Query editor
with trades as (select block_date, a.blockchain, amount_usd,COALESCE(b.project, c.project) as protocolfrom 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 regexp_like(token_pair, 'COIN|TSLA|NVDA|GOOGL|MSFT|MSTR')and COALESCE(b.token_address, c.token_address) is not nulland amount_usd > 0UNION ALL-- Only xStocksselect block_date, a.blockchain, amount_usd,'xStocks' as protocolfrom 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 nulland amount_usd > 0)select block_date, protocol,sum(amount_usd) as trading_volumefrom tradesgroup by 1,2order by 1 desc, trading_volume desc