Pulling Stock Data with Alpha Vantage API

import pandas as pd
import requests
import matplotlib.pyplot as plt

if not installed in your system install pandas and requests and matplotlib library library as

pip install pandas
pip install requests
pip install matplotlib

Now, we will find the URL that can communicate with Alpha Vantage. read API documentation to get the url you want. in this case we will use Daily adjusted time series data, and pull data for IBM stock.

So, Our url will look like

https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=IBM&apikey=demo

remember to replace apikey = demo to your api key.

now, lets Implement using Python:

url = 'https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=IBM&apikey=<API_KEY>'
r = requests.get(url)

When You run above code you will get the response of Success or failure.

print(f"Status Code {r.status_code}")

output:

Status Code 200

here “200” means API call is successful, now we move further.

Now, we will convert the data we received in json format and after convert it to pandas DataFrame.

data = r.json()
print(data)

df = pd.DataFrame(data['Time Series (Daily)']).T
df.head()

now, we have successfully fetch Daily Time Series Data and Stored in a dataframe, but Column name is not Suitable, So now change Column name,

df.rename(columns={"1. open": "Open",
'2. high':"High",
'3. low': "Low",
'4. close': "Close",
'5. volume':"Volume"}, inplace=True)
print(df.columns)

after renaming column name our column name will look like

Index(['Open', 'High', 'Low', 'Close', 'Volume'], dtype='object')