shoa1bUntitled Query
    Updated 2022-09-07
    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