Query editor
WITH high_whale_days AS (SELECTblock_date AS day,SUM(amount_usd) AS whale_usdFROM tokens.transfersWHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '180' DAYAND amount > 100GROUP BY 1ORDER BY whale_usd DESCLIMIT 10),destination_swaps AS (SELECTdt.token_bought_symbol,ROUND(SUM(dt.amount_usd), 0) AS swap_volume_usd,COUNT(DISTINCT dt.tx_hash) AS swap_count,ROUND(SUM(dt.amount_usd) / COUNT(DISTINCT dt.tx_hash), 0) AS avg_swap_usdFROM dex.trades dtINNER JOIN high_whale_days wON dt.block_date BETWEEN w.day AND w.day + INTERVAL '2' DAYWHERE dt.token_sold_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND dt.blockchain = 'ethereum'AND dt.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '180' DAY)GROUP BY 1)SELECTtoken_bought_symbol AS destination_token,swap_volume_usd,swap_count,avg_swap_usd,ROUND(swap_volume_usd / SUM(swap_volume_usd) OVER () * 100, 2) AS pct_of_totalFROM destination_swapsWHERE token_bought_symbol IS NOT NULLAND REGEXP_LIKE(token_bought_symbol, '^[A-Za-z0-9._-]+$') -- non-ASCII 심볼 제거 (7AΩ∞, The Glitch 등)AND swap_count >= 500 -- 건수 극소(< 500) 아티팩트 제거AND avg_swap_usd < 1000000 -- 건당 평균 $1M 초과 이상 거래 제거ORDER BY swap_volume_usd DESCLIMIT 15