date_trunc('week', block_timestamp) AS week

, COUNT(*) AS Contracts_Deployed

, SUM(Contracts_Deployed) OVER (ORDER BY week) AS Cumulative_Contracts

FROM near.core.fact_actions_events

WHERE action_name = 'DeployContract'

AND block_timestamp >= '2023-01-01'

GROUP BY 1

ORDER BY 1 DESC

LIMIT 1000