Get Ethereum Fee History

SELECT
  DATE_TRUNC('hour', b.process_time) AS datetime,
  AVG(gas_limit) AS gas_limit,
  AVG(gas_used) AS gas_used,
  AVG(gas_used) / AVG(gas_limit) AS utilization, 
  SUM(num_of_transactions) as total_transactions_count 
FROM
  ethereum_mainnet.blocks b
WHERE
  process_time >= NOW() - INTERVAL '10' YEAR
GROUP BY
  1
ORDER BY
  datetime DESC;