PROJECT | PARTICIPANTS | |
|---|---|---|
1 | no_airdrop | 225352115 |
2 | arbitrum | 95074 |
3 | eigen | 59231 |
4 | Layer3 | 41661 |
5 | arkham | 20301 |
6 | optimism | 14490 |
7 | blur | 11819 |
8 | hashflow | 5844 |
9 | galxe | 3996 |
10 | ens | 3756 |
11 | hop | 3712 |
12 | uni | 3694 |
13 | looks | 3643 |
14 | dydx | 2318 |
15 | paraswap | 2111 |
16 | ape | 181 |
hessNumber of Addresses Based on Airdrop
Updated 6 days ago
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH participant AS (
SELECT DISTINCT from_address AS address
FROM monad.testnet.fact_transactions
),
arkham AS (
SELECT DISTINCT origin_from_address
FROM ethereum.core.ez_token_transfers
WHERE from_address = '0x08c7676680f187a31241e83e6d44c03a98adab05'
AND contract_address = '0x6e2a43be0b1d33b726f0ca3b8de60b3482b8b050'
),
arbitrum AS (
SELECT DISTINCT origin_from_address
FROM arbitrum.core.ez_token_transfers
WHERE origin_to_address = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9'
AND origin_function_signature IN ('0x4e71d92d', '0x78e2b594')
AND BLOCK_NUMBER >= 70506697
),
uni AS (
SELECT DISTINCT origin_from_address
FROM ethereum.core.ez_token_transfers
WHERE origin_to_address = '0x090d4613473dee047c3f2706764f49e0821d256e'
AND contract_address = '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'
AND origin_function_signature = '0x2e7ba6ef'
),
paraswap AS (
SELECT DISTINCT origin_from_address
FROM ethereum.core.ez_token_transfers
WHERE origin_to_address = '0x090e53c44e8a9b6b1bca800e881455b921aec420'
AND contract_address = '0xcafe001067cdef266afb7eb5a286dcfd277f3de5'
AND origin_function_signature = '0x2e7ba6ef'
),
dydx AS (
SELECT DISTINCT origin_from_address
FROM ethereum.core.ez_token_transfers
WHERE origin_to_address = '0x0fd829c3365a225fb9226e75c97c3a114bd3199e'
Last run: 6 days ago
16
260B
599s