Query editor
WITH norm AS (SELECTblockchain,LEAST(token_sold_mint_address, token_bought_mint_address) AS pair_from,GREATEST(token_sold_mint_address, token_bought_mint_address) AS pair_to,CASE WHEN token_sold_mint_address < token_bought_mint_addressTHEN token_sold_symbol ELSE token_bought_symbol END AS sym_from,CASE WHEN token_sold_mint_address < token_bought_mint_addressTHEN token_bought_symbol ELSE token_sold_symbol END AS sym_to,amount_usd,trader_idFROM dex_solana.tradesWHERE block_time >= CURRENT_DATE - INTERVAL '7' DAYAND block_date >= CURRENT_DATE - INTERVAL '7' DAYAND blockchain = 'solana'AND amount_usd > 0AND token_sold_mint_address <> '11111111111111111111111111111111'AND token_bought_mint_address <> '11111111111111111111111111111111')SELECTblockchain,pair_from,pair_to,MAX(sym_from) AS sym_from,MAX(sym_to) AS sym_to,SUM(amount_usd) AS weekly_volume_usdFROM normGROUP BY blockchain, pair_from, pair_toHAVING COUNT(DISTINCT trader_id) >= 10ORDER BY weekly_volume_usd DESCLIMIT 1000;