permaryConcentration of Holdings
    Updated 2024-11-21
    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