Query editor
WITH norm AS (SELECTblockchain,LEAST(token_sold_address, token_bought_address) AS pair_from,GREATEST(token_sold_address, token_bought_address) AS pair_to,CASE WHEN token_sold_address < token_bought_addressTHEN token_sold_symbol ELSE token_bought_symbol END AS sym_from,CASE WHEN token_sold_address < token_bought_addressTHEN token_bought_symbol ELSE token_sold_symbol END AS sym_to,amount_usd,takerFROM dex.tradesWHERE block_time >= CURRENT_DATE - INTERVAL '7' DAYAND block_date >= CURRENT_DATE - INTERVAL '7' DAYAND blockchain = 'ethereum'AND amount_usd > 0AND token_sold_address <> 0x0000000000000000000000000000000000000000AND token_bought_address <> 0x0000000000000000000000000000000000000000)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 taker) >= 10ORDER BY weekly_volume_usd DESCLIMIT 1000;