sum(BALANCE/pow(10,DECIMAL)) as balance_osmo,

avg(BALANCE/pow(10,DECIMAL)) as avg_balance,

median(BALANCE/pow(10,DECIMAL)) as median_balance,

count(distinct address) as no_holders,

balance_osmo/no_holders as osmo_per_wallet

from osmosis.core.fact_daily_balances

where currency='uosmo'

and DATE=CURRENT_DATE