select week, n_minter as new_minter, sum(new_minter) OVER(ORDER BY week asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_new_minter

from (with firstdate as (select tx_from_address as ad1, min(block_timestamp) as t

from ethereum.events_emitted

where --tx_id='0x9fe341e2f9715e3a5a2e73a47d3907cdf63fb9e085dee5bb6840596672c5ece7' and

event_name='NameRegistered' and

contract_address='0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'

group by 1

),

newuser as (select block_timestamp as t1,tx_from_address as ad2

from ethereum.events_emitted

where --tx_id='0x9fe341e2f9715e3a5a2e73a47d3907cdf63fb9e085dee5bb6840596672c5ece7' and

event_name='NameRegistered' and

contract_address='0x283af0b28c62c092c9727f1ee09c02ca627eb7f5'

select date_trunc('week',t) as week , count(ad1) as n_minter

from firstdate

inner join newuser on firstdate.t=newuser.t1

group by 1 order by 1

where week>'2021-11-09'