DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",

AVG(GAS_USED * GAS_PRICE) AS "Average Gas Fee ($)"

FROM

base.core.fact_transactions

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

"Date";