count(distinct(date_trunc('day', date))) as "Number of Dates",

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

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

from osmosis.core.fact_daily_balances

where currency = 'uosmo'

and date::date >= '2022-10-01'