AIRDROP_CLAIMERS | TOTAL_AMOUNT | AVERAGE_AMOUNT | MEDIAN_AMOUNT | MIN_AMOUNT | MAXIMUM_AMOUNT | TOTAL_AMOUNT_USD | AVERAGE_AMOUNT_USD | MEDIAN_AMOUNT_USD | MIN_AMOUNT_USD | MAXIMUM_AMOUNT_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 742 | 2414553.9587416 | 1622.684112058 | 0 | 0 | 98336.399497924 | 17759.698370209 | 11.935281163 | 0 | 0 | 734.409665826 |
Ali3NOverview ($ARENA Airdrop 16 March 2025)
Updated 2025-03-17
99
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 claimrewardst as (
select distinct tx_hash
from avalanche.core.ez_decoded_event_logs
where origin_to_address = '0xeffb809d99142ce3b51c1796c096f5b01b4aaec4'
and event_name = 'Transfer'
and origin_function_signature = '0x2e1a7d4d'
and contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'
--and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
--and origin_from_address = decoded_log:to
and decoded_log:value/1e18 = '0'
and block_timestamp >= '2025-03-16 23:00:00.000'
group by 1),
arenapricet as (
select hour as hour1,
avg (price) as arenaprice
from avalanche.price.ez_prices_hourly
where token_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'
group by 1)
/*select count (distinct to_address) as Airdrop_Claimers,
sum (amount) as Total_Amount,
avg (amount) as Average_Amount,
median (amount) as Median_Amount,
min (amount) as Min_Amount,
max (amount) as Maximum_Amount,
sum (amount*arenaprice) as Total_Amount_usd,
avg (amount*arenaprice) as Average_Amount_usd,
median (amount*arenaprice) as Median_Amount_usd,
min (amount*arenaprice) as Min_Amount_usd,
max (amount*arenaprice) as Maximum_Amount_usd
from avalanche.core.ez_token_transfers t1 left outer join arenapricet t2 on date_trunc (hour,t1.block_timestamp) = t2.hour1
where contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'
and from_address = '0x30f587903ef022774f5e35151e0e73c196bd755d'
and origin_function_signature = '0x3b439351'
and block_timestamp >= '2025-03-09 18:30:00.000'
Last run: about 1 month ago
1
105B
9s