CLAIM_VOLUME_GROUP | WALLETS | TOKENS_CLAIMED | |
|---|---|---|---|
1 | c/ 10-100 | 55472 | 2046124.21656191 |
2 | g/ 100k+ | 25 | 4198090.03272014 |
3 | e/ 1K-10K | 2564 | 9866321.50558576 |
4 | d/ 100-1K | 10564 | 2889379.0864601 |
5 | a/ below 1 | 1 | 0.6259543177 |
6 | b/ 1-10 | 27109 | 208710.263560062 |
7 | f/ 10K-100K | 574 | 12805558.6263939 |
Pine AnalyticsKaito Airdrop copy copy copy
Updated 2025-03-24
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
›
⌄
-- forked from Kaito Airdrop copy copy @ https://flipsidecrypto.xyz/studio/queries/c97708fa-b39e-4226-a474-18f824852e4a
with tab1 as (
select
tx_hash
from base.core.fact_transactions
where to_address like '0xeb7d383b0c77ea0bed28b42d0c288f9071bd8a7a'
and origin_function_signature like '0x69659658'
and TX_SUCCEEDED
)
select
case when claim_volume < 1 then 'a/ below 1'
when claim_volume < 10 then 'b/ 1-10'
when claim_volume < 100 then 'c/ 10-100'
when claim_volume < 1000 then 'd/ 100-1K'
when claim_volume < 10000 then 'e/ 1K-10K'
when claim_volume < 100000 then 'f/ 10K-100K'
else 'g/ 100k+' end as claim_volume_group,
count(*) as wallets,
sum(claim_volume) as tokens_claimed
from (
select
ORIGIN_FROM_ADDRESS as claimer,
min(block_timestamp) as claim_time,
sum(RAW_AMOUNT_PRECISE / power(10, 18)) as claim_volume
from base.core.fact_token_transfers
where tx_hash in (select * from tab1)
and CONTRACT_ADDRESS like lower('0x98d0baa52b2D063E780DE12F615f963Fe8537553')
group by 1
order by 3 desc
)
group by 1
Last run: 15 days ago
7
245B
11s