SELECT

balance_type,

CURRENCY,

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

WHERE date > '2022-01-01'

GROUP BY 1,2 )

select * from Q1

LEFT outer JOIN osmosis.core.dim_labels

ON CURRENCY = osmosis.core.dim_labels.ADDRESS

WHERE project_name LIKE 'OSMO'