starter_notebook.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import datetime as dt\n",
    "from config import API_KEY\n",
    "import requests\n",
    "import json\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "file = 'constituents_csv.csv'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#setup DF from the csv\n",
    "\n",
    "df = pd.read_csv(file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Pro</th>\n",
       "      <th>Name</th>\n",
       "      <th>Sector</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>MMM</td>\n",
       "      <td>3M Company</td>\n",
       "      <td>Industrials</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AOS</td>\n",
       "      <td>A.O. Smith Corp</td>\n",
       "      <td>Industrials</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ABT</td>\n",
       "      <td>Abbott Laboratories</td>\n",
       "      <td>Health Care</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ABBV</td>\n",
       "      <td>AbbVie Inc.</td>\n",
       "      <td>Health Care</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ACN</td>\n",
       "      <td>Accenture plc</td>\n",
       "      <td>Information Technology</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Pro                 Name                  Sector\n",
       "0   MMM           3M Company             Industrials\n",
       "1   AOS      A.O. Smith Corp             Industrials\n",
       "2   ABT  Abbott Laboratories             Health Care\n",
       "3  ABBV          AbbVie Inc.             Health Care\n",
       "4   ACN        Accenture plc  Information Technology"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Convert Data Frame to Dictionary (set_index method allows any column to be used as index)\n",
    "df2dict=df.set_index('Pro').transpose().to_dict(orient='dict')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(df2dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "404\n"
     ]
    }
   ],
   "source": [
    "#Python API from IEX\n",
    "response = requests.get(\"https://cloud.iexapis.com/?token={$API_KEY}\")\n",
    "print(response.status_code)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#create a for loop that returns each ticker so we can return financial information for each company and store it in a list\n",
    "symbols = []\n",
    "for key, value in df2dict.items():\n",
    "    symbols.append(key)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['MMM', 'AOS', 'ABT', 'ABBV', 'ACN', 'ATVI', 'AYI', 'ADBE', 'AAP', 'AMD', 'AES', 'AET', 'AMG', 'AFL', 'A', 'APD', 'AKAM', 'ALK', 'ALB', 'ARE', 'ALXN', 'ALGN', 'ALLE', 'AGN', 'ADS', 'LNT', 'ALL', 'GOOGL', 'GOOG', 'MO', 'AMZN', 'AEE', 'AAL', 'AEP', 'AXP', 'AIG', 'AMT', 'AWK', 'AMP', 'ABC', 'AME', 'AMGN', 'APH', 'APC', 'ADI', 'ANDV', 'ANSS', 'ANTM', 'AON', 'APA', 'AIV', 'AAPL', 'AMAT', 'APTV', 'ADM', 'ARNC', 'AJG', 'AIZ', 'T', 'ADSK', 'ADP', 'AZO', 'AVB', 'AVY', 'BHGE', 'BLL', 'BAC', 'BAX', 'BBT', 'BDX', 'BRK.B', 'BBY', 'BIIB', 'BLK', 'HRB', 'BA', 'BKNG', 'BWA', 'BXP', 'BSX', 'BHF', 'BMY', 'AVGO', 'BF.B', 'CHRW', 'CA', 'COG', 'CDNS', 'CPB', 'COF', 'CAH', 'KMX', 'CCL', 'CAT', 'CBOE', 'CBRE', 'CBS', 'CELG', 'CNC', 'CNP', 'CTL', 'CERN', 'CF', 'SCHW', 'CHTR', 'CVX', 'CMG', 'CB', 'CHD', 'CI', 'XEC', 'CINF', 'CTAS', 'CSCO', 'C', 'CFG', 'CTXS', 'CME', 'CMS', 'KO', 'CTSH', 'CL', 'CMCSA', 'CMA', 'CAG', 'CXO', 'COP', 'ED', 'STZ', 'GLW', 'COST', 'COTY', 'CCI', 'CSRA', 'CSX', 'CMI', 'CVS', 'DHI', 'DHR', 'DRI', 'DVA', 'DE', 'DAL', 'XRAY', 'DVN', 'DLR', 'DFS', 'DISCA', 'DISCK', 'DISH', 'DG', 'DLTR', 'D', 'DOV', 'DWDP', 'DPS', 'DTE', 'DUK', 'DRE', 'DXC', 'ETFC', 'EMN', 'ETN', 'EBAY', 'ECL', 'EIX', 'EW', 'EA', 'EMR', 'ETR', 'EVHC', 'EOG', 'EQT', 'EFX', 'EQIX', 'EQR', 'ESS', 'EL', 'RE', 'ES', 'EXC', 'EXPE', 'EXPD', 'ESRX', 'EXR', 'XOM', 'FFIV', 'FB', 'FAST', 'FRT', 'FDX', 'FIS', 'FITB', 'FE', 'FISV', 'FLIR', 'FLS', 'FLR', 'FMC', 'FL', 'F', 'FTV', 'FBHS', 'BEN', 'FCX', 'GPS', 'GRMN', 'IT', 'GD', 'GE', 'GGP', 'GIS', 'GM', 'GPC', 'GILD', 'GPN', 'GS', 'GT', 'GWW', 'HAL', 'HBI', 'HOG', 'HRS', 'HIG', 'HAS', 'HCA', 'HCP', 'HP', 'HSIC', 'HES', 'HPE', 'HLT', 'HOLX', 'HD', 'HON', 'HRL', 'HST', 'HPQ', 'HUM', 'HBAN', 'HII', 'IDXX', 'INFO', 'ITW', 'ILMN', 'INCY', 'IR', 'INTC', 'ICE', 'IBM', 'IP', 'IPG', 'IFF', 'INTU', 'ISRG', 'IVZ', 'IPGP', 'IQV', 'IRM', 'JBHT', 'JEC', 'SJM', 'JNJ', 'JCI', 'JPM', 'JNPR', 'KSU', 'K', 'KEY', 'KMB', 'KIM', 'KMI', 'KLAC', 'KSS', 'KHC', 'KR', 'LB', 'LLL', 'LH', 'LRCX', 'LEG', 'LEN', 'LUK', 'LLY', 'LNC', 'LKQ', 'LMT', 'L', 'LOW', 'LYB', 'MTB', 'MAC', 'M', 'MRO', 'MPC', 'MAR', 'MMC', 'MLM', 'MAS', 'MA', 'MAT', 'MKC', 'MCD', 'MCK', 'MDT', 'MRK', 'MET', 'MTD', 'MGM', 'KORS', 'MCHP', 'MU', 'MSFT', 'MAA', 'MHK', 'TAP', 'MDLZ', 'MON', 'MNST', 'MCO', 'MS', 'MSI', 'MYL', 'NDAQ', 'NOV', 'NAVI', 'NKTR', 'NTAP', 'NFLX', 'NWL', 'NFX', 'NEM', 'NWSA', 'NWS', 'NEE', 'NLSN', 'NKE', 'NI', 'NBL', 'JWN', 'NSC', 'NTRS', 'NOC', 'NCLH', 'NRG', 'NUE', 'NVDA', 'ORLY', 'OXY', 'OMC', 'OKE', 'ORCL', 'PCAR', 'PKG', 'PH', 'PAYX', 'PYPL', 'PNR', 'PBCT', 'PEP', 'PKI', 'PRGO', 'PFE', 'PCG', 'PM', 'PSX', 'PNW', 'PXD', 'PNC', 'RL', 'PPG', 'PPL', 'PX', 'PFG', 'PG', 'PGR', 'PLD', 'PRU', 'PEG', 'PSA', 'PHM', 'PVH', 'QRVO', 'QCOM', 'PWR', 'DGX', 'RRC', 'RJF', 'RTN', 'O', 'RHT', 'REG', 'REGN', 'RF', 'RSG', 'RMD', 'RHI', 'ROK', 'COL', 'ROP', 'ROST', 'RCL', 'SPGI', 'CRM', 'SBAC', 'SCG', 'SLB', 'STX', 'SEE', 'SRE', 'SHW', 'SPG', 'SWKS', 'SLG', 'SNA', 'SO', 'LUV', 'SWK', 'SBUX', 'STT', 'SRCL', 'SYK', 'STI', 'SIVB', 'SYMC', 'SYF', 'SNPS', 'SYY', 'TROW', 'TTWO', 'TPR', 'TGT', 'TEL', 'FTI', 'TXN', 'TXT', 'BK', 'CLX', 'COO', 'HSY', 'MOS', 'TRV', 'DIS', 'TMO', 'TIF', 'TWX', 'TJX', 'TMK', 'TSS', 'TSCO', 'TDG', 'TRIP', 'FOXA', 'FOX', 'TSN', 'USB', 'UDR', 'ULTA', 'UAA', 'UA', 'UNP', 'UAL', 'UNH', 'UPS', 'URI', 'UTX', 'UHS', 'UNM', 'VFC', 'VLO', 'VAR', 'VTR', 'VRSN', 'VRSK', 'VZ', 'VRTX', 'VIAB', 'V', 'VNO', 'VMC', 'WMT', 'WBA', 'WM', 'WAT', 'WEC', 'WFC', 'WELL', 'WDC', 'WU', 'WRK', 'WY', 'WHR', 'WMB', 'WLTW', 'WYN', 'WYNN', 'XEL', 'XRX', 'XLNX', 'XL', 'XYL', 'YUM', 'ZBH', 'ZION', 'ZTS']\n"
     ]
    }
   ],
   "source": [
    "print(symbols)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "#maybe pointless? want to tie the symbol to financial data. \n",
    "\n",
    "symbols2dict = dict.fromkeys(symbols)\n",
    "#print(symbols2dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"avgTotalVolume\": 2184449,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": 1.03,\n",
      "    \"changePercent\": 0.00515,\n",
      "    \"close\": 200.89,\n",
      "    \"closeTime\": 1552078967843,\n",
      "    \"companyName\": \"3M Co.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0.01,\n",
      "    \"extendedChangePercent\": 5e-05,\n",
      "    \"extendedPrice\": 200.9,\n",
      "    \"extendedPriceTime\": 1552171077847,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 200.89,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078967843,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 115672462000,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 22.06,\n",
      "    \"previousClose\": 199.86,\n",
      "    \"symbol\": \"MMM\",\n",
      "    \"week52High\": 243.1,\n",
      "    \"week52Low\": 176.87,\n",
      "    \"ytdChange\": 0.057206\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 1702232,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": 0.15,\n",
      "    \"changePercent\": 0.00296,\n",
      "    \"close\": 50.87,\n",
      "    \"closeTime\": 1552078844434,\n",
      "    \"companyName\": \"A. O. Smith Corp.\",\n",
      "    \"delayedPrice\": 50.87,\n",
      "    \"delayedPriceTime\": 1552165249968,\n",
      "    \"extendedChange\": 0,\n",
      "    \"extendedChangePercent\": 0,\n",
      "    \"extendedPrice\": 50.87,\n",
      "    \"extendedPriceTime\": 1552078849968,\n",
      "    \"high\": 51,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 50.87,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078844434,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": 50.26,\n",
      "    \"marketCap\": 8539238984,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 19.46,\n",
      "    \"previousClose\": 50.72,\n",
      "    \"symbol\": \"AOS\",\n",
      "    \"week52High\": 66.85,\n",
      "    \"week52Low\": 40.34,\n",
      "    \"ytdChange\": 0.17319199999999998\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 5821018,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -0.17,\n",
      "    \"changePercent\": -0.00221,\n",
      "    \"close\": 76.63,\n",
      "    \"closeTime\": 1552078879042,\n",
      "    \"companyName\": \"Abbott Laboratories\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": -0.01,\n",
      "    \"extendedChangePercent\": -0.00013,\n",
      "    \"extendedPrice\": 76.62,\n",
      "    \"extendedPriceTime\": 1552176993906,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 76.63,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078879042,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 134598296100,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 56.99,\n",
      "    \"previousClose\": 76.8,\n",
      "    \"symbol\": \"ABT\",\n",
      "    \"week52High\": 78.97,\n",
      "    \"week52Low\": 56.81,\n",
      "    \"ytdChange\": 0.10038\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 7264245,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -0.66,\n",
      "    \"changePercent\": -0.00844,\n",
      "    \"close\": 77.58,\n",
      "    \"closeTime\": 1552079029562,\n",
      "    \"companyName\": \"AbbVie, Inc.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0.16,\n",
      "    \"extendedChangePercent\": 0.00206,\n",
      "    \"extendedPrice\": 77.74,\n",
      "    \"extendedPriceTime\": 1552172621469,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 77.58,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552079029562,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 114436706400,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 21.67,\n",
      "    \"previousClose\": 78.24,\n",
      "    \"symbol\": \"ABBV\",\n",
      "    \"week52High\": 121.45,\n",
      "    \"week52Low\": 75.77,\n",
      "    \"ytdChange\": -0.139001\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 1807020,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -0.16,\n",
      "    \"changePercent\": -0.00099,\n",
      "    \"close\": 161.69,\n",
      "    \"closeTime\": 1552078955760,\n",
      "    \"companyName\": \"Accenture Plc\",\n",
      "    \"delayedPrice\": 161.69,\n",
      "    \"delayedPriceTime\": 1552166241298,\n",
      "    \"extendedChange\": 0,\n",
      "    \"extendedChangePercent\": 0,\n",
      "    \"extendedPrice\": 161.69,\n",
      "    \"extendedPriceTime\": 1552079841298,\n",
      "    \"high\": 161.81,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 161.69,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078955760,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": 160.5,\n",
      "    \"marketCap\": 103069128810,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 24.35,\n",
      "    \"previousClose\": 161.85,\n",
      "    \"symbol\": \"ACN\",\n",
      "    \"week52High\": 175.64,\n",
      "    \"week52Low\": 132.63,\n",
      "    \"ytdChange\": 0.149092\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 16329260,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": 0.61,\n",
      "    \"changePercent\": 0.01473,\n",
      "    \"close\": 42.03,\n",
      "    \"closeTime\": 1552078800458,\n",
      "    \"companyName\": \"Activision Blizzard, Inc.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": -0.1,\n",
      "    \"extendedChangePercent\": -0.00238,\n",
      "    \"extendedPrice\": 41.93,\n",
      "    \"extendedPriceTime\": 1552172167085,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 42.03,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078800458,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 32103943020,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 17.66,\n",
      "    \"previousClose\": 41.42,\n",
      "    \"symbol\": \"ATVI\",\n",
      "    \"week52High\": 84.68,\n",
      "    \"week52Low\": 39.85,\n",
      "    \"ytdChange\": -0.091585\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 376079,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -3.45,\n",
      "    \"changePercent\": -0.02607,\n",
      "    \"close\": 128.91,\n",
      "    \"closeTime\": 1552078921075,\n",
      "    \"companyName\": \"Acuity Brands, Inc.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0,\n",
      "    \"extendedChangePercent\": 0,\n",
      "    \"extendedPrice\": 128.91,\n",
      "    \"extendedPriceTime\": 1552169251704,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 128.91,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078921075,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 5142477720,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 14.57,\n",
      "    \"previousClose\": 132.36,\n",
      "    \"symbol\": \"AYI\",\n",
      "    \"week52High\": 173.01,\n",
      "    \"week52Low\": 103.48,\n",
      "    \"ytdChange\": 0.09264900000000001\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 2713470,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -0.72,\n",
      "    \"changePercent\": -0.00282,\n",
      "    \"close\": 254.74,\n",
      "    \"closeTime\": 1552078800295,\n",
      "    \"companyName\": \"Adobe, Inc.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0.95,\n",
      "    \"extendedChangePercent\": 0.00373,\n",
      "    \"extendedPrice\": 255.69,\n",
      "    \"extendedPriceTime\": 1552179583336,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 254.74,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078800295,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 124597155100,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 48.25,\n",
      "    \"previousClose\": 255.46,\n",
      "    \"symbol\": \"ADBE\",\n",
      "    \"week52High\": 277.61,\n",
      "    \"week52Low\": 204.95,\n",
      "    \"ytdChange\": 0.131526\n",
      "}\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{\n",
      "    \"avgTotalVolume\": 1316763,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -2.36,\n",
      "    \"changePercent\": -0.01531,\n",
      "    \"close\": 151.77,\n",
      "    \"closeTime\": 1552078923085,\n",
      "    \"companyName\": \"Advance Auto Parts, Inc.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0,\n",
      "    \"extendedChangePercent\": 0,\n",
      "    \"extendedPrice\": 151.77,\n",
      "    \"extendedPriceTime\": 1552169252569,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 151.77,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078923085,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 10877355900,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 26.44,\n",
      "    \"previousClose\": 154.13,\n",
      "    \"symbol\": \"AAP\",\n",
      "    \"week52High\": 186.15,\n",
      "    \"week52Low\": 102.15,\n",
      "    \"ytdChange\": -0.054254\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 78886911,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": -0.07,\n",
      "    \"changePercent\": -0.00317,\n",
      "    \"close\": 22.01,\n",
      "    \"closeTime\": 1552078800598,\n",
      "    \"companyName\": \"Advanced Micro Devices, Inc.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0.13,\n",
      "    \"extendedChangePercent\": 0.00591,\n",
      "    \"extendedPrice\": 22.14,\n",
      "    \"extendedPriceTime\": 1552179596691,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 22.01,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078800598,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 22126653000,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 64.74,\n",
      "    \"previousClose\": 22.08,\n",
      "    \"symbol\": \"AMD\",\n",
      "    \"week52High\": 34.14,\n",
      "    \"week52Low\": 9.04,\n",
      "    \"ytdChange\": 0.165709\n",
      "}\n",
      "{\n",
      "    \"avgTotalVolume\": 5768327,\n",
      "    \"calculationPrice\": \"close\",\n",
      "    \"change\": 0.03,\n",
      "    \"changePercent\": 0.0017,\n",
      "    \"close\": 17.7,\n",
      "    \"closeTime\": 1552078998841,\n",
      "    \"companyName\": \"The AES Corp.\",\n",
      "    \"delayedPrice\": null,\n",
      "    \"delayedPriceTime\": null,\n",
      "    \"extendedChange\": 0.61,\n",
      "    \"extendedChangePercent\": 0.03446,\n",
      "    \"extendedPrice\": 18.31,\n",
      "    \"extendedPriceTime\": 1552177668803,\n",
      "    \"high\": null,\n",
      "    \"iexAskPrice\": null,\n",
      "    \"iexAskSize\": null,\n",
      "    \"iexBidPrice\": null,\n",
      "    \"iexBidSize\": null,\n",
      "    \"iexLastUpdated\": null,\n",
      "    \"iexMarketPercent\": null,\n",
      "    \"iexRealtimePrice\": null,\n",
      "    \"iexRealtimeSize\": null,\n",
      "    \"iexVolume\": null,\n",
      "    \"latestPrice\": 17.7,\n",
      "    \"latestSource\": \"Close\",\n",
      "    \"latestTime\": \"March 8, 2019\",\n",
      "    \"latestUpdate\": 1552078998841,\n",
      "    \"latestVolume\": 0,\n",
      "    \"low\": null,\n",
      "    \"marketCap\": 11724550800,\n",
      "    \"open\": null,\n",
      "    \"openTime\": null,\n",
      "    \"peRatio\": 9.75,\n",
      "    \"previousClose\": 17.67,\n",
      "    \"symbol\": \"AES\",\n",
      "    \"week52High\": 17.95,\n",
      "    \"week52Low\": 10.49,\n",
      "    \"ytdChange\": 0.24993700000000002\n",
      "}\n"
     ]
    },
    {
     "ename": "JSONDecodeError",
     "evalue": "Expecting value: line 1 column 1 (char 0)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mJSONDecodeError\u001b[0m                           Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-13-2a6f01f46c13>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;32mfor\u001b[0m \u001b[0msymbol\u001b[0m \u001b[0;32min\u001b[0m \u001b[0msymbols\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m     \u001b[0mresponse\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mrequests\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34mf'https://cloud.iexapis.com/beta/stock/{symbol}/quote?token={API_KEY}'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 5\u001b[0;31m     \u001b[0mresponse_json\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mresponse\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mjson\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m     \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mjson\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdumps\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mresponse_json\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindent\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m4\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0msort_keys\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/site-packages/requests/models.py\u001b[0m in \u001b[0;36mjson\u001b[0;34m(self, **kwargs)\u001b[0m\n\u001b[1;32m    895\u001b[0m                     \u001b[0;31m# used.\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    896\u001b[0m                     \u001b[0;32mpass\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 897\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0mcomplexjson\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mloads\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtext\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    898\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    899\u001b[0m     \u001b[0;34m@\u001b[0m\u001b[0mproperty\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/json/__init__.py\u001b[0m in \u001b[0;36mloads\u001b[0;34m(s, encoding, cls, object_hook, parse_float, parse_int, parse_constant, object_pairs_hook, **kw)\u001b[0m\n\u001b[1;32m    352\u001b[0m             \u001b[0mparse_int\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mparse_float\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m \u001b[0;32mand\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    353\u001b[0m             parse_constant is None and object_pairs_hook is None and not kw):\n\u001b[0;32m--> 354\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_default_decoder\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdecode\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    355\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mcls\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    356\u001b[0m         \u001b[0mcls\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mJSONDecoder\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/json/decoder.py\u001b[0m in \u001b[0;36mdecode\u001b[0;34m(self, s, _w)\u001b[0m\n\u001b[1;32m    337\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    338\u001b[0m         \"\"\"\n\u001b[0;32m--> 339\u001b[0;31m         \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mraw_decode\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0midx\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0m_w\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    340\u001b[0m         \u001b[0mend\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_w\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    341\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mend\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/anaconda3/lib/python3.6/json/decoder.py\u001b[0m in \u001b[0;36mraw_decode\u001b[0;34m(self, s, idx)\u001b[0m\n\u001b[1;32m    355\u001b[0m             \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mscan_once\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0midx\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    356\u001b[0m         \u001b[0;32mexcept\u001b[0m \u001b[0mStopIteration\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 357\u001b[0;31m             \u001b[0;32mraise\u001b[0m \u001b[0mJSONDecodeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"Expecting value\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0ms\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    358\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mend\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mJSONDecodeError\u001b[0m: Expecting value: line 1 column 1 (char 0)"
     ]
    }
   ],
   "source": [
    "# reference the symbols list in the API call \n",
    "\n",
    "for symbol in symbols:\n",
    "    response = requests.get(f'https://cloud.iexapis.com/beta/stock/{symbol}/quote?token={API_KEY}')\n",
    "    response_json = response.json()\n",
    "    print(json.dumps(response_json, indent=4, sort_keys=True))                       "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}