Query editor
WITH daily AS (SELECTproject,CAST(block_time AS DATE) AS day,SUM(CAST(amount_usd AS DOUBLE)) AS volume_usdFROM dex_solana.tradesWHERE block_time >= NOW() - INTERVAL '30' DAYAND block_time < NOW()AND amount_usd IS NOT NULLGROUP BY project, CAST(block_time AS DATE))SELECTproject,SUM(CASE WHEN day >= CURRENT_DATE - INTERVAL '1' DAY THEN volume_usd ELSE 0 END) AS volume_24h,SUM(CASE WHEN day >= CURRENT_DATE - INTERVAL '7' DAY THEN volume_usd ELSE 0 END) AS volume_7d,SUM(volume_usd) AS volume_30dFROM dailyGROUP BY projectORDER BY volume_24h DESCLIMIT 50