Query editor
-- =====================================================================-- DEBLOCK CURRENT VALUES: latest TVL + lifetime fees/volume per Deblock vault-- =====================================================================-- Thin wrapper over Vault Metrics Daily (8092271), filtered to Deblock.-- Mirrors Near Current Values (8585880) / Bennu Current Values (8302870).-- lifetime_fees_usd = cumulative minted performance/management fees (USD).-- =====================================================================WITH m AS (SELECT * FROM query_8092271WHERE client = 'Deblock')SELECTreport_name,vault_name,blockchain,und_symbol,vault_address,vault_shares,tvl_underlying,tvl_usd,underlying_usd_price,pps_as_of AS last_pps_day,fees_usd_cumulative AS lifetime_fees_usd,volume_usd_cumulative AS lifetime_volume_usd,SUM(tvl_usd) OVER () AS total_tvl_usd,SUM(fees_usd_cumulative) OVER () AS total_lifetime_fees_usd,SUM(volume_usd_cumulative) OVER () AS total_lifetime_volume_usdFROM mWHERE day = (SELECT MAX(day) FROM m)ORDER BY lifetime_fees_usd DESC NULLS LAST, tvl_usd DESC