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

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

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

count(distinct(address)) total_holders

from osmosis.core.fact_daily_balances

where 1 = 1

and date_trunc('day', date) = '2022-10-24'

and currency = 'uosmo'