*,

sum(new_nodes) over (ORDER BY week) as total_nodes

FROM (

SELECT

date_trunc('week', min_day) as week,

count(*) as new_nodes

FROM (

SELECT

NODE_ID,

min(block_timestamp) as min_day

FROM flow.core.ez_staking_actions where block_timestamp::date<CURRENT_DATE

GROUP BY 1

)

GROUP BY 1