DISTINCT address as user,

sum(balance/pow(10,6))

FROM osmosis.core.fact_daily_balances

WHERE CURRENCY = 'uosmo'

AND date ='2022-10-24'

group by 1

order by 2 desc

limit 100