Query editor
with trades as (select block_date, a.blockchain, amount_usdfrom dex.trades aleft join query_5343342 b on a.token_bought_address = b.token_addressleft join query_5343342 c on a.token_bought_address = c.token_addresswhere block_month >= DATE('2025-01-01')and COALESCE(b.token_address, c.token_address) is not nulland amount_usd > 0UNION ALL-- Only xStocksselect block_date, a.blockchain, amount_usdfrom dex_solana.trades aleft join query_5373882 b on a.token_bought_mint_address = b.solana_addressleft join query_5373882 c on a.token_sold_mint_address = c.solana_addresswhere block_month >= DATE('2025-06-01')and COALESCE(b.solana_address, c.solana_address) is not null)select block_date, blockchain,sum(amount_usd) as trading_volumefrom tradesgroup by 1,2order by 1 desc, trading_volume