ALPHA VANTAGE Preprocessed Free APIs in JSON and CSV formats

Follow the Video Tutorial above for Proper Instructions then Go for the Programmes as Follows:

import requests
import pandas as pd
import datetime
import matplotlib.pyplot as plt
from matplotlib import style
import numpy as np
style.use('fivethirtyeight')
api_key=open('alpha.txt','r').read()
data=requests.get('https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&interval=1min&symbol=YESBANK&apikey={}'.format(api_key))
data=data.json()
data=data['Time Series (1min)']
df=pd.DataFrame(columns=['date','open','high','low','close','volume'])
for d,p in data.items():
    date=datetime.datetime.strptime(d,'%Y-%m-%d %H:%M:%S')
    data_row=[date,float(p['1. open']),float(p['2. high']),float(p['3. low']),float(p['4. close']),int(p['5. volume'])]
    df.loc[-1,:]=data_row
    df.index=df.index+1
data=df.sort_values('date')
data['close']=data['close'].astype(float)
data['5min']=np.round(data['close'].rolling(window=5).mean(),2)
data[['5min','close']].plot()
plt.show()