adambalaUntitled Query
Updated 2022-08-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH
polygon AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS hours,
AVG(fee) AS fees
FROM
flipside_prod_db.polygon.transactions
WHERE
block_timestamp::date >= '2021-09-01'
GROUP BY
hours
)
SELECT
DATE_PART(hour, polygon.hours) AS tx_hour,
AVG(polygon.fees) AS "Polygon (MATIC)"
FROM
polygon
GROUP BY
tx_hour
ORDER BY
tx_hour
Run a query to Download Data