DATE_TRUNC('day', block_timestamp) AS day,

SUM(gas_used) AS total_gas_used

kaia.core.fact_transactions

block_timestamp >= '2024-08-01'

AND block_timestamp < '2024-09-01'

GROUP BY

day

ORDER BY

day;