MahrooAverage Balance and Number of Wallets
Updated 2022-10-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
--select date(recorded_at) as day,avg(price) as price from osmosis.core.dim_prices where symbol='OSMO' and recorded_at>='2022-01-01' group by day order by day
with osmo_daily_balance as (select date,address,sum(balance/POW(10, decimal)) as balance
from osmosis.core.fact_daily_balances
where date>='2022-01-01' and currency='uosmo'
group by date,address)
select date,count(address) as addresses,avg(balance) as average_balance,
sum(case when balance>=10000 then 1 else 0 end) atlst_10000,
sum(case when balance>=1000 and balance<10000 then 1 else 0 end) atlst_1000,
sum(case when balance<10 then 1 else 0 end) less_than_10
from osmo_daily_balance
group by date
order by date
Run a query to Download Data