Query editor
SELECTROW_NUMBER() OVER (ORDER BY SUM(amount_usd) DESC) AS rank,CASEWHEN 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(SUM(amount_usd) / COUNT(*), 2) AS avg_trade_size,ROUND(SUM(amount_usd) / NULLIF(SUM(amount_usd) / COUNT(*),0),2) AS lp_score,CASEWHEN SUM(amount_usd) > 100000000AND COUNT(*) > 10000THEN '🟢 STRONG'WHEN SUM(amount_usd) > 20000000THEN '🟡 MID'ELSE '🔴 WEAK'END AS qualityFROM dex.tradesWHERE block_time >= now() - interval '7' dayAND project = 'uniswap'GROUP BY 2HAVING COUNT(*) > 100ORDER BY volume_usd DESCLIMIT 20