Query editor
WITH evm_daily AS (SELECT block_date,CASE WHEN project LIKE 'uniswap%' THEN 'Uniswap' WHEN project LIKE 'curve%' THEN 'Curve' WHEN project = 'aerodrome' THEN 'Aerodrome' END AS protocol,SUM(amount_usd) AS volume_usdFROM dex.tradesWHERE block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND (project LIKE 'uniswap%' OR project LIKE 'curve%' OR project = 'aerodrome')AND amount_usd IS NOT NULL AND amount_usd > 0 AND amount_usd < 1e10GROUP BY 1, 2),solana_daily AS (SELECT block_date, 'Jupiter' AS protocol, SUM(amount_usd) AS volume_usdFROM dex_solana.tradesWHERE block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND project = 'jupiter'AND amount_usd IS NOT NULL AND amount_usd > 0 AND amount_usd < 1e10GROUP BY 1, 2),combined AS (SELECT * FROM evm_daily UNION ALL SELECT * FROM solana_daily)SELECT block_date,SUM(CASE WHEN protocol = 'Uniswap' THEN volume_usd ELSE 0 END) AS uniswap_volume,SUM(CASE WHEN protocol = 'Curve' THEN volume_usd ELSE 0 END) AS curve_volume,SUM(CASE WHEN protocol = 'Aerodrome' THEN volume_usd ELSE 0 END) AS aerodrome_volume,SUM(CASE WHEN protocol = 'Jupiter' THEN volume_usd ELSE 0 END) AS jupiter_volumeFROM combined GROUP BY 1 ORDER BY 1