SELECT
DATE_TRUNC('day', created_block_timestamp) AS day,
COUNT(*) AS contracts_deployed
FROM
kaia.core.dim_contracts
WHERE
created_block_timestamp >= '2024-08-01 00:00:00'
AND created_block_timestamp < '2024-09-01 00:00:00'
GROUP BY
day
ORDER BY
day ASC;