Expected duration: less than 1 week I need to collect all historical odds data for Formula 1 from the Betfair historical data feed.
https://historicdata.betfair.com
The data is free to download by selecting "Basic Plan", then "Other Sports", then selecting a date range. I need all data available (2015 to present).
The data is provided as a tar file (around 7GB) which in turn, contains a large dated folder structure containing many bz2 files. These bz2 files then contain text files in JSON format.
I need all the JSON data filtered to include only F1 data, then processed into a well-formed MSSQL database which I will then go on to interrogate myself.
Specifically, I am looking for the odds on every driver to win each Grand Prix and the date and time those odds changed. I would suggest as an absolute minimum we have a Driver table (id and name), Event table (id name, e.g. "2015 Spanish Grand Prix" or whatever Betfair call it), Odds table (eventId, driverId, oddsDateTime, odds).
Ideally I would like whatever script is developed to be handed over, aswell as the database, so I can run this at a later date myself.
If you see any issues with my proposed project, please message me.
Utopía Project Category: Graphic Design, Photography, Product Design, Social Media Marketing, Social Networking, Sound Design, Video Editing, Video Post Editing, Videography, Web Design Budget: €6 - €12 EUR
26-Aug-2025 09:55 GMT
Graphic Design for Digital Content Category: Adobe Illustrator, Photoshop, Graphic Design, Illustration, Social Media Marketing, Visual Design Budget: $10 - $30 USD
Excel VLOOKUP Inventory Assistance Category: Data Analysis, Data Entry, Data Management, Data Processing, Data Visualization, Excel, Excel VBA, Visual Basic Budget: ₹750 - ₹1250 INR
Instagram Marketing Specialist Category: Content Creation, Digital Marketing, Facebook Marketing, Graphic Design, Instagram Marketing, Social Media Marketing, Social Networking, Twitter Budget: $15 - $25 USD
26-Aug-2025 09:50 GMT
Sales Boost and Brand Awareness Campaign Category: Advertising, Digital Marketing, ECommerce, Google Ads, Google Adwords, Internet Marketing, PPC Marketing, Search Engine Marketing (SEM), SEO, Shopify Budget: ₹600 - ₹35000 INR
