(

SELECT balance/decimal as total_osmo,

address as user,

date,

max(date) as datee

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and balance_type in ('liquid', 'staked')

group by total_osmo, user

order by total_osmo DESC

limit 100

)

select user, total_osmo, date

from info

where date=datee