permaryConcentration of Holdings
Updated 2024-11-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with holder_dist as (
select
case
when net_balance >= 1000000 then '1M+'
when net_balance >= 100000 then '100K-1M'
when net_balance >= 10000 then '10K-100K'
when net_balance >= 1000 then '1K-10K'
when net_balance >= 100 then '100-1K'
else 'Less than 100'
end as balance_bucket,
count(*) as num_holders,
sum(net_balance) as total_tokens_in_bucket
from $query('49111813-f1ca-442f-bd2a-1b02e5af15d4')
where net_balance > 0
group by 1
order by total_tokens_in_bucket desc
)
select * from holder_dist;
QueryRunArchived: QueryRun has been archived