Query editor
WITH blockchains_filter AS (SELECT blockchainFROM evms.infoWHERE name = '{{Blockchain}}')SELECT EXTRACT(HOUR FROM block_time) AS "Hour", ROUND(AVG(gas_price) / CAST(1e9 AS DOUBLE)) AS "Average", ROUND(APPROX_PERCENTILE(gas_price, 0.1) / CAST(1e9 AS DOUBLE)) AS "0.1 Percentile", ROUND(APPROX_PERCENTILE(gas_price, 0.5) / CAST(1e9 AS DOUBLE)) AS "Median", ROUND(APPROX_PERCENTILE(gas_price, 0.9) / CAST(1e9 AS DOUBLE)) AS "0.9 Percentile"FROM evms.transactionsWHERE blockchain = (SELECT blockchain FROM blockchains_filter)AND block_time >= CURRENT_TIMESTAMP - INTERVAL '5' yearGROUP BY 1ORDER BY 1