Why I try to get 1 minute data by using get_history， but returned data is missing ?

Baojiayi_2025

Hi,

I am trying to get 1 minute ice brent oil price from workspace python api. I am using get_history function like this: (I live in EAST-8)

df = ld.get_history(universe='LCOcv1',start="2025-04-23",end="2025-04-24",interval="1min",count=2000000)

What I get is:

Latest data is 2024-04-23 21:59:00, seems to be UTC time, so it shall be 05:59 in my local time. But at the same time we see on Workspace the following data, which is updated to 16:34 local time. So from 06:00 - 16:34 1 minite data is missing, we can't get them. So what's wrong? Thanks in advance.

Workspace data:

Jirapongse

@Baojiayi_2025

Thank you for reaching out to us.

I used the historical pricing in content layer with the following code.

response1 = historical_pricing.summaries.Definition(
    "LCOv1", 
    interval=Intervals.MINUTE,    
    start = '2025-04-23T00:00:00', 
    end = '2025-04-24T23:59:59',
    fields=['OPEN_PRC', 'TRDPRC_1', 'HIGH_1', 'LOW_1'],
    extended_params={"summaryTimestampLabel":"endPeriod"}
).get_data()
response1.data.df

I assumed that your timezone is UTC+8.

df = response1.data.df
df[(df.index.get_level_values(0) >= '2025-04-24 08:26:00') & (df.index.get_level_values(0) <= '2025-04-24 08:34:00')][::-1]['TRDPRC_1']

The example code is on GitHub.

Baojiayi_2025

Thank you for your support. Could the data of OPINT_1 be obtained simultaneously？

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/125584#Comment_125584

Baojiayi_2025

May 7, 2025

Thank you for your support. Could the data of OPINT_1 be obtained simultaneously？

I checked and found that it doesn't support the OPINT_1 data for Intervals.MINUTE.

You can remove the fields parameter to retrieve all available fields.

Baojiayi_2025

https://community.developers.refinitiv.com/discussion/comment/125586#Comment_125586

Jirapongse

May 7, 2025

I checked and found that it doesn't support the OPINT_1 data for Intervals.MINUTE.

You can remove the fields parameter to retrieve all available fields.

I want to obtain the minute real-time OPINT_1 data of, for example, LCOv1. Can Python retrieve it?

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/125629#Comment_125629

Please contact the Historical Pricing support team via MyAccount to confirm if this field is available on the historical database.