Query editor
WITH high_volume_traders AS (SELECT DISTINCT taker AS traderFROM dex.tradesWHERE block_time >= date_trunc('day', NOW()) - interval '90' dayGROUP BY takerHAVING SUM(amount_usd) >= 2000),pair_volumes AS (SELECTtoken_pair AS trading_pair,COUNT(*) AS trade_count,SUM(amount_usd) AS total_volume_usdFROM dex.tradesWHERE taker IN (SELECT trader FROM high_volume_traders)AND block_time >= date_trunc('day', NOW()) - interval '90' dayGROUP BY 1)SELECT trading_pair AS item, trade_count, total_volume_usdFROM pair_volumesORDER BY total_volume_usd DESCLIMIT 10