SELECT

DATE_TRUNC('week', created_block_timestamp) AS day,

COUNT(DISTINCT address) AS Contracts

FROM

avalanche.core.dim_contracts

WHERE

created_block_timestamp >= '2021-02-01'

GROUP BY

1

SELECT

day,

Contracts,

CASE

WHEN day < '2024-12-16' THEN 'Pre-upgrade'

ELSE 'Post-upgrade'

END AS period

FROM

deploy

ORDER BY

day ASC;