Query editor
WITH top_10_pairs AS (SELECTCASEWHEN token_bought_symbol = 'BTC' THEN CONCAT(token_sold_symbol, '-BTC')WHEN token_sold_symbol = 'BTC' THEN CONCAT(token_bought_symbol, '-BTC')WHEN token_bought_symbol = 'WBTC' THEN CONCAT(token_sold_symbol, '-WBTC')WHEN token_sold_symbol = 'WBTC' THEN CONCAT(token_bought_symbol, '-WBTC')END as trading_pair,SUM(amount_usd) as total_volume_30dFROM dex.tradesWHERE(token_bought_symbol IN ('BTC', 'WBTC') OR token_sold_symbol IN ('BTC', 'WBTC'))AND block_time >= NOW() - INTERVAL '30' dayAND token_bought_symbol != token_sold_symbolAND token_bought_symbol IS NOT NULL AND token_sold_symbol IS NOT NULLGROUP BY 1ORDER BY total_volume_30d DESCLIMIT 10),wallet_activity AS (SELECTCASEWHEN token_bought_symbol = 'BTC' THEN CONCAT(token_sold_symbol, '-BTC')WHEN token_sold_symbol = 'BTC' THEN CONCAT(token_bought_symbol, '-BTC')WHEN token_bought_symbol = 'WBTC' THEN CONCAT(token_sold_symbol, '-WBTC')WHEN token_sold_symbol = 'WBTC' THEN CONCAT(token_bought_symbol, '-WBTC')END as trading_pair,taker as wallet_address,SUM(amount_usd) as total_volume_usd,COUNT(*) as total_trades,MAX(block_time) as last_activity,MIN(block_time) as first_activityFROM dex.tradesWHERE(token_bought_symbol IN ('BTC', 'WBTC') OR token_sold_symbol IN ('BTC', 'WBTC'))AND block_time >= NOW() - INTERVAL '30' dayAND token_bought_symbol != token_sold_symbolAND token_bought_symbol IS NOT NULL AND token_sold_symbol IS NOT NULLGROUP BY 1, 2),wallet_categories AS (SELECTtrading_pair,wallet_address,total_volume_usd,total_trades,CASEWHEN total_volume_usd >= 1000000 THEN 'Whale (>$1M)'WHEN total_volume_usd >= 100000 THEN 'Large ($100K-$1M)'WHEN total_volume_usd >= 10000 THEN 'Medium ($10K-$100K)'WHEN total_volume_usd >= 1000 THEN 'Small ($1K-$10K)'ELSE 'Micro (<$1K)'END as wallet_category,CASEWHEN total_trades >= 50 THEN 'Very Active (50+ trades)'WHEN total_trades >= 10 THEN 'Active (10-49 trades)'WHEN total_trades >= 3 THEN 'Moderate (3-9 trades)'ELSE 'Light (1-2 trades)'