shoa1bUntitled Query
Updated 2022-09-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH gas_table AS (
SELECT
days,
avg_gas_price,
CASE
WHEN avg_gas_price < 15.0 THEN 1 ELSE 0
END AS avg_gas_price_lt15
FROM (
SELECT
DATE_TRUNC('day', block_timestamp) AS days,
AVG(gas_price) AS avg_gas_price
FROM
ethereum.core.fact_transactions
WHERE
block_timestamp::DATE BETWEEN '2022-07-01' AND '2022-07-31'
GROUP BY
days
) AS f
)
SELECT SUM(avg_gas_price_lt15) FROM gas_table;
Run a query to Download Data