gap_fill_precipitation_forcing.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import datetime\n",
    "dt = datetime.timedelta(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "#newRegions = ['01','02','03','04','05','06','13','14','15','16','18','20','21'] # 17 removed b/c still processing\n",
    "newRegions = ['17']\n",
    "files = []\n",
    "for reg in newRegions:\n",
    "    files.append('./data/hru_%s_stage_4_precip.pcl'%reg)"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "files = glob.glob('./data/hru_*_stage_4_precip.pcl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['./data/hru_17_stage_4_precip.pcl']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def interp_convert(fl,compress=False):\n",
    "    dat = pd.read_pickle(fl)\n",
    "    \n",
    "    # generate lists of dates\n",
    "    strt = str(dat.index[0])\n",
    "    nd = str(dat.index[-1])\n",
    "\n",
    "    dates = []\n",
    "    [dates.append(str(date)) for date in pd.date_range(strt,nd,freq='D')]\n",
    "\n",
    "    dsDates = []\n",
    "    [dsDates.append(str(date)) for date in dat.index]\n",
    "    \n",
    "    missing = list(set(dates) - set(dsDates)) # compute the difference between the two lists\n",
    "    \n",
    "    if len(missing) == 0:\n",
    "        print('Dates match, no interpolation needed')\n",
    "    else:\n",
    "        print('Dates missing, interpolation needed')\n",
    "\n",
    "        for date in missing: # iterate through the missing dates\n",
    "            print(date)\n",
    "            # find the dates before and after the missing date\n",
    "            year = int(date.split(' ')[-2].split('-')[0])\n",
    "            month = int(date.split(' ')[-2].split('-')[1])\n",
    "            day = int(date.split(' ')[-2].split('-')[2])\n",
    "            date = datetime.date(year,month,day)\n",
    "            before = date - dt\n",
    "            after = date + dt\n",
    "\n",
    "\n",
    "            out = pd.DataFrame()\n",
    "            out['datetime'] = [date]\n",
    "            out['year'] = year\n",
    "            out['month'] = month\n",
    "            out['day'] = day\n",
    "            out['hour'] = 0\n",
    "            out['minute'] = 0\n",
    "            out['second'] = 0\n",
    "\n",
    "\n",
    "            for hru in dat.columns[6:]:\n",
    "                out[hru] =((dat.loc[dat.index==str(before),hru].as_matrix() + dat.loc[dat.index==str(after),hru].as_matrix()) / 2.)[0]\n",
    "\n",
    "            out.index = pd.DatetimeIndex(out.datetime)\n",
    "            del out['datetime']\n",
    "            dat = dat.append(out)\n",
    "\n",
    "    dat.sort_index(inplace=True)\n",
    "    dat.interpolate(limit=5,inplace=True)\n",
    "\n",
    "    # convert the values to inches\n",
    "    region = fl.split('_')[1] # extract the region from the file name\n",
    "    #if region != '12': # 12 is already in inches...\n",
    "    #    print('Converting mm to inches')\n",
    "    #    for hru in dat.columns[6:]:\n",
    "    #        dat[hru] *= 0.0393701 # mm to inches!!!\n",
    "\n",
    "    dat.to_pickle('./data/hru_%s_stage_4_precip_interp_inches.pcl'%region)\n",
    "    dat.to_csv('./data/hru_%s_stage_4_precip_interp_inches.cbh'%region, sep = ' ',na_rep='-999',float_format='%.4f',header=False)\n",
    "    if compress: dat.to_csv('./data/hru_%s_stage_4_precip_interp_inches.cbh.bz2'%region, sep = ' ',na_rep='-999',float_format='%.4f',\n",
    "               header=False,compression='bz2')\n",
    "    print('Region: %s complete'%region)\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dates missing, interpolation needed\n",
      "2008-11-02 00:00:00\n",
      "2012-10-01 00:00:00\n",
      "Region: 17 complete\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[None]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[interp_convert(fl,compress=True) for fl in files]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# export the data frames as new forcing files:\n",
    "files = glob.glob('./data/hru_*_stage_4_precip_interp_inches.pcl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def export_cbh(fl):\n",
    "    region = fl.split('_')[1]\n",
    "    print('Processing Region: %s'%region)\n",
    "    dat = pd.read_pickle(fl)\n",
    "    dat.to_csv('./data/hru_%s_stage_4_precip_interp_inches.cbh'%region,sep=' ',index=False,header=False,float_format='%.4f')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Processing Region: 07\n",
      "Processing Region: 08\n",
      "Processing Region: 09\n",
      "Processing Region: 10L\n",
      "Processing Region: 10U\n",
      "Processing Region: 11\n",
      "Processing Region: 12\n"
     ]
    }
   ],
   "source": [
    "for fl in files:\n",
    "    export_cbh(fl)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>hru_1</th>\n",
       "      <th>hru_2</th>\n",
       "      <th>hru_3</th>\n",
       "      <th>hru_4</th>\n",
       "      <th>...</th>\n",
       "      <th>hru_8196</th>\n",
       "      <th>hru_8197</th>\n",
       "      <th>hru_8198</th>\n",
       "      <th>hru_8199</th>\n",
       "      <th>hru_8200</th>\n",
       "      <th>hru_8201</th>\n",
       "      <th>hru_8202</th>\n",
       "      <th>hru_8203</th>\n",
       "      <th>hru_8204</th>\n",
       "      <th>hru_8205</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2004-12-20</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-21</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-22</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.030779</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.160426</td>\n",
       "      <td>...</td>\n",
       "      <td>8.34631</td>\n",
       "      <td>8.708111</td>\n",
       "      <td>9.731642</td>\n",
       "      <td>9.566482</td>\n",
       "      <td>2.483852</td>\n",
       "      <td>2.367854</td>\n",
       "      <td>6.98103</td>\n",
       "      <td>5.275792</td>\n",
       "      <td>2.472068</td>\n",
       "      <td>2.887732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-23</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.291635</td>\n",
       "      <td>3.337007</td>\n",
       "      <td>4.584321</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-24</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 8211 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            year  month  day  hour  minute  second  hru_1     hru_2     hru_3  \\\n",
       "datetime                                                                        \n",
       "2004-12-20  2004     12   20     0       0       0    0.0  0.000000  0.000000   \n",
       "2004-12-21  2004     12   21     0       0       0    0.0  0.000000  0.000000   \n",
       "2004-12-22  2004     12   22     0       0       0    0.0  0.030779  0.000000   \n",
       "2004-12-23  2004     12   23     0       0       0    0.0  4.291635  3.337007   \n",
       "2004-12-24  2004     12   24     0       0       0    0.0  0.000000  0.000000   \n",
       "\n",
       "               hru_4    ...     hru_8196  hru_8197  hru_8198  hru_8199  \\\n",
       "datetime                ...                                              \n",
       "2004-12-20  0.000000    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "2004-12-21  0.000000    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "2004-12-22  0.160426    ...      8.34631  8.708111  9.731642  9.566482   \n",
       "2004-12-23  4.584321    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "2004-12-24  0.000000    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "\n",
       "            hru_8200  hru_8201  hru_8202  hru_8203  hru_8204  hru_8205  \n",
       "datetime                                                                \n",
       "2004-12-20  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "2004-12-21  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "2004-12-22  2.483852  2.367854   6.98103  5.275792  2.472068  2.887732  \n",
       "2004-12-23  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "2004-12-24  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "\n",
       "[5 rows x 8211 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>hru_1</th>\n",
       "      <th>hru_2</th>\n",
       "      <th>hru_3</th>\n",
       "      <th>hru_4</th>\n",
       "      <th>...</th>\n",
       "      <th>hru_8196</th>\n",
       "      <th>hru_8197</th>\n",
       "      <th>hru_8198</th>\n",
       "      <th>hru_8199</th>\n",
       "      <th>hru_8200</th>\n",
       "      <th>hru_8201</th>\n",
       "      <th>hru_8202</th>\n",
       "      <th>hru_8203</th>\n",
       "      <th>hru_8204</th>\n",
       "      <th>hru_8205</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2015-01-03</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10.524005</td>\n",
       "      <td>15.240544</td>\n",
       "      <td>14.692121</td>\n",
       "      <td>15.025848</td>\n",
       "      <td>...</td>\n",
       "      <td>20.794635</td>\n",
       "      <td>20.938213</td>\n",
       "      <td>20.242687</td>\n",
       "      <td>19.595702</td>\n",
       "      <td>13.147538</td>\n",
       "      <td>13.659655</td>\n",
       "      <td>12.358628</td>\n",
       "      <td>12.419685</td>\n",
       "      <td>17.806062</td>\n",
       "      <td>15.797369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-04</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.845967</td>\n",
       "      <td>0.477940</td>\n",
       "      <td>0.596432</td>\n",
       "      <td>0.372863</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-05</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.677320</td>\n",
       "      <td>0.118776</td>\n",
       "      <td>0.140070</td>\n",
       "      <td>0.121935</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-06</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.652099</td>\n",
       "      <td>2.371195</td>\n",
       "      <td>2.350720</td>\n",
       "      <td>2.391178</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-07</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.005035</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 8211 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            year  month  day  hour  minute  second      hru_1      hru_2  \\\n",
       "datetime                                                                   \n",
       "2015-01-03  2015      1    3     0       0       0  10.524005  15.240544   \n",
       "2015-01-04  2015      1    4     0       0       0   2.845967   0.477940   \n",
       "2015-01-05  2015      1    5     0       0       0   0.677320   0.118776   \n",
       "2015-01-06  2015      1    6     0       0       0   3.652099   2.371195   \n",
       "2015-01-07  2015      1    7     0       0       0   0.750000   0.000000   \n",
       "\n",
       "                hru_3      hru_4    ...       hru_8196   hru_8197   hru_8198  \\\n",
       "datetime                            ...                                        \n",
       "2015-01-03  14.692121  15.025848    ...      20.794635  20.938213  20.242687   \n",
       "2015-01-04   0.596432   0.372863    ...       0.000000   0.000000   0.000000   \n",
       "2015-01-05   0.140070   0.121935    ...       0.000000   0.000000   0.000000   \n",
       "2015-01-06   2.350720   2.391178    ...       0.000000   0.000000   0.000000   \n",
       "2015-01-07   0.005035   0.000000    ...       0.000000   0.000000   0.000000   \n",
       "\n",
       "             hru_8199   hru_8200   hru_8201   hru_8202   hru_8203   hru_8204  \\\n",
       "datetime                                                                       \n",
       "2015-01-03  19.595702  13.147538  13.659655  12.358628  12.419685  17.806062   \n",
       "2015-01-04   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "2015-01-05   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "2015-01-06   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "2015-01-07   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "\n",
       "             hru_8205  \n",
       "datetime               \n",
       "2015-01-03  15.797369  \n",
       "2015-01-04   0.000000  \n",
       "2015-01-05   0.000000  \n",
       "2015-01-06   0.000000  \n",
       "2015-01-07   0.000000  \n",
       "\n",
       "[5 rows x 8211 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>hru_1</th>\n",
       "      <th>hru_2</th>\n",
       "      <th>hru_3</th>\n",
       "      <th>hru_4</th>\n",
       "      <th>...</th>\n",
       "      <th>hru_8196</th>\n",
       "      <th>hru_8197</th>\n",
       "      <th>hru_8198</th>\n",
       "      <th>hru_8199</th>\n",
       "      <th>hru_8200</th>\n",
       "      <th>hru_8201</th>\n",
       "      <th>hru_8202</th>\n",
       "      <th>hru_8203</th>\n",
       "      <th>hru_8204</th>\n",
       "      <th>hru_8205</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2012-09-30</th>\n",
       "      <td>2012</td>\n",
       "      <td>9</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>26.831316</td>\n",
       "      <td>25.40707</td>\n",
       "      <td>11.75609</td>\n",
       "      <td>11.214021</td>\n",
       "      <td>2.766403</td>\n",
       "      <td>2.800153</td>\n",
       "      <td>4.946539</td>\n",
       "      <td>3.362403</td>\n",
       "      <td>3.806132</td>\n",
       "      <td>4.025229</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 8211 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            year  month  day  hour  minute  second  hru_1  hru_2  hru_3  \\\n",
       "datetime                                                                  \n",
       "2012-09-30  2012      9   30     0       0       0    0.0    0.0    0.0   \n",
       "\n",
       "            hru_4    ...      hru_8196  hru_8197  hru_8198   hru_8199  \\\n",
       "datetime             ...                                                \n",
       "2012-09-30    0.0    ...     26.831316  25.40707  11.75609  11.214021   \n",
       "\n",
       "            hru_8200  hru_8201  hru_8202  hru_8203  hru_8204  hru_8205  \n",
       "datetime                                                                \n",
       "2012-09-30  2.766403  2.800153  4.946539  3.362403  3.806132  4.025229  \n",
       "\n",
       "[1 rows x 8211 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "before"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'hru_1'"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.loc[]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2012-10-01 00:00:00', '2008-11-02 00:00:00']"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "missing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Lengths do not match, interpolation needed\n"
     ]
    }
   ],
   "source": [
    "if n == m:\n",
    "    print('Lengths match, no interpolation needed')\n",
    "elif n != m:\n",
    "    print('Lengths do not match, interpolation needed')\n",
    "    \n",
    "\n",
    "    #missing = []    \n",
    "    #for date in dates: # iterate through dates in the data set\n",
    "    #    if str(date) in dsDates == False:\n",
    "    #        missing.append(str(date))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "missing = list(set(dates) - set(dsDates))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "d = missing[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "datetime.date(2012, 10, 1)"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "year = int(d.split(' ')[-2].split('-')[0])\n",
    "month = int(d.split(' ')[-2].split('-')[1])\n",
    "day = int(d.split(' ')[-2].split('-')[2])\n",
    "datetime.date(year,month,day)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2012-10-01 00:00:00'"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "missing[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "an integer is required (got type str)",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-85-6866f01d232b>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mdatetime\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdate\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mmissing\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m: an integer is required (got type str)"
     ]
    }
   ],
   "source": [
    "datetime.date(missing[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3671"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(dates)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['2004-12-20 00:00:00',\n",
       " '2004-12-21 00:00:00',\n",
       " '2004-12-22 00:00:00',\n",
       " '2004-12-23 00:00:00',\n",
       " '2004-12-24 00:00:00',\n",
       " '2004-12-25 00:00:00',\n",
       " '2004-12-26 00:00:00',\n",
       " '2004-12-27 00:00:00',\n",
       " '2004-12-28 00:00:00',\n",
       " '2004-12-29 00:00:00',\n",
       " '2004-12-30 00:00:00',\n",
       " '2004-12-31 00:00:00',\n",
       " '2005-01-01 00:00:00',\n",
       " '2005-01-02 00:00:00',\n",
       " '2005-01-03 00:00:00',\n",
       " '2005-01-04 00:00:00',\n",
       " '2005-01-05 00:00:00',\n",
       " '2005-01-06 00:00:00',\n",
       " '2005-01-07 00:00:00',\n",
       " '2005-01-08 00:00:00',\n",
       " '2005-01-09 00:00:00',\n",
       " '2005-01-10 00:00:00',\n",
       " '2005-01-11 00:00:00',\n",
       " '2005-01-12 00:00:00',\n",
       " '2005-01-13 00:00:00',\n",
       " '2005-01-14 00:00:00',\n",
       " '2005-01-15 00:00:00',\n",
       " '2005-01-16 00:00:00',\n",
       " '2005-01-17 00:00:00',\n",
       " '2005-01-18 00:00:00',\n",
       " '2005-01-19 00:00:00',\n",
       " '2005-01-20 00:00:00',\n",
       " '2005-01-21 00:00:00',\n",
       " '2005-01-22 00:00:00',\n",
       " '2005-01-23 00:00:00',\n",
       " '2005-01-24 00:00:00',\n",
       " '2005-01-25 00:00:00',\n",
       " '2005-01-26 00:00:00',\n",
       " '2005-01-27 00:00:00',\n",
       " '2005-01-28 00:00:00',\n",
       " '2005-01-29 00:00:00',\n",
       " '2005-01-30 00:00:00',\n",
       " '2005-01-31 00:00:00',\n",
       " '2005-02-01 00:00:00',\n",
       " '2005-02-02 00:00:00',\n",
       " '2005-02-03 00:00:00',\n",
       " '2005-02-04 00:00:00',\n",
       " '2005-02-05 00:00:00',\n",
       " '2005-02-06 00:00:00',\n",
       " '2005-02-07 00:00:00',\n",
       " '2005-02-08 00:00:00',\n",
       " '2005-02-09 00:00:00',\n",
       " '2005-02-10 00:00:00',\n",
       " '2005-02-11 00:00:00',\n",
       " '2005-02-12 00:00:00',\n",
       " '2005-02-13 00:00:00',\n",
       " '2005-02-14 00:00:00',\n",
       " '2005-02-15 00:00:00',\n",
       " '2005-02-16 00:00:00',\n",
       " '2005-02-17 00:00:00',\n",
       " '2005-02-18 00:00:00',\n",
       " '2005-02-19 00:00:00',\n",
       " '2005-02-20 00:00:00',\n",
       " '2005-02-21 00:00:00',\n",
       " '2005-02-22 00:00:00',\n",
       " '2005-02-23 00:00:00',\n",
       " '2005-02-24 00:00:00',\n",
       " '2005-02-25 00:00:00',\n",
       " '2005-02-26 00:00:00',\n",
       " '2005-02-27 00:00:00',\n",
       " '2005-02-28 00:00:00',\n",
       " '2005-03-01 00:00:00',\n",
       " '2005-03-02 00:00:00',\n",
       " '2005-03-03 00:00:00',\n",
       " '2005-03-04 00:00:00',\n",
       " '2005-03-05 00:00:00',\n",
       " '2005-03-06 00:00:00',\n",
       " '2005-03-07 00:00:00',\n",
       " '2005-03-08 00:00:00',\n",
       " '2005-03-09 00:00:00',\n",
       " '2005-03-10 00:00:00',\n",
       " '2005-03-11 00:00:00',\n",
       " '2005-03-12 00:00:00',\n",
       " '2005-03-13 00:00:00',\n",
       " '2005-03-14 00:00:00',\n",
       " '2005-03-15 00:00:00',\n",
       " '2005-03-16 00:00:00',\n",
       " '2005-03-17 00:00:00',\n",
       " '2005-03-18 00:00:00',\n",
       " '2005-03-19 00:00:00',\n",
       " '2005-03-20 00:00:00',\n",
       " '2005-03-21 00:00:00',\n",
       " '2005-03-22 00:00:00',\n",
       " '2005-03-23 00:00:00',\n",
       " '2005-03-24 00:00:00',\n",
       " '2005-03-25 00:00:00',\n",
       " '2005-03-26 00:00:00',\n",
       " '2005-03-27 00:00:00',\n",
       " '2005-03-28 00:00:00',\n",
       " '2005-03-29 00:00:00',\n",
       " '2005-03-30 00:00:00',\n",
       " '2005-03-31 00:00:00',\n",
       " '2005-04-01 00:00:00',\n",
       " '2005-04-02 00:00:00',\n",
       " '2005-04-03 00:00:00',\n",
       " '2005-04-04 00:00:00',\n",
       " '2005-04-05 00:00:00',\n",
       " '2005-04-06 00:00:00',\n",
       " '2005-04-07 00:00:00',\n",
       " '2005-04-08 00:00:00',\n",
       " '2005-04-09 00:00:00',\n",
       " '2005-04-10 00:00:00',\n",
       " '2005-04-11 00:00:00',\n",
       " '2005-04-12 00:00:00',\n",
       " '2005-04-13 00:00:00',\n",
       " '2005-04-14 00:00:00',\n",
       " '2005-04-15 00:00:00',\n",
       " '2005-04-16 00:00:00',\n",
       " '2005-04-17 00:00:00',\n",
       " '2005-04-18 00:00:00',\n",
       " '2005-04-19 00:00:00',\n",
       " '2005-04-20 00:00:00',\n",
       " '2005-04-21 00:00:00',\n",
       " '2005-04-22 00:00:00',\n",
       " '2005-04-23 00:00:00',\n",
       " '2005-04-24 00:00:00',\n",
       " '2005-04-25 00:00:00',\n",
       " '2005-04-26 00:00:00',\n",
       " '2005-04-27 00:00:00',\n",
       " '2005-04-28 00:00:00',\n",
       " '2005-04-29 00:00:00',\n",
       " '2005-04-30 00:00:00',\n",
       " '2005-05-01 00:00:00',\n",
       " '2005-05-02 00:00:00',\n",
       " '2005-05-03 00:00:00',\n",
       " '2005-05-04 00:00:00',\n",
       " '2005-05-05 00:00:00',\n",
       " '2005-05-06 00:00:00',\n",
       " '2005-05-07 00:00:00',\n",
       " '2005-05-08 00:00:00',\n",
       " '2005-05-09 00:00:00',\n",
       " '2005-05-10 00:00:00',\n",
       " '2005-05-11 00:00:00',\n",
       " '2005-05-12 00:00:00',\n",
       " '2005-05-13 00:00:00',\n",
       " '2005-05-14 00:00:00',\n",
       " '2005-05-15 00:00:00',\n",
       " '2005-05-16 00:00:00',\n",
       " '2005-05-17 00:00:00',\n",
       " '2005-05-18 00:00:00',\n",
       " '2005-05-19 00:00:00',\n",
       " '2005-05-20 00:00:00',\n",
       " '2005-05-21 00:00:00',\n",
       " '2005-05-22 00:00:00',\n",
       " '2005-05-23 00:00:00',\n",
       " '2005-05-24 00:00:00',\n",
       " '2005-05-25 00:00:00',\n",
       " '2005-05-26 00:00:00',\n",
       " '2005-05-27 00:00:00',\n",
       " '2005-05-28 00:00:00',\n",
       " '2005-05-29 00:00:00',\n",
       " '2005-05-30 00:00:00',\n",
       " '2005-05-31 00:00:00',\n",
       " '2005-06-01 00:00:00',\n",
       " '2005-06-02 00:00:00',\n",
       " '2005-06-03 00:00:00',\n",
       " '2005-06-04 00:00:00',\n",
       " '2005-06-05 00:00:00',\n",
       " '2005-06-06 00:00:00',\n",
       " '2005-06-07 00:00:00',\n",
       " '2005-06-08 00:00:00',\n",
       " '2005-06-09 00:00:00',\n",
       " '2005-06-10 00:00:00',\n",
       " '2005-06-11 00:00:00',\n",
       " '2005-06-12 00:00:00',\n",
       " '2005-06-13 00:00:00',\n",
       " '2005-06-14 00:00:00',\n",
       " '2005-06-15 00:00:00',\n",
       " '2005-06-16 00:00:00',\n",
       " '2005-06-17 00:00:00',\n",
       " '2005-06-18 00:00:00',\n",
       " '2005-06-19 00:00:00',\n",
       " '2005-06-20 00:00:00',\n",
       " '2005-06-21 00:00:00',\n",
       " '2005-06-22 00:00:00',\n",
       " '2005-06-23 00:00:00',\n",
       " '2005-06-24 00:00:00',\n",
       " '2005-06-25 00:00:00',\n",
       " '2005-06-26 00:00:00',\n",
       " '2005-06-27 00:00:00',\n",
       " '2005-06-28 00:00:00',\n",
       " '2005-06-29 00:00:00',\n",
       " '2005-06-30 00:00:00',\n",
       " '2005-07-01 00:00:00',\n",
       " '2005-07-02 00:00:00',\n",
       " '2005-07-03 00:00:00',\n",
       " '2005-07-04 00:00:00',\n",
       " '2005-07-05 00:00:00',\n",
       " '2005-07-06 00:00:00',\n",
       " '2005-07-07 00:00:00',\n",
       " '2005-07-08 00:00:00',\n",
       " '2005-07-09 00:00:00',\n",
       " '2005-07-10 00:00:00',\n",
       " '2005-07-11 00:00:00',\n",
       " '2005-07-12 00:00:00',\n",
       " '2005-07-13 00:00:00',\n",
       " '2005-07-14 00:00:00',\n",
       " '2005-07-15 00:00:00',\n",
       " '2005-07-16 00:00:00',\n",
       " '2005-07-17 00:00:00',\n",
       " '2005-07-18 00:00:00',\n",
       " '2005-07-19 00:00:00',\n",
       " '2005-07-20 00:00:00',\n",
       " '2005-07-21 00:00:00',\n",
       " '2005-07-22 00:00:00',\n",
       " '2005-07-23 00:00:00',\n",
       " '2005-07-24 00:00:00',\n",
       " '2005-07-25 00:00:00',\n",
       " '2005-07-26 00:00:00',\n",
       " '2005-07-27 00:00:00',\n",
       " '2005-07-28 00:00:00',\n",
       " '2005-07-29 00:00:00',\n",
       " '2005-07-30 00:00:00',\n",
       " '2005-07-31 00:00:00',\n",
       " '2005-08-01 00:00:00',\n",
       " '2005-08-02 00:00:00',\n",
       " '2005-08-03 00:00:00',\n",
       " '2005-08-04 00:00:00',\n",
       " '2005-08-05 00:00:00',\n",
       " '2005-08-06 00:00:00',\n",
       " '2005-08-07 00:00:00',\n",
       " '2005-08-08 00:00:00',\n",
       " '2005-08-09 00:00:00',\n",
       " '2005-08-10 00:00:00',\n",
       " '2005-08-11 00:00:00',\n",
       " '2005-08-12 00:00:00',\n",
       " '2005-08-13 00:00:00',\n",
       " '2005-08-14 00:00:00',\n",
       " '2005-08-15 00:00:00',\n",
       " '2005-08-16 00:00:00',\n",
       " '2005-08-17 00:00:00',\n",
       " '2005-08-18 00:00:00',\n",
       " '2005-08-19 00:00:00',\n",
       " '2005-08-20 00:00:00',\n",
       " '2005-08-21 00:00:00',\n",
       " '2005-08-22 00:00:00',\n",
       " '2005-08-23 00:00:00',\n",
       " '2005-08-24 00:00:00',\n",
       " '2005-08-25 00:00:00',\n",
       " '2005-08-26 00:00:00',\n",
       " '2005-08-27 00:00:00',\n",
       " '2005-08-28 00:00:00',\n",
       " '2005-08-29 00:00:00',\n",
       " '2005-08-30 00:00:00',\n",
       " '2005-08-31 00:00:00',\n",
       " '2005-09-01 00:00:00',\n",
       " '2005-09-02 00:00:00',\n",
       " '2005-09-03 00:00:00',\n",
       " '2005-09-04 00:00:00',\n",
       " '2005-09-05 00:00:00',\n",
       " '2005-09-06 00:00:00',\n",
       " '2005-09-07 00:00:00',\n",
       " '2005-09-08 00:00:00',\n",
       " '2005-09-09 00:00:00',\n",
       " '2005-09-10 00:00:00',\n",
       " '2005-09-11 00:00:00',\n",
       " '2005-09-12 00:00:00',\n",
       " '2005-09-13 00:00:00',\n",
       " '2005-09-14 00:00:00',\n",
       " '2005-09-15 00:00:00',\n",
       " '2005-09-16 00:00:00',\n",
       " '2005-09-17 00:00:00',\n",
       " '2005-09-18 00:00:00',\n",
       " '2005-09-19 00:00:00',\n",
       " '2005-09-20 00:00:00',\n",
       " '2005-09-21 00:00:00',\n",
       " '2005-09-22 00:00:00',\n",
       " '2005-09-23 00:00:00',\n",
       " '2005-09-24 00:00:00',\n",
       " '2005-09-25 00:00:00',\n",
       " '2005-09-26 00:00:00',\n",
       " '2005-09-27 00:00:00',\n",
       " '2005-09-28 00:00:00',\n",
       " '2005-09-29 00:00:00',\n",
       " '2005-09-30 00:00:00',\n",
       " '2005-10-01 00:00:00',\n",
       " '2005-10-02 00:00:00',\n",
       " '2005-10-03 00:00:00',\n",
       " '2005-10-04 00:00:00',\n",
       " '2005-10-05 00:00:00',\n",
       " '2005-10-06 00:00:00',\n",
       " '2005-10-07 00:00:00',\n",
       " '2005-10-08 00:00:00',\n",
       " '2005-10-09 00:00:00',\n",
       " '2005-10-10 00:00:00',\n",
       " '2005-10-11 00:00:00',\n",
       " '2005-10-12 00:00:00',\n",
       " '2005-10-13 00:00:00',\n",
       " '2005-10-14 00:00:00',\n",
       " '2005-10-15 00:00:00',\n",
       " '2005-10-16 00:00:00',\n",
       " '2005-10-17 00:00:00',\n",
       " '2005-10-18 00:00:00',\n",
       " '2005-10-19 00:00:00',\n",
       " '2005-10-20 00:00:00',\n",
       " '2005-10-21 00:00:00',\n",
       " '2005-10-22 00:00:00',\n",
       " '2005-10-23 00:00:00',\n",
       " '2005-10-24 00:00:00',\n",
       " '2005-10-25 00:00:00',\n",
       " '2005-10-26 00:00:00',\n",
       " '2005-10-27 00:00:00',\n",
       " '2005-10-28 00:00:00',\n",
       " '2005-10-29 00:00:00',\n",
       " '2005-10-30 00:00:00',\n",
       " '2005-10-31 00:00:00',\n",
       " '2005-11-01 00:00:00',\n",
       " '2005-11-02 00:00:00',\n",
       " '2005-11-03 00:00:00',\n",
       " '2005-11-04 00:00:00',\n",
       " '2005-11-05 00:00:00',\n",
       " '2005-11-06 00:00:00',\n",
       " '2005-11-07 00:00:00',\n",
       " '2005-11-08 00:00:00',\n",
       " '2005-11-09 00:00:00',\n",
       " '2005-11-10 00:00:00',\n",
       " '2005-11-11 00:00:00',\n",
       " '2005-11-12 00:00:00',\n",
       " '2005-11-13 00:00:00',\n",
       " '2005-11-14 00:00:00',\n",
       " '2005-11-15 00:00:00',\n",
       " '2005-11-16 00:00:00',\n",
       " '2005-11-17 00:00:00',\n",
       " '2005-11-18 00:00:00',\n",
       " '2005-11-19 00:00:00',\n",
       " '2005-11-20 00:00:00',\n",
       " '2005-11-21 00:00:00',\n",
       " '2005-11-22 00:00:00',\n",
       " '2005-11-23 00:00:00',\n",
       " '2005-11-24 00:00:00',\n",
       " '2005-11-25 00:00:00',\n",
       " '2005-11-26 00:00:00',\n",
       " '2005-11-27 00:00:00',\n",
       " '2005-11-28 00:00:00',\n",
       " '2005-11-29 00:00:00',\n",
       " '2005-11-30 00:00:00',\n",
       " '2005-12-01 00:00:00',\n",
       " '2005-12-02 00:00:00',\n",
       " '2005-12-03 00:00:00',\n",
       " '2005-12-04 00:00:00',\n",
       " '2005-12-05 00:00:00',\n",
       " '2005-12-06 00:00:00',\n",
       " '2005-12-07 00:00:00',\n",
       " '2005-12-08 00:00:00',\n",
       " '2005-12-09 00:00:00',\n",
       " '2005-12-10 00:00:00',\n",
       " '2005-12-11 00:00:00',\n",
       " '2005-12-12 00:00:00',\n",
       " '2005-12-13 00:00:00',\n",
       " '2005-12-14 00:00:00',\n",
       " '2005-12-15 00:00:00',\n",
       " '2005-12-16 00:00:00',\n",
       " '2005-12-17 00:00:00',\n",
       " '2005-12-18 00:00:00',\n",
       " '2005-12-19 00:00:00',\n",
       " '2005-12-20 00:00:00',\n",
       " '2005-12-21 00:00:00',\n",
       " '2005-12-22 00:00:00',\n",
       " '2005-12-23 00:00:00',\n",
       " '2005-12-24 00:00:00',\n",
       " '2005-12-25 00:00:00',\n",
       " '2005-12-26 00:00:00',\n",
       " '2005-12-27 00:00:00',\n",
       " '2005-12-28 00:00:00',\n",
       " '2005-12-29 00:00:00',\n",
       " '2005-12-30 00:00:00',\n",
       " '2005-12-31 00:00:00',\n",
       " '2006-01-01 00:00:00',\n",
       " '2006-01-02 00:00:00',\n",
       " '2006-01-03 00:00:00',\n",
       " '2006-01-04 00:00:00',\n",
       " '2006-01-05 00:00:00',\n",
       " '2006-01-06 00:00:00',\n",
       " '2006-01-07 00:00:00',\n",
       " '2006-01-08 00:00:00',\n",
       " '2006-01-09 00:00:00',\n",
       " '2006-01-10 00:00:00',\n",
       " '2006-01-11 00:00:00',\n",
       " '2006-01-12 00:00:00',\n",
       " '2006-01-13 00:00:00',\n",
       " '2006-01-14 00:00:00',\n",
       " '2006-01-15 00:00:00',\n",
       " '2006-01-16 00:00:00',\n",
       " '2006-01-17 00:00:00',\n",
       " '2006-01-18 00:00:00',\n",
       " '2006-01-19 00:00:00',\n",
       " '2006-01-20 00:00:00',\n",
       " '2006-01-21 00:00:00',\n",
       " '2006-01-22 00:00:00',\n",
       " '2006-01-23 00:00:00',\n",
       " '2006-01-24 00:00:00',\n",
       " '2006-01-25 00:00:00',\n",
       " '2006-01-26 00:00:00',\n",
       " '2006-01-27 00:00:00',\n",
       " '2006-01-28 00:00:00',\n",
       " '2006-01-29 00:00:00',\n",
       " '2006-01-30 00:00:00',\n",
       " '2006-01-31 00:00:00',\n",
       " '2006-02-01 00:00:00',\n",
       " '2006-02-02 00:00:00',\n",
       " '2006-02-03 00:00:00',\n",
       " '2006-02-04 00:00:00',\n",
       " '2006-02-05 00:00:00',\n",
       " '2006-02-06 00:00:00',\n",
       " '2006-02-07 00:00:00',\n",
       " '2006-02-08 00:00:00',\n",
       " '2006-02-09 00:00:00',\n",
       " '2006-02-10 00:00:00',\n",
       " '2006-02-11 00:00:00',\n",
       " '2006-02-12 00:00:00',\n",
       " '2006-02-13 00:00:00',\n",
       " '2006-02-14 00:00:00',\n",
       " '2006-02-15 00:00:00',\n",
       " '2006-02-16 00:00:00',\n",
       " '2006-02-17 00:00:00',\n",
       " '2006-02-18 00:00:00',\n",
       " '2006-02-19 00:00:00',\n",
       " '2006-02-20 00:00:00',\n",
       " '2006-02-21 00:00:00',\n",
       " '2006-02-22 00:00:00',\n",
       " '2006-02-23 00:00:00',\n",
       " '2006-02-24 00:00:00',\n",
       " '2006-02-25 00:00:00',\n",
       " '2006-02-26 00:00:00',\n",
       " '2006-02-27 00:00:00',\n",
       " '2006-02-28 00:00:00',\n",
       " '2006-03-01 00:00:00',\n",
       " '2006-03-02 00:00:00',\n",
       " '2006-03-03 00:00:00',\n",
       " '2006-03-04 00:00:00',\n",
       " '2006-03-05 00:00:00',\n",
       " '2006-03-06 00:00:00',\n",
       " '2006-03-07 00:00:00',\n",
       " '2006-03-08 00:00:00',\n",
       " '2006-03-09 00:00:00',\n",
       " '2006-03-10 00:00:00',\n",
       " '2006-03-11 00:00:00',\n",
       " '2006-03-12 00:00:00',\n",
       " '2006-03-13 00:00:00',\n",
       " '2006-03-14 00:00:00',\n",
       " '2006-03-15 00:00:00',\n",
       " '2006-03-16 00:00:00',\n",
       " '2006-03-17 00:00:00',\n",
       " '2006-03-18 00:00:00',\n",
       " '2006-03-19 00:00:00',\n",
       " '2006-03-20 00:00:00',\n",
       " '2006-03-21 00:00:00',\n",
       " '2006-03-22 00:00:00',\n",
       " '2006-03-23 00:00:00',\n",
       " '2006-03-24 00:00:00',\n",
       " '2006-03-25 00:00:00',\n",
       " '2006-03-26 00:00:00',\n",
       " '2006-03-27 00:00:00',\n",
       " '2006-03-28 00:00:00',\n",
       " '2006-03-29 00:00:00',\n",
       " '2006-03-30 00:00:00',\n",
       " '2006-03-31 00:00:00',\n",
       " '2006-04-01 00:00:00',\n",
       " '2006-04-02 00:00:00',\n",
       " '2006-04-03 00:00:00',\n",
       " '2006-04-04 00:00:00',\n",
       " '2006-04-05 00:00:00',\n",
       " '2006-04-06 00:00:00',\n",
       " '2006-04-07 00:00:00',\n",
       " '2006-04-08 00:00:00',\n",
       " '2006-04-09 00:00:00',\n",
       " '2006-04-10 00:00:00',\n",
       " '2006-04-11 00:00:00',\n",
       " '2006-04-12 00:00:00',\n",
       " '2006-04-13 00:00:00',\n",
       " '2006-04-14 00:00:00',\n",
       " '2006-04-15 00:00:00',\n",
       " '2006-04-16 00:00:00',\n",
       " '2006-04-17 00:00:00',\n",
       " '2006-04-18 00:00:00',\n",
       " '2006-04-19 00:00:00',\n",
       " '2006-04-20 00:00:00',\n",
       " '2006-04-21 00:00:00',\n",
       " '2006-04-22 00:00:00',\n",
       " '2006-04-23 00:00:00',\n",
       " '2006-04-24 00:00:00',\n",
       " '2006-04-25 00:00:00',\n",
       " '2006-04-26 00:00:00',\n",
       " '2006-04-27 00:00:00',\n",
       " '2006-04-28 00:00:00',\n",
       " '2006-04-29 00:00:00',\n",
       " '2006-04-30 00:00:00',\n",
       " '2006-05-01 00:00:00',\n",
       " '2006-05-02 00:00:00',\n",
       " '2006-05-03 00:00:00',\n",
       " '2006-05-04 00:00:00',\n",
       " '2006-05-05 00:00:00',\n",
       " '2006-05-06 00:00:00',\n",
       " '2006-05-07 00:00:00',\n",
       " '2006-05-08 00:00:00',\n",
       " '2006-05-09 00:00:00',\n",
       " '2006-05-10 00:00:00',\n",
       " '2006-05-11 00:00:00',\n",
       " '2006-05-12 00:00:00',\n",
       " '2006-05-13 00:00:00',\n",
       " '2006-05-14 00:00:00',\n",
       " '2006-05-15 00:00:00',\n",
       " '2006-05-16 00:00:00',\n",
       " '2006-05-17 00:00:00',\n",
       " '2006-05-18 00:00:00',\n",
       " '2006-05-19 00:00:00',\n",
       " '2006-05-20 00:00:00',\n",
       " '2006-05-21 00:00:00',\n",
       " '2006-05-22 00:00:00',\n",
       " '2006-05-23 00:00:00',\n",
       " '2006-05-24 00:00:00',\n",
       " '2006-05-25 00:00:00',\n",
       " '2006-05-26 00:00:00',\n",
       " '2006-05-27 00:00:00',\n",
       " '2006-05-28 00:00:00',\n",
       " '2006-05-29 00:00:00',\n",
       " '2006-05-30 00:00:00',\n",
       " '2006-05-31 00:00:00',\n",
       " '2006-06-01 00:00:00',\n",
       " '2006-06-02 00:00:00',\n",
       " '2006-06-03 00:00:00',\n",
       " '2006-06-04 00:00:00',\n",
       " '2006-06-05 00:00:00',\n",
       " '2006-06-06 00:00:00',\n",
       " '2006-06-07 00:00:00',\n",
       " '2006-06-08 00:00:00',\n",
       " '2006-06-09 00:00:00',\n",
       " '2006-06-10 00:00:00',\n",
       " '2006-06-11 00:00:00',\n",
       " '2006-06-12 00:00:00',\n",
       " '2006-06-13 00:00:00',\n",
       " '2006-06-14 00:00:00',\n",
       " '2006-06-15 00:00:00',\n",
       " '2006-06-16 00:00:00',\n",
       " '2006-06-17 00:00:00',\n",
       " '2006-06-18 00:00:00',\n",
       " '2006-06-19 00:00:00',\n",
       " '2006-06-20 00:00:00',\n",
       " '2006-06-21 00:00:00',\n",
       " '2006-06-22 00:00:00',\n",
       " '2006-06-23 00:00:00',\n",
       " '2006-06-24 00:00:00',\n",
       " '2006-06-25 00:00:00',\n",
       " '2006-06-26 00:00:00',\n",
       " '2006-06-27 00:00:00',\n",
       " '2006-06-28 00:00:00',\n",
       " '2006-06-29 00:00:00',\n",
       " '2006-06-30 00:00:00',\n",
       " '2006-07-01 00:00:00',\n",
       " '2006-07-02 00:00:00',\n",
       " '2006-07-03 00:00:00',\n",
       " '2006-07-04 00:00:00',\n",
       " '2006-07-05 00:00:00',\n",
       " '2006-07-06 00:00:00',\n",
       " '2006-07-07 00:00:00',\n",
       " '2006-07-08 00:00:00',\n",
       " '2006-07-09 00:00:00',\n",
       " '2006-07-10 00:00:00',\n",
       " '2006-07-11 00:00:00',\n",
       " '2006-07-12 00:00:00',\n",
       " '2006-07-13 00:00:00',\n",
       " '2006-07-14 00:00:00',\n",
       " '2006-07-15 00:00:00',\n",
       " '2006-07-16 00:00:00',\n",
       " '2006-07-17 00:00:00',\n",
       " '2006-07-18 00:00:00',\n",
       " '2006-07-19 00:00:00',\n",
       " '2006-07-20 00:00:00',\n",
       " '2006-07-21 00:00:00',\n",
       " '2006-07-22 00:00:00',\n",
       " '2006-07-23 00:00:00',\n",
       " '2006-07-24 00:00:00',\n",
       " '2006-07-25 00:00:00',\n",
       " '2006-07-26 00:00:00',\n",
       " '2006-07-27 00:00:00',\n",
       " '2006-07-28 00:00:00',\n",
       " '2006-07-29 00:00:00',\n",
       " '2006-07-30 00:00:00',\n",
       " '2006-07-31 00:00:00',\n",
       " '2006-08-01 00:00:00',\n",
       " '2006-08-02 00:00:00',\n",
       " '2006-08-03 00:00:00',\n",
       " '2006-08-04 00:00:00',\n",
       " '2006-08-05 00:00:00',\n",
       " '2006-08-06 00:00:00',\n",
       " '2006-08-07 00:00:00',\n",
       " '2006-08-08 00:00:00',\n",
       " '2006-08-09 00:00:00',\n",
       " '2006-08-10 00:00:00',\n",
       " '2006-08-11 00:00:00',\n",
       " '2006-08-12 00:00:00',\n",
       " '2006-08-13 00:00:00',\n",
       " '2006-08-14 00:00:00',\n",
       " '2006-08-15 00:00:00',\n",
       " '2006-08-16 00:00:00',\n",
       " '2006-08-17 00:00:00',\n",
       " '2006-08-18 00:00:00',\n",
       " '2006-08-19 00:00:00',\n",
       " '2006-08-20 00:00:00',\n",
       " '2006-08-21 00:00:00',\n",
       " '2006-08-22 00:00:00',\n",
       " '2006-08-23 00:00:00',\n",
       " '2006-08-24 00:00:00',\n",
       " '2006-08-25 00:00:00',\n",
       " '2006-08-26 00:00:00',\n",
       " '2006-08-27 00:00:00',\n",
       " '2006-08-28 00:00:00',\n",
       " '2006-08-29 00:00:00',\n",
       " '2006-08-30 00:00:00',\n",
       " '2006-08-31 00:00:00',\n",
       " '2006-09-01 00:00:00',\n",
       " '2006-09-02 00:00:00',\n",
       " '2006-09-03 00:00:00',\n",
       " '2006-09-04 00:00:00',\n",
       " '2006-09-05 00:00:00',\n",
       " '2006-09-06 00:00:00',\n",
       " '2006-09-07 00:00:00',\n",
       " '2006-09-08 00:00:00',\n",
       " '2006-09-09 00:00:00',\n",
       " '2006-09-10 00:00:00',\n",
       " '2006-09-11 00:00:00',\n",
       " '2006-09-12 00:00:00',\n",
       " '2006-09-13 00:00:00',\n",
       " '2006-09-14 00:00:00',\n",
       " '2006-09-15 00:00:00',\n",
       " '2006-09-16 00:00:00',\n",
       " '2006-09-17 00:00:00',\n",
       " '2006-09-18 00:00:00',\n",
       " '2006-09-19 00:00:00',\n",
       " '2006-09-20 00:00:00',\n",
       " '2006-09-21 00:00:00',\n",
       " '2006-09-22 00:00:00',\n",
       " '2006-09-23 00:00:00',\n",
       " '2006-09-24 00:00:00',\n",
       " '2006-09-25 00:00:00',\n",
       " '2006-09-26 00:00:00',\n",
       " '2006-09-27 00:00:00',\n",
       " '2006-09-28 00:00:00',\n",
       " '2006-09-29 00:00:00',\n",
       " '2006-09-30 00:00:00',\n",
       " '2006-10-01 00:00:00',\n",
       " '2006-10-02 00:00:00',\n",
       " '2006-10-03 00:00:00',\n",
       " '2006-10-04 00:00:00',\n",
       " '2006-10-05 00:00:00',\n",
       " '2006-10-06 00:00:00',\n",
       " '2006-10-07 00:00:00',\n",
       " '2006-10-08 00:00:00',\n",
       " '2006-10-09 00:00:00',\n",
       " '2006-10-10 00:00:00',\n",
       " '2006-10-11 00:00:00',\n",
       " '2006-10-12 00:00:00',\n",
       " '2006-10-13 00:00:00',\n",
       " '2006-10-14 00:00:00',\n",
       " '2006-10-15 00:00:00',\n",
       " '2006-10-16 00:00:00',\n",
       " '2006-10-17 00:00:00',\n",
       " '2006-10-18 00:00:00',\n",
       " '2006-10-19 00:00:00',\n",
       " '2006-10-20 00:00:00',\n",
       " '2006-10-21 00:00:00',\n",
       " '2006-10-22 00:00:00',\n",
       " '2006-10-23 00:00:00',\n",
       " '2006-10-24 00:00:00',\n",
       " '2006-10-25 00:00:00',\n",
       " '2006-10-26 00:00:00',\n",
       " '2006-10-27 00:00:00',\n",
       " '2006-10-28 00:00:00',\n",
       " '2006-10-29 00:00:00',\n",
       " '2006-10-30 00:00:00',\n",
       " '2006-10-31 00:00:00',\n",
       " '2006-11-01 00:00:00',\n",
       " '2006-11-02 00:00:00',\n",
       " '2006-11-03 00:00:00',\n",
       " '2006-11-04 00:00:00',\n",
       " '2006-11-05 00:00:00',\n",
       " '2006-11-06 00:00:00',\n",
       " '2006-11-07 00:00:00',\n",
       " '2006-11-08 00:00:00',\n",
       " '2006-11-09 00:00:00',\n",
       " '2006-11-10 00:00:00',\n",
       " '2006-11-11 00:00:00',\n",
       " '2006-11-12 00:00:00',\n",
       " '2006-11-13 00:00:00',\n",
       " '2006-11-14 00:00:00',\n",
       " '2006-11-15 00:00:00',\n",
       " '2006-11-16 00:00:00',\n",
       " '2006-11-17 00:00:00',\n",
       " '2006-11-18 00:00:00',\n",
       " '2006-11-19 00:00:00',\n",
       " '2006-11-20 00:00:00',\n",
       " '2006-11-21 00:00:00',\n",
       " '2006-11-22 00:00:00',\n",
       " '2006-11-23 00:00:00',\n",
       " '2006-11-24 00:00:00',\n",
       " '2006-11-25 00:00:00',\n",
       " '2006-11-26 00:00:00',\n",
       " '2006-11-27 00:00:00',\n",
       " '2006-11-28 00:00:00',\n",
       " '2006-11-29 00:00:00',\n",
       " '2006-11-30 00:00:00',\n",
       " '2006-12-01 00:00:00',\n",
       " '2006-12-02 00:00:00',\n",
       " '2006-12-03 00:00:00',\n",
       " '2006-12-04 00:00:00',\n",
       " '2006-12-05 00:00:00',\n",
       " '2006-12-06 00:00:00',\n",
       " '2006-12-07 00:00:00',\n",
       " '2006-12-08 00:00:00',\n",
       " '2006-12-09 00:00:00',\n",
       " '2006-12-10 00:00:00',\n",
       " '2006-12-11 00:00:00',\n",
       " '2006-12-12 00:00:00',\n",
       " '2006-12-13 00:00:00',\n",
       " '2006-12-14 00:00:00',\n",
       " '2006-12-15 00:00:00',\n",
       " '2006-12-16 00:00:00',\n",
       " '2006-12-17 00:00:00',\n",
       " '2006-12-18 00:00:00',\n",
       " '2006-12-19 00:00:00',\n",
       " '2006-12-20 00:00:00',\n",
       " '2006-12-21 00:00:00',\n",
       " '2006-12-22 00:00:00',\n",
       " '2006-12-23 00:00:00',\n",
       " '2006-12-24 00:00:00',\n",
       " '2006-12-25 00:00:00',\n",
       " '2006-12-26 00:00:00',\n",
       " '2006-12-27 00:00:00',\n",
       " '2006-12-28 00:00:00',\n",
       " '2006-12-29 00:00:00',\n",
       " '2006-12-30 00:00:00',\n",
       " '2006-12-31 00:00:00',\n",
       " '2007-01-01 00:00:00',\n",
       " '2007-01-02 00:00:00',\n",
       " '2007-01-03 00:00:00',\n",
       " '2007-01-04 00:00:00',\n",
       " '2007-01-05 00:00:00',\n",
       " '2007-01-06 00:00:00',\n",
       " '2007-01-07 00:00:00',\n",
       " '2007-01-08 00:00:00',\n",
       " '2007-01-09 00:00:00',\n",
       " '2007-01-10 00:00:00',\n",
       " '2007-01-11 00:00:00',\n",
       " '2007-01-12 00:00:00',\n",
       " '2007-01-13 00:00:00',\n",
       " '2007-01-14 00:00:00',\n",
       " '2007-01-15 00:00:00',\n",
       " '2007-01-16 00:00:00',\n",
       " '2007-01-17 00:00:00',\n",
       " '2007-01-18 00:00:00',\n",
       " '2007-01-19 00:00:00',\n",
       " '2007-01-20 00:00:00',\n",
       " '2007-01-21 00:00:00',\n",
       " '2007-01-22 00:00:00',\n",
       " '2007-01-23 00:00:00',\n",
       " '2007-01-24 00:00:00',\n",
       " '2007-01-25 00:00:00',\n",
       " '2007-01-26 00:00:00',\n",
       " '2007-01-27 00:00:00',\n",
       " '2007-01-28 00:00:00',\n",
       " '2007-01-29 00:00:00',\n",
       " '2007-01-30 00:00:00',\n",
       " '2007-01-31 00:00:00',\n",
       " '2007-02-01 00:00:00',\n",
       " '2007-02-02 00:00:00',\n",
       " '2007-02-03 00:00:00',\n",
       " '2007-02-04 00:00:00',\n",
       " '2007-02-05 00:00:00',\n",
       " '2007-02-06 00:00:00',\n",
       " '2007-02-07 00:00:00',\n",
       " '2007-02-08 00:00:00',\n",
       " '2007-02-09 00:00:00',\n",
       " '2007-02-10 00:00:00',\n",
       " '2007-02-11 00:00:00',\n",
       " '2007-02-12 00:00:00',\n",
       " '2007-02-13 00:00:00',\n",
       " '2007-02-14 00:00:00',\n",
       " '2007-02-15 00:00:00',\n",
       " '2007-02-16 00:00:00',\n",
       " '2007-02-17 00:00:00',\n",
       " '2007-02-18 00:00:00',\n",
       " '2007-02-19 00:00:00',\n",
       " '2007-02-20 00:00:00',\n",
       " '2007-02-21 00:00:00',\n",
       " '2007-02-22 00:00:00',\n",
       " '2007-02-23 00:00:00',\n",
       " '2007-02-24 00:00:00',\n",
       " '2007-02-25 00:00:00',\n",
       " '2007-02-26 00:00:00',\n",
       " '2007-02-27 00:00:00',\n",
       " '2007-02-28 00:00:00',\n",
       " '2007-03-01 00:00:00',\n",
       " '2007-03-02 00:00:00',\n",
       " '2007-03-03 00:00:00',\n",
       " '2007-03-04 00:00:00',\n",
       " '2007-03-05 00:00:00',\n",
       " '2007-03-06 00:00:00',\n",
       " '2007-03-07 00:00:00',\n",
       " '2007-03-08 00:00:00',\n",
       " '2007-03-09 00:00:00',\n",
       " '2007-03-10 00:00:00',\n",
       " '2007-03-11 00:00:00',\n",
       " '2007-03-12 00:00:00',\n",
       " '2007-03-13 00:00:00',\n",
       " '2007-03-14 00:00:00',\n",
       " '2007-03-15 00:00:00',\n",
       " '2007-03-16 00:00:00',\n",
       " '2007-03-17 00:00:00',\n",
       " '2007-03-18 00:00:00',\n",
       " '2007-03-19 00:00:00',\n",
       " '2007-03-20 00:00:00',\n",
       " '2007-03-21 00:00:00',\n",
       " '2007-03-22 00:00:00',\n",
       " '2007-03-23 00:00:00',\n",
       " '2007-03-24 00:00:00',\n",
       " '2007-03-25 00:00:00',\n",
       " '2007-03-26 00:00:00',\n",
       " '2007-03-27 00:00:00',\n",
       " '2007-03-28 00:00:00',\n",
       " '2007-03-29 00:00:00',\n",
       " '2007-03-30 00:00:00',\n",
       " '2007-03-31 00:00:00',\n",
       " '2007-04-01 00:00:00',\n",
       " '2007-04-02 00:00:00',\n",
       " '2007-04-03 00:00:00',\n",
       " '2007-04-04 00:00:00',\n",
       " '2007-04-05 00:00:00',\n",
       " '2007-04-06 00:00:00',\n",
       " '2007-04-07 00:00:00',\n",
       " '2007-04-08 00:00:00',\n",
       " '2007-04-09 00:00:00',\n",
       " '2007-04-10 00:00:00',\n",
       " '2007-04-11 00:00:00',\n",
       " '2007-04-12 00:00:00',\n",
       " '2007-04-13 00:00:00',\n",
       " '2007-04-14 00:00:00',\n",
       " '2007-04-15 00:00:00',\n",
       " '2007-04-16 00:00:00',\n",
       " '2007-04-17 00:00:00',\n",
       " '2007-04-18 00:00:00',\n",
       " '2007-04-19 00:00:00',\n",
       " '2007-04-20 00:00:00',\n",
       " '2007-04-21 00:00:00',\n",
       " '2007-04-22 00:00:00',\n",
       " '2007-04-23 00:00:00',\n",
       " '2007-04-24 00:00:00',\n",
       " '2007-04-25 00:00:00',\n",
       " '2007-04-26 00:00:00',\n",
       " '2007-04-27 00:00:00',\n",
       " '2007-04-28 00:00:00',\n",
       " '2007-04-29 00:00:00',\n",
       " '2007-04-30 00:00:00',\n",
       " '2007-05-01 00:00:00',\n",
       " '2007-05-02 00:00:00',\n",
       " '2007-05-03 00:00:00',\n",
       " '2007-05-04 00:00:00',\n",
       " '2007-05-05 00:00:00',\n",
       " '2007-05-06 00:00:00',\n",
       " '2007-05-07 00:00:00',\n",
       " '2007-05-08 00:00:00',\n",
       " '2007-05-09 00:00:00',\n",
       " '2007-05-10 00:00:00',\n",
       " '2007-05-11 00:00:00',\n",
       " '2007-05-12 00:00:00',\n",
       " '2007-05-13 00:00:00',\n",
       " '2007-05-14 00:00:00',\n",
       " '2007-05-15 00:00:00',\n",
       " '2007-05-16 00:00:00',\n",
       " '2007-05-17 00:00:00',\n",
       " '2007-05-18 00:00:00',\n",
       " '2007-05-19 00:00:00',\n",
       " '2007-05-20 00:00:00',\n",
       " '2007-05-21 00:00:00',\n",
       " '2007-05-22 00:00:00',\n",
       " '2007-05-23 00:00:00',\n",
       " '2007-05-24 00:00:00',\n",
       " '2007-05-25 00:00:00',\n",
       " '2007-05-26 00:00:00',\n",
       " '2007-05-27 00:00:00',\n",
       " '2007-05-28 00:00:00',\n",
       " '2007-05-29 00:00:00',\n",
       " '2007-05-30 00:00:00',\n",
       " '2007-05-31 00:00:00',\n",
       " '2007-06-01 00:00:00',\n",
       " '2007-06-02 00:00:00',\n",
       " '2007-06-03 00:00:00',\n",
       " '2007-06-04 00:00:00',\n",
       " '2007-06-05 00:00:00',\n",
       " '2007-06-06 00:00:00',\n",
       " '2007-06-07 00:00:00',\n",
       " '2007-06-08 00:00:00',\n",
       " '2007-06-09 00:00:00',\n",
       " '2007-06-10 00:00:00',\n",
       " '2007-06-11 00:00:00',\n",
       " '2007-06-12 00:00:00',\n",
       " '2007-06-13 00:00:00',\n",
       " '2007-06-14 00:00:00',\n",
       " '2007-06-15 00:00:00',\n",
       " '2007-06-16 00:00:00',\n",
       " '2007-06-17 00:00:00',\n",
       " '2007-06-18 00:00:00',\n",
       " '2007-06-19 00:00:00',\n",
       " '2007-06-20 00:00:00',\n",
       " '2007-06-21 00:00:00',\n",
       " '2007-06-22 00:00:00',\n",
       " '2007-06-23 00:00:00',\n",
       " '2007-06-24 00:00:00',\n",
       " '2007-06-25 00:00:00',\n",
       " '2007-06-26 00:00:00',\n",
       " '2007-06-27 00:00:00',\n",
       " '2007-06-28 00:00:00',\n",
       " '2007-06-29 00:00:00',\n",
       " '2007-06-30 00:00:00',\n",
       " '2007-07-01 00:00:00',\n",
       " '2007-07-02 00:00:00',\n",
       " '2007-07-03 00:00:00',\n",
       " '2007-07-04 00:00:00',\n",
       " '2007-07-05 00:00:00',\n",
       " '2007-07-06 00:00:00',\n",
       " '2007-07-07 00:00:00',\n",
       " '2007-07-08 00:00:00',\n",
       " '2007-07-09 00:00:00',\n",
       " '2007-07-10 00:00:00',\n",
       " '2007-07-11 00:00:00',\n",
       " '2007-07-12 00:00:00',\n",
       " '2007-07-13 00:00:00',\n",
       " '2007-07-14 00:00:00',\n",
       " '2007-07-15 00:00:00',\n",
       " '2007-07-16 00:00:00',\n",
       " '2007-07-17 00:00:00',\n",
       " '2007-07-18 00:00:00',\n",
       " '2007-07-19 00:00:00',\n",
       " '2007-07-20 00:00:00',\n",
       " '2007-07-21 00:00:00',\n",
       " '2007-07-22 00:00:00',\n",
       " '2007-07-23 00:00:00',\n",
       " '2007-07-24 00:00:00',\n",
       " '2007-07-25 00:00:00',\n",
       " '2007-07-26 00:00:00',\n",
       " '2007-07-27 00:00:00',\n",
       " '2007-07-28 00:00:00',\n",
       " '2007-07-29 00:00:00',\n",
       " '2007-07-30 00:00:00',\n",
       " '2007-07-31 00:00:00',\n",
       " '2007-08-01 00:00:00',\n",
       " '2007-08-02 00:00:00',\n",
       " '2007-08-03 00:00:00',\n",
       " '2007-08-04 00:00:00',\n",
       " '2007-08-05 00:00:00',\n",
       " '2007-08-06 00:00:00',\n",
       " '2007-08-07 00:00:00',\n",
       " '2007-08-08 00:00:00',\n",
       " '2007-08-09 00:00:00',\n",
       " '2007-08-10 00:00:00',\n",
       " '2007-08-11 00:00:00',\n",
       " '2007-08-12 00:00:00',\n",
       " '2007-08-13 00:00:00',\n",
       " '2007-08-14 00:00:00',\n",
       " '2007-08-15 00:00:00',\n",
       " '2007-08-16 00:00:00',\n",
       " '2007-08-17 00:00:00',\n",
       " '2007-08-18 00:00:00',\n",
       " '2007-08-19 00:00:00',\n",
       " '2007-08-20 00:00:00',\n",
       " '2007-08-21 00:00:00',\n",
       " '2007-08-22 00:00:00',\n",
       " '2007-08-23 00:00:00',\n",
       " '2007-08-24 00:00:00',\n",
       " '2007-08-25 00:00:00',\n",
       " '2007-08-26 00:00:00',\n",
       " '2007-08-27 00:00:00',\n",
       " '2007-08-28 00:00:00',\n",
       " '2007-08-29 00:00:00',\n",
       " '2007-08-30 00:00:00',\n",
       " '2007-08-31 00:00:00',\n",
       " '2007-09-01 00:00:00',\n",
       " '2007-09-02 00:00:00',\n",
       " '2007-09-03 00:00:00',\n",
       " '2007-09-04 00:00:00',\n",
       " '2007-09-05 00:00:00',\n",
       " '2007-09-06 00:00:00',\n",
       " '2007-09-07 00:00:00',\n",
       " '2007-09-08 00:00:00',\n",
       " '2007-09-09 00:00:00',\n",
       " '2007-09-10 00:00:00',\n",
       " '2007-09-11 00:00:00',\n",
       " '2007-09-12 00:00:00',\n",
       " '2007-09-13 00:00:00',\n",
       " '2007-09-14 00:00:00',\n",
       " '2007-09-15 00:00:00',\n",
       " ...]"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dsDates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[Timestamp('2004-12-20 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-21 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-22 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-23 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-24 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-25 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-26 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-27 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-28 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-29 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-30 00:00:00', freq='D'),\n",
       " Timestamp('2004-12-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-01-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-02-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-03-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-04-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-05-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-06-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-07-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-08-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-09-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-10-31 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-11-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-01 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-02 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-03 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-04 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-05 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-06 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-07 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-08 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-09 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-10 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-11 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-12 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-13 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-14 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-15 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-16 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-17 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-18 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-19 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-20 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-21 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-22 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-23 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-24 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-25 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-26 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-27 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-28 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-29 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-30 00:00:00', freq='D'),\n",
       " Timestamp('2005-12-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-01-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-02-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-03-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-04-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-05-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-06-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-07-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-08-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-09-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-10-31 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-11-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-01 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-02 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-03 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-04 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-05 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-06 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-07 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-08 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-09 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-10 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-11 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-12 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-13 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-14 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-15 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-16 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-17 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-18 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-19 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-20 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-21 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-22 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-23 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-24 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-25 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-26 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-27 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-28 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-29 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-30 00:00:00', freq='D'),\n",
       " Timestamp('2006-12-31 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-01-31 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-02-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-03-31 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-04-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-05-31 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-06-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-07-31 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-15 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-16 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-17 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-18 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-19 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-20 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-21 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-22 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-23 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-24 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-25 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-26 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-27 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-28 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-29 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-30 00:00:00', freq='D'),\n",
       " Timestamp('2007-08-31 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-01 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-02 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-03 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-04 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-05 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-06 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-07 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-08 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-09 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-10 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-11 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-12 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-13 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-14 00:00:00', freq='D'),\n",
       " Timestamp('2007-09-15 00:00:00', freq='D'),\n",
       " ...]"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "dates=dsDates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "str(date) in dsDates"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2004-12-20 00:00:00'"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "str(dates[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2015-01-07 00:00:00'"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "str(date)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>hru_1</th>\n",
       "      <th>hru_2</th>\n",
       "      <th>hru_3</th>\n",
       "      <th>hru_4</th>\n",
       "      <th>...</th>\n",
       "      <th>hru_8196</th>\n",
       "      <th>hru_8197</th>\n",
       "      <th>hru_8198</th>\n",
       "      <th>hru_8199</th>\n",
       "      <th>hru_8200</th>\n",
       "      <th>hru_8201</th>\n",
       "      <th>hru_8202</th>\n",
       "      <th>hru_8203</th>\n",
       "      <th>hru_8204</th>\n",
       "      <th>hru_8205</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2004-12-20</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-21</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-22</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.030779</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.160426</td>\n",
       "      <td>...</td>\n",
       "      <td>8.34631</td>\n",
       "      <td>8.708111</td>\n",
       "      <td>9.731642</td>\n",
       "      <td>9.566482</td>\n",
       "      <td>2.483852</td>\n",
       "      <td>2.367854</td>\n",
       "      <td>6.98103</td>\n",
       "      <td>5.275792</td>\n",
       "      <td>2.472068</td>\n",
       "      <td>2.887732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-23</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.291635</td>\n",
       "      <td>3.337007</td>\n",
       "      <td>4.584321</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004-12-24</th>\n",
       "      <td>2004</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 8211 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            year  month  day  hour  minute  second  hru_1     hru_2     hru_3  \\\n",
       "datetime                                                                        \n",
       "2004-12-20  2004     12   20     0       0       0    0.0  0.000000  0.000000   \n",
       "2004-12-21  2004     12   21     0       0       0    0.0  0.000000  0.000000   \n",
       "2004-12-22  2004     12   22     0       0       0    0.0  0.030779  0.000000   \n",
       "2004-12-23  2004     12   23     0       0       0    0.0  4.291635  3.337007   \n",
       "2004-12-24  2004     12   24     0       0       0    0.0  0.000000  0.000000   \n",
       "\n",
       "               hru_4    ...     hru_8196  hru_8197  hru_8198  hru_8199  \\\n",
       "datetime                ...                                              \n",
       "2004-12-20  0.000000    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "2004-12-21  0.000000    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "2004-12-22  0.160426    ...      8.34631  8.708111  9.731642  9.566482   \n",
       "2004-12-23  4.584321    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "2004-12-24  0.000000    ...      0.00000  0.000000  0.000000  0.000000   \n",
       "\n",
       "            hru_8200  hru_8201  hru_8202  hru_8203  hru_8204  hru_8205  \n",
       "datetime                                                                \n",
       "2004-12-20  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "2004-12-21  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "2004-12-22  2.483852  2.367854   6.98103  5.275792  2.472068  2.887732  \n",
       "2004-12-23  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "2004-12-24  0.000000  0.000000   0.00000  0.000000  0.000000  0.000000  \n",
       "\n",
       "[5 rows x 8211 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "      <th>hour</th>\n",
       "      <th>minute</th>\n",
       "      <th>second</th>\n",
       "      <th>hru_1</th>\n",
       "      <th>hru_2</th>\n",
       "      <th>hru_3</th>\n",
       "      <th>hru_4</th>\n",
       "      <th>...</th>\n",
       "      <th>hru_8196</th>\n",
       "      <th>hru_8197</th>\n",
       "      <th>hru_8198</th>\n",
       "      <th>hru_8199</th>\n",
       "      <th>hru_8200</th>\n",
       "      <th>hru_8201</th>\n",
       "      <th>hru_8202</th>\n",
       "      <th>hru_8203</th>\n",
       "      <th>hru_8204</th>\n",
       "      <th>hru_8205</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2015-01-03</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10.524005</td>\n",
       "      <td>15.240544</td>\n",
       "      <td>14.692121</td>\n",
       "      <td>15.025848</td>\n",
       "      <td>...</td>\n",
       "      <td>20.794635</td>\n",
       "      <td>20.938213</td>\n",
       "      <td>20.242687</td>\n",
       "      <td>19.595702</td>\n",
       "      <td>13.147538</td>\n",
       "      <td>13.659655</td>\n",
       "      <td>12.358628</td>\n",
       "      <td>12.419685</td>\n",
       "      <td>17.806062</td>\n",
       "      <td>15.797369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-04</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.845967</td>\n",
       "      <td>0.477940</td>\n",
       "      <td>0.596432</td>\n",
       "      <td>0.372863</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-05</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.677320</td>\n",
       "      <td>0.118776</td>\n",
       "      <td>0.140070</td>\n",
       "      <td>0.121935</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-06</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.652099</td>\n",
       "      <td>2.371195</td>\n",
       "      <td>2.350720</td>\n",
       "      <td>2.391178</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-01-07</th>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.005035</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 8211 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            year  month  day  hour  minute  second      hru_1      hru_2  \\\n",
       "datetime                                                                   \n",
       "2015-01-03  2015      1    3     0       0       0  10.524005  15.240544   \n",
       "2015-01-04  2015      1    4     0       0       0   2.845967   0.477940   \n",
       "2015-01-05  2015      1    5     0       0       0   0.677320   0.118776   \n",
       "2015-01-06  2015      1    6     0       0       0   3.652099   2.371195   \n",
       "2015-01-07  2015      1    7     0       0       0   0.750000   0.000000   \n",
       "\n",
       "                hru_3      hru_4    ...       hru_8196   hru_8197   hru_8198  \\\n",
       "datetime                            ...                                        \n",
       "2015-01-03  14.692121  15.025848    ...      20.794635  20.938213  20.242687   \n",
       "2015-01-04   0.596432   0.372863    ...       0.000000   0.000000   0.000000   \n",
       "2015-01-05   0.140070   0.121935    ...       0.000000   0.000000   0.000000   \n",
       "2015-01-06   2.350720   2.391178    ...       0.000000   0.000000   0.000000   \n",
       "2015-01-07   0.005035   0.000000    ...       0.000000   0.000000   0.000000   \n",
       "\n",
       "             hru_8199   hru_8200   hru_8201   hru_8202   hru_8203   hru_8204  \\\n",
       "datetime                                                                       \n",
       "2015-01-03  19.595702  13.147538  13.659655  12.358628  12.419685  17.806062   \n",
       "2015-01-04   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "2015-01-05   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "2015-01-06   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "2015-01-07   0.000000   0.000000   0.000000   0.000000   0.000000   0.000000   \n",
       "\n",
       "             hru_8205  \n",
       "datetime               \n",
       "2015-01-03  15.797369  \n",
       "2015-01-04   0.000000  \n",
       "2015-01-05   0.000000  \n",
       "2015-01-06   0.000000  \n",
       "2015-01-07   0.000000  \n",
       "\n",
       "[5 rows x 8211 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dat.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}