SELECT
CAST(created_block_timestamp AS DATE) AS creation_date,
COUNT(*) AS contract_count
FROM
kaia.core.dim_contracts
WHERE
created_block_timestamp >= DATEADD(YEAR, -4, CURRENT_DATE)
GROUP BY
CAST(created_block_timestamp AS DATE)
ORDER BY
creation_date DESC;