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.tradeswhere block_time >= cast('2023-01-01' as date)group by 1order by 1 ),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.tradeswhere block_date >= cast('2023-01-01' as date)group by 1,5order by 1)SELECT *FROM solana_dexsUNION ALLSELECT *FROM evm_tradesORDER BY date desc