address,

sum(balance/ power(10,6)) total_balance,

avg(balance/ power(10,6)) average_balance,

median(balance/ power(10,6)) median_balance

from osmosis.core.fact_daily_balances

where 1 = 1

and date_trunc('day', date) = current_date

and currency = 'uosmo'

group by address

order by total_balance desc

limit 10