top 100 address,

(balance / pow (10,decimal)) as total_osmo,

row_number() over (order by total_osmo DESC) as rank

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and date = (select max(date) from osmosis.core.fact_daily_balances)

order by 2 desc