Query editor
WITH combined AS (SELECT block_time, CAST(block_date AS DATE) AS bd, 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 block_time, block_date AS bd, 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')SELECTSUM(CASE WHEN YEAR(block_time) = 2025 THEN amount_usd END) / 1e9 AS total_vol_2025_b,SUM(CASE WHEN YEAR(block_time) = 2026 THEN amount_usd END) / 1e9 AS total_vol_2026_ytd_b,COUNT(CASE WHEN YEAR(block_time) = 2025 THEN 1 END) / 1e6 AS total_trades_2025_m,COUNT(CASE WHEN YEAR(block_time) = 2026 THEN 1 END) / 1e6 AS total_trades_2026_ytd_m,ROUND((SUM(CASE WHEN YEAR(block_time) = 2026 THEN amount_usd END) /NULLIF(SUM(CASE WHEN YEAR(block_time) = 2025 THEN amount_usd END), 0)) * 100, 1) AS ytd_pct_of_2025FROM combined