I am using TickHistoryRaw Rest API while providing few Fids in the extraction request. I am using Python and used the same tutorial logic provided in Refinitiv tutorials. The response i am saving in gzip format and then unzipping it which is csv file. Below is my Python file: Python_TickHistoryRaw.txt
When i opened csv its not formatted and the columns fields are inserted as rows which is very difficult to read and also i dont want to save this unformatted data to my Oracle databse table.
The FID Name column values normally this should be displayed in column section according to FIDS i have provided in the extraction request:
So normally for every Key/Msg Sequence Number it will be my one row...This way i can also reduce the volume of the data and i can also insert this data in my database table and which is easily readable.
When i tried to extract the csv from Refinitiv gui template: https://select.datascope.refinitiv.com/DataScope/extractions/reports/create/TickHistoryTimeAndSales
i received the same response which i am getting now.
Can anyone please help here ? Currently for one instrument i am getting almost 1.4billion records just for previous 1 day request. If i get solution i can also reduce volume.