with top100 as (
select address,
balance / pow (10,decimal) as OSMO_Balance
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and date = (select max(date) from osmosis.core.fact_daily_balances)
order by 2 DESC
limit 100)
select date,
sum (balance / pow (10,decimal)) as Total_OSMO_Balance,
avg (balance / pow (10,decimal)) as Average_OSMO_Balance
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and address in (select address from top100)
group by 1
order by 1