question

Upvotes
Accepted
5 2 5 8

file size of TRTHv2 API Elektron TimeSeries

One of my clients would like to know rough estimate of the file size when he extracts TRTHv2 Elektron TimeSeries data (EoD history) of 1 RIC from 1996 until now. When I tried TRTH extraction via GUI, it was apprx 300KB per RIC in CSV file (selected fields are RIC, Trade Date, and Open/HIgh/Low/Close). Please advise whether or not file size per RIC via REST API would be almost same as that of GUI CSV file.

Regards,

Hiroko

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.

@hiroko.goto

Hi,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If yes please click the 'Accept' next to the 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

Hello @hiroko.goto

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?

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

Thanks,

AHS

hello @hiroko.goto,

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
13.7k 26 8 12

@hiroko.goto, if you request EoD history, the instrument volatility has no influence on the size of the result set, so the only factors that will influence the file size are:

  • The number of instruments
  • The date range
  • The number of fields

Your test gives a rough estimate of the CSV size for 1 RIC, all data since 1996 and 6 fields, you can use that.

The CSV file content and size will be the same if you request it via the GUI or the API. If you observe smaller file sizes with the API, check this advisory.

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.