Query editor
WITH combined AS (SELECT bot, 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 bot, 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')SELECTbot,blockchain,SUM(amount_usd) / 1e9 AS total_volume_b,COUNT(*) / 1e6 AS total_trades_m,ROUND(SUM(amount_usd) * 100.0 /SUM(SUM(amount_usd)) OVER (), 2) AS volume_share_pctFROM combinedGROUP BY 1, 2ORDER BY 3 DESCLIMIT 15