with ethereum_ez_token_transfers as ( select block_number , block_timestamp , tx_hash , from_address , to_address , contract_address , name , symbol , decimals , amount , amount_usd , origin_function_signature , origin_from_address , origin_to_address from ethereum.core.ez_token_transfers where block_number >= 10875578 and block_number <= 22480921 ), arbitrum_ez_token_transfers as ( select block_number , block_timestamp , tx_hash , from_address , to_address , contract_address , name , symbol , decimals , amount , amount_usd , origin_function_signature , origin_from_address , origin_to_address from arbitrum.core.ez_token_transfers where block_number >= 72829612 and block_number <= 134320927 ), optimism_ez_token_transfers as ( select block_number , block_timestamp , tx_hash , from_address , to_address , contract_address , name , symbol , decimals , amount , amount_usd , origin_function_signature , origin_from_address , origin_to_address from optimism.core.ez_token_transfers ), base_ez_token_transfers as ( select block_number , block_timestamp , tx_hash , from_address , to_address , contract_address , name , symbol , decimals , amount , amount_usd , origin_function_signature , origin_from_address , origin_to_address from base.core.ez_token_transfers ), ethereum_drops as ( select to_address as user_address, 'Ethereum' as chain, 'Arkham' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x08c7676680f187a31241e83e6d44c03a98adab05') and block_number >= 17718694 and block_number <= 21808832 and contract_address = lower('0x6e2a43be0b1d33b726f0ca3b8de60b3482b8b050') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Uniswap' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x090d4613473dee047c3f2706764f49e0821d256e') and block_number >= 10875578 and block_number <= 22476502 and contract_address = lower('0x1f9840a85d5af5bf1d1762f925bdaddc4201f984') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Paraswap' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x090e53c44e8a9b6b1bca800e881455b921aec420') and block_number >= 13620174 and block_number <= 22473657 and contract_address = lower('0xcafe001067cdef266afb7eb5a286dcfd277f3de5') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Dydx' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x0fd829c3365a225fb9226e75c97c3a114bd3199e') and block_number >= 13183164 and block_number <= 22450687 and contract_address = lower('0x92d6c1e31e14520e676a687f0a93788b716beff5') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Blur' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where origin_to_address IN (lower('0xeC2432a227440139DDF1044c3feA7Ae03203933E') ,'0xf2d15c0a89428c9251d71a0e29b39ff1e86bce25') and origin_function_signature in ('0xc3a086d0' , '0x3d13f874')--depositFromAirdrop -- claim and block_number >= 16628730 and block_number <= 18964188 and contract_address = lower('0x5283d291dbcf85356a21ba090e6db59121208b44') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Eigen' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where (from_address = lower('0x035bdAeaB85E47710C27EdA7FD754bA80aD4ad02') or from_address = lower('0xF532a5A35007804A9cA79E7Fa15D8f648F6D7F28')) and to_address != '0xbb00dda2832850a43840a3a86515e3fe226865f2' and block_number >= 19837601 and block_number <= 20711312 and contract_address = lower('0xec53bf9167f50cdeb3ae105f56099aaab9061f83') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'ENS' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xC18360217D8F7Ab5e7c516566761Ea12Ce7F9D72') and block_number >= 13578843 and block_number <= 21896384 and contract_address = lower('0xC18360217D8F7Ab5e7c516566761Ea12Ce7F9D72') and origin_function_signature = '0x76122903' -- claimTokens and amount != 0 union all select origin_from_address as user_address, 'Ethereum' as chain, 'Layer3' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x6571e50e8769d236414f3fb9e9b1d05341f6f79a') and block_number >= 20418477 and block_number <= 20665801 and contract_address = lower('0x88909d489678dd17aa6d9609f89b0419bf78fd9a') and (origin_function_signature = '0x9a15bf92' or origin_function_signature = '0x0768132f') -- claim / claimAndStake and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Ape' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x025C6da5BD0e6A5dd1350fda9e3B6a614B205a1F') and block_number >= 14403978 and block_number <= 14967366 and contract_address = lower('0x4d224452801ACEd8B2F0aebE155379bb5D594381') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Galxe' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x92e130d5ed0f14199edfa050071116ca60e99aa5') and block_number >= 14717145 and block_number <= 14902868 and contract_address = lower('0x5faa989af96af85384b8a938c2ede4a7378d9875') and origin_function_signature = '0x2e7ba6ef' -- claimTokens and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'LOOKS' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xA35dce3e0E6ceb67a30b8D7f4aEe721C949B5970') and block_number >= 13976786 and block_number <= 14409234 and contract_address = lower('0xf4d2888d29d722226fafa5d9b24f9164c092421e') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Hashflow' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x1a9a4d919943340b7e855e310489e16155f4ed29') and block_number >= 15915772 and block_number <= 22480921 and contract_address = lower('0xb3999f658c0391d94a37f7ff328f3fec942bcadc') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Hop' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc') and block_number >= 14934021 and block_number <= 22442856 and contract_address = lower('0xc5102fe9359fd9a28f877a67e36b0f050d81a3cc') and origin_function_signature = '0x76122903' -- claimTokens and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Shuffle' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xc8b6950e0654a7368ce1a8855ed90e987dac2d8d') and block_number >= 19428071 and block_number <= 21176910 and contract_address = lower('0x8881562783028f5c1bcb985d2283d5e170d88888') and origin_function_signature = '0x379607f5' -- claim and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'X2Y2' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xe6949137b24ad50cce2cf6b124b3b874449a41fa') and block_number >= 14213329 and block_number <= 14487427 and contract_address = lower('0x1E4EDE388cbc9F4b5c79681B7f94d36a11ABEBC9') and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Mask' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x7adcfcafb69aae283f4268e59209ba64a5db4d91') and block_number >= 11936809 and block_number <= 11968906 and contract_address = lower('0x69af81e73a73b40adf4f3d4223cd9b1ece623074') and origin_function_signature = '0xae0b51df' -- claim and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Altlayer' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where origin_to_address = lower('0xb58a659eee982fe4e6ce0c2c37ebd0f7e8224d7e') -- AltLayer: Airdrop Distribution and block_number >= 19082593 and block_number <= 19303559 and contract_address = lower('0x8457ca5040ad67fdebbcc8edce889a335bc0fbfb') and origin_function_signature in ( '0x304c2c03' , '0xea80119e' )-- claim/claim and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Gitcoin' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xde3e5a990bce7fc60a6f017e7c4a95fc4939299e')-- Gitcoin: GTC Distributor and block_number >= 12499254 and block_number <= 12691083 and contract_address = lower('0xde30da39c46104798bb5aa3fe8b9e0e1f348163f') and origin_function_signature in ( '0x9e5167e5' )-- claim and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Aevo' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0xD4B812DD7134F632C947CA11a2Fb0f49082a2483') and block_number >= 19424212 and block_number <= 20717341 and contract_address = lower('0xB528edBef013aff855ac3c50b381f253aF13b997') and origin_function_signature in ( '0x2e7ba6ef' )-- claim and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'Thor' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x8526CEC1D97a68C0e69420488d04DEC5F101B46E') and block_number >= 13582200 and block_number <= 13770406 and contract_address = lower('0xa5f2211b9b8170f694421f2046281775e8468044') and origin_function_signature in ( '0x2e7ba6ef' )-- claim and amount != 0 union all select to_address as user_address, 'Ethereum' as chain, 'DappRadar' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from ethereum_ez_token_transfers where from_address = lower('0x2e424a4953940ae99f153a50d0139e7cd108c071') and block_number >= 13805102 and block_number <= 14413965 and contract_address = lower('0x44709a920fccf795fbc57baa433cc3dd53c44dbe') and amount != 0 ), arbitrum_drops as ( select to_address as user_address, 'Arbitrum' as chain, 'Arbitrum' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from arbitrum_ez_token_transfers where from_address = lower('0x67a24CE4321aB3aF51c2D0a4801c3E111D88C9d9') and origin_function_signature IN ('0x4e71d92d', '0x78e2b594') -- 0x78e2b594 claimAndDelegate -- 0x4e71d92d claim and block_number >= 72829612 and block_number <= 134320927 and contract_address = lower('0x912CE59144191C1204E64559FE8253a0e49E6548') and amount != 0 -- 0x78e2b594 claimAndDelegate -- stake -- 0xa9059cbb claim ), optimism_drops as ( select to_address as user_address, 'Optimism' as chain, 'OP' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from optimism_ez_token_transfers where from_address in (lower('0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'),lower('0xfb4d5a94b516df77fbdbcf3cfeb262baaf7d4db7')) and block_number >= 9401026 and block_number <= 133119111 and contract_address = lower('0x4200000000000000000000000000000000000042') and amount != 0 -- 0xfbaf1763 Delegate -- 0x406afac5 Delegate union all select to_address as user_address, 'Optimism' as chain, 'Velodrome' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from optimism_ez_token_transfers where origin_to_address = lower('0x00d59bc35174c3b250dd92a363495d38c8777a49') -- Velodrome Finance: Merkle Claim and block_number >= 10086197 and block_number <= 118520451 and contract_address = lower('0x3c8b650257cfb5f272f799f5e2b4e65093a11a05') and origin_function_signature in ( '0x3d13f874' )-- claim and amount != 0 ), base_drops as ( select to_address as user_address, 'Base' as chain, 'Spectral' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from base_ez_token_transfers where origin_to_address = lower('0xadf7c35560035944e805d98ff17d58cde2449389') and block_number >= 14060867 and block_number <= 16773448 and contract_address = lower('0x96419929d7949d6a801a6909c145c8eef6a40431') and origin_function_signature in ( '0xbbfb1a0b' )-- merkleClaim and amount != 0 union all select to_address as user_address, 'Base' as chain, 'Zora' as label, Block_timestamp, tx_hash, symbol, amount, amount_usd from base_ez_token_transfers where origin_to_address = lower('0x0000000002ba96C69b95E32CAAB8fc38bAB8B3F8') and block_number >= 29313727 and block_number <= 30254610 and contract_address = lower('0x1111111111166b7fe7bd91427724b487980afc69') and origin_function_signature in ( '0x1e83409a','0xd7ff1a57' )-- claim/claimWithSignature and amount != 0 ), all_drops as ( select * from ethereum_drops union all select * from arbitrum_drops union all select * from optimism_drops union all select * from base_drops ), ethereum_first_transactions AS ( SELECT a.from_address , a.to_address, a.tx_hash , b.label, min(a.block_timestamp) AS first_event_time, row_number()over(partition BY a.from_address , label ORDER BY first_event_time) AS rn FROM ethereum.core.fact_transactions a JOIN ethereum_drops b on a.from_address = b.user_address WHERE a.block_timestamp > b.Block_timestamp GROUP BY 1 , 2 , 3 , 4 qualify rn <= 20 ORDER BY 4 , 6 ASC ), arbitrum_first_transactions AS ( SELECT b.block_timestamp as air_drop_date, a.from_address , a.to_address, a.tx_hash , b.label, min(a.block_timestamp) AS first_event_time, case when datediff('second', air_drop_date, first_event_time) < 60 then concat(cast(datediff('second', air_drop_date, first_event_time) as string), ' s') when datediff('second', air_drop_date, first_event_time) between 60 and 3599 then concat(cast(floor(datediff('second', air_drop_date, first_event_time) / 60) as string), ' m') when datediff('second', air_drop_date, first_event_time) between 3600 and 86399 then concat(cast(floor(datediff('second', air_drop_date, first_event_time) / 3600) as string), ' h') when datediff('second', air_drop_date, first_event_time) between 86400 and 604799 then concat(cast(floor(datediff('second', air_drop_date, first_event_time) / 86400) as string), ' d') when datediff('second', air_drop_date, first_event_time) between 604800 and 2591999 then concat(cast(floor(datediff('second', air_drop_date, first_event_time) / 604800) as string), ' w') else concat(cast(datediff('month', air_drop_date, first_event_time) as string), ' month') end as time_difference, row_number()over(partition BY a.from_address , label ORDER BY first_event_time) AS rn FROM arbitrum.core.fact_transactions a JOIN arbitrum_drops b on a.from_address = b.user_address join arbitrum.core.fact_event_logs c on a.tx_hash = c.tx_hash WHERE a.block_timestamp > b.Block_timestamp and c.contract_address = lower('0x912CE59144191C1204E64559FE8253a0e49E6548') GROUP BY 1 , 2 , 3 , 4 , 5 qualify rn <= 20 ORDER BY 5 , 7 ASC ) select * from arbitrum_first_transactions where from_address = lower('0x3625eff632eab044489a46014dd168ccb5112240') select * from arbitrum.defi.ez_lending_liquidations where tx_hash = '0xbf8a1e14883084205f22e9e075ba2dff85150eccfc0aa28499d3b822c231b79b' --select * from arbitrum.defi.ez_dex_swaps where tx_hash = '0x0ce9682eb2732f57c58dd219a3662d9de3f80e4731f6fded33c4ca436e9bd716' /* -------------------------------------------------------------------- CEX Deposit Wallets -------------------------------------------------------------------- ethereum_deposit_wallet as ( select 'Ethereum' as chain ,address as cex_address ,initcap(label) as cex_name from ethereum.core.dim_labels where label_subtype = 'deposit_wallet' and label_type = 'cex' ), arbitrum_deposit_wallet as ( select 'Arbitrum' as chain ,address as cex_address ,initcap(label) as cex_name from Arbitrum.core.dim_labels where label_subtype = 'deposit_wallet' and label_type = 'cex' ), Optimism_deposit_wallet as ( select 'Optimism' as chain ,address as cex_address ,initcap(label) as cex_name from Optimism.core.dim_labels where label_subtype = 'deposit_wallet' and label_type = 'cex' ), Base_deposit_wallet as ( select 'Base' as chain ,address as cex_address ,initcap(label) as cex_name from Base.core.dim_labels where label_subtype = 'deposit_wallet' and label_type = 'cex' ), all_deposit_wallet as ( select * from ethereum_deposit_wallet union all select * from arbitrum_deposit_wallet union all select * from Optimism_deposit_wallet union all select * from Base_deposit_wallet ), ---------------------------------------------------------------------------------------------------------------------------------------- arbitrum_first_transfers as ( SELECT a.from_address , a.to_address as cex_deposit_address, a.tx_hash , b.label, min(a.block_timestamp) AS first_event_time, row_number()over(partition BY a.from_address , label ORDER BY first_event_time) AS rn FROM arbitrum_ez_token_transfers a JOIN arbitrum_drops b inner join on a.from_address = b.user_address WHERE a.block_timestamp > b.Block_timestamp and contract_address = GROUP BY 1 , 2 , 3 , 4 qualify rn <= 20 ORDER BY 4 , 6 ASC ) select * from base.defi.ez_dex_swaps where origin_from_address = lower('0xD45536f11169d3E0f316cf1C2bD95424ACFbacc5') */

Query	Creator	Created
Users Breakdown Type gnosis flow aurora bsc arbitrum	Sajjadiii	May 22, 2025
yucky-olive copy bsc arbitrum base ethereum optimism	Sajjadiii	May 13, 2025
Number of Addresses Based on Airdrop copy arbitrum ethereum optimism l2 evm	Sajjadiii	Feb 23, 2025
Correlated Wallets List copy gnosis aurora bsc arbitrum base	Sajjadiii	Aug 18, 2023
occasional-brown uniswap kyberswap woofi hashflow maverick	Sajjadiii	May 13, 2025

Sajjadiii