SELECT

*,

sum(BALANCE_CHANGE) over (partition by node_id ORDER BY day) as node_bal

FROM (

SELECT --DISTINCT action

date_trunc('month', BLOCK_TIMESTAMP) as day,

node_id,

sum(CASE

WHEN ACTION = 'DelegatorTokensCommitted' THEN AMOUNT

ELSE -AMOUNT

END) as balance_change

FROM flow.core.ez_staking_actions

GROUP BY 1,2

HAVING node_bal > 0

AND day > '2021-03-01'