Query editor
WITH combined AS (SELECT blockchain, amount_usdFROM dex_evm.bot_tradesWHERE CAST(block_date AS DATE) >= DATE '2025-01-01'AND CAST(block_date AS DATE) < DATE '2026-03-23'AND CAST(block_month AS DATE) >= DATE '2025-01-01'UNION ALLSELECT blockchain, amount_usdFROM dex_solana.bot_tradesWHERE block_date >= DATE '2025-01-01'AND block_date < DATE '2026-03-23'AND block_month >= DATE '2025-01-01')SELECTUPPER(blockchain) AS chain,SUM(amount_usd) / 1e9 AS volume_bFROM combinedGROUP BY 1ORDER BY 2 DESC