sum(new_users) over (ORDER BY min_day) as total_users

FROM (SELECT min_day,

count(*) as new_users

FROM (SELECT from_address,

min(date_trunc('day', block_timestamp)) as min_day

FROM gnosis.core.fact_transactions

where block_timestamp>'2022-09-01'

GROUP BY 1

)

GROUP BY 1

ORDER BY 1 DESC

)