keshanAlgo distribution non jan wallets
Updated 2022-02-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select (case when amount = 0 then '0'
when amount > 0 and amount <=1 then '0 - 1'
when amount > 1 and amount <=10 then '1 - 10'
when amount > 10 and amount <=100 then '10 - 100'
when amount > 100 and amount <=1000 then '100 - 1000'
when amount > 1000 and amount <=10000 then '1000 - 10000'
when amount > 10000 and amount <=1000000 then '10000 - 1000000'
when amount > 1000000 then '1M+'
end)
as bracket,
count(address) as count from
(select address,
sum(balance) as amount
from algorand.account
left join algorand.block on block_id = created_at
where date_trunc('month', block_timestamp) != '2022-1-1'
group by address)
group by bracket
Run a query to Download Data