Provide previous day QueryStartDate and QueryEndDate in TickHistoryRawExtractionRequest Rest Api

I am using TickHistoryRawExtractionRequest Rest Api. In extraction request condition for QueryStartDate and QueryEndDate what does T12:00:00.000Z means ?

"QueryStartDate": "2021-09-02T12:00:00.000Z","QueryEndDate": "2021-09-02T12:10:00.000Z"

For example now i want to check and extract the previous whole day tick raw data so how to do that ? I am using Python coding and i always want to extract previous day(sysdate-1) whole data tick raw data as part of automated process...

Best Answer

  • Gurpreet
    Gurpreet admin
    Answer ✓

    HI @rahul.deshmukh ,

    The TRTH uses the ISO 8601 format for date. The numbers after T represent the time and Z at the end means it is UTC time zone.

    yyyy-MM-dd<strong>T</strong>HH:mm:ss.SSS<strong>Z</strong>

    UTC is the only timezone accepted in the queries. If you need data for another timezone - for.e.g. US markets, you will have to convert the local time to UTC before submitting to RTH.