DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

AVG(CAST(BLOCK_HEADER_JSON:baseFeePerGas AS INTEGER)) AS avg_base_fee

FROM

polygon.core.fact_blocks

WHERE

BLOCK_TIMESTAMP >= '2023-09-01'

AND BLOCK_TIMESTAMP < '2023-10-01'

GROUP BY

day

ORDER BY

day;