api_data_wrangling_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",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'dataset': {'id': 9775687, 'dataset_code': 'FB', 'database_code': 'WIKI', 'name': 'Facebook Inc. (FB) Prices, Dividends, Splits and Trading Volume', 'description': \"End of day open, high, low, close and volume, dividends and splits, and split/dividend adjusted open, high, low close and volume for Facebook, Inc. (FB). Ex-Dividend is non-zero on ex-dividend dates. Split Ratio is 1 on non-split dates. Adjusted prices are calculated per CRSP (www.crsp.com/products/documentation/crsp-calculations)\\n\\nThis data is in the public domain. You may copy, distribute, disseminate or include the data in other products for commercial and/or noncommercial purposes.\\n\\nThis data is part of Quandl's Wiki initiative to get financial data permanently into the public domain. Quandl relies on users like you to flag errors and provide data where data is wrong or missing. Get involved: connect@quandl.com\\n\", 'refreshed_at': '2018-03-27T21:46:11.036Z', 'newest_available_date': '2018-03-27', 'oldest_available_date': '2012-05-18', 'column_names': ['Date', 'Open', 'High', 'Low', 'Close', 'Volume', 'Ex-Dividend', 'Split Ratio', 'Adj. Open', 'Adj. High', 'Adj. Low', 'Adj. Close', 'Adj. Volume'], 'frequency': 'daily', 'type': 'Time Series', 'premium': False, 'limit': None, 'transform': None, 'column_index': None, 'start_date': '2014-01-01', 'end_date': '2014-12-31', 'data': [['2014-12-31', 79.54, 79.8, 77.86, 78.02, 20040439.0, 0.0, 1.0, 79.54, 79.8, 77.86, 78.02, 20040439.0], ['2014-11-30', 77.67, 78.27, 77.23, 77.7, 15992035.0, 0.0, 1.0, 77.67, 78.27, 77.23, 77.7, 15992035.0], ['2014-10-31', 74.93, 75.7, 74.45, 74.99, 44544325.0, 0.0, 1.0, 74.93, 75.7, 74.45, 74.99, 44544325.0], ['2014-09-30', 79.35, 79.7067, 78.6, 79.04, 35899444.0, 0.0, 1.0, 79.35, 79.7067, 78.6, 79.04, 35899444.0], ['2014-08-31', 74.3, 74.82, 74.01, 74.82, 26224300.0, 0.0, 1.0, 74.3, 74.82, 74.01, 74.82, 26224300.0], ['2014-07-31', 74.0, 74.165, 72.44, 72.65, 43909200.0, 0.0, 1.0, 74.0, 74.165, 72.44, 72.65, 43909200.0], ['2014-06-30', 67.46, 67.92, 67.13, 67.29, 27102800.0, 0.0, 1.0, 67.46, 67.92, 67.13, 67.29, 27102800.0], ['2014-05-31', 63.95, 64.17, 62.56, 63.3, 45253500.0, 0.0, 1.0, 63.95, 64.17, 62.56, 63.3, 45253500.0], ['2014-04-30', 57.58, 59.85, 57.16, 59.78, 76093000.0, 0.0, 1.0, 57.58, 59.85, 57.16, 59.78, 76093000.0], ['2014-03-31', 60.78, 61.52, 59.87, 60.24, 53011000.0, 0.0, 1.0, 60.78, 61.52, 59.87, 60.24, 53011000.0], ['2014-02-28', 69.47, 69.88, 67.38, 68.46, 66783700.0, 0.0, 1.0, 69.47, 69.88, 67.38, 68.46, 66783700.0], ['2014-01-31', 60.47, 63.37, 60.17, 62.57, 87794600.0, 0.0, 1.0, 60.47, 63.37, 60.17, 62.57, 87794600.0]], 'collapse': 'monthly', 'order': None, 'database_id': 4922}}\n"
     ]
    }
   ],
   "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",
    "response =requests.get('https://www.quandl.com/api/v3/datasets/WIKI/FB.json?start_date=2014-01-01&end_date=2014-12-31&collapse=monthly&api_key=' + API_KEY)\n",
    "print(response.json())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "79.54\n",
      "2014-12-31\n"
     ]
    }
   ],
   "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",
    "#start and end date provides the data containing stock prices with in the range \n",
    "print(response.json()['dataset']['data'][0][1])# acessing stock specific date\n",
    "print(response.json()['dataset']['data'][0][0]) # accessing stock specific price \n"
   ]
  },
  {
   "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": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'dataset': {'id': 10095370,\n",
       "  'dataset_code': 'AFX_X',\n",
       "  'database_code': 'FSE',\n",
       "  'name': 'Carl Zeiss Meditec (AFX_X)',\n",
       "  'description': 'Stock Prices for Carl Zeiss Meditec (2019-08-23) from the Frankfurt Stock Exchange.<br><br>Trading System: Xetra<br><br>ISIN: DE0005313704',\n",
       "  'refreshed_at': '2019-09-06T22:29:23.358Z',\n",
       "  'newest_available_date': '2019-09-06',\n",
       "  'oldest_available_date': '2000-06-07',\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",
       "  'frequency': 'daily',\n",
       "  'type': 'Time Series',\n",
       "  'premium': False,\n",
       "  'limit': None,\n",
       "  'transform': None,\n",
       "  'column_index': None,\n",
       "  'start_date': '2017-01-01',\n",
       "  'end_date': '2017-12-31',\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",
       "  'collapse': None,\n",
       "  'order': None,\n",
       "  'database_id': 6129}}"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#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",
    "\n",
    "stockprices_2017 =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=' + API_KEY)\n",
    "stockprices_2017.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'2017-12-29': [51.76, 51.94, 51.45, 51.76, 34640.0],\n",
       " '2017-12-28': [51.65, 51.82, 51.43, 51.6, 40660.0],\n",
       " '2017-12-27': [51.45, 51.89, 50.76, 51.82, 57452.0],\n",
       " '2017-12-22': [51.05, 51.5, 50.92, 51.32, 71165.0],\n",
       " '2017-12-21': [51.16, 51.52, 50.9, 51.4, 120649.0],\n",
       " '2017-12-20': [51.88, 52.04, 51.2, 51.27, 50587.0],\n",
       " '2017-12-19': [52.73, 52.73, 51.07, 51.66, 137313.0],\n",
       " '2017-12-18': [52.37, 52.75, 51.61, 52.62, 129733.0],\n",
       " '2017-12-15': [52.7, 52.7, 51.64, 52.01, 204080.0],\n",
       " '2017-12-14': [53.11, 53.54, 52.15, 52.67, 132981.0],\n",
       " '2017-12-13': [52.64, 53.35, 52.48, 53.09, 128434.0],\n",
       " '2017-12-12': [52.29, 53.1, 51.82, 52.43, 87911.0],\n",
       " '2017-12-11': [52.28, 52.45, 51.26, 52.14, 71817.0],\n",
       " '2017-12-08': [51.5, 52.83, 51.28, 52.12, 109157.0],\n",
       " '2017-12-07': [50.89, 51.47, 50.81, 51.47, 48123.0],\n",
       " '2017-12-06': [50.8, 51.11, 50.39, 50.89, 88730.0],\n",
       " '2017-12-05': [51.21, 51.38, 50.4, 51.25, 83023.0],\n",
       " '2017-12-04': [49.5, 51.23, 49.5, 51.14, 94385.0],\n",
       " '2017-12-01': [49.52, 50.49, 49.17, 49.86, 101733.0],\n",
       " '2017-11-30': [48.64, 49.84, 48.28, 49.7, 123019.0],\n",
       " '2017-11-29': [49.64, 49.64, 48.7, 48.75, 67342.0],\n",
       " '2017-11-28': [49.09, 49.89, 49.03, 49.25, 42669.0],\n",
       " '2017-11-27': [49.13, 49.73, 48.96, 49.2, 102180.0],\n",
       " '2017-11-24': [49.11, 49.41, 48.87, 49.11, 50350.0],\n",
       " '2017-11-23': [48.8, 49.46, 48.45, 49.2, 38834.0],\n",
       " '2017-11-22': [48.4, 49.61, 48.39, 48.8, 91142.0],\n",
       " '2017-11-21': [47.25, 48.59, 46.78, 48.39, 78502.0],\n",
       " '2017-11-20': [46.57, 47.38, 46.54, 47.04, 97252.0],\n",
       " '2017-11-17': [47.03, 47.15, 46.8, 46.84, 54107.0],\n",
       " '2017-11-16': [47.09, 47.23, 46.55, 47.03, 89373.0],\n",
       " '2017-11-15': [47.98, 48.01, 46.75, 47.05, 67593.0],\n",
       " '2017-11-14': [48.4, 48.9, 47.84, 48.0, 67672.0],\n",
       " '2017-11-13': [48.38, 48.61, 47.76, 48.34, 76286.0],\n",
       " '2017-11-10': [47.3, 48.89, 47.16, 48.34, 90245.0],\n",
       " '2017-11-09': [47.65, 48.06, 47.09, 47.21, 120268.0],\n",
       " '2017-11-08': [46.42, 47.72, 46.42, 47.47, 94195.0],\n",
       " '2017-11-07': [46.16, 46.33, 45.84, 46.26, 48152.0],\n",
       " '2017-11-06': [45.81, 46.09, 45.76, 45.99, 60716.0],\n",
       " '2017-11-03': [45.0, 46.04, 44.83, 45.97, 56911.0],\n",
       " '2017-11-02': [45.88, 46.06, 45.18, 45.27, 37958.0],\n",
       " '2017-11-01': [46.29, 46.55, 45.97, 46.04, 56319.0],\n",
       " '2017-10-30': [46.53, 46.65, 45.61, 45.76, 56245.0],\n",
       " '2017-10-27': [45.48, 46.42, 45.46, 46.41, 74472.0],\n",
       " '2017-10-26': [45.2, 45.41, 44.91, 45.41, 56319.0],\n",
       " '2017-10-25': [45.01, 45.06, 44.7, 45.0, 47730.0],\n",
       " '2017-10-24': [45.16, 45.27, 44.75, 44.85, 43042.0],\n",
       " '2017-10-23': [44.9, 45.34, 44.89, 45.0, 43375.0],\n",
       " '2017-10-20': [45.08, 45.34, 44.76, 44.87, 55707.0],\n",
       " '2017-10-19': [45.72, 45.85, 44.79, 45.0, 59991.0],\n",
       " '2017-10-18': [46.01, 46.2, 45.61, 45.77, 45263.0],\n",
       " '2017-10-17': [45.8, 46.06, 45.37, 45.96, 65837.0],\n",
       " '2017-10-16': [45.61, 45.75, 45.3, 45.55, 49246.0],\n",
       " '2017-10-13': [45.5, 45.7, 45.37, 45.4, 43362.0],\n",
       " '2017-10-12': [45.58, 45.58, 45.17, 45.43, 49180.0],\n",
       " '2017-10-11': [45.97, 45.97, 45.25, 45.29, 69455.0],\n",
       " '2017-10-10': [45.64, 46.04, 45.57, 45.84, 65860.0],\n",
       " '2017-10-09': [46.2, 46.2, 45.6, 45.74, 44059.0],\n",
       " '2017-10-06': [46.19, 46.19, 45.69, 46.0, 66760.0],\n",
       " '2017-10-05': [46.01, 46.09, 45.63, 46.05, 94804.0],\n",
       " '2017-10-04': [45.36, 46.17, 45.22, 46.11, 115706.0],\n",
       " '2017-10-02': [44.51, 44.98, 44.18, 44.98, 95313.0],\n",
       " '2017-09-29': [43.58, 44.17, 43.3, 44.17, 99821.0],\n",
       " '2017-09-28': [42.0, 43.56, 42.0, 43.56, 157234.0],\n",
       " '2017-09-27': [42.35, 42.49, 41.78, 42.04, 76600.0],\n",
       " '2017-09-26': [42.3, 42.57, 42.11, 42.37, 51321.0],\n",
       " '2017-09-25': [42.3, 42.3, 41.96, 42.07, 56224.0],\n",
       " '2017-09-22': [41.48, 42.38, 41.48, 42.06, 79955.0],\n",
       " '2017-09-21': [42.29, 42.29, 41.39, 41.46, 105194.0],\n",
       " '2017-09-20': [42.54, 42.54, 41.99, 41.99, 57838.0],\n",
       " '2017-09-19': [42.65, 42.65, 42.13, 42.44, 65546.0],\n",
       " '2017-09-18': [42.5, 42.63, 42.23, 42.27, 44037.0],\n",
       " '2017-09-15': [42.29, 42.81, 42.25, 42.42, 107144.0],\n",
       " '2017-09-14': [42.35, 42.8, 42.35, 42.52, 65157.0],\n",
       " '2017-09-13': [42.49, 42.69, 42.22, 42.45, 68801.0],\n",
       " '2017-09-12': [43.21, 43.34, 42.62, 42.73, 52828.0],\n",
       " '2017-09-11': [42.81, 42.89, 42.56, 42.85, 103273.0],\n",
       " '2017-09-08': [42.7, 42.75, 42.56, 42.67, 59881.0],\n",
       " '2017-09-07': [43.0, 43.02, 42.67, 42.77, 64320.0],\n",
       " '2017-09-06': [42.66, 42.71, 42.34, 42.55, 71006.0],\n",
       " '2017-09-05': [43.0, 43.19, 42.55, 42.62, 66351.0],\n",
       " '2017-09-04': [42.38, 42.75, 41.95, 42.6, 105288.0],\n",
       " '2017-09-01': [42.16, 43.06, 42.07, 42.41, 151474.0],\n",
       " '2017-08-31': [42.0, 42.08, 41.12, 41.9, 157888.0],\n",
       " '2017-08-30': [42.0, 42.2, 41.49, 41.94, 97804.0],\n",
       " '2017-08-29': [41.71, 41.98, 41.33, 41.85, 98156.0],\n",
       " '2017-08-28': [42.11, 42.25, 41.86, 41.91, 47130.0],\n",
       " '2017-08-25': [42.64, 42.64, 42.05, 42.14, 69734.0],\n",
       " '2017-08-24': [42.72, 43.05, 42.63, 42.69, 65213.0],\n",
       " '2017-08-23': [42.82, 43.17, 42.6, 42.71, 70269.0],\n",
       " '2017-08-22': [42.46, 42.96, 42.4, 42.71, 95376.0],\n",
       " '2017-08-21': [42.42, 42.76, 42.2, 42.26, 68812.0],\n",
       " '2017-08-18': [42.28, 42.6, 42.01, 42.41, 72886.0],\n",
       " '2017-08-17': [41.88, 43.01, 41.76, 42.5, 131361.0],\n",
       " '2017-08-16': [42.4, 42.62, 41.98, 42.05, 104676.0],\n",
       " '2017-08-15': [42.53, 42.53, 42.2, 42.28, 64334.0],\n",
       " '2017-08-14': [42.12, 42.69, 42.01, 42.3, 127682.0],\n",
       " '2017-08-11': [41.3, 41.94, 40.96, 41.94, 183412.0],\n",
       " '2017-08-10': [41.73, 41.99, 41.14, 41.68, 175161.0],\n",
       " '2017-08-09': [43.5, 43.5, 41.64, 41.81, 355857.0],\n",
       " '2017-08-08': [44.9, 45.09, 44.15, 44.37, 156168.0],\n",
       " '2017-08-07': [45.85, 46.34, 44.02, 44.96, 164543.0],\n",
       " '2017-08-04': [45.13, 45.13, 44.36, 45.07, 96202.0],\n",
       " '2017-08-03': [45.34, 45.54, 44.91, 44.97, 77854.0],\n",
       " '2017-08-02': [45.25, 45.77, 44.9, 45.56, 187468.0],\n",
       " '2017-08-01': [45.24, 45.54, 45.1, 45.45, 74975.0],\n",
       " '2017-07-31': [44.94, 45.75, 44.94, 45.3, 62672.0],\n",
       " '2017-07-28': [45.26, 45.29, 44.75, 44.97, 114006.0],\n",
       " '2017-07-27': [45.16, 45.45, 45.15, 45.25, 50557.0],\n",
       " '2017-07-26': [44.91, 45.33, 44.46, 45.16, 81970.0],\n",
       " '2017-07-25': [44.7, 45.04, 44.63, 44.82, 112224.0],\n",
       " '2017-07-24': [45.31, 45.31, 44.49, 44.61, 104282.0],\n",
       " '2017-07-21': [45.57, 45.88, 45.04, 45.44, 73422.0],\n",
       " '2017-07-20': [45.74, 45.96, 45.23, 45.66, 87399.0],\n",
       " '2017-07-19': [45.06, 45.72, 44.94, 45.57, 71971.0],\n",
       " '2017-07-18': [45.5, 45.55, 44.7, 45.0, 104003.0],\n",
       " '2017-07-17': [45.6, 46.23, 45.29, 45.6, 104995.0],\n",
       " '2017-07-14': [45.07, 45.56, 44.83, 45.53, 67375.0],\n",
       " '2017-07-13': [44.67, 45.18, 44.67, 44.95, 82745.0],\n",
       " '2017-07-12': [44.29, 45.05, 43.89, 44.95, 115705.0],\n",
       " '2017-07-11': [44.94, 44.94, 44.08, 44.2, 90538.0],\n",
       " '2017-07-10': [44.64, 45.18, 44.51, 44.7, 71868.0],\n",
       " '2017-07-07': [44.79, 44.79, 44.25, 44.53, 47999.0],\n",
       " '2017-07-06': [45.5, 45.5, 44.15, 44.62, 66116.0],\n",
       " '2017-07-05': [44.67, 45.36, 44.44, 45.19, 48706.0],\n",
       " '2017-07-04': [45.83, 45.83, 44.74, 44.8, 50549.0],\n",
       " '2017-07-03': [45.29, 45.83, 45.06, 45.75, 71381.0],\n",
       " '2017-06-30': [45.01, 45.74, 45.0, 45.44, 136112.0],\n",
       " '2017-06-29': [45.73, 45.81, 45.11, 45.2, 134965.0],\n",
       " '2017-06-28': [46.68, 46.68, 45.41, 45.68, 117165.0],\n",
       " '2017-06-27': [47.23, 47.33, 46.39, 46.83, 82492.0],\n",
       " '2017-06-26': [46.95, 47.63, 46.91, 47.21, 73322.0],\n",
       " '2017-06-23': [47.29, 47.4, 46.79, 46.99, 80586.0],\n",
       " '2017-06-22': [47.03, 47.4, 46.75, 47.29, 56071.0],\n",
       " '2017-06-21': [47.46, 47.48, 46.53, 46.99, 89752.0],\n",
       " '2017-06-20': [46.48, 47.43, 46.27, 47.37, 108334.0],\n",
       " '2017-06-19': [46.9, 46.9, 46.25, 46.64, 70056.0],\n",
       " '2017-06-16': [45.66, 46.8, 45.66, 46.63, 202214.0],\n",
       " '2017-06-15': [46.34, 46.34, 45.21, 45.67, 101733.0],\n",
       " '2017-06-14': [46.52, 46.86, 46.05, 46.33, 83741.0],\n",
       " '2017-06-13': [46.5, 46.51, 46.03, 46.32, 107644.0],\n",
       " '2017-06-12': [47.31, 47.43, 45.89, 46.31, 112942.0],\n",
       " '2017-06-09': [46.77, 47.44, 46.55, 47.44, 99674.0],\n",
       " '2017-06-08': [47.8, 47.8, 46.27, 46.27, 1945.0],\n",
       " '2017-06-07': [47.01, 47.43, 47.01, 47.43, 1081.0],\n",
       " '2017-06-06': [47.12, 47.45, 46.21, 47.43, 686.0],\n",
       " '2017-06-02': [46.8, 46.99, 46.72, 46.99, 290.0],\n",
       " '2017-06-01': [46.12, 46.52, 45.89, 46.52, 106513.0],\n",
       " '2017-05-31': [45.22, 46.26, 45.22, 45.86, 522.0],\n",
       " '2017-05-30': [45.05, 46.02, 45.05, 46.02, 587.0],\n",
       " '2017-05-29': [45.61, 45.61, 45.24, 45.32, 112.0],\n",
       " '2017-05-26': [44.8, 45.36, 44.71, 45.3, 74453.0],\n",
       " '2017-05-25': [44.8, 44.87, 44.29, 44.78, 49970.0],\n",
       " '2017-05-24': [43.92, 44.67, 43.92, 44.53, 111923.0],\n",
       " '2017-05-23': [43.67, 44.13, 43.55, 43.9, 38308.0],\n",
       " '2017-05-22': [44.16, 44.22, 43.44, 43.84, 70856.0],\n",
       " '2017-05-19': [43.74, 44.12, 43.74, 44.12, 45.0],\n",
       " '2017-05-18': [44.0, 44.3, 43.29, 43.98, 166160.0],\n",
       " '2017-05-17': [45.06, 45.34, 44.01, 44.19, 149515.0],\n",
       " '2017-05-16': [45.15, 45.36, 44.56, 45.31, 101476.0],\n",
       " '2017-05-15': [45.09, 45.78, 44.31, 45.14, 193702.0],\n",
       " '2017-05-12': [45.18, 45.18, 44.16, 44.99, 159495.0],\n",
       " '2017-05-11': [43.4, 46.06, 43.25, 45.0, 189125.0],\n",
       " '2017-05-10': [43.5, 43.6, 42.53, 43.28, 91858.0],\n",
       " '2017-05-09': [41.83, 43.55, 41.82, 43.3, 151439.0],\n",
       " '2017-05-08': [43.0, 43.0, 42.04, 42.24, 97456.0],\n",
       " '2017-05-05': [42.52, 42.91, 42.38, 42.75, 78512.0],\n",
       " '2017-05-04': [41.86, 42.5, 41.71, 42.5, 82058.0],\n",
       " '2017-05-03': [42.2, 42.29, 41.78, 41.9, 65266.0],\n",
       " '2017-05-02': [41.89, 42.23, 41.76, 42.15, 86559.0],\n",
       " '2017-05-01': [None, 42.245, 41.655, 41.72, 86348.0],\n",
       " '2017-04-28': [42.17, 42.25, 41.66, 41.72, 86348.0],\n",
       " '2017-04-27': [41.51, 42.24, 41.51, 42.16, 151683.0],\n",
       " '2017-04-26': [41.88, 41.94, 41.4, 41.5, 65847.0],\n",
       " '2017-04-25': [41.93, 42.18, 41.66, 41.89, 85973.0],\n",
       " '2017-04-24': [42.01, 42.02, 41.23, 41.81, 102084.0],\n",
       " '2017-04-21': [41.97, 42.14, 41.01, 41.32, 186784.0],\n",
       " '2017-04-20': [42.5, 42.64, 41.52, 41.93, 223621.0],\n",
       " '2017-04-19': [41.94, 42.61, 41.94, 42.61, 92722.0],\n",
       " '2017-04-18': [42.24, 42.4, 41.54, 42.0, 133057.0],\n",
       " '2017-04-17': [None, 42.48, 41.985, 42.2, 88416.0],\n",
       " '2017-04-14': [None, 42.48, 41.985, 42.2, 88416.0],\n",
       " '2017-04-13': [42.06, 42.48, 41.99, 42.2, 88416.0],\n",
       " '2017-04-12': [42.02, 42.45, 41.84, 42.2, 158278.0],\n",
       " '2017-04-11': [41.62, 42.03, 41.53, 41.75, 107817.0],\n",
       " '2017-04-10': [41.46, 41.68, 41.31, 41.68, 62297.0],\n",
       " '2017-04-07': [40.9, 41.42, 40.84, 41.42, 81255.0],\n",
       " '2017-04-06': [40.96, 41.25, 40.83, 41.05, 96794.0],\n",
       " '2017-04-05': [41.1, 41.34, 40.79, 41.1, 156005.0],\n",
       " '2017-04-04': [39.5, 40.88, 39.48, 40.81, 193156.0],\n",
       " '2017-04-03': [40.15, 40.15, 39.54, 39.64, 127973.0],\n",
       " '2017-03-31': [39.77, 40.07, 39.42, 39.98, 95382.0],\n",
       " '2017-03-30': [40.02, 40.14, 39.42, 39.75, 189201.0],\n",
       " '2017-03-29': [39.39, 40.01, 39.05, 40.01, 335406.0],\n",
       " '2017-03-28': [38.95, 39.35, 38.79, 39.22, 115075.0],\n",
       " '2017-03-27': [38.73, 39.1, 38.53, 38.85, 191515.0],\n",
       " '2017-03-24': [38.94, 39.02, 38.6, 38.94, 210926.0],\n",
       " '2017-03-23': [39.01, 39.25, 38.63, 38.96, 169971.0],\n",
       " '2017-03-22': [38.25, 39.02, 37.53, 38.94, 670349.0],\n",
       " '2017-03-21': [41.8, 41.83, 40.97, 40.98, 56906.0],\n",
       " '2017-03-20': [41.26, 42.17, 41.26, 41.97, 97572.0],\n",
       " '2017-03-17': [41.47, 41.59, 41.16, 41.34, 90109.0],\n",
       " '2017-03-16': [41.4, 41.57, 41.09, 41.46, 55799.0],\n",
       " '2017-03-15': [41.4, 41.5, 40.91, 41.25, 60324.0],\n",
       " '2017-03-14': [41.2, 41.5, 41.2, 41.3, 60420.0],\n",
       " '2017-03-13': [41.4, 41.46, 41.08, 41.3, 44803.0],\n",
       " '2017-03-10': [41.53, 41.53, 41.16, 41.4, 38518.0],\n",
       " '2017-03-09': [41.61, 41.61, 41.16, 41.4, 43988.0],\n",
       " '2017-03-08': [41.13, 41.71, 40.95, 41.68, 45111.0],\n",
       " '2017-03-07': [41.5, 41.8, 41.25, 41.42, 61925.0],\n",
       " '2017-03-06': [41.25, 41.4, 40.81, 41.4, 46510.0],\n",
       " '2017-03-03': [41.12, 41.22, 40.84, 41.18, 40800.0],\n",
       " '2017-03-02': [41.38, 41.39, 40.76, 41.17, 49863.0],\n",
       " '2017-03-01': [41.19, 41.57, 40.9, 41.2, 86753.0],\n",
       " '2017-02-28': [40.38, 40.95, 40.38, 40.84, 67440.0],\n",
       " '2017-02-27': [39.75, 40.64, 39.75, 40.39, 62655.0],\n",
       " '2017-02-24': [39.77, 40.14, 38.91, 39.74, 101294.0],\n",
       " '2017-02-23': [39.72, 39.98, 39.38, 39.79, 81945.0],\n",
       " '2017-02-22': [39.6, 39.75, 39.27, 39.7, 77619.0],\n",
       " '2017-02-21': [38.85, 39.57, 38.85, 39.45, 46070.0],\n",
       " '2017-02-20': [39.25, 39.25, 38.81, 38.98, 37014.0],\n",
       " '2017-02-17': [38.8, 39.03, 38.48, 39.02, 60583.0],\n",
       " '2017-02-16': [38.8, 39.2, 38.25, 38.71, 84682.0],\n",
       " '2017-02-15': [38.5, 38.93, 38.4, 38.72, 77420.0],\n",
       " '2017-02-14': [38.81, 38.86, 38.0, 38.37, 82601.0],\n",
       " '2017-02-13': [37.37, 39.36, 37.35, 38.53, 177171.0],\n",
       " '2017-02-10': [36.65, 37.5, 36.57, 37.06, 115843.0],\n",
       " '2017-02-09': [36.2, 36.25, 35.77, 36.25, 67781.0],\n",
       " '2017-02-08': [35.98, 36.14, 35.84, 36.05, 39731.0],\n",
       " '2017-02-07': [35.56, 36.05, 35.36, 35.89, 67410.0],\n",
       " '2017-02-06': [36.06, 36.15, 35.6, 35.64, 41911.0],\n",
       " '2017-02-03': [36.02, 36.2, 35.73, 36.1, 40705.0],\n",
       " '2017-02-02': [35.95, 36.2, 35.7, 36.07, 54279.0],\n",
       " '2017-02-01': [34.75, 36.0, 34.75, 35.94, 85137.0],\n",
       " '2017-01-31': [35.24, 35.24, 34.56, 34.56, 63371.0],\n",
       " '2017-01-30': [35.38, 35.59, 34.95, 35.15, 69603.0],\n",
       " '2017-01-27': [34.83, 35.43, 34.81, 35.3, 69657.0],\n",
       " '2017-01-26': [35.07, 35.58, 34.8, 34.89, 64103.0],\n",
       " '2017-01-25': [34.42, 34.86, 34.03, 34.83, 56240.0],\n",
       " '2017-01-24': [34.0, 34.35, 33.85, 34.22, 48797.0],\n",
       " '2017-01-23': [34.04, 34.12, 33.62, 34.06, 55333.0],\n",
       " '2017-01-20': [34.54, 34.59, 34.05, 34.17, 80246.0],\n",
       " '2017-01-19': [35.04, 35.04, 34.42, 34.5, 73105.0],\n",
       " '2017-01-18': [35.04, 35.51, 34.8, 34.9, 65931.0],\n",
       " '2017-01-17': [35.06, 35.19, 34.79, 34.99, 39195.0],\n",
       " '2017-01-16': [34.85, 35.24, 34.56, 35.07, 47879.0],\n",
       " '2017-01-13': [34.98, 34.98, 34.6, 34.85, 59367.0],\n",
       " '2017-01-12': [35.38, 35.38, 34.31, 34.9, 163860.0],\n",
       " '2017-01-11': [34.95, 36.0, 34.84, 35.42, 123530.0],\n",
       " '2017-01-10': [34.8, 34.98, 34.46, 34.91, 43976.0],\n",
       " '2017-01-09': [35.29, 35.35, 34.43, 34.67, 62225.0],\n",
       " '2017-01-06': [34.91, 35.21, 34.91, 35.04, 27507.0],\n",
       " '2017-01-05': [35.02, 35.2, 34.73, 35.06, 48412.0],\n",
       " '2017-01-04': [35.48, 35.51, 34.75, 35.19, 54408.0],\n",
       " '2017-01-03': [35.9, 35.93, 35.34, 35.48, 70618.0],\n",
       " '2017-01-02': [34.99, 35.94, 34.99, 35.8, 44700.0]}"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#2.2.Convert the returned JSON object into a Python dictionary.\n",
    "# converted JSON into dictionary with open,high,low,close,trading volume as value list and date as keys of dictionary\n",
    "stock_json =stockprices_2017.json()['dataset']['data']\n",
    "stock_dict ={}\n",
    "for price in stock_json:\n",
    "    stock_dict[price[0]] = [price[1],price[2],price[3],price[4],price[6]]\n",
    "    \n",
    "stock_dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Highest Opening stock price  for the year 2017 was 53.11 occured on day 2017-12-14\n",
      "lowest Opening stock price  for the year 2017 was 34.00 occured on day 2017-01-24\n"
     ]
    }
   ],
   "source": [
    "#3.Calculate what the highest and lowest opening prices were for the stock in this period.\n",
    "#using list comprehensions\n",
    "prices_open ={}\n",
    "open_dict = {row[0]: row[1] for row in stock_json if row[1] != None}\n",
    "open_max_date, open_max = max(open_dict.items(), key=lambda k: k[1])\n",
    "open_min_date, open_min = min(open_dict.items(), key=lambda k: k[1])\n",
    "\n",
    "print('Highest Opening stock price  for the year 2017 was {0:.2f} occured on day {1}'.format(open_max,open_max_date))\n",
    "print('lowest Opening stock price  for the year 2017 was {0:.2f} occured on day {1}'.format(open_min,open_min_date))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The largest change for a day  in 2017 year  was 2.81 which occured on 2017-05-11.\n"
     ]
    }
   ],
   "source": [
    "#4.What was the largest change in any one day (based on High and Low price)?\n",
    "pricerange_dict ={}\n",
    "for date,prices in stock_dict.items():\n",
    "    pricerange_dict = {row[0]: row[2] - row[3] for row in stock_json}\n",
    "range_max_date, range_max = max(pricerange_dict.items(), key=lambda k: k[1])\n",
    "    \n",
    "print('The largest change for a day  in 2017 year  was {0:.2f} which occured on {1}.'.format(range_max,range_max_date))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The largest change between consecutive day closing prices in 2017 was 2.56 which  occurred on 2017-08-09.\n"
     ]
    }
   ],
   "source": [
    "#5.What was the largest change between any two days (based on Closing Price)?\n",
    "\n",
    "close_dict = {}\n",
    "stock  = stock_json[::-1]\n",
    "prev_close = stock[0][4]\n",
    "for row in stock[1:]:\n",
    "    close =row[4]\n",
    "    close_dict[row[0]] = abs(close - prev_close)\n",
    "    prev_close = close\n",
    "close_max_date, close_max = max(close_dict.items(), key=lambda k:k[1])\n",
    "print(\"The largest change between consecutive day closing prices in 2017 was {0:.2f}\" \\\n",
    "      \" which  occurred on {1}.\".format(round(close_max, 2), \\\n",
    "                                               close_max_date))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "The average daily trading colume is 89124.33725490196\n"
     ]
    }
   ],
   "source": [
    "#6.What was the average daily trading volume during this year?\n",
    "daily_volume = [row[6] for row in stock_json]\n",
    "avg_volume= sum(daily_volume)/len(daily_volume)\n",
    "print('The average daily trading colume is ' + str(avg_volume))"
   ]
  },
  {
   "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.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}