BETFAIR JSON to CSV
Budget: $10 – $30 USD
For this project we want someone to extract data from Betfair historical data packages into csv files. Only horse racing packages will be used. We will provide the data file.
The files are packed as TAR files and further into .bz2. The files with the data are in JSON format. Since the packed files may contain thousands of files itself, we would like to have a user friendly method for handling these TAR files. We do not want to sit and unpack these all the time but instead just simply download the TAR-file, run the program to get a csv-file. Our main goal is to get minute by minute data for each horse before the start of the race which would mean 180 minutes of data for each horse.
The data should be presented in the csv file and display all the following fields:
market_id unique market identifier
event_date scheduled start date/time (UTC)
country event country code
track track name
market_name market name
selection_id unique runner identifier
selection_name runner name
result win/loss/removed
bsp Betfair starting price
pp_min pre play min price traded
pp_max pre play max price traded
pp_wap pre play weighted average price
pp_ltp pre play last traded price
pp_volume pre play matched volume
ip_min in play min price traded
ip_max in play max price traded
ip_wap in play weighted average price
ip_ltp in play last traded price
ip_volume in play matched volume
If you think you have the necessary skills and requirements, please get in touch with me. I'm eager to get started on this project as soon as possible. Thank you!
The files are packed as TAR files and further into .bz2. The files with the data are in JSON format. Since the packed files may contain thousands of files itself, we would like to have a user friendly method for handling these TAR files. We do not want to sit and unpack these all the time but instead just simply download the TAR-file, run the program to get a csv-file. Our main goal is to get minute by minute data for each horse before the start of the race which would mean 180 minutes of data for each horse.
The data should be presented in the csv file and display all the following fields:
market_id unique market identifier
event_date scheduled start date/time (UTC)
country event country code
track track name
market_name market name
selection_id unique runner identifier
selection_name runner name
result win/loss/removed
bsp Betfair starting price
pp_min pre play min price traded
pp_max pre play max price traded
pp_wap pre play weighted average price
pp_ltp pre play last traded price
pp_volume pre play matched volume
ip_min in play min price traded
ip_max in play max price traded
ip_wap in play weighted average price
ip_ltp in play last traded price
ip_volume in play matched volume
If you think you have the necessary skills and requirements, please get in touch with me. I'm eager to get started on this project as soon as possible. Thank you!