Query editor
WITH stable_pairs AS (SELECTCASEWHEN token_bought_symbol < token_sold_symbolTHEN CONCAT(token_bought_symbol, '/', token_sold_symbol)ELSE CONCAT(token_sold_symbol, '/', token_bought_symbol)END AS normalized_pair,amount_usdFROM dex.tradesWHERE blockchain = 'mantle'AND block_time > NOW() - INTERVAL '30' dayAND (token_bought_symbol IN ('USDC','USDT')OR token_sold_symbol IN ('USDC','USDT')))SELECTnormalized_pair,SUM(amount_usd) AS volume_usdFROM stable_pairsGROUP BY 1ORDER BY volume_usd DESCLIMIT 20;