This should be a simple fix, but I have been unable to find a cause/solution. I am running the following query:
startDate = datetime.datetime.today() - datetime.timedelta(days=365)
df = ek.get_timeseries('OTGBJFIXYZ21', start_date=startDate, interval="daily")
This works for CLOSE and COUNT (notice the count is 252). However, for HIGH, LOW, and OPEN I only get 3 values, the rest are NaN (these are the 3 most recent values). Below is the pandas.describe() output.
OTGBJFIXYZ21 CLOSE HIGH LOW OPEN COUNT
count 252.000000 3.000000 3.000000 3.000000 252.000000
mean 4.420756 4.172667 4.164867 4.167500 -0.992063
std 0.195545 0.021465 0.026670 0.022381 0.125988
min 4.033400 4.148100 4.135600 4.143500 -1.000000
25% 4.224800 4.165100 4.153400 4.157350 -1.000000
50% 4.455900 4.182100 4.171200 4.171200 -1.000000
75% 4.608025 4.184950 4.179500 4.179500 -1.000000
max 4.773200 4.187800 4.187800 4.187800 1.000000
Why is this happening and how can I get the full high/low data? Thanks so much for the help!
