DATE(created_block_timestamp) AS date,

COUNT(address) AS new_contracts

FROM

kaia.core.dim_contracts

WHERE

created_block_timestamp >= '2024-05-29'

GROUP BY

DATE(created_block_timestamp)

ORDER BY

date;