question

Upvotes
Accepted
7 6 4 5

Get minute interval data for a RIC historically

Hi,

I am trying to download 1-minute interval data for a sample RIC: `HDBK.NS`. When I do it for Aug 1, 2019 trading hours (9:15 am to 3:30 pm), I do not get all the rows. Why is it so?

Below is my code

start_time = datetime.datetime(year=2019, month=8, day=1, hour=9, minute=15, second=0)
end_time = datetime.datetime(year=2019, month=8, day=1, hour=15, minute=30, second=0)
df = ek.get_timeseries(['HDBK.NS'], interval='minute', start_date=start_time, end_date=end_time)

Below is the output of this dataframe. Note the dataframe tail does not show 1 minute data. Random time data is extracted and returned. The dataframe returns data only till 11:55 am not 3:30 pm as initially requested. Why?

HDBK.NS                 HIGH      LOW     OPEN    CLOSE  COUNT   VOLUME
Date
2019-08-01 09:15:00  2220.00  2218.15  2219.00  2218.90   40.0   5060.0
2019-08-01 09:16:00  2219.75  2217.00  2219.75  2218.00   35.0   4486.0
...........................................................................
2019-08-01 10:25:00  2221.80  2221.80  2221.80  2221.80    1.0     10.0
2019-08-01 10:28:00  2221.80  2221.80  2221.80  2221.80    1.0      1.0
2019-08-01 10:29:00  2221.80  2221.80  2221.80  2221.80    1.0      1.0
2019-08-01 11:55:00  2221.80  2221.80  2221.80  2221.80    1.0      NaN<br>
eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apipricinginterval
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.

1 Answer

· Write an Answer
Upvotes
Accepted
18.2k 21 13 21

The time return in GMT, India is GMT+5.30

You can follow this:


ahs.png (33.1 KiB)
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.