Query editor
WITH gas_metrics AS (SELECTDATE_TRUNC('hour', b.time) AS hour,AVG(b.base_fee_per_gas) AS avg_base_fee,MAX(b.base_fee_per_gas) AS max_base_fee,AVG(TRY_CAST(b.gas_used AS REAL) / b.gas_limit) AS gas_utilization,COUNT(*) AS block_countFROM ink.blocks AS bGROUP BY1)SELECT*FROM gas_metricsORDER BYhour DESC