yasminTOP 100 HOLDER 1
Updated 2025-02-04
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 asset_movements as (
select receiver as participant,
token_change as quantity
from (select
to_address as receiver,
cast(amount as double) as token_change
from avalanche.core.ez_token_transfers
where contract_address = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
union all
select
from_address as receiver,
cast(-amount as double) as token_change
from avalanche.core.ez_token_transfers
where
contract_address = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
)),
holder_balances as (
select
participant,
sum(quantity) as current_balance
from asset_movements
group by participant
having sum(quantity) > 0
)
select
participant as "Top Holder",
current_balance as "Balance"
from
holder_balances
order by
current_balance desc
-- limit 100;
QueryRunArchived: QueryRun has been archived