Query editor
WITH evm AS (SELECT block_time, CAST(block_date AS DATE) AS bd, blockchain, amount_usd,CAST("user" AS VARCHAR) AS usrFROM 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'),sol AS (SELECT block_time, block_date AS bd, blockchain, amount_usd, "user" AS usrFROM dex_solana.bot_tradesWHERE block_date >= DATE '2025-01-01'AND block_date < DATE '2026-03-23'AND block_month >= DATE '2025-01-01'),combined AS (SELECT * FROM evmUNION ALLSELECT * FROM sol)SELECTDATE_TRUNC('month', block_time) AS month,ROUND(SUM(CASE WHEN blockchain = 'solana' THEN amount_usd ELSE 0 END) / 1e9, 3) AS solana_vol,ROUND(SUM(CASE WHEN blockchain = 'ethereum' THEN amount_usd ELSE 0 END) / 1e9, 3) AS ethereum_vol,ROUND(SUM(CASE WHEN blockchain = 'base' THEN amount_usd ELSE 0 END) / 1e9, 3) AS base_vol,ROUND(SUM(amount_usd) / 1e9, 3) AS total_vol,ROUND(COUNT(*) / 1e6, 2) AS total_trades_m,ROUND(SUM(CASE WHEN blockchain = 'solana' THEN 1 ELSE 0 END) / 1e6, 2) AS solana_trades_m,ROUND(SUM(CASE WHEN blockchain = 'ethereum' THEN 1 ELSE 0 END) / 1e6, 2) AS ethereum_trades_m,ROUND(SUM(CASE WHEN blockchain = 'base' THEN 1 ELSE 0 END) / 1e6, 2) AS base_trades_m,COUNT(DISTINCT usr) / 1e3 AS unique_users_k,COUNT(DISTINCT CASE WHEN blockchain = 'solana' THEN usr END) / 1e3 AS solana_users_k,COUNT(DISTINCT CASE WHEN blockchain = 'ethereum' THEN usr END) / 1e3 AS ethereum_users_k,COUNT(DISTINCT CASE WHEN blockchain = 'base' THEN usr END) / 1e3 AS base_users_kFROM combinedGROUP BY 1ORDER BY 1