Python code for Alphavantage api Stock Data Collection into json/csv database

Python code for Alphavantage api Stock Data Collection into json/csv database
Collecting Stocks data from alphavantage.co api

I have a paid subscription with alphavantage.co which allows me to use api to harvest data in json or csv for stocks.

i have a list of all US stocks tickers (AAPL,NVDA,NFLX,TSLA,AMZN,... etc etc) around 7000 tickers for which i want to collect data for using api on alphavantage.co

data required to be harvested shall be collected from 3 links below:

1
https://www.alphavantage.co/query?function=EARNINGS_ESTIMATES&symbol=NVDA&apikey=CZWPTL8DGI5KMW6H
2
https://www.alphavantage.co/query?function=EARNINGS&symbol=NVDA&apikey=CZWPTL8DGI5KMW6H
3
https://www.alphavantage.co/query?function=INCOME_STATEMENT&symbol=NVDA&apikey=CZWPTL8DGI5KMW6H


so, for each stock ticker : you open each link of the above 3 links then you have to collect data from the above 3 links (change NVDA to new ticker) then save the result in json or csv database.
so each stock ticker (i have 7000 tickers) will be opened in each of the 3 links above then save each result per ticker/link in a json/csv database, so you'll have to collect 7000*3 = 21000 json/csv files.

it is possible to do it in bulk and get bulk json/csv files.

please be noted that my subscription allows only for 75 api request per minute, so you have to adjust the code with delay factor to obey this api request limit.

Read here, maybe will help you for alphavantage api documentation https://www.alphavantage.co/documentation/