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