all airdrops - # airdrops

mo115all airdrops - # airdrops

Updated 2025-02-07

-- forked from all airdrops - top 1000 @ https://flipsidecrypto.xyz/studio/queries/78723b77-333a-4974-ba74-f73ca25a2894

with txs as (

-- airdrop 1 - part 1

select * , '1' as airdrop

from optimism.core.ez_token_transfers

where FROM_ADDRESS = '0xfedfaf1a10335448b7fa0268f56d2b44dbd357de'

and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'

and ORIGIN_FUNCTION_SIGNATURE != '0x57888c29'--- not claimed tokens

UNION

-- airdrop 1 - part 2

select *, '1' as airdrop

from optimism.core.ez_token_transfers

where ORIGIN_FUNCTION_SIGNATURE = '0x43913491'

and FROM_ADDRESS = '0x2501c477d0a35545a387aa4a3eee4292a9a8b3f0'

and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'

and BLOCK_TIMESTAMP > '2023-09-15 00:00:00.000'

and BLOCK_TIMESTAMP < '2023-09-16 00:00:00.000'

UNION

-- airdrop 2

select *, '2' as airdrop

from optimism.core.ez_token_transfers

where ORIGIN_FUNCTION_SIGNATURE = '0x43913491'

and FROM_ADDRESS = '0x2501c477d0a35545a387aa4a3eee4292a9a8b3f0'

and CONTRACT_ADDRESS = '0x4200000000000000000000000000000000000042'

and BLOCK_TIMESTAMP > '2023-02-09 00:00:00.000'

and BLOCK_TIMESTAMP < '2023-02-10 00:00:00.000'

UNION

-- airdrop 3

select *, '3' as airdrop

from optimism.core.ez_token_transfers

where ORIGIN_FUNCTION_SIGNATURE = '0x43913491'

and FROM_ADDRESS = '0x2501c477d0a35545a387aa4a3eee4292a9a8b3f0'

Last run: about 2 months ago

	Number of Airdrops	Users	OP	Average OP per user
1	1	416582	113120594.63	271.54
2	2	69535	77578321.82	1115.67
3	3	27110	61377261.04	2264.01
4	4	2231	9174347.37	4112.21
5	5	127	800820.06	6305.67

146B

23s