DATE(created_block_timestamp) AS day,

COUNT(*) AS new_contracts

FROM mezo.testnet.dim_contracts

WHERE created_block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'

GROUP BY day

ORDER BY day;