select address as osmo_users,BALANCE/1e6 as osmo_bal_amount,rank()over(order by osmo_bal_amount)as rank

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and BALANCE_TYPE='liquid'

and date = current_date

group by 1,2

order by 2 desc

limit 100