Content
@
0 reply
0 recast
0 reaction
Stephan
@stephancill
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
11 replies
4 recasts
20 reactions
Ryan J. Shaw
@rjs
How often do you need the data? If infrequent, BigQuery will be fast and free for this dataset.
2 replies
0 recast
2 reactions
Stephan
@stephancill
Which BigQuery dataset?
1 reply
0 recast
2 reactions
Ryan J. Shaw
@rjs
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
2 replies
0 recast
1 reaction
Stephan
@stephancill
Actually managed to find it in the data marketplace, worked like a charm!
1 reply
0 recast
1 reaction
Ryan J. Shaw
@rjs
Was it free? Still can't find the article I thought I read about this 😅
2 replies
0 recast
1 reaction
Stephan
@stephancill
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
1 reply
0 recast
1 reaction
Ryan J. Shaw
@rjs
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.
1 reply
0 recast
1 reaction
