question

Upvotes
Accepted
1 0 0 1

Historical TickHistory Data Download

We have 4200 RICs for which we want to download the tickhistory(all 364 fields) going back to 12 years. Our requirement is that the downloaded compressed file size can be of maximum 1.5GB/file but again we do not want too many (100K+) small files for our requirement. We cannot do this manually using Datascope web UI hence we are looking at REST API option.

I did some calculation 1. For 1RIC/1-day tickhistory, we need to make 12.6 million request. This will be 12.6 M files and too many requests which is not desirable. 2. For 1RIC/1-year tickhistory, we need to make 50,400 requests.How do we schedule - for each RIC and for each year, schedule a tickhistory extraction request. I also have come to know that at maximum of 50 REST calls can be made at a time, so please suggest the best strategy given that we do not want compressed file size of >1.5GB.
tick-history-rest-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
4.4k 10 6 9

Hi @vboddula

About your requirement, what if you use Byte serving, would that be ok?

Basically, you just make big requests, i.e. 1RIC/12-years. The total file size would be bigger than 1.5GB. But instead of download the whole file in one go, you just download a portion of the file at a time and then combine them to make the whole file.

Would that be a viable solution?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.