select

tx_signer as user,

min(block_timestamp::date) as min_date

from near.core.fact_transactions

group by 1

having min_date >= current_date - 90),

new_users as (

select min_date as date,

count(distinct user) as "new users"

from first_txs

group by 1

order by 1)

select

date,

"new users",

sum("new users") over (order by date) as "cum new users"

from new_users

order by date desc

limit 90