DATE_TRUNC('day', block_timestamp) AS date,

AVG(gas_used) AS avg_gas_used,

MAX(gas_used) AS max_gas_used,

MIN(gas_used) AS min_gas_used,

AVG(tx_fee) AS avg_tx_fee,

MAX(tx_fee) AS max_tx_fee,

MIN(tx_fee) AS min_tx_fee

FROM base.goerli.fact_transactions

where status='SUCCESS'

GROUP BY 1

order by 1 asc