SELECT DISTINCT DATE, count(address) over (order by date) as users

FROM (select distinct address, date from osmosis.core.fact_daily_balances)

ORDER BY Date)

SELECT avg(balance/power(10,decimal))avg_balance, users, b.DATE

FROM osmosis.core.fact_daily_balances as b

JOIN user_growth as u on b.date = u.date

Where currency like '%uosmo%'

GROUP BY 2, 3

ORDER BY 3