Skip to content

Instantly share code, notes, and snippets.

@allenday

allenday/gas-price-by-date.sql

Created May 26, 2019 08:11
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save allenday/b7867cc0db76b810dee2ab9215e0512d to your computer and use it in GitHub Desktop.
Save allenday/b7867cc0db76b810dee2ab9215e0512d to your computer and use it in GitHub Desktop.
Download ZIP
Ethereum gas price by date from BigQuery
Raw
gas-price-by-date.sql
SELECT CAST('2019-04-01' AS DATE) AS d, AVG(gas_used) AS gas
FROM `bigquery-public-data.crypto_ethereum.blocks`
WHERE TRUE
AND timestamp >= TIMESTAMP('2019-04-01')
AND timestamp <= TIMESTAMP(DATE_ADD(CAST('2019-04-01' AS DATE), INTERVAL 1 DAY))
GROUP BY d
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment