AzinTop airdrop claimers
Updated 2025-01-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with t1 as
( select
SENDER,
PAYLOAD['arguments'][2]/1e8 as amount
from aptos.core.fact_transactions
where
PAYLOAD['function']='0xcf8a27bb49491e65ad2ce1c48c098473e3340f45ed5a267a0d3ad8ee3eee5e35::claim::claim'
and
SUCCESS='TRUE'
)
select
SENDER as claimer,
sum(amount)*10 as volume
from t1
group by 1
order by 2 desc
limit 1000
QueryRunArchived: QueryRun has been archived