DATE_TRUNC('day', block_timestamp) AS day,

AVG(gas_used) AS avg_gas_used_per_tx

kaia.core.fact_transactions

block_timestamp >= '2024-08-01'

AND block_timestamp < '2024-09-01'

GROUP BY

day

ORDER BY

day;