Query editor
-- Comprehensive_Wallet_CollectionWITH high_value_wallets AS (SELECT "from" as wallet_address, 'high_value' as sourceFROM ethereum.transactionsWHERE value > 1000000000000000000AND block_time >= now() - interval '90' dayGROUP BY "from"HAVING COUNT(*) > 10LIMIT 500),defi_wallets AS (SELECT "from" as wallet_address, 'defi_active' as sourceFROM ethereum.transactionsWHERE block_time >= now() - interval '90' dayGROUP BY "from"HAVING COUNT(DISTINCT "to") > 5 AND COUNT(*) > 20LIMIT 500),contract_creators AS (SELECT "from" as wallet_address, 'contract_creator' as sourceFROM ethereum.transactionsWHERE "to" IS NULLAND block_time >= now() - interval '90' dayGROUP BY "from"HAVING COUNT(*) > 1LIMIT 200),all_wallets AS (SELECT wallet_address, source FROM high_value_walletsUNION ALLSELECT wallet_address, source FROM defi_walletsUNION ALLSELECT wallet_address, source FROM contract_creators)SELECTwallet_address,COUNT(DISTINCT source) as source_count,CONCAT('https://etherscan.io/address/', CAST(wallet_address AS VARCHAR)) as etherscan_linkFROM all_walletsGROUP BY wallet_addressORDER BY source_count DESC, wallet_address