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,ROUND(SUM(amount_usd), 2) AS volume_usd,COUNT(*) AS trades,ROUND(AVG(amount_usd), 2) AS avg_trade_size,ROUND(SUM(amount_usd) / NULLIF(COUNT(*), 0),2) AS efficiency_score,CASEWHEN COUNT(*) > 20000AND SUM(amount_usd) > 100000000THEN '🟢 ACTIVE'WHEN COUNT(*) > 5000THEN '🟡 MID'ELSE '🔴 WEAK'END AS lp_strengthFROM dex.tradesWHERE block_time >= now() - interval '7' dayAND project = 'uniswap'GROUP BY 1HAVING SUM(amount_usd) > 1000000ORDER BY volume_usd DESCLIMIT 20