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.
Ionic/Angular Interface Redesign and Migration Category: Angular, AngularJS, API Integration, Frontend Development, HTML5, Ionic Framework, Mobile App Development, Mobile Development, PhoneGap, Version Control Git Budget: €250 - €750 EUR
23-Aug-2025 16:03 GMT
Indigenous-Inspired Coffee Bag Art Category: 2D Drawing, AI Art Creation, Art Consulting, Art Installation, Caricature & Cartoons, Graphic Design, Illustration Budget: $250 - $750 USD
23-Aug-2025 16:02 GMT
Documentary Video Editor Needed Category: Adobe Premiere Pro, After Effects, Editing, Video Editing, Video Production, YouTube Video Editing Budget: ₹600 - ₹1500 INR
Etsy Shop Manager & Marketer Category: Customer Service, Etsy, Internet Marketing, Marketing, Product Descriptions, Sales, SEO, Social Media Marketing Budget: $15 - $25 USD
23-Aug-2025 15:59 GMT
Jamaican Coffee Bag Art Category: 2D Drawing, 2D Layout, AI Art Creation, Art Installation, Graphic Design, Illustration, Photoshop Budget: $250 - $750 USD
Cameroonian Artist for Coffee Label Category: AI Art Creation, AI Image Editing, Art Installation, Fashion Design, Graphic Design, Illustration, Label Design Budget: $250 - $750 USD
23-Aug-2025 15:56 GMT
Construir un programa para Gestión de Mantenimiento Category: Android, Artificial Intelligence, C#, Programming, C++, ChatGPT, Java, Mobile App Development, N8n, R Programming Language, Web Design Budget: $30 - $250 USD
23-Aug-2025 15:56 GMT
3D Animated Financial Dialogue Category: 3D Animation, 3D Design, 3D Modelling, 3D Rendering, 3D Rigging, Animation, Blender, Maya Budget: ₹600 - ₹1500 INR
23-Aug-2025 15:56 GMT
SEO-Optimized Website Clone Build Category: Content Management System (CMS), CSS, HTML, JavaScript, PHP, SEO, Web Design, Web Development, Website Optimization, WordPress Budget: $250 - $750 USD
