Query editor
-- Enhanced RWA Wallet Tracker (High Purity & Coverage, Dune SQL Compliant)WITHhigh_value_wallets AS (SELECT to_hex("from") as wallet_address, 'high_value' as sourceFROM ethereum.transactionsWHERE value > 1000000000000000000 -- 1 ETH 이상AND block_time >= now() - interval '90' dayGROUP BY 1HAVING COUNT(*) > 15 -- threshold 강화 for purityLIMIT 1000),defi_wallets AS (SELECT to_hex("from") as wallet_address, 'defi_active' as sourceFROM ethereum.transactionsWHERE block_time >= now() - interval '90' dayGROUP BY 1HAVING COUNT(DISTINCT "to") > 10 AND COUNT(*) > 30 -- threshold 강화LIMIT 1000),contract_creators AS (SELECT to_hex("from") as wallet_address, 'contract_creator' as sourceFROM ethereum.transactionsWHERE "to" IS NULL -- 컨트랙트 생성AND block_time >= now() - interval '90' dayGROUP BY 1HAVING COUNT(*) > 2LIMIT 500),rwa_token_traders AS (SELECT to_hex("from") as wallet_address, 'rwa_trader' as sourceFROM erc20_ethereum.evt_TransferWHERE contract_address IN (-- Top RWA tokens on Ethereum (Sep 2025 기준: Ondo, Centrifuge, Pax Gold, BlackRock BUIDL, VanEck VBILL)X'faba6f8e4a5e8ab82f62fe7c39859fa577269be3', -- ONDOX'cccccccccc33d538dbc2ee4feab0a7a1ff4e8a94', -- CFG (new Ethereum native)X'45804880de22913dafe09f4980848ece6ecbaf78', -- PAXGX'7712c34205737192402172409a8f7ccef8aa2aec', -- BUIDLX'2255718832bc9fd3be1caf75084f4803da14ff01' -- VBILL)AND evt_block_time >= now() - interval '90' dayAND value > 0 -- 실제 전송만GROUP BY 1HAVING COUNT(*) > 10 -- RWA 거래 10회 이상 for high purityLIMIT 1000),all_wallets AS (SELECT wallet_address, source FROM high_value_walletsUNION ALLSELECT wallet_address, source FROM defi_walletsUNION ALLSELECT wallet_address, source FROM contract_creatorsUNION ALLSELECT wallet_address, source FROM rwa_token_traders)SELECTwallet_address,COUNT(DISTINCT source) as source_count,array_join(array_agg(DISTINCT source), ', ') as sources, -- 소스 목록 추가 for analysis (Trino compatible)CONCAT('https://etherscan.io/address/0x', wallet_address) as etherscan_linkFROM all_wallets