ST_API_mini_project.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This exercise will require you to pull some data from the Qunadl API. Qaundl is currently the most widely used aggregator of financial market data."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "As a first step, you will need to register a free account on the http://www.quandl.com website."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "After you register, you will be provided with a unique API key, that you should store:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Store the API key as a string - according to PEP8, constants are always named in all upper case\n",
    "API_KEY = "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Qaundl has a large number of data sources, but, unfortunately, most of them require a Premium subscription. Still, there are also a good number of free datasets."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "For this mini project, we will focus on equities data from the Frankfurt Stock Exhange (FSE), which is available for free. We'll try and analyze the stock prices of a company called Carl Zeiss Meditec, which manufactures tools for eye examinations, as well as medical lasers for laser eye surgery: https://www.zeiss.com/meditec/int/home.html. The company is listed under the stock ticker AFX_X."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "You can find the detailed Quandl API instructions here: https://docs.quandl.com/docs/time-series"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "While there is a dedicated Python package for connecting to the Quandl API, we would prefer that you use the *requests* package, which can be easily downloaded using *pip* or *conda*. You can find the documentation for the package here: http://docs.python-requests.org/en/master/ "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Finally, apart from the *requests* package, you are encouraged to not use any third party Python packages, such as *pandas*, and instead focus on what's available in the Python Standard Library (the *collections* module might come in handy: https://pymotw.com/3/collections/).\n",
    "Also, since you won't have access to DataFrames, you are encouraged to us Python's native data structures - preferably dictionaries, though some questions can also be answered using lists.\n",
    "You can read more on these data structures here: https://docs.python.org/3/tutorial/datastructures.html"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Keep in mind that the JSON responses you will be getting from the API map almost one-to-one to Python's dictionaries. Unfortunately, they can be very nested, so make sure you read up on indexing dictionaries in the documentation provided above."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "# First, import the relevant modules\n",
    "import requests\n",
    "import numpy as np\n",
    "import json\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Now, call the Quandl API and pull out a small sample of the data (only one day) to get a glimpse\n",
    "# into the JSON structure that will be returned\n",
    "r = requests.get(\"https://www.quandl.com/api/v3/datasets/FSE/AFX_X.json?start_date=2018-11-19&end_date=2018-11-19&api_key=\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'dataset': {'collapse': None,\n",
       "  'column_index': None,\n",
       "  'column_names': ['Date',\n",
       "   'Open',\n",
       "   'High',\n",
       "   'Low',\n",
       "   'Close',\n",
       "   'Change',\n",
       "   'Traded Volume',\n",
       "   'Turnover',\n",
       "   'Last Price of the Day',\n",
       "   'Daily Traded Units',\n",
       "   'Daily Turnover'],\n",
       "  'data': [['2018-11-19',\n",
       "    None,\n",
       "    65.6,\n",
       "    63.4,\n",
       "    63.7,\n",
       "    None,\n",
       "    127749.0,\n",
       "    8213592.0,\n",
       "    None,\n",
       "    None,\n",
       "    None]],\n",
       "  'database_code': 'FSE',\n",
       "  'database_id': 6129,\n",
       "  'dataset_code': 'AFX_X',\n",
       "  'description': 'Stock Prices for Carl Zeiss Meditec (AFX) from the Frankfurt Stock Exchange.<br><br>Trading System: Xetra<br><br>ISIN: DE0005313704',\n",
       "  'end_date': '2018-11-19',\n",
       "  'frequency': 'daily',\n",
       "  'id': 10095370,\n",
       "  'limit': None,\n",
       "  'name': 'Carl Zeiss Meditec (AFX_X)',\n",
       "  'newest_available_date': '2018-11-23',\n",
       "  'oldest_available_date': '2000-06-07',\n",
       "  'order': None,\n",
       "  'premium': False,\n",
       "  'refreshed_at': '2018-11-23T22:34:22.231Z',\n",
       "  'start_date': '2018-11-19',\n",
       "  'transform': None,\n",
       "  'type': 'Time Series'}}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Inspect the JSON structure of the object you created, and take note of how nested it is,\n",
    "# as well as the overall structure\n",
    "r.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "These are your tasks for this mini project:\n",
    "\n",
    "1. Collect data from the Franfurt Stock Exchange, for the ticker AFX_X, for the whole year 2017 (keep in mind that the date format is YYYY-MM-DD).\n",
    "2. Convert the returned JSON object into a Python dictionary.\n",
    "3. Calculate what the highest and lowest opening prices were for the stock in this period.\n",
    "4. What was the largest change in any one day (based on High and Low price)?\n",
    "5. What was the largest change between any two days (based on Closing Price)?\n",
    "6. What was the average daily trading volume during this year?\n",
    "7. (Optional) What was the median trading volume during this year. (Note: you may need to implement your own function for calculating the median.)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "   ## Q1 ANSWER"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "r1 = requests.get(\"https://www.quandl.com/api/v3/datasets/FSE/AFX_X.json?start_date=2017-01-01&end_date=2017-12-31&api_key=ZH5z8nVkfHSJ83xVj4KA\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'dataset': {'collapse': None,\n",
       "  'column_index': None,\n",
       "  'column_names': ['Date',\n",
       "   'Open',\n",
       "   'High',\n",
       "   'Low',\n",
       "   'Close',\n",
       "   'Change',\n",
       "   'Traded Volume',\n",
       "   'Turnover',\n",
       "   'Last Price of the Day',\n",
       "   'Daily Traded Units',\n",
       "   'Daily Turnover'],\n",
       "  'data': [['2017-12-29',\n",
       "    51.76,\n",
       "    51.94,\n",
       "    51.45,\n",
       "    51.76,\n",
       "    None,\n",
       "    34640.0,\n",
       "    1792304.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-28',\n",
       "    51.65,\n",
       "    51.82,\n",
       "    51.43,\n",
       "    51.6,\n",
       "    None,\n",
       "    40660.0,\n",
       "    2099024.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-27',\n",
       "    51.45,\n",
       "    51.89,\n",
       "    50.76,\n",
       "    51.82,\n",
       "    None,\n",
       "    57452.0,\n",
       "    2957018.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-22',\n",
       "    51.05,\n",
       "    51.5,\n",
       "    50.92,\n",
       "    51.32,\n",
       "    None,\n",
       "    71165.0,\n",
       "    3641949.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-21',\n",
       "    51.16,\n",
       "    51.52,\n",
       "    50.9,\n",
       "    51.4,\n",
       "    None,\n",
       "    120649.0,\n",
       "    6179433.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-20',\n",
       "    51.88,\n",
       "    52.04,\n",
       "    51.2,\n",
       "    51.27,\n",
       "    None,\n",
       "    50587.0,\n",
       "    2610258.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-19',\n",
       "    52.73,\n",
       "    52.73,\n",
       "    51.07,\n",
       "    51.66,\n",
       "    None,\n",
       "    137313.0,\n",
       "    7102361.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-18',\n",
       "    52.37,\n",
       "    52.75,\n",
       "    51.61,\n",
       "    52.62,\n",
       "    None,\n",
       "    129733.0,\n",
       "    6770499.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-15',\n",
       "    52.7,\n",
       "    52.7,\n",
       "    51.64,\n",
       "    52.01,\n",
       "    None,\n",
       "    204080.0,\n",
       "    10596319.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-14',\n",
       "    53.11,\n",
       "    53.54,\n",
       "    52.15,\n",
       "    52.67,\n",
       "    None,\n",
       "    132981.0,\n",
       "    7016953.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-13',\n",
       "    52.64,\n",
       "    53.35,\n",
       "    52.48,\n",
       "    53.09,\n",
       "    None,\n",
       "    128434.0,\n",
       "    6801159.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-12',\n",
       "    52.29,\n",
       "    53.1,\n",
       "    51.82,\n",
       "    52.43,\n",
       "    None,\n",
       "    87911.0,\n",
       "    4615924.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-11',\n",
       "    52.28,\n",
       "    52.45,\n",
       "    51.26,\n",
       "    52.14,\n",
       "    None,\n",
       "    71817.0,\n",
       "    3724193.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-08',\n",
       "    51.5,\n",
       "    52.83,\n",
       "    51.28,\n",
       "    52.12,\n",
       "    None,\n",
       "    109157.0,\n",
       "    5690648.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-07',\n",
       "    50.89,\n",
       "    51.47,\n",
       "    50.81,\n",
       "    51.47,\n",
       "    None,\n",
       "    48123.0,\n",
       "    2463848.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-06',\n",
       "    50.8,\n",
       "    51.11,\n",
       "    50.39,\n",
       "    50.89,\n",
       "    None,\n",
       "    88730.0,\n",
       "    4504075.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-05',\n",
       "    51.21,\n",
       "    51.38,\n",
       "    50.4,\n",
       "    51.25,\n",
       "    None,\n",
       "    83023.0,\n",
       "    4231971.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-04',\n",
       "    49.5,\n",
       "    51.23,\n",
       "    49.5,\n",
       "    51.14,\n",
       "    None,\n",
       "    94385.0,\n",
       "    4800027.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-12-01',\n",
       "    49.52,\n",
       "    50.49,\n",
       "    49.17,\n",
       "    49.86,\n",
       "    None,\n",
       "    101733.0,\n",
       "    5065932.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-30',\n",
       "    48.64,\n",
       "    49.84,\n",
       "    48.28,\n",
       "    49.7,\n",
       "    None,\n",
       "    123019.0,\n",
       "    6085171.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-29',\n",
       "    49.64,\n",
       "    49.64,\n",
       "    48.7,\n",
       "    48.75,\n",
       "    None,\n",
       "    67342.0,\n",
       "    3292223.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-28',\n",
       "    49.09,\n",
       "    49.89,\n",
       "    49.03,\n",
       "    49.25,\n",
       "    None,\n",
       "    42669.0,\n",
       "    2107358.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-27',\n",
       "    49.13,\n",
       "    49.73,\n",
       "    48.96,\n",
       "    49.2,\n",
       "    None,\n",
       "    102180.0,\n",
       "    5055762.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-24',\n",
       "    49.11,\n",
       "    49.41,\n",
       "    48.87,\n",
       "    49.11,\n",
       "    None,\n",
       "    50350.0,\n",
       "    2472842.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-23',\n",
       "    48.8,\n",
       "    49.46,\n",
       "    48.45,\n",
       "    49.2,\n",
       "    None,\n",
       "    38834.0,\n",
       "    1909352.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-22',\n",
       "    48.4,\n",
       "    49.61,\n",
       "    48.39,\n",
       "    48.8,\n",
       "    None,\n",
       "    91142.0,\n",
       "    4478093.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-21',\n",
       "    47.25,\n",
       "    48.59,\n",
       "    46.78,\n",
       "    48.39,\n",
       "    None,\n",
       "    78502.0,\n",
       "    3782098.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-20',\n",
       "    46.57,\n",
       "    47.38,\n",
       "    46.54,\n",
       "    47.04,\n",
       "    None,\n",
       "    97252.0,\n",
       "    4563515.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-17',\n",
       "    47.03,\n",
       "    47.15,\n",
       "    46.8,\n",
       "    46.84,\n",
       "    None,\n",
       "    54107.0,\n",
       "    2540820.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-16',\n",
       "    47.09,\n",
       "    47.23,\n",
       "    46.55,\n",
       "    47.03,\n",
       "    None,\n",
       "    89373.0,\n",
       "    4195732.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-15',\n",
       "    47.98,\n",
       "    48.01,\n",
       "    46.75,\n",
       "    47.05,\n",
       "    None,\n",
       "    67593.0,\n",
       "    3188321.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-14',\n",
       "    48.4,\n",
       "    48.9,\n",
       "    47.84,\n",
       "    48.0,\n",
       "    None,\n",
       "    67672.0,\n",
       "    3259979.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-13',\n",
       "    48.38,\n",
       "    48.61,\n",
       "    47.76,\n",
       "    48.34,\n",
       "    None,\n",
       "    76286.0,\n",
       "    3681337.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-10',\n",
       "    47.3,\n",
       "    48.89,\n",
       "    47.16,\n",
       "    48.34,\n",
       "    None,\n",
       "    90245.0,\n",
       "    4361552.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-09',\n",
       "    47.65,\n",
       "    48.06,\n",
       "    47.09,\n",
       "    47.21,\n",
       "    None,\n",
       "    120268.0,\n",
       "    5712034.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-08',\n",
       "    46.42,\n",
       "    47.72,\n",
       "    46.42,\n",
       "    47.47,\n",
       "    None,\n",
       "    94195.0,\n",
       "    4463935.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-07',\n",
       "    46.16,\n",
       "    46.33,\n",
       "    45.84,\n",
       "    46.26,\n",
       "    None,\n",
       "    48152.0,\n",
       "    2224221.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-06',\n",
       "    45.81,\n",
       "    46.09,\n",
       "    45.76,\n",
       "    45.99,\n",
       "    None,\n",
       "    60716.0,\n",
       "    2789220.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-03',\n",
       "    45.0,\n",
       "    46.04,\n",
       "    44.83,\n",
       "    45.97,\n",
       "    None,\n",
       "    56911.0,\n",
       "    2603498.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-02',\n",
       "    45.88,\n",
       "    46.06,\n",
       "    45.18,\n",
       "    45.27,\n",
       "    None,\n",
       "    37958.0,\n",
       "    1724840.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-11-01',\n",
       "    46.29,\n",
       "    46.55,\n",
       "    45.97,\n",
       "    46.04,\n",
       "    None,\n",
       "    56319.0,\n",
       "    2603859.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-30',\n",
       "    46.53,\n",
       "    46.65,\n",
       "    45.61,\n",
       "    45.76,\n",
       "    None,\n",
       "    56245.0,\n",
       "    2585397.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-27',\n",
       "    45.48,\n",
       "    46.42,\n",
       "    45.46,\n",
       "    46.41,\n",
       "    None,\n",
       "    74472.0,\n",
       "    3434087.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-26',\n",
       "    45.2,\n",
       "    45.41,\n",
       "    44.91,\n",
       "    45.41,\n",
       "    None,\n",
       "    56319.0,\n",
       "    2548078.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-25',\n",
       "    45.01,\n",
       "    45.06,\n",
       "    44.7,\n",
       "    45.0,\n",
       "    None,\n",
       "    47730.0,\n",
       "    2145697.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-24',\n",
       "    45.16,\n",
       "    45.27,\n",
       "    44.75,\n",
       "    44.85,\n",
       "    None,\n",
       "    43042.0,\n",
       "    1937616.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-23',\n",
       "    44.9,\n",
       "    45.34,\n",
       "    44.89,\n",
       "    45.0,\n",
       "    None,\n",
       "    43375.0,\n",
       "    1952918.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-20',\n",
       "    45.08,\n",
       "    45.34,\n",
       "    44.76,\n",
       "    44.87,\n",
       "    None,\n",
       "    55707.0,\n",
       "    2503853.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-19',\n",
       "    45.72,\n",
       "    45.85,\n",
       "    44.79,\n",
       "    45.0,\n",
       "    None,\n",
       "    59991.0,\n",
       "    2703085.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-18',\n",
       "    46.01,\n",
       "    46.2,\n",
       "    45.61,\n",
       "    45.77,\n",
       "    None,\n",
       "    45263.0,\n",
       "    2076951.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-17',\n",
       "    45.8,\n",
       "    46.06,\n",
       "    45.37,\n",
       "    45.96,\n",
       "    None,\n",
       "    65837.0,\n",
       "    3014080.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-16',\n",
       "    45.61,\n",
       "    45.75,\n",
       "    45.3,\n",
       "    45.55,\n",
       "    None,\n",
       "    49246.0,\n",
       "    2243129.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-13',\n",
       "    45.5,\n",
       "    45.7,\n",
       "    45.37,\n",
       "    45.4,\n",
       "    None,\n",
       "    43362.0,\n",
       "    1971801.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-12',\n",
       "    45.58,\n",
       "    45.58,\n",
       "    45.17,\n",
       "    45.43,\n",
       "    None,\n",
       "    49180.0,\n",
       "    2233481.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-11',\n",
       "    45.97,\n",
       "    45.97,\n",
       "    45.25,\n",
       "    45.29,\n",
       "    None,\n",
       "    69455.0,\n",
       "    3158321.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-10',\n",
       "    45.64,\n",
       "    46.04,\n",
       "    45.57,\n",
       "    45.84,\n",
       "    None,\n",
       "    65860.0,\n",
       "    3016658.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-09',\n",
       "    46.2,\n",
       "    46.2,\n",
       "    45.6,\n",
       "    45.74,\n",
       "    None,\n",
       "    44059.0,\n",
       "    2015453.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-06',\n",
       "    46.19,\n",
       "    46.19,\n",
       "    45.69,\n",
       "    46.0,\n",
       "    None,\n",
       "    66760.0,\n",
       "    3066198.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-05',\n",
       "    46.01,\n",
       "    46.09,\n",
       "    45.63,\n",
       "    46.05,\n",
       "    None,\n",
       "    94804.0,\n",
       "    4352002.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-04',\n",
       "    45.36,\n",
       "    46.17,\n",
       "    45.22,\n",
       "    46.11,\n",
       "    None,\n",
       "    115706.0,\n",
       "    5313199.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-10-02',\n",
       "    44.51,\n",
       "    44.98,\n",
       "    44.18,\n",
       "    44.98,\n",
       "    None,\n",
       "    95313.0,\n",
       "    4265024.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-29',\n",
       "    43.58,\n",
       "    44.17,\n",
       "    43.3,\n",
       "    44.17,\n",
       "    None,\n",
       "    99821.0,\n",
       "    4384796.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-28',\n",
       "    42.0,\n",
       "    43.56,\n",
       "    42.0,\n",
       "    43.56,\n",
       "    None,\n",
       "    157234.0,\n",
       "    6775569.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-27',\n",
       "    42.35,\n",
       "    42.49,\n",
       "    41.78,\n",
       "    42.04,\n",
       "    None,\n",
       "    76600.0,\n",
       "    3219861.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-26',\n",
       "    42.3,\n",
       "    42.57,\n",
       "    42.11,\n",
       "    42.37,\n",
       "    None,\n",
       "    51321.0,\n",
       "    2175381.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-25',\n",
       "    42.3,\n",
       "    42.3,\n",
       "    41.96,\n",
       "    42.07,\n",
       "    None,\n",
       "    56224.0,\n",
       "    2366453.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-22',\n",
       "    41.48,\n",
       "    42.38,\n",
       "    41.48,\n",
       "    42.06,\n",
       "    None,\n",
       "    79955.0,\n",
       "    3362517.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-21',\n",
       "    42.29,\n",
       "    42.29,\n",
       "    41.39,\n",
       "    41.46,\n",
       "    None,\n",
       "    105194.0,\n",
       "    4378409.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-20',\n",
       "    42.54,\n",
       "    42.54,\n",
       "    41.99,\n",
       "    41.99,\n",
       "    None,\n",
       "    57838.0,\n",
       "    2440557.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-19',\n",
       "    42.65,\n",
       "    42.65,\n",
       "    42.13,\n",
       "    42.44,\n",
       "    None,\n",
       "    65546.0,\n",
       "    2777065.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-18',\n",
       "    42.5,\n",
       "    42.63,\n",
       "    42.23,\n",
       "    42.27,\n",
       "    None,\n",
       "    44037.0,\n",
       "    1864954.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-15',\n",
       "    42.29,\n",
       "    42.81,\n",
       "    42.25,\n",
       "    42.42,\n",
       "    None,\n",
       "    107144.0,\n",
       "    4555791.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-14',\n",
       "    42.35,\n",
       "    42.8,\n",
       "    42.35,\n",
       "    42.52,\n",
       "    None,\n",
       "    65157.0,\n",
       "    2770696.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-13',\n",
       "    42.49,\n",
       "    42.69,\n",
       "    42.22,\n",
       "    42.45,\n",
       "    None,\n",
       "    68801.0,\n",
       "    2921240.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-12',\n",
       "    43.21,\n",
       "    43.34,\n",
       "    42.62,\n",
       "    42.73,\n",
       "    None,\n",
       "    52828.0,\n",
       "    2259924.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-11',\n",
       "    42.81,\n",
       "    42.89,\n",
       "    42.56,\n",
       "    42.85,\n",
       "    None,\n",
       "    103273.0,\n",
       "    4415614.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-08',\n",
       "    42.7,\n",
       "    42.75,\n",
       "    42.56,\n",
       "    42.67,\n",
       "    None,\n",
       "    59881.0,\n",
       "    2553977.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-07',\n",
       "    43.0,\n",
       "    43.02,\n",
       "    42.67,\n",
       "    42.77,\n",
       "    None,\n",
       "    64320.0,\n",
       "    2751388.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-06',\n",
       "    42.66,\n",
       "    42.71,\n",
       "    42.34,\n",
       "    42.55,\n",
       "    None,\n",
       "    71006.0,\n",
       "    3020229.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-05',\n",
       "    43.0,\n",
       "    43.19,\n",
       "    42.55,\n",
       "    42.62,\n",
       "    None,\n",
       "    66351.0,\n",
       "    2846115.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-04',\n",
       "    42.38,\n",
       "    42.75,\n",
       "    41.95,\n",
       "    42.6,\n",
       "    None,\n",
       "    105288.0,\n",
       "    4471634.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-09-01',\n",
       "    42.16,\n",
       "    43.06,\n",
       "    42.07,\n",
       "    42.41,\n",
       "    None,\n",
       "    151474.0,\n",
       "    6453558.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-31',\n",
       "    42.0,\n",
       "    42.08,\n",
       "    41.12,\n",
       "    41.9,\n",
       "    None,\n",
       "    157888.0,\n",
       "    6580200.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-30',\n",
       "    42.0,\n",
       "    42.2,\n",
       "    41.49,\n",
       "    41.94,\n",
       "    None,\n",
       "    97804.0,\n",
       "    4090262.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-29',\n",
       "    41.71,\n",
       "    41.98,\n",
       "    41.33,\n",
       "    41.85,\n",
       "    None,\n",
       "    98156.0,\n",
       "    4094452.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-28',\n",
       "    42.11,\n",
       "    42.25,\n",
       "    41.86,\n",
       "    41.91,\n",
       "    None,\n",
       "    47130.0,\n",
       "    1978704.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-25',\n",
       "    42.64,\n",
       "    42.64,\n",
       "    42.05,\n",
       "    42.14,\n",
       "    None,\n",
       "    69734.0,\n",
       "    2948016.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-24',\n",
       "    42.72,\n",
       "    43.05,\n",
       "    42.63,\n",
       "    42.69,\n",
       "    None,\n",
       "    65213.0,\n",
       "    2792319.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-23',\n",
       "    42.82,\n",
       "    43.17,\n",
       "    42.6,\n",
       "    42.71,\n",
       "    None,\n",
       "    70269.0,\n",
       "    3011578.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-22',\n",
       "    42.46,\n",
       "    42.96,\n",
       "    42.4,\n",
       "    42.71,\n",
       "    None,\n",
       "    95376.0,\n",
       "    4075646.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-21',\n",
       "    42.42,\n",
       "    42.76,\n",
       "    42.2,\n",
       "    42.26,\n",
       "    None,\n",
       "    68812.0,\n",
       "    2922972.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-18',\n",
       "    42.28,\n",
       "    42.6,\n",
       "    42.01,\n",
       "    42.41,\n",
       "    None,\n",
       "    72886.0,\n",
       "    3092377.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-17',\n",
       "    41.88,\n",
       "    43.01,\n",
       "    41.76,\n",
       "    42.5,\n",
       "    None,\n",
       "    131361.0,\n",
       "    5583704.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-16',\n",
       "    42.4,\n",
       "    42.62,\n",
       "    41.98,\n",
       "    42.05,\n",
       "    None,\n",
       "    104676.0,\n",
       "    4408312.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-15',\n",
       "    42.53,\n",
       "    42.53,\n",
       "    42.2,\n",
       "    42.28,\n",
       "    None,\n",
       "    64334.0,\n",
       "    2721852.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-14',\n",
       "    42.12,\n",
       "    42.69,\n",
       "    42.01,\n",
       "    42.3,\n",
       "    None,\n",
       "    127682.0,\n",
       "    5416963.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-11',\n",
       "    41.3,\n",
       "    41.94,\n",
       "    40.96,\n",
       "    41.94,\n",
       "    None,\n",
       "    183412.0,\n",
       "    7604144.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-10',\n",
       "    41.73,\n",
       "    41.99,\n",
       "    41.14,\n",
       "    41.68,\n",
       "    None,\n",
       "    175161.0,\n",
       "    7303562.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-09',\n",
       "    43.5,\n",
       "    43.5,\n",
       "    41.64,\n",
       "    41.81,\n",
       "    None,\n",
       "    355857.0,\n",
       "    15003956.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-08',\n",
       "    44.9,\n",
       "    45.09,\n",
       "    44.15,\n",
       "    44.37,\n",
       "    None,\n",
       "    156168.0,\n",
       "    6941408.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-07',\n",
       "    45.85,\n",
       "    46.34,\n",
       "    44.02,\n",
       "    44.96,\n",
       "    None,\n",
       "    164543.0,\n",
       "    7378816.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-04',\n",
       "    45.13,\n",
       "    45.13,\n",
       "    44.36,\n",
       "    45.07,\n",
       "    None,\n",
       "    96202.0,\n",
       "    4306911.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-03',\n",
       "    45.34,\n",
       "    45.54,\n",
       "    44.91,\n",
       "    44.97,\n",
       "    None,\n",
       "    77854.0,\n",
       "    3517146.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-02',\n",
       "    45.25,\n",
       "    45.77,\n",
       "    44.9,\n",
       "    45.56,\n",
       "    None,\n",
       "    187468.0,\n",
       "    8528548.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-08-01',\n",
       "    45.24,\n",
       "    45.54,\n",
       "    45.1,\n",
       "    45.45,\n",
       "    None,\n",
       "    74975.0,\n",
       "    3399891.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-31',\n",
       "    44.94,\n",
       "    45.75,\n",
       "    44.94,\n",
       "    45.3,\n",
       "    None,\n",
       "    62672.0,\n",
       "    2844210.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-28',\n",
       "    45.26,\n",
       "    45.29,\n",
       "    44.75,\n",
       "    44.97,\n",
       "    None,\n",
       "    114006.0,\n",
       "    5127247.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-27',\n",
       "    45.16,\n",
       "    45.45,\n",
       "    45.15,\n",
       "    45.25,\n",
       "    None,\n",
       "    50557.0,\n",
       "    2290284.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-26',\n",
       "    44.91,\n",
       "    45.33,\n",
       "    44.46,\n",
       "    45.16,\n",
       "    None,\n",
       "    81970.0,\n",
       "    3688510.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-25',\n",
       "    44.7,\n",
       "    45.04,\n",
       "    44.63,\n",
       "    44.82,\n",
       "    None,\n",
       "    112224.0,\n",
       "    5033312.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-24',\n",
       "    45.31,\n",
       "    45.31,\n",
       "    44.49,\n",
       "    44.61,\n",
       "    None,\n",
       "    104282.0,\n",
       "    4661866.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-21',\n",
       "    45.57,\n",
       "    45.88,\n",
       "    45.04,\n",
       "    45.44,\n",
       "    None,\n",
       "    73422.0,\n",
       "    3334695.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-20',\n",
       "    45.74,\n",
       "    45.96,\n",
       "    45.23,\n",
       "    45.66,\n",
       "    None,\n",
       "    87399.0,\n",
       "    3986488.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-19',\n",
       "    45.06,\n",
       "    45.72,\n",
       "    44.94,\n",
       "    45.57,\n",
       "    None,\n",
       "    71971.0,\n",
       "    3273001.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-18',\n",
       "    45.5,\n",
       "    45.55,\n",
       "    44.7,\n",
       "    45.0,\n",
       "    None,\n",
       "    104003.0,\n",
       "    4684627.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-17',\n",
       "    45.6,\n",
       "    46.23,\n",
       "    45.29,\n",
       "    45.6,\n",
       "    None,\n",
       "    104995.0,\n",
       "    4801806.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-14',\n",
       "    45.07,\n",
       "    45.56,\n",
       "    44.83,\n",
       "    45.53,\n",
       "    None,\n",
       "    67375.0,\n",
       "    3054060.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-13',\n",
       "    44.67,\n",
       "    45.18,\n",
       "    44.67,\n",
       "    44.95,\n",
       "    None,\n",
       "    82745.0,\n",
       "    3718928.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-12',\n",
       "    44.29,\n",
       "    45.05,\n",
       "    43.89,\n",
       "    44.95,\n",
       "    None,\n",
       "    115705.0,\n",
       "    5133971.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-11',\n",
       "    44.94,\n",
       "    44.94,\n",
       "    44.08,\n",
       "    44.2,\n",
       "    None,\n",
       "    90538.0,\n",
       "    4010457.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-10',\n",
       "    44.64,\n",
       "    45.18,\n",
       "    44.51,\n",
       "    44.7,\n",
       "    None,\n",
       "    71868.0,\n",
       "    3221218.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-07',\n",
       "    44.79,\n",
       "    44.79,\n",
       "    44.25,\n",
       "    44.53,\n",
       "    None,\n",
       "    47999.0,\n",
       "    2136578.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-06',\n",
       "    45.5,\n",
       "    45.5,\n",
       "    44.15,\n",
       "    44.62,\n",
       "    None,\n",
       "    66116.0,\n",
       "    2952605.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-05',\n",
       "    44.67,\n",
       "    45.36,\n",
       "    44.44,\n",
       "    45.19,\n",
       "    None,\n",
       "    48706.0,\n",
       "    2189436.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-04',\n",
       "    45.83,\n",
       "    45.83,\n",
       "    44.74,\n",
       "    44.8,\n",
       "    None,\n",
       "    50549.0,\n",
       "    2273551.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-07-03',\n",
       "    45.29,\n",
       "    45.83,\n",
       "    45.06,\n",
       "    45.75,\n",
       "    None,\n",
       "    71381.0,\n",
       "    3251502.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-30',\n",
       "    45.01,\n",
       "    45.74,\n",
       "    45.0,\n",
       "    45.44,\n",
       "    None,\n",
       "    136112.0,\n",
       "    6187148.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-29',\n",
       "    45.73,\n",
       "    45.81,\n",
       "    45.11,\n",
       "    45.2,\n",
       "    None,\n",
       "    134965.0,\n",
       "    6132452.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-28',\n",
       "    46.68,\n",
       "    46.68,\n",
       "    45.41,\n",
       "    45.68,\n",
       "    None,\n",
       "    117165.0,\n",
       "    5381488.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-27',\n",
       "    47.23,\n",
       "    47.33,\n",
       "    46.39,\n",
       "    46.83,\n",
       "    None,\n",
       "    82492.0,\n",
       "    3866344.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-26',\n",
       "    46.95,\n",
       "    47.63,\n",
       "    46.91,\n",
       "    47.21,\n",
       "    None,\n",
       "    73322.0,\n",
       "    3465639.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-23',\n",
       "    47.29,\n",
       "    47.4,\n",
       "    46.79,\n",
       "    46.99,\n",
       "    None,\n",
       "    80586.0,\n",
       "    3792498.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-22',\n",
       "    47.03,\n",
       "    47.4,\n",
       "    46.75,\n",
       "    47.29,\n",
       "    None,\n",
       "    56071.0,\n",
       "    2640508.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-21',\n",
       "    47.46,\n",
       "    47.48,\n",
       "    46.53,\n",
       "    46.99,\n",
       "    None,\n",
       "    89752.0,\n",
       "    4206563.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-20',\n",
       "    46.48,\n",
       "    47.43,\n",
       "    46.27,\n",
       "    47.37,\n",
       "    None,\n",
       "    108334.0,\n",
       "    5109730.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-19',\n",
       "    46.9,\n",
       "    46.9,\n",
       "    46.25,\n",
       "    46.64,\n",
       "    None,\n",
       "    70056.0,\n",
       "    3260381.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-16',\n",
       "    45.66,\n",
       "    46.8,\n",
       "    45.66,\n",
       "    46.63,\n",
       "    None,\n",
       "    202214.0,\n",
       "    9411695.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-15',\n",
       "    46.34,\n",
       "    46.34,\n",
       "    45.21,\n",
       "    45.67,\n",
       "    None,\n",
       "    101733.0,\n",
       "    4635593.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-14',\n",
       "    46.52,\n",
       "    46.86,\n",
       "    46.05,\n",
       "    46.33,\n",
       "    None,\n",
       "    83741.0,\n",
       "    3881453.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-13',\n",
       "    46.5,\n",
       "    46.51,\n",
       "    46.03,\n",
       "    46.32,\n",
       "    None,\n",
       "    107644.0,\n",
       "    4981185.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-12',\n",
       "    47.31,\n",
       "    47.43,\n",
       "    45.89,\n",
       "    46.31,\n",
       "    None,\n",
       "    112942.0,\n",
       "    5238390.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-09',\n",
       "    46.77,\n",
       "    47.44,\n",
       "    46.55,\n",
       "    47.44,\n",
       "    None,\n",
       "    99674.0,\n",
       "    4702170.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-08',\n",
       "    47.8,\n",
       "    47.8,\n",
       "    46.27,\n",
       "    46.27,\n",
       "    None,\n",
       "    1945.0,\n",
       "    90599.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-07',\n",
       "    47.01,\n",
       "    47.43,\n",
       "    47.01,\n",
       "    47.43,\n",
       "    None,\n",
       "    1081.0,\n",
       "    51021.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-06',\n",
       "    47.12,\n",
       "    47.45,\n",
       "    46.21,\n",
       "    47.43,\n",
       "    None,\n",
       "    686.0,\n",
       "    32083.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-02',\n",
       "    46.8,\n",
       "    46.99,\n",
       "    46.72,\n",
       "    46.99,\n",
       "    None,\n",
       "    290.0,\n",
       "    13584.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-06-01',\n",
       "    46.12,\n",
       "    46.52,\n",
       "    45.89,\n",
       "    46.52,\n",
       "    None,\n",
       "    106513.0,\n",
       "    4930686.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-31',\n",
       "    45.22,\n",
       "    46.26,\n",
       "    45.22,\n",
       "    45.86,\n",
       "    None,\n",
       "    522.0,\n",
       "    24044.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-30',\n",
       "    45.05,\n",
       "    46.02,\n",
       "    45.05,\n",
       "    46.02,\n",
       "    None,\n",
       "    587.0,\n",
       "    26792.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-29',\n",
       "    45.61,\n",
       "    45.61,\n",
       "    45.24,\n",
       "    45.32,\n",
       "    None,\n",
       "    112.0,\n",
       "    5089.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-26',\n",
       "    44.8,\n",
       "    45.36,\n",
       "    44.71,\n",
       "    45.3,\n",
       "    None,\n",
       "    74453.0,\n",
       "    3360707.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-25',\n",
       "    44.8,\n",
       "    44.87,\n",
       "    44.29,\n",
       "    44.78,\n",
       "    None,\n",
       "    49970.0,\n",
       "    2231857.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-24',\n",
       "    43.92,\n",
       "    44.67,\n",
       "    43.92,\n",
       "    44.53,\n",
       "    None,\n",
       "    111923.0,\n",
       "    4971343.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-23',\n",
       "    43.67,\n",
       "    44.13,\n",
       "    43.55,\n",
       "    43.9,\n",
       "    None,\n",
       "    38308.0,\n",
       "    1681904.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-22',\n",
       "    44.16,\n",
       "    44.22,\n",
       "    43.44,\n",
       "    43.84,\n",
       "    None,\n",
       "    70856.0,\n",
       "    3103013.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-19',\n",
       "    43.74,\n",
       "    44.12,\n",
       "    43.74,\n",
       "    44.12,\n",
       "    None,\n",
       "    45.0,\n",
       "    1980.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-18',\n",
       "    44.0,\n",
       "    44.3,\n",
       "    43.29,\n",
       "    43.98,\n",
       "    None,\n",
       "    166160.0,\n",
       "    7277314.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-17',\n",
       "    45.06,\n",
       "    45.34,\n",
       "    44.01,\n",
       "    44.19,\n",
       "    None,\n",
       "    149515.0,\n",
       "    6664744.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-16',\n",
       "    45.15,\n",
       "    45.36,\n",
       "    44.56,\n",
       "    45.31,\n",
       "    None,\n",
       "    101476.0,\n",
       "    4567885.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-15',\n",
       "    45.09,\n",
       "    45.78,\n",
       "    44.31,\n",
       "    45.14,\n",
       "    None,\n",
       "    193702.0,\n",
       "    8734286.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-12',\n",
       "    45.18,\n",
       "    45.18,\n",
       "    44.16,\n",
       "    44.99,\n",
       "    None,\n",
       "    159495.0,\n",
       "    7113519.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-11',\n",
       "    43.4,\n",
       "    46.06,\n",
       "    43.25,\n",
       "    45.0,\n",
       "    None,\n",
       "    189125.0,\n",
       "    8496322.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-10',\n",
       "    43.5,\n",
       "    43.6,\n",
       "    42.53,\n",
       "    43.28,\n",
       "    None,\n",
       "    91858.0,\n",
       "    3958630.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-09',\n",
       "    41.83,\n",
       "    43.55,\n",
       "    41.82,\n",
       "    43.3,\n",
       "    None,\n",
       "    151439.0,\n",
       "    6538516.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-08',\n",
       "    43.0,\n",
       "    43.0,\n",
       "    42.04,\n",
       "    42.24,\n",
       "    None,\n",
       "    97456.0,\n",
       "    4128048.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-05',\n",
       "    42.52,\n",
       "    42.91,\n",
       "    42.38,\n",
       "    42.75,\n",
       "    None,\n",
       "    78512.0,\n",
       "    3353971.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-04',\n",
       "    41.86,\n",
       "    42.5,\n",
       "    41.71,\n",
       "    42.5,\n",
       "    None,\n",
       "    82058.0,\n",
       "    3465505.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-03',\n",
       "    42.2,\n",
       "    42.29,\n",
       "    41.78,\n",
       "    41.9,\n",
       "    None,\n",
       "    65266.0,\n",
       "    2738394.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-02',\n",
       "    41.89,\n",
       "    42.23,\n",
       "    41.76,\n",
       "    42.15,\n",
       "    None,\n",
       "    86559.0,\n",
       "    3636583.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-05-01',\n",
       "    None,\n",
       "    42.245,\n",
       "    41.655,\n",
       "    41.72,\n",
       "    -0.44,\n",
       "    86348.0,\n",
       "    3606589.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-28',\n",
       "    42.17,\n",
       "    42.25,\n",
       "    41.66,\n",
       "    41.72,\n",
       "    None,\n",
       "    86348.0,\n",
       "    3606589.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-27',\n",
       "    41.51,\n",
       "    42.24,\n",
       "    41.51,\n",
       "    42.16,\n",
       "    None,\n",
       "    151683.0,\n",
       "    6380639.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-26',\n",
       "    41.88,\n",
       "    41.94,\n",
       "    41.4,\n",
       "    41.5,\n",
       "    None,\n",
       "    65847.0,\n",
       "    2743109.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-25',\n",
       "    41.93,\n",
       "    42.18,\n",
       "    41.66,\n",
       "    41.89,\n",
       "    None,\n",
       "    85973.0,\n",
       "    3604204.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-24',\n",
       "    42.01,\n",
       "    42.02,\n",
       "    41.23,\n",
       "    41.81,\n",
       "    None,\n",
       "    102084.0,\n",
       "    4247032.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-21',\n",
       "    41.97,\n",
       "    42.14,\n",
       "    41.01,\n",
       "    41.32,\n",
       "    None,\n",
       "    186784.0,\n",
       "    7728103.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-20',\n",
       "    42.5,\n",
       "    42.64,\n",
       "    41.52,\n",
       "    41.93,\n",
       "    None,\n",
       "    223621.0,\n",
       "    9418192.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-19',\n",
       "    41.94,\n",
       "    42.61,\n",
       "    41.94,\n",
       "    42.61,\n",
       "    None,\n",
       "    92722.0,\n",
       "    3930856.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-18',\n",
       "    42.24,\n",
       "    42.4,\n",
       "    41.54,\n",
       "    42.0,\n",
       "    None,\n",
       "    133057.0,\n",
       "    5587565.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-17',\n",
       "    None,\n",
       "    42.48,\n",
       "    41.985,\n",
       "    42.2,\n",
       "    None,\n",
       "    88416.0,\n",
       "    3734717.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-14',\n",
       "    None,\n",
       "    42.48,\n",
       "    41.985,\n",
       "    42.2,\n",
       "    None,\n",
       "    88416.0,\n",
       "    3734717.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-13',\n",
       "    42.06,\n",
       "    42.48,\n",
       "    41.99,\n",
       "    42.2,\n",
       "    None,\n",
       "    88416.0,\n",
       "    3734717.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-12',\n",
       "    42.02,\n",
       "    42.45,\n",
       "    41.84,\n",
       "    42.2,\n",
       "    None,\n",
       "    158278.0,\n",
       "    6672547.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-11',\n",
       "    41.62,\n",
       "    42.03,\n",
       "    41.53,\n",
       "    41.75,\n",
       "    None,\n",
       "    107817.0,\n",
       "    4501109.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-10',\n",
       "    41.46,\n",
       "    41.68,\n",
       "    41.31,\n",
       "    41.68,\n",
       "    None,\n",
       "    62297.0,\n",
       "    2585922.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-07',\n",
       "    40.9,\n",
       "    41.42,\n",
       "    40.84,\n",
       "    41.42,\n",
       "    None,\n",
       "    81255.0,\n",
       "    3344628.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-06',\n",
       "    40.96,\n",
       "    41.25,\n",
       "    40.83,\n",
       "    41.05,\n",
       "    None,\n",
       "    96794.0,\n",
       "    3968681.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-05',\n",
       "    41.1,\n",
       "    41.34,\n",
       "    40.79,\n",
       "    41.1,\n",
       "    None,\n",
       "    156005.0,\n",
       "    6404780.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-04',\n",
       "    39.5,\n",
       "    40.88,\n",
       "    39.48,\n",
       "    40.81,\n",
       "    None,\n",
       "    193156.0,\n",
       "    7822665.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-04-03',\n",
       "    40.15,\n",
       "    40.15,\n",
       "    39.54,\n",
       "    39.64,\n",
       "    None,\n",
       "    127973.0,\n",
       "    5081376.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-31',\n",
       "    39.77,\n",
       "    40.07,\n",
       "    39.42,\n",
       "    39.98,\n",
       "    None,\n",
       "    95382.0,\n",
       "    3795061.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-30',\n",
       "    40.02,\n",
       "    40.14,\n",
       "    39.42,\n",
       "    39.75,\n",
       "    None,\n",
       "    189201.0,\n",
       "    7541354.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-29',\n",
       "    39.39,\n",
       "    40.01,\n",
       "    39.05,\n",
       "    40.01,\n",
       "    None,\n",
       "    335406.0,\n",
       "    13349426.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-28',\n",
       "    38.95,\n",
       "    39.35,\n",
       "    38.79,\n",
       "    39.22,\n",
       "    None,\n",
       "    115075.0,\n",
       "    4505494.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-27',\n",
       "    38.73,\n",
       "    39.1,\n",
       "    38.53,\n",
       "    38.85,\n",
       "    None,\n",
       "    191515.0,\n",
       "    7446952.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-24',\n",
       "    38.94,\n",
       "    39.02,\n",
       "    38.6,\n",
       "    38.94,\n",
       "    None,\n",
       "    210926.0,\n",
       "    8205507.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-23',\n",
       "    39.01,\n",
       "    39.25,\n",
       "    38.63,\n",
       "    38.96,\n",
       "    None,\n",
       "    169971.0,\n",
       "    6621807.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-22',\n",
       "    38.25,\n",
       "    39.02,\n",
       "    37.53,\n",
       "    38.94,\n",
       "    None,\n",
       "    670349.0,\n",
       "    25910543.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-21',\n",
       "    41.8,\n",
       "    41.83,\n",
       "    40.97,\n",
       "    40.98,\n",
       "    None,\n",
       "    56906.0,\n",
       "    2349965.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-20',\n",
       "    41.26,\n",
       "    42.17,\n",
       "    41.26,\n",
       "    41.97,\n",
       "    None,\n",
       "    97572.0,\n",
       "    4074891.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-17',\n",
       "    41.47,\n",
       "    41.59,\n",
       "    41.16,\n",
       "    41.34,\n",
       "    None,\n",
       "    90109.0,\n",
       "    3734232.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-16',\n",
       "    41.4,\n",
       "    41.57,\n",
       "    41.09,\n",
       "    41.46,\n",
       "    None,\n",
       "    55799.0,\n",
       "    2308423.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-15',\n",
       "    41.4,\n",
       "    41.5,\n",
       "    40.91,\n",
       "    41.25,\n",
       "    None,\n",
       "    60324.0,\n",
       "    2488650.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-14',\n",
       "    41.2,\n",
       "    41.5,\n",
       "    41.2,\n",
       "    41.3,\n",
       "    None,\n",
       "    60420.0,\n",
       "    2498025.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-13',\n",
       "    41.4,\n",
       "    41.46,\n",
       "    41.08,\n",
       "    41.3,\n",
       "    None,\n",
       "    44803.0,\n",
       "    1850251.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-10',\n",
       "    41.53,\n",
       "    41.53,\n",
       "    41.16,\n",
       "    41.4,\n",
       "    None,\n",
       "    38518.0,\n",
       "    1592270.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-09',\n",
       "    41.61,\n",
       "    41.61,\n",
       "    41.16,\n",
       "    41.4,\n",
       "    None,\n",
       "    43988.0,\n",
       "    1819182.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-08',\n",
       "    41.13,\n",
       "    41.71,\n",
       "    40.95,\n",
       "    41.68,\n",
       "    None,\n",
       "    45111.0,\n",
       "    1870935.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-07',\n",
       "    41.5,\n",
       "    41.8,\n",
       "    41.25,\n",
       "    41.42,\n",
       "    None,\n",
       "    61925.0,\n",
       "    2569608.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-06',\n",
       "    41.25,\n",
       "    41.4,\n",
       "    40.81,\n",
       "    41.4,\n",
       "    None,\n",
       "    46510.0,\n",
       "    1916799.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-03',\n",
       "    41.12,\n",
       "    41.22,\n",
       "    40.84,\n",
       "    41.18,\n",
       "    None,\n",
       "    40800.0,\n",
       "    1675587.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-02',\n",
       "    41.38,\n",
       "    41.39,\n",
       "    40.76,\n",
       "    41.17,\n",
       "    None,\n",
       "    49863.0,\n",
       "    2048153.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-03-01',\n",
       "    41.19,\n",
       "    41.57,\n",
       "    40.9,\n",
       "    41.2,\n",
       "    None,\n",
       "    86753.0,\n",
       "    3569796.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-28',\n",
       "    40.38,\n",
       "    40.95,\n",
       "    40.38,\n",
       "    40.84,\n",
       "    None,\n",
       "    67440.0,\n",
       "    2747011.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-27',\n",
       "    39.75,\n",
       "    40.64,\n",
       "    39.75,\n",
       "    40.39,\n",
       "    None,\n",
       "    62655.0,\n",
       "    2520260.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-24',\n",
       "    39.77,\n",
       "    40.14,\n",
       "    38.91,\n",
       "    39.74,\n",
       "    None,\n",
       "    101294.0,\n",
       "    4015150.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-23',\n",
       "    39.72,\n",
       "    39.98,\n",
       "    39.38,\n",
       "    39.79,\n",
       "    None,\n",
       "    81945.0,\n",
       "    3260642.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-22',\n",
       "    39.6,\n",
       "    39.75,\n",
       "    39.27,\n",
       "    39.7,\n",
       "    None,\n",
       "    77619.0,\n",
       "    3066894.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-21',\n",
       "    38.85,\n",
       "    39.57,\n",
       "    38.85,\n",
       "    39.45,\n",
       "    None,\n",
       "    46070.0,\n",
       "    1808350.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-20',\n",
       "    39.25,\n",
       "    39.25,\n",
       "    38.81,\n",
       "    38.98,\n",
       "    None,\n",
       "    37014.0,\n",
       "    1444138.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-17',\n",
       "    38.8,\n",
       "    39.03,\n",
       "    38.48,\n",
       "    39.02,\n",
       "    None,\n",
       "    60583.0,\n",
       "    2352961.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-16',\n",
       "    38.8,\n",
       "    39.2,\n",
       "    38.25,\n",
       "    38.71,\n",
       "    None,\n",
       "    84682.0,\n",
       "    3282322.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-15',\n",
       "    38.5,\n",
       "    38.93,\n",
       "    38.4,\n",
       "    38.72,\n",
       "    None,\n",
       "    77420.0,\n",
       "    2996861.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-14',\n",
       "    38.81,\n",
       "    38.86,\n",
       "    38.0,\n",
       "    38.37,\n",
       "    None,\n",
       "    82601.0,\n",
       "    3163898.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-13',\n",
       "    37.37,\n",
       "    39.36,\n",
       "    37.35,\n",
       "    38.53,\n",
       "    None,\n",
       "    177171.0,\n",
       "    6804028.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-10',\n",
       "    36.65,\n",
       "    37.5,\n",
       "    36.57,\n",
       "    37.06,\n",
       "    None,\n",
       "    115843.0,\n",
       "    4291017.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-09',\n",
       "    36.2,\n",
       "    36.25,\n",
       "    35.77,\n",
       "    36.25,\n",
       "    None,\n",
       "    67781.0,\n",
       "    2445428.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-08',\n",
       "    35.98,\n",
       "    36.14,\n",
       "    35.84,\n",
       "    36.05,\n",
       "    None,\n",
       "    39731.0,\n",
       "    1431205.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-07',\n",
       "    35.56,\n",
       "    36.05,\n",
       "    35.36,\n",
       "    35.89,\n",
       "    None,\n",
       "    67410.0,\n",
       "    2410818.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-06',\n",
       "    36.06,\n",
       "    36.15,\n",
       "    35.6,\n",
       "    35.64,\n",
       "    None,\n",
       "    41911.0,\n",
       "    1496794.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-03',\n",
       "    36.02,\n",
       "    36.2,\n",
       "    35.73,\n",
       "    36.1,\n",
       "    None,\n",
       "    40705.0,\n",
       "    1464712.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-02',\n",
       "    35.95,\n",
       "    36.2,\n",
       "    35.7,\n",
       "    36.07,\n",
       "    None,\n",
       "    54279.0,\n",
       "    1953176.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-02-01',\n",
       "    34.75,\n",
       "    36.0,\n",
       "    34.75,\n",
       "    35.94,\n",
       "    None,\n",
       "    85137.0,\n",
       "    3038172.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-31',\n",
       "    35.24,\n",
       "    35.24,\n",
       "    34.56,\n",
       "    34.56,\n",
       "    None,\n",
       "    63371.0,\n",
       "    2199583.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-30',\n",
       "    35.38,\n",
       "    35.59,\n",
       "    34.95,\n",
       "    35.15,\n",
       "    None,\n",
       "    69603.0,\n",
       "    2457762.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-27',\n",
       "    34.83,\n",
       "    35.43,\n",
       "    34.81,\n",
       "    35.3,\n",
       "    None,\n",
       "    69657.0,\n",
       "    2444913.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-26',\n",
       "    35.07,\n",
       "    35.58,\n",
       "    34.8,\n",
       "    34.89,\n",
       "    None,\n",
       "    64103.0,\n",
       "    2249375.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-25',\n",
       "    34.42,\n",
       "    34.86,\n",
       "    34.03,\n",
       "    34.83,\n",
       "    None,\n",
       "    56240.0,\n",
       "    1947147.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-24',\n",
       "    34.0,\n",
       "    34.35,\n",
       "    33.85,\n",
       "    34.22,\n",
       "    None,\n",
       "    48797.0,\n",
       "    1666086.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-23',\n",
       "    34.04,\n",
       "    34.12,\n",
       "    33.62,\n",
       "    34.06,\n",
       "    None,\n",
       "    55333.0,\n",
       "    1877957.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-20',\n",
       "    34.54,\n",
       "    34.59,\n",
       "    34.05,\n",
       "    34.17,\n",
       "    None,\n",
       "    80246.0,\n",
       "    2743474.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-19',\n",
       "    35.04,\n",
       "    35.04,\n",
       "    34.42,\n",
       "    34.5,\n",
       "    None,\n",
       "    73105.0,\n",
       "    2526731.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-18',\n",
       "    35.04,\n",
       "    35.51,\n",
       "    34.8,\n",
       "    34.9,\n",
       "    None,\n",
       "    65931.0,\n",
       "    2311608.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-17',\n",
       "    35.06,\n",
       "    35.19,\n",
       "    34.79,\n",
       "    34.99,\n",
       "    None,\n",
       "    39195.0,\n",
       "    1369857.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-16',\n",
       "    34.85,\n",
       "    35.24,\n",
       "    34.56,\n",
       "    35.07,\n",
       "    None,\n",
       "    47879.0,\n",
       "    1678679.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-13',\n",
       "    34.98,\n",
       "    34.98,\n",
       "    34.6,\n",
       "    34.85,\n",
       "    None,\n",
       "    59367.0,\n",
       "    2065534.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-12',\n",
       "    35.38,\n",
       "    35.38,\n",
       "    34.31,\n",
       "    34.9,\n",
       "    None,\n",
       "    163860.0,\n",
       "    5703427.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-11',\n",
       "    34.95,\n",
       "    36.0,\n",
       "    34.84,\n",
       "    35.42,\n",
       "    None,\n",
       "    123530.0,\n",
       "    4369079.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-10',\n",
       "    34.8,\n",
       "    34.98,\n",
       "    34.46,\n",
       "    34.91,\n",
       "    None,\n",
       "    43976.0,\n",
       "    1528055.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-09',\n",
       "    35.29,\n",
       "    35.35,\n",
       "    34.43,\n",
       "    34.67,\n",
       "    None,\n",
       "    62225.0,\n",
       "    2157182.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-06',\n",
       "    34.91,\n",
       "    35.21,\n",
       "    34.91,\n",
       "    35.04,\n",
       "    None,\n",
       "    27507.0,\n",
       "    964046.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-05',\n",
       "    35.02,\n",
       "    35.2,\n",
       "    34.73,\n",
       "    35.06,\n",
       "    None,\n",
       "    48412.0,\n",
       "    1692326.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-04',\n",
       "    35.48,\n",
       "    35.51,\n",
       "    34.75,\n",
       "    35.19,\n",
       "    None,\n",
       "    54408.0,\n",
       "    1906810.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-03',\n",
       "    35.9,\n",
       "    35.93,\n",
       "    35.34,\n",
       "    35.48,\n",
       "    None,\n",
       "    70618.0,\n",
       "    2515473.0,\n",
       "    None,\n",
       "    None,\n",
       "    None],\n",
       "   ['2017-01-02',\n",
       "    34.99,\n",
       "    35.94,\n",
       "    34.99,\n",
       "    35.8,\n",
       "    None,\n",
       "    44700.0,\n",
       "    1590561.0,\n",
       "    None,\n",
       "    None,\n",
       "    None]],\n",
       "  'database_code': 'FSE',\n",
       "  'database_id': 6129,\n",
       "  'dataset_code': 'AFX_X',\n",
       "  'description': 'Stock Prices for Carl Zeiss Meditec (AFX) from the Frankfurt Stock Exchange.<br><br>Trading System: Xetra<br><br>ISIN: DE0005313704',\n",
       "  'end_date': '2017-12-31',\n",
       "  'frequency': 'daily',\n",
       "  'id': 10095370,\n",
       "  'limit': None,\n",
       "  'name': 'Carl Zeiss Meditec (AFX_X)',\n",
       "  'newest_available_date': '2018-11-23',\n",
       "  'oldest_available_date': '2000-06-07',\n",
       "  'order': None,\n",
       "  'premium': False,\n",
       "  'refreshed_at': '2018-11-23T22:34:22.231Z',\n",
       "  'start_date': '2017-01-01',\n",
       "  'transform': None,\n",
       "  'type': 'Time Series'}}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r1.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Q2 ANSWER"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "d_af = r1.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'dict'>\n"
     ]
    }
   ],
   "source": [
    "print(type(d_af))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Q3 ANSWER\n",
    "Calculate what the highest and lowest opening prices were for the stock in this period"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['dataset'])"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d_af.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['2017-12-29',\n",
       "  51.76,\n",
       "  51.94,\n",
       "  51.45,\n",
       "  51.76,\n",
       "  None,\n",
       "  34640.0,\n",
       "  1792304.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-28',\n",
       "  51.65,\n",
       "  51.82,\n",
       "  51.43,\n",
       "  51.6,\n",
       "  None,\n",
       "  40660.0,\n",
       "  2099024.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-27',\n",
       "  51.45,\n",
       "  51.89,\n",
       "  50.76,\n",
       "  51.82,\n",
       "  None,\n",
       "  57452.0,\n",
       "  2957018.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-22',\n",
       "  51.05,\n",
       "  51.5,\n",
       "  50.92,\n",
       "  51.32,\n",
       "  None,\n",
       "  71165.0,\n",
       "  3641949.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-21',\n",
       "  51.16,\n",
       "  51.52,\n",
       "  50.9,\n",
       "  51.4,\n",
       "  None,\n",
       "  120649.0,\n",
       "  6179433.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-20',\n",
       "  51.88,\n",
       "  52.04,\n",
       "  51.2,\n",
       "  51.27,\n",
       "  None,\n",
       "  50587.0,\n",
       "  2610258.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-19',\n",
       "  52.73,\n",
       "  52.73,\n",
       "  51.07,\n",
       "  51.66,\n",
       "  None,\n",
       "  137313.0,\n",
       "  7102361.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-18',\n",
       "  52.37,\n",
       "  52.75,\n",
       "  51.61,\n",
       "  52.62,\n",
       "  None,\n",
       "  129733.0,\n",
       "  6770499.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-15',\n",
       "  52.7,\n",
       "  52.7,\n",
       "  51.64,\n",
       "  52.01,\n",
       "  None,\n",
       "  204080.0,\n",
       "  10596319.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-14',\n",
       "  53.11,\n",
       "  53.54,\n",
       "  52.15,\n",
       "  52.67,\n",
       "  None,\n",
       "  132981.0,\n",
       "  7016953.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-13',\n",
       "  52.64,\n",
       "  53.35,\n",
       "  52.48,\n",
       "  53.09,\n",
       "  None,\n",
       "  128434.0,\n",
       "  6801159.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-12',\n",
       "  52.29,\n",
       "  53.1,\n",
       "  51.82,\n",
       "  52.43,\n",
       "  None,\n",
       "  87911.0,\n",
       "  4615924.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-11',\n",
       "  52.28,\n",
       "  52.45,\n",
       "  51.26,\n",
       "  52.14,\n",
       "  None,\n",
       "  71817.0,\n",
       "  3724193.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-08',\n",
       "  51.5,\n",
       "  52.83,\n",
       "  51.28,\n",
       "  52.12,\n",
       "  None,\n",
       "  109157.0,\n",
       "  5690648.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-07',\n",
       "  50.89,\n",
       "  51.47,\n",
       "  50.81,\n",
       "  51.47,\n",
       "  None,\n",
       "  48123.0,\n",
       "  2463848.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-06',\n",
       "  50.8,\n",
       "  51.11,\n",
       "  50.39,\n",
       "  50.89,\n",
       "  None,\n",
       "  88730.0,\n",
       "  4504075.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-05',\n",
       "  51.21,\n",
       "  51.38,\n",
       "  50.4,\n",
       "  51.25,\n",
       "  None,\n",
       "  83023.0,\n",
       "  4231971.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-04',\n",
       "  49.5,\n",
       "  51.23,\n",
       "  49.5,\n",
       "  51.14,\n",
       "  None,\n",
       "  94385.0,\n",
       "  4800027.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-12-01',\n",
       "  49.52,\n",
       "  50.49,\n",
       "  49.17,\n",
       "  49.86,\n",
       "  None,\n",
       "  101733.0,\n",
       "  5065932.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-30',\n",
       "  48.64,\n",
       "  49.84,\n",
       "  48.28,\n",
       "  49.7,\n",
       "  None,\n",
       "  123019.0,\n",
       "  6085171.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-29',\n",
       "  49.64,\n",
       "  49.64,\n",
       "  48.7,\n",
       "  48.75,\n",
       "  None,\n",
       "  67342.0,\n",
       "  3292223.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-28',\n",
       "  49.09,\n",
       "  49.89,\n",
       "  49.03,\n",
       "  49.25,\n",
       "  None,\n",
       "  42669.0,\n",
       "  2107358.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-27',\n",
       "  49.13,\n",
       "  49.73,\n",
       "  48.96,\n",
       "  49.2,\n",
       "  None,\n",
       "  102180.0,\n",
       "  5055762.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-24',\n",
       "  49.11,\n",
       "  49.41,\n",
       "  48.87,\n",
       "  49.11,\n",
       "  None,\n",
       "  50350.0,\n",
       "  2472842.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-23',\n",
       "  48.8,\n",
       "  49.46,\n",
       "  48.45,\n",
       "  49.2,\n",
       "  None,\n",
       "  38834.0,\n",
       "  1909352.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-22',\n",
       "  48.4,\n",
       "  49.61,\n",
       "  48.39,\n",
       "  48.8,\n",
       "  None,\n",
       "  91142.0,\n",
       "  4478093.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-21',\n",
       "  47.25,\n",
       "  48.59,\n",
       "  46.78,\n",
       "  48.39,\n",
       "  None,\n",
       "  78502.0,\n",
       "  3782098.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-20',\n",
       "  46.57,\n",
       "  47.38,\n",
       "  46.54,\n",
       "  47.04,\n",
       "  None,\n",
       "  97252.0,\n",
       "  4563515.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-17',\n",
       "  47.03,\n",
       "  47.15,\n",
       "  46.8,\n",
       "  46.84,\n",
       "  None,\n",
       "  54107.0,\n",
       "  2540820.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-16',\n",
       "  47.09,\n",
       "  47.23,\n",
       "  46.55,\n",
       "  47.03,\n",
       "  None,\n",
       "  89373.0,\n",
       "  4195732.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-15',\n",
       "  47.98,\n",
       "  48.01,\n",
       "  46.75,\n",
       "  47.05,\n",
       "  None,\n",
       "  67593.0,\n",
       "  3188321.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-14',\n",
       "  48.4,\n",
       "  48.9,\n",
       "  47.84,\n",
       "  48.0,\n",
       "  None,\n",
       "  67672.0,\n",
       "  3259979.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-13',\n",
       "  48.38,\n",
       "  48.61,\n",
       "  47.76,\n",
       "  48.34,\n",
       "  None,\n",
       "  76286.0,\n",
       "  3681337.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-10',\n",
       "  47.3,\n",
       "  48.89,\n",
       "  47.16,\n",
       "  48.34,\n",
       "  None,\n",
       "  90245.0,\n",
       "  4361552.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-09',\n",
       "  47.65,\n",
       "  48.06,\n",
       "  47.09,\n",
       "  47.21,\n",
       "  None,\n",
       "  120268.0,\n",
       "  5712034.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-08',\n",
       "  46.42,\n",
       "  47.72,\n",
       "  46.42,\n",
       "  47.47,\n",
       "  None,\n",
       "  94195.0,\n",
       "  4463935.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-07',\n",
       "  46.16,\n",
       "  46.33,\n",
       "  45.84,\n",
       "  46.26,\n",
       "  None,\n",
       "  48152.0,\n",
       "  2224221.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-06',\n",
       "  45.81,\n",
       "  46.09,\n",
       "  45.76,\n",
       "  45.99,\n",
       "  None,\n",
       "  60716.0,\n",
       "  2789220.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-03',\n",
       "  45.0,\n",
       "  46.04,\n",
       "  44.83,\n",
       "  45.97,\n",
       "  None,\n",
       "  56911.0,\n",
       "  2603498.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-02',\n",
       "  45.88,\n",
       "  46.06,\n",
       "  45.18,\n",
       "  45.27,\n",
       "  None,\n",
       "  37958.0,\n",
       "  1724840.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-11-01',\n",
       "  46.29,\n",
       "  46.55,\n",
       "  45.97,\n",
       "  46.04,\n",
       "  None,\n",
       "  56319.0,\n",
       "  2603859.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-30',\n",
       "  46.53,\n",
       "  46.65,\n",
       "  45.61,\n",
       "  45.76,\n",
       "  None,\n",
       "  56245.0,\n",
       "  2585397.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-27',\n",
       "  45.48,\n",
       "  46.42,\n",
       "  45.46,\n",
       "  46.41,\n",
       "  None,\n",
       "  74472.0,\n",
       "  3434087.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-26',\n",
       "  45.2,\n",
       "  45.41,\n",
       "  44.91,\n",
       "  45.41,\n",
       "  None,\n",
       "  56319.0,\n",
       "  2548078.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-25',\n",
       "  45.01,\n",
       "  45.06,\n",
       "  44.7,\n",
       "  45.0,\n",
       "  None,\n",
       "  47730.0,\n",
       "  2145697.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-24',\n",
       "  45.16,\n",
       "  45.27,\n",
       "  44.75,\n",
       "  44.85,\n",
       "  None,\n",
       "  43042.0,\n",
       "  1937616.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-23',\n",
       "  44.9,\n",
       "  45.34,\n",
       "  44.89,\n",
       "  45.0,\n",
       "  None,\n",
       "  43375.0,\n",
       "  1952918.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-20',\n",
       "  45.08,\n",
       "  45.34,\n",
       "  44.76,\n",
       "  44.87,\n",
       "  None,\n",
       "  55707.0,\n",
       "  2503853.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-19',\n",
       "  45.72,\n",
       "  45.85,\n",
       "  44.79,\n",
       "  45.0,\n",
       "  None,\n",
       "  59991.0,\n",
       "  2703085.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-18',\n",
       "  46.01,\n",
       "  46.2,\n",
       "  45.61,\n",
       "  45.77,\n",
       "  None,\n",
       "  45263.0,\n",
       "  2076951.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-17',\n",
       "  45.8,\n",
       "  46.06,\n",
       "  45.37,\n",
       "  45.96,\n",
       "  None,\n",
       "  65837.0,\n",
       "  3014080.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-16',\n",
       "  45.61,\n",
       "  45.75,\n",
       "  45.3,\n",
       "  45.55,\n",
       "  None,\n",
       "  49246.0,\n",
       "  2243129.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-13',\n",
       "  45.5,\n",
       "  45.7,\n",
       "  45.37,\n",
       "  45.4,\n",
       "  None,\n",
       "  43362.0,\n",
       "  1971801.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-12',\n",
       "  45.58,\n",
       "  45.58,\n",
       "  45.17,\n",
       "  45.43,\n",
       "  None,\n",
       "  49180.0,\n",
       "  2233481.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-11',\n",
       "  45.97,\n",
       "  45.97,\n",
       "  45.25,\n",
       "  45.29,\n",
       "  None,\n",
       "  69455.0,\n",
       "  3158321.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-10',\n",
       "  45.64,\n",
       "  46.04,\n",
       "  45.57,\n",
       "  45.84,\n",
       "  None,\n",
       "  65860.0,\n",
       "  3016658.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-09',\n",
       "  46.2,\n",
       "  46.2,\n",
       "  45.6,\n",
       "  45.74,\n",
       "  None,\n",
       "  44059.0,\n",
       "  2015453.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-06',\n",
       "  46.19,\n",
       "  46.19,\n",
       "  45.69,\n",
       "  46.0,\n",
       "  None,\n",
       "  66760.0,\n",
       "  3066198.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-05',\n",
       "  46.01,\n",
       "  46.09,\n",
       "  45.63,\n",
       "  46.05,\n",
       "  None,\n",
       "  94804.0,\n",
       "  4352002.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-04',\n",
       "  45.36,\n",
       "  46.17,\n",
       "  45.22,\n",
       "  46.11,\n",
       "  None,\n",
       "  115706.0,\n",
       "  5313199.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-10-02',\n",
       "  44.51,\n",
       "  44.98,\n",
       "  44.18,\n",
       "  44.98,\n",
       "  None,\n",
       "  95313.0,\n",
       "  4265024.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-29',\n",
       "  43.58,\n",
       "  44.17,\n",
       "  43.3,\n",
       "  44.17,\n",
       "  None,\n",
       "  99821.0,\n",
       "  4384796.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-28',\n",
       "  42.0,\n",
       "  43.56,\n",
       "  42.0,\n",
       "  43.56,\n",
       "  None,\n",
       "  157234.0,\n",
       "  6775569.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-27',\n",
       "  42.35,\n",
       "  42.49,\n",
       "  41.78,\n",
       "  42.04,\n",
       "  None,\n",
       "  76600.0,\n",
       "  3219861.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-26',\n",
       "  42.3,\n",
       "  42.57,\n",
       "  42.11,\n",
       "  42.37,\n",
       "  None,\n",
       "  51321.0,\n",
       "  2175381.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-25',\n",
       "  42.3,\n",
       "  42.3,\n",
       "  41.96,\n",
       "  42.07,\n",
       "  None,\n",
       "  56224.0,\n",
       "  2366453.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-22',\n",
       "  41.48,\n",
       "  42.38,\n",
       "  41.48,\n",
       "  42.06,\n",
       "  None,\n",
       "  79955.0,\n",
       "  3362517.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-21',\n",
       "  42.29,\n",
       "  42.29,\n",
       "  41.39,\n",
       "  41.46,\n",
       "  None,\n",
       "  105194.0,\n",
       "  4378409.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-20',\n",
       "  42.54,\n",
       "  42.54,\n",
       "  41.99,\n",
       "  41.99,\n",
       "  None,\n",
       "  57838.0,\n",
       "  2440557.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-19',\n",
       "  42.65,\n",
       "  42.65,\n",
       "  42.13,\n",
       "  42.44,\n",
       "  None,\n",
       "  65546.0,\n",
       "  2777065.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-18',\n",
       "  42.5,\n",
       "  42.63,\n",
       "  42.23,\n",
       "  42.27,\n",
       "  None,\n",
       "  44037.0,\n",
       "  1864954.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-15',\n",
       "  42.29,\n",
       "  42.81,\n",
       "  42.25,\n",
       "  42.42,\n",
       "  None,\n",
       "  107144.0,\n",
       "  4555791.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-14',\n",
       "  42.35,\n",
       "  42.8,\n",
       "  42.35,\n",
       "  42.52,\n",
       "  None,\n",
       "  65157.0,\n",
       "  2770696.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-13',\n",
       "  42.49,\n",
       "  42.69,\n",
       "  42.22,\n",
       "  42.45,\n",
       "  None,\n",
       "  68801.0,\n",
       "  2921240.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-12',\n",
       "  43.21,\n",
       "  43.34,\n",
       "  42.62,\n",
       "  42.73,\n",
       "  None,\n",
       "  52828.0,\n",
       "  2259924.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-11',\n",
       "  42.81,\n",
       "  42.89,\n",
       "  42.56,\n",
       "  42.85,\n",
       "  None,\n",
       "  103273.0,\n",
       "  4415614.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-08',\n",
       "  42.7,\n",
       "  42.75,\n",
       "  42.56,\n",
       "  42.67,\n",
       "  None,\n",
       "  59881.0,\n",
       "  2553977.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-07',\n",
       "  43.0,\n",
       "  43.02,\n",
       "  42.67,\n",
       "  42.77,\n",
       "  None,\n",
       "  64320.0,\n",
       "  2751388.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-06',\n",
       "  42.66,\n",
       "  42.71,\n",
       "  42.34,\n",
       "  42.55,\n",
       "  None,\n",
       "  71006.0,\n",
       "  3020229.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-05',\n",
       "  43.0,\n",
       "  43.19,\n",
       "  42.55,\n",
       "  42.62,\n",
       "  None,\n",
       "  66351.0,\n",
       "  2846115.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-04',\n",
       "  42.38,\n",
       "  42.75,\n",
       "  41.95,\n",
       "  42.6,\n",
       "  None,\n",
       "  105288.0,\n",
       "  4471634.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-09-01',\n",
       "  42.16,\n",
       "  43.06,\n",
       "  42.07,\n",
       "  42.41,\n",
       "  None,\n",
       "  151474.0,\n",
       "  6453558.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-31',\n",
       "  42.0,\n",
       "  42.08,\n",
       "  41.12,\n",
       "  41.9,\n",
       "  None,\n",
       "  157888.0,\n",
       "  6580200.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-30',\n",
       "  42.0,\n",
       "  42.2,\n",
       "  41.49,\n",
       "  41.94,\n",
       "  None,\n",
       "  97804.0,\n",
       "  4090262.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-29',\n",
       "  41.71,\n",
       "  41.98,\n",
       "  41.33,\n",
       "  41.85,\n",
       "  None,\n",
       "  98156.0,\n",
       "  4094452.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-28',\n",
       "  42.11,\n",
       "  42.25,\n",
       "  41.86,\n",
       "  41.91,\n",
       "  None,\n",
       "  47130.0,\n",
       "  1978704.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-25',\n",
       "  42.64,\n",
       "  42.64,\n",
       "  42.05,\n",
       "  42.14,\n",
       "  None,\n",
       "  69734.0,\n",
       "  2948016.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-24',\n",
       "  42.72,\n",
       "  43.05,\n",
       "  42.63,\n",
       "  42.69,\n",
       "  None,\n",
       "  65213.0,\n",
       "  2792319.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-23',\n",
       "  42.82,\n",
       "  43.17,\n",
       "  42.6,\n",
       "  42.71,\n",
       "  None,\n",
       "  70269.0,\n",
       "  3011578.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-22',\n",
       "  42.46,\n",
       "  42.96,\n",
       "  42.4,\n",
       "  42.71,\n",
       "  None,\n",
       "  95376.0,\n",
       "  4075646.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-21',\n",
       "  42.42,\n",
       "  42.76,\n",
       "  42.2,\n",
       "  42.26,\n",
       "  None,\n",
       "  68812.0,\n",
       "  2922972.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-18',\n",
       "  42.28,\n",
       "  42.6,\n",
       "  42.01,\n",
       "  42.41,\n",
       "  None,\n",
       "  72886.0,\n",
       "  3092377.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-17',\n",
       "  41.88,\n",
       "  43.01,\n",
       "  41.76,\n",
       "  42.5,\n",
       "  None,\n",
       "  131361.0,\n",
       "  5583704.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-16',\n",
       "  42.4,\n",
       "  42.62,\n",
       "  41.98,\n",
       "  42.05,\n",
       "  None,\n",
       "  104676.0,\n",
       "  4408312.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-15',\n",
       "  42.53,\n",
       "  42.53,\n",
       "  42.2,\n",
       "  42.28,\n",
       "  None,\n",
       "  64334.0,\n",
       "  2721852.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-14',\n",
       "  42.12,\n",
       "  42.69,\n",
       "  42.01,\n",
       "  42.3,\n",
       "  None,\n",
       "  127682.0,\n",
       "  5416963.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-11',\n",
       "  41.3,\n",
       "  41.94,\n",
       "  40.96,\n",
       "  41.94,\n",
       "  None,\n",
       "  183412.0,\n",
       "  7604144.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-10',\n",
       "  41.73,\n",
       "  41.99,\n",
       "  41.14,\n",
       "  41.68,\n",
       "  None,\n",
       "  175161.0,\n",
       "  7303562.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-09',\n",
       "  43.5,\n",
       "  43.5,\n",
       "  41.64,\n",
       "  41.81,\n",
       "  None,\n",
       "  355857.0,\n",
       "  15003956.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-08',\n",
       "  44.9,\n",
       "  45.09,\n",
       "  44.15,\n",
       "  44.37,\n",
       "  None,\n",
       "  156168.0,\n",
       "  6941408.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-07',\n",
       "  45.85,\n",
       "  46.34,\n",
       "  44.02,\n",
       "  44.96,\n",
       "  None,\n",
       "  164543.0,\n",
       "  7378816.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-04',\n",
       "  45.13,\n",
       "  45.13,\n",
       "  44.36,\n",
       "  45.07,\n",
       "  None,\n",
       "  96202.0,\n",
       "  4306911.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-03',\n",
       "  45.34,\n",
       "  45.54,\n",
       "  44.91,\n",
       "  44.97,\n",
       "  None,\n",
       "  77854.0,\n",
       "  3517146.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-02',\n",
       "  45.25,\n",
       "  45.77,\n",
       "  44.9,\n",
       "  45.56,\n",
       "  None,\n",
       "  187468.0,\n",
       "  8528548.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-08-01',\n",
       "  45.24,\n",
       "  45.54,\n",
       "  45.1,\n",
       "  45.45,\n",
       "  None,\n",
       "  74975.0,\n",
       "  3399891.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-31',\n",
       "  44.94,\n",
       "  45.75,\n",
       "  44.94,\n",
       "  45.3,\n",
       "  None,\n",
       "  62672.0,\n",
       "  2844210.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-28',\n",
       "  45.26,\n",
       "  45.29,\n",
       "  44.75,\n",
       "  44.97,\n",
       "  None,\n",
       "  114006.0,\n",
       "  5127247.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-27',\n",
       "  45.16,\n",
       "  45.45,\n",
       "  45.15,\n",
       "  45.25,\n",
       "  None,\n",
       "  50557.0,\n",
       "  2290284.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-26',\n",
       "  44.91,\n",
       "  45.33,\n",
       "  44.46,\n",
       "  45.16,\n",
       "  None,\n",
       "  81970.0,\n",
       "  3688510.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-25',\n",
       "  44.7,\n",
       "  45.04,\n",
       "  44.63,\n",
       "  44.82,\n",
       "  None,\n",
       "  112224.0,\n",
       "  5033312.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-24',\n",
       "  45.31,\n",
       "  45.31,\n",
       "  44.49,\n",
       "  44.61,\n",
       "  None,\n",
       "  104282.0,\n",
       "  4661866.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-21',\n",
       "  45.57,\n",
       "  45.88,\n",
       "  45.04,\n",
       "  45.44,\n",
       "  None,\n",
       "  73422.0,\n",
       "  3334695.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-20',\n",
       "  45.74,\n",
       "  45.96,\n",
       "  45.23,\n",
       "  45.66,\n",
       "  None,\n",
       "  87399.0,\n",
       "  3986488.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-19',\n",
       "  45.06,\n",
       "  45.72,\n",
       "  44.94,\n",
       "  45.57,\n",
       "  None,\n",
       "  71971.0,\n",
       "  3273001.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-18',\n",
       "  45.5,\n",
       "  45.55,\n",
       "  44.7,\n",
       "  45.0,\n",
       "  None,\n",
       "  104003.0,\n",
       "  4684627.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-17',\n",
       "  45.6,\n",
       "  46.23,\n",
       "  45.29,\n",
       "  45.6,\n",
       "  None,\n",
       "  104995.0,\n",
       "  4801806.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-14',\n",
       "  45.07,\n",
       "  45.56,\n",
       "  44.83,\n",
       "  45.53,\n",
       "  None,\n",
       "  67375.0,\n",
       "  3054060.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-13',\n",
       "  44.67,\n",
       "  45.18,\n",
       "  44.67,\n",
       "  44.95,\n",
       "  None,\n",
       "  82745.0,\n",
       "  3718928.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-12',\n",
       "  44.29,\n",
       "  45.05,\n",
       "  43.89,\n",
       "  44.95,\n",
       "  None,\n",
       "  115705.0,\n",
       "  5133971.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-11',\n",
       "  44.94,\n",
       "  44.94,\n",
       "  44.08,\n",
       "  44.2,\n",
       "  None,\n",
       "  90538.0,\n",
       "  4010457.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-10',\n",
       "  44.64,\n",
       "  45.18,\n",
       "  44.51,\n",
       "  44.7,\n",
       "  None,\n",
       "  71868.0,\n",
       "  3221218.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-07',\n",
       "  44.79,\n",
       "  44.79,\n",
       "  44.25,\n",
       "  44.53,\n",
       "  None,\n",
       "  47999.0,\n",
       "  2136578.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-06',\n",
       "  45.5,\n",
       "  45.5,\n",
       "  44.15,\n",
       "  44.62,\n",
       "  None,\n",
       "  66116.0,\n",
       "  2952605.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-05',\n",
       "  44.67,\n",
       "  45.36,\n",
       "  44.44,\n",
       "  45.19,\n",
       "  None,\n",
       "  48706.0,\n",
       "  2189436.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-04',\n",
       "  45.83,\n",
       "  45.83,\n",
       "  44.74,\n",
       "  44.8,\n",
       "  None,\n",
       "  50549.0,\n",
       "  2273551.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-07-03',\n",
       "  45.29,\n",
       "  45.83,\n",
       "  45.06,\n",
       "  45.75,\n",
       "  None,\n",
       "  71381.0,\n",
       "  3251502.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-30',\n",
       "  45.01,\n",
       "  45.74,\n",
       "  45.0,\n",
       "  45.44,\n",
       "  None,\n",
       "  136112.0,\n",
       "  6187148.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-29',\n",
       "  45.73,\n",
       "  45.81,\n",
       "  45.11,\n",
       "  45.2,\n",
       "  None,\n",
       "  134965.0,\n",
       "  6132452.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-28',\n",
       "  46.68,\n",
       "  46.68,\n",
       "  45.41,\n",
       "  45.68,\n",
       "  None,\n",
       "  117165.0,\n",
       "  5381488.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-27',\n",
       "  47.23,\n",
       "  47.33,\n",
       "  46.39,\n",
       "  46.83,\n",
       "  None,\n",
       "  82492.0,\n",
       "  3866344.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-26',\n",
       "  46.95,\n",
       "  47.63,\n",
       "  46.91,\n",
       "  47.21,\n",
       "  None,\n",
       "  73322.0,\n",
       "  3465639.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-23',\n",
       "  47.29,\n",
       "  47.4,\n",
       "  46.79,\n",
       "  46.99,\n",
       "  None,\n",
       "  80586.0,\n",
       "  3792498.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-22',\n",
       "  47.03,\n",
       "  47.4,\n",
       "  46.75,\n",
       "  47.29,\n",
       "  None,\n",
       "  56071.0,\n",
       "  2640508.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-21',\n",
       "  47.46,\n",
       "  47.48,\n",
       "  46.53,\n",
       "  46.99,\n",
       "  None,\n",
       "  89752.0,\n",
       "  4206563.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-20',\n",
       "  46.48,\n",
       "  47.43,\n",
       "  46.27,\n",
       "  47.37,\n",
       "  None,\n",
       "  108334.0,\n",
       "  5109730.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-19',\n",
       "  46.9,\n",
       "  46.9,\n",
       "  46.25,\n",
       "  46.64,\n",
       "  None,\n",
       "  70056.0,\n",
       "  3260381.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-16',\n",
       "  45.66,\n",
       "  46.8,\n",
       "  45.66,\n",
       "  46.63,\n",
       "  None,\n",
       "  202214.0,\n",
       "  9411695.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-15',\n",
       "  46.34,\n",
       "  46.34,\n",
       "  45.21,\n",
       "  45.67,\n",
       "  None,\n",
       "  101733.0,\n",
       "  4635593.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-14',\n",
       "  46.52,\n",
       "  46.86,\n",
       "  46.05,\n",
       "  46.33,\n",
       "  None,\n",
       "  83741.0,\n",
       "  3881453.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-13',\n",
       "  46.5,\n",
       "  46.51,\n",
       "  46.03,\n",
       "  46.32,\n",
       "  None,\n",
       "  107644.0,\n",
       "  4981185.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-12',\n",
       "  47.31,\n",
       "  47.43,\n",
       "  45.89,\n",
       "  46.31,\n",
       "  None,\n",
       "  112942.0,\n",
       "  5238390.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-09',\n",
       "  46.77,\n",
       "  47.44,\n",
       "  46.55,\n",
       "  47.44,\n",
       "  None,\n",
       "  99674.0,\n",
       "  4702170.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-08',\n",
       "  47.8,\n",
       "  47.8,\n",
       "  46.27,\n",
       "  46.27,\n",
       "  None,\n",
       "  1945.0,\n",
       "  90599.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-07',\n",
       "  47.01,\n",
       "  47.43,\n",
       "  47.01,\n",
       "  47.43,\n",
       "  None,\n",
       "  1081.0,\n",
       "  51021.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-06',\n",
       "  47.12,\n",
       "  47.45,\n",
       "  46.21,\n",
       "  47.43,\n",
       "  None,\n",
       "  686.0,\n",
       "  32083.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-02',\n",
       "  46.8,\n",
       "  46.99,\n",
       "  46.72,\n",
       "  46.99,\n",
       "  None,\n",
       "  290.0,\n",
       "  13584.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-06-01',\n",
       "  46.12,\n",
       "  46.52,\n",
       "  45.89,\n",
       "  46.52,\n",
       "  None,\n",
       "  106513.0,\n",
       "  4930686.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-31',\n",
       "  45.22,\n",
       "  46.26,\n",
       "  45.22,\n",
       "  45.86,\n",
       "  None,\n",
       "  522.0,\n",
       "  24044.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-30',\n",
       "  45.05,\n",
       "  46.02,\n",
       "  45.05,\n",
       "  46.02,\n",
       "  None,\n",
       "  587.0,\n",
       "  26792.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-29',\n",
       "  45.61,\n",
       "  45.61,\n",
       "  45.24,\n",
       "  45.32,\n",
       "  None,\n",
       "  112.0,\n",
       "  5089.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-26',\n",
       "  44.8,\n",
       "  45.36,\n",
       "  44.71,\n",
       "  45.3,\n",
       "  None,\n",
       "  74453.0,\n",
       "  3360707.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-25',\n",
       "  44.8,\n",
       "  44.87,\n",
       "  44.29,\n",
       "  44.78,\n",
       "  None,\n",
       "  49970.0,\n",
       "  2231857.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-24',\n",
       "  43.92,\n",
       "  44.67,\n",
       "  43.92,\n",
       "  44.53,\n",
       "  None,\n",
       "  111923.0,\n",
       "  4971343.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-23',\n",
       "  43.67,\n",
       "  44.13,\n",
       "  43.55,\n",
       "  43.9,\n",
       "  None,\n",
       "  38308.0,\n",
       "  1681904.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-22',\n",
       "  44.16,\n",
       "  44.22,\n",
       "  43.44,\n",
       "  43.84,\n",
       "  None,\n",
       "  70856.0,\n",
       "  3103013.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-19',\n",
       "  43.74,\n",
       "  44.12,\n",
       "  43.74,\n",
       "  44.12,\n",
       "  None,\n",
       "  45.0,\n",
       "  1980.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-18',\n",
       "  44.0,\n",
       "  44.3,\n",
       "  43.29,\n",
       "  43.98,\n",
       "  None,\n",
       "  166160.0,\n",
       "  7277314.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-17',\n",
       "  45.06,\n",
       "  45.34,\n",
       "  44.01,\n",
       "  44.19,\n",
       "  None,\n",
       "  149515.0,\n",
       "  6664744.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-16',\n",
       "  45.15,\n",
       "  45.36,\n",
       "  44.56,\n",
       "  45.31,\n",
       "  None,\n",
       "  101476.0,\n",
       "  4567885.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-15',\n",
       "  45.09,\n",
       "  45.78,\n",
       "  44.31,\n",
       "  45.14,\n",
       "  None,\n",
       "  193702.0,\n",
       "  8734286.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-12',\n",
       "  45.18,\n",
       "  45.18,\n",
       "  44.16,\n",
       "  44.99,\n",
       "  None,\n",
       "  159495.0,\n",
       "  7113519.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-11',\n",
       "  43.4,\n",
       "  46.06,\n",
       "  43.25,\n",
       "  45.0,\n",
       "  None,\n",
       "  189125.0,\n",
       "  8496322.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-10',\n",
       "  43.5,\n",
       "  43.6,\n",
       "  42.53,\n",
       "  43.28,\n",
       "  None,\n",
       "  91858.0,\n",
       "  3958630.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-09',\n",
       "  41.83,\n",
       "  43.55,\n",
       "  41.82,\n",
       "  43.3,\n",
       "  None,\n",
       "  151439.0,\n",
       "  6538516.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-08',\n",
       "  43.0,\n",
       "  43.0,\n",
       "  42.04,\n",
       "  42.24,\n",
       "  None,\n",
       "  97456.0,\n",
       "  4128048.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-05',\n",
       "  42.52,\n",
       "  42.91,\n",
       "  42.38,\n",
       "  42.75,\n",
       "  None,\n",
       "  78512.0,\n",
       "  3353971.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-04',\n",
       "  41.86,\n",
       "  42.5,\n",
       "  41.71,\n",
       "  42.5,\n",
       "  None,\n",
       "  82058.0,\n",
       "  3465505.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-03',\n",
       "  42.2,\n",
       "  42.29,\n",
       "  41.78,\n",
       "  41.9,\n",
       "  None,\n",
       "  65266.0,\n",
       "  2738394.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-02',\n",
       "  41.89,\n",
       "  42.23,\n",
       "  41.76,\n",
       "  42.15,\n",
       "  None,\n",
       "  86559.0,\n",
       "  3636583.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-05-01',\n",
       "  None,\n",
       "  42.245,\n",
       "  41.655,\n",
       "  41.72,\n",
       "  -0.44,\n",
       "  86348.0,\n",
       "  3606589.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-28',\n",
       "  42.17,\n",
       "  42.25,\n",
       "  41.66,\n",
       "  41.72,\n",
       "  None,\n",
       "  86348.0,\n",
       "  3606589.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-27',\n",
       "  41.51,\n",
       "  42.24,\n",
       "  41.51,\n",
       "  42.16,\n",
       "  None,\n",
       "  151683.0,\n",
       "  6380639.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-26',\n",
       "  41.88,\n",
       "  41.94,\n",
       "  41.4,\n",
       "  41.5,\n",
       "  None,\n",
       "  65847.0,\n",
       "  2743109.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-25',\n",
       "  41.93,\n",
       "  42.18,\n",
       "  41.66,\n",
       "  41.89,\n",
       "  None,\n",
       "  85973.0,\n",
       "  3604204.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-24',\n",
       "  42.01,\n",
       "  42.02,\n",
       "  41.23,\n",
       "  41.81,\n",
       "  None,\n",
       "  102084.0,\n",
       "  4247032.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-21',\n",
       "  41.97,\n",
       "  42.14,\n",
       "  41.01,\n",
       "  41.32,\n",
       "  None,\n",
       "  186784.0,\n",
       "  7728103.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-20',\n",
       "  42.5,\n",
       "  42.64,\n",
       "  41.52,\n",
       "  41.93,\n",
       "  None,\n",
       "  223621.0,\n",
       "  9418192.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-19',\n",
       "  41.94,\n",
       "  42.61,\n",
       "  41.94,\n",
       "  42.61,\n",
       "  None,\n",
       "  92722.0,\n",
       "  3930856.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-18',\n",
       "  42.24,\n",
       "  42.4,\n",
       "  41.54,\n",
       "  42.0,\n",
       "  None,\n",
       "  133057.0,\n",
       "  5587565.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-17',\n",
       "  None,\n",
       "  42.48,\n",
       "  41.985,\n",
       "  42.2,\n",
       "  None,\n",
       "  88416.0,\n",
       "  3734717.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-14',\n",
       "  None,\n",
       "  42.48,\n",
       "  41.985,\n",
       "  42.2,\n",
       "  None,\n",
       "  88416.0,\n",
       "  3734717.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-13',\n",
       "  42.06,\n",
       "  42.48,\n",
       "  41.99,\n",
       "  42.2,\n",
       "  None,\n",
       "  88416.0,\n",
       "  3734717.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-12',\n",
       "  42.02,\n",
       "  42.45,\n",
       "  41.84,\n",
       "  42.2,\n",
       "  None,\n",
       "  158278.0,\n",
       "  6672547.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-11',\n",
       "  41.62,\n",
       "  42.03,\n",
       "  41.53,\n",
       "  41.75,\n",
       "  None,\n",
       "  107817.0,\n",
       "  4501109.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-10',\n",
       "  41.46,\n",
       "  41.68,\n",
       "  41.31,\n",
       "  41.68,\n",
       "  None,\n",
       "  62297.0,\n",
       "  2585922.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-07',\n",
       "  40.9,\n",
       "  41.42,\n",
       "  40.84,\n",
       "  41.42,\n",
       "  None,\n",
       "  81255.0,\n",
       "  3344628.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-06',\n",
       "  40.96,\n",
       "  41.25,\n",
       "  40.83,\n",
       "  41.05,\n",
       "  None,\n",
       "  96794.0,\n",
       "  3968681.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-05',\n",
       "  41.1,\n",
       "  41.34,\n",
       "  40.79,\n",
       "  41.1,\n",
       "  None,\n",
       "  156005.0,\n",
       "  6404780.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-04',\n",
       "  39.5,\n",
       "  40.88,\n",
       "  39.48,\n",
       "  40.81,\n",
       "  None,\n",
       "  193156.0,\n",
       "  7822665.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-04-03',\n",
       "  40.15,\n",
       "  40.15,\n",
       "  39.54,\n",
       "  39.64,\n",
       "  None,\n",
       "  127973.0,\n",
       "  5081376.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-31',\n",
       "  39.77,\n",
       "  40.07,\n",
       "  39.42,\n",
       "  39.98,\n",
       "  None,\n",
       "  95382.0,\n",
       "  3795061.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-30',\n",
       "  40.02,\n",
       "  40.14,\n",
       "  39.42,\n",
       "  39.75,\n",
       "  None,\n",
       "  189201.0,\n",
       "  7541354.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-29',\n",
       "  39.39,\n",
       "  40.01,\n",
       "  39.05,\n",
       "  40.01,\n",
       "  None,\n",
       "  335406.0,\n",
       "  13349426.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-28',\n",
       "  38.95,\n",
       "  39.35,\n",
       "  38.79,\n",
       "  39.22,\n",
       "  None,\n",
       "  115075.0,\n",
       "  4505494.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-27',\n",
       "  38.73,\n",
       "  39.1,\n",
       "  38.53,\n",
       "  38.85,\n",
       "  None,\n",
       "  191515.0,\n",
       "  7446952.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-24',\n",
       "  38.94,\n",
       "  39.02,\n",
       "  38.6,\n",
       "  38.94,\n",
       "  None,\n",
       "  210926.0,\n",
       "  8205507.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-23',\n",
       "  39.01,\n",
       "  39.25,\n",
       "  38.63,\n",
       "  38.96,\n",
       "  None,\n",
       "  169971.0,\n",
       "  6621807.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-22',\n",
       "  38.25,\n",
       "  39.02,\n",
       "  37.53,\n",
       "  38.94,\n",
       "  None,\n",
       "  670349.0,\n",
       "  25910543.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-21',\n",
       "  41.8,\n",
       "  41.83,\n",
       "  40.97,\n",
       "  40.98,\n",
       "  None,\n",
       "  56906.0,\n",
       "  2349965.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-20',\n",
       "  41.26,\n",
       "  42.17,\n",
       "  41.26,\n",
       "  41.97,\n",
       "  None,\n",
       "  97572.0,\n",
       "  4074891.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-17',\n",
       "  41.47,\n",
       "  41.59,\n",
       "  41.16,\n",
       "  41.34,\n",
       "  None,\n",
       "  90109.0,\n",
       "  3734232.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-16',\n",
       "  41.4,\n",
       "  41.57,\n",
       "  41.09,\n",
       "  41.46,\n",
       "  None,\n",
       "  55799.0,\n",
       "  2308423.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-15',\n",
       "  41.4,\n",
       "  41.5,\n",
       "  40.91,\n",
       "  41.25,\n",
       "  None,\n",
       "  60324.0,\n",
       "  2488650.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-14',\n",
       "  41.2,\n",
       "  41.5,\n",
       "  41.2,\n",
       "  41.3,\n",
       "  None,\n",
       "  60420.0,\n",
       "  2498025.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-13',\n",
       "  41.4,\n",
       "  41.46,\n",
       "  41.08,\n",
       "  41.3,\n",
       "  None,\n",
       "  44803.0,\n",
       "  1850251.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-10',\n",
       "  41.53,\n",
       "  41.53,\n",
       "  41.16,\n",
       "  41.4,\n",
       "  None,\n",
       "  38518.0,\n",
       "  1592270.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-09',\n",
       "  41.61,\n",
       "  41.61,\n",
       "  41.16,\n",
       "  41.4,\n",
       "  None,\n",
       "  43988.0,\n",
       "  1819182.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-08',\n",
       "  41.13,\n",
       "  41.71,\n",
       "  40.95,\n",
       "  41.68,\n",
       "  None,\n",
       "  45111.0,\n",
       "  1870935.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-07',\n",
       "  41.5,\n",
       "  41.8,\n",
       "  41.25,\n",
       "  41.42,\n",
       "  None,\n",
       "  61925.0,\n",
       "  2569608.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-06',\n",
       "  41.25,\n",
       "  41.4,\n",
       "  40.81,\n",
       "  41.4,\n",
       "  None,\n",
       "  46510.0,\n",
       "  1916799.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-03',\n",
       "  41.12,\n",
       "  41.22,\n",
       "  40.84,\n",
       "  41.18,\n",
       "  None,\n",
       "  40800.0,\n",
       "  1675587.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-02',\n",
       "  41.38,\n",
       "  41.39,\n",
       "  40.76,\n",
       "  41.17,\n",
       "  None,\n",
       "  49863.0,\n",
       "  2048153.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-03-01',\n",
       "  41.19,\n",
       "  41.57,\n",
       "  40.9,\n",
       "  41.2,\n",
       "  None,\n",
       "  86753.0,\n",
       "  3569796.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-28',\n",
       "  40.38,\n",
       "  40.95,\n",
       "  40.38,\n",
       "  40.84,\n",
       "  None,\n",
       "  67440.0,\n",
       "  2747011.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-27',\n",
       "  39.75,\n",
       "  40.64,\n",
       "  39.75,\n",
       "  40.39,\n",
       "  None,\n",
       "  62655.0,\n",
       "  2520260.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-24',\n",
       "  39.77,\n",
       "  40.14,\n",
       "  38.91,\n",
       "  39.74,\n",
       "  None,\n",
       "  101294.0,\n",
       "  4015150.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-23',\n",
       "  39.72,\n",
       "  39.98,\n",
       "  39.38,\n",
       "  39.79,\n",
       "  None,\n",
       "  81945.0,\n",
       "  3260642.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-22',\n",
       "  39.6,\n",
       "  39.75,\n",
       "  39.27,\n",
       "  39.7,\n",
       "  None,\n",
       "  77619.0,\n",
       "  3066894.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-21',\n",
       "  38.85,\n",
       "  39.57,\n",
       "  38.85,\n",
       "  39.45,\n",
       "  None,\n",
       "  46070.0,\n",
       "  1808350.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-20',\n",
       "  39.25,\n",
       "  39.25,\n",
       "  38.81,\n",
       "  38.98,\n",
       "  None,\n",
       "  37014.0,\n",
       "  1444138.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-17',\n",
       "  38.8,\n",
       "  39.03,\n",
       "  38.48,\n",
       "  39.02,\n",
       "  None,\n",
       "  60583.0,\n",
       "  2352961.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-16',\n",
       "  38.8,\n",
       "  39.2,\n",
       "  38.25,\n",
       "  38.71,\n",
       "  None,\n",
       "  84682.0,\n",
       "  3282322.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-15',\n",
       "  38.5,\n",
       "  38.93,\n",
       "  38.4,\n",
       "  38.72,\n",
       "  None,\n",
       "  77420.0,\n",
       "  2996861.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-14',\n",
       "  38.81,\n",
       "  38.86,\n",
       "  38.0,\n",
       "  38.37,\n",
       "  None,\n",
       "  82601.0,\n",
       "  3163898.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-13',\n",
       "  37.37,\n",
       "  39.36,\n",
       "  37.35,\n",
       "  38.53,\n",
       "  None,\n",
       "  177171.0,\n",
       "  6804028.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-10',\n",
       "  36.65,\n",
       "  37.5,\n",
       "  36.57,\n",
       "  37.06,\n",
       "  None,\n",
       "  115843.0,\n",
       "  4291017.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-09',\n",
       "  36.2,\n",
       "  36.25,\n",
       "  35.77,\n",
       "  36.25,\n",
       "  None,\n",
       "  67781.0,\n",
       "  2445428.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-08',\n",
       "  35.98,\n",
       "  36.14,\n",
       "  35.84,\n",
       "  36.05,\n",
       "  None,\n",
       "  39731.0,\n",
       "  1431205.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-07',\n",
       "  35.56,\n",
       "  36.05,\n",
       "  35.36,\n",
       "  35.89,\n",
       "  None,\n",
       "  67410.0,\n",
       "  2410818.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-06',\n",
       "  36.06,\n",
       "  36.15,\n",
       "  35.6,\n",
       "  35.64,\n",
       "  None,\n",
       "  41911.0,\n",
       "  1496794.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-03',\n",
       "  36.02,\n",
       "  36.2,\n",
       "  35.73,\n",
       "  36.1,\n",
       "  None,\n",
       "  40705.0,\n",
       "  1464712.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-02',\n",
       "  35.95,\n",
       "  36.2,\n",
       "  35.7,\n",
       "  36.07,\n",
       "  None,\n",
       "  54279.0,\n",
       "  1953176.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-02-01',\n",
       "  34.75,\n",
       "  36.0,\n",
       "  34.75,\n",
       "  35.94,\n",
       "  None,\n",
       "  85137.0,\n",
       "  3038172.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-31',\n",
       "  35.24,\n",
       "  35.24,\n",
       "  34.56,\n",
       "  34.56,\n",
       "  None,\n",
       "  63371.0,\n",
       "  2199583.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-30',\n",
       "  35.38,\n",
       "  35.59,\n",
       "  34.95,\n",
       "  35.15,\n",
       "  None,\n",
       "  69603.0,\n",
       "  2457762.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-27',\n",
       "  34.83,\n",
       "  35.43,\n",
       "  34.81,\n",
       "  35.3,\n",
       "  None,\n",
       "  69657.0,\n",
       "  2444913.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-26',\n",
       "  35.07,\n",
       "  35.58,\n",
       "  34.8,\n",
       "  34.89,\n",
       "  None,\n",
       "  64103.0,\n",
       "  2249375.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-25',\n",
       "  34.42,\n",
       "  34.86,\n",
       "  34.03,\n",
       "  34.83,\n",
       "  None,\n",
       "  56240.0,\n",
       "  1947147.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-24',\n",
       "  34.0,\n",
       "  34.35,\n",
       "  33.85,\n",
       "  34.22,\n",
       "  None,\n",
       "  48797.0,\n",
       "  1666086.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-23',\n",
       "  34.04,\n",
       "  34.12,\n",
       "  33.62,\n",
       "  34.06,\n",
       "  None,\n",
       "  55333.0,\n",
       "  1877957.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-20',\n",
       "  34.54,\n",
       "  34.59,\n",
       "  34.05,\n",
       "  34.17,\n",
       "  None,\n",
       "  80246.0,\n",
       "  2743474.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-19',\n",
       "  35.04,\n",
       "  35.04,\n",
       "  34.42,\n",
       "  34.5,\n",
       "  None,\n",
       "  73105.0,\n",
       "  2526731.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-18',\n",
       "  35.04,\n",
       "  35.51,\n",
       "  34.8,\n",
       "  34.9,\n",
       "  None,\n",
       "  65931.0,\n",
       "  2311608.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-17',\n",
       "  35.06,\n",
       "  35.19,\n",
       "  34.79,\n",
       "  34.99,\n",
       "  None,\n",
       "  39195.0,\n",
       "  1369857.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-16',\n",
       "  34.85,\n",
       "  35.24,\n",
       "  34.56,\n",
       "  35.07,\n",
       "  None,\n",
       "  47879.0,\n",
       "  1678679.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-13',\n",
       "  34.98,\n",
       "  34.98,\n",
       "  34.6,\n",
       "  34.85,\n",
       "  None,\n",
       "  59367.0,\n",
       "  2065534.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-12',\n",
       "  35.38,\n",
       "  35.38,\n",
       "  34.31,\n",
       "  34.9,\n",
       "  None,\n",
       "  163860.0,\n",
       "  5703427.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-11',\n",
       "  34.95,\n",
       "  36.0,\n",
       "  34.84,\n",
       "  35.42,\n",
       "  None,\n",
       "  123530.0,\n",
       "  4369079.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-10',\n",
       "  34.8,\n",
       "  34.98,\n",
       "  34.46,\n",
       "  34.91,\n",
       "  None,\n",
       "  43976.0,\n",
       "  1528055.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-09',\n",
       "  35.29,\n",
       "  35.35,\n",
       "  34.43,\n",
       "  34.67,\n",
       "  None,\n",
       "  62225.0,\n",
       "  2157182.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-06',\n",
       "  34.91,\n",
       "  35.21,\n",
       "  34.91,\n",
       "  35.04,\n",
       "  None,\n",
       "  27507.0,\n",
       "  964046.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-05',\n",
       "  35.02,\n",
       "  35.2,\n",
       "  34.73,\n",
       "  35.06,\n",
       "  None,\n",
       "  48412.0,\n",
       "  1692326.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-04',\n",
       "  35.48,\n",
       "  35.51,\n",
       "  34.75,\n",
       "  35.19,\n",
       "  None,\n",
       "  54408.0,\n",
       "  1906810.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-03',\n",
       "  35.9,\n",
       "  35.93,\n",
       "  35.34,\n",
       "  35.48,\n",
       "  None,\n",
       "  70618.0,\n",
       "  2515473.0,\n",
       "  None,\n",
       "  None,\n",
       "  None],\n",
       " ['2017-01-02',\n",
       "  34.99,\n",
       "  35.94,\n",
       "  34.99,\n",
       "  35.8,\n",
       "  None,\n",
       "  44700.0,\n",
       "  1590561.0,\n",
       "  None,\n",
       "  None,\n",
       "  None]]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d_af['dataset']['data']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "open_pr = [data[1] for data in d_af['dataset']['data'] if data[1] is not None]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[51.76, 51.65, 51.45, 51.05, 51.16, 51.88, 52.73, 52.37, 52.7, 53.11, 52.64, 52.29, 52.28, 51.5, 50.89, 50.8, 51.21, 49.5, 49.52, 48.64, 49.64, 49.09, 49.13, 49.11, 48.8, 48.4, 47.25, 46.57, 47.03, 47.09, 47.98, 48.4, 48.38, 47.3, 47.65, 46.42, 46.16, 45.81, 45.0, 45.88, 46.29, 46.53, 45.48, 45.2, 45.01, 45.16, 44.9, 45.08, 45.72, 46.01, 45.8, 45.61, 45.5, 45.58, 45.97, 45.64, 46.2, 46.19, 46.01, 45.36, 44.51, 43.58, 42.0, 42.35, 42.3, 42.3, 41.48, 42.29, 42.54, 42.65, 42.5, 42.29, 42.35, 42.49, 43.21, 42.81, 42.7, 43.0, 42.66, 43.0, 42.38, 42.16, 42.0, 42.0, 41.71, 42.11, 42.64, 42.72, 42.82, 42.46, 42.42, 42.28, 41.88, 42.4, 42.53, 42.12, 41.3, 41.73, 43.5, 44.9, 45.85, 45.13, 45.34, 45.25, 45.24, 44.94, 45.26, 45.16, 44.91, 44.7, 45.31, 45.57, 45.74, 45.06, 45.5, 45.6, 45.07, 44.67, 44.29, 44.94, 44.64, 44.79, 45.5, 44.67, 45.83, 45.29, 45.01, 45.73, 46.68, 47.23, 46.95, 47.29, 47.03, 47.46, 46.48, 46.9, 45.66, 46.34, 46.52, 46.5, 47.31, 46.77, 47.8, 47.01, 47.12, 46.8, 46.12, 45.22, 45.05, 45.61, 44.8, 44.8, 43.92, 43.67, 44.16, 43.74, 44.0, 45.06, 45.15, 45.09, 45.18, 43.4, 43.5, 41.83, 43.0, 42.52, 41.86, 42.2, 41.89, 42.17, 41.51, 41.88, 41.93, 42.01, 41.97, 42.5, 41.94, 42.24, 42.06, 42.02, 41.62, 41.46, 40.9, 40.96, 41.1, 39.5, 40.15, 39.77, 40.02, 39.39, 38.95, 38.73, 38.94, 39.01, 38.25, 41.8, 41.26, 41.47, 41.4, 41.4, 41.2, 41.4, 41.53, 41.61, 41.13, 41.5, 41.25, 41.12, 41.38, 41.19, 40.38, 39.75, 39.77, 39.72, 39.6, 38.85, 39.25, 38.8, 38.8, 38.5, 38.81, 37.37, 36.65, 36.2, 35.98, 35.56, 36.06, 36.02, 35.95, 34.75, 35.24, 35.38, 34.83, 35.07, 34.42, 34.0, 34.04, 34.54, 35.04, 35.04, 35.06, 34.85, 34.98, 35.38, 34.95, 34.8, 35.29, 34.91, 35.02, 35.48, 35.9, 34.99]\n"
     ]
    }
   ],
   "source": [
    "print(open_pr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Opening Prices for 2017: Lowest is $34.00 and Highest is $53.11.\n"
     ]
    }
   ],
   "source": [
    "min_open = min(open_pr)\n",
    "max_open = max(open_pr)\n",
    "print(\"Opening Prices for 2017: Lowest is $%.2f and Highest is $%.2f.\" % (min_open, max_open))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Q4 ANSWER\n",
    "What was the largest change in any one day (based on High and Low price)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Largest Price Change for any one day in 2017 is $2.81.\n"
     ]
    }
   ],
   "source": [
    "larg_change = [(data[2]-data[3]) for data in d_af['dataset']['data']]\n",
    "print(\"Largest Price Change for any one day in 2017 is $%.2f.\" % (max(larg_change)))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Q5 ANSWER\n",
    "What was the largest change between any two days (based on Closing Price)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Create and populate a list for any 2-day changes\n",
    "two_daycha =[]\n",
    "prev_day_price = 0\n",
    "for data in d_af['dataset']['data']:\n",
    "    if prev_day_price == 0:\n",
    "        prev_day_price = data[4]\n",
    "    else:\n",
    "        two_daycha.append(data[4]-prev_day_price)\n",
    "        prev_day_price = data[4]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "#Calculate max and min for 2-day changes\n",
    "max_change = max(two_daycha)\n",
    "min_change = min(two_daycha)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Largest Price Change between any 2 days, based on Closing Price, in 2017 is $2.56.\n"
     ]
    }
   ],
   "source": [
    "if abs(min_change) > max_change:\n",
    "    print(\"Largest Price Change between any 2 days, based on Closing Price, \n",
    "          in 2017 is $%.2f.\" % abs(min_change))\n",
    "else: \n",
    "    print((\"Largest Price Change between any 2 days, based on Closing Price, \n",
    "           in 2017 is $%.2f.\" % (max_change)))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Q6 ANSWER\n",
    "What was the average daily trading volume during this year?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The avg daily trading volume during this year is 89124 trades.\n"
     ]
    }
   ],
   "source": [
    "ttl_vol = 0\n",
    "for data in d_af['dataset']['data']:\n",
    "    ttl_vol += data[6]\n",
    "print('The avg daily trading volume during this year is %d trades.' \n",
    "      % (ttl_vol/len(d_af['dataset']['data'])))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Q7 ANSWER (OPTIONAL)\n",
    "What was the median trading volume during this year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Median trading volume during this year is 76600 trades.\n"
     ]
    }
   ],
   "source": [
    "trad_vol = sorted([data[6] for data in d_af['dataset']['data']])\n",
    "trad_obs = len(trad_vol)\n",
    "half_obs = trad_obs/2\n",
    "if trad_obs % 2 == 1:\n",
    "    print(\"Median trading volume during this year is %d trades.\" \n",
    "          % trad_vol[round(half_obs)])\n",
    "else:\n",
    "      print(\"ERROR\")"
   ]
  },
  {
   "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.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}