MetiocreUSDC holders distribution
Updated 2022-02-16
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
›
⌄
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