with all_users as ( SELECT block_timestamp, from_address as address, COALESCE(label,to_address) as interacted_with, COALESCE(label_type,'NA') as interacted_with_type FROM ethereum.core.fact_transactions LEFT JOIN (SELECT * FROM ethereum.core.dim_labels) f ON to_address = address WHERE status = 'SUCCESS' and DATE(block_timestamp) < '2023-01-01' and DATE(block_timestamp) >= '2022-01-01' UNION ALL SELECT block_timestamp, to_address as address, COALESCE(label,from_address) as interacted_with, COALESCE(label_type,'NA') as interacted_with_type FROM ethereum.core.fact_transactions LEFT JOIN (SELECT * FROM ethereum.core.dim_labels) f ON from_address = address WHERE status = 'SUCCESS' and DATE(block_timestamp) < '2023-01-01' and DATE(block_timestamp) >= '2022-01-01' ), total_wallets as (SELECT COUNT(DISTINCT(address)) as all_wallets, 1 as key_join FROM all_users), total_minters as ( SELECT 'Minted NFT' as action_type, COUNT(DISTINCT(nft_to_address)) as total_wallets FROM ethereum.core.ez_nft_mints WHERE DATE(block_timestamp) >= '2022-01-01' and DATE(block_timestamp) < '2023-01-01' UNION ALL SELECT 'Bought an NFT' as action_type, COUNT(DISTINCT(buyer_address)) as total_wallets FROM ethereum.core.ez_nft_sales WHERE DATE(block_timestamp) >= '2022-01-01' and DATE(block_timestamp) < '2023-01-01' UNION ALL SELECT 'Sold an NFT' as action_type, COUNT(DISTINCT(seller_address)) as total_wallets FROM ethereum.core.ez_nft_sales WHERE DATE(block_timestamp) >= '2022-01-01' and DATE(block_timestamp) < '2023-01-01' UNION ALL SELECT 'Bought an NFT on Opensea' as action_type, COUNT(DISTINCT(buyer_address)) as total_wallets FROM ethereum.core.ez_nft_sales WHERE DATE(block_timestamp) >= '2022-01-01' and DATE(block_timestamp) < '2023-01-01' and platform_name = 'opensea' UNION ALL SELECT 'Swapped on Uniswap' as action_type, COUNT(DISTINCT(origin_from_address)) as total_wallets FROM ethereum.core.ez_dex_swaps WHERE platform in ('uniswap-v2','uniswap-v3') and DATE(block_timestamp) >= '2022-01-1' and DATE(block_timestamp) < '2023-01-01' UNION ALL SELECT 'Swapped on Sushiswap' as action_type, COUNT(DISTINCT(origin_from_address)) as total_wallets FROM ethereum.sushi.ez_swaps WHERE DATE(block_timestamp) >= '2022-01-1' and DATE(block_timestamp) < '2023-01-01' UNION ALL SELECT 'Deposited on AAVE' as action_type, COUNT(DISTINCT(depositor_address)) as total_wallets FROM ethereum.aave.ez_deposits WHERE DATE(block_timestamp) >= '2022-01-1' and DATE(block_timestamp) < '2023-01-01' UNION ALL SELECT 'Voted for Governance via Snapshot' as action_type, COUNT(DISTINCT(voter)) as total_wallets FROM ethereum.core.ez_snapshot WHERE DATE(proposal_start_time) >= '2022-01-1' and DATE(proposal_start_time) < '2023-01-01' UNION ALL SELECT 'Interacted with FTX' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with = 'ftx' UNION ALL SELECT 'Interacted with Central Exchange' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with_type = 'cex' UNION ALL SELECT 'Interacted with a Layer 2' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with_type = 'layer2' UNION ALL SELECT 'Interacted with DeFi' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with_type in ( 'defi','dex') UNION ALL SELECT 'Interacted with DeFi Outside of DEX' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with_type = 'defi' UNION ALL SELECT 'Interacted with Coinbase' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with = 'coinbase' UNION ALL SELECT 'Interacted with Binance' as action_type, COUNT(DISTINCT(address)) as total_wallets FROM all_users WHERE interacted_with = 'binance' ) SELECT action_type, total_wallets, total_wallets / all_wallets * 100 as percent_of_active_eth_wallets FROM total_minters LEFT JOIN total_wallets on key_join = 1 ORDER BY total_wallets DESC

Ethereum Wrapped 2022: A Year in Review