SurfsUp_Challenge.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Dependencies\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "# Python SQL toolkit and Object Relational Mapper\n",
    "%matplotlib notebook\n",
    "from matplotlib import style\n",
    "style.use('fivethirtyeight')\n",
    "import matplotlib.pyplot as plt\n",
    "import sqlalchemy\n",
    "from sqlalchemy.ext.automap import automap_base\n",
    "from sqlalchemy.orm import Session\n",
    "from sqlalchemy import create_engine, func\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "engine = create_engine(\"sqlite:///hawaii.sqlite\")\n",
    "\n",
    "# reflect an existing database into a new model\n",
    "Base = automap_base()\n",
    "# reflect the tables\n",
    "Base.prepare(engine, reflect=True)\n",
    "\n",
    "# Save references to each table\n",
    "Measurement = Base.classes.measurement\n",
    "Station = Base.classes.station"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create our session (link) from Python to the DB\n",
    "session = Session(engine)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## D1: Determine the Summary Statistics for June"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1. Import the sqlalchemy extract function.\n",
    "from sqlalchemy import extract\n",
    "\n",
    "# 2. Write a query that filters the Measurement table to retrieve the temperatures for the month of June. \n",
    "month_of_June = session.query(Measurement.date, Measurement.tobs).\\\n",
    "    filter(extract('month', Measurement.date)==6)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('2010-06-01', 78.0), ('2010-06-02', 76.0), ('2010-06-03', 78.0), ('2010-06-04', 76.0), ('2010-06-05', 77.0), ('2010-06-06', 78.0), ('2010-06-07', 77.0), ('2010-06-08', 78.0), ('2010-06-09', 78.0), ('2010-06-10', 79.0), ('2010-06-11', 78.0), ('2010-06-12', 78.0), ('2010-06-13', 78.0), ('2010-06-14', 77.0), ('2010-06-15', 78.0), ('2010-06-16', 78.0), ('2010-06-17', 77.0), ('2010-06-18', 77.0), ('2010-06-19', 82.0), ('2010-06-20', 78.0), ('2010-06-21', 78.0), ('2010-06-22', 78.0), ('2010-06-23', 78.0), ('2010-06-24', 78.0), ('2010-06-25', 77.0), ('2010-06-26', 76.0), ('2010-06-27', 78.0), ('2010-06-28', 78.0), ('2010-06-29', 78.0), ('2010-06-30', 78.0), ('2011-06-01', 77.0), ('2011-06-02', 78.0), ('2011-06-03', 73.0), ('2011-06-04', 70.0), ('2011-06-05', 76.0), ('2011-06-06', 77.0), ('2011-06-07', 77.0), ('2011-06-08', 77.0), ('2011-06-09', 77.0), ('2011-06-10', 78.0), ('2011-06-11', 77.0), ('2011-06-12', 77.0), ('2011-06-13', 78.0), ('2011-06-14', 78.0), ('2011-06-15', 77.0), ('2011-06-17', 78.0), ('2011-06-18', 78.0), ('2011-06-19', 75.0), ('2011-06-20', 76.0), ('2011-06-21', 76.0), ('2011-06-24', 77.0), ('2011-06-25', 78.0), ('2011-06-26', 76.0), ('2011-06-27', 77.0), ('2011-06-28', 75.0), ('2011-06-29', 77.0), ('2012-06-01', 76.0), ('2012-06-02', 76.0), ('2012-06-03', 75.0), ('2012-06-04', 77.0), ('2012-06-05', 77.0), ('2012-06-06', 76.0), ('2012-06-07', 78.0), ('2012-06-08', 77.0), ('2012-06-09', 76.0), ('2012-06-10', 77.0), ('2012-06-11', 76.0), ('2012-06-12', 76.0), ('2012-06-13', 77.0), ('2012-06-14', 77.0), ('2012-06-15', 78.0), ('2012-06-16', 77.0), ('2012-06-17', 77.0), ('2012-06-18', 77.0), ('2012-06-19', 76.0), ('2012-06-20', 75.0), ('2012-06-21', 76.0), ('2012-06-22', 76.0), ('2012-06-23', 77.0), ('2012-06-24', 76.0), ('2012-06-25', 73.0), ('2012-06-26', 73.0), ('2012-06-27', 75.0), ('2012-06-28', 77.0), ('2012-06-29', 76.0), ('2012-06-30', 77.0), ('2013-06-01', 79.0), ('2013-06-02', 78.0), ('2013-06-03', 79.0), ('2013-06-04', 78.0), ('2013-06-05', 78.0), ('2013-06-06', 79.0), ('2013-06-07', 77.0), ('2013-06-08', 77.0), ('2013-06-09', 77.0), ('2013-06-10', 77.0), ('2013-06-11', 77.0), ('2013-06-12', 78.0), ('2013-06-13', 77.0), ('2013-06-14', 76.0), ('2013-06-15', 78.0), ('2013-06-16', 78.0), ('2013-06-17', 77.0), ('2013-06-18', 78.0), ('2013-06-19', 78.0), ('2013-06-20', 73.0), ('2013-06-21', 76.0), ('2013-06-22', 77.0), ('2013-06-23', 75.0), ('2013-06-24', 76.0), ('2013-06-25', 74.0), ('2013-06-26', 75.0), ('2013-06-27', 77.0), ('2013-06-28', 76.0), ('2013-06-29', 77.0), ('2013-06-30', 78.0), ('2014-06-01', 79.0), ('2014-06-02', 77.0), ('2014-06-03', 78.0), ('2014-06-04', 79.0), ('2014-06-05', 78.0), ('2014-06-06', 78.0), ('2014-06-07', 78.0), ('2014-06-08', 78.0), ('2014-06-09', 79.0), ('2014-06-10', 79.0), ('2014-06-11', 82.0), ('2014-06-12', 80.0), ('2014-06-13', 79.0), ('2014-06-14', 79.0), ('2014-06-15', 78.0), ('2014-06-16', 78.0), ('2014-06-17', 77.0), ('2014-06-18', 78.0), ('2014-06-19', 78.0), ('2014-06-20', 73.0), ('2014-06-21', 75.0), ('2014-06-22', 75.0), ('2014-06-23', 76.0), ('2014-06-24', 84.0), ('2014-06-25', 79.0), ('2014-06-26', 76.0), ('2014-06-27', 79.0), ('2014-06-28', 79.0), ('2014-06-29', 77.0), ('2014-06-30', 79.0), ('2015-06-01', 78.0), ('2015-06-02', 78.0), ('2015-06-03', 79.0), ('2015-06-04', 77.0), ('2015-06-05', 79.0), ('2015-06-06', 78.0), ('2015-06-07', 78.0), ('2015-06-08', 78.0), ('2015-06-09', 79.0), ('2015-06-10', 77.0), ('2015-06-11', 78.0), ('2015-06-12', 78.0), ('2015-06-13', 78.0), ('2015-06-14', 78.0), ('2015-06-15', 79.0), ('2015-06-16', 79.0), ('2015-06-17', 77.0), ('2015-06-18', 78.0), ('2015-06-19', 78.0), ('2015-06-20', 78.0), ('2015-06-21', 79.0), ('2015-06-22', 79.0), ('2015-06-23', 77.0), ('2015-06-24', 79.0), ('2015-06-25', 79.0), ('2015-06-26', 79.0), ('2015-06-27', 81.0), ('2015-06-28', 76.0), ('2015-06-29', 80.0), ('2015-06-30', 78.0), ('2016-06-01', 76.0), ('2016-06-02', 71.0), ('2016-06-03', 71.0), ('2016-06-04', 74.0), ('2016-06-05', 76.0), ('2016-06-06', 78.0), ('2016-06-07', 77.0), ('2016-06-08', 77.0), ('2016-06-09', 73.0), ('2016-06-10', 77.0), ('2016-06-11', 78.0), ('2016-06-12', 78.0), ('2016-06-13', 80.0), ('2016-06-14', 79.0), ('2016-06-15', 78.0), ('2016-06-16', 77.0), ('2016-06-17', 76.0), ('2016-06-18', 77.0), ('2016-06-19', 77.0), ('2016-06-20', 78.0), ('2016-06-21', 80.0), ('2016-06-22', 79.0), ('2016-06-23', 79.0), ('2016-06-24', 77.0), ('2016-06-25', 78.0), ('2016-06-26', 79.0), ('2016-06-27', 80.0), ('2016-06-28', 76.0), ('2016-06-29', 79.0), ('2016-06-30', 80.0), ('2017-06-01', 79.0), ('2017-06-02', 79.0), ('2017-06-03', 79.0), ('2017-06-04', 79.0), ('2017-06-05', 80.0), ('2017-06-06', 79.0), ('2017-06-07', 79.0), ('2017-06-08', 80.0), ('2017-06-09', 80.0), ('2017-06-10', 77.0), ('2017-06-11', 79.0), ('2017-06-12', 83.0), ('2017-06-13', 80.0), ('2017-06-14', 80.0), ('2017-06-15', 78.0), ('2017-06-16', 79.0), ('2017-06-17', 80.0), ('2017-06-18', 77.0), ('2017-06-19', 80.0), ('2017-06-20', 78.0), ('2017-06-21', 79.0), ('2017-06-22', 80.0), ('2017-06-23', 78.0), ('2017-06-24', 80.0), ('2017-06-25', 80.0), ('2017-06-26', 81.0), ('2017-06-27', 80.0), ('2017-06-28', 79.0), ('2017-06-29', 79.0), ('2017-06-30', 75.0), ('2010-06-01', 74.0), ('2010-06-02', 76.0), ('2010-06-03', 75.0), ('2010-06-04', 75.0), ('2010-06-05', 74.0), ('2010-06-06', 75.0), ('2010-06-07', 75.0), ('2010-06-08', 75.0), ('2010-06-09', 75.0), ('2010-06-10', 75.0), ('2010-06-11', 83.0), ('2010-06-12', 75.0), ('2010-06-13', 76.0), ('2010-06-14', 73.0), ('2010-06-15', 74.0), ('2010-06-16', 74.0), ('2010-06-17', 75.0), ('2010-06-18', 70.0), ('2010-06-19', 74.0), ('2010-06-20', 75.0), ('2010-06-21', 75.0), ('2010-06-22', 75.0), ('2010-06-23', 75.0), ('2010-06-24', 75.0), ('2010-06-25', 74.0), ('2010-06-26', 72.0), ('2010-06-27', 76.0), ('2010-06-28', 73.0), ('2010-06-29', 75.0), ('2010-06-30', 76.0), ('2011-06-01', 74.0), ('2011-06-02', 75.0), ('2011-06-03', 71.0), ('2011-06-04', 69.0), ('2011-06-05', 69.0), ('2011-06-06', 74.0), ('2011-06-07', 71.0), ('2011-06-08', 74.0), ('2011-06-09', 74.0), ('2011-06-10', 75.0), ('2011-06-11', 73.0), ('2011-06-12', 73.0), ('2011-06-13', 73.0), ('2011-06-14', 75.0), ('2011-06-15', 75.0), ('2011-06-16', 74.0), ('2011-06-17', 74.0), ('2011-06-18', 75.0), ('2011-06-19', 74.0), ('2011-06-20', 73.0), ('2011-06-21', 72.0), ('2011-06-22', 74.0), ('2011-06-23', 72.0), ('2011-06-24', 75.0), ('2011-06-25', 76.0), ('2011-06-26', 74.0), ('2011-06-27', 74.0), ('2011-06-28', 74.0), ('2011-06-29', 74.0), ('2011-06-30', 74.0), ('2012-06-01', 71.0), ('2012-06-02', 71.0), ('2012-06-03', 75.0), ('2012-06-04', 72.0), ('2012-06-05', 72.0), ('2012-06-06', 73.0), ('2012-06-07', 73.0), ('2012-06-08', 73.0), ('2012-06-09', 74.0), ('2012-06-10', 73.0), ('2012-06-11', 72.0), ('2012-06-12', 72.0), ('2012-06-13', 70.0), ('2012-06-14', 72.0), ('2012-06-15', 72.0), ('2012-06-16', 72.0), ('2012-06-17', 74.0), ('2012-06-18', 73.0), ('2012-06-19', 73.0), ('2012-06-20', 70.0), ('2012-06-21', 73.0), ('2012-06-22', 72.0), ('2012-06-23', 73.0), ('2012-06-24', 69.0), ('2012-06-25', 72.0), ('2012-06-26', 71.0), ('2012-06-27', 71.0), ('2012-06-28', 73.0), ('2012-06-29', 73.0), ('2012-06-30', 72.0), ('2013-06-01', 75.0), ('2013-06-02', 75.0), ('2013-06-03', 75.0), ('2013-06-04', 75.0), ('2013-06-05', 74.0), ('2013-06-06', 74.0), ('2013-06-07', 74.0), ('2013-06-08', 75.0), ('2013-06-09', 75.0), ('2013-06-10', 74.0), ('2013-06-11', 75.0), ('2013-06-12', 75.0), ('2013-06-13', 74.0), ('2013-06-14', 72.0), ('2013-06-15', 74.0), ('2013-06-16', 74.0), ('2013-06-17', 74.0), ('2013-06-18', 74.0), ('2013-06-19', 74.0), ('2013-06-20', 72.0), ('2013-06-21', 70.0), ('2013-06-22', 75.0), ('2013-06-23', 74.0), ('2013-06-24', 71.0), ('2013-06-25', 71.0), ('2013-06-26', 70.0), ('2013-06-27', 73.0), ('2013-06-28', 71.0), ('2013-06-29', 71.0), ('2013-06-30', 77.0), ('2014-06-01', 77.0), ('2014-06-02', 74.0), ('2014-06-03', 73.0), ('2014-06-04', 75.0), ('2014-06-05', 75.0), ('2014-06-06', 74.0), ('2014-06-07', 74.0), ('2014-06-08', 75.0), ('2014-06-09', 75.0), ('2014-06-10', 72.0), ('2014-06-11', 74.0), ('2014-06-12', 76.0), ('2014-06-13', 76.0), ('2014-06-14', 75.0), ('2014-06-15', 75.0), ('2014-06-16', 74.0), ('2014-06-17', 72.0), ('2014-06-18', 74.0), ('2014-06-19', 75.0), ('2014-06-20', 70.0), ('2014-06-21', 71.0), ('2014-06-22', 72.0), ('2014-06-23', 71.0), ('2014-06-24', 73.0), ('2014-06-25', 74.0), ('2014-06-26', 72.0), ('2014-06-27', 74.0), ('2014-06-28', 76.0), ('2014-06-29', 72.0), ('2014-06-30', 75.0), ('2015-06-03', 75.0), ('2015-06-04', 72.0), ('2015-06-05', 70.0), ('2015-06-06', 76.0), ('2015-06-07', 78.0), ('2015-06-08', 72.0), ('2015-06-09', 74.0), ('2015-06-10', 74.0), ('2015-06-11', 72.0), ('2015-06-12', 71.0), ('2015-06-13', 79.0), ('2015-06-14', 79.0), ('2015-06-15', 76.0), ('2015-06-16', 75.0), ('2015-06-17', 72.0), ('2015-06-18', 74.0), ('2015-06-19', 76.0), ('2015-06-20', 76.0), ('2015-06-21', 77.0), ('2015-06-22', 75.0), ('2015-06-23', 76.0), ('2015-06-24', 75.0), ('2015-06-25', 75.0), ('2015-06-26', 76.0), ('2015-06-27', 76.0), ('2015-06-29', 74.0), ('2016-06-01', 70.0), ('2016-06-02', 69.0), ('2016-06-03', 70.0), ('2016-06-04', 68.0), ('2016-06-05', 70.0), ('2016-06-06', 74.0), ('2016-06-07', 75.0), ('2016-06-08', 74.0), ('2016-06-09', 71.0), ('2016-06-10', 73.0), ('2016-06-11', 75.0), ('2016-06-12', 74.0), ('2016-06-13', 76.0), ('2016-06-14', 76.0), ('2016-06-15', 76.0), ('2016-06-16', 76.0), ('2016-06-17', 75.0), ('2016-06-18', 75.0), ('2016-06-19', 75.0), ('2016-06-20', 74.0), ('2016-06-21', 73.0), ('2016-06-22', 76.0), ('2016-06-23', 74.0), ('2016-06-24', 78.0), ('2016-06-25', 71.0), ('2016-06-26', 75.0), ('2016-06-27', 75.0), ('2016-06-28', 74.0), ('2016-06-29', 77.0), ('2016-06-30', 77.0), ('2017-06-01', 76.0), ('2017-06-02', 76.0), ('2017-06-03', 76.0), ('2017-06-04', 78.0), ('2017-06-05', 76.0), ('2017-06-06', 75.0), ('2017-06-07', 75.0), ('2017-06-08', 76.0), ('2017-06-09', 78.0), ('2017-06-10', 75.0), ('2017-06-11', 73.0), ('2017-06-12', 76.0), ('2017-06-13', 76.0), ('2017-06-14', 76.0), ('2017-06-15', 77.0), ('2017-06-16', 76.0), ('2017-06-17', 77.0), ('2017-06-18', 72.0), ('2017-06-19', 77.0), ('2017-06-20', 75.0), ('2017-06-21', 82.0), ('2017-06-22', 77.0), ('2017-06-23', 76.0), ('2017-06-24', 74.0), ('2017-06-25', 73.0), ('2017-06-26', 77.0), ('2017-06-27', 77.0), ('2017-06-28', 77.0), ('2017-06-29', 76.0), ('2017-06-30', 74.0), ('2010-06-01', 73.0), ('2010-06-02', 72.0), ('2010-06-03', 74.0), ('2010-06-04', 73.0), ('2010-06-05', 72.0), ('2010-06-06', 75.0), ('2010-06-07', 74.0), ('2010-06-08', 75.0), ('2010-06-09', 73.0), ('2010-06-10', 75.0), ('2010-06-11', 76.0), ('2010-06-12', 74.0), ('2010-06-13', 74.0), ('2010-06-14', 73.0), ('2010-06-15', 73.0), ('2010-06-16', 76.0), ('2010-06-17', 75.0), ('2010-06-18', 70.0), ('2010-06-19', 75.0), ('2010-06-20', 73.0), ('2010-06-21', 74.0), ('2010-06-22', 74.0), ('2010-06-23', 74.0), ('2010-06-24', 74.0), ('2010-06-25', 70.0), ('2010-06-27', 75.0), ('2010-06-28', 74.0), ('2010-06-29', 73.0), ('2010-06-30', 74.0), ('2011-06-01', 72.0), ('2011-06-02', 73.0), ('2011-06-03', 67.0), ('2011-06-04', 69.0), ('2011-06-05', 76.0), ('2011-06-06', 73.0), ('2011-06-07', 70.0), ('2011-06-08', 72.0), ('2011-06-09', 74.0), ('2011-06-10', 72.0), ('2011-06-13', 72.0), ('2011-06-14', 75.0), ('2011-06-15', 73.0), ('2011-06-16', 73.0), ('2011-06-17', 72.0), ('2011-06-18', 74.0), ('2011-06-19', 76.0), ('2011-06-21', 72.0), ('2011-06-22', 74.0), ('2011-06-23', 70.0), ('2011-06-24', 74.0), ('2011-06-25', 74.0), ('2011-06-27', 74.0), ('2011-06-28', 71.0), ('2012-06-21', 75.0), ('2012-06-22', 75.0), ('2012-06-24', 76.0), ('2012-06-25', 77.0), ('2012-06-26', 75.0), ('2012-06-27', 74.0), ('2012-06-28', 75.0), ('2012-06-29', 76.0), ('2012-06-30', 78.0), ('2013-06-03', 78.0), ('2013-06-04', 76.0), ('2013-06-05', 78.0), ('2013-06-06', 76.0), ('2013-06-07', 76.0), ('2013-06-08', 78.0), ('2013-06-09', 79.0), ('2013-06-10', 77.0), ('2013-06-11', 76.0), ('2013-06-12', 77.0), ('2013-06-13', 77.0), ('2013-06-14', 76.0), ('2013-06-16', 78.0), ('2013-06-17', 76.0), ('2013-06-18', 76.0), ('2013-06-19', 77.0), ('2013-06-20', 71.0), ('2013-06-25', 74.0), ('2013-06-26', 72.0), ('2013-06-27', 77.0), ('2014-06-01', 77.0), ('2014-06-02', 78.0), ('2014-06-03', 77.0), ('2014-06-04', 77.0), ('2014-06-05', 76.0), ('2014-06-06', 75.0), ('2014-06-07', 79.0), ('2014-06-09', 75.0), ('2014-06-10', 73.0), ('2014-06-11', 76.0), ('2014-06-12', 78.0), ('2014-06-13', 77.0), ('2014-06-14', 78.0), ('2014-06-16', 76.0), ('2014-06-17', 75.0), ('2014-06-18', 76.0), ('2014-06-19', 77.0), ('2014-06-20', 74.0), ('2014-06-21', 78.0), ('2014-06-23', 77.0), ('2014-06-24', 77.0), ('2014-06-25', 74.0), ('2014-06-26', 74.0), ('2014-06-27', 78.0), ('2014-06-29', 79.0), ('2014-06-30', 79.0), ('2015-06-01', 78.0), ('2015-06-03', 75.0), ('2015-06-04', 76.0), ('2015-06-05', 78.0), ('2015-06-06', 78.0), ('2015-06-08', 74.0), ('2015-06-09', 78.0), ('2015-06-10', 77.0), ('2015-06-11', 76.0), ('2015-06-12', 78.0), ('2015-06-14', 78.0), ('2015-06-15', 78.0), ('2015-06-16', 78.0), ('2015-06-17', 74.0), ('2015-06-18', 79.0), ('2015-06-19', 77.0), ('2015-06-20', 73.0), ('2015-06-21', 79.0), ('2015-06-22', 79.0), ('2015-06-23', 78.0), ('2015-06-24', 77.0), ('2015-06-25', 78.0), ('2015-06-26', 78.0), ('2015-06-27', 80.0), ('2015-06-28', 80.0), ('2015-06-29', 79.0), ('2015-06-30', 74.0), ('2016-06-01', 71.0), ('2016-06-02', 74.0), ('2016-06-03', 75.0), ('2016-06-07', 75.0), ('2016-06-08', 74.0), ('2016-06-09', 76.0), ('2016-06-10', 75.0), ('2016-06-11', 77.0), ('2016-06-12', 77.0), ('2016-06-13', 79.0), ('2016-06-14', 79.0), ('2016-06-15', 78.0), ('2016-06-16', 79.0), ('2016-06-17', 73.0), ('2016-06-18', 78.0), ('2016-06-19', 79.0), ('2016-06-20', 80.0), ('2016-06-21', 76.0), ('2016-06-22', 79.0), ('2016-06-23', 79.0), ('2016-06-24', 77.0), ('2016-06-25', 80.0), ('2016-06-26', 79.0), ('2016-06-27', 78.0), ('2016-06-28', 78.0), ('2016-06-29', 79.0), ('2016-06-30', 78.0), ('2017-06-01', 81.0), ('2017-06-02', 78.0), ('2017-06-03', 80.0), ('2017-06-04', 79.0), ('2017-06-05', 81.0), ('2017-06-06', 80.0), ('2017-06-07', 81.0), ('2017-06-08', 79.0), ('2017-06-09', 81.0), ('2017-06-10', 78.0), ('2017-06-11', 79.0), ('2017-06-12', 79.0), ('2017-06-13', 75.0), ('2017-06-14', 79.0), ('2017-06-15', 78.0), ('2017-06-16', 80.0), ('2017-06-17', 78.0), ('2017-06-18', 77.0), ('2017-06-19', 78.0), ('2017-06-20', 79.0), ('2017-06-23', 76.0), ('2017-06-26', 80.0), ('2017-06-29', 76.0), ('2017-06-30', 81.0), ('2010-06-01', 77.0), ('2010-06-02', 76.0), ('2010-06-03', 77.0), ('2010-06-04', 75.0), ('2010-06-07', 76.0), ('2010-06-08', 79.0), ('2010-06-09', 79.0), ('2010-06-10', 77.0), ('2010-06-15', 76.0), ('2010-06-16', 77.0), ('2010-06-17', 76.0), ('2010-06-18', 73.0), ('2010-06-21', 76.0), ('2010-06-22', 77.0), ('2010-06-23', 77.0), ('2010-06-24', 78.0), ('2010-06-25', 77.0), ('2010-06-28', 76.0), ('2010-06-29', 78.0), ('2010-06-30', 78.0), ('2011-06-01', 75.0), ('2011-06-02', 77.0), ('2011-06-03', 65.0), ('2011-06-06', 76.0), ('2011-06-07', 74.0), ('2011-06-08', 76.0), ('2011-06-09', 76.0), ('2011-06-13', 77.0), ('2011-06-14', 77.0), ('2011-06-15', 76.0), ('2011-06-16', 77.0), ('2011-06-17', 76.0), ('2011-06-20', 77.0), ('2011-06-21', 74.0), ('2011-06-22', 76.0), ('2011-06-23', 73.0), ('2011-06-24', 75.0), ('2011-06-27', 76.0), ('2011-06-28', 75.0), ('2011-06-29', 76.0), ('2011-06-30', 75.0), ('2012-06-01', 74.0), ('2012-06-04', 74.0), ('2012-06-05', 74.0), ('2012-06-06', 74.0), ('2012-06-07', 76.0), ('2012-06-08', 76.0), ('2012-06-12', 77.0), ('2012-06-13', 77.0), ('2012-06-14', 78.0), ('2012-06-15', 73.0), ('2012-06-18', 75.0), ('2012-06-19', 72.0), ('2012-06-20', 76.0), ('2012-06-21', 76.0), ('2012-06-22', 73.0), ('2012-06-25', 74.0), ('2012-06-26', 72.0), ('2012-06-27', 76.0), ('2012-06-28', 76.0), ('2012-06-29', 76.0), ('2013-06-03', 78.0), ('2013-06-04', 78.0), ('2013-06-05', 78.0), ('2013-06-06', 78.0), ('2013-06-07', 75.0), ('2013-06-10', 77.0), ('2013-06-12', 73.0), ('2013-06-13', 78.0), ('2013-06-14', 75.0), ('2013-06-17', 73.0), ('2013-06-18', 77.0), ('2013-06-19', 80.0), ('2013-06-20', 70.0), ('2013-06-21', 78.0), ('2013-06-25', 72.0), ('2013-06-26', 78.0), ('2013-06-27', 72.0), ('2013-06-28', 78.0), ('2014-06-02', 77.0), ('2014-06-03', 79.0), ('2014-06-04', 77.0), ('2014-06-05', 78.0), ('2014-06-06', 74.0), ('2014-06-09', 79.0), ('2014-06-10', 79.0), ('2014-06-12', 79.0), ('2014-06-13', 79.0), ('2014-06-16', 77.0), ('2014-06-17', 79.0), ('2014-06-18', 78.0), ('2014-06-19', 80.0), ('2014-06-20', 81.0), ('2014-06-27', 81.0), ('2015-06-10', 78.0), ('2015-06-12', 77.0), ('2015-06-15', 78.0), ('2015-06-16', 79.0), ('2015-06-17', 77.0), ('2015-06-18', 79.0), ('2015-06-19', 80.0), ('2015-06-22', 79.0), ('2015-06-23', 78.0), ('2015-06-24', 79.0), ('2015-06-25', 79.0), ('2015-06-29', 79.0), ('2015-06-30', 81.0), ('2016-06-01', 64.0), ('2016-06-02', 65.0), ('2016-06-03', 75.0), ('2016-06-06', 76.0), ('2016-06-07', 78.0), ('2016-06-08', 77.0), ('2016-06-09', 75.0), ('2016-06-13', 78.0), ('2016-06-14', 81.0), ('2016-06-15', 78.0), ('2016-06-16', 76.0), ('2016-06-17', 73.0), ('2016-06-20', 74.0), ('2016-06-21', 76.0), ('2016-06-22', 78.0), ('2016-06-23', 79.0), ('2016-06-24', 78.0), ('2016-06-27', 72.0), ('2016-06-28', 78.0), ('2016-06-29', 80.0), ('2016-06-30', 81.0), ('2017-06-02', 79.0), ('2017-06-05', 78.0), ('2017-06-06', 80.0), ('2017-06-07', 80.0), ('2017-06-08', 78.0), ('2017-06-09', 80.0), ('2017-06-13', 81.0), ('2017-06-14', 78.0), ('2017-06-15', 77.0), ('2017-06-16', 78.0), ('2017-06-19', 78.0), ('2017-06-20', 77.0), ('2017-06-21', 76.0), ('2017-06-22', 81.0), ('2017-06-23', 76.0), ('2017-06-26', 82.0), ('2017-06-27', 80.0), ('2017-06-28', 80.0), ('2017-06-29', 79.0), ('2017-06-30', 74.0), ('2010-06-01', 69.0), ('2010-06-02', 70.0), ('2010-06-03', 67.0), ('2010-06-04', 70.0), ('2010-06-05', 73.0), ('2010-06-06', 73.0), ('2010-06-09', 72.0), ('2010-06-10', 72.0), ('2010-06-11', 77.0), ('2010-06-12', 70.0), ('2010-06-13', 78.0), ('2010-06-15', 73.0), ('2010-06-17', 75.0), ('2010-06-18', 70.0), ('2010-06-19', 74.0), ('2010-06-20', 77.0), ('2010-06-22', 69.0), ('2010-06-23', 73.0), ('2010-06-24', 73.0), ('2010-06-25', 74.0), ('2010-06-28', 73.0), ('2010-06-29', 72.0), ('2010-06-30', 75.0), ('2011-06-08', 73.0), ('2011-06-09', 76.0), ('2011-06-12', 74.0), ('2011-06-13', 76.0), ('2011-06-14', 73.0), ('2011-06-15', 76.0), ('2011-06-16', 76.0), ('2011-06-20', 78.0), ('2011-06-21', 75.0), ('2011-06-22', 77.0), ('2012-06-01', 75.0), ('2012-06-14', 73.0), ('2012-06-21', 76.0), ('2012-06-26', 71.0), ('2012-06-29', 71.0), ('2010-06-01', 76.0), ('2010-06-02', 76.0), ('2010-06-03', 76.0), ('2010-06-04', 73.0), ('2010-06-05', 78.0), ('2010-06-06', 77.0), ('2010-06-07', 77.0), ('2010-06-08', 77.0), ('2010-06-09', 78.0), ('2010-06-10', 78.0), ('2010-06-11', 76.0), ('2010-06-12', 76.0), ('2010-06-13', 79.0), ('2010-06-14', 74.0), ('2010-06-15', 75.0), ('2010-06-16', 76.0), ('2010-06-17', 75.0), ('2010-06-18', 73.0), ('2010-06-19', 76.0), ('2010-06-20', 78.0), ('2010-06-21', 76.0), ('2010-06-22', 79.0), ('2010-06-23', 77.0), ('2010-06-24', 76.0), ('2010-06-25', 74.0), ('2010-06-26', 75.0), ('2010-06-28', 76.0), ('2010-06-29', 76.0), ('2010-06-30', 76.0), ('2011-06-01', 79.0), ('2011-06-02', 76.0), ('2011-06-03', 72.0), ('2011-06-04', 71.0), ('2011-06-05', 72.0), ('2011-06-06', 76.0), ('2011-06-07', 74.0), ('2011-06-08', 75.0), ('2011-06-09', 76.0), ('2011-06-10', 77.0), ('2011-06-11', 76.0), ('2011-06-12', 75.0), ('2011-06-13', 76.0), ('2011-06-14', 76.0), ('2011-06-15', 76.0), ('2011-06-16', 75.0), ('2011-06-17', 76.0), ('2011-06-18', 76.0), ('2011-06-19', 79.0), ('2011-06-20', 74.0), ('2011-06-21', 73.0), ('2011-06-22', 75.0), ('2011-06-23', 74.0), ('2011-06-24', 75.0), ('2011-06-25', 76.0), ('2011-06-26', 72.0), ('2011-06-27', 74.0), ('2011-06-28', 74.0), ('2011-06-29', 75.0), ('2011-06-30', 75.0), ('2012-06-01', 74.0), ('2012-06-02', 75.0), ('2012-06-03', 77.0), ('2012-06-04', 75.0), ('2012-06-05', 74.0), ('2012-06-06', 75.0), ('2012-06-07', 74.0), ('2012-06-08', 75.0), ('2012-06-09', 73.0), ('2012-06-10', 75.0), ('2012-06-11', 76.0), ('2012-06-12', 76.0), ('2012-06-13', 76.0), ('2012-06-14', 79.0), ('2012-06-15', 74.0), ('2012-06-16', 78.0), ('2012-06-17', 80.0), ('2012-06-18', 75.0), ('2012-06-19', 72.0), ('2012-06-20', 72.0), ('2012-06-21', 74.0), ('2012-06-22', 78.0), ('2012-06-23', 76.0), ('2012-06-24', 77.0), ('2012-06-25', 72.0), ('2012-06-26', 72.0), ('2012-06-27', 73.0), ('2012-06-28', 75.0), ('2012-06-29', 79.0), ('2012-06-30', 81.0), ('2013-06-01', 76.0), ('2013-06-02', 76.0), ('2013-06-03', 77.0), ('2013-06-04', 78.0), ('2013-06-05', 79.0), ('2013-06-06', 79.0), ('2013-06-07', 75.0), ('2013-06-08', 79.0), ('2013-06-09', 79.0), ('2013-06-10', 75.0), ('2013-06-11', 77.0), ('2013-06-12', 81.0), ('2013-06-13', 76.0), ('2013-06-14', 75.0), ('2013-06-15', 78.0), ('2013-06-16', 81.0), ('2013-06-17', 76.0), ('2013-06-18', 76.0), ('2013-06-19', 76.0), ('2013-06-20', 72.0), ('2013-06-21', 73.0), ('2013-06-22', 74.0), ('2013-06-23', 74.0), ('2013-06-24', 75.0), ('2013-06-25', 73.0), ('2013-06-26', 73.0), ('2013-06-27', 76.0), ('2013-06-29', 73.0), ('2013-06-30', 79.0), ('2014-06-01', 78.0), ('2014-06-02', 76.0), ('2014-06-04', 76.0), ('2014-06-05', 76.0), ('2014-06-06', 77.0), ('2014-06-07', 79.0), ('2014-06-08', 80.0), ('2014-06-09', 78.0), ('2014-06-10', 76.0), ('2014-06-11', 78.0), ('2014-06-12', 78.0), ('2014-06-13', 77.0), ('2014-06-14', 79.0), ('2014-06-15', 79.0), ('2014-06-16', 75.0), ('2014-06-18', 76.0), ('2014-06-19', 77.0), ('2014-06-20', 74.0), ('2014-06-21', 77.0), ('2014-06-22', 76.0), ('2014-06-23', 76.0), ('2014-06-24', 75.0), ('2014-06-25', 74.0), ('2014-06-26', 79.0), ('2014-06-28', 76.0), ('2014-06-29', 74.0), ('2014-06-30', 76.0), ('2015-06-01', 77.0), ('2015-06-02', 78.0), ('2015-06-03', 77.0), ('2015-06-04', 75.0), ('2015-06-05', 75.0), ('2015-06-06', 80.0), ('2015-06-07', 77.0), ('2015-06-08', 77.0), ('2015-06-09', 77.0), ('2015-06-10', 80.0), ('2015-06-11', 76.0), ('2015-06-12', 78.0), ('2015-06-13', 77.0), ('2015-06-14', 79.0), ('2015-06-15', 79.0), ('2015-06-16', 77.0), ('2015-06-17', 75.0), ('2015-06-18', 76.0), ('2015-06-19', 78.0), ('2015-06-20', 78.0), ('2015-06-21', 80.0), ('2015-06-22', 78.0), ('2015-06-23', 79.0), ('2015-06-24', 79.0), ('2015-06-25', 77.0), ('2015-06-26', 77.0), ('2015-06-27', 81.0), ('2015-06-29', 75.0), ('2015-06-30', 72.0), ('2016-06-01', 75.0), ('2016-06-02', 75.0), ('2016-06-03', 75.0), ('2016-06-04', 75.0), ('2016-06-05', 73.0), ('2016-06-06', 78.0), ('2016-06-07', 77.0), ('2016-06-08', 80.0), ('2016-06-09', 72.0), ('2016-06-10', 78.0), ('2016-06-11', 78.0), ('2016-06-12', 77.0), ('2016-06-13', 78.0), ('2016-06-14', 79.0), ('2016-06-15', 80.0), ('2016-06-17', 76.0), ('2016-06-18', 77.0), ('2016-06-19', 79.0), ('2016-06-20', 79.0), ('2016-06-21', 77.0), ('2016-06-22', 79.0), ('2016-06-23', 80.0), ('2016-06-24', 80.0), ('2016-06-25', 77.0), ('2016-06-26', 79.0), ('2016-06-27', 81.0), ('2016-06-28', 78.0), ('2016-06-29', 80.0), ('2016-06-30', 79.0), ('2017-06-01', 79.0), ('2017-06-02', 81.0), ('2017-06-03', 79.0), ('2017-06-04', 81.0), ('2017-06-05', 78.0), ('2017-06-06', 78.0), ('2017-06-07', 78.0), ('2017-06-08', 77.0), ('2017-06-09', 78.0), ('2017-06-10', 75.0), ('2017-06-11', 81.0), ('2017-06-12', 80.0), ('2017-06-13', 77.0), ('2017-06-14', 80.0), ('2017-06-15', 78.0), ('2017-06-16', 80.0), ('2017-06-17', 77.0), ('2017-06-18', 78.0), ('2017-06-19', 78.0), ('2017-06-21', 80.0), ('2017-06-22', 80.0), ('2017-06-23', 79.0), ('2017-06-24', 82.0), ('2017-06-25', 80.0), ('2017-06-26', 81.0), ('2017-06-27', 81.0), ('2017-06-28', 79.0), ('2017-06-29', 78.0), ('2017-06-30', 75.0), ('2010-06-01', 71.0), ('2010-06-02', 71.0), ('2010-06-03', 72.0), ('2010-06-04', 72.0), ('2010-06-05', 76.0), ('2010-06-06', 77.0), ('2010-06-07', 71.0), ('2010-06-08', 73.0), ('2010-06-09', 73.0), ('2010-06-10', 75.0), ('2010-06-11', 81.0), ('2010-06-12', 74.0), ('2010-06-13', 77.0), ('2010-06-14', 70.0), ('2010-06-15', 69.0), ('2010-06-16', 70.0), ('2010-06-17', 72.0), ('2010-06-18', 71.0), ('2010-06-19', 77.0), ('2010-06-20', 76.0), ('2010-06-21', 74.0), ('2010-06-22', 74.0), ('2010-06-23', 74.0), ('2010-06-24', 74.0), ('2010-06-25', 71.0), ('2010-06-26', 80.0), ('2010-06-27', 77.0), ('2010-06-28', 72.0), ('2010-06-29', 72.0), ('2010-06-30', 73.0), ('2011-06-01', 72.0), ('2011-06-02', 73.0), ('2011-06-03', 73.0), ('2011-06-08', 77.0), ('2011-06-09', 76.0), ('2011-06-10', 79.0), ('2011-06-11', 78.0), ('2011-06-12', 82.0), ('2011-06-13', 79.0), ('2011-06-14', 76.0), ('2011-06-15', 74.0), ('2011-06-16', 74.0), ('2011-06-17', 73.0), ('2011-06-18', 79.0), ('2011-06-19', 77.0), ('2011-06-20', 73.0), ('2011-06-21', 72.0), ('2011-06-22', 72.0), ('2011-06-23', 73.0), ('2011-06-24', 74.0), ('2011-06-25', 77.0), ('2011-06-26', 73.0), ('2011-06-27', 73.0), ('2011-06-28', 72.0), ('2011-06-29', 72.0), ('2011-06-30', 67.0), ('2012-06-01', 71.0), ('2012-06-02', 73.0), ('2012-06-03', 78.0), ('2012-06-04', 71.0), ('2012-06-05', 72.0), ('2012-06-06', 70.0), ('2012-06-07', 72.0), ('2012-06-08', 73.0), ('2012-06-09', 74.0), ('2012-06-10', 81.0), ('2012-06-11', 72.0), ('2012-06-12', 77.0), ('2012-06-13', 69.0), ('2012-06-14', 69.0), ('2012-06-15', 69.0), ('2012-06-16', 78.0), ('2012-06-17', 78.0), ('2012-06-18', 73.0), ('2012-06-19', 72.0), ('2012-06-20', 71.0), ('2012-06-21', 72.0), ('2012-06-22', 72.0), ('2012-06-23', 73.0), ('2012-06-24', 71.0), ('2012-06-25', 70.0), ('2012-06-26', 71.0), ('2012-06-27', 68.0), ('2012-06-28', 72.0), ('2012-06-29', 71.0), ('2012-06-30', 78.0), ('2013-06-01', 81.0), ('2013-06-02', 74.0), ('2013-06-03', 74.0), ('2013-06-04', 73.0), ('2013-06-05', 73.0), ('2013-06-06', 72.0), ('2013-06-07', 73.0), ('2013-06-08', 77.0), ('2013-06-09', 73.0), ('2013-06-10', 73.0), ('2013-06-11', 75.0), ('2013-06-12', 72.0), ('2013-06-13', 72.0), ('2013-06-14', 73.0), ('2013-06-15', 73.0), ('2013-06-16', 75.0), ('2013-06-17', 72.0), ('2013-06-18', 73.0), ('2013-06-19', 70.0), ('2013-06-20', 69.0), ('2013-06-21', 68.0), ('2013-06-22', 75.0), ('2013-06-23', 74.0), ('2013-06-24', 73.0), ('2013-06-25', 70.0), ('2013-06-26', 70.0), ('2013-06-27', 71.0), ('2013-06-28', 70.0), ('2013-06-29', 70.0), ('2013-06-30', 75.0), ('2014-06-01', 74.0), ('2014-06-02', 72.0), ('2014-06-03', 74.0), ('2014-06-04', 73.0), ('2014-06-05', 73.0), ('2014-06-06', 70.0), ('2014-06-07', 73.0), ('2014-06-08', 75.0), ('2014-06-09', 73.0), ('2014-06-10', 69.0), ('2014-06-11', 80.0), ('2014-06-12', 73.0), ('2014-06-13', 72.0), ('2014-06-14', 80.0), ('2014-06-15', 80.0), ('2014-06-16', 69.0), ('2014-06-17', 70.0), ('2014-06-18', 69.0), ('2014-06-19', 72.0), ('2014-06-20', 68.0), ('2014-06-21', 74.0), ('2014-06-22', 75.0), ('2014-06-23', 70.0), ('2014-06-24', 70.0), ('2014-06-25', 72.0), ('2014-06-26', 71.0), ('2014-06-27', 70.0), ('2014-06-28', 77.0), ('2014-06-29', 73.0), ('2014-06-30', 71.0), ('2015-06-01', 76.0), ('2015-06-02', 68.0), ('2015-06-03', 71.0), ('2015-06-04', 70.0), ('2015-06-05', 68.0), ('2015-06-06', 79.0), ('2015-06-07', 75.0), ('2015-06-08', 71.0), ('2015-06-09', 69.0), ('2015-06-10', 71.0), ('2015-06-11', 72.0), ('2015-06-12', 69.0), ('2015-06-13', 72.0), ('2015-06-14', 75.0), ('2015-06-15', 71.0), ('2015-06-16', 72.0), ('2015-06-17', 70.0), ('2015-06-18', 71.0), ('2015-06-19', 72.0), ('2015-06-20', 75.0), ('2015-06-21', 75.0), ('2015-06-22', 71.0), ('2015-06-23', 73.0), ('2015-06-24', 71.0), ('2015-06-25', 71.0), ('2015-06-26', 74.0), ('2015-06-27', 74.0), ('2015-06-28', 78.0), ('2015-06-29', 72.0), ('2015-06-30', 69.0), ('2016-06-01', 69.0), ('2016-06-02', 67.0), ('2016-06-03', 68.0), ('2016-06-04', 65.0), ('2016-06-05', 70.0), ('2016-06-06', 72.0), ('2016-06-07', 74.0), ('2016-06-08', 73.0), ('2016-06-09', 71.0), ('2016-06-10', 75.0), ('2016-06-11', 72.0), ('2016-06-12', 75.0), ('2016-06-13', 76.0), ('2016-06-14', 75.0), ('2016-06-15', 76.0), ('2016-06-16', 75.0), ('2016-06-17', 71.0), ('2016-06-18', 75.0), ('2016-06-19', 75.0), ('2016-06-20', 72.0), ('2016-06-21', 72.0), ('2016-06-22', 75.0), ('2016-06-23', 73.0), ('2016-06-24', 76.0), ('2016-06-25', 74.0), ('2016-06-26', 77.0), ('2016-06-27', 72.0), ('2016-06-28', 71.0), ('2016-06-29', 76.0), ('2016-06-30', 77.0), ('2017-06-01', 80.0), ('2017-06-02', 76.0), ('2017-06-03', 76.0), ('2017-06-04', 77.0), ('2017-06-05', 75.0), ('2017-06-06', 75.0), ('2017-06-07', 75.0), ('2017-06-08', 75.0), ('2017-06-09', 72.0), ('2017-06-10', 74.0), ('2017-06-11', 74.0), ('2017-06-12', 74.0), ('2017-06-13', 76.0), ('2017-06-14', 74.0), ('2017-06-15', 75.0), ('2017-06-16', 73.0), ('2017-06-17', 79.0), ('2017-06-18', 75.0), ('2017-06-19', 72.0), ('2017-06-20', 72.0), ('2017-06-21', 74.0), ('2017-06-22', 72.0), ('2017-06-23', 72.0), ('2017-06-24', 77.0), ('2017-06-25', 71.0), ('2017-06-26', 73.0), ('2017-06-27', 76.0), ('2017-06-28', 77.0), ('2017-06-29', 76.0), ('2017-06-30', 76.0), ('2010-06-01', 74.0), ('2010-06-02', 76.0), ('2010-06-03', 78.0), ('2010-06-04', 74.0), ('2010-06-05', 79.0), ('2010-06-06', 79.0), ('2010-06-07', 69.0), ('2010-06-08', 77.0), ('2010-06-09', 80.0), ('2010-06-10', 75.0), ('2010-06-11', 75.0), ('2010-06-12', 78.0), ('2010-06-14', 71.0), ('2010-06-15', 76.0), ('2010-06-16', 74.0), ('2010-06-17', 78.0), ('2010-06-18', 72.0), ('2010-06-19', 78.0), ('2010-06-20', 85.0), ('2010-06-21', 77.0), ('2010-06-22', 76.0), ('2010-06-23', 76.0), ('2010-06-24', 75.0), ('2010-06-25', 71.0), ('2010-06-26', 70.0), ('2010-06-27', 80.0), ('2010-06-28', 77.0), ('2010-06-29', 70.0), ('2010-06-30', 73.0), ('2011-06-01', 73.0), ('2011-06-02', 76.0), ('2011-06-03', 70.0), ('2011-06-04', 71.0), ('2011-06-05', 80.0), ('2011-06-06', 70.0), ('2011-06-07', 68.0), ('2011-06-08', 74.0), ('2011-06-09', 75.0), ('2011-06-10', 75.0), ('2011-06-11', 78.0), ('2011-06-12', 76.0), ('2011-06-13', 69.0), ('2011-06-14', 73.0), ('2011-06-15', 76.0), ('2011-06-16', 72.0), ('2011-06-17', 72.0), ('2011-06-18', 80.0), ('2011-06-19', 76.0), ('2011-06-20', 71.0), ('2011-06-21', 68.0), ('2011-06-22', 71.0), ('2011-06-23', 72.0), ('2011-06-24', 75.0), ('2011-06-25', 80.0), ('2011-06-26', 75.0), ('2011-06-27', 74.0), ('2011-06-28', 74.0), ('2011-06-29', 69.0), ('2011-06-30', 70.0), ('2012-06-01', 73.0), ('2012-06-02', 76.0), ('2012-06-03', 76.0), ('2012-06-04', 74.0), ('2012-06-05', 71.0), ('2012-06-06', 72.0), ('2012-06-07', 73.0), ('2012-06-08', 77.0), ('2012-06-09', 77.0), ('2012-06-10', 77.0), ('2012-06-11', 79.0), ('2012-06-12', 77.0), ('2012-06-13', 77.0), ('2012-06-14', 78.0), ('2012-06-16', 78.0), ('2012-06-17', 81.0), ('2012-06-18', 76.0), ('2012-06-19', 74.0), ('2012-06-20', 71.0), ('2012-06-21', 78.0), ('2012-06-22', 71.0), ('2012-06-23', 76.0), ('2012-06-24', 81.0), ('2012-06-25', 73.0), ('2012-06-26', 72.0), ('2012-06-27', 72.0), ('2012-06-28', 74.0), ('2012-06-29', 72.0), ('2012-06-30', 79.0), ('2013-06-01', 80.0), ('2013-06-02', 81.0), ('2013-06-03', 75.0), ('2013-06-04', 80.0), ('2013-06-05', 73.0), ('2013-06-06', 74.0), ('2013-06-07', 73.0), ('2013-06-08', 81.0), ('2013-06-09', 79.0), ('2013-06-10', 78.0), ('2013-06-11', 74.0), ('2013-06-12', 74.0), ('2013-06-13', 73.0), ('2013-06-14', 73.0), ('2013-06-15', 77.0), ('2013-06-16', 77.0), ('2013-06-17', 74.0), ('2013-06-18', 73.0), ('2013-06-19', 70.0), ('2013-06-20', 69.0), ('2013-06-21', 72.0), ('2013-06-22', 79.0), ('2013-06-23', 77.0), ('2013-06-24', 70.0), ('2013-06-25', 71.0), ('2013-06-26', 67.0), ('2013-06-27', 66.0), ('2013-06-28', 78.0), ('2013-06-29', 80.0), ('2013-06-30', 80.0), ('2014-06-01', 79.0), ('2014-06-02', 68.0), ('2014-06-03', 67.0), ('2014-06-04', 71.0), ('2014-06-06', 72.0), ('2014-06-07', 79.0), ('2014-06-08', 80.0), ('2014-06-09', 72.0), ('2014-06-10', 68.0), ('2014-06-11', 84.0), ('2014-06-12', 82.0), ('2014-06-13', 79.0), ('2014-06-14', 78.0), ('2014-06-15', 81.0), ('2014-06-16', 77.0), ('2014-06-17', 71.0), ('2014-06-18', 69.0), ('2014-06-19', 73.0), ('2014-06-20', 68.0), ('2014-06-21', 75.0), ('2014-06-22', 79.0), ('2014-06-23', 70.0), ('2014-06-24', 70.0), ('2014-06-25', 73.0), ('2014-06-26', 71.0), ('2014-06-27', 68.0), ('2014-06-29', 78.0), ('2014-06-30', 69.0), ('2015-06-01', 70.0), ('2015-06-02', 67.0), ('2015-06-03', 68.0), ('2015-06-04', 68.0), ('2015-06-05', 71.0), ('2015-06-08', 74.0), ('2015-06-09', 69.0), ('2015-06-11', 69.0), ('2015-06-12', 66.0), ('2015-06-15', 67.0), ('2015-06-16', 69.0), ('2015-06-17', 72.0), ('2015-06-18', 72.0), ('2015-06-19', 72.0), ('2015-06-22', 70.0), ('2015-06-23', 75.0), ('2015-06-24', 73.0), ('2015-06-25', 70.0), ('2015-06-26', 71.0), ('2010-06-01', 70.0), ('2010-06-02', 78.0), ('2010-06-03', 73.0), ('2010-06-04', 68.0), ('2010-06-05', 79.0), ('2010-06-06', 74.0), ('2010-06-07', 75.0), ('2010-06-08', 71.0), ('2010-06-09', 75.0), ('2010-06-14', 76.0), ('2010-06-16', 73.0), ('2010-06-17', 73.0), ('2010-06-19', 74.0), ('2010-06-22', 72.0), ('2010-06-23', 72.0), ('2010-06-24', 72.0), ('2010-06-25', 70.0), ('2010-06-26', 69.0), ('2010-06-27', 73.0), ('2010-06-28', 71.0), ('2010-06-29', 73.0), ('2010-06-30', 72.0), ('2011-06-01', 69.0), ('2011-06-02', 72.0), ('2011-06-03', 66.0), ('2011-06-04', 67.0), ('2011-06-05', 71.0), ('2011-06-06', 71.0), ('2011-06-07', 72.0), ('2011-06-08', 72.0), ('2011-06-09', 71.0), ('2011-06-10', 71.0), ('2011-06-11', 71.0), ('2011-06-12', 69.0), ('2011-06-13', 68.0), ('2011-06-14', 71.0), ('2011-06-15', 73.0), ('2011-06-16', 72.0), ('2011-06-17', 74.0), ('2011-06-18', 70.0), ('2011-06-19', 72.0), ('2011-06-20', 71.0), ('2011-06-21', 71.0), ('2011-06-22', 70.0), ('2011-06-23', 70.0), ('2011-06-24', 69.0), ('2011-06-25', 74.0), ('2011-06-26', 69.0), ('2011-06-27', 72.0), ('2011-06-28', 70.0), ('2011-06-29', 72.0), ('2011-06-30', 72.0), ('2012-06-01', 69.0), ('2012-06-02', 73.0), ('2012-06-03', 71.0), ('2012-06-04', 72.0), ('2012-06-05', 71.0), ('2012-06-06', 72.0), ('2012-06-07', 71.0), ('2012-06-08', 74.0), ('2012-06-09', 74.0), ('2012-06-10', 75.0), ('2012-06-11', 69.0), ('2012-06-12', 75.0), ('2012-06-13', 70.0), ('2012-06-14', 73.0), ('2012-06-15', 72.0), ('2012-06-16', 70.0), ('2012-06-17', 73.0), ('2012-06-18', 71.0), ('2012-06-19', 70.0), ('2012-06-20', 69.0), ('2012-06-21', 71.0), ('2012-06-23', 68.0), ('2012-06-24', 68.0), ('2012-06-25', 68.0), ('2012-06-26', 69.0), ('2012-06-27', 69.0), ('2012-06-28', 69.0), ('2012-06-29', 71.0), ('2013-06-01', 78.0), ('2013-06-02', 72.0), ('2013-06-03', 73.0), ('2013-06-04', 71.0), ('2013-06-05', 72.0), ('2013-06-06', 72.0), ('2013-06-07', 71.0), ('2013-06-08', 74.0), ('2013-06-09', 71.0), ('2013-06-10', 72.0), ('2013-06-11', 72.0), ('2013-06-12', 74.0), ('2013-06-13', 72.0), ('2013-06-14', 69.0), ('2013-06-15', 70.0), ('2013-06-16', 76.0), ('2013-06-17', 70.0), ('2013-06-18', 71.0), ('2013-06-19', 73.0), ('2013-06-20', 68.0), ('2013-06-21', 68.0), ('2013-06-22', 69.0), ('2013-06-23', 70.0), ('2013-06-24', 69.0), ('2013-06-25', 69.0), ('2013-06-26', 70.0), ('2013-06-27', 71.0), ('2013-06-28', 70.0), ('2013-06-29', 67.0), ('2013-06-30', 72.0), ('2014-06-01', 72.0), ('2014-06-02', 75.0), ('2014-06-03', 73.0), ('2014-06-04', 73.0), ('2014-06-05', 72.0), ('2014-06-06', 71.0), ('2014-06-07', 77.0), ('2014-06-08', 73.0), ('2014-06-09', 70.0), ('2014-06-10', 70.0), ('2014-06-11', 76.0), ('2014-06-12', 72.0), ('2014-06-13', 73.0), ('2014-06-14', 77.0), ('2014-06-15', 73.0), ('2014-06-16', 70.0), ('2014-06-17', 68.0), ('2014-06-18', 69.0), ('2014-06-19', 70.0), ('2014-06-20', 70.0), ('2014-06-21', 73.0), ('2014-06-22', 70.0), ('2014-06-23', 69.0), ('2014-06-24', 71.0), ('2014-06-25', 70.0), ('2014-06-26', 70.0), ('2014-06-27', 72.0), ('2014-06-28', 71.0), ('2014-06-29', 70.0), ('2015-06-01', 69.0), ('2015-06-02', 72.0), ('2015-06-03', 72.0), ('2015-06-04', 71.0), ('2015-06-05', 76.0), ('2015-06-06', 71.0), ('2015-06-07', 72.0), ('2015-06-08', 70.0), ('2015-06-09', 72.0), ('2015-06-10', 72.0), ('2015-06-12', 71.0), ('2015-06-13', 72.0), ('2015-06-14', 69.0), ('2015-06-15', 70.0), ('2015-06-16', 73.0), ('2015-06-17', 70.0), ('2015-06-18', 72.0), ('2015-06-19', 72.0), ('2015-06-20', 71.0), ('2015-06-21', 73.0), ('2015-06-22', 72.0), ('2015-06-23', 73.0), ('2015-06-24', 72.0), ('2015-06-25', 71.0), ('2015-06-26', 70.0), ('2015-06-27', 75.0), ('2015-06-28', 72.0), ('2015-06-29', 70.0), ('2015-06-30', 72.0), ('2016-06-01', 70.0), ('2016-06-02', 71.0), ('2016-06-03', 70.0), ('2016-06-05', 73.0), ('2016-06-06', 72.0), ('2016-06-07', 71.0), ('2016-06-08', 71.0), ('2016-06-09', 69.0), ('2016-06-10', 70.0), ('2016-06-11', 73.0), ('2016-06-12', 75.0), ('2016-06-13', 73.0), ('2016-06-14', 72.0), ('2016-06-15', 70.0), ('2016-06-16', 70.0), ('2016-06-17', 69.0), ('2016-06-18', 73.0), ('2016-06-19', 74.0), ('2016-06-20', 72.0), ('2016-06-21', 71.0), ('2016-06-22', 73.0), ('2016-06-23', 72.0), ('2016-06-25', 73.0), ('2016-06-26', 74.0), ('2016-06-27', 72.0), ('2016-06-28', 74.0), ('2016-06-29', 72.0), ('2017-06-01', 74.0), ('2017-06-03', 74.0), ('2017-06-04', 77.0), ('2017-06-05', 74.0), ('2017-06-06', 74.0), ('2017-06-07', 79.0), ('2017-06-08', 75.0), ('2017-06-10', 72.0), ('2017-06-11', 76.0), ('2017-06-12', 74.0), ('2017-06-13', 73.0), ('2017-06-14', 74.0), ('2017-06-15', 77.0), ('2017-06-16', 74.0), ('2017-06-17', 72.0), ('2017-06-18', 77.0), ('2017-06-19', 76.0), ('2017-06-20', 74.0), ('2017-06-21', 75.0), ('2017-06-22', 76.0), ('2017-06-23', 71.0), ('2017-06-24', 73.0), ('2017-06-25', 79.0), ('2017-06-26', 79.0), ('2017-06-27', 74.0), ('2017-06-28', 74.0), ('2017-06-29', 76.0), ('2017-06-30', 75.0)]\n"
     ]
    }
   ],
   "source": [
    "#  3. Convert the June temperatures to a list.\n",
    "# Used reference code from CarlySandler: \"SurfsUp_Challenge.ipynb\" on GitHub. Corrected syntax in parameters\n",
    "month_of_June = session.query(Measurement.date, Measurement.tobs).\\\n",
    "    filter(extract('month', Measurement.date)==6).all()\n",
    "print(month_of_June)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 4. Create a DataFrame from the list of temperatures for the month of June. \n",
    "# set the index to the date column\n",
    "df = pd.DataFrame(month_of_June, columns=['date', 'June Temps'])\n",
    "df.set_index(df['date'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>June Temps</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1700.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>74.944118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.257417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>64.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>73.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>75.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>77.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>85.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        June Temps\n",
       "count  1700.000000\n",
       "mean     74.944118\n",
       "std       3.257417\n",
       "min      64.000000\n",
       "25%      73.000000\n",
       "50%      75.000000\n",
       "75%      77.000000\n",
       "max      85.000000"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 5. Calculate and print out the summary statistics for the June temperature DataFrame.\n",
    "df.describe()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## D2: Determine the Summary Statistics for December"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "SELECT measurement.date AS measurement_date, measurement.tobs AS measurement_tobs \n",
      "FROM measurement \n",
      "WHERE CAST(STRFTIME('%m', measurement.date) AS INTEGER) = ?\n"
     ]
    }
   ],
   "source": [
    "# 6. Write a query that filters the Measurement table to retrieve the temperatures for the month of December.\n",
    "month_of_Dec = session.query(Measurement.date, Measurement.tobs).\\\n",
    "    filter(extract('month', Measurement.date)==12)\n",
    "print(month_of_Dec)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('2010-12-01', 76.0), ('2010-12-03', 74.0), ('2010-12-04', 74.0), ('2010-12-06', 64.0), ('2010-12-07', 64.0), ('2010-12-08', 67.0), ('2010-12-09', 77.0), ('2010-12-10', 66.0), ('2010-12-11', 69.0), ('2010-12-12', 68.0), ('2010-12-13', 68.0), ('2010-12-14', 71.0), ('2010-12-15', 74.0), ('2010-12-16', 67.0), ('2010-12-17', 66.0), ('2010-12-18', 69.0), ('2010-12-19', 71.0), ('2010-12-23', 70.0), ('2010-12-24', 70.0), ('2010-12-26', 74.0), ('2010-12-27', 74.0), ('2010-12-28', 71.0), ('2010-12-29', 75.0), ('2010-12-30', 75.0), ('2010-12-31', 72.0), ('2011-12-01', 69.0), ('2011-12-02', 68.0), ('2011-12-03', 73.0), ('2011-12-04', 74.0), ('2011-12-05', 73.0), ('2011-12-06', 73.0), ('2011-12-07', 73.0), ('2011-12-08', 73.0), ('2011-12-09', 71.0), ('2011-12-10', 73.0), ('2011-12-11', 73.0), ('2011-12-12', 77.0), ('2011-12-13', 72.0), ('2011-12-14', 71.0), ('2011-12-15', 73.0), ('2011-12-16', 70.0), ('2011-12-17', 73.0), ('2011-12-18', 69.0), ('2011-12-19', 74.0), ('2011-12-20', 72.0), ('2011-12-21', 71.0), ('2011-12-22', 72.0), ('2011-12-23', 72.0), ('2011-12-24', 70.0), ('2011-12-25', 73.0), ('2011-12-26', 73.0), ('2011-12-27', 72.0), ('2011-12-28', 73.0), ('2011-12-29', 73.0), ('2011-12-30', 72.0), ('2011-12-31', 63.0), ('2012-12-01', 65.0), ('2012-12-02', 71.0), ('2012-12-03', 76.0), ('2012-12-04', 70.0), ('2012-12-05', 76.0), ('2012-12-06', 69.0), ('2012-12-07', 69.0), ('2012-12-08', 69.0), ('2012-12-09', 74.0), ('2012-12-10', 76.0), ('2012-12-11', 74.0), ('2012-12-12', 73.0), ('2012-12-13', 73.0), ('2012-12-14', 74.0), ('2012-12-15', 73.0), ('2012-12-16', 73.0), ('2012-12-17', 73.0), ('2012-12-18', 74.0), ('2012-12-19', 74.0), ('2012-12-20', 71.0), ('2012-12-21', 73.0), ('2012-12-22', 72.0), ('2012-12-23', 64.0), ('2012-12-24', 66.0), ('2012-12-26', 73.0), ('2012-12-27', 72.0), ('2012-12-28', 65.0), ('2012-12-29', 64.0), ('2012-12-30', 69.0), ('2012-12-31', 68.0), ('2013-12-01', 77.0), ('2013-12-02', 71.0), ('2013-12-03', 71.0), ('2013-12-04', 69.0), ('2013-12-05', 68.0), ('2013-12-06', 68.0), ('2013-12-07', 69.0), ('2013-12-08', 70.0), ('2013-12-09', 72.0), ('2013-12-10', 76.0), ('2013-12-11', 75.0), ('2013-12-12', 69.0), ('2013-12-13', 71.0), ('2013-12-14', 71.0), ('2013-12-15', 71.0), ('2013-12-16', 68.0), ('2013-12-17', 65.0), ('2013-12-18', 70.0), ('2013-12-19', 69.0), ('2013-12-20', 69.0), ('2013-12-21', 71.0), ('2013-12-22', 67.0), ('2013-12-23', 73.0), ('2013-12-24', 74.0), ('2013-12-25', 73.0), ('2013-12-26', 67.0), ('2013-12-27', 74.0), ('2013-12-28', 75.0), ('2013-12-29', 75.0), ('2013-12-30', 74.0), ('2013-12-31', 67.0), ('2014-12-01', 73.0), ('2014-12-02', 73.0), ('2014-12-03', 71.0), ('2014-12-04', 72.0), ('2014-12-05', 71.0), ('2014-12-06', 68.0), ('2014-12-07', 65.0), ('2014-12-08', 69.0), ('2014-12-09', 70.0), ('2014-12-10', 70.0), ('2014-12-11', 74.0), ('2014-12-12', 71.0), ('2014-12-13', 74.0), ('2014-12-14', 73.0), ('2014-12-15', 72.0), ('2014-12-16', 74.0), ('2014-12-17', 72.0), ('2014-12-18', 74.0), ('2014-12-19', 75.0), ('2014-12-20', 74.0), ('2014-12-21', 70.0), ('2014-12-22', 74.0), ('2014-12-23', 70.0), ('2014-12-24', 66.0), ('2014-12-25', 61.0), ('2014-12-26', 63.0), ('2014-12-27', 63.0), ('2014-12-28', 63.0), ('2014-12-29', 63.0), ('2014-12-30', 67.0), ('2014-12-31', 56.0), ('2015-12-01', 75.0), ('2015-12-02', 77.0), ('2015-12-03', 75.0), ('2015-12-04', 75.0), ('2015-12-05', 75.0), ('2015-12-06', 75.0), ('2015-12-07', 71.0), ('2015-12-08', 70.0), ('2015-12-09', 74.0), ('2015-12-10', 74.0), ('2015-12-11', 75.0), ('2015-12-12', 72.0), ('2015-12-13', 70.0), ('2015-12-14', 66.0), ('2015-12-15', 74.0), ('2015-12-16', 75.0), ('2015-12-17', 74.0), ('2015-12-18', 75.0), ('2015-12-19', 76.0), ('2015-12-20', 74.0), ('2015-12-21', 75.0), ('2015-12-22', 74.0), ('2015-12-23', 73.0), ('2015-12-24', 68.0), ('2015-12-25', 73.0), ('2015-12-26', 74.0), ('2015-12-27', 74.0), ('2015-12-28', 77.0), ('2015-12-29', 70.0), ('2015-12-30', 70.0), ('2015-12-31', 69.0), ('2016-12-01', 75.0), ('2016-12-02', 72.0), ('2016-12-03', 69.0), ('2016-12-04', 71.0), ('2016-12-05', 68.0), ('2016-12-06', 67.0), ('2016-12-07', 69.0), ('2016-12-08', 73.0), ('2016-12-09', 70.0), ('2016-12-10', 70.0), ('2016-12-11', 70.0), ('2016-12-12', 66.0), ('2016-12-13', 67.0), ('2016-12-14', 70.0), ('2016-12-15', 66.0), ('2016-12-16', 62.0), ('2016-12-17', 71.0), ('2016-12-18', 73.0), ('2016-12-19', 69.0), ('2016-12-20', 77.0), ('2016-12-21', 74.0), ('2016-12-22', 71.0), ('2016-12-23', 72.0), ('2016-12-24', 74.0), ('2016-12-25', 74.0), ('2016-12-26', 74.0), ('2016-12-27', 74.0), ('2016-12-28', 71.0), ('2016-12-29', 73.0), ('2016-12-30', 69.0), ('2016-12-31', 66.0), ('2010-12-01', 73.0), ('2010-12-02', 72.0), ('2010-12-03', 73.0), ('2010-12-04', 74.0), ('2010-12-05', 73.0), ('2010-12-06', 66.0), ('2010-12-07', 64.0), ('2010-12-08', 66.0), ('2010-12-09', 75.0), ('2010-12-10', 65.0), ('2010-12-11', 69.0), ('2010-12-12', 71.0), ('2010-12-13', 69.0), ('2010-12-14', 78.0), ('2010-12-15', 74.0), ('2010-12-16', 68.0), ('2010-12-17', 68.0), ('2010-12-18', 70.0), ('2010-12-19', 70.0), ('2010-12-20', 71.0), ('2010-12-21', 71.0), ('2010-12-22', 71.0), ('2010-12-23', 71.0), ('2010-12-24', 69.0), ('2010-12-25', 69.0), ('2010-12-26', 72.0), ('2010-12-27', 76.0), ('2010-12-28', 72.0), ('2010-12-29', 73.0), ('2010-12-30', 73.0), ('2010-12-31', 74.0), ('2011-12-01', 69.0), ('2011-12-02', 68.0), ('2011-12-03', 74.0), ('2011-12-04', 73.0), ('2011-12-05', 73.0), ('2011-12-06', 72.0), ('2011-12-07', 71.0), ('2011-12-08', 71.0), ('2011-12-09', 68.0), ('2011-12-10', 72.0), ('2011-12-11', 71.0), ('2011-12-12', 72.0), ('2011-12-13', 71.0), ('2011-12-14', 71.0), ('2011-12-15', 72.0), ('2011-12-16', 71.0), ('2011-12-17', 71.0), ('2011-12-18', 72.0), ('2011-12-19', 72.0), ('2011-12-20', 72.0), ('2011-12-21', 69.0), ('2011-12-22', 71.0), ('2011-12-23', 71.0), ('2011-12-24', 69.0), ('2011-12-25', 74.0), ('2011-12-26', 72.0), ('2011-12-27', 71.0), ('2011-12-28', 71.0), ('2011-12-29', 72.0), ('2011-12-30', 71.0), ('2011-12-31', 67.0), ('2012-12-01', 65.0), ('2012-12-02', 70.0), ('2012-12-03', 76.0), ('2012-12-04', 68.0), ('2012-12-05', 71.0), ('2012-12-06', 71.0), ('2012-12-07', 68.0), ('2012-12-08', 70.0), ('2012-12-09', 73.0), ('2012-12-10', 73.0), ('2012-12-11', 72.0), ('2012-12-12', 71.0), ('2012-12-13', 70.0), ('2012-12-14', 72.0), ('2012-12-15', 71.0), ('2012-12-16', 72.0), ('2012-12-17', 72.0), ('2012-12-18', 71.0), ('2012-12-19', 70.0), ('2012-12-20', 71.0), ('2012-12-21', 71.0), ('2012-12-22', 71.0), ('2012-12-23', 66.0), ('2012-12-24', 65.0), ('2012-12-25', 73.0), ('2012-12-26', 72.0), ('2012-12-27', 72.0), ('2012-12-28', 65.0), ('2012-12-29', 65.0), ('2012-12-30', 68.0), ('2012-12-31', 67.0), ('2013-12-01', 76.0), ('2013-12-02', 70.0), ('2013-12-03', 71.0), ('2013-12-04', 69.0), ('2013-12-05', 67.0), ('2013-12-06', 69.0), ('2013-12-07', 71.0), ('2013-12-08', 69.0), ('2013-12-09', 72.0), ('2013-12-10', 76.0), ('2013-12-11', 75.0), ('2013-12-12', 72.0), ('2013-12-13', 75.0), ('2013-12-14', 71.0), ('2013-12-15', 69.0), ('2013-12-16', 68.0), ('2013-12-17', 68.0), ('2013-12-18', 72.0), ('2013-12-19', 70.0), ('2013-12-20', 72.0), ('2013-12-21', 75.0), ('2013-12-22', 69.0), ('2013-12-23', 72.0), ('2013-12-24', 73.0), ('2013-12-25', 73.0), ('2013-12-26', 72.0), ('2013-12-27', 73.0), ('2013-12-28', 74.0), ('2013-12-29', 73.0), ('2013-12-30', 72.0), ('2013-12-31', 68.0), ('2014-12-01', 72.0), ('2014-12-02', 71.0), ('2014-12-03', 69.0), ('2014-12-04', 67.0), ('2014-12-05', 70.0), ('2014-12-06', 72.0), ('2014-12-07', 67.0), ('2014-12-08', 67.0), ('2014-12-09', 69.0), ('2014-12-10', 67.0), ('2014-12-11', 74.0), ('2014-12-12', 70.0), ('2014-12-13', 73.0), ('2014-12-14', 71.0), ('2014-12-15', 71.0), ('2014-12-16', 71.0), ('2014-12-17', 71.0), ('2014-12-18', 72.0), ('2014-12-19', 76.0), ('2014-12-20', 78.0), ('2014-12-21', 76.0), ('2014-12-22', 73.0), ('2014-12-23', 70.0), ('2014-12-24', 68.0), ('2014-12-25', 77.0), ('2014-12-26', 66.0), ('2014-12-27', 65.0), ('2014-12-28', 69.0), ('2014-12-29', 69.0), ('2014-12-30', 66.0), ('2014-12-31', 64.0), ('2015-12-02', 74.0), ('2015-12-03', 75.0), ('2015-12-04', 80.0), ('2015-12-05', 72.0), ('2015-12-06', 73.0), ('2015-12-07', 70.0), ('2015-12-08', 69.0), ('2015-12-09', 77.0), ('2015-12-10', 74.0), ('2015-12-11', 77.0), ('2015-12-12', 72.0), ('2015-12-13', 69.0), ('2015-12-14', 69.0), ('2015-12-15', 75.0), ('2015-12-16', 75.0), ('2015-12-17', 72.0), ('2015-12-18', 73.0), ('2015-12-19', 78.0), ('2015-12-20', 75.0), ('2015-12-21', 75.0), ('2015-12-22', 74.0), ('2015-12-23', 73.0), ('2015-12-24', 70.0), ('2015-12-25', 70.0), ('2015-12-26', 72.0), ('2015-12-27', 74.0), ('2015-12-28', 74.0), ('2015-12-29', 67.0), ('2015-12-30', 74.0), ('2015-12-31', 70.0), ('2016-12-01', 73.0), ('2016-12-02', 71.0), ('2016-12-03', 71.0), ('2016-12-04', 69.0), ('2016-12-05', 68.0), ('2016-12-06', 70.0), ('2016-12-07', 71.0), ('2016-12-08', 72.0), ('2016-12-09', 70.0), ('2016-12-10', 71.0), ('2016-12-11', 72.0), ('2016-12-12', 68.0), ('2016-12-13', 68.0), ('2016-12-14', 70.0), ('2016-12-15', 70.0), ('2016-12-16', 63.0), ('2016-12-17', 71.0), ('2016-12-18', 67.0), ('2016-12-19', 69.0), ('2016-12-20', 74.0), ('2016-12-21', 72.0), ('2016-12-22', 70.0), ('2016-12-23', 69.0), ('2016-12-24', 73.0), ('2016-12-25', 74.0), ('2016-12-26', 74.0), ('2016-12-27', 73.0), ('2016-12-28', 71.0), ('2016-12-29', 72.0), ('2016-12-30', 69.0), ('2016-12-31', 71.0), ('2010-12-01', 73.0), ('2010-12-02', 73.0), ('2010-12-03', 71.0), ('2010-12-04', 72.0), ('2010-12-05', 71.0), ('2010-12-06', 64.0), ('2010-12-07', 71.0), ('2010-12-08', 62.0), ('2010-12-09', 70.0), ('2010-12-10', 64.0), ('2010-12-11', 64.0), ('2010-12-12', 70.0), ('2010-12-13', 70.0), ('2010-12-14', 69.0), ('2010-12-15', 72.0), ('2010-12-16', 68.0), ('2010-12-17', 68.0), ('2010-12-18', 65.0), ('2010-12-19', 67.0), ('2010-12-20', 68.0), ('2010-12-21', 70.0), ('2010-12-22', 67.0), ('2010-12-23', 73.0), ('2010-12-24', 70.0), ('2010-12-26', 68.0), ('2010-12-27', 72.0), ('2010-12-28', 69.0), ('2010-12-29', 71.0), ('2010-12-30', 70.0), ('2010-12-31', 75.0), ('2011-12-01', 70.0), ('2011-12-02', 68.0), ('2011-12-03', 73.0), ('2011-12-04', 71.0), ('2011-12-05', 71.0), ('2011-12-06', 70.0), ('2011-12-07', 70.0), ('2011-12-08', 70.0), ('2011-12-09', 70.0), ('2011-12-10', 72.0), ('2011-12-12', 74.0), ('2011-12-13', 71.0), ('2011-12-14', 70.0), ('2011-12-15', 70.0), ('2011-12-16', 69.0), ('2011-12-18', 71.0), ('2011-12-19', 70.0), ('2011-12-20', 70.0), ('2011-12-21', 72.0), ('2011-12-22', 72.0), ('2011-12-24', 72.0), ('2011-12-26', 72.0), ('2011-12-27', 72.0), ('2011-12-29', 70.0), ('2011-12-30', 66.0), ('2011-12-31', 71.0), ('2012-12-01', 68.0), ('2012-12-03', 79.0), ('2012-12-04', 76.0), ('2012-12-05', 73.0), ('2012-12-06', 75.0), ('2012-12-07', 71.0), ('2012-12-10', 76.0), ('2012-12-11', 74.0), ('2012-12-12', 73.0), ('2012-12-13', 73.0), ('2012-12-14', 74.0), ('2012-12-17', 73.0), ('2012-12-18', 72.0), ('2012-12-19', 76.0), ('2012-12-21', 75.0), ('2012-12-22', 77.0), ('2012-12-24', 74.0), ('2012-12-26', 76.0), ('2012-12-28', 75.0), ('2012-12-31', 76.0), ('2013-12-02', 73.0), ('2013-12-03', 75.0), ('2013-12-04', 73.0), ('2013-12-05', 73.0), ('2013-12-06', 74.0), ('2013-12-07', 78.0), ('2013-12-08', 78.0), ('2013-12-09', 78.0), ('2013-12-10', 75.0), ('2013-12-11', 75.0), ('2013-12-12', 75.0), ('2013-12-13', 74.0), ('2013-12-14', 77.0), ('2013-12-16', 72.0), ('2013-12-17', 72.0), ('2013-12-18', 73.0), ('2013-12-19', 71.0), ('2013-12-20', 75.0), ('2013-12-21', 76.0), ('2013-12-23', 74.0), ('2013-12-24', 75.0), ('2013-12-26', 74.0), ('2013-12-27', 75.0), ('2013-12-28', 73.0), ('2013-12-29', 72.0), ('2013-12-30', 72.0), ('2013-12-31', 75.0), ('2014-12-01', 74.0), ('2014-12-02', 74.0), ('2014-12-03', 72.0), ('2014-12-04', 73.0), ('2014-12-05', 70.0), ('2014-12-06', 76.0), ('2014-12-08', 78.0), ('2014-12-09', 76.0), ('2014-12-10', 78.0), ('2014-12-11', 74.0), ('2014-12-12', 71.0), ('2014-12-13', 78.0), ('2014-12-15', 70.0), ('2014-12-16', 74.0), ('2014-12-17', 74.0), ('2014-12-18', 75.0), ('2014-12-19', 76.0), ('2014-12-20', 78.0), ('2014-12-22', 72.0), ('2014-12-23', 73.0), ('2014-12-25', 76.0), ('2014-12-29', 72.0), ('2014-12-31', 72.0), ('2015-12-01', 78.0), ('2015-12-02', 76.0), ('2015-12-03', 76.0), ('2015-12-04', 77.0), ('2015-12-07', 79.0), ('2015-12-08', 73.0), ('2015-12-09', 79.0), ('2015-12-10', 77.0), ('2015-12-11', 78.0), ('2015-12-12', 76.0), ('2015-12-13', 78.0), ('2015-12-14', 77.0), ('2015-12-15', 79.0), ('2015-12-16', 75.0), ('2015-12-17', 77.0), ('2015-12-18', 76.0), ('2015-12-19', 78.0), ('2015-12-21', 78.0), ('2015-12-22', 77.0), ('2015-12-23', 78.0), ('2015-12-25', 78.0), ('2015-12-27', 76.0), ('2015-12-28', 75.0), ('2015-12-29', 72.0), ('2016-12-01', 75.0), ('2016-12-02', 77.0), ('2016-12-03', 75.0), ('2016-12-04', 77.0), ('2016-12-05', 76.0), ('2016-12-07', 76.0), ('2016-12-08', 75.0), ('2016-12-09', 72.0), ('2016-12-10', 76.0), ('2016-12-12', 75.0), ('2016-12-13', 72.0), ('2016-12-14', 72.0), ('2016-12-15', 75.0), ('2016-12-16', 69.0), ('2016-12-17', 75.0), ('2016-12-18', 74.0), ('2016-12-19', 78.0), ('2016-12-20', 77.0), ('2016-12-21', 76.0), ('2016-12-22', 72.0), ('2016-12-23', 73.0), ('2016-12-24', 74.0), ('2016-12-26', 74.0), ('2016-12-27', 74.0), ('2016-12-28', 73.0), ('2016-12-29', 73.0), ('2016-12-30', 71.0), ('2016-12-31', 72.0), ('2010-12-01', 72.0), ('2010-12-02', 75.0), ('2010-12-06', 66.0), ('2010-12-07', 66.0), ('2010-12-08', 67.0), ('2010-12-09', 76.0), ('2010-12-10', 68.0), ('2010-12-13', 69.0), ('2010-12-14', 71.0), ('2010-12-15', 70.0), ('2010-12-16', 68.0), ('2010-12-17', 66.0), ('2011-12-01', 69.0), ('2011-12-02', 69.0), ('2011-12-05', 71.0), ('2011-12-06', 72.0), ('2011-12-07', 69.0), ('2011-12-08', 72.0), ('2011-12-09', 70.0), ('2011-12-12', 76.0), ('2011-12-13', 69.0), ('2011-12-14', 71.0), ('2011-12-15', 72.0), ('2011-12-16', 71.0), ('2012-12-03', 78.0), ('2012-12-04', 73.0), ('2012-12-05', 74.0), ('2012-12-06', 68.0), ('2012-12-07', 71.0), ('2012-12-10', 76.0), ('2012-12-11', 75.0), ('2012-12-12', 74.0), ('2012-12-13', 73.0), ('2012-12-14', 73.0), ('2012-12-27', 74.0), ('2012-12-28', 69.0), ('2013-12-02', 74.0), ('2013-12-03', 72.0), ('2013-12-04', 70.0), ('2013-12-05', 67.0), ('2013-12-06', 69.0), ('2013-12-09', 73.0), ('2013-12-10', 75.0), ('2013-12-11', 74.0), ('2013-12-12', 72.0), ('2013-12-13', 71.0), ('2013-12-16', 67.0), ('2013-12-17', 74.0), ('2013-12-18', 70.0), ('2013-12-19', 70.0), ('2013-12-20', 70.0), ('2013-12-23', 71.0), ('2013-12-24', 70.0), ('2013-12-26', 71.0), ('2013-12-27', 71.0), ('2013-12-28', 68.0), ('2014-12-01', 74.0), ('2014-12-02', 75.0), ('2014-12-03', 74.0), ('2014-12-04', 77.0), ('2014-12-05', 76.0), ('2014-12-08', 77.0), ('2014-12-09', 75.0), ('2014-12-10', 76.0), ('2014-12-11', 75.0), ('2014-12-15', 77.0), ('2014-12-16', 75.0), ('2014-12-17', 77.0), ('2014-12-18', 74.0), ('2014-12-19', 78.0), ('2014-12-22', 77.0), ('2014-12-23', 76.0), ('2014-12-24', 69.0), ('2014-12-26', 70.0), ('2014-12-29', 64.0), ('2014-12-30', 75.0), ('2015-12-01', 69.0), ('2015-12-02', 65.0), ('2015-12-03', 76.0), ('2015-12-04', 81.0), ('2015-12-08', 71.0), ('2015-12-09', 71.0), ('2015-12-10', 71.0), ('2015-12-16', 82.0), ('2015-12-17', 74.0), ('2015-12-18', 75.0), ('2015-12-24', 77.0), ('2015-12-27', 74.0), ('2015-12-28', 68.0), ('2016-12-01', 72.0), ('2016-12-02', 70.0), ('2016-12-05', 68.0), ('2016-12-06', 74.0), ('2016-12-07', 71.0), ('2016-12-08', 70.0), ('2016-12-09', 70.0), ('2016-12-12', 70.0), ('2016-12-13', 68.0), ('2016-12-14', 68.0), ('2016-12-15', 68.0), ('2016-12-16', 66.0), ('2016-12-19', 71.0), ('2016-12-20', 76.0), ('2016-12-21', 73.0), ('2016-12-22', 70.0), ('2016-12-23', 68.0), ('2016-12-28', 71.0), ('2016-12-29', 71.0), ('2016-12-30', 68.0), ('2010-12-02', 71.0), ('2010-12-03', 70.0), ('2010-12-05', 73.0), ('2010-12-06', 78.0), ('2010-12-07', 76.0), ('2010-12-08', 73.0), ('2010-12-09', 74.0), ('2010-12-10', 63.0), ('2010-12-11', 72.0), ('2010-12-13', 75.0), ('2010-12-14', 74.0), ('2010-12-15', 72.0), ('2010-12-16', 68.0), ('2012-12-03', 74.0), ('2012-12-06', 73.0), ('2013-12-17', 73.0), ('2013-12-19', 72.0), ('2013-12-20', 73.0), ('2013-12-23', 72.0), ('2010-12-01', 78.0), ('2010-12-02', 74.0), ('2010-12-03', 74.0), ('2010-12-04', 78.0), ('2010-12-05', 78.0), ('2010-12-06', 61.0), ('2010-12-07', 69.0), ('2010-12-08', 65.0), ('2010-12-09', 77.0), ('2010-12-10', 67.0), ('2010-12-11', 69.0), ('2010-12-12', 75.0), ('2010-12-13', 67.0), ('2010-12-14', 71.0), ('2010-12-15', 74.0), ('2010-12-16', 66.0), ('2010-12-17', 66.0), ('2010-12-18', 77.0), ('2010-12-19', 70.0), ('2010-12-20', 73.0), ('2010-12-21', 71.0), ('2010-12-22', 71.0), ('2010-12-23', 71.0), ('2010-12-24', 67.0), ('2010-12-25', 71.0), ('2010-12-26', 74.0), ('2010-12-27', 76.0), ('2010-12-28', 72.0), ('2010-12-29', 74.0), ('2010-12-30', 75.0), ('2010-12-31', 69.0), ('2011-12-01', 69.0), ('2011-12-02', 69.0), ('2011-12-03', 75.0), ('2011-12-04', 73.0), ('2011-12-05', 73.0), ('2011-12-06', 72.0), ('2011-12-07', 72.0), ('2011-12-08', 72.0), ('2011-12-09', 74.0), ('2011-12-10', 72.0), ('2011-12-11', 73.0), ('2011-12-12', 73.0), ('2011-12-13', 73.0), ('2011-12-14', 73.0), ('2011-12-15', 74.0), ('2011-12-16', 73.0), ('2011-12-17', 71.0), ('2011-12-18', 72.0), ('2011-12-19', 73.0), ('2011-12-20', 74.0), ('2011-12-21', 72.0), ('2011-12-22', 73.0), ('2011-12-23', 73.0), ('2011-12-24', 71.0), ('2011-12-25', 73.0), ('2011-12-26', 75.0), ('2011-12-27', 71.0), ('2011-12-28', 72.0), ('2011-12-29', 73.0), ('2011-12-30', 71.0), ('2011-12-31', 65.0), ('2012-12-01', 77.0), ('2012-12-02', 72.0), ('2012-12-03', 78.0), ('2012-12-04', 71.0), ('2012-12-05', 72.0), ('2012-12-06', 71.0), ('2012-12-07', 72.0), ('2012-12-08', 76.0), ('2012-12-09', 75.0), ('2012-12-10', 75.0), ('2012-12-11', 76.0), ('2012-12-12', 73.0), ('2012-12-13', 72.0), ('2012-12-14', 74.0), ('2012-12-15', 74.0), ('2012-12-16', 74.0), ('2012-12-17', 73.0), ('2012-12-18', 77.0), ('2012-12-19', 73.0), ('2012-12-20', 70.0), ('2012-12-21', 72.0), ('2012-12-22', 76.0), ('2012-12-23', 65.0), ('2012-12-24', 74.0), ('2012-12-25', 73.0), ('2012-12-26', 77.0), ('2012-12-27', 76.0), ('2012-12-28', 69.0), ('2012-12-29', 78.0), ('2012-12-30', 76.0), ('2012-12-31', 68.0), ('2013-12-01', 76.0), ('2013-12-02', 68.0), ('2013-12-03', 79.0), ('2013-12-04', 69.0), ('2013-12-05', 64.0), ('2013-12-06', 70.0), ('2013-12-07', 69.0), ('2013-12-08', 73.0), ('2013-12-09', 70.0), ('2013-12-10', 74.0), ('2013-12-11', 76.0), ('2013-12-12', 76.0), ('2013-12-13', 69.0), ('2013-12-14', 73.0), ('2013-12-15', 73.0), ('2013-12-16', 65.0), ('2013-12-17', 70.0), ('2013-12-18', 72.0), ('2013-12-19', 72.0), ('2013-12-20', 75.0), ('2013-12-21', 74.0), ('2013-12-22', 69.0), ('2013-12-23', 73.0), ('2013-12-24', 75.0), ('2013-12-25', 76.0), ('2013-12-26', 74.0), ('2013-12-27', 73.0), ('2013-12-28', 74.0), ('2013-12-29', 71.0), ('2013-12-30', 72.0), ('2013-12-31', 73.0), ('2014-12-01', 72.0), ('2014-12-02', 72.0), ('2014-12-03', 73.0), ('2014-12-04', 72.0), ('2014-12-05', 75.0), ('2014-12-06', 76.0), ('2014-12-07', 67.0), ('2014-12-08', 69.0), ('2014-12-09', 70.0), ('2014-12-10', 75.0), ('2014-12-11', 74.0), ('2014-12-12', 71.0), ('2014-12-13', 74.0), ('2014-12-14', 71.0), ('2014-12-15', 72.0), ('2014-12-16', 74.0), ('2014-12-17', 75.0), ('2014-12-18', 73.0), ('2014-12-19', 75.0), ('2014-12-20', 76.0), ('2014-12-22', 68.0), ('2014-12-23', 71.0), ('2014-12-24', 68.0), ('2014-12-25', 66.0), ('2014-12-26', 63.0), ('2014-12-27', 62.0), ('2014-12-28', 67.0), ('2014-12-29', 68.0), ('2014-12-30', 63.0), ('2014-12-31', 56.0), ('2015-12-02', 76.0), ('2015-12-03', 75.0), ('2015-12-04', 74.0), ('2015-12-05', 76.0), ('2015-12-07', 69.0), ('2015-12-08', 71.0), ('2015-12-09', 72.0), ('2015-12-10', 74.0), ('2015-12-11', 75.0), ('2015-12-12', 72.0), ('2015-12-13', 78.0), ('2015-12-14', 69.0), ('2015-12-15', 75.0), ('2015-12-16', 75.0), ('2015-12-17', 74.0), ('2015-12-18', 74.0), ('2015-12-19', 76.0), ('2015-12-20', 73.0), ('2015-12-22', 75.0), ('2015-12-23', 75.0), ('2015-12-24', 74.0), ('2015-12-25', 79.0), ('2015-12-26', 75.0), ('2015-12-27', 76.0), ('2015-12-28', 76.0), ('2015-12-29', 69.0), ('2015-12-31', 72.0), ('2016-12-01', 76.0), ('2016-12-02', 75.0), ('2016-12-03', 75.0), ('2016-12-04', 75.0), ('2016-12-05', 70.0), ('2016-12-06', 70.0), ('2016-12-07', 74.0), ('2016-12-08', 73.0), ('2016-12-10', 72.0), ('2016-12-11', 78.0), ('2016-12-12', 67.0), ('2016-12-13', 69.0), ('2016-12-14', 71.0), ('2016-12-15', 74.0), ('2016-12-16', 63.0), ('2016-12-17', 76.0), ('2016-12-18', 76.0), ('2016-12-19', 71.0), ('2016-12-20', 76.0), ('2016-12-21', 77.0), ('2016-12-22', 73.0), ('2016-12-23', 71.0), ('2016-12-24', 78.0), ('2016-12-25', 78.0), ('2016-12-26', 75.0), ('2016-12-27', 75.0), ('2016-12-28', 72.0), ('2016-12-29', 77.0), ('2016-12-30', 72.0), ('2010-12-01', 72.0), ('2010-12-02', 71.0), ('2010-12-03', 72.0), ('2010-12-04', 74.0), ('2010-12-05', 66.0), ('2010-12-06', 61.0), ('2010-12-07', 58.0), ('2010-12-08', 60.0), ('2010-12-09', 71.0), ('2010-12-10', 65.0), ('2010-12-11', 72.0), ('2010-12-12', 70.0), ('2010-12-13', 68.0), ('2010-12-14', 67.0), ('2010-12-15', 71.0), ('2010-12-16', 65.0), ('2010-12-17', 64.0), ('2010-12-18', 65.0), ('2010-12-19', 69.0), ('2010-12-20', 70.0), ('2010-12-21', 70.0), ('2010-12-22', 68.0), ('2010-12-23', 69.0), ('2010-12-24', 71.0), ('2010-12-25', 70.0), ('2010-12-26', 71.0), ('2010-12-27', 76.0), ('2010-12-28', 71.0), ('2010-12-29', 72.0), ('2010-12-30', 73.0), ('2010-12-31', 77.0), ('2011-12-01', 67.0), ('2011-12-02', 69.0), ('2011-12-03', 72.0), ('2011-12-04', 74.0), ('2011-12-05', 71.0), ('2011-12-06', 70.0), ('2011-12-07', 68.0), ('2011-12-08', 70.0), ('2011-12-09', 66.0), ('2011-12-10', 72.0), ('2011-12-11', 70.0), ('2011-12-12', 70.0), ('2011-12-13', 70.0), ('2011-12-14', 70.0), ('2011-12-15', 73.0), ('2011-12-16', 71.0), ('2011-12-17', 69.0), ('2011-12-18', 73.0), ('2011-12-19', 72.0), ('2011-12-20', 71.0), ('2011-12-21', 69.0), ('2011-12-22', 70.0), ('2011-12-23', 69.0), ('2011-12-24', 70.0), ('2011-12-25', 75.0), ('2011-12-26', 71.0), ('2011-12-27', 70.0), ('2011-12-28', 69.0), ('2011-12-29', 71.0), ('2011-12-30', 65.0), ('2011-12-31', 67.0), ('2012-12-01', 72.0), ('2012-12-02', 67.0), ('2012-12-03', 76.0), ('2012-12-04', 67.0), ('2012-12-05', 72.0), ('2012-12-06', 69.0), ('2012-12-07', 66.0), ('2012-12-08', 75.0), ('2012-12-09', 74.0), ('2012-12-10', 72.0), ('2012-12-11', 72.0), ('2012-12-12', 72.0), ('2012-12-13', 68.0), ('2012-12-14', 74.0), ('2012-12-15', 73.0), ('2012-12-16', 73.0), ('2012-12-17', 72.0), ('2012-12-18', 70.0), ('2012-12-19', 70.0), ('2012-12-20', 71.0), ('2012-12-21', 70.0), ('2012-12-22', 72.0), ('2012-12-23', 65.0), ('2012-12-24', 62.0), ('2012-12-25', 73.0), ('2012-12-26', 71.0), ('2012-12-27', 70.0), ('2012-12-28', 62.0), ('2012-12-29', 69.0), ('2012-12-30', 69.0), ('2012-12-31', 66.0), ('2013-12-01', 72.0), ('2013-12-02', 73.0), ('2013-12-03', 70.0), ('2013-12-04', 66.0), ('2013-12-05', 64.0), ('2013-12-06', 65.0), ('2013-12-07', 73.0), ('2013-12-08', 74.0), ('2013-12-09', 67.0), ('2013-12-10', 73.0), ('2013-12-11', 70.0), ('2013-12-12', 67.0), ('2013-12-13', 71.0), ('2013-12-14', 78.0), ('2013-12-15', 69.0), ('2013-12-16', 63.0), ('2013-12-17', 64.0), ('2013-12-18', 66.0), ('2013-12-19', 69.0), ('2013-12-20', 69.0), ('2013-12-21', 71.0), ('2013-12-22', 72.0), ('2013-12-23', 69.0), ('2013-12-24', 70.0), ('2013-12-25', 73.0), ('2013-12-26', 68.0), ('2013-12-27', 69.0), ('2013-12-28', 73.0), ('2013-12-29', 73.0), ('2013-12-30', 70.0), ('2013-12-31', 65.0), ('2014-12-01', 70.0), ('2014-12-02', 68.0), ('2014-12-03', 68.0), ('2014-12-04', 66.0), ('2014-12-05', 68.0), ('2014-12-06', 65.0), ('2014-12-07', 62.0), ('2014-12-08', 62.0), ('2014-12-09', 65.0), ('2014-12-10', 61.0), ('2014-12-11', 70.0), ('2014-12-12', 68.0), ('2014-12-13', 67.0), ('2014-12-14', 68.0), ('2014-12-15', 71.0), ('2014-12-16', 69.0), ('2014-12-17', 71.0), ('2014-12-18', 71.0), ('2014-12-19', 71.0), ('2014-12-20', 72.0), ('2014-12-21', 72.0), ('2014-12-22', 68.0), ('2014-12-23', 69.0), ('2014-12-24', 66.0), ('2014-12-25', 60.0), ('2014-12-26', 63.0), ('2014-12-27', 68.0), ('2014-12-28', 64.0), ('2014-12-29', 63.0), ('2014-12-30', 63.0), ('2014-12-31', 59.0), ('2015-12-01', 73.0), ('2015-12-02', 74.0), ('2015-12-03', 75.0), ('2015-12-04', 75.0), ('2015-12-05', 70.0), ('2015-12-06', 72.0), ('2015-12-07', 69.0), ('2015-12-08', 68.0), ('2015-12-09', 74.0), ('2015-12-10', 72.0), ('2015-12-11', 75.0), ('2015-12-12', 79.0), ('2015-12-13', 69.0), ('2015-12-14', 67.0), ('2015-12-15', 73.0), ('2015-12-16', 74.0), ('2015-12-17', 75.0), ('2015-12-18', 72.0), ('2015-12-19', 76.0), ('2015-12-20', 74.0), ('2015-12-21', 75.0), ('2015-12-22', 74.0), ('2015-12-23', 74.0), ('2015-12-24', 76.0), ('2015-12-25', 74.0), ('2015-12-26', 75.0), ('2015-12-27', 75.0), ('2015-12-28', 73.0), ('2015-12-29', 76.0), ('2015-12-30', 74.0), ('2015-12-31', 73.0), ('2016-12-01', 74.0), ('2016-12-02', 70.0), ('2016-12-03', 72.0), ('2016-12-04', 70.0), ('2016-12-05', 67.0), ('2016-12-06', 67.0), ('2016-12-07', 69.0), ('2016-12-08', 70.0), ('2016-12-09', 68.0), ('2016-12-10', 69.0), ('2016-12-11', 69.0), ('2016-12-12', 66.0), ('2016-12-13', 65.0), ('2016-12-14', 68.0), ('2016-12-15', 62.0), ('2016-12-16', 75.0), ('2016-12-17', 70.0), ('2016-12-18', 69.0), ('2016-12-19', 76.0), ('2016-12-20', 76.0), ('2016-12-21', 74.0), ('2016-12-22', 73.0), ('2016-12-23', 71.0), ('2016-12-24', 74.0), ('2016-12-25', 74.0), ('2016-12-26', 72.0), ('2016-12-27', 71.0), ('2016-12-28', 72.0), ('2016-12-29', 74.0), ('2016-12-30', 69.0), ('2016-12-31', 67.0), ('2010-12-01', 70.0), ('2010-12-02', 74.0), ('2010-12-03', 74.0), ('2010-12-04', 75.0), ('2010-12-05', 69.0), ('2010-12-06', 65.0), ('2010-12-07', 66.0), ('2010-12-08', 68.0), ('2010-12-09', 77.0), ('2010-12-10', 65.0), ('2010-12-11', 72.0), ('2010-12-12', 65.0), ('2010-12-13', 66.0), ('2010-12-14', 74.0), ('2010-12-15', 66.0), ('2010-12-16', 63.0), ('2010-12-17', 63.0), ('2010-12-18', 69.0), ('2010-12-19', 69.0), ('2010-12-20', 73.0), ('2010-12-21', 72.0), ('2010-12-22', 68.0), ('2010-12-23', 67.0), ('2010-12-24', 69.0), ('2010-12-25', 74.0), ('2010-12-26', 72.0), ('2010-12-27', 76.0), ('2010-12-28', 70.0), ('2010-12-29', 73.0), ('2010-12-30', 70.0), ('2010-12-31', 76.0), ('2011-12-01', 66.0), ('2011-12-02', 69.0), ('2011-12-03', 69.0), ('2011-12-04', 70.0), ('2011-12-05', 71.0), ('2011-12-06', 73.0), ('2011-12-07', 65.0), ('2011-12-08', 71.0), ('2011-12-09', 65.0), ('2011-12-10', 75.0), ('2011-12-11', 72.0), ('2011-12-12', 74.0), ('2011-12-13', 67.0), ('2011-12-14', 65.0), ('2011-12-15', 68.0), ('2011-12-16', 66.0), ('2011-12-17', 73.0), ('2011-12-18', 74.0), ('2011-12-19', 76.0), ('2011-12-20', 72.0), ('2011-12-21', 69.0), ('2011-12-22', 71.0), ('2011-12-23', 70.0), ('2011-12-24', 70.0), ('2011-12-25', 73.0), ('2011-12-26', 71.0), ('2011-12-27', 76.0), ('2011-12-28', 72.0), ('2011-12-29', 77.0), ('2011-12-30', 70.0), ('2011-12-31', 65.0), ('2012-12-02', 72.0), ('2012-12-03', 75.0), ('2012-12-04', 68.0), ('2012-12-05', 72.0), ('2012-12-06', 64.0), ('2012-12-07', 75.0), ('2012-12-08', 69.0), ('2012-12-09', 80.0), ('2012-12-10', 73.0), ('2012-12-11', 73.0), ('2012-12-12', 73.0), ('2012-12-13', 72.0), ('2012-12-14', 73.0), ('2012-12-15', 75.0), ('2012-12-16', 76.0), ('2012-12-17', 74.0), ('2012-12-18', 72.0), ('2012-12-19', 72.0), ('2012-12-20', 70.0), ('2012-12-21', 70.0), ('2012-12-22', 71.0), ('2012-12-23', 61.0), ('2012-12-24', 65.0), ('2012-12-25', 74.0), ('2012-12-26', 71.0), ('2012-12-27', 63.0), ('2012-12-28', 64.0), ('2012-12-29', 66.0), ('2012-12-30', 68.0), ('2012-12-31', 66.0), ('2013-12-01', 70.0), ('2013-12-02', 68.0), ('2013-12-03', 68.0), ('2013-12-04', 66.0), ('2013-12-05', 75.0), ('2013-12-06', 67.0), ('2013-12-07', 70.0), ('2013-12-08', 72.0), ('2013-12-09', 69.0), ('2013-12-10', 72.0), ('2013-12-11', 69.0), ('2013-12-12', 65.0), ('2013-12-13', 71.0), ('2013-12-14', 73.0), ('2013-12-15', 69.0), ('2013-12-16', 69.0), ('2013-12-17', 63.0), ('2013-12-18', 63.0), ('2013-12-19', 71.0), ('2013-12-20', 79.0), ('2013-12-21', 67.0), ('2013-12-22', 67.0), ('2013-12-23', 64.0), ('2013-12-24', 63.0), ('2013-12-25', 68.0), ('2013-12-26', 77.0), ('2013-12-27', 79.0), ('2013-12-28', 74.0), ('2013-12-29', 68.0), ('2013-12-30', 64.0), ('2014-12-01', 70.0), ('2014-12-02', 62.0), ('2014-12-03', 68.0), ('2014-12-04', 67.0), ('2014-12-05', 70.0), ('2014-12-06', 66.0), ('2014-12-07', 64.0), ('2014-12-08', 62.0), ('2014-12-09', 64.0), ('2014-12-10', 63.0), ('2014-12-11', 69.0), ('2014-12-12', 64.0), ('2014-12-14', 70.0), ('2014-12-15', 72.0), ('2014-12-16', 72.0), ('2014-12-17', 64.0), ('2014-12-18', 71.0), ('2014-12-19', 68.0), ('2014-12-20', 81.0), ('2014-12-21', 78.0), ('2014-12-22', 69.0), ('2014-12-23', 72.0), ('2014-12-24', 70.0), ('2014-12-25', 62.0), ('2014-12-26', 76.0), ('2014-12-27', 72.0), ('2014-12-28', 76.0), ('2014-12-29', 57.0), ('2014-12-30', 64.0), ('2014-12-31', 57.0), ('2010-12-01', 71.0), ('2010-12-02', 70.0), ('2010-12-03', 67.0), ('2010-12-04', 77.0), ('2010-12-05', 69.0), ('2010-12-06', 61.0), ('2010-12-07', 62.0), ('2010-12-08', 63.0), ('2010-12-09', 73.0), ('2010-12-10', 64.0), ('2010-12-11', 67.0), ('2010-12-12', 69.0), ('2010-12-13', 80.0), ('2010-12-14', 71.0), ('2010-12-15', 73.0), ('2010-12-16', 65.0), ('2010-12-17', 68.0), ('2010-12-18', 68.0), ('2010-12-19', 69.0), ('2010-12-20', 72.0), ('2010-12-21', 69.0), ('2010-12-22', 69.0), ('2010-12-23', 67.0), ('2010-12-24', 69.0), ('2010-12-25', 73.0), ('2010-12-26', 71.0), ('2010-12-27', 71.0), ('2010-12-28', 70.0), ('2010-12-29', 71.0), ('2010-12-30', 70.0), ('2010-12-31', 75.0), ('2011-12-01', 71.0), ('2011-12-02', 73.0), ('2011-12-03', 71.0), ('2011-12-04', 71.0), ('2011-12-05', 68.0), ('2011-12-06', 67.0), ('2011-12-07', 70.0), ('2011-12-08', 67.0), ('2011-12-10', 69.0), ('2011-12-11', 71.0), ('2011-12-12', 69.0), ('2011-12-13', 69.0), ('2011-12-14', 68.0), ('2011-12-15', 69.0), ('2011-12-16', 69.0), ('2011-12-17', 67.0), ('2011-12-18', 69.0), ('2011-12-19', 68.0), ('2011-12-20', 70.0), ('2011-12-21', 68.0), ('2011-12-22', 69.0), ('2011-12-23', 71.0), ('2011-12-24', 65.0), ('2011-12-25', 69.0), ('2011-12-26', 69.0), ('2011-12-27', 69.0), ('2011-12-28', 69.0), ('2011-12-29', 70.0), ('2011-12-30', 73.0), ('2011-12-31', 67.0), ('2012-12-01', 74.0), ('2012-12-02', 77.0), ('2012-12-03', 74.0), ('2012-12-04', 73.0), ('2012-12-05', 71.0), ('2012-12-06', 73.0), ('2012-12-07', 68.0), ('2012-12-08', 69.0), ('2012-12-09', 71.0), ('2012-12-10', 72.0), ('2012-12-11', 72.0), ('2012-12-12', 67.0), ('2012-12-13', 67.0), ('2012-12-14', 69.0), ('2012-12-15', 66.0), ('2012-12-16', 66.0), ('2012-12-17', 69.0), ('2012-12-18', 66.0), ('2012-12-19', 68.0), ('2012-12-20', 65.0), ('2012-12-21', 68.0), ('2012-12-22', 67.0), ('2012-12-23', 71.0), ('2012-12-24', 65.0), ('2012-12-25', 71.0), ('2012-12-26', 69.0), ('2012-12-27', 69.0), ('2012-12-28', 62.0), ('2012-12-29', 62.0), ('2012-12-30', 67.0), ('2012-12-31', 65.0), ('2013-12-01', 68.0), ('2013-12-02', 67.0), ('2013-12-03', 75.0), ('2013-12-04', 68.0), ('2013-12-05', 68.0), ('2013-12-06', 70.0), ('2013-12-08', 83.0), ('2013-12-09', 68.0), ('2013-12-10', 70.0), ('2013-12-11', 70.0), ('2013-12-12', 68.0), ('2013-12-13', 76.0), ('2013-12-14', 72.0), ('2013-12-15', 68.0), ('2013-12-16', 64.0), ('2013-12-17', 72.0), ('2013-12-18', 72.0), ('2013-12-19', 68.0), ('2013-12-20', 70.0), ('2013-12-21', 69.0), ('2013-12-23', 68.0), ('2013-12-24', 70.0), ('2013-12-25', 67.0), ('2013-12-26', 70.0), ('2013-12-27', 70.0), ('2013-12-28', 71.0), ('2013-12-29', 70.0), ('2013-12-30', 69.0), ('2013-12-31', 71.0), ('2014-12-01', 68.0), ('2014-12-02', 70.0), ('2014-12-03', 67.0), ('2014-12-04', 70.0), ('2014-12-05', 73.0), ('2014-12-06', 70.0), ('2014-12-07', 66.0), ('2014-12-09', 70.0), ('2014-12-10', 72.0), ('2014-12-11', 71.0), ('2014-12-12', 68.0), ('2014-12-13', 71.0), ('2014-12-14', 67.0), ('2014-12-15', 65.0), ('2014-12-16', 66.0), ('2014-12-17', 70.0), ('2014-12-18', 69.0), ('2014-12-19', 70.0), ('2014-12-21', 72.0), ('2014-12-22', 67.0), ('2014-12-23', 68.0), ('2014-12-24', 64.0), ('2014-12-25', 66.0), ('2014-12-26', 65.0), ('2014-12-27', 62.0), ('2014-12-28', 68.0), ('2014-12-29', 67.0), ('2015-12-01', 73.0), ('2015-12-02', 70.0), ('2015-12-03', 71.0), ('2015-12-04', 71.0), ('2015-12-05', 70.0), ('2015-12-06', 71.0), ('2015-12-07', 69.0), ('2015-12-08', 70.0), ('2015-12-09', 73.0), ('2015-12-10', 70.0), ('2015-12-11', 72.0), ('2015-12-12', 71.0), ('2015-12-13', 69.0), ('2015-12-15', 74.0), ('2015-12-16', 73.0), ('2015-12-17', 69.0), ('2015-12-18', 71.0), ('2015-12-19', 68.0), ('2015-12-20', 72.0), ('2015-12-22', 71.0), ('2015-12-23', 70.0), ('2015-12-24', 72.0), ('2015-12-25', 71.0), ('2015-12-26', 69.0), ('2015-12-27', 71.0), ('2015-12-29', 67.0), ('2015-12-30', 71.0), ('2015-12-31', 69.0), ('2016-12-01', 71.0), ('2016-12-02', 71.0), ('2016-12-03', 67.0), ('2016-12-04', 76.0), ('2016-12-05', 67.0), ('2016-12-06', 67.0), ('2016-12-07', 68.0), ('2016-12-08', 71.0), ('2016-12-09', 68.0), ('2016-12-10', 68.0), ('2016-12-11', 69.0), ('2016-12-12', 65.0), ('2016-12-13', 70.0), ('2016-12-14', 69.0), ('2016-12-15', 64.0), ('2016-12-16', 60.0), ('2016-12-18', 67.0), ('2016-12-19', 72.0), ('2016-12-20', 73.0), ('2016-12-21', 70.0), ('2016-12-22', 68.0), ('2016-12-23', 69.0), ('2016-12-24', 69.0), ('2016-12-25', 69.0), ('2016-12-26', 71.0), ('2016-12-27', 71.0), ('2016-12-28', 71.0), ('2016-12-29', 69.0), ('2016-12-30', 65.0), ('2016-12-31', 65.0)]\n"
     ]
    }
   ],
   "source": [
    "# 7. Convert the December temperatures to a list.\n",
    "month_of_Dec = session.query(Measurement.date, Measurement.tobs).\\\n",
    "    filter(extract('month', Measurement.date)==12).all()\n",
    "print(month_of_Dec)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 8. Create a DataFrame from the list of temperatures for the month of December. \n",
    "# set the index to the date column\n",
    "df = pd.DataFrame(month_of_Dec, columns=['date', 'Dec Temps'])\n",
    "df.set_index(df['date'], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Dec Temps</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1517.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>71.041529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.745920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>56.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>69.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>71.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>74.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>83.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Dec Temps\n",
       "count  1517.000000\n",
       "mean     71.041529\n",
       "std       3.745920\n",
       "min      56.000000\n",
       "25%      69.000000\n",
       "50%      71.000000\n",
       "75%      74.000000\n",
       "max      83.000000"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 9. Calculate and print out the summary statistics for the Decemeber temperature DataFrame.\n",
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "PythonData",
   "language": "python",
   "name": "pythondata"
  },
  "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.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}