BREAKDOWN | WALLET_ADD | |
|---|---|---|
1 | a. < 10 xAVAX | 403 |
2 | b. 10 - 50 xAVAX | 55 |
3 | c. 50 - 100 xAVAX | 13 |
4 | d. 100 - 500 xAVAX | 74 |
5 | e. 500 - 1K xAVAX | 31 |
6 | f. 1K - 5K xAVAX | 60 |
7 | g. 5K - 10K xAVAX | 16 |
8 | h. 10K - 100K xAVAX | 27 |
9 | i. > 100K xAVAX | 11 |
0xHaM-dxAVAX Holders Breakdown
Updated 2025-03-27
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 receivet as (
select
block_timestamp,
to_address as address,
amount
from avalanche.core.ez_token_transfers
where contract_address = '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e'
union all
select
block_timestamp,
from_address as address,
amount*-1 as amount
from avalanche.core.ez_token_transfers
where contract_address = '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e'
)
,
amountTb as (
select
address as user_add,
sum (amount) as total_amount
from receivet
group by 1
order by 2 desc
)
select
case
when total_amount < 10 then 'a. < 10 xAVAX'
when total_amount <= 50 then 'b. 10 - 50 xAVAX'
when total_amount <= 100 then 'c. 50 - 100 xAVAX'
when total_amount <= 500 then 'd. 100 - 500 xAVAX'
when total_amount <= 1000 then 'e. 500 - 1K xAVAX'
when total_amount <= 5000 then 'f. 1K - 5K xAVAX'
when total_amount <= 10000 then 'g. 5K - 10K xAVAX'
when total_amount <= 100000 then 'h. 10K - 100K xAVAX'
else 'i. > 100K xAVAX'
end as breakdown,
Last run: 27 days ago
9
222B
3s