SELECT TX_HASH AS hash

FROM near.core.fact_actions_events

WHERE action_name = 'DeployContract'

),

t2 AS (

SELECT MIN(block_timestamp) AS time, TX_RECEIVER

from near.core.fact_transactions

Join t1 ON t1.hash = near.core.fact_transactions.tx_hash

Group by 2)

Select Date_trunc('week',time) AS week, count(*) AS unique_Deployment

From t2

group by 1