WITH t1 AS (
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