SELECT
DATE_TRUNC('week', block_timestamp) AS "deployment date",
COUNT(DISTINCT tx_hash) AS "total contracts deployed"
FROM
near.core.fact_actions_events
WHERE
action_name = 'DeployContract'
AND receipt_succeeded = TRUE
GROUP BY
"deployment date"
ORDER BY
"deployment date" ASC;