extended time series support about alpha_vantage HOT 5 CLOSED

I am surprised noone responded in 2 months, but I face the same problem.

After debugging sources and reading documentation, it is clear that either this endpoint never worked or alpha_vantage did a breaking change, because per doc:

...this endpoint uses the CSV format which is more memory-efficient than JSON...

This wrapper naively appends &datatype=json to the end of the uri which does work for the regular API but not extended one.

So a hotfix would be to request output_format="csv" and then pandas.from_csv for example

from alpha_vantage.

Not an API issue. I can get a response if I specify CSV format. the issue becomes converting it. as mentioned in #287 (comment) the output is a _csv.reader object so pipe it through list and then use pandas.dataframe.from_records to convert it back to pandas.

csv_list = list(_csv.reader)   
df = pandas.DataFrame.from_records(csv_list[1:], columns=csv_list[0])

As far as your API limit if you wanted to iterate through the 24 slices you can simply add a throttling delay to avoid hitting the limit.

from alpha_vantage.

if you don't have premium api key, you got only 5 API requests per minute

from alpha_vantage.

Why not implement this into the package? This solution works great

from alpha_vantage.

[2023-07] Temporarily closing this issue due to inactivity.

from alpha_vantage.