Updated 2023-03-29
    SELECT
    AVG(gas_price), -- apply aggregate function to columns that are not being grouped
    trunc(block_timestamp, 'day') as time -- truncates each timestamp to its day
    FROM
    optimism.core.fact_transactions
    WHERE
    time > '2022-01-01' -- YYYY-MM-DD format
    AND
    time != '2022-03-11' -- Omit outlier
    GROUP BY
    time
    ORDER BY
    time DESC;
    Run a query to Download Data