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
9 replies
4 recasts
7 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
Ryan J. Shaw
@rjs
One thing I don't see on that list is Goldsky, which lets you pull parquet -- I kept having issues with the sync finishing in the past, but maybe you'll have better luck: https://www.indexed.xyz/#
0 reply
0 recast
0 reaction
Stephan
@stephancill
Actually managed to find it in the data marketplace, worked like a charm!
1 reply
0 recast
1 reaction