Query editor
WITH top_10_variants AS (-- Get the same top 10 variants from previous querySELECTCASEWHEN token_bought_symbol LIKE '%BTC%' AND token_bought_symbol != 'BTC' THEN token_bought_symbolWHEN token_sold_symbol LIKE '%BTC%' AND token_sold_symbol != 'BTC' THEN token_sold_symbolEND as variant_name,SUM(amount_usd) as total_volume_30dFROM dex.tradesWHERE(token_bought_symbol LIKE '%BTC%' OR token_sold_symbol LIKE '%BTC%')AND token_bought_symbol != 'BTC' AND token_sold_symbol != 'BTC'AND LENGTH(COALESCE(token_bought_symbol, token_sold_symbol)) <= 10AND COALESCE(token_bought_symbol, token_sold_symbol) NOT LIKE '%/%'AND COALESCE(token_bought_symbol, token_sold_symbol) NOT LIKE '% %'AND block_time >= NOW() - INTERVAL '30' dayGROUP BY 1ORDER BY total_volume_30d DESCLIMIT 10),-- Get unique wallet holders for each variant (last 30 days activity)wallet_activity AS (SELECTCASEWHEN token_bought_symbol IN (SELECT variant_name FROM top_10_variants) THEN token_bought_symbolWHEN token_sold_symbol IN (SELECT variant_name FROM top_10_variants) THEN token_sold_symbolEND as variant_name,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 (SELECT variant_name FROM top_10_variants)OR token_sold_symbol IN (SELECT variant_name FROM top_10_variants))AND block_time >= NOW() - INTERVAL '30' dayGROUP BY 1, 2),-- Categorize wallets by trading volumewallet_categories AS (SELECTvariant_name,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 >= 100 THEN 'Very Active (100+ trades)'WHEN total_trades >= 20 THEN 'Active (20-99 trades)'WHEN total_trades >= 5 THEN 'Moderate (5-19 trades)'ELSE 'Light (1-4 trades)'