Query editor
-- 3번 쿼리: 주요 플레이어 식별 및 프로토콜 주소WITH major_players AS (SELECT"from" as wallet_address,COUNT(*) as tx_count,SUM(value / 1e18) as total_volume_eth,AVG(value / 1e18) as avg_tx_size_eth,MAX(value / 1e18) as max_tx_size_eth,MIN(block_time) as first_tx,MAX(block_time) as last_txFROM ethereum.transactionsWHERE block_time >= now() - interval '7' dayAND value / 1e18 >= 10 -- 10 ETH 이상 거래AND success = trueGROUP BY "from"HAVING COUNT(*) >= 3 -- 최소 3번 이상 거래),player_ranking AS (SELECTwallet_address,tx_count,ROUND(total_volume_eth, 2) as total_volume_eth,ROUND(avg_tx_size_eth, 2) as avg_tx_size_eth,ROUND(max_tx_size_eth, 2) as max_tx_size_eth,first_tx,last_tx,ROW_NUMBER() OVER (ORDER BY total_volume_eth DESC) as volume_rank,ROW_NUMBER() OVER (ORDER BY tx_count DESC) as activity_rankFROM major_players)SELECTwallet_address,volume_rank,activity_rank,tx_count,total_volume_eth,avg_tx_size_eth,max_tx_size_eth,first_tx,last_tx,CASEWHEN volume_rank <= 10 THEN 'Top 10 by Volume'WHEN volume_rank <= 50 THEN 'Top 50 by Volume'WHEN activity_rank <= 10 THEN 'Top 10 by Activity'ELSE 'Other'END as player_categoryFROM player_rankingORDER BY total_volume_eth DESCLIMIT 100;