Zanyar_98Average gas price in polygon
Updated 2023-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
WITH
AVERAGE_GAS_PRICE AS (
SELECT
date_trunc('HOUR', BLOCK_TIMESTAMP) AS HOUR,
AVG(GAS_PRICE) AS "Average gas price",
SUM(GAS_PRICE) / COUNT(DISTINCT (TX_HASH)) AS "Average gas price per transaction",
CASE
WHEN BLOCK_NUMBER >= 38189056 THEN 'After hard fork'
WHEN BLOCK_NUMBER < 38189056 THEN 'Before hard fork'
END AS
TYPE
FROM
polygon.core.fact_transactions
WHERE
BLOCK_TIMESTAMP::DATE BETWEEN '2022-12-17' AND '2023-02-17'
GROUP BY
HOUR,
TYPE
)
SELECT
TYPE,
ROUND(AVG("Average gas price"), 3) AS "Average gas price",
ROUND(AVG("Average gas price per transaction"), 3) AS "Average gas price per transaction"
FROM
AVERAGE_GAS_PRICE
GROUP BY
TYPE
Run a query to Download Data