CLAIMER_GROUP | CLAIMERS | CLAIMER_WEIGHTED_BY_VOLUME | |
|---|---|---|---|
1 | b/ Hodl Some | 16256 | 7605569.80006387 |
2 | a/ Hodl None | 74420 | 23246204.5948865 |
3 | c/ Hodl All | 5347 | 1049274.38844987 |
4 | d/ Increased Holdings | 286 | 113135.573835926 |
Pine AnalyticsKaito Airdrop copy 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
›
⌄
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
), tab2 as (
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
), tab3 as (
select
wallet,
sum(
case when flow like 'in' then vol else -vol end
) as balance
from (
select
FROM_ADDRESS as wallet,
'out' as flow,
sum(RAW_AMOUNT_PRECISE / power(10, 18)) as vol
from base.core.fact_token_transfers
where contract_address like lower('0x98d0baa52b2D063E780DE12F615f963Fe8537553')
and from_address in (select claimer from tab2)
group by 1,2
union all
Last run: about 1 month ago
4
166B
22s