date_trunc(HOUR, block_timestamp) AS hours,

avg(GAS_PRICE) AS "Average Gas Price",

max(GAS_PRICE) AS "Maximum Gas Price",

min(GAS_PRICE) AS "Minimum Gas Price",

avg(TX_FEE) AS "Average TX Fee"

FROM avalanche.core.fact_transactions

WHERE block_timestamp > '2022-06-20'

AND status = 'SUCCESS'

GROUP BY hours

ORDER BY hours DESC