Query editor
SELECTCASEWHEN token_sold_symbol < token_bought_symbolTHEN CONCAT(token_sold_symbol, '/', token_bought_symbol)ELSE CONCAT(token_bought_symbol, '/', token_sold_symbol)END AS pair,SUM(amount_usd) AS volume,COUNT(*) AS trades,CASEWHEN SUM(amount_usd) > 100000000 THEN '🟢 HIGH LIQUIDITY'WHEN SUM(amount_usd) > 20000000 THEN '🟡 MID LIQUIDITY'ELSE '🔴 LOW LIQUIDITY'ENDFROM dex.tradesWHERE block_time >= now() - interval '7' dayAND project = 'uniswap'GROUP BY 1ORDER BY volume DESCLIMIT 20