count(distinct address) as user_no,

sum (balance / pow(10,decimal)) as total_balance,

avg (balance/ pow(10,decimal)) as average,

total_balance / user_no as wallet_avg

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

group by date

order by date desc