Date(block_timestamp::date) as day,

COUNT(tx_hash) as count_deploy,

sum(count_deploy) over (ORDER BY DAY) as cum_deploy

FROM near.core.fact_actions_events

WHERE action_name = 'DeployContract'

and Date(block_timestamp::date) >= CURRENT_DATE-30

GROUP BY 1