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
arbitrum bridge.traderjoexyz 1 uniswap kyberswap woofi hashflow maverick	Sajjadiii	Jul 20, 2023
occasional-brown uniswap kyberswap woofi hashflow maverick	Sajjadiii	May 13, 2025

Sajjadiii