address as user,

balance/pow(10,decimal) as total_osmo

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

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

and date=CURRENT_DATE

group by 1,2,3

order by total_osmo desc

limit 100