DATE_TRUNC('day', block_timestamp) AS day,

COUNT(*) AS transaction_count

kaia.core.fact_transactions

block_timestamp >= '2024-08-01'

AND block_timestamp < '2024-09-01'

GROUP BY

day

ORDER BY

day;