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