Query editor
SELECTproject AS competitor,'0x' || lower(to_hex(taker)) AS trader,blockchain 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_hash) AS sample_txFROM dex_aggregator.tradesWHERE block_time >= from_unixtime(1781654400)AND block_time < from_unixtime(1781740800)AND amount_usd IS NOT NULLAND amount_usd >= 1000.0AND taker 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