Query editor
SELECTproject AS competitor,trader_id AS trader,'solana' AS chain,token_sold_symbol,token_bought_symbol,COUNT(*) AS tx_count,ROUND(SUM(amount_usd), 2) AS vol_usd,ROUND(MAX(amount_usd), 2) AS max_tx_usd,ARBITRARY(tx_id) AS sample_txFROM dex_solana.tradesWHERE block_month = CAST(DATE_TRUNC('month', DATE '2026-06-17') AS DATE)AND block_date = DATE '2026-06-17'AND amount_usd IS NOT NULLAND amount_usd >= 1000.0AND trader_id IS NOT NULLAND (UPPER(token_sold_symbol) IN ('AGGON','AUX','BENJI','BINCON','BRK.BX','BUIDL','CETES','CFG','CGO','CPOOL','DGX','EMRLD','FOBXX','GFI','GLDON','GLDT','GLDX','GLINT','GLTRON','GOLDAO','GRAMS','HYGON','IAUON','IEFAON','IEFON','JAAA','JAAAON','JTRSY','KAG','KAU','MPL','NBASIS','OM','ONDO','OUSG','PALLON','PALLX','PAXG','PENDLE','PMGT','POLYX','PPLTON','PROPS','QGOLD','RSR','SGOVON','SHYON','SHYX','SLVON','SLVX','STBT','SYRUP','TBILL','TCU29','TIPON','TLTON','TLTX','TRADE','TRU','TXAU','UGOLD','USCC','USDM','USDY','USFRON','USTB','USTBL','USYC','VNXAU','VPR','VRO','WTSYX','XAGX','XAUM','XAUT','XAUT0','XNK') OR UPPER(token_bought_symbol) IN ('AGGON','AUX','BENJI','BINCON','BRK.BX','BUIDL','CETES','CFG','CGO','CPOOL','DGX','EMRLD','FOBXX','GFI','GLDON','GLDT','GLDX','GLINT','GLTRON','GOLDAO','GRAMS','HYGON','IAUON','IEFAON','IEFON','JAAA','JAAAON','JTRSY','KAG','KAU','MPL','NBASIS','OM','ONDO','OUSG','PALLON','PALLX','PAXG','PENDLE','PMGT','POLYX','PPLTON','PROPS','QGOLD','RSR','SGOVON','SHYON','SHYX','SLVON','SLVX','STBT','SYRUP','TBILL','TCU29','TIPON','TLTON','TLTX','TRADE','TRU','TXAU','UGOLD','USCC','USDM','USDY','USFRON','USTB','USTBL','USYC','VNXAU','VPR','VRO','WTSYX','XAGX','XAUM','XAUT','XAUT0','XNK') OR (regexp_like(token_sold_symbol, '^[A-Z]{1,6}(on|x)$') AND UPPER(token_sold_symbol) NOT IN ('BNBX','DFDVX','ETHX','MNTX','PUMPX','SOLRX','USDX')) OR (regexp_like(token_bought_symbol, '^[A-Z]{1,6}(on|x)$') AND UPPER(token_bought_symbol) NOT IN ('BNBX','DFDVX','ETHX','MNTX','PUMPX','SOLRX','USDX')))GROUP BY 1, 2, 3, 4, 5ORDER BY vol_usd DESC