Query editor
WITH total AS (SELECTtime,SUM(daily_usd_volume) AS total_volume,SUM(open_interest) AS total_oiFROM dune.yandhii.dataset_hyperliquid_daily_metricsGROUP BY 1),hip3 AS (SELECTtime,SUM(daily_usd_volume) AS hip3_volume,SUM(open_interest) AS hip3_oiFROM dune.yandhii.dataset_hyperliquid_daily_metricsWHERE REGEXP_LIKE(coin, '^(xyz|flx|vntl|hyna|km|cash)')GROUP BY 1)SELECTt.time,t.total_volume,COALESCE(h.hip3_volume, 0) AS hip3_volume,t.total_volume - COALESCE(h.hip3_volume, 0) AS standard_volume,ROUND(COALESCE(h.hip3_volume, 0) / t.total_volume * 100, 2) AS hip3_pct,t.total_oi,COALESCE(h.hip3_oi, 0) AS hip3_oiFROM total tLEFT JOIN hip3 h ON t.time = h.timeORDER BY t.time DESC