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(volume_24h) as total_daily_volume, users, date_trunc('day', recorded_at) as day

FROM osmosis.core.dim_prices as p

JOIN user_growth as u on date_trunc('day', recorded_at) = u.date

GROUP BY 2, 3

HAVING total_daily_volume < 200000000000

ORDER BY 3