NUM_CLAIMERS | TOTAL_CLAIMED_AMOUNT | AVERAGE_CLAIMED_AMOUNT | MEDIAN_CLAIMED_AMOUNT | MINIMUM_CLAIMED_AMOUNT | MAXIMUM_CLAIMED_AMOUNT | |
|---|---|---|---|---|---|---|
1 | 86470 | 30566956.2485033 | 345.213803699 | 25.949505584 | 0.6259543177 | 460845 |
saeedmzn[Kaito] - airdrop Total
Updated 2025-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with claim_txns as (
select tx_hash ,
from base.core.fact_event_logs
where contract_address = '0x98d0baa52b2d063e780de12f615f963fe8537553'
and ORIGIN_TO_ADDRESS ='0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'
and ORIGIN_FUNCTION_SIGNATURE = '0x69659658'
and block_timestamp::date >= '2025-02-20'
group by 1
),
claimed_amount as(
select date_trunc(hour,BLOCK_TIMESTAMP) date ,
TO_ADDRESS user ,
AMOUNT
from claim_txns left join base.core.ez_token_transfers using (tx_hash)
)
select count (distinct user) num_claimers ,
sum (AMOUNT) Total_claimed_amount ,
avg(AMOUNT) average_claimed_amount ,
median (AMOUNT) median_claimed_amount ,
min (AMOUNT) minimum_claimed_amount ,
max(amount) maximum_claimed_amount
from claimed_amount
Last run: about 2 months ago
1
73B
55s