BREAKDOWN | WALLET_ADD | |
|---|---|---|
1 | a. < 10 aUSD | 965 |
2 | b. 10 - 50 aUSD | 21 |
3 | c. 50 - 100 aUSD | 6 |
4 | d. 100 - 500 aUSD | 9 |
5 | e. 500 - 1K aUSD | 2 |
6 | f. 1K - 5K aUSD | 1 |
7 | h. 10K - 100K aUSD | 3 |
8 | i. > 100K aUSD | 2 |
0xHaM-daUSD 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
›
⌄
-- forked from xAVAX Holders Breakdown @ https://flipsidecrypto.xyz/studio/queries/6bbf089a-40a5-4467-bd9e-375e1067c0f4
with receivet as (
select
block_timestamp,
to_address as address,
amount
from avalanche.core.ez_token_transfers
where contract_address = '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
union all
select
block_timestamp,
from_address as address,
amount*-1 as amount
from avalanche.core.ez_token_transfers
where contract_address = '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'
)
,
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 aUSD'
when total_amount <= 50 then 'b. 10 - 50 aUSD'
when total_amount <= 100 then 'c. 50 - 100 aUSD'
when total_amount <= 500 then 'd. 100 - 500 aUSD'
when total_amount <= 1000 then 'e. 500 - 1K aUSD'
when total_amount <= 5000 then 'f. 1K - 5K aUSD'
when total_amount <= 10000 then 'g. 5K - 10K aUSD'
when total_amount <= 100000 then 'h. 10K - 100K aUSD'
Last run: 12 days ago
8
183B
4s