balance_type as "Type",

avg (balance/ pow(10, 6)) as "Average Balance",

count(distinct(address)) as "Number of Addresses",

median (balance/ pow(10, 6)) as "Median Balance"

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and date::date between '2022-10-15' and '2022-10-23'

group by 1

order by 2 desc

limit 100