Updated 2023-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
case when (balance / pow(10, 6))>0 and (balance / pow(10, 6))<=10 then '0-10 OSMO'
when (balance / pow(10, 6))>10 and (balance / pow(10, 6))<=100 then '10-100 OSMO'
when (balance / pow(10, 6))>100 and (balance / pow(10, 6))<=1000 then '100-1k OSMO'
when (balance / pow(10, 6))>1000 and (balance / pow(10, 6))<=10000 then '1k-10k OSMO'
when (balance / pow(10, 6))>10000 and (balance / pow(10, 6))<=50000 then '10k-50k OSMO'
when (balance / pow(10, 6))>50000 then 'more than 50k OSMO'
end as distribution,
count(DISTINCT (address)) as user
from
osmosis.core.fact_daily_balances
where
currency = 'uosmo'
and date='2023-02-16'
group by distribution
Run a query to Download Data