Moe4probprob
Updated 2022-12-03Copy Reference Fork
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 base as (
select
ADDRESS,
sum(balance/pow(10,decimal)) as balances
from
osmosis.core.fact_daily_balances
where currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'
and DATE::date = CURRENT_DATE - 1
group by 1)
select
case
when balances < 10 then 'Under 10'
when balances between 10 and 100 then '10 - 100'
when balances between 100 and 1000 then '100 - 1000'
when balances between 1000 and 10000 then '1k - 10k'
when balances between 10000 and 100000 then '10k - 100k'
when balances > 100000 then 'above 100k'
end as tier ,
count (distinct address) as holders
from
base
group by 1
Run a query to Download Data