COUNT(*) AS total_contracts

kaia.core.dim_contracts

created_block_timestamp >= '2024-08-01'

AND created_block_timestamp < '2024-09-01';