balance_type,

count(DISTINCT osmosis.core.fact_daily_balances.address) as holders,

avg(balance/ power(10, decimal)) as bal,

sum(balance/ power(10, decimal)) / count(DISTINCT date) as avg_bal

FROM osmosis.core.fact_daily_balances

LEFT outer JOIN osmosis.core.dim_labels

ON CURRENCY = osmosis.core.dim_labels.ADDRESS

WHERE project_name LIKE 'OSMO'

AND date > '2022-01-01'

GROUP BY 1