For no reason other than "because I can", I have loaded eight years worth of fuel prices for German petrol stations into a database...all 2.1 BILLION of them. What statistics would you be interested in?
Commit
2e3d7d3
How did you get the raw data? Is there a public data file or did you have to scrape it?
commit 2e3d7d3
Data has to be provided by petrol stations via an API, but it's only available to select consumers because the German Government didn't want to make it open data. tankerkoenig.de provides a CSV dump of the files, which I used for this project. I wrote about this a while back:…
TankerkönigTankerkönig: Spritpreise für alleAktuelle Spritpreise für Super E5, E10 und Diesel vergleichen und die günstigste Tankstelle in deiner Nähe finden. Kostenlos und transparent, direkt aus der amtlichen Quelle (MTS-K).
One more thing: the CSV files for the 8 years shown here are roughly 80 GB. Data goes back to 2014, I'll import that after playing around with the current amount of data. I'm still adding to the functionality of my test app, so I'll do a re-import at some point.