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

optimism.core.

WHERE

time > '2022-01-01' -- dates are in 'YYYY-MM-DD' format

time != '2022-03-11' -- omit outlier seen (if desired)

GROUP BY

time

ORDER BY

time DESC;