date,

avg((balance/decimal)/pow(10, 6)) as avg_osmo

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and balance_type = 'liquid'

group by date