select address as "Osmosis adress",BALANCE/1e6 as Osmosis_balance_amount,rank()over(order by Osmosis_balance_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