Query editor
WITH eth_volume AS (SELECTDATE_TRUNC('month', block_time) AS month,'ethereum' AS chain,SUM(CAST(amount_usd AS DOUBLE)) AS usd_volumeFROMdex."trades" AS tWHEREblock_time > CAST('2023-01-01' AS TIMESTAMP)GROUP BY1,2),solana_volume AS (SELECTdate_trunc('month',block_time) AS month,'solana' AS chain,sum(amount_usd) AS usd_volumeFROM dex_solana.trades spWHEREblock_time > CAST('2023-01-01' AS TIMESTAMP)GROUP BY 1,2)SELECTmonth,chain,usd_volumeFROM solana_volumeUNION ALLSELECTmonth,chain,usd_volumeFROM eth_volume