blog2_20190723-mlb-data-collection.py

# read in libraries 
import os
import sys
import pandas as pd
import requests

from iexfinance.stocks import Stock 
from iexfinance.refdata import get_symbols

root_dir = os.path.join(os.getcwd(), '..')
sys.path.append(root_dir)

from conf import secrets

# api key from alpha vantage 
ALPHA_VANTAGE_KEY = secrets.ALPHA_VANTAGE_KEY

# perform API call for data
function = 'TIME_SERIES_DAILY_ADJUSTED'
symbol = 'MSFT'
datatype = 'csv'
url = f"https://www.alphavantage.co/query?function={function}&symbol={symbol}&datatype={datatype}&apikey={ALPHA_VANTAGE_KEY}"

msft_raw = pd.read_csv(url)
# before making any changes save this to raw data folder
msft_raw.to_csv('../data/01_raw/msft_raw.csv', index=False)