select mindate::date as date,
count (distinct node_id) as New_Nodes,
sum (New_Nodes) over (order by date) as Total_Nodes
from (select node_id,min(block_timestamp) as mindate from flow.core.ez_staking_actions
where tx_succeeded = 'TRUE' group by 1) group by 1