Query editor
SELECTblockchain AS blockchain,SUM(cast(amount_usd AS DOUBLE)) AS usd_volumeFROM dex.tradesWHERE block_time >= cast ('2024-03-01' AS TIMESTAMP)GROUP BY blockchainUNIONSELECT'solana' AS blockchain,SUM(cast(amount_usd AS DOUBLE)) AS usd_volumeFROM dex_solana.tradesWHERE block_time >= cast ('2024-03-01' AS TIMESTAMP)GROUP BY blockchain