MetiocreUSDC holders distribution
    Updated 2022-02-16
    with usdc_holdings as (
    select aa.address as address , aa.amount / power(10,a.decimals) as amount
    from algorand.account_asset as aa inner join algorand.asset as a on aa.asset_id = a.asset_id
    where aa.asset_id='31566704' and aa.amount>0
    order by amount desc
    limit null offset 1
    )


    select
    case
    when amount between 0 and 1 then '0-1'
    when amount between 1 and 10 then '1-10'
    when amount between 10 and 100 then '10-100'
    when amount between 100 and 1000 then '100-1k'
    when amount between 1000 and 10000 then '1k-10k'
    when amount between 10000 and 100000 then '10k-100k'
    when amount between 100000 and 1000000 then '100k-1m'
    when amount between 1000000 and 10000000 then '1m-10m'
    when amount between 10000000 and 100000000 then '10m-100m'
    when amount between 100000000 and 1000000000 then '100m-1b'
    when amount between 1000000000 and 10000000000 then '1b-10b'
    when amount between 10000000000 and 100000000000 then '10b-100b'
    else '100b+'
    end as amount_band,
    count(address) as count_of_holders_in_this_bucket, sum(amount) as sum_of_amount_in_this_bucket
    from usdc_holdings
    group by 1
    order by 1


    Run a query to Download Data