distinct address ,

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

from osmosis.core.fact_daily_balances

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

and currency = 'ibc/0954E1C28EB7AF5B72D24F3BC2B47BBB2FDF91BDDFD57B74B99E133AED40972A'

group by 1

order by 2 DESC

limit 10