DataImport.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# This Notebook Is for Exploring Importing Data from IEX into Apache Cassandra\n",
    "## Future works will be converted into python scripts which will be more easily 'dockerized' for managing requirements and run environments\n",
    "### Although Cassandra's advantages are more in enterprise-level write performance, I think its widespread use and compatibility with DFS will make it a better option than Mongo for any crazy timelines where this turns into anything"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import Requirements\n",
    "import requests\n",
    "import csv\n",
    "from bs4 import BeautifulSoup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Use requests session to pull Wikipedia's S&P500 list page, this will hopefully not change too much or else this might break\n",
    "session = requests.Session()\n",
    "url = 'https://en.wikipedia.org/wiki/List_of_S%26P_500_companies'\n",
    "response = session.get(url)\n",
    "#Pull the content (html) of the HTTP response object into BSoup and use the html parser\n",
    "soup = BeautifulSoup(response.content,'html.parser')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Utilize the constituents id to locate the relavant HTML info\n",
    "const_table = soup.find(id='constituents')\n",
    "#More parsing...\n",
    "table_row = const_table.find_all('tr')[1:] #Use of list indexing removes the table header which is also a tr\n",
    "#Create an empty list to receive the tickers for the S&P500 companies\n",
    "sp500 = []\n",
    "#Loop over BSoup result set, each 'row' being a BSoup object that can be further parsed into table data\n",
    "for row in table_row:\n",
    "    columns = row.find_all('td')\n",
    "    #Based on the layout of the table, the second column will contain the symbols\n",
    "    symbol_col = columns[1]\n",
    "    sp500.append(symbol_col.text)\n",
    "#Confirm the length of the list as 505\n",
    "print(len(sp500))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Write list to a csv file for durability\n",
    "with open ('./sp500.csv','w',newline='') as csvfile:\n",
    "    csvwriter = csv.writer(csvfile,delimiter=',')\n",
    "    for ticker in sp500:\n",
    "        csvwriter.writerow([ticker])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Check the csv file\n",
    "with open('./sp500.csv','r',newline='') as csvfile:\n",
    "    csvreader = csv.reader(csvfile)\n",
    "    counter = 0\n",
    "    for row in csvreader:\n",
    "        counter += 1\n",
    "        print(row, counter)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import Cassandra driver\n",
    "from cassandra.cluster import Cluster\n",
    "from cassandra.cqlengine.management import sync_table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Establish a Cluster object that will connect to the cassandra keyspace\n",
    "cluster = Cluster(['127.0.0.1'])\n",
    "session = cluster.connect()\n",
    "session.set_keyspace('sp500')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Import the ORM Model for future mapping, but I'm going to try and make this work iteratively\n",
    "from cassandra.cqlengine.models import Model\n",
    "from cassandra.cqlengine import columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Open the S&P500 csv and begin iterating over ticker symbols\n",
    "list_of_sp500 = [] #This doesn't need to be done twice, but I'm keeping the cells modular for easier copypasta later\n",
    "with open('./sp500.csv','r',newline='') as csvfile:\n",
    "    csvreader = csv.reader(csvfile)\n",
    "    for row in csvreader:\n",
    "        #Wikipedia lists the tickers with hyphens but IEX's api expects periods\n",
    "        if '-' in row[0]:\n",
    "            ticker = row[0].replace('-','.')\n",
    "            list_of_sp500.append(ticker)\n",
    "        else:\n",
    "            list_of_sp500.append(row[0]) #The reader will return an interative object so we reference the sole value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "for ticker in list_of_sp500:\n",
    "    print(ticker)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from cassandra.cqlengine import connection\n",
    "connection.setup(['127.0.0.1'],\"sp500\",protocol_version=3)\n",
    "#Define a function that will accept a ticker string and request\n",
    "# the 5 year JSON history from IEX\n",
    "def GetAndReturnJSON(ticker):\n",
    "    '''This function accepts a string corresponding to a stock ticker'''\n",
    "    #Build out the url string from the ticker for 5 year history\n",
    "    url = \"https://api.iextrading.com/1.0/stock/\"+ticker+\"/chart/5y\"\n",
    "    session = requests.Session()\n",
    "    response = session.get(url)\n",
    "    return response.json()\n",
    "\n",
    "#TODO -- Build the function that will pass the JSON into a Cassandra Model\n",
    "# and then create that row in the raw_data table\n",
    "def InsertStockData(ticker,JSON):\n",
    "    import uuid\n",
    "    #This may be an atrocious way to do this, but in the exploratory phase\n",
    "    # I'm willing to define the model within the function for right now\n",
    "    class Raw_data(Model):\n",
    "        id = columns.UUID(primary_key=True)\n",
    "        ticker = columns.Text() #This one will not be returned by IEX, but will be populated while iterating\n",
    "        change = columns.Float()\n",
    "        changeOverTime = columns.Double()\n",
    "        changePercent = columns.Float()\n",
    "        close = columns.Float()\n",
    "        date = columns.Text() #The IEX returns it as a date string, which would need to be processed later\n",
    "        high = columns.Float()\n",
    "        label = columns.Text()\n",
    "        low = columns.Float()\n",
    "        open = columns.Float()\n",
    "        unadjustedVolume = columns.BigInt()\n",
    "        volume = columns.BigInt()\n",
    "        vwap = columns.Float()\n",
    "    sync_table(Raw_data)\n",
    "    try:\n",
    "        daily_stock = Raw_data(id = uuid.uuid1(),\n",
    "             ticker=ticker,\n",
    "             change=JSON['change'],\n",
    "             changeOverTime=JSON['changeOverTime'],\n",
    "             changePercent=JSON['changePercent'],\n",
    "             close=JSON['close'],\n",
    "             date=JSON['date'],\n",
    "             high=JSON['high'],\n",
    "             label=JSON['label'],\n",
    "             low=JSON['low'],\n",
    "             open=JSON['open'],\n",
    "             unadjustedVolume=JSON['unadjustedVolume'],\n",
    "             volume=JSON['volume'],\n",
    "             vwap=JSON['vwap'])\n",
    "    except KeyError:\n",
    "        vwap=''\n",
    "        pass\n",
    "    try:\n",
    "        daily_stock.save()\n",
    "    except:\n",
    "        pass\n",
    "    return"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Grabbing 5 year stock data for MMM\n",
      "Stock data acquired, inserting into db\n",
      "Done with MMM. Currently on #1 of 505\n",
      "Grabbing 5 year stock data for ABT\n",
      "Stock data acquired, inserting into db\n",
      "Done with ABT. Currently on #2 of 505\n",
      "Grabbing 5 year stock data for ABBV\n",
      "Stock data acquired, inserting into db\n",
      "Done with ABBV. Currently on #3 of 505\n",
      "Grabbing 5 year stock data for ABMD\n",
      "Stock data acquired, inserting into db\n",
      "Done with ABMD. Currently on #4 of 505\n",
      "Grabbing 5 year stock data for ACN\n",
      "Stock data acquired, inserting into db\n",
      "Done with ACN. Currently on #5 of 505\n",
      "Grabbing 5 year stock data for ATVI\n",
      "Stock data acquired, inserting into db\n",
      "Done with ATVI. Currently on #6 of 505\n",
      "Grabbing 5 year stock data for ADBE\n",
      "Stock data acquired, inserting into db\n",
      "Done with ADBE. Currently on #7 of 505\n",
      "Grabbing 5 year stock data for AMD\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMD. Currently on #8 of 505\n",
      "Grabbing 5 year stock data for AAP\n",
      "Stock data acquired, inserting into db\n",
      "Done with AAP. Currently on #9 of 505\n",
      "Grabbing 5 year stock data for AES\n",
      "Stock data acquired, inserting into db\n",
      "Done with AES. Currently on #10 of 505\n",
      "Grabbing 5 year stock data for AMG\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMG. Currently on #11 of 505\n",
      "Grabbing 5 year stock data for AFL\n",
      "Stock data acquired, inserting into db\n",
      "Done with AFL. Currently on #12 of 505\n",
      "Grabbing 5 year stock data for A\n",
      "Stock data acquired, inserting into db\n",
      "Done with A. Currently on #13 of 505\n",
      "Grabbing 5 year stock data for APD\n",
      "Stock data acquired, inserting into db\n",
      "Done with APD. Currently on #14 of 505\n",
      "Grabbing 5 year stock data for AKAM\n",
      "Stock data acquired, inserting into db\n",
      "Done with AKAM. Currently on #15 of 505\n",
      "Grabbing 5 year stock data for ALK\n",
      "Stock data acquired, inserting into db\n",
      "Done with ALK. Currently on #16 of 505\n",
      "Grabbing 5 year stock data for ALB\n",
      "Stock data acquired, inserting into db\n",
      "Done with ALB. Currently on #17 of 505\n",
      "Grabbing 5 year stock data for ARE\n",
      "Stock data acquired, inserting into db\n",
      "Done with ARE. Currently on #18 of 505\n",
      "Grabbing 5 year stock data for ALXN\n",
      "Stock data acquired, inserting into db\n",
      "Done with ALXN. Currently on #19 of 505\n",
      "Grabbing 5 year stock data for ALGN\n",
      "Stock data acquired, inserting into db\n",
      "Done with ALGN. Currently on #20 of 505\n",
      "Grabbing 5 year stock data for ALLE\n",
      "Stock data acquired, inserting into db\n",
      "Done with ALLE. Currently on #21 of 505\n",
      "Grabbing 5 year stock data for AGN\n",
      "Stock data acquired, inserting into db\n",
      "Done with AGN. Currently on #22 of 505\n",
      "Grabbing 5 year stock data for ADS\n",
      "Stock data acquired, inserting into db\n",
      "Done with ADS. Currently on #23 of 505\n",
      "Grabbing 5 year stock data for LNT\n",
      "Stock data acquired, inserting into db\n",
      "Done with LNT. Currently on #24 of 505\n",
      "Grabbing 5 year stock data for ALL\n",
      "Stock data acquired, inserting into db\n",
      "Done with ALL. Currently on #25 of 505\n",
      "Grabbing 5 year stock data for GOOGL\n",
      "Stock data acquired, inserting into db\n",
      "Done with GOOGL. Currently on #26 of 505\n",
      "Grabbing 5 year stock data for GOOG\n",
      "Stock data acquired, inserting into db\n",
      "Done with GOOG. Currently on #27 of 505\n",
      "Grabbing 5 year stock data for MO\n",
      "Stock data acquired, inserting into db\n",
      "Done with MO. Currently on #28 of 505\n",
      "Grabbing 5 year stock data for AMZN\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMZN. Currently on #29 of 505\n",
      "Grabbing 5 year stock data for AEE\n",
      "Stock data acquired, inserting into db\n",
      "Done with AEE. Currently on #30 of 505\n",
      "Grabbing 5 year stock data for AAL\n",
      "Stock data acquired, inserting into db\n",
      "Done with AAL. Currently on #31 of 505\n",
      "Grabbing 5 year stock data for AEP\n",
      "Stock data acquired, inserting into db\n",
      "Done with AEP. Currently on #32 of 505\n",
      "Grabbing 5 year stock data for AXP\n",
      "Stock data acquired, inserting into db\n",
      "Done with AXP. Currently on #33 of 505\n",
      "Grabbing 5 year stock data for AIG\n",
      "Stock data acquired, inserting into db\n",
      "Done with AIG. Currently on #34 of 505\n",
      "Grabbing 5 year stock data for AMT\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMT. Currently on #35 of 505\n",
      "Grabbing 5 year stock data for AWK\n",
      "Stock data acquired, inserting into db\n",
      "Done with AWK. Currently on #36 of 505\n",
      "Grabbing 5 year stock data for AMP\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMP. Currently on #37 of 505\n",
      "Grabbing 5 year stock data for ABC\n",
      "Stock data acquired, inserting into db\n",
      "Done with ABC. Currently on #38 of 505\n",
      "Grabbing 5 year stock data for AME\n",
      "Stock data acquired, inserting into db\n",
      "Done with AME. Currently on #39 of 505\n",
      "Grabbing 5 year stock data for AMGN\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMGN. Currently on #40 of 505\n",
      "Grabbing 5 year stock data for APH\n",
      "Stock data acquired, inserting into db\n",
      "Done with APH. Currently on #41 of 505\n",
      "Grabbing 5 year stock data for APC\n",
      "Stock data acquired, inserting into db\n",
      "Done with APC. Currently on #42 of 505\n",
      "Grabbing 5 year stock data for ADI\n",
      "Stock data acquired, inserting into db\n",
      "Done with ADI. Currently on #43 of 505\n",
      "Grabbing 5 year stock data for ANSS\n",
      "Stock data acquired, inserting into db\n",
      "Done with ANSS. Currently on #44 of 505\n",
      "Grabbing 5 year stock data for ANTM\n",
      "Stock data acquired, inserting into db\n",
      "Done with ANTM. Currently on #45 of 505\n",
      "Grabbing 5 year stock data for AON\n",
      "Stock data acquired, inserting into db\n",
      "Done with AON. Currently on #46 of 505\n",
      "Grabbing 5 year stock data for AOS\n",
      "Stock data acquired, inserting into db\n",
      "Done with AOS. Currently on #47 of 505\n",
      "Grabbing 5 year stock data for APA\n",
      "Stock data acquired, inserting into db\n",
      "Done with APA. Currently on #48 of 505\n",
      "Grabbing 5 year stock data for AIV\n",
      "Stock data acquired, inserting into db\n",
      "Done with AIV. Currently on #49 of 505\n",
      "Grabbing 5 year stock data for AAPL\n",
      "Stock data acquired, inserting into db\n",
      "Done with AAPL. Currently on #50 of 505\n",
      "Grabbing 5 year stock data for AMAT\n",
      "Stock data acquired, inserting into db\n",
      "Done with AMAT. Currently on #51 of 505\n",
      "Grabbing 5 year stock data for APTV\n",
      "Stock data acquired, inserting into db\n",
      "Done with APTV. Currently on #52 of 505\n",
      "Grabbing 5 year stock data for ADM\n",
      "Stock data acquired, inserting into db\n",
      "Done with ADM. Currently on #53 of 505\n",
      "Grabbing 5 year stock data for ARNC\n",
      "Stock data acquired, inserting into db\n",
      "Done with ARNC. Currently on #54 of 505\n",
      "Grabbing 5 year stock data for ANET\n",
      "Stock data acquired, inserting into db\n",
      "Done with ANET. Currently on #55 of 505\n",
      "Grabbing 5 year stock data for AJG\n",
      "Stock data acquired, inserting into db\n",
      "Done with AJG. Currently on #56 of 505\n",
      "Grabbing 5 year stock data for AIZ\n",
      "Stock data acquired, inserting into db\n",
      "Done with AIZ. Currently on #57 of 505\n",
      "Grabbing 5 year stock data for ATO\n",
      "Stock data acquired, inserting into db\n",
      "Done with ATO. Currently on #58 of 505\n",
      "Grabbing 5 year stock data for T\n",
      "Stock data acquired, inserting into db\n",
      "Done with T. Currently on #59 of 505\n",
      "Grabbing 5 year stock data for ADSK\n",
      "Stock data acquired, inserting into db\n",
      "Done with ADSK. Currently on #60 of 505\n",
      "Grabbing 5 year stock data for ADP\n",
      "Stock data acquired, inserting into db\n",
      "Done with ADP. Currently on #61 of 505\n",
      "Grabbing 5 year stock data for AZO\n",
      "Stock data acquired, inserting into db\n",
      "Done with AZO. Currently on #62 of 505\n",
      "Grabbing 5 year stock data for AVB\n",
      "Stock data acquired, inserting into db\n",
      "Done with AVB. Currently on #63 of 505\n",
      "Grabbing 5 year stock data for AVY\n",
      "Stock data acquired, inserting into db\n",
      "Done with AVY. Currently on #64 of 505\n",
      "Grabbing 5 year stock data for BHGE\n",
      "Stock data acquired, inserting into db\n",
      "Done with BHGE. Currently on #65 of 505\n",
      "Grabbing 5 year stock data for BLL\n",
      "Stock data acquired, inserting into db\n",
      "Done with BLL. Currently on #66 of 505\n",
      "Grabbing 5 year stock data for BAC\n",
      "Stock data acquired, inserting into db\n",
      "Done with BAC. Currently on #67 of 505\n",
      "Grabbing 5 year stock data for BK\n",
      "Stock data acquired, inserting into db\n",
      "Done with BK. Currently on #68 of 505\n",
      "Grabbing 5 year stock data for BAX\n",
      "Stock data acquired, inserting into db\n",
      "Done with BAX. Currently on #69 of 505\n",
      "Grabbing 5 year stock data for BBT\n",
      "Stock data acquired, inserting into db\n",
      "Done with BBT. Currently on #70 of 505\n",
      "Grabbing 5 year stock data for BDX\n",
      "Stock data acquired, inserting into db\n",
      "Done with BDX. Currently on #71 of 505\n",
      "Grabbing 5 year stock data for BRK.B\n",
      "Stock data acquired, inserting into db\n",
      "Done with BRK.B. Currently on #72 of 505\n",
      "Grabbing 5 year stock data for BBY\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with BBY. Currently on #73 of 505\n",
      "Grabbing 5 year stock data for BIIB\n",
      "Stock data acquired, inserting into db\n",
      "Done with BIIB. Currently on #74 of 505\n",
      "Grabbing 5 year stock data for BLK\n",
      "Stock data acquired, inserting into db\n",
      "Done with BLK. Currently on #75 of 505\n",
      "Grabbing 5 year stock data for HRB\n",
      "Stock data acquired, inserting into db\n",
      "Done with HRB. Currently on #76 of 505\n",
      "Grabbing 5 year stock data for BA\n",
      "Stock data acquired, inserting into db\n",
      "Done with BA. Currently on #77 of 505\n",
      "Grabbing 5 year stock data for BKNG\n",
      "Stock data acquired, inserting into db\n",
      "Done with BKNG. Currently on #78 of 505\n",
      "Grabbing 5 year stock data for BWA\n",
      "Stock data acquired, inserting into db\n",
      "Done with BWA. Currently on #79 of 505\n",
      "Grabbing 5 year stock data for BXP\n",
      "Stock data acquired, inserting into db\n",
      "Done with BXP. Currently on #80 of 505\n",
      "Grabbing 5 year stock data for BSX\n",
      "Stock data acquired, inserting into db\n",
      "Done with BSX. Currently on #81 of 505\n",
      "Grabbing 5 year stock data for BHF\n",
      "Stock data acquired, inserting into db\n",
      "Done with BHF. Currently on #82 of 505\n",
      "Grabbing 5 year stock data for BMY\n",
      "Stock data acquired, inserting into db\n",
      "Done with BMY. Currently on #83 of 505\n",
      "Grabbing 5 year stock data for AVGO\n",
      "Stock data acquired, inserting into db\n",
      "Done with AVGO. Currently on #84 of 505\n",
      "Grabbing 5 year stock data for BR\n",
      "Stock data acquired, inserting into db\n",
      "Done with BR. Currently on #85 of 505\n",
      "Grabbing 5 year stock data for BF.B\n",
      "Stock data acquired, inserting into db\n",
      "Done with BF.B. Currently on #86 of 505\n",
      "Grabbing 5 year stock data for CHRW\n",
      "Stock data acquired, inserting into db\n",
      "Done with CHRW. Currently on #87 of 505\n",
      "Grabbing 5 year stock data for COG\n",
      "Stock data acquired, inserting into db\n",
      "Done with COG. Currently on #88 of 505\n",
      "Grabbing 5 year stock data for CDNS\n",
      "Stock data acquired, inserting into db\n",
      "Done with CDNS. Currently on #89 of 505\n",
      "Grabbing 5 year stock data for CPB\n",
      "Stock data acquired, inserting into db\n",
      "Done with CPB. Currently on #90 of 505\n",
      "Grabbing 5 year stock data for COF\n",
      "Stock data acquired, inserting into db\n",
      "Done with COF. Currently on #91 of 505\n",
      "Grabbing 5 year stock data for CPRI\n",
      "Stock data acquired, inserting into db\n",
      "Done with CPRI. Currently on #92 of 505\n",
      "Grabbing 5 year stock data for CAH\n",
      "Stock data acquired, inserting into db\n",
      "Done with CAH. Currently on #93 of 505\n",
      "Grabbing 5 year stock data for KMX\n",
      "Stock data acquired, inserting into db\n",
      "Done with KMX. Currently on #94 of 505\n",
      "Grabbing 5 year stock data for CCL\n",
      "Stock data acquired, inserting into db\n",
      "Done with CCL. Currently on #95 of 505\n",
      "Grabbing 5 year stock data for CAT\n",
      "Stock data acquired, inserting into db\n",
      "Done with CAT. Currently on #96 of 505\n",
      "Grabbing 5 year stock data for CBOE\n",
      "Stock data acquired, inserting into db\n",
      "Done with CBOE. Currently on #97 of 505\n",
      "Grabbing 5 year stock data for CBRE\n",
      "Stock data acquired, inserting into db\n",
      "Done with CBRE. Currently on #98 of 505\n",
      "Grabbing 5 year stock data for CBS\n",
      "Stock data acquired, inserting into db\n",
      "Done with CBS. Currently on #99 of 505\n",
      "Grabbing 5 year stock data for CE\n",
      "Stock data acquired, inserting into db\n",
      "Done with CE. Currently on #100 of 505\n",
      "Grabbing 5 year stock data for CELG\n",
      "Stock data acquired, inserting into db\n",
      "Done with CELG. Currently on #101 of 505\n",
      "Grabbing 5 year stock data for CNC\n",
      "Stock data acquired, inserting into db\n",
      "Done with CNC. Currently on #102 of 505\n",
      "Grabbing 5 year stock data for CNP\n",
      "Stock data acquired, inserting into db\n",
      "Done with CNP. Currently on #103 of 505\n",
      "Grabbing 5 year stock data for CTL\n",
      "Stock data acquired, inserting into db\n",
      "Done with CTL. Currently on #104 of 505\n",
      "Grabbing 5 year stock data for CERN\n",
      "Stock data acquired, inserting into db\n",
      "Done with CERN. Currently on #105 of 505\n",
      "Grabbing 5 year stock data for CF\n",
      "Stock data acquired, inserting into db\n",
      "Done with CF. Currently on #106 of 505\n",
      "Grabbing 5 year stock data for SCHW\n",
      "Stock data acquired, inserting into db\n",
      "Done with SCHW. Currently on #107 of 505\n",
      "Grabbing 5 year stock data for CHTR\n",
      "Stock data acquired, inserting into db\n",
      "Done with CHTR. Currently on #108 of 505\n",
      "Grabbing 5 year stock data for CVX\n",
      "Stock data acquired, inserting into db\n",
      "Done with CVX. Currently on #109 of 505\n",
      "Grabbing 5 year stock data for CMG\n",
      "Stock data acquired, inserting into db\n",
      "Done with CMG. Currently on #110 of 505\n",
      "Grabbing 5 year stock data for CB\n",
      "Stock data acquired, inserting into db\n",
      "Done with CB. Currently on #111 of 505\n",
      "Grabbing 5 year stock data for CHD\n",
      "Stock data acquired, inserting into db\n",
      "Done with CHD. Currently on #112 of 505\n",
      "Grabbing 5 year stock data for CI\n",
      "Stock data acquired, inserting into db\n",
      "Done with CI. Currently on #113 of 505\n",
      "Grabbing 5 year stock data for XEC\n",
      "Stock data acquired, inserting into db\n",
      "Done with XEC. Currently on #114 of 505\n",
      "Grabbing 5 year stock data for CINF\n",
      "Stock data acquired, inserting into db\n",
      "Done with CINF. Currently on #115 of 505\n",
      "Grabbing 5 year stock data for CTAS\n",
      "Stock data acquired, inserting into db\n",
      "Done with CTAS. Currently on #116 of 505\n",
      "Grabbing 5 year stock data for CSCO\n",
      "Stock data acquired, inserting into db\n",
      "Done with CSCO. Currently on #117 of 505\n",
      "Grabbing 5 year stock data for C\n",
      "Stock data acquired, inserting into db\n",
      "Done with C. Currently on #118 of 505\n",
      "Grabbing 5 year stock data for CFG\n",
      "Stock data acquired, inserting into db\n",
      "Done with CFG. Currently on #119 of 505\n",
      "Grabbing 5 year stock data for CTXS\n",
      "Stock data acquired, inserting into db\n",
      "Done with CTXS. Currently on #120 of 505\n",
      "Grabbing 5 year stock data for CLX\n",
      "Stock data acquired, inserting into db\n",
      "Done with CLX. Currently on #121 of 505\n",
      "Grabbing 5 year stock data for CME\n",
      "Stock data acquired, inserting into db\n",
      "Done with CME. Currently on #122 of 505\n",
      "Grabbing 5 year stock data for CMS\n",
      "Stock data acquired, inserting into db\n",
      "Done with CMS. Currently on #123 of 505\n",
      "Grabbing 5 year stock data for KO\n",
      "Stock data acquired, inserting into db\n",
      "Done with KO. Currently on #124 of 505\n",
      "Grabbing 5 year stock data for CTSH\n",
      "Stock data acquired, inserting into db\n",
      "Done with CTSH. Currently on #125 of 505\n",
      "Grabbing 5 year stock data for CL\n",
      "Stock data acquired, inserting into db\n",
      "Done with CL. Currently on #126 of 505\n",
      "Grabbing 5 year stock data for CMCSA\n",
      "Stock data acquired, inserting into db\n",
      "Done with CMCSA. Currently on #127 of 505\n",
      "Grabbing 5 year stock data for CMA\n",
      "Stock data acquired, inserting into db\n",
      "Done with CMA. Currently on #128 of 505\n",
      "Grabbing 5 year stock data for CAG\n",
      "Stock data acquired, inserting into db\n",
      "Done with CAG. Currently on #129 of 505\n",
      "Grabbing 5 year stock data for CXO\n",
      "Stock data acquired, inserting into db\n",
      "Done with CXO. Currently on #130 of 505\n",
      "Grabbing 5 year stock data for COP\n",
      "Stock data acquired, inserting into db\n",
      "Done with COP. Currently on #131 of 505\n",
      "Grabbing 5 year stock data for ED\n",
      "Stock data acquired, inserting into db\n",
      "Done with ED. Currently on #132 of 505\n",
      "Grabbing 5 year stock data for STZ\n",
      "Stock data acquired, inserting into db\n",
      "Done with STZ. Currently on #133 of 505\n",
      "Grabbing 5 year stock data for COO\n",
      "Stock data acquired, inserting into db\n",
      "Done with COO. Currently on #134 of 505\n",
      "Grabbing 5 year stock data for CPRT\n",
      "Stock data acquired, inserting into db\n",
      "Done with CPRT. Currently on #135 of 505\n",
      "Grabbing 5 year stock data for GLW\n",
      "Stock data acquired, inserting into db\n",
      "Done with GLW. Currently on #136 of 505\n",
      "Grabbing 5 year stock data for COST\n",
      "Stock data acquired, inserting into db\n",
      "Done with COST. Currently on #137 of 505\n",
      "Grabbing 5 year stock data for COTY\n",
      "Stock data acquired, inserting into db\n",
      "Done with COTY. Currently on #138 of 505\n",
      "Grabbing 5 year stock data for CCI\n",
      "Stock data acquired, inserting into db\n",
      "Done with CCI. Currently on #139 of 505\n",
      "Grabbing 5 year stock data for CSX\n",
      "Stock data acquired, inserting into db\n",
      "Done with CSX. Currently on #140 of 505\n",
      "Grabbing 5 year stock data for CMI\n",
      "Stock data acquired, inserting into db\n",
      "Done with CMI. Currently on #141 of 505\n",
      "Grabbing 5 year stock data for CVS\n",
      "Stock data acquired, inserting into db\n",
      "Done with CVS. Currently on #142 of 505\n",
      "Grabbing 5 year stock data for DHI\n",
      "Stock data acquired, inserting into db\n",
      "Done with DHI. Currently on #143 of 505\n",
      "Grabbing 5 year stock data for DHR\n",
      "Stock data acquired, inserting into db\n",
      "Done with DHR. Currently on #144 of 505\n",
      "Grabbing 5 year stock data for DRI\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with DRI. Currently on #145 of 505\n",
      "Grabbing 5 year stock data for DVA\n",
      "Stock data acquired, inserting into db\n",
      "Done with DVA. Currently on #146 of 505\n",
      "Grabbing 5 year stock data for DE\n",
      "Stock data acquired, inserting into db\n",
      "Done with DE. Currently on #147 of 505\n",
      "Grabbing 5 year stock data for DAL\n",
      "Stock data acquired, inserting into db\n",
      "Done with DAL. Currently on #148 of 505\n",
      "Grabbing 5 year stock data for XRAY\n",
      "Stock data acquired, inserting into db\n",
      "Done with XRAY. Currently on #149 of 505\n",
      "Grabbing 5 year stock data for DVN\n",
      "Stock data acquired, inserting into db\n",
      "Done with DVN. Currently on #150 of 505\n",
      "Grabbing 5 year stock data for FANG\n",
      "Stock data acquired, inserting into db\n",
      "Done with FANG. Currently on #151 of 505\n",
      "Grabbing 5 year stock data for DLR\n",
      "Stock data acquired, inserting into db\n",
      "Done with DLR. Currently on #152 of 505\n",
      "Grabbing 5 year stock data for DFS\n",
      "Stock data acquired, inserting into db\n",
      "Done with DFS. Currently on #153 of 505\n",
      "Grabbing 5 year stock data for DISCA\n",
      "Stock data acquired, inserting into db\n",
      "Done with DISCA. Currently on #154 of 505\n",
      "Grabbing 5 year stock data for DISCK\n",
      "Stock data acquired, inserting into db\n",
      "Done with DISCK. Currently on #155 of 505\n",
      "Grabbing 5 year stock data for DISH\n",
      "Stock data acquired, inserting into db\n",
      "Done with DISH. Currently on #156 of 505\n",
      "Grabbing 5 year stock data for DG\n",
      "Stock data acquired, inserting into db\n",
      "Done with DG. Currently on #157 of 505\n",
      "Grabbing 5 year stock data for DLTR\n",
      "Stock data acquired, inserting into db\n",
      "Done with DLTR. Currently on #158 of 505\n",
      "Grabbing 5 year stock data for D\n",
      "Stock data acquired, inserting into db\n",
      "Done with D. Currently on #159 of 505\n",
      "Grabbing 5 year stock data for DOV\n",
      "Stock data acquired, inserting into db\n",
      "Done with DOV. Currently on #160 of 505\n",
      "Grabbing 5 year stock data for DWDP\n",
      "Stock data acquired, inserting into db\n",
      "Done with DWDP. Currently on #161 of 505\n",
      "Grabbing 5 year stock data for DTE\n",
      "Stock data acquired, inserting into db\n",
      "Done with DTE. Currently on #162 of 505\n",
      "Grabbing 5 year stock data for DRE\n",
      "Stock data acquired, inserting into db\n",
      "Done with DRE. Currently on #163 of 505\n",
      "Grabbing 5 year stock data for DUK\n",
      "Stock data acquired, inserting into db\n",
      "Done with DUK. Currently on #164 of 505\n",
      "Grabbing 5 year stock data for DXC\n",
      "Stock data acquired, inserting into db\n",
      "Done with DXC. Currently on #165 of 505\n",
      "Grabbing 5 year stock data for ETFC\n",
      "Stock data acquired, inserting into db\n",
      "Done with ETFC. Currently on #166 of 505\n",
      "Grabbing 5 year stock data for EMN\n",
      "Stock data acquired, inserting into db\n",
      "Done with EMN. Currently on #167 of 505\n",
      "Grabbing 5 year stock data for ETN\n",
      "Stock data acquired, inserting into db\n",
      "Done with ETN. Currently on #168 of 505\n",
      "Grabbing 5 year stock data for EBAY\n",
      "Stock data acquired, inserting into db\n",
      "Done with EBAY. Currently on #169 of 505\n",
      "Grabbing 5 year stock data for ECL\n",
      "Stock data acquired, inserting into db\n",
      "Done with ECL. Currently on #170 of 505\n",
      "Grabbing 5 year stock data for EIX\n",
      "Stock data acquired, inserting into db\n",
      "Done with EIX. Currently on #171 of 505\n",
      "Grabbing 5 year stock data for EW\n",
      "Stock data acquired, inserting into db\n",
      "Done with EW. Currently on #172 of 505\n",
      "Grabbing 5 year stock data for EA\n",
      "Stock data acquired, inserting into db\n",
      "Done with EA. Currently on #173 of 505\n",
      "Grabbing 5 year stock data for EMR\n",
      "Stock data acquired, inserting into db\n",
      "Done with EMR. Currently on #174 of 505\n",
      "Grabbing 5 year stock data for ETR\n",
      "Stock data acquired, inserting into db\n",
      "Done with ETR. Currently on #175 of 505\n",
      "Grabbing 5 year stock data for EOG\n",
      "Stock data acquired, inserting into db\n",
      "Done with EOG. Currently on #176 of 505\n",
      "Grabbing 5 year stock data for EFX\n",
      "Stock data acquired, inserting into db\n",
      "Done with EFX. Currently on #177 of 505\n",
      "Grabbing 5 year stock data for EQIX\n",
      "Stock data acquired, inserting into db\n",
      "Done with EQIX. Currently on #178 of 505\n",
      "Grabbing 5 year stock data for EQR\n",
      "Stock data acquired, inserting into db\n",
      "Done with EQR. Currently on #179 of 505\n",
      "Grabbing 5 year stock data for ESS\n",
      "Stock data acquired, inserting into db\n",
      "Done with ESS. Currently on #180 of 505\n",
      "Grabbing 5 year stock data for EL\n",
      "Stock data acquired, inserting into db\n",
      "Done with EL. Currently on #181 of 505\n",
      "Grabbing 5 year stock data for EVRG\n",
      "Stock data acquired, inserting into db\n",
      "Done with EVRG. Currently on #182 of 505\n",
      "Grabbing 5 year stock data for ES\n",
      "Stock data acquired, inserting into db\n",
      "Done with ES. Currently on #183 of 505\n",
      "Grabbing 5 year stock data for RE\n",
      "Stock data acquired, inserting into db\n",
      "Done with RE. Currently on #184 of 505\n",
      "Grabbing 5 year stock data for EXC\n",
      "Stock data acquired, inserting into db\n",
      "Done with EXC. Currently on #185 of 505\n",
      "Grabbing 5 year stock data for EXPE\n",
      "Stock data acquired, inserting into db\n",
      "Done with EXPE. Currently on #186 of 505\n",
      "Grabbing 5 year stock data for EXPD\n",
      "Stock data acquired, inserting into db\n",
      "Done with EXPD. Currently on #187 of 505\n",
      "Grabbing 5 year stock data for EXR\n",
      "Stock data acquired, inserting into db\n",
      "Done with EXR. Currently on #188 of 505\n",
      "Grabbing 5 year stock data for XOM\n",
      "Stock data acquired, inserting into db\n",
      "Done with XOM. Currently on #189 of 505\n",
      "Grabbing 5 year stock data for FFIV\n",
      "Stock data acquired, inserting into db\n",
      "Done with FFIV. Currently on #190 of 505\n",
      "Grabbing 5 year stock data for FB\n",
      "Stock data acquired, inserting into db\n",
      "Done with FB. Currently on #191 of 505\n",
      "Grabbing 5 year stock data for FAST\n",
      "Stock data acquired, inserting into db\n",
      "Done with FAST. Currently on #192 of 505\n",
      "Grabbing 5 year stock data for FRT\n",
      "Stock data acquired, inserting into db\n",
      "Done with FRT. Currently on #193 of 505\n",
      "Grabbing 5 year stock data for FDX\n",
      "Stock data acquired, inserting into db\n",
      "Done with FDX. Currently on #194 of 505\n",
      "Grabbing 5 year stock data for FIS\n",
      "Stock data acquired, inserting into db\n",
      "Done with FIS. Currently on #195 of 505\n",
      "Grabbing 5 year stock data for FITB\n",
      "Stock data acquired, inserting into db\n",
      "Done with FITB. Currently on #196 of 505\n",
      "Grabbing 5 year stock data for FE\n",
      "Stock data acquired, inserting into db\n",
      "Done with FE. Currently on #197 of 505\n",
      "Grabbing 5 year stock data for FRC\n",
      "Stock data acquired, inserting into db\n",
      "Done with FRC. Currently on #198 of 505\n",
      "Grabbing 5 year stock data for FISV\n",
      "Stock data acquired, inserting into db\n",
      "Done with FISV. Currently on #199 of 505\n",
      "Grabbing 5 year stock data for FLT\n",
      "Stock data acquired, inserting into db\n",
      "Done with FLT. Currently on #200 of 505\n",
      "Grabbing 5 year stock data for FLIR\n",
      "Stock data acquired, inserting into db\n",
      "Done with FLIR. Currently on #201 of 505\n",
      "Grabbing 5 year stock data for FLS\n",
      "Stock data acquired, inserting into db\n",
      "Done with FLS. Currently on #202 of 505\n",
      "Grabbing 5 year stock data for FLR\n",
      "Stock data acquired, inserting into db\n",
      "Done with FLR. Currently on #203 of 505\n",
      "Grabbing 5 year stock data for FMC\n",
      "Stock data acquired, inserting into db\n",
      "Done with FMC. Currently on #204 of 505\n",
      "Grabbing 5 year stock data for FL\n",
      "Stock data acquired, inserting into db\n",
      "Done with FL. Currently on #205 of 505\n",
      "Grabbing 5 year stock data for F\n",
      "Stock data acquired, inserting into db\n",
      "Done with F. Currently on #206 of 505\n",
      "Grabbing 5 year stock data for FTNT\n",
      "Stock data acquired, inserting into db\n",
      "Done with FTNT. Currently on #207 of 505\n",
      "Grabbing 5 year stock data for FTV\n",
      "Stock data acquired, inserting into db\n",
      "Done with FTV. Currently on #208 of 505\n",
      "Grabbing 5 year stock data for FBHS\n",
      "Stock data acquired, inserting into db\n",
      "Done with FBHS. Currently on #209 of 505\n",
      "Grabbing 5 year stock data for BEN\n",
      "Stock data acquired, inserting into db\n",
      "Done with BEN. Currently on #210 of 505\n",
      "Grabbing 5 year stock data for FCX\n",
      "Stock data acquired, inserting into db\n",
      "Done with FCX. Currently on #211 of 505\n",
      "Grabbing 5 year stock data for GPS\n",
      "Stock data acquired, inserting into db\n",
      "Done with GPS. Currently on #212 of 505\n",
      "Grabbing 5 year stock data for GRMN\n",
      "Stock data acquired, inserting into db\n",
      "Done with GRMN. Currently on #213 of 505\n",
      "Grabbing 5 year stock data for IT\n",
      "Stock data acquired, inserting into db\n",
      "Done with IT. Currently on #214 of 505\n",
      "Grabbing 5 year stock data for GD\n",
      "Stock data acquired, inserting into db\n",
      "Done with GD. Currently on #215 of 505\n",
      "Grabbing 5 year stock data for GE\n",
      "Stock data acquired, inserting into db\n",
      "Done with GE. Currently on #216 of 505\n",
      "Grabbing 5 year stock data for GIS\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with GIS. Currently on #217 of 505\n",
      "Grabbing 5 year stock data for GM\n",
      "Stock data acquired, inserting into db\n",
      "Done with GM. Currently on #218 of 505\n",
      "Grabbing 5 year stock data for GPC\n",
      "Stock data acquired, inserting into db\n",
      "Done with GPC. Currently on #219 of 505\n",
      "Grabbing 5 year stock data for GILD\n",
      "Stock data acquired, inserting into db\n",
      "Done with GILD. Currently on #220 of 505\n",
      "Grabbing 5 year stock data for GPN\n",
      "Stock data acquired, inserting into db\n",
      "Done with GPN. Currently on #221 of 505\n",
      "Grabbing 5 year stock data for GS\n",
      "Stock data acquired, inserting into db\n",
      "Done with GS. Currently on #222 of 505\n",
      "Grabbing 5 year stock data for GT\n",
      "Stock data acquired, inserting into db\n",
      "Done with GT. Currently on #223 of 505\n",
      "Grabbing 5 year stock data for GWW\n",
      "Stock data acquired, inserting into db\n",
      "Done with GWW. Currently on #224 of 505\n",
      "Grabbing 5 year stock data for HAL\n",
      "Stock data acquired, inserting into db\n",
      "Done with HAL. Currently on #225 of 505\n",
      "Grabbing 5 year stock data for HBI\n",
      "Stock data acquired, inserting into db\n",
      "Done with HBI. Currently on #226 of 505\n",
      "Grabbing 5 year stock data for HOG\n",
      "Stock data acquired, inserting into db\n",
      "Done with HOG. Currently on #227 of 505\n",
      "Grabbing 5 year stock data for HRS\n",
      "Stock data acquired, inserting into db\n",
      "Done with HRS. Currently on #228 of 505\n",
      "Grabbing 5 year stock data for HIG\n",
      "Stock data acquired, inserting into db\n",
      "Done with HIG. Currently on #229 of 505\n",
      "Grabbing 5 year stock data for HAS\n",
      "Stock data acquired, inserting into db\n",
      "Done with HAS. Currently on #230 of 505\n",
      "Grabbing 5 year stock data for HCA\n",
      "Stock data acquired, inserting into db\n",
      "Done with HCA. Currently on #231 of 505\n",
      "Grabbing 5 year stock data for HCP\n",
      "Stock data acquired, inserting into db\n",
      "Done with HCP. Currently on #232 of 505\n",
      "Grabbing 5 year stock data for HP\n",
      "Stock data acquired, inserting into db\n",
      "Done with HP. Currently on #233 of 505\n",
      "Grabbing 5 year stock data for HSIC\n",
      "Stock data acquired, inserting into db\n",
      "Done with HSIC. Currently on #234 of 505\n",
      "Grabbing 5 year stock data for HSY\n",
      "Stock data acquired, inserting into db\n",
      "Done with HSY. Currently on #235 of 505\n",
      "Grabbing 5 year stock data for HES\n",
      "Stock data acquired, inserting into db\n",
      "Done with HES. Currently on #236 of 505\n",
      "Grabbing 5 year stock data for HPE\n",
      "Stock data acquired, inserting into db\n",
      "Done with HPE. Currently on #237 of 505\n",
      "Grabbing 5 year stock data for HLT\n",
      "Stock data acquired, inserting into db\n",
      "Done with HLT. Currently on #238 of 505\n",
      "Grabbing 5 year stock data for HFC\n",
      "Stock data acquired, inserting into db\n",
      "Done with HFC. Currently on #239 of 505\n",
      "Grabbing 5 year stock data for HOLX\n",
      "Stock data acquired, inserting into db\n",
      "Done with HOLX. Currently on #240 of 505\n",
      "Grabbing 5 year stock data for HD\n",
      "Stock data acquired, inserting into db\n",
      "Done with HD. Currently on #241 of 505\n",
      "Grabbing 5 year stock data for HON\n",
      "Stock data acquired, inserting into db\n",
      "Done with HON. Currently on #242 of 505\n",
      "Grabbing 5 year stock data for HRL\n",
      "Stock data acquired, inserting into db\n",
      "Done with HRL. Currently on #243 of 505\n",
      "Grabbing 5 year stock data for HST\n",
      "Stock data acquired, inserting into db\n",
      "Done with HST. Currently on #244 of 505\n",
      "Grabbing 5 year stock data for HPQ\n",
      "Stock data acquired, inserting into db\n",
      "Done with HPQ. Currently on #245 of 505\n",
      "Grabbing 5 year stock data for HUM\n",
      "Stock data acquired, inserting into db\n",
      "Done with HUM. Currently on #246 of 505\n",
      "Grabbing 5 year stock data for HBAN\n",
      "Stock data acquired, inserting into db\n",
      "Done with HBAN. Currently on #247 of 505\n",
      "Grabbing 5 year stock data for HII\n",
      "Stock data acquired, inserting into db\n",
      "Done with HII. Currently on #248 of 505\n",
      "Grabbing 5 year stock data for IDXX\n",
      "Stock data acquired, inserting into db\n",
      "Done with IDXX. Currently on #249 of 505\n",
      "Grabbing 5 year stock data for INFO\n",
      "Stock data acquired, inserting into db\n",
      "Done with INFO. Currently on #250 of 505\n",
      "Grabbing 5 year stock data for ITW\n",
      "Stock data acquired, inserting into db\n",
      "Done with ITW. Currently on #251 of 505\n",
      "Grabbing 5 year stock data for ILMN\n",
      "Stock data acquired, inserting into db\n",
      "Done with ILMN. Currently on #252 of 505\n",
      "Grabbing 5 year stock data for IR\n",
      "Stock data acquired, inserting into db\n",
      "Done with IR. Currently on #253 of 505\n",
      "Grabbing 5 year stock data for INTC\n",
      "Stock data acquired, inserting into db\n",
      "Done with INTC. Currently on #254 of 505\n",
      "Grabbing 5 year stock data for ICE\n",
      "Stock data acquired, inserting into db\n",
      "Done with ICE. Currently on #255 of 505\n",
      "Grabbing 5 year stock data for IBM\n",
      "Stock data acquired, inserting into db\n",
      "Done with IBM. Currently on #256 of 505\n",
      "Grabbing 5 year stock data for INCY\n",
      "Stock data acquired, inserting into db\n",
      "Done with INCY. Currently on #257 of 505\n",
      "Grabbing 5 year stock data for IP\n",
      "Stock data acquired, inserting into db\n",
      "Done with IP. Currently on #258 of 505\n",
      "Grabbing 5 year stock data for IPG\n",
      "Stock data acquired, inserting into db\n",
      "Done with IPG. Currently on #259 of 505\n",
      "Grabbing 5 year stock data for IFF\n",
      "Stock data acquired, inserting into db\n",
      "Done with IFF. Currently on #260 of 505\n",
      "Grabbing 5 year stock data for INTU\n",
      "Stock data acquired, inserting into db\n",
      "Done with INTU. Currently on #261 of 505\n",
      "Grabbing 5 year stock data for ISRG\n",
      "Stock data acquired, inserting into db\n",
      "Done with ISRG. Currently on #262 of 505\n",
      "Grabbing 5 year stock data for IVZ\n",
      "Stock data acquired, inserting into db\n",
      "Done with IVZ. Currently on #263 of 505\n",
      "Grabbing 5 year stock data for IPGP\n",
      "Stock data acquired, inserting into db\n",
      "Done with IPGP. Currently on #264 of 505\n",
      "Grabbing 5 year stock data for IQV\n",
      "Stock data acquired, inserting into db\n",
      "Done with IQV. Currently on #265 of 505\n",
      "Grabbing 5 year stock data for IRM\n",
      "Stock data acquired, inserting into db\n",
      "Done with IRM. Currently on #266 of 505\n",
      "Grabbing 5 year stock data for JKHY\n",
      "Stock data acquired, inserting into db\n",
      "Done with JKHY. Currently on #267 of 505\n",
      "Grabbing 5 year stock data for JEC\n",
      "Stock data acquired, inserting into db\n",
      "Done with JEC. Currently on #268 of 505\n",
      "Grabbing 5 year stock data for JBHT\n",
      "Stock data acquired, inserting into db\n",
      "Done with JBHT. Currently on #269 of 505\n",
      "Grabbing 5 year stock data for JEF\n",
      "Stock data acquired, inserting into db\n",
      "Done with JEF. Currently on #270 of 505\n",
      "Grabbing 5 year stock data for SJM\n",
      "Stock data acquired, inserting into db\n",
      "Done with SJM. Currently on #271 of 505\n",
      "Grabbing 5 year stock data for JNJ\n",
      "Stock data acquired, inserting into db\n",
      "Done with JNJ. Currently on #272 of 505\n",
      "Grabbing 5 year stock data for JCI\n",
      "Stock data acquired, inserting into db\n",
      "Done with JCI. Currently on #273 of 505\n",
      "Grabbing 5 year stock data for JPM\n",
      "Stock data acquired, inserting into db\n",
      "Done with JPM. Currently on #274 of 505\n",
      "Grabbing 5 year stock data for JNPR\n",
      "Stock data acquired, inserting into db\n",
      "Done with JNPR. Currently on #275 of 505\n",
      "Grabbing 5 year stock data for KSU\n",
      "Stock data acquired, inserting into db\n",
      "Done with KSU. Currently on #276 of 505\n",
      "Grabbing 5 year stock data for K\n",
      "Stock data acquired, inserting into db\n",
      "Done with K. Currently on #277 of 505\n",
      "Grabbing 5 year stock data for KEY\n",
      "Stock data acquired, inserting into db\n",
      "Done with KEY. Currently on #278 of 505\n",
      "Grabbing 5 year stock data for KEYS\n",
      "Stock data acquired, inserting into db\n",
      "Done with KEYS. Currently on #279 of 505\n",
      "Grabbing 5 year stock data for KMB\n",
      "Stock data acquired, inserting into db\n",
      "Done with KMB. Currently on #280 of 505\n",
      "Grabbing 5 year stock data for KIM\n",
      "Stock data acquired, inserting into db\n",
      "Done with KIM. Currently on #281 of 505\n",
      "Grabbing 5 year stock data for KMI\n",
      "Stock data acquired, inserting into db\n",
      "Done with KMI. Currently on #282 of 505\n",
      "Grabbing 5 year stock data for KLAC\n",
      "Stock data acquired, inserting into db\n",
      "Done with KLAC. Currently on #283 of 505\n",
      "Grabbing 5 year stock data for KSS\n",
      "Stock data acquired, inserting into db\n",
      "Done with KSS. Currently on #284 of 505\n",
      "Grabbing 5 year stock data for KHC\n",
      "Stock data acquired, inserting into db\n",
      "Done with KHC. Currently on #285 of 505\n",
      "Grabbing 5 year stock data for KR\n",
      "Stock data acquired, inserting into db\n",
      "Done with KR. Currently on #286 of 505\n",
      "Grabbing 5 year stock data for LB\n",
      "Stock data acquired, inserting into db\n",
      "Done with LB. Currently on #287 of 505\n",
      "Grabbing 5 year stock data for LLL\n",
      "Stock data acquired, inserting into db\n",
      "Done with LLL. Currently on #288 of 505\n",
      "Grabbing 5 year stock data for LH\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with LH. Currently on #289 of 505\n",
      "Grabbing 5 year stock data for LRCX\n",
      "Stock data acquired, inserting into db\n",
      "Done with LRCX. Currently on #290 of 505\n",
      "Grabbing 5 year stock data for LW\n",
      "Stock data acquired, inserting into db\n",
      "Done with LW. Currently on #291 of 505\n",
      "Grabbing 5 year stock data for LEG\n",
      "Stock data acquired, inserting into db\n",
      "Done with LEG. Currently on #292 of 505\n",
      "Grabbing 5 year stock data for LEN\n",
      "Stock data acquired, inserting into db\n",
      "Done with LEN. Currently on #293 of 505\n",
      "Grabbing 5 year stock data for LLY\n",
      "Stock data acquired, inserting into db\n",
      "Done with LLY. Currently on #294 of 505\n",
      "Grabbing 5 year stock data for LNC\n",
      "Stock data acquired, inserting into db\n",
      "Done with LNC. Currently on #295 of 505\n",
      "Grabbing 5 year stock data for LIN\n",
      "Stock data acquired, inserting into db\n",
      "Done with LIN. Currently on #296 of 505\n",
      "Grabbing 5 year stock data for LKQ\n",
      "Stock data acquired, inserting into db\n",
      "Done with LKQ. Currently on #297 of 505\n",
      "Grabbing 5 year stock data for LMT\n",
      "Stock data acquired, inserting into db\n",
      "Done with LMT. Currently on #298 of 505\n",
      "Grabbing 5 year stock data for L\n",
      "Stock data acquired, inserting into db\n",
      "Done with L. Currently on #299 of 505\n",
      "Grabbing 5 year stock data for LOW\n",
      "Stock data acquired, inserting into db\n",
      "Done with LOW. Currently on #300 of 505\n",
      "Grabbing 5 year stock data for LYB\n",
      "Stock data acquired, inserting into db\n",
      "Done with LYB. Currently on #301 of 505\n",
      "Grabbing 5 year stock data for MTB\n",
      "Stock data acquired, inserting into db\n",
      "Done with MTB. Currently on #302 of 505\n",
      "Grabbing 5 year stock data for MAC\n",
      "Stock data acquired, inserting into db\n",
      "Done with MAC. Currently on #303 of 505\n",
      "Grabbing 5 year stock data for M\n",
      "Stock data acquired, inserting into db\n",
      "Done with M. Currently on #304 of 505\n",
      "Grabbing 5 year stock data for MRO\n",
      "Stock data acquired, inserting into db\n",
      "Done with MRO. Currently on #305 of 505\n",
      "Grabbing 5 year stock data for MPC\n",
      "Stock data acquired, inserting into db\n",
      "Done with MPC. Currently on #306 of 505\n",
      "Grabbing 5 year stock data for MAR\n",
      "Stock data acquired, inserting into db\n",
      "Done with MAR. Currently on #307 of 505\n",
      "Grabbing 5 year stock data for MMC\n",
      "Stock data acquired, inserting into db\n",
      "Done with MMC. Currently on #308 of 505\n",
      "Grabbing 5 year stock data for MLM\n",
      "Stock data acquired, inserting into db\n",
      "Done with MLM. Currently on #309 of 505\n",
      "Grabbing 5 year stock data for MAS\n",
      "Stock data acquired, inserting into db\n",
      "Done with MAS. Currently on #310 of 505\n",
      "Grabbing 5 year stock data for MA\n",
      "Stock data acquired, inserting into db\n",
      "Done with MA. Currently on #311 of 505\n",
      "Grabbing 5 year stock data for MAT\n",
      "Stock data acquired, inserting into db\n",
      "Done with MAT. Currently on #312 of 505\n",
      "Grabbing 5 year stock data for MKC\n",
      "Stock data acquired, inserting into db\n",
      "Done with MKC. Currently on #313 of 505\n",
      "Grabbing 5 year stock data for MXIM\n",
      "Stock data acquired, inserting into db\n",
      "Done with MXIM. Currently on #314 of 505\n",
      "Grabbing 5 year stock data for MCD\n",
      "Stock data acquired, inserting into db\n",
      "Done with MCD. Currently on #315 of 505\n",
      "Grabbing 5 year stock data for MCK\n",
      "Stock data acquired, inserting into db\n",
      "Done with MCK. Currently on #316 of 505\n",
      "Grabbing 5 year stock data for MDT\n",
      "Stock data acquired, inserting into db\n",
      "Done with MDT. Currently on #317 of 505\n",
      "Grabbing 5 year stock data for MRK\n",
      "Stock data acquired, inserting into db\n",
      "Done with MRK. Currently on #318 of 505\n",
      "Grabbing 5 year stock data for MET\n",
      "Stock data acquired, inserting into db\n",
      "Done with MET. Currently on #319 of 505\n",
      "Grabbing 5 year stock data for MTD\n",
      "Stock data acquired, inserting into db\n",
      "Done with MTD. Currently on #320 of 505\n",
      "Grabbing 5 year stock data for MGM\n",
      "Stock data acquired, inserting into db\n",
      "Done with MGM. Currently on #321 of 505\n",
      "Grabbing 5 year stock data for MCHP\n",
      "Stock data acquired, inserting into db\n",
      "Done with MCHP. Currently on #322 of 505\n",
      "Grabbing 5 year stock data for MU\n",
      "Stock data acquired, inserting into db\n",
      "Done with MU. Currently on #323 of 505\n",
      "Grabbing 5 year stock data for MSFT\n",
      "Stock data acquired, inserting into db\n",
      "Done with MSFT. Currently on #324 of 505\n",
      "Grabbing 5 year stock data for MAA\n",
      "Stock data acquired, inserting into db\n",
      "Done with MAA. Currently on #325 of 505\n",
      "Grabbing 5 year stock data for MHK\n",
      "Stock data acquired, inserting into db\n",
      "Done with MHK. Currently on #326 of 505\n",
      "Grabbing 5 year stock data for TAP\n",
      "Stock data acquired, inserting into db\n",
      "Done with TAP. Currently on #327 of 505\n",
      "Grabbing 5 year stock data for MDLZ\n",
      "Stock data acquired, inserting into db\n",
      "Done with MDLZ. Currently on #328 of 505\n",
      "Grabbing 5 year stock data for MNST\n",
      "Stock data acquired, inserting into db\n",
      "Done with MNST. Currently on #329 of 505\n",
      "Grabbing 5 year stock data for MCO\n",
      "Stock data acquired, inserting into db\n",
      "Done with MCO. Currently on #330 of 505\n",
      "Grabbing 5 year stock data for MS\n",
      "Stock data acquired, inserting into db\n",
      "Done with MS. Currently on #331 of 505\n",
      "Grabbing 5 year stock data for MOS\n",
      "Stock data acquired, inserting into db\n",
      "Done with MOS. Currently on #332 of 505\n",
      "Grabbing 5 year stock data for MSI\n",
      "Stock data acquired, inserting into db\n",
      "Done with MSI. Currently on #333 of 505\n",
      "Grabbing 5 year stock data for MSCI\n",
      "Stock data acquired, inserting into db\n",
      "Done with MSCI. Currently on #334 of 505\n",
      "Grabbing 5 year stock data for MYL\n",
      "Stock data acquired, inserting into db\n",
      "Done with MYL. Currently on #335 of 505\n",
      "Grabbing 5 year stock data for NDAQ\n",
      "Stock data acquired, inserting into db\n",
      "Done with NDAQ. Currently on #336 of 505\n",
      "Grabbing 5 year stock data for NOV\n",
      "Stock data acquired, inserting into db\n",
      "Done with NOV. Currently on #337 of 505\n",
      "Grabbing 5 year stock data for NKTR\n",
      "Stock data acquired, inserting into db\n",
      "Done with NKTR. Currently on #338 of 505\n",
      "Grabbing 5 year stock data for NTAP\n",
      "Stock data acquired, inserting into db\n",
      "Done with NTAP. Currently on #339 of 505\n",
      "Grabbing 5 year stock data for NFLX\n",
      "Stock data acquired, inserting into db\n",
      "Done with NFLX. Currently on #340 of 505\n",
      "Grabbing 5 year stock data for NWL\n",
      "Stock data acquired, inserting into db\n",
      "Done with NWL. Currently on #341 of 505\n",
      "Grabbing 5 year stock data for NEM\n",
      "Stock data acquired, inserting into db\n",
      "Done with NEM. Currently on #342 of 505\n",
      "Grabbing 5 year stock data for NWSA\n",
      "Stock data acquired, inserting into db\n",
      "Done with NWSA. Currently on #343 of 505\n",
      "Grabbing 5 year stock data for NWS\n",
      "Stock data acquired, inserting into db\n",
      "Done with NWS. Currently on #344 of 505\n",
      "Grabbing 5 year stock data for NEE\n",
      "Stock data acquired, inserting into db\n",
      "Done with NEE. Currently on #345 of 505\n",
      "Grabbing 5 year stock data for NLSN\n",
      "Stock data acquired, inserting into db\n",
      "Done with NLSN. Currently on #346 of 505\n",
      "Grabbing 5 year stock data for NKE\n",
      "Stock data acquired, inserting into db\n",
      "Done with NKE. Currently on #347 of 505\n",
      "Grabbing 5 year stock data for NI\n",
      "Stock data acquired, inserting into db\n",
      "Done with NI. Currently on #348 of 505\n",
      "Grabbing 5 year stock data for NBL\n",
      "Stock data acquired, inserting into db\n",
      "Done with NBL. Currently on #349 of 505\n",
      "Grabbing 5 year stock data for JWN\n",
      "Stock data acquired, inserting into db\n",
      "Done with JWN. Currently on #350 of 505\n",
      "Grabbing 5 year stock data for NSC\n",
      "Stock data acquired, inserting into db\n",
      "Done with NSC. Currently on #351 of 505\n",
      "Grabbing 5 year stock data for NTRS\n",
      "Stock data acquired, inserting into db\n",
      "Done with NTRS. Currently on #352 of 505\n",
      "Grabbing 5 year stock data for NOC\n",
      "Stock data acquired, inserting into db\n",
      "Done with NOC. Currently on #353 of 505\n",
      "Grabbing 5 year stock data for NCLH\n",
      "Stock data acquired, inserting into db\n",
      "Done with NCLH. Currently on #354 of 505\n",
      "Grabbing 5 year stock data for NRG\n",
      "Stock data acquired, inserting into db\n",
      "Done with NRG. Currently on #355 of 505\n",
      "Grabbing 5 year stock data for NUE\n",
      "Stock data acquired, inserting into db\n",
      "Done with NUE. Currently on #356 of 505\n",
      "Grabbing 5 year stock data for NVDA\n",
      "Stock data acquired, inserting into db\n",
      "Done with NVDA. Currently on #357 of 505\n",
      "Grabbing 5 year stock data for ORLY\n",
      "Stock data acquired, inserting into db\n",
      "Done with ORLY. Currently on #358 of 505\n",
      "Grabbing 5 year stock data for OXY\n",
      "Stock data acquired, inserting into db\n",
      "Done with OXY. Currently on #359 of 505\n",
      "Grabbing 5 year stock data for OMC\n",
      "Stock data acquired, inserting into db\n",
      "Done with OMC. Currently on #360 of 505\n",
      "Grabbing 5 year stock data for OKE\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with OKE. Currently on #361 of 505\n",
      "Grabbing 5 year stock data for ORCL\n",
      "Stock data acquired, inserting into db\n",
      "Done with ORCL. Currently on #362 of 505\n",
      "Grabbing 5 year stock data for PCAR\n",
      "Stock data acquired, inserting into db\n",
      "Done with PCAR. Currently on #363 of 505\n",
      "Grabbing 5 year stock data for PKG\n",
      "Stock data acquired, inserting into db\n",
      "Done with PKG. Currently on #364 of 505\n",
      "Grabbing 5 year stock data for PH\n",
      "Stock data acquired, inserting into db\n",
      "Done with PH. Currently on #365 of 505\n",
      "Grabbing 5 year stock data for PAYX\n",
      "Stock data acquired, inserting into db\n",
      "Done with PAYX. Currently on #366 of 505\n",
      "Grabbing 5 year stock data for PYPL\n",
      "Stock data acquired, inserting into db\n",
      "Done with PYPL. Currently on #367 of 505\n",
      "Grabbing 5 year stock data for PNR\n",
      "Stock data acquired, inserting into db\n",
      "Done with PNR. Currently on #368 of 505\n",
      "Grabbing 5 year stock data for PBCT\n",
      "Stock data acquired, inserting into db\n",
      "Done with PBCT. Currently on #369 of 505\n",
      "Grabbing 5 year stock data for PEP\n",
      "Stock data acquired, inserting into db\n",
      "Done with PEP. Currently on #370 of 505\n",
      "Grabbing 5 year stock data for PKI\n",
      "Stock data acquired, inserting into db\n",
      "Done with PKI. Currently on #371 of 505\n",
      "Grabbing 5 year stock data for PRGO\n",
      "Stock data acquired, inserting into db\n",
      "Done with PRGO. Currently on #372 of 505\n",
      "Grabbing 5 year stock data for PFE\n",
      "Stock data acquired, inserting into db\n",
      "Done with PFE. Currently on #373 of 505\n",
      "Grabbing 5 year stock data for PM\n",
      "Stock data acquired, inserting into db\n",
      "Done with PM. Currently on #374 of 505\n",
      "Grabbing 5 year stock data for PSX\n",
      "Stock data acquired, inserting into db\n",
      "Done with PSX. Currently on #375 of 505\n",
      "Grabbing 5 year stock data for PNW\n",
      "Stock data acquired, inserting into db\n",
      "Done with PNW. Currently on #376 of 505\n",
      "Grabbing 5 year stock data for PXD\n",
      "Stock data acquired, inserting into db\n",
      "Done with PXD. Currently on #377 of 505\n",
      "Grabbing 5 year stock data for PNC\n",
      "Stock data acquired, inserting into db\n",
      "Done with PNC. Currently on #378 of 505\n",
      "Grabbing 5 year stock data for RL\n",
      "Stock data acquired, inserting into db\n",
      "Done with RL. Currently on #379 of 505\n",
      "Grabbing 5 year stock data for PPG\n",
      "Stock data acquired, inserting into db\n",
      "Done with PPG. Currently on #380 of 505\n",
      "Grabbing 5 year stock data for PPL\n",
      "Stock data acquired, inserting into db\n",
      "Done with PPL. Currently on #381 of 505\n",
      "Grabbing 5 year stock data for PFG\n",
      "Stock data acquired, inserting into db\n",
      "Done with PFG. Currently on #382 of 505\n",
      "Grabbing 5 year stock data for PG\n",
      "Stock data acquired, inserting into db\n",
      "Done with PG. Currently on #383 of 505\n",
      "Grabbing 5 year stock data for PGR\n",
      "Stock data acquired, inserting into db\n",
      "Done with PGR. Currently on #384 of 505\n",
      "Grabbing 5 year stock data for PLD\n",
      "Stock data acquired, inserting into db\n",
      "Done with PLD. Currently on #385 of 505\n",
      "Grabbing 5 year stock data for PRU\n",
      "Stock data acquired, inserting into db\n",
      "Done with PRU. Currently on #386 of 505\n",
      "Grabbing 5 year stock data for PEG\n",
      "Stock data acquired, inserting into db\n",
      "Done with PEG. Currently on #387 of 505\n",
      "Grabbing 5 year stock data for PSA\n",
      "Stock data acquired, inserting into db\n",
      "Done with PSA. Currently on #388 of 505\n",
      "Grabbing 5 year stock data for PHM\n",
      "Stock data acquired, inserting into db\n",
      "Done with PHM. Currently on #389 of 505\n",
      "Grabbing 5 year stock data for PVH\n",
      "Stock data acquired, inserting into db\n",
      "Done with PVH. Currently on #390 of 505\n",
      "Grabbing 5 year stock data for QRVO\n",
      "Stock data acquired, inserting into db\n",
      "Done with QRVO. Currently on #391 of 505\n",
      "Grabbing 5 year stock data for PWR\n",
      "Stock data acquired, inserting into db\n",
      "Done with PWR. Currently on #392 of 505\n",
      "Grabbing 5 year stock data for QCOM\n",
      "Stock data acquired, inserting into db\n",
      "Done with QCOM. Currently on #393 of 505\n",
      "Grabbing 5 year stock data for DGX\n",
      "Stock data acquired, inserting into db\n",
      "Done with DGX. Currently on #394 of 505\n",
      "Grabbing 5 year stock data for RJF\n",
      "Stock data acquired, inserting into db\n",
      "Done with RJF. Currently on #395 of 505\n",
      "Grabbing 5 year stock data for RTN\n",
      "Stock data acquired, inserting into db\n",
      "Done with RTN. Currently on #396 of 505\n",
      "Grabbing 5 year stock data for O\n",
      "Stock data acquired, inserting into db\n",
      "Done with O. Currently on #397 of 505\n",
      "Grabbing 5 year stock data for RHT\n",
      "Stock data acquired, inserting into db\n",
      "Done with RHT. Currently on #398 of 505\n",
      "Grabbing 5 year stock data for REG\n",
      "Stock data acquired, inserting into db\n",
      "Done with REG. Currently on #399 of 505\n",
      "Grabbing 5 year stock data for REGN\n",
      "Stock data acquired, inserting into db\n",
      "Done with REGN. Currently on #400 of 505\n",
      "Grabbing 5 year stock data for RF\n",
      "Stock data acquired, inserting into db\n",
      "Done with RF. Currently on #401 of 505\n",
      "Grabbing 5 year stock data for RSG\n",
      "Stock data acquired, inserting into db\n",
      "Done with RSG. Currently on #402 of 505\n",
      "Grabbing 5 year stock data for RMD\n",
      "Stock data acquired, inserting into db\n",
      "Done with RMD. Currently on #403 of 505\n",
      "Grabbing 5 year stock data for RHI\n",
      "Stock data acquired, inserting into db\n",
      "Done with RHI. Currently on #404 of 505\n",
      "Grabbing 5 year stock data for ROK\n",
      "Stock data acquired, inserting into db\n",
      "Done with ROK. Currently on #405 of 505\n",
      "Grabbing 5 year stock data for ROL\n",
      "Stock data acquired, inserting into db\n",
      "Done with ROL. Currently on #406 of 505\n",
      "Grabbing 5 year stock data for ROP\n",
      "Stock data acquired, inserting into db\n",
      "Done with ROP. Currently on #407 of 505\n",
      "Grabbing 5 year stock data for ROST\n",
      "Stock data acquired, inserting into db\n",
      "Done with ROST. Currently on #408 of 505\n",
      "Grabbing 5 year stock data for RCL\n",
      "Stock data acquired, inserting into db\n",
      "Done with RCL. Currently on #409 of 505\n",
      "Grabbing 5 year stock data for CRM\n",
      "Stock data acquired, inserting into db\n",
      "Done with CRM. Currently on #410 of 505\n",
      "Grabbing 5 year stock data for SBAC\n",
      "Stock data acquired, inserting into db\n",
      "Done with SBAC. Currently on #411 of 505\n",
      "Grabbing 5 year stock data for SLB\n",
      "Stock data acquired, inserting into db\n",
      "Done with SLB. Currently on #412 of 505\n",
      "Grabbing 5 year stock data for STX\n",
      "Stock data acquired, inserting into db\n",
      "Done with STX. Currently on #413 of 505\n",
      "Grabbing 5 year stock data for SEE\n",
      "Stock data acquired, inserting into db\n",
      "Done with SEE. Currently on #414 of 505\n",
      "Grabbing 5 year stock data for SRE\n",
      "Stock data acquired, inserting into db\n",
      "Done with SRE. Currently on #415 of 505\n",
      "Grabbing 5 year stock data for SHW\n",
      "Stock data acquired, inserting into db\n",
      "Done with SHW. Currently on #416 of 505\n",
      "Grabbing 5 year stock data for SPG\n",
      "Stock data acquired, inserting into db\n",
      "Done with SPG. Currently on #417 of 505\n",
      "Grabbing 5 year stock data for SWKS\n",
      "Stock data acquired, inserting into db\n",
      "Done with SWKS. Currently on #418 of 505\n",
      "Grabbing 5 year stock data for SLG\n",
      "Stock data acquired, inserting into db\n",
      "Done with SLG. Currently on #419 of 505\n",
      "Grabbing 5 year stock data for SNA\n",
      "Stock data acquired, inserting into db\n",
      "Done with SNA. Currently on #420 of 505\n",
      "Grabbing 5 year stock data for SO\n",
      "Stock data acquired, inserting into db\n",
      "Done with SO. Currently on #421 of 505\n",
      "Grabbing 5 year stock data for LUV\n",
      "Stock data acquired, inserting into db\n",
      "Done with LUV. Currently on #422 of 505\n",
      "Grabbing 5 year stock data for SPGI\n",
      "Stock data acquired, inserting into db\n",
      "Done with SPGI. Currently on #423 of 505\n",
      "Grabbing 5 year stock data for SWK\n",
      "Stock data acquired, inserting into db\n",
      "Done with SWK. Currently on #424 of 505\n",
      "Grabbing 5 year stock data for SBUX\n",
      "Stock data acquired, inserting into db\n",
      "Done with SBUX. Currently on #425 of 505\n",
      "Grabbing 5 year stock data for STT\n",
      "Stock data acquired, inserting into db\n",
      "Done with STT. Currently on #426 of 505\n",
      "Grabbing 5 year stock data for SYK\n",
      "Stock data acquired, inserting into db\n",
      "Done with SYK. Currently on #427 of 505\n",
      "Grabbing 5 year stock data for STI\n",
      "Stock data acquired, inserting into db\n",
      "Done with STI. Currently on #428 of 505\n",
      "Grabbing 5 year stock data for SIVB\n",
      "Stock data acquired, inserting into db\n",
      "Done with SIVB. Currently on #429 of 505\n",
      "Grabbing 5 year stock data for SYMC\n",
      "Stock data acquired, inserting into db\n",
      "Done with SYMC. Currently on #430 of 505\n",
      "Grabbing 5 year stock data for SYF\n",
      "Stock data acquired, inserting into db\n",
      "Done with SYF. Currently on #431 of 505\n",
      "Grabbing 5 year stock data for SNPS\n",
      "Stock data acquired, inserting into db\n",
      "Done with SNPS. Currently on #432 of 505\n",
      "Grabbing 5 year stock data for SYY\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with SYY. Currently on #433 of 505\n",
      "Grabbing 5 year stock data for TROW\n",
      "Stock data acquired, inserting into db\n",
      "Done with TROW. Currently on #434 of 505\n",
      "Grabbing 5 year stock data for TTWO\n",
      "Stock data acquired, inserting into db\n",
      "Done with TTWO. Currently on #435 of 505\n",
      "Grabbing 5 year stock data for TPR\n",
      "Stock data acquired, inserting into db\n",
      "Done with TPR. Currently on #436 of 505\n",
      "Grabbing 5 year stock data for TGT\n",
      "Stock data acquired, inserting into db\n",
      "Done with TGT. Currently on #437 of 505\n",
      "Grabbing 5 year stock data for TEL\n",
      "Stock data acquired, inserting into db\n",
      "Done with TEL. Currently on #438 of 505\n",
      "Grabbing 5 year stock data for FTI\n",
      "Stock data acquired, inserting into db\n",
      "Done with FTI. Currently on #439 of 505\n",
      "Grabbing 5 year stock data for TFX\n",
      "Stock data acquired, inserting into db\n",
      "Done with TFX. Currently on #440 of 505\n",
      "Grabbing 5 year stock data for TXN\n",
      "Stock data acquired, inserting into db\n",
      "Done with TXN. Currently on #441 of 505\n",
      "Grabbing 5 year stock data for TXT\n",
      "Stock data acquired, inserting into db\n",
      "Done with TXT. Currently on #442 of 505\n",
      "Grabbing 5 year stock data for TMO\n",
      "Stock data acquired, inserting into db\n",
      "Done with TMO. Currently on #443 of 505\n",
      "Grabbing 5 year stock data for TIF\n",
      "Stock data acquired, inserting into db\n",
      "Done with TIF. Currently on #444 of 505\n",
      "Grabbing 5 year stock data for TWTR\n",
      "Stock data acquired, inserting into db\n",
      "Done with TWTR. Currently on #445 of 505\n",
      "Grabbing 5 year stock data for TJX\n",
      "Stock data acquired, inserting into db\n",
      "Done with TJX. Currently on #446 of 505\n",
      "Grabbing 5 year stock data for TMK\n",
      "Stock data acquired, inserting into db\n",
      "Done with TMK. Currently on #447 of 505\n",
      "Grabbing 5 year stock data for TSS\n",
      "Stock data acquired, inserting into db\n",
      "Done with TSS. Currently on #448 of 505\n",
      "Grabbing 5 year stock data for TSCO\n",
      "Stock data acquired, inserting into db\n",
      "Done with TSCO. Currently on #449 of 505\n",
      "Grabbing 5 year stock data for TDG\n",
      "Stock data acquired, inserting into db\n",
      "Done with TDG. Currently on #450 of 505\n",
      "Grabbing 5 year stock data for TRV\n",
      "Stock data acquired, inserting into db\n",
      "Done with TRV. Currently on #451 of 505\n",
      "Grabbing 5 year stock data for TRIP\n",
      "Stock data acquired, inserting into db\n",
      "Done with TRIP. Currently on #452 of 505\n",
      "Grabbing 5 year stock data for FOXA\n",
      "Stock data acquired, inserting into db\n",
      "Done with FOXA. Currently on #453 of 505\n",
      "Grabbing 5 year stock data for FOX\n",
      "Stock data acquired, inserting into db\n",
      "Done with FOX. Currently on #454 of 505\n",
      "Grabbing 5 year stock data for TSN\n",
      "Stock data acquired, inserting into db\n",
      "Done with TSN. Currently on #455 of 505\n",
      "Grabbing 5 year stock data for UDR\n",
      "Stock data acquired, inserting into db\n",
      "Done with UDR. Currently on #456 of 505\n",
      "Grabbing 5 year stock data for ULTA\n",
      "Stock data acquired, inserting into db\n",
      "Done with ULTA. Currently on #457 of 505\n",
      "Grabbing 5 year stock data for USB\n",
      "Stock data acquired, inserting into db\n",
      "Done with USB. Currently on #458 of 505\n",
      "Grabbing 5 year stock data for UAA\n",
      "Stock data acquired, inserting into db\n",
      "Done with UAA. Currently on #459 of 505\n",
      "Grabbing 5 year stock data for UA\n",
      "Stock data acquired, inserting into db\n",
      "Done with UA. Currently on #460 of 505\n",
      "Grabbing 5 year stock data for UNP\n",
      "Stock data acquired, inserting into db\n",
      "Done with UNP. Currently on #461 of 505\n",
      "Grabbing 5 year stock data for UAL\n",
      "Stock data acquired, inserting into db\n",
      "Done with UAL. Currently on #462 of 505\n",
      "Grabbing 5 year stock data for UNH\n",
      "Stock data acquired, inserting into db\n",
      "Done with UNH. Currently on #463 of 505\n",
      "Grabbing 5 year stock data for UPS\n",
      "Stock data acquired, inserting into db\n",
      "Done with UPS. Currently on #464 of 505\n",
      "Grabbing 5 year stock data for URI\n",
      "Stock data acquired, inserting into db\n",
      "Done with URI. Currently on #465 of 505\n",
      "Grabbing 5 year stock data for UTX\n",
      "Stock data acquired, inserting into db\n",
      "Done with UTX. Currently on #466 of 505\n",
      "Grabbing 5 year stock data for UHS\n",
      "Stock data acquired, inserting into db\n",
      "Done with UHS. Currently on #467 of 505\n",
      "Grabbing 5 year stock data for UNM\n",
      "Stock data acquired, inserting into db\n",
      "Done with UNM. Currently on #468 of 505\n",
      "Grabbing 5 year stock data for VFC\n",
      "Stock data acquired, inserting into db\n",
      "Done with VFC. Currently on #469 of 505\n",
      "Grabbing 5 year stock data for VLO\n",
      "Stock data acquired, inserting into db\n",
      "Done with VLO. Currently on #470 of 505\n",
      "Grabbing 5 year stock data for VAR\n",
      "Stock data acquired, inserting into db\n",
      "Done with VAR. Currently on #471 of 505\n",
      "Grabbing 5 year stock data for VTR\n",
      "Stock data acquired, inserting into db\n",
      "Done with VTR. Currently on #472 of 505\n",
      "Grabbing 5 year stock data for VRSN\n",
      "Stock data acquired, inserting into db\n",
      "Done with VRSN. Currently on #473 of 505\n",
      "Grabbing 5 year stock data for VRSK\n",
      "Stock data acquired, inserting into db\n",
      "Done with VRSK. Currently on #474 of 505\n",
      "Grabbing 5 year stock data for VZ\n",
      "Stock data acquired, inserting into db\n",
      "Done with VZ. Currently on #475 of 505\n",
      "Grabbing 5 year stock data for VRTX\n",
      "Stock data acquired, inserting into db\n",
      "Done with VRTX. Currently on #476 of 505\n",
      "Grabbing 5 year stock data for VIAB\n",
      "Stock data acquired, inserting into db\n",
      "Done with VIAB. Currently on #477 of 505\n",
      "Grabbing 5 year stock data for V\n",
      "Stock data acquired, inserting into db\n",
      "Done with V. Currently on #478 of 505\n",
      "Grabbing 5 year stock data for VNO\n",
      "Stock data acquired, inserting into db\n",
      "Done with VNO. Currently on #479 of 505\n",
      "Grabbing 5 year stock data for VMC\n",
      "Stock data acquired, inserting into db\n",
      "Done with VMC. Currently on #480 of 505\n",
      "Grabbing 5 year stock data for WMT\n",
      "Stock data acquired, inserting into db\n",
      "Done with WMT. Currently on #481 of 505\n",
      "Grabbing 5 year stock data for WBA\n",
      "Stock data acquired, inserting into db\n",
      "Done with WBA. Currently on #482 of 505\n",
      "Grabbing 5 year stock data for DIS\n",
      "Stock data acquired, inserting into db\n",
      "Done with DIS. Currently on #483 of 505\n",
      "Grabbing 5 year stock data for WM\n",
      "Stock data acquired, inserting into db\n",
      "Done with WM. Currently on #484 of 505\n",
      "Grabbing 5 year stock data for WAT\n",
      "Stock data acquired, inserting into db\n",
      "Done with WAT. Currently on #485 of 505\n",
      "Grabbing 5 year stock data for WEC\n",
      "Stock data acquired, inserting into db\n",
      "Done with WEC. Currently on #486 of 505\n",
      "Grabbing 5 year stock data for WCG\n",
      "Stock data acquired, inserting into db\n",
      "Done with WCG. Currently on #487 of 505\n",
      "Grabbing 5 year stock data for WFC\n",
      "Stock data acquired, inserting into db\n",
      "Done with WFC. Currently on #488 of 505\n",
      "Grabbing 5 year stock data for WELL\n",
      "Stock data acquired, inserting into db\n",
      "Done with WELL. Currently on #489 of 505\n",
      "Grabbing 5 year stock data for WDC\n",
      "Stock data acquired, inserting into db\n",
      "Done with WDC. Currently on #490 of 505\n",
      "Grabbing 5 year stock data for WU\n",
      "Stock data acquired, inserting into db\n",
      "Done with WU. Currently on #491 of 505\n",
      "Grabbing 5 year stock data for WRK\n",
      "Stock data acquired, inserting into db\n",
      "Done with WRK. Currently on #492 of 505\n",
      "Grabbing 5 year stock data for WY\n",
      "Stock data acquired, inserting into db\n",
      "Done with WY. Currently on #493 of 505\n",
      "Grabbing 5 year stock data for WHR\n",
      "Stock data acquired, inserting into db\n",
      "Done with WHR. Currently on #494 of 505\n",
      "Grabbing 5 year stock data for WMB\n",
      "Stock data acquired, inserting into db\n",
      "Done with WMB. Currently on #495 of 505\n",
      "Grabbing 5 year stock data for WLTW\n",
      "Stock data acquired, inserting into db\n",
      "Done with WLTW. Currently on #496 of 505\n",
      "Grabbing 5 year stock data for WYNN\n",
      "Stock data acquired, inserting into db\n",
      "Done with WYNN. Currently on #497 of 505\n",
      "Grabbing 5 year stock data for XEL\n",
      "Stock data acquired, inserting into db\n",
      "Done with XEL. Currently on #498 of 505\n",
      "Grabbing 5 year stock data for XRX\n",
      "Stock data acquired, inserting into db\n",
      "Done with XRX. Currently on #499 of 505\n",
      "Grabbing 5 year stock data for XLNX\n",
      "Stock data acquired, inserting into db\n",
      "Done with XLNX. Currently on #500 of 505\n",
      "Grabbing 5 year stock data for XYL\n",
      "Stock data acquired, inserting into db\n",
      "Done with XYL. Currently on #501 of 505\n",
      "Grabbing 5 year stock data for YUM\n",
      "Stock data acquired, inserting into db\n",
      "Done with YUM. Currently on #502 of 505\n",
      "Grabbing 5 year stock data for ZBH\n",
      "Stock data acquired, inserting into db\n",
      "Done with ZBH. Currently on #503 of 505\n",
      "Grabbing 5 year stock data for ZION\n",
      "Stock data acquired, inserting into db\n",
      "Done with ZION. Currently on #504 of 505\n",
      "Grabbing 5 year stock data for ZTS\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Stock data acquired, inserting into db\n",
      "Done with ZTS. Currently on #505 of 505\n"
     ]
    }
   ],
   "source": [
    "#Set up a loop to retrieve and insert 5 years of stock data\n",
    "# this will need to be try/except'd for continuous use\n",
    "counter = 0\n",
    "for ticker in list_of_sp500:\n",
    "    print('Grabbing 5 year stock data for '+ticker)\n",
    "    json_collection = GetAndReturnJSON(ticker)\n",
    "    print('Stock data acquired, inserting into db')\n",
    "    for json in json_collection:\n",
    "        InsertStockData(ticker,json)\n",
    "    counter += 1\n",
    "    print('Done with '+ticker+'. Currently on #'+str(counter)+' of '+str(len(list_of_sp500)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}