Data

What is the fastest way of getting the last 100k block number + block hash pairs for free?

Looking for this data on ethereum mainnet specifically to use in a script

cypherpunk wannabe, engineer working on @frames /open-frames /opencast
https://stephancill.co.za create stories at https://stories.steer.fun

How often do you need the data? If infrequent, BigQuery will be fast and free for this dataset.

Husband, dad, dev • @dune.eth wizard • Ultimate Ⓜ️oxie Dashboard https://tinyurl.com/moxiedash • Ultimate Degen Tips FAQ https://tinyurl.com/degenfaq

Could've sworn I read they added it to BQ but indeed it's not there :(

Base.org does maintain a list of indexers, maybe something in there? https://docs.base.org/docs/tools/data-indexers/

https://console.cloud.google.com/marketplace/browse?filter=partner:BigQuery%20Public%20Data

Actually managed to find it in the data marketplace, worked like a charm!

Was it free? Still can't find the article I thought I read about this 😅

It was free as far as I can tell lol

Article here

Dude. You said Ethereum mainnet, and I was thinking of Base the whole time 😂  Yeah that dataset is free.

BTW, not sure if you're familiar with the billing, but be careful - they count the logical (uncompressed) bytes your query processes. So 1TB of free processing can go quickly if you are scanning everything (in your case I think you're fine since you have a nice indexed range query, but I was downloading all code contracts previously and had to be careful). IIRC it shows the logical bytes stats after the query runs.

It was free as far as I can tell lol

Article here https://cloud.google.com/blog/products/data-analytics/ethereum-bigquery-public-dataset-smart-contract-analytics

https://console.cloud.google.com/bigquery?p=bigquery-public-data&d=goog_blockchain_ethereum_mainnet_us&page=dataset