all airdrops - groups

mo115all airdrops - groups

Updated 2025-04-16

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

with a_z as (

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

	AMOUNT	Users	Total OP	Average OP Tokens Received	Average Number of Airdrops	MAX	MIN
1	A: 0-100	227863	1893591.38090439	8.310218776	1.00797	99.984090548	9.620726743e-8
2	B: 100-1k	198686	103383661.936886	520.33692327	1.29531	999.90196208	100.016248631
3	C: 1k-10k	58571	126913468.487534	2166.831170503	1.882911	10000	1000.131589648
4	D: more than 10k	1100	20395944.489941	18541.767718128	2.577273	62469.398653772	10017.480586746

353B

20s