Query editor
WITH solana_dexs AS (SELECTDATE_TRUNC('day', block_time) AS date,SUM(amount_usd) AS volume,COUNT(DISTINCT trader_id) AS user_count,COUNT(*) AS transactions,'solana' AS chainFROM dex_solana.tradesWHEREblock_time >= CURRENT_DATE - INTERVAL '1' monthGROUP BY1ORDER BY1), evm_trades AS (SELECTblock_date AS date,SUM(amount_usd) AS volume,COUNT(DISTINCT tx_from) AS user_count,COUNT(*) AS transactions,blockchain AS chainFROM dex.tradesWHEREblock_date >= CURRENT_DATE - INTERVAL '1' monthGROUP BY1,5ORDER BY1)SELECT*FROM solana_dexsUNION ALLSELECT*FROM evm_tradesORDER BYdate DESC