get_gdax_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "from os import path as os_path, getcwd\n",
    "from sys import path as sys_path\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "\n",
    "import datetime\n",
    "\n",
    "import gdax\n",
    "\n",
    "from gdax_client import GdaxClient "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "max_requests = 350\n",
    "dt = datetime.timedelta(minutes=15*max_requests)\n",
    "begin = datetime.datetime(2016, 1, 1, 0, 0) # Change begin date (YYYY/DD/MM/h/min)\n",
    "end = datetime.datetime(2018, 1, 1, 0, 0)   # Change end date\n",
    "\n",
    "client = GdaxClient()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2016-05-18 00:00:00</td>\n",
       "      <td>12.50</td>\n",
       "      <td>12.50</td>\n",
       "      <td>12.50</td>\n",
       "      <td>12.50</td>\n",
       "      <td>0.399002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2016-05-18 00:15:00</td>\n",
       "      <td>12.50</td>\n",
       "      <td>13.00</td>\n",
       "      <td>12.50</td>\n",
       "      <td>13.00</td>\n",
       "      <td>0.790428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2016-05-18 00:30:00</td>\n",
       "      <td>12.75</td>\n",
       "      <td>13.00</td>\n",
       "      <td>12.75</td>\n",
       "      <td>13.00</td>\n",
       "      <td>6.310570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2016-05-18 00:45:00</td>\n",
       "      <td>13.00</td>\n",
       "      <td>14.93</td>\n",
       "      <td>14.93</td>\n",
       "      <td>13.00</td>\n",
       "      <td>0.502848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2016-05-18 01:00:00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>0.462483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2016-05-18 01:15:00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.10</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.10</td>\n",
       "      <td>15.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2016-05-18 02:00:00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.00</td>\n",
       "      <td>0.052000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2016-05-18 17:15:00</td>\n",
       "      <td>13.60</td>\n",
       "      <td>13.60</td>\n",
       "      <td>13.60</td>\n",
       "      <td>13.60</td>\n",
       "      <td>0.366730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2016-05-18 18:30:00</td>\n",
       "      <td>13.05</td>\n",
       "      <td>13.27</td>\n",
       "      <td>13.27</td>\n",
       "      <td>13.05</td>\n",
       "      <td>163.219034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2016-05-18 18:45:00</td>\n",
       "      <td>13.51</td>\n",
       "      <td>13.51</td>\n",
       "      <td>13.51</td>\n",
       "      <td>13.51</td>\n",
       "      <td>3.691733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2016-05-18 19:00:00</td>\n",
       "      <td>13.03</td>\n",
       "      <td>13.04</td>\n",
       "      <td>13.04</td>\n",
       "      <td>13.03</td>\n",
       "      <td>89.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2016-05-18 19:45:00</td>\n",
       "      <td>13.51</td>\n",
       "      <td>13.51</td>\n",
       "      <td>13.51</td>\n",
       "      <td>13.51</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2016-05-18 21:15:00</td>\n",
       "      <td>13.08</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.08</td>\n",
       "      <td>13.13</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2016-05-18 22:00:00</td>\n",
       "      <td>13.11</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.11</td>\n",
       "      <td>13.13</td>\n",
       "      <td>3.799265</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2016-05-18 22:45:00</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.13</td>\n",
       "      <td>3.798577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2016-05-18 23:15:00</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.13</td>\n",
       "      <td>45.668768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2016-05-18 23:30:00</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.17</td>\n",
       "      <td>13.13</td>\n",
       "      <td>13.17</td>\n",
       "      <td>97.837177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2016-05-18 23:45:00</td>\n",
       "      <td>13.18</td>\n",
       "      <td>13.18</td>\n",
       "      <td>13.18</td>\n",
       "      <td>13.18</td>\n",
       "      <td>48.523213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2016-05-19 00:45:00</td>\n",
       "      <td>13.00</td>\n",
       "      <td>13.18</td>\n",
       "      <td>13.18</td>\n",
       "      <td>13.18</td>\n",
       "      <td>2.256440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2016-05-19 08:15:00</td>\n",
       "      <td>14.13</td>\n",
       "      <td>14.27</td>\n",
       "      <td>14.27</td>\n",
       "      <td>14.13</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2016-05-19 08:30:00</td>\n",
       "      <td>14.10</td>\n",
       "      <td>14.13</td>\n",
       "      <td>14.13</td>\n",
       "      <td>14.10</td>\n",
       "      <td>101.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2016-05-19 16:30:00</td>\n",
       "      <td>14.15</td>\n",
       "      <td>14.19</td>\n",
       "      <td>14.15</td>\n",
       "      <td>14.19</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2016-05-19 17:30:00</td>\n",
       "      <td>14.13</td>\n",
       "      <td>14.17</td>\n",
       "      <td>14.13</td>\n",
       "      <td>14.17</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2016-05-19 17:45:00</td>\n",
       "      <td>14.18</td>\n",
       "      <td>14.18</td>\n",
       "      <td>14.18</td>\n",
       "      <td>14.18</td>\n",
       "      <td>0.794063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2016-05-19 19:15:00</td>\n",
       "      <td>14.33</td>\n",
       "      <td>14.34</td>\n",
       "      <td>14.33</td>\n",
       "      <td>14.34</td>\n",
       "      <td>6.959012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2016-05-19 19:30:00</td>\n",
       "      <td>14.05</td>\n",
       "      <td>14.34</td>\n",
       "      <td>14.34</td>\n",
       "      <td>14.34</td>\n",
       "      <td>17.379381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2016-05-19 20:45:00</td>\n",
       "      <td>14.34</td>\n",
       "      <td>14.35</td>\n",
       "      <td>14.34</td>\n",
       "      <td>14.35</td>\n",
       "      <td>20.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2016-05-19 22:45:00</td>\n",
       "      <td>14.83</td>\n",
       "      <td>14.83</td>\n",
       "      <td>14.83</td>\n",
       "      <td>14.83</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2016-05-19 23:45:00</td>\n",
       "      <td>14.89</td>\n",
       "      <td>14.90</td>\n",
       "      <td>14.89</td>\n",
       "      <td>14.90</td>\n",
       "      <td>600.952309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2016-05-20 00:30:00</td>\n",
       "      <td>14.82</td>\n",
       "      <td>14.82</td>\n",
       "      <td>14.82</td>\n",
       "      <td>14.82</td>\n",
       "      <td>16.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54904</th>\n",
       "      <td>2017-12-31 16:30:00</td>\n",
       "      <td>737.87</td>\n",
       "      <td>743.24</td>\n",
       "      <td>738.84</td>\n",
       "      <td>740.00</td>\n",
       "      <td>3013.280414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54905</th>\n",
       "      <td>2017-12-31 16:45:00</td>\n",
       "      <td>735.49</td>\n",
       "      <td>741.14</td>\n",
       "      <td>740.00</td>\n",
       "      <td>738.00</td>\n",
       "      <td>1573.849483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54906</th>\n",
       "      <td>2017-12-31 17:00:00</td>\n",
       "      <td>737.99</td>\n",
       "      <td>742.00</td>\n",
       "      <td>737.99</td>\n",
       "      <td>739.37</td>\n",
       "      <td>1333.790085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54907</th>\n",
       "      <td>2017-12-31 17:15:00</td>\n",
       "      <td>739.17</td>\n",
       "      <td>741.50</td>\n",
       "      <td>739.36</td>\n",
       "      <td>740.75</td>\n",
       "      <td>845.921922</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54908</th>\n",
       "      <td>2017-12-31 17:30:00</td>\n",
       "      <td>738.02</td>\n",
       "      <td>743.25</td>\n",
       "      <td>740.75</td>\n",
       "      <td>743.25</td>\n",
       "      <td>1660.362365</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54909</th>\n",
       "      <td>2017-12-31 17:45:00</td>\n",
       "      <td>742.51</td>\n",
       "      <td>743.67</td>\n",
       "      <td>743.24</td>\n",
       "      <td>743.50</td>\n",
       "      <td>824.307330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54910</th>\n",
       "      <td>2017-12-31 18:00:00</td>\n",
       "      <td>743.00</td>\n",
       "      <td>744.00</td>\n",
       "      <td>743.50</td>\n",
       "      <td>744.00</td>\n",
       "      <td>1080.871577</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54911</th>\n",
       "      <td>2017-12-31 18:15:00</td>\n",
       "      <td>741.27</td>\n",
       "      <td>744.00</td>\n",
       "      <td>743.98</td>\n",
       "      <td>742.02</td>\n",
       "      <td>809.490039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54912</th>\n",
       "      <td>2017-12-31 18:30:00</td>\n",
       "      <td>738.00</td>\n",
       "      <td>742.19</td>\n",
       "      <td>742.01</td>\n",
       "      <td>739.14</td>\n",
       "      <td>990.755928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54913</th>\n",
       "      <td>2017-12-31 18:45:00</td>\n",
       "      <td>739.13</td>\n",
       "      <td>739.90</td>\n",
       "      <td>739.14</td>\n",
       "      <td>739.89</td>\n",
       "      <td>741.920552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54914</th>\n",
       "      <td>2017-12-31 19:00:00</td>\n",
       "      <td>739.88</td>\n",
       "      <td>742.00</td>\n",
       "      <td>739.89</td>\n",
       "      <td>742.00</td>\n",
       "      <td>738.735585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54915</th>\n",
       "      <td>2017-12-31 19:15:00</td>\n",
       "      <td>741.99</td>\n",
       "      <td>743.50</td>\n",
       "      <td>742.00</td>\n",
       "      <td>743.48</td>\n",
       "      <td>974.504834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54916</th>\n",
       "      <td>2017-12-31 19:30:00</td>\n",
       "      <td>740.61</td>\n",
       "      <td>743.75</td>\n",
       "      <td>743.48</td>\n",
       "      <td>741.67</td>\n",
       "      <td>800.368667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54917</th>\n",
       "      <td>2017-12-31 19:45:00</td>\n",
       "      <td>741.67</td>\n",
       "      <td>743.42</td>\n",
       "      <td>741.68</td>\n",
       "      <td>743.42</td>\n",
       "      <td>684.747274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54918</th>\n",
       "      <td>2017-12-31 20:00:00</td>\n",
       "      <td>743.41</td>\n",
       "      <td>744.00</td>\n",
       "      <td>743.42</td>\n",
       "      <td>744.00</td>\n",
       "      <td>1142.876682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54919</th>\n",
       "      <td>2017-12-31 20:15:00</td>\n",
       "      <td>743.99</td>\n",
       "      <td>744.87</td>\n",
       "      <td>744.00</td>\n",
       "      <td>744.84</td>\n",
       "      <td>666.581856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54920</th>\n",
       "      <td>2017-12-31 20:30:00</td>\n",
       "      <td>744.88</td>\n",
       "      <td>748.00</td>\n",
       "      <td>744.88</td>\n",
       "      <td>747.99</td>\n",
       "      <td>1243.404868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54921</th>\n",
       "      <td>2017-12-31 20:45:00</td>\n",
       "      <td>747.98</td>\n",
       "      <td>750.30</td>\n",
       "      <td>747.99</td>\n",
       "      <td>750.11</td>\n",
       "      <td>2968.584571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54922</th>\n",
       "      <td>2017-12-31 21:00:00</td>\n",
       "      <td>745.21</td>\n",
       "      <td>751.00</td>\n",
       "      <td>750.11</td>\n",
       "      <td>745.31</td>\n",
       "      <td>2018.474614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54923</th>\n",
       "      <td>2017-12-31 21:15:00</td>\n",
       "      <td>743.96</td>\n",
       "      <td>746.89</td>\n",
       "      <td>745.32</td>\n",
       "      <td>744.50</td>\n",
       "      <td>795.856323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54924</th>\n",
       "      <td>2017-12-31 21:30:00</td>\n",
       "      <td>744.49</td>\n",
       "      <td>747.00</td>\n",
       "      <td>744.50</td>\n",
       "      <td>745.00</td>\n",
       "      <td>581.797757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54925</th>\n",
       "      <td>2017-12-31 21:45:00</td>\n",
       "      <td>744.02</td>\n",
       "      <td>746.37</td>\n",
       "      <td>745.07</td>\n",
       "      <td>746.08</td>\n",
       "      <td>546.302125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54926</th>\n",
       "      <td>2017-12-31 22:00:00</td>\n",
       "      <td>743.61</td>\n",
       "      <td>747.79</td>\n",
       "      <td>746.09</td>\n",
       "      <td>744.18</td>\n",
       "      <td>802.706264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54927</th>\n",
       "      <td>2017-12-31 22:15:00</td>\n",
       "      <td>743.11</td>\n",
       "      <td>746.65</td>\n",
       "      <td>744.19</td>\n",
       "      <td>743.39</td>\n",
       "      <td>545.429944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54928</th>\n",
       "      <td>2017-12-31 22:30:00</td>\n",
       "      <td>743.10</td>\n",
       "      <td>745.98</td>\n",
       "      <td>743.38</td>\n",
       "      <td>744.99</td>\n",
       "      <td>793.012603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54929</th>\n",
       "      <td>2017-12-31 22:45:00</td>\n",
       "      <td>743.00</td>\n",
       "      <td>750.00</td>\n",
       "      <td>744.90</td>\n",
       "      <td>743.01</td>\n",
       "      <td>1741.159341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54930</th>\n",
       "      <td>2017-12-31 23:00:00</td>\n",
       "      <td>742.15</td>\n",
       "      <td>743.01</td>\n",
       "      <td>743.01</td>\n",
       "      <td>742.16</td>\n",
       "      <td>554.996150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54931</th>\n",
       "      <td>2017-12-31 23:15:00</td>\n",
       "      <td>740.33</td>\n",
       "      <td>742.16</td>\n",
       "      <td>742.16</td>\n",
       "      <td>742.00</td>\n",
       "      <td>888.298569</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54932</th>\n",
       "      <td>2017-12-31 23:30:00</td>\n",
       "      <td>741.48</td>\n",
       "      <td>743.00</td>\n",
       "      <td>742.00</td>\n",
       "      <td>743.00</td>\n",
       "      <td>1191.988408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54933</th>\n",
       "      <td>2017-12-31 23:45:00</td>\n",
       "      <td>741.27</td>\n",
       "      <td>743.01</td>\n",
       "      <td>742.99</td>\n",
       "      <td>741.27</td>\n",
       "      <td>954.695232</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>54934 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     time     low    high    open   close       volume\n",
       "0     2016-05-18 00:00:00   12.50   12.50   12.50   12.50     0.399002\n",
       "1     2016-05-18 00:15:00   12.50   13.00   12.50   13.00     0.790428\n",
       "2     2016-05-18 00:30:00   12.75   13.00   12.75   13.00     6.310570\n",
       "3     2016-05-18 00:45:00   13.00   14.93   14.93   13.00     0.502848\n",
       "4     2016-05-18 01:00:00   14.00   14.00   14.00   14.00     0.462483\n",
       "5     2016-05-18 01:15:00   14.00   14.10   14.00   14.10    15.000000\n",
       "6     2016-05-18 02:00:00   14.00   14.00   14.00   14.00     0.052000\n",
       "7     2016-05-18 17:15:00   13.60   13.60   13.60   13.60     0.366730\n",
       "8     2016-05-18 18:30:00   13.05   13.27   13.27   13.05   163.219034\n",
       "9     2016-05-18 18:45:00   13.51   13.51   13.51   13.51     3.691733\n",
       "10    2016-05-18 19:00:00   13.03   13.04   13.04   13.03    89.100000\n",
       "11    2016-05-18 19:45:00   13.51   13.51   13.51   13.51     1.000000\n",
       "12    2016-05-18 21:15:00   13.08   13.13   13.08   13.13     2.000000\n",
       "13    2016-05-18 22:00:00   13.11   13.13   13.11   13.13     3.799265\n",
       "14    2016-05-18 22:45:00   13.13   13.13   13.13   13.13     3.798577\n",
       "15    2016-05-18 23:15:00   13.13   13.13   13.13   13.13    45.668768\n",
       "16    2016-05-18 23:30:00   13.13   13.17   13.13   13.17    97.837177\n",
       "17    2016-05-18 23:45:00   13.18   13.18   13.18   13.18    48.523213\n",
       "18    2016-05-19 00:45:00   13.00   13.18   13.18   13.18     2.256440\n",
       "19    2016-05-19 08:15:00   14.13   14.27   14.27   14.13   100.000000\n",
       "20    2016-05-19 08:30:00   14.10   14.13   14.13   14.10   101.000000\n",
       "21    2016-05-19 16:30:00   14.15   14.19   14.15   14.19   100.000000\n",
       "22    2016-05-19 17:30:00   14.13   14.17   14.13   14.17     1.000000\n",
       "23    2016-05-19 17:45:00   14.18   14.18   14.18   14.18     0.794063\n",
       "24    2016-05-19 19:15:00   14.33   14.34   14.33   14.34     6.959012\n",
       "25    2016-05-19 19:30:00   14.05   14.34   14.34   14.34    17.379381\n",
       "26    2016-05-19 20:45:00   14.34   14.35   14.34   14.35    20.000000\n",
       "27    2016-05-19 22:45:00   14.83   14.83   14.83   14.83     0.100000\n",
       "28    2016-05-19 23:45:00   14.89   14.90   14.89   14.90   600.952309\n",
       "29    2016-05-20 00:30:00   14.82   14.82   14.82   14.82    16.000000\n",
       "...                   ...     ...     ...     ...     ...          ...\n",
       "54904 2017-12-31 16:30:00  737.87  743.24  738.84  740.00  3013.280414\n",
       "54905 2017-12-31 16:45:00  735.49  741.14  740.00  738.00  1573.849483\n",
       "54906 2017-12-31 17:00:00  737.99  742.00  737.99  739.37  1333.790085\n",
       "54907 2017-12-31 17:15:00  739.17  741.50  739.36  740.75   845.921922\n",
       "54908 2017-12-31 17:30:00  738.02  743.25  740.75  743.25  1660.362365\n",
       "54909 2017-12-31 17:45:00  742.51  743.67  743.24  743.50   824.307330\n",
       "54910 2017-12-31 18:00:00  743.00  744.00  743.50  744.00  1080.871577\n",
       "54911 2017-12-31 18:15:00  741.27  744.00  743.98  742.02   809.490039\n",
       "54912 2017-12-31 18:30:00  738.00  742.19  742.01  739.14   990.755928\n",
       "54913 2017-12-31 18:45:00  739.13  739.90  739.14  739.89   741.920552\n",
       "54914 2017-12-31 19:00:00  739.88  742.00  739.89  742.00   738.735585\n",
       "54915 2017-12-31 19:15:00  741.99  743.50  742.00  743.48   974.504834\n",
       "54916 2017-12-31 19:30:00  740.61  743.75  743.48  741.67   800.368667\n",
       "54917 2017-12-31 19:45:00  741.67  743.42  741.68  743.42   684.747274\n",
       "54918 2017-12-31 20:00:00  743.41  744.00  743.42  744.00  1142.876682\n",
       "54919 2017-12-31 20:15:00  743.99  744.87  744.00  744.84   666.581856\n",
       "54920 2017-12-31 20:30:00  744.88  748.00  744.88  747.99  1243.404868\n",
       "54921 2017-12-31 20:45:00  747.98  750.30  747.99  750.11  2968.584571\n",
       "54922 2017-12-31 21:00:00  745.21  751.00  750.11  745.31  2018.474614\n",
       "54923 2017-12-31 21:15:00  743.96  746.89  745.32  744.50   795.856323\n",
       "54924 2017-12-31 21:30:00  744.49  747.00  744.50  745.00   581.797757\n",
       "54925 2017-12-31 21:45:00  744.02  746.37  745.07  746.08   546.302125\n",
       "54926 2017-12-31 22:00:00  743.61  747.79  746.09  744.18   802.706264\n",
       "54927 2017-12-31 22:15:00  743.11  746.65  744.19  743.39   545.429944\n",
       "54928 2017-12-31 22:30:00  743.10  745.98  743.38  744.99   793.012603\n",
       "54929 2017-12-31 22:45:00  743.00  750.00  744.90  743.01  1741.159341\n",
       "54930 2017-12-31 23:00:00  742.15  743.01  743.01  742.16   554.996150\n",
       "54931 2017-12-31 23:15:00  740.33  742.16  742.16  742.00   888.298569\n",
       "54932 2017-12-31 23:30:00  741.48  743.00  742.00  743.00  1191.988408\n",
       "54933 2017-12-31 23:45:00  741.27  743.01  742.99  741.27   954.695232\n",
       "\n",
       "[54934 rows x 6 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "df_year = client.get_historical_data(begin, end)\n",
    "display(df_year)\n",
    "# df_year.to_pickle(\"data/ETH_USD_2016_2018_15min.pkl\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "54934\n",
      "2017-12-31 23:45:00\n",
      "[]\n"
     ]
    }
   ],
   "source": [
    "print(len(df_year[\"time\"]))\n",
    "print(df_year[\"time\"][54934-1])\n",
    "a = df_year.loc[1+2:7,[\"close\",\"volume\"]].values\n",
    "print(a)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No data between 2016-05-18 01:15:00 and 2016-05-18 02:00:00.\n",
      "No data between 2016-05-18 02:00:00 and 2016-05-18 17:15:00.\n",
      "No data between 2016-05-18 17:15:00 and 2016-05-18 18:30:00.\n",
      "No data between 2016-05-18 19:00:00 and 2016-05-18 19:45:00.\n",
      "No data between 2016-05-18 19:45:00 and 2016-05-18 21:15:00.\n",
      "No data between 2016-05-18 21:15:00 and 2016-05-18 22:00:00.\n",
      "No data between 2016-05-18 22:00:00 and 2016-05-18 22:45:00.\n",
      "No data between 2016-05-18 22:45:00 and 2016-05-18 23:15:00.\n",
      "No data between 2016-05-18 23:45:00 and 2016-05-19 00:45:00.\n",
      "No data between 2016-05-19 00:45:00 and 2016-05-19 08:15:00.\n",
      "No data between 2016-05-19 08:30:00 and 2016-05-19 16:30:00.\n",
      "No data between 2016-05-19 16:30:00 and 2016-05-19 17:30:00.\n",
      "No data between 2016-05-19 17:45:00 and 2016-05-19 19:15:00.\n",
      "No data between 2016-05-19 19:30:00 and 2016-05-19 20:45:00.\n",
      "No data between 2016-05-19 20:45:00 and 2016-05-19 22:45:00.\n",
      "No data between 2016-05-19 22:45:00 and 2016-05-19 23:45:00.\n",
      "No data between 2016-05-19 23:45:00 and 2016-05-20 00:30:00.\n",
      "No data between 2016-05-20 00:30:00 and 2016-05-20 15:00:00.\n",
      "No data between 2016-05-20 15:00:00 and 2016-05-20 16:30:00.\n",
      "No data between 2016-05-20 16:30:00 and 2016-05-20 20:00:00.\n",
      "No data between 2016-05-20 20:00:00 and 2016-05-23 14:00:00.\n",
      "No data between 2016-05-23 14:00:00 and 2016-05-23 22:00:00.\n",
      "No data between 2016-05-23 22:00:00 and 2016-05-23 23:45:00.\n",
      "No data between 2016-05-24 00:00:00 and 2016-05-24 07:45:00.\n",
      "No data between 2016-05-24 07:45:00 and 2016-05-24 15:30:00.\n",
      "No data between 2016-05-24 15:30:00 and 2016-05-24 16:00:00.\n",
      "No data between 2016-05-24 16:00:00 and 2016-05-24 17:15:00.\n",
      "No data between 2016-05-24 17:15:00 and 2016-05-24 17:45:00.\n",
      "No data between 2016-05-24 17:45:00 and 2016-05-24 18:30:00.\n",
      "No data between 2016-05-24 18:30:00 and 2016-05-24 19:00:00.\n",
      "No data between 2016-05-24 23:00:00 and 2016-05-24 23:30:00.\n",
      "No data between 2016-05-25 00:00:00 and 2016-05-25 00:30:00.\n",
      "No data between 2016-05-25 00:30:00 and 2016-05-25 01:00:00.\n",
      "No data between 2016-05-25 07:15:00 and 2016-05-25 08:00:00.\n",
      "No data between 2016-05-25 08:00:00 and 2016-05-25 08:30:00.\n",
      "No data between 2016-05-25 08:45:00 and 2016-05-25 09:15:00.\n",
      "No data between 2016-05-25 09:15:00 and 2016-05-25 09:45:00.\n",
      "No data between 2016-05-25 10:15:00 and 2016-05-25 10:45:00.\n",
      "No data between 2016-05-25 11:15:00 and 2016-05-25 12:00:00.\n",
      "No data between 2016-05-25 12:00:00 and 2016-05-25 12:30:00.\n",
      "No data between 2016-05-25 15:15:00 and 2016-05-25 15:45:00.\n",
      "No data between 2016-05-25 15:45:00 and 2016-05-25 16:15:00.\n",
      "No data between 2016-05-25 17:45:00 and 2016-05-25 18:30:00.\n",
      "No data between 2016-05-25 18:30:00 and 2016-05-25 19:00:00.\n",
      "No data between 2016-05-25 21:15:00 and 2016-05-25 21:45:00.\n",
      "No data between 2016-05-25 22:30:00 and 2016-05-25 23:30:00.\n",
      "No data between 2016-05-26 00:30:00 and 2016-05-26 01:00:00.\n",
      "No data between 2016-05-26 01:00:00 and 2016-05-26 01:30:00.\n",
      "No data between 2016-05-26 03:45:00 and 2016-05-26 04:30:00.\n",
      "No data between 2016-05-26 04:30:00 and 2016-05-26 05:30:00.\n",
      "No data between 2016-05-26 06:00:00 and 2016-05-26 06:30:00.\n",
      "No data between 2016-05-26 07:00:00 and 2016-05-26 11:45:00.\n",
      "No data between 2016-05-26 12:15:00 and 2016-05-26 13:00:00.\n",
      "No data between 2016-05-26 13:00:00 and 2016-05-26 13:30:00.\n",
      "No data between 2016-05-26 14:00:00 and 2016-05-26 14:30:00.\n",
      "No data between 2016-05-26 14:30:00 and 2016-05-26 15:15:00.\n",
      "No data between 2016-05-26 16:15:00 and 2016-05-26 16:45:00.\n",
      "No data between 2016-05-26 17:30:00 and 2016-05-26 18:00:00.\n",
      "No data between 2016-05-26 20:00:00 and 2016-05-26 20:30:00.\n",
      "No data between 2016-05-26 20:30:00 and 2016-05-26 21:00:00.\n",
      "No data between 2016-05-26 22:45:00 and 2016-05-26 23:15:00.\n",
      "No data between 2016-05-27 02:00:00 and 2016-05-27 02:30:00.\n",
      "No data between 2016-05-27 06:30:00 and 2016-05-27 07:00:00.\n",
      "No data between 2016-05-27 07:30:00 and 2016-05-27 08:30:00.\n",
      "No data between 2016-05-27 08:30:00 and 2016-05-27 09:00:00.\n",
      "No data between 2016-05-27 09:00:00 and 2016-05-27 09:30:00.\n",
      "No data between 2016-05-27 09:45:00 and 2016-05-27 10:15:00.\n",
      "No data between 2016-05-27 12:15:00 and 2016-05-27 12:45:00.\n",
      "No data between 2016-05-27 17:00:00 and 2016-05-27 17:30:00.\n",
      "No data between 2016-05-27 21:45:00 and 2016-05-27 22:15:00.\n",
      "No data between 2016-05-28 01:45:00 and 2016-05-28 02:30:00.\n",
      "No data between 2016-05-28 03:00:00 and 2016-05-28 03:30:00.\n",
      "No data between 2016-05-28 04:45:00 and 2016-05-28 05:15:00.\n",
      "No data between 2016-05-28 06:15:00 and 2016-05-28 06:45:00.\n",
      "No data between 2016-05-28 07:45:00 and 2016-05-28 08:15:00.\n",
      "No data between 2016-05-28 08:45:00 and 2016-05-28 09:15:00.\n",
      "No data between 2016-05-28 09:45:00 and 2016-05-28 10:30:00.\n",
      "No data between 2016-05-28 11:15:00 and 2016-05-28 12:00:00.\n",
      "No data between 2016-05-28 13:00:00 and 2016-05-28 13:30:00.\n",
      "No data between 2016-05-28 13:30:00 and 2016-05-28 14:30:00.\n",
      "No data between 2016-05-28 15:00:00 and 2016-05-28 15:30:00.\n",
      "No data between 2016-05-28 17:00:00 and 2016-05-28 18:00:00.\n",
      "No data between 2016-05-28 18:30:00 and 2016-05-28 19:00:00.\n",
      "No data between 2016-05-28 19:30:00 and 2016-05-28 20:15:00.\n",
      "No data between 2016-05-28 22:00:00 and 2016-05-28 22:30:00.\n",
      "No data between 2016-05-28 22:30:00 and 2016-05-28 23:00:00.\n",
      "No data between 2016-05-29 02:15:00 and 2016-05-29 02:45:00.\n",
      "No data between 2016-05-29 02:45:00 and 2016-05-29 03:15:00.\n",
      "No data between 2016-05-29 03:30:00 and 2016-05-29 04:00:00.\n",
      "No data between 2016-05-29 05:30:00 and 2016-05-29 06:30:00.\n",
      "No data between 2016-05-29 07:00:00 and 2016-05-29 08:00:00.\n",
      "No data between 2016-05-29 08:00:00 and 2016-05-29 08:45:00.\n",
      "No data between 2016-05-29 08:45:00 and 2016-05-29 10:45:00.\n",
      "No data between 2016-05-29 11:00:00 and 2016-05-29 11:30:00.\n",
      "No data between 2016-05-29 11:30:00 and 2016-05-29 12:00:00.\n",
      "No data between 2016-05-29 12:15:00 and 2016-05-29 12:45:00.\n",
      "No data between 2016-05-29 13:45:00 and 2016-05-29 14:15:00.\n",
      "No data between 2016-05-29 14:15:00 and 2016-05-29 14:45:00.\n",
      "No data between 2016-05-29 14:45:00 and 2016-05-29 15:30:00.\n",
      "No data between 2016-05-29 15:30:00 and 2016-05-29 16:00:00.\n",
      "No data between 2016-05-29 16:15:00 and 2016-05-29 16:45:00.\n",
      "No data between 2016-05-29 17:15:00 and 2016-05-29 17:45:00.\n",
      "No data between 2016-05-29 18:15:00 and 2016-05-29 18:45:00.\n",
      "No data between 2016-05-29 20:15:00 and 2016-05-29 20:45:00.\n",
      "No data between 2016-05-29 21:00:00 and 2016-05-29 21:45:00.\n",
      "No data between 2016-05-29 22:15:00 and 2016-05-29 23:00:00.\n",
      "No data between 2016-05-29 23:15:00 and 2016-05-30 00:30:00.\n",
      "No data between 2016-05-30 01:15:00 and 2016-05-30 02:00:00.\n",
      "No data between 2016-05-30 02:15:00 and 2016-05-30 03:15:00.\n",
      "No data between 2016-05-30 03:15:00 and 2016-05-30 03:45:00.\n",
      "No data between 2016-05-30 03:45:00 and 2016-05-30 05:15:00.\n",
      "No data between 2016-05-30 05:15:00 and 2016-05-30 06:15:00.\n",
      "No data between 2016-05-30 06:45:00 and 2016-05-30 07:15:00.\n",
      "No data between 2016-05-30 07:15:00 and 2016-05-30 08:15:00.\n",
      "No data between 2016-05-30 09:00:00 and 2016-05-30 09:30:00.\n",
      "No data between 2016-05-30 11:00:00 and 2016-05-30 11:45:00.\n",
      "No data between 2016-05-30 12:00:00 and 2016-05-30 12:30:00.\n",
      "No data between 2016-05-30 13:15:00 and 2016-05-30 13:45:00.\n",
      "No data between 2016-05-30 14:00:00 and 2016-05-30 14:45:00.\n",
      "No data between 2016-05-30 17:30:00 and 2016-05-30 18:00:00.\n",
      "No data between 2016-05-30 18:15:00 and 2016-05-30 18:45:00.\n",
      "No data between 2016-05-30 19:45:00 and 2016-05-30 20:15:00.\n",
      "No data between 2016-05-30 20:45:00 and 2016-05-30 21:15:00.\n",
      "No data between 2016-05-30 21:15:00 and 2016-05-30 22:00:00.\n",
      "No data between 2016-05-30 22:15:00 and 2016-05-30 22:45:00.\n",
      "No data between 2016-05-30 23:30:00 and 2016-05-31 00:15:00.\n",
      "No data between 2016-05-31 01:30:00 and 2016-05-31 02:00:00.\n",
      "No data between 2016-05-31 02:45:00 and 2016-05-31 03:15:00.\n",
      "No data between 2016-05-31 03:30:00 and 2016-05-31 04:00:00.\n",
      "No data between 2016-05-31 04:00:00 and 2016-05-31 04:45:00.\n",
      "No data between 2016-05-31 04:45:00 and 2016-05-31 05:45:00.\n",
      "No data between 2016-05-31 05:45:00 and 2016-05-31 07:00:00.\n",
      "No data between 2016-05-31 07:30:00 and 2016-05-31 08:15:00.\n",
      "No data between 2016-05-31 08:45:00 and 2016-05-31 09:15:00.\n",
      "No data between 2016-05-31 09:30:00 and 2016-05-31 11:00:00.\n",
      "No data between 2016-05-31 11:00:00 and 2016-05-31 11:45:00.\n",
      "No data between 2016-05-31 11:45:00 and 2016-05-31 12:15:00.\n",
      "No data between 2016-05-31 13:45:00 and 2016-05-31 14:15:00.\n",
      "No data between 2016-05-31 16:45:00 and 2016-05-31 17:15:00.\n",
      "No data between 2016-05-31 22:45:00 and 2016-05-31 23:30:00.\n",
      "No data between 2016-06-01 00:30:00 and 2016-06-01 01:00:00.\n",
      "No data between 2016-06-01 01:45:00 and 2016-06-01 02:15:00.\n",
      "No data between 2016-06-01 04:45:00 and 2016-06-01 05:15:00.\n",
      "No data between 2016-06-01 07:15:00 and 2016-06-01 07:45:00.\n",
      "No data between 2016-06-01 09:00:00 and 2016-06-01 10:00:00.\n",
      "No data between 2016-06-01 10:00:00 and 2016-06-01 10:45:00.\n",
      "No data between 2016-06-01 11:15:00 and 2016-06-01 11:45:00.\n",
      "No data between 2016-06-01 17:00:00 and 2016-06-01 17:30:00.\n",
      "No data between 2016-06-01 23:30:00 and 2016-06-02 00:00:00.\n",
      "No data between 2016-06-02 01:00:00 and 2016-06-02 01:30:00.\n",
      "No data between 2016-06-02 02:00:00 and 2016-06-02 02:30:00.\n",
      "No data between 2016-06-02 02:45:00 and 2016-06-02 03:15:00.\n",
      "No data between 2016-06-02 05:15:00 and 2016-06-02 05:45:00.\n",
      "No data between 2016-06-02 07:00:00 and 2016-06-02 07:45:00.\n",
      "No data between 2016-06-02 07:45:00 and 2016-06-02 08:30:00.\n",
      "No data between 2016-06-02 09:00:00 and 2016-06-02 11:00:00.\n",
      "No data between 2016-06-02 11:00:00 and 2016-06-02 11:30:00.\n",
      "No data between 2016-06-02 11:30:00 and 2016-06-02 12:30:00.\n",
      "No data between 2016-06-02 13:15:00 and 2016-06-02 14:00:00.\n",
      "No data between 2016-06-02 17:00:00 and 2016-06-02 17:30:00.\n",
      "No data between 2016-06-02 20:30:00 and 2016-06-02 21:00:00.\n",
      "No data between 2016-06-02 23:00:00 and 2016-06-02 23:30:00.\n",
      "No data between 2016-06-03 01:00:00 and 2016-06-03 01:30:00.\n",
      "No data between 2016-06-03 02:15:00 and 2016-06-03 03:00:00.\n",
      "No data between 2016-06-03 04:15:00 and 2016-06-03 05:00:00.\n",
      "No data between 2016-06-03 05:00:00 and 2016-06-03 05:30:00.\n",
      "No data between 2016-06-03 05:45:00 and 2016-06-03 06:15:00.\n",
      "No data between 2016-06-03 07:30:00 and 2016-06-03 08:15:00.\n",
      "No data between 2016-06-03 09:30:00 and 2016-06-03 10:00:00.\n",
      "No data between 2016-06-03 12:15:00 and 2016-06-03 12:45:00.\n",
      "No data between 2016-06-03 21:30:00 and 2016-06-03 22:00:00.\n",
      "No data between 2016-06-03 22:00:00 and 2016-06-03 22:30:00.\n",
      "No data between 2016-06-04 00:45:00 and 2016-06-04 01:15:00.\n",
      "No data between 2016-06-04 01:15:00 and 2016-06-04 01:45:00.\n",
      "No data between 2016-06-04 02:45:00 and 2016-06-04 03:15:00.\n",
      "No data between 2016-06-04 03:15:00 and 2016-06-04 03:45:00.\n",
      "No data between 2016-06-04 04:45:00 and 2016-06-04 05:15:00.\n",
      "No data between 2016-06-04 05:45:00 and 2016-06-04 06:15:00.\n",
      "No data between 2016-06-04 07:15:00 and 2016-06-04 07:45:00.\n",
      "No data between 2016-06-04 08:15:00 and 2016-06-04 09:00:00.\n",
      "No data between 2016-06-04 10:30:00 and 2016-06-04 12:00:00.\n",
      "No data between 2016-06-04 12:00:00 and 2016-06-04 12:45:00.\n",
      "No data between 2016-06-04 12:45:00 and 2016-06-04 13:45:00.\n",
      "No data between 2016-06-04 13:45:00 and 2016-06-04 14:15:00.\n",
      "No data between 2016-06-04 15:45:00 and 2016-06-04 16:15:00.\n",
      "No data between 2016-06-04 18:00:00 and 2016-06-04 18:30:00.\n",
      "No data between 2016-06-04 20:30:00 and 2016-06-04 21:45:00.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No data between 2016-06-04 21:45:00 and 2016-06-04 22:15:00.\n",
      "No data between 2016-06-04 22:30:00 and 2016-06-04 23:30:00.\n",
      "No data between 2016-06-05 00:00:00 and 2016-06-05 00:45:00.\n",
      "No data between 2016-06-05 00:45:00 and 2016-06-05 01:30:00.\n",
      "No data between 2016-06-05 03:00:00 and 2016-06-05 03:30:00.\n",
      "No data between 2016-06-05 05:00:00 and 2016-06-05 05:30:00.\n",
      "No data between 2016-06-05 05:30:00 and 2016-06-05 06:15:00.\n",
      "No data between 2016-06-05 06:45:00 and 2016-06-05 07:45:00.\n",
      "No data between 2016-06-05 07:45:00 and 2016-06-05 09:15:00.\n",
      "No data between 2016-06-05 09:15:00 and 2016-06-05 10:45:00.\n",
      "No data between 2016-06-05 10:45:00 and 2016-06-05 11:15:00.\n",
      "No data between 2016-06-05 11:15:00 and 2016-06-05 12:45:00.\n",
      "No data between 2016-06-05 12:45:00 and 2016-06-05 13:30:00.\n",
      "No data between 2016-06-05 13:30:00 and 2016-06-05 14:00:00.\n",
      "No data between 2016-06-05 14:15:00 and 2016-06-05 15:15:00.\n",
      "No data between 2016-06-05 16:15:00 and 2016-06-05 17:00:00.\n",
      "No data between 2016-06-05 17:15:00 and 2016-06-05 17:45:00.\n",
      "No data between 2016-06-05 18:15:00 and 2016-06-05 18:45:00.\n",
      "No data between 2016-06-05 18:45:00 and 2016-06-05 19:15:00.\n",
      "No data between 2016-06-05 19:30:00 and 2016-06-05 20:00:00.\n",
      "No data between 2016-06-05 20:00:00 and 2016-06-05 20:45:00.\n",
      "No data between 2016-06-05 20:45:00 and 2016-06-05 21:30:00.\n",
      "No data between 2016-06-05 21:45:00 and 2016-06-05 22:15:00.\n",
      "No data between 2016-06-05 22:15:00 and 2016-06-05 23:00:00.\n",
      "No data between 2016-06-05 23:15:00 and 2016-06-06 00:45:00.\n",
      "No data between 2016-06-06 01:00:00 and 2016-06-06 02:15:00.\n",
      "No data between 2016-06-06 03:15:00 and 2016-06-06 03:45:00.\n",
      "No data between 2016-06-06 04:00:00 and 2016-06-06 04:45:00.\n",
      "No data between 2016-06-06 05:00:00 and 2016-06-06 06:00:00.\n",
      "No data between 2016-06-06 06:30:00 and 2016-06-06 07:00:00.\n",
      "No data between 2016-06-06 07:00:00 and 2016-06-06 07:45:00.\n",
      "No data between 2016-06-06 08:00:00 and 2016-06-06 10:15:00.\n",
      "No data between 2016-06-06 10:15:00 and 2016-06-06 11:15:00.\n",
      "No data between 2016-06-06 12:00:00 and 2016-06-06 13:00:00.\n",
      "No data between 2016-06-06 13:00:00 and 2016-06-06 13:30:00.\n",
      "No data between 2016-06-06 17:15:00 and 2016-06-06 17:45:00.\n",
      "No data between 2016-06-06 21:45:00 and 2016-06-06 22:15:00.\n",
      "No data between 2016-06-06 23:15:00 and 2016-06-07 00:00:00.\n",
      "No data between 2016-06-07 05:00:00 and 2016-06-07 05:30:00.\n",
      "No data between 2016-06-07 05:30:00 and 2016-06-07 06:00:00.\n",
      "No data between 2016-06-07 06:30:00 and 2016-06-07 07:15:00.\n",
      "No data between 2016-06-07 07:15:00 and 2016-06-07 07:45:00.\n",
      "No data between 2016-06-07 07:45:00 and 2016-06-07 08:15:00.\n",
      "No data between 2016-06-07 08:15:00 and 2016-06-07 08:45:00.\n",
      "No data between 2016-06-07 09:00:00 and 2016-06-07 09:30:00.\n",
      "No data between 2016-06-07 14:45:00 and 2016-06-07 15:15:00.\n",
      "No data between 2016-06-07 19:30:00 and 2016-06-07 20:00:00.\n",
      "No data between 2016-06-07 20:45:00 and 2016-06-07 21:30:00.\n",
      "No data between 2016-06-07 21:30:00 and 2016-06-07 22:15:00.\n",
      "No data between 2016-06-08 05:30:00 and 2016-06-08 06:00:00.\n",
      "No data between 2016-06-08 06:00:00 and 2016-06-08 07:30:00.\n",
      "No data between 2016-06-08 07:30:00 and 2016-06-08 08:00:00.\n",
      "No data between 2016-06-08 09:00:00 and 2016-06-08 10:15:00.\n",
      "No data between 2016-06-08 10:15:00 and 2016-06-08 10:45:00.\n",
      "No data between 2016-06-08 11:15:00 and 2016-06-08 12:00:00.\n",
      "No data between 2016-06-08 12:15:00 and 2016-06-08 12:45:00.\n",
      "No data between 2016-06-08 13:00:00 and 2016-06-08 13:30:00.\n",
      "No data between 2016-06-08 17:00:00 and 2016-06-08 17:30:00.\n",
      "No data between 2016-06-08 19:45:00 and 2016-06-08 20:15:00.\n",
      "No data between 2016-06-08 21:15:00 and 2016-06-08 21:45:00.\n",
      "No data between 2016-06-08 23:00:00 and 2016-06-08 23:30:00.\n",
      "No data between 2016-06-09 01:45:00 and 2016-06-09 02:15:00.\n",
      "No data between 2016-06-09 02:15:00 and 2016-06-09 02:45:00.\n",
      "No data between 2016-06-09 06:30:00 and 2016-06-09 07:00:00.\n",
      "No data between 2016-06-09 07:00:00 and 2016-06-09 07:30:00.\n",
      "No data between 2016-06-09 07:30:00 and 2016-06-09 08:15:00.\n",
      "No data between 2016-06-09 08:15:00 and 2016-06-09 08:45:00.\n",
      "No data between 2016-06-09 08:45:00 and 2016-06-09 09:45:00.\n",
      "No data between 2016-06-09 11:00:00 and 2016-06-09 11:30:00.\n",
      "No data between 2016-06-09 11:30:00 and 2016-06-09 12:15:00.\n",
      "No data between 2016-06-09 12:15:00 and 2016-06-09 12:45:00.\n",
      "No data between 2016-06-09 14:15:00 and 2016-06-09 14:45:00.\n",
      "No data between 2016-06-09 15:00:00 and 2016-06-09 15:30:00.\n",
      "No data between 2016-06-09 15:30:00 and 2016-06-09 16:00:00.\n",
      "No data between 2016-06-09 21:15:00 and 2016-06-09 21:45:00.\n",
      "No data between 2016-06-09 22:00:00 and 2016-06-09 22:30:00.\n",
      "No data between 2016-06-09 22:45:00 and 2016-06-09 23:15:00.\n",
      "No data between 2016-06-09 23:15:00 and 2016-06-10 00:00:00.\n",
      "No data between 2016-06-10 00:30:00 and 2016-06-10 01:15:00.\n",
      "No data between 2016-06-10 05:15:00 and 2016-06-10 06:00:00.\n",
      "No data between 2016-06-10 09:00:00 and 2016-06-10 09:30:00.\n",
      "No data between 2016-06-10 10:45:00 and 2016-06-10 11:45:00.\n",
      "No data between 2016-06-10 11:45:00 and 2016-06-10 12:15:00.\n",
      "No data between 2016-06-10 23:00:00 and 2016-06-10 23:30:00.\n",
      "No data between 2016-06-11 03:00:00 and 2016-06-11 03:30:00.\n",
      "No data between 2016-06-11 05:00:00 and 2016-06-11 05:30:00.\n",
      "No data between 2016-06-11 05:30:00 and 2016-06-11 06:00:00.\n",
      "No data between 2016-06-11 06:00:00 and 2016-06-11 07:00:00.\n",
      "No data between 2016-06-11 07:00:00 and 2016-06-11 08:00:00.\n",
      "No data between 2016-06-11 08:45:00 and 2016-06-11 09:15:00.\n",
      "No data between 2016-06-11 10:45:00 and 2016-06-11 11:15:00.\n",
      "No data between 2016-06-11 11:15:00 and 2016-06-11 12:30:00.\n",
      "No data between 2016-06-11 13:30:00 and 2016-06-11 14:00:00.\n",
      "No data between 2016-06-11 14:00:00 and 2016-06-11 14:30:00.\n",
      "No data between 2016-06-11 14:30:00 and 2016-06-11 15:00:00.\n",
      "No data between 2016-06-11 15:15:00 and 2016-06-11 15:45:00.\n",
      "No data between 2016-06-11 15:45:00 and 2016-06-11 16:15:00.\n",
      "No data between 2016-06-11 16:45:00 and 2016-06-11 17:15:00.\n",
      "No data between 2016-06-11 17:15:00 and 2016-06-11 17:45:00.\n",
      "No data between 2016-06-11 19:30:00 and 2016-06-11 20:00:00.\n",
      "No data between 2016-06-11 20:30:00 and 2016-06-11 21:00:00.\n",
      "No data between 2016-06-11 22:00:00 and 2016-06-11 22:30:00.\n",
      "No data between 2016-06-12 02:30:00 and 2016-06-12 03:00:00.\n",
      "No data between 2016-06-12 03:15:00 and 2016-06-12 03:45:00.\n",
      "No data between 2016-06-12 07:15:00 and 2016-06-12 07:45:00.\n",
      "No data between 2016-06-12 08:00:00 and 2016-06-12 09:00:00.\n",
      "No data between 2016-06-12 09:00:00 and 2016-06-12 09:30:00.\n",
      "No data between 2016-06-12 09:45:00 and 2016-06-12 10:15:00.\n",
      "No data between 2016-06-12 10:30:00 and 2016-06-12 11:00:00.\n",
      "No data between 2016-06-12 11:15:00 and 2016-06-12 12:00:00.\n",
      "No data between 2016-06-12 21:00:00 and 2016-06-12 21:30:00.\n",
      "No data between 2016-06-13 04:30:00 and 2016-06-13 05:00:00.\n",
      "No data between 2016-06-13 09:30:00 and 2016-06-13 10:15:00.\n",
      "No data between 2016-06-13 10:45:00 and 2016-06-13 11:15:00.\n",
      "No data between 2016-06-14 07:45:00 and 2016-06-14 09:00:00.\n",
      "No data between 2016-06-14 09:00:00 and 2016-06-14 10:15:00.\n",
      "No data between 2016-06-14 10:30:00 and 2016-06-14 11:00:00.\n",
      "No data between 2016-06-14 12:45:00 and 2016-06-14 13:15:00.\n",
      "No data between 2016-06-15 05:15:00 and 2016-06-15 05:45:00.\n",
      "No data between 2016-06-15 06:15:00 and 2016-06-15 06:45:00.\n",
      "No data between 2016-06-15 07:00:00 and 2016-06-15 07:45:00.\n",
      "No data between 2016-06-15 08:15:00 and 2016-06-15 08:45:00.\n",
      "No data between 2016-06-15 09:30:00 and 2016-06-15 10:00:00.\n",
      "No data between 2016-06-15 10:15:00 and 2016-06-15 10:45:00.\n",
      "No data between 2016-06-15 10:45:00 and 2016-06-15 11:15:00.\n",
      "No data between 2016-06-15 14:15:00 and 2016-06-15 14:45:00.\n",
      "No data between 2016-06-16 06:45:00 and 2016-06-16 07:30:00.\n",
      "No data between 2016-06-16 07:30:00 and 2016-06-16 09:00:00.\n",
      "No data between 2016-06-16 10:45:00 and 2016-06-16 11:30:00.\n",
      "No data between 2016-06-17 01:45:00 and 2016-06-17 02:15:00.\n",
      "No data between 2016-06-18 03:30:00 and 2016-06-18 04:00:00.\n",
      "No data between 2016-06-18 11:00:00 and 2016-06-18 11:30:00.\n",
      "No data between 2016-06-19 08:00:00 and 2016-06-19 09:00:00.\n",
      "No data between 2016-06-19 09:00:00 and 2016-06-19 09:30:00.\n",
      "No data between 2016-06-19 09:30:00 and 2016-06-19 10:30:00.\n",
      "No data between 2016-06-19 11:15:00 and 2016-06-19 12:00:00.\n",
      "No data between 2016-06-19 12:45:00 and 2016-06-19 13:30:00.\n",
      "No data between 2016-06-19 14:15:00 and 2016-06-19 14:45:00.\n",
      "No data between 2016-06-19 20:45:00 and 2016-06-19 21:15:00.\n",
      "No data between 2016-06-20 00:45:00 and 2016-06-20 01:15:00.\n",
      "No data between 2016-06-20 02:15:00 and 2016-06-20 02:45:00.\n",
      "No data between 2016-06-20 03:15:00 and 2016-06-20 03:45:00.\n",
      "No data between 2016-06-20 07:45:00 and 2016-06-20 08:15:00.\n",
      "No data between 2016-06-20 09:30:00 and 2016-06-20 10:00:00.\n",
      "No data between 2016-06-20 19:45:00 and 2016-06-20 20:15:00.\n",
      "No data between 2016-06-20 21:30:00 and 2016-06-20 22:00:00.\n",
      "No data between 2016-06-21 05:45:00 and 2016-06-21 06:15:00.\n",
      "No data between 2016-06-21 06:30:00 and 2016-06-21 07:00:00.\n",
      "No data between 2016-06-21 08:15:00 and 2016-06-21 08:45:00.\n",
      "No data between 2016-06-21 09:00:00 and 2016-06-21 09:45:00.\n",
      "No data between 2016-06-21 09:45:00 and 2016-06-21 10:30:00.\n",
      "No data between 2016-06-21 11:15:00 and 2016-06-21 11:45:00.\n",
      "No data between 2016-06-22 07:30:00 and 2016-06-22 08:00:00.\n",
      "No data between 2016-06-22 08:15:00 and 2016-06-22 08:45:00.\n",
      "No data between 2016-06-22 09:00:00 and 2016-06-22 09:30:00.\n",
      "No data between 2016-06-22 10:15:00 and 2016-06-22 10:45:00.\n",
      "No data between 2016-06-22 18:00:00 and 2016-06-22 18:30:00.\n",
      "No data between 2016-06-23 07:15:00 and 2016-06-23 07:45:00.\n",
      "No data between 2016-06-23 07:45:00 and 2016-06-23 08:15:00.\n",
      "No data between 2016-06-23 09:45:00 and 2016-06-23 10:15:00.\n",
      "No data between 2016-06-23 10:15:00 and 2016-06-23 10:45:00.\n",
      "No data between 2016-06-23 10:45:00 and 2016-06-23 11:15:00.\n",
      "No data between 2016-06-23 12:15:00 and 2016-06-23 12:45:00.\n",
      "No data between 2016-06-23 14:00:00 and 2016-06-23 14:30:00.\n",
      "No data between 2016-06-24 09:30:00 and 2016-06-24 10:00:00.\n",
      "No data between 2016-06-25 02:00:00 and 2016-06-25 02:30:00.\n",
      "No data between 2016-06-25 05:30:00 and 2016-06-25 06:00:00.\n",
      "No data between 2016-06-25 07:45:00 and 2016-06-25 08:15:00.\n",
      "No data between 2016-06-25 09:45:00 and 2016-06-25 10:30:00.\n",
      "No data between 2016-06-25 12:00:00 and 2016-06-25 12:45:00.\n",
      "No data between 2016-06-25 12:45:00 and 2016-06-25 13:15:00.\n",
      "No data between 2016-06-25 17:45:00 and 2016-06-25 18:15:00.\n",
      "No data between 2016-06-25 20:30:00 and 2016-06-25 21:00:00.\n",
      "No data between 2016-06-25 21:00:00 and 2016-06-25 21:30:00.\n",
      "No data between 2016-06-25 23:30:00 and 2016-06-26 00:30:00.\n",
      "No data between 2016-06-26 00:30:00 and 2016-06-26 01:00:00.\n",
      "No data between 2016-06-26 02:45:00 and 2016-06-26 03:15:00.\n",
      "No data between 2016-06-26 05:30:00 and 2016-06-26 06:15:00.\n",
      "No data between 2016-06-26 06:30:00 and 2016-06-26 07:00:00.\n",
      "No data between 2016-06-26 07:00:00 and 2016-06-26 09:15:00.\n",
      "No data between 2016-06-26 09:15:00 and 2016-06-26 09:45:00.\n",
      "No data between 2016-06-26 09:45:00 and 2016-06-26 10:15:00.\n",
      "No data between 2016-06-26 10:15:00 and 2016-06-26 10:45:00.\n",
      "No data between 2016-06-26 11:00:00 and 2016-06-26 11:30:00.\n",
      "No data between 2016-06-26 11:30:00 and 2016-06-26 12:15:00.\n",
      "No data between 2016-06-26 12:45:00 and 2016-06-26 13:15:00.\n",
      "No data between 2016-06-26 16:00:00 and 2016-06-26 16:30:00.\n",
      "No data between 2016-06-26 17:45:00 and 2016-06-26 18:15:00.\n",
      "No data between 2016-06-26 20:45:00 and 2016-06-26 21:15:00.\n",
      "No data between 2016-06-26 21:15:00 and 2016-06-26 21:45:00.\n",
      "No data between 2016-06-26 22:00:00 and 2016-06-26 22:30:00.\n",
      "No data between 2016-06-26 22:30:00 and 2016-06-26 23:45:00.\n",
      "No data between 2016-06-26 23:45:00 and 2016-06-27 00:30:00.\n",
      "No data between 2016-06-27 01:15:00 and 2016-06-27 01:45:00.\n",
      "No data between 2016-06-27 02:45:00 and 2016-06-27 03:15:00.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No data between 2016-06-27 03:15:00 and 2016-06-27 04:15:00.\n",
      "No data between 2016-06-27 04:15:00 and 2016-06-27 04:45:00.\n",
      "No data between 2016-06-27 05:00:00 and 2016-06-27 06:15:00.\n",
      "No data between 2016-06-27 07:00:00 and 2016-06-27 07:30:00.\n",
      "No data between 2016-06-27 07:30:00 and 2016-06-27 08:15:00.\n",
      "No data between 2016-06-27 09:00:00 and 2016-06-27 10:00:00.\n",
      "No data between 2016-06-27 11:00:00 and 2016-06-27 11:30:00.\n",
      "No data between 2016-06-27 11:30:00 and 2016-06-27 12:00:00.\n",
      "No data between 2016-06-27 12:45:00 and 2016-06-27 13:30:00.\n",
      "No data between 2016-06-27 21:00:00 and 2016-06-27 21:30:00.\n",
      "No data between 2016-06-27 23:15:00 and 2016-06-27 23:45:00.\n",
      "No data between 2016-06-28 01:15:00 and 2016-06-28 02:00:00.\n",
      "No data between 2016-06-28 02:00:00 and 2016-06-28 02:30:00.\n",
      "No data between 2016-06-28 04:00:00 and 2016-06-28 04:30:00.\n",
      "No data between 2016-06-28 05:00:00 and 2016-06-28 05:30:00.\n",
      "No data between 2016-06-28 07:30:00 and 2016-06-28 08:45:00.\n",
      "No data between 2016-06-28 08:45:00 and 2016-06-28 09:45:00.\n",
      "No data between 2016-06-28 09:45:00 and 2016-06-28 10:15:00.\n",
      "No data between 2016-06-28 11:30:00 and 2016-06-28 12:15:00.\n",
      "No data between 2016-06-29 02:45:00 and 2016-06-29 03:15:00.\n",
      "No data between 2016-06-29 06:15:00 and 2016-06-29 06:45:00.\n",
      "No data between 2016-06-29 06:45:00 and 2016-06-29 08:15:00.\n",
      "No data between 2016-06-29 10:30:00 and 2016-06-29 11:00:00.\n",
      "No data between 2016-06-29 11:00:00 and 2016-06-29 11:45:00.\n",
      "No data between 2016-06-29 18:45:00 and 2016-06-29 19:15:00.\n",
      "No data between 2016-06-29 21:00:00 and 2016-06-29 21:30:00.\n",
      "No data between 2016-06-30 00:15:00 and 2016-06-30 00:45:00.\n",
      "No data between 2016-06-30 01:15:00 and 2016-06-30 02:00:00.\n",
      "No data between 2016-06-30 02:30:00 and 2016-06-30 03:00:00.\n",
      "No data between 2016-06-30 03:30:00 and 2016-06-30 04:00:00.\n",
      "No data between 2016-06-30 04:30:00 and 2016-06-30 05:00:00.\n",
      "No data between 2016-06-30 05:30:00 and 2016-06-30 07:15:00.\n",
      "No data between 2016-06-30 08:15:00 and 2016-06-30 09:00:00.\n",
      "No data between 2016-06-30 09:00:00 and 2016-06-30 09:30:00.\n",
      "No data between 2016-06-30 10:45:00 and 2016-06-30 11:30:00.\n",
      "No data between 2016-06-30 12:15:00 and 2016-06-30 12:45:00.\n",
      "No data between 2016-06-30 15:15:00 and 2016-06-30 15:45:00.\n",
      "No data between 2016-06-30 16:30:00 and 2016-06-30 17:00:00.\n",
      "No data between 2016-06-30 21:00:00 and 2016-06-30 21:30:00.\n",
      "No data between 2016-06-30 22:30:00 and 2016-06-30 23:00:00.\n",
      "No data between 2016-07-01 01:15:00 and 2016-07-01 01:45:00.\n",
      "No data between 2016-07-01 01:45:00 and 2016-07-01 02:15:00.\n",
      "No data between 2016-07-01 02:15:00 and 2016-07-01 02:45:00.\n",
      "No data between 2016-07-01 03:45:00 and 2016-07-01 04:30:00.\n",
      "No data between 2016-07-01 04:45:00 and 2016-07-01 05:45:00.\n",
      "No data between 2016-07-01 05:45:00 and 2016-07-01 06:15:00.\n",
      "No data between 2016-07-01 08:00:00 and 2016-07-01 08:30:00.\n",
      "No data between 2016-07-01 08:45:00 and 2016-07-01 09:30:00.\n",
      "No data between 2016-07-01 09:30:00 and 2016-07-01 10:00:00.\n",
      "No data between 2016-07-01 11:00:00 and 2016-07-01 11:30:00.\n",
      "No data between 2016-07-01 18:45:00 and 2016-07-01 19:15:00.\n",
      "No data between 2016-07-01 20:45:00 and 2016-07-01 21:15:00.\n",
      "No data between 2016-07-01 21:30:00 and 2016-07-01 22:00:00.\n",
      "No data between 2016-07-01 22:45:00 and 2016-07-01 23:30:00.\n",
      "No data between 2016-07-02 03:00:00 and 2016-07-02 03:30:00.\n",
      "No data between 2016-07-02 03:30:00 and 2016-07-02 04:15:00.\n",
      "No data between 2016-07-02 05:30:00 and 2016-07-02 06:15:00.\n",
      "No data between 2016-07-02 06:15:00 and 2016-07-02 06:45:00.\n",
      "No data between 2016-07-02 06:45:00 and 2016-07-02 07:45:00.\n",
      "No data between 2016-07-02 07:45:00 and 2016-07-02 10:30:00.\n",
      "No data between 2016-07-02 10:30:00 and 2016-07-02 11:15:00.\n",
      "No data between 2016-07-02 11:30:00 and 2016-07-02 12:00:00.\n",
      "No data between 2016-07-02 12:00:00 and 2016-07-02 12:30:00.\n",
      "No data between 2016-07-02 13:30:00 and 2016-07-02 14:15:00.\n",
      "No data between 2016-07-02 14:30:00 and 2016-07-02 15:00:00.\n",
      "No data between 2016-07-02 15:45:00 and 2016-07-02 16:15:00.\n",
      "No data between 2016-07-02 19:00:00 and 2016-07-02 20:30:00.\n",
      "No data between 2016-07-02 20:30:00 and 2016-07-02 21:00:00.\n",
      "No data between 2016-07-02 21:15:00 and 2016-07-02 21:45:00.\n",
      "No data between 2016-07-02 22:00:00 and 2016-07-02 22:30:00.\n",
      "No data between 2016-07-02 22:30:00 and 2016-07-02 23:00:00.\n",
      "No data between 2016-07-02 23:00:00 and 2016-07-02 23:30:00.\n",
      "No data between 2016-07-03 00:15:00 and 2016-07-03 01:00:00.\n",
      "No data between 2016-07-03 03:00:00 and 2016-07-03 03:30:00.\n",
      "No data between 2016-07-03 03:30:00 and 2016-07-03 04:00:00.\n",
      "No data between 2016-07-03 04:15:00 and 2016-07-03 04:45:00.\n",
      "No data between 2016-07-03 04:45:00 and 2016-07-03 06:00:00.\n",
      "No data between 2016-07-03 06:00:00 and 2016-07-03 06:30:00.\n",
      "No data between 2016-07-03 06:30:00 and 2016-07-03 07:15:00.\n",
      "No data between 2016-07-03 07:15:00 and 2016-07-03 08:15:00.\n",
      "No data between 2016-07-03 08:15:00 and 2016-07-03 08:45:00.\n",
      "No data between 2016-07-03 09:00:00 and 2016-07-03 09:30:00.\n",
      "No data between 2016-07-03 10:30:00 and 2016-07-03 11:15:00.\n",
      "No data between 2016-07-03 11:15:00 and 2016-07-03 12:30:00.\n",
      "No data between 2016-07-03 13:15:00 and 2016-07-03 14:00:00.\n",
      "No data between 2016-07-03 17:45:00 and 2016-07-03 18:15:00.\n",
      "No data between 2016-07-03 19:30:00 and 2016-07-03 20:15:00.\n",
      "No data between 2016-07-03 20:45:00 and 2016-07-03 21:15:00.\n",
      "No data between 2016-07-03 21:15:00 and 2016-07-03 21:45:00.\n",
      "No data between 2016-07-03 21:45:00 and 2016-07-03 22:30:00.\n",
      "No data between 2016-07-03 22:30:00 and 2016-07-03 23:15:00.\n",
      "No data between 2016-07-04 00:00:00 and 2016-07-04 01:15:00.\n",
      "No data between 2016-07-04 01:30:00 and 2016-07-04 02:00:00.\n",
      "No data between 2016-07-04 02:00:00 and 2016-07-04 02:30:00.\n",
      "No data between 2016-07-04 02:30:00 and 2016-07-04 03:15:00.\n",
      "No data between 2016-07-04 04:15:00 and 2016-07-04 04:45:00.\n",
      "No data between 2016-07-04 04:45:00 and 2016-07-04 05:45:00.\n",
      "No data between 2016-07-04 05:45:00 and 2016-07-04 07:30:00.\n",
      "No data between 2016-07-04 08:15:00 and 2016-07-04 08:45:00.\n",
      "No data between 2016-07-04 09:30:00 and 2016-07-04 10:30:00.\n",
      "No data between 2016-07-04 10:30:00 and 2016-07-04 12:00:00.\n",
      "No data between 2016-07-04 14:00:00 and 2016-07-04 14:45:00.\n",
      "No data between 2016-07-04 15:45:00 and 2016-07-04 16:15:00.\n",
      "No data between 2016-07-04 17:45:00 and 2016-07-04 18:15:00.\n",
      "No data between 2016-07-04 18:45:00 and 2016-07-04 19:15:00.\n",
      "No data between 2016-07-04 19:15:00 and 2016-07-04 19:45:00.\n",
      "No data between 2016-07-04 19:45:00 and 2016-07-04 21:00:00.\n",
      "No data between 2016-07-04 23:00:00 and 2016-07-04 23:30:00.\n",
      "No data between 2016-07-05 00:00:00 and 2016-07-05 00:30:00.\n",
      "No data between 2016-07-05 01:00:00 and 2016-07-05 01:30:00.\n",
      "No data between 2016-07-05 01:30:00 and 2016-07-05 02:15:00.\n",
      "No data between 2016-07-05 02:30:00 and 2016-07-05 03:00:00.\n",
      "No data between 2016-07-05 03:15:00 and 2016-07-05 04:00:00.\n",
      "No data between 2016-07-05 04:45:00 and 2016-07-05 05:15:00.\n",
      "No data between 2016-07-05 05:15:00 and 2016-07-05 05:45:00.\n",
      "No data between 2016-07-05 05:45:00 and 2016-07-05 06:15:00.\n",
      "No data between 2016-07-05 07:30:00 and 2016-07-05 08:15:00.\n",
      "No data between 2016-07-06 01:45:00 and 2016-07-06 03:30:00.\n",
      "No data between 2016-07-06 03:30:00 and 2016-07-06 04:30:00.\n",
      "No data between 2016-07-06 04:45:00 and 2016-07-06 05:30:00.\n",
      "No data between 2016-07-06 06:00:00 and 2016-07-06 06:45:00.\n",
      "No data between 2016-07-06 06:45:00 and 2016-07-06 07:15:00.\n",
      "No data between 2016-07-06 07:15:00 and 2016-07-06 07:45:00.\n",
      "No data between 2016-07-06 08:15:00 and 2016-07-06 09:00:00.\n",
      "No data between 2016-07-06 09:30:00 and 2016-07-06 10:15:00.\n",
      "No data between 2016-07-06 10:15:00 and 2016-07-06 11:15:00.\n",
      "No data between 2016-07-06 11:15:00 and 2016-07-06 12:00:00.\n",
      "No data between 2016-07-06 12:15:00 and 2016-07-06 13:00:00.\n",
      "No data between 2016-07-06 13:15:00 and 2016-07-06 14:00:00.\n",
      "No data between 2016-07-06 19:45:00 and 2016-07-06 20:15:00.\n",
      "No data between 2016-07-06 20:45:00 and 2016-07-06 21:15:00.\n",
      "No data between 2016-07-06 23:15:00 and 2016-07-06 23:45:00.\n",
      "No data between 2016-07-07 02:30:00 and 2016-07-07 03:00:00.\n",
      "No data between 2016-07-07 08:30:00 and 2016-07-07 09:30:00.\n",
      "No data between 2016-07-07 10:00:00 and 2016-07-07 10:30:00.\n",
      "No data between 2016-07-07 10:30:00 and 2016-07-07 11:00:00.\n",
      "No data between 2016-07-07 11:45:00 and 2016-07-07 12:30:00.\n",
      "No data between 2016-07-07 12:30:00 and 2016-07-07 13:00:00.\n",
      "No data between 2016-07-07 15:45:00 and 2016-07-07 16:15:00.\n",
      "No data between 2016-07-07 19:00:00 and 2016-07-07 19:30:00.\n",
      "No data between 2016-07-07 20:45:00 and 2016-07-07 21:15:00.\n",
      "No data between 2016-07-07 22:30:00 and 2016-07-07 23:00:00.\n",
      "No data between 2016-07-07 23:15:00 and 2016-07-07 23:45:00.\n",
      "No data between 2016-07-08 00:15:00 and 2016-07-08 00:45:00.\n",
      "No data between 2016-07-08 01:15:00 and 2016-07-08 01:45:00.\n",
      "No data between 2016-07-08 03:00:00 and 2016-07-08 03:30:00.\n",
      "No data between 2016-07-08 03:45:00 and 2016-07-08 04:45:00.\n",
      "No data between 2016-07-08 04:45:00 and 2016-07-08 05:15:00.\n",
      "No data between 2016-07-08 06:15:00 and 2016-07-08 07:45:00.\n",
      "No data between 2016-07-08 08:15:00 and 2016-07-08 10:00:00.\n",
      "No data between 2016-07-08 10:00:00 and 2016-07-08 11:30:00.\n",
      "No data between 2016-07-08 14:00:00 and 2016-07-08 14:30:00.\n",
      "No data between 2016-07-08 15:30:00 and 2016-07-08 16:00:00.\n",
      "No data between 2016-07-08 16:45:00 and 2016-07-08 17:15:00.\n",
      "No data between 2016-07-08 18:00:00 and 2016-07-08 18:30:00.\n",
      "No data between 2016-07-08 23:30:00 and 2016-07-09 00:00:00.\n",
      "No data between 2016-07-09 00:45:00 and 2016-07-09 01:15:00.\n",
      "No data between 2016-07-09 01:15:00 and 2016-07-09 01:45:00.\n",
      "No data between 2016-07-09 02:00:00 and 2016-07-09 02:30:00.\n",
      "No data between 2016-07-09 04:00:00 and 2016-07-09 04:30:00.\n",
      "No data between 2016-07-09 05:00:00 and 2016-07-09 05:30:00.\n",
      "No data between 2016-07-09 06:00:00 and 2016-07-09 06:45:00.\n",
      "No data between 2016-07-09 06:45:00 and 2016-07-09 08:15:00.\n",
      "No data between 2016-07-09 08:15:00 and 2016-07-09 08:45:00.\n",
      "No data between 2016-07-09 08:45:00 and 2016-07-09 09:45:00.\n",
      "No data between 2016-07-09 10:00:00 and 2016-07-09 11:45:00.\n",
      "No data between 2016-07-09 12:00:00 and 2016-07-09 12:30:00.\n",
      "No data between 2016-07-09 12:45:00 and 2016-07-09 13:15:00.\n",
      "No data between 2016-07-09 13:45:00 and 2016-07-09 14:15:00.\n",
      "No data between 2016-07-09 15:15:00 and 2016-07-09 16:00:00.\n",
      "No data between 2016-07-09 16:30:00 and 2016-07-09 17:15:00.\n",
      "No data between 2016-07-09 17:30:00 and 2016-07-09 18:00:00.\n",
      "No data between 2016-07-09 18:00:00 and 2016-07-09 18:45:00.\n",
      "No data between 2016-07-09 18:45:00 and 2016-07-09 19:30:00.\n",
      "No data between 2016-07-09 20:00:00 and 2016-07-09 20:45:00.\n",
      "No data between 2016-07-09 22:45:00 and 2016-07-09 23:15:00.\n",
      "No data between 2016-07-09 23:15:00 and 2016-07-09 23:45:00.\n",
      "No data between 2016-07-10 02:15:00 and 2016-07-10 02:45:00.\n",
      "No data between 2016-07-10 03:30:00 and 2016-07-10 04:00:00.\n",
      "No data between 2016-07-10 04:30:00 and 2016-07-10 06:45:00.\n",
      "No data between 2016-07-10 06:45:00 and 2016-07-10 07:30:00.\n",
      "No data between 2016-07-10 07:30:00 and 2016-07-10 08:00:00.\n",
      "No data between 2016-07-10 08:30:00 and 2016-07-10 09:30:00.\n",
      "No data between 2016-07-10 10:00:00 and 2016-07-10 13:00:00.\n",
      "No data between 2016-07-10 13:00:00 and 2016-07-10 14:00:00.\n",
      "No data between 2016-07-10 14:00:00 and 2016-07-10 14:30:00.\n",
      "No data between 2016-07-10 15:00:00 and 2016-07-10 15:30:00.\n",
      "No data between 2016-07-10 16:30:00 and 2016-07-10 17:00:00.\n",
      "No data between 2016-07-10 17:00:00 and 2016-07-10 17:30:00.\n",
      "No data between 2016-07-10 17:45:00 and 2016-07-10 18:15:00.\n",
      "No data between 2016-07-10 20:00:00 and 2016-07-10 20:30:00.\n",
      "No data between 2016-07-10 21:00:00 and 2016-07-10 22:00:00.\n",
      "No data between 2016-07-10 22:00:00 and 2016-07-10 23:00:00.\n",
      "No data between 2016-07-10 23:15:00 and 2016-07-11 00:00:00.\n",
      "No data between 2016-07-11 00:00:00 and 2016-07-11 00:30:00.\n",
      "No data between 2016-07-11 00:30:00 and 2016-07-11 01:00:00.\n",
      "No data between 2016-07-11 02:00:00 and 2016-07-11 02:45:00.\n",
      "No data between 2016-07-11 03:15:00 and 2016-07-11 04:15:00.\n",
      "No data between 2016-07-11 04:15:00 and 2016-07-11 05:00:00.\n",
      "No data between 2016-07-11 05:15:00 and 2016-07-11 06:00:00.\n",
      "No data between 2016-07-11 07:15:00 and 2016-07-11 08:15:00.\n",
      "No data between 2016-07-11 09:00:00 and 2016-07-11 09:45:00.\n",
      "No data between 2016-07-11 12:30:00 and 2016-07-11 13:00:00.\n",
      "No data between 2016-07-11 13:30:00 and 2016-07-11 14:15:00.\n",
      "No data between 2016-07-11 18:00:00 and 2016-07-11 18:30:00.\n",
      "No data between 2016-07-11 19:00:00 and 2016-07-11 19:30:00.\n",
      "No data between 2016-07-11 20:30:00 and 2016-07-11 21:30:00.\n",
      "No data between 2016-07-11 21:30:00 and 2016-07-11 22:00:00.\n",
      "No data between 2016-07-11 22:30:00 and 2016-07-11 23:00:00.\n",
      "No data between 2016-07-12 04:00:00 and 2016-07-12 04:30:00.\n",
      "No data between 2016-07-12 04:30:00 and 2016-07-12 05:15:00.\n",
      "No data between 2016-07-12 07:45:00 and 2016-07-12 08:15:00.\n",
      "No data between 2016-07-12 08:15:00 and 2016-07-12 09:00:00.\n",
      "No data between 2016-07-12 09:00:00 and 2016-07-12 10:00:00.\n",
      "No data between 2016-07-12 10:15:00 and 2016-07-12 10:45:00.\n",
      "No data between 2016-07-12 11:00:00 and 2016-07-12 12:00:00.\n",
      "No data between 2016-07-12 12:00:00 and 2016-07-12 13:00:00.\n",
      "No data between 2016-07-12 13:00:00 and 2016-07-12 13:30:00.\n",
      "No data between 2016-07-12 14:15:00 and 2016-07-12 14:45:00.\n",
      "No data between 2016-07-12 18:15:00 and 2016-07-12 19:00:00.\n",
      "No data between 2016-07-13 01:00:00 and 2016-07-13 03:00:00.\n",
      "No data between 2016-07-13 03:15:00 and 2016-07-13 04:30:00.\n",
      "No data between 2016-07-13 04:45:00 and 2016-07-13 05:15:00.\n",
      "No data between 2016-07-13 05:30:00 and 2016-07-13 06:30:00.\n",
      "No data between 2016-07-13 06:30:00 and 2016-07-13 07:00:00.\n",
      "No data between 2016-07-13 07:15:00 and 2016-07-13 09:15:00.\n",
      "No data between 2016-07-13 09:15:00 and 2016-07-13 11:00:00.\n",
      "No data between 2016-07-13 11:00:00 and 2016-07-13 13:30:00.\n",
      "No data between 2016-07-13 14:00:00 and 2016-07-13 15:00:00.\n",
      "No data between 2016-07-13 15:00:00 and 2016-07-13 15:30:00.\n",
      "No data between 2016-07-13 15:30:00 and 2016-07-13 16:15:00.\n",
      "No data between 2016-07-13 16:30:00 and 2016-07-13 17:00:00.\n",
      "No data between 2016-07-13 17:00:00 and 2016-07-13 17:30:00.\n",
      "No data between 2016-07-13 17:30:00 and 2016-07-13 18:00:00.\n",
      "No data between 2016-07-13 20:45:00 and 2016-07-13 22:15:00.\n",
      "No data between 2016-07-13 22:15:00 and 2016-07-13 22:45:00.\n",
      "No data between 2016-07-13 23:15:00 and 2016-07-13 23:45:00.\n",
      "No data between 2016-07-14 04:45:00 and 2016-07-14 05:45:00.\n",
      "No data between 2016-07-14 05:45:00 and 2016-07-14 06:15:00.\n",
      "No data between 2016-07-14 07:15:00 and 2016-07-14 07:45:00.\n",
      "No data between 2016-07-14 09:15:00 and 2016-07-14 10:15:00.\n",
      "No data between 2016-07-14 10:15:00 and 2016-07-14 12:15:00.\n",
      "No data between 2016-07-14 12:45:00 and 2016-07-14 13:15:00.\n",
      "No data between 2016-07-14 13:30:00 and 2016-07-14 14:00:00.\n",
      "No data between 2016-07-14 14:15:00 and 2016-07-14 15:00:00.\n",
      "No data between 2016-07-14 15:00:00 and 2016-07-14 15:30:00.\n",
      "No data between 2016-07-14 23:45:00 and 2016-07-15 00:15:00.\n",
      "No data between 2016-07-15 01:45:00 and 2016-07-15 02:15:00.\n",
      "No data between 2016-07-15 05:30:00 and 2016-07-15 06:00:00.\n",
      "No data between 2016-07-15 07:15:00 and 2016-07-15 08:00:00.\n",
      "No data between 2016-07-15 08:15:00 and 2016-07-15 09:00:00.\n",
      "No data between 2016-07-15 09:45:00 and 2016-07-15 10:15:00.\n",
      "No data between 2016-07-15 15:45:00 and 2016-07-15 16:15:00.\n",
      "No data between 2016-07-15 18:15:00 and 2016-07-15 18:45:00.\n",
      "No data between 2016-07-16 00:15:00 and 2016-07-16 00:45:00.\n",
      "No data between 2016-07-16 02:00:00 and 2016-07-16 02:30:00.\n",
      "No data between 2016-07-16 05:30:00 and 2016-07-16 06:00:00.\n",
      "No data between 2016-07-16 06:15:00 and 2016-07-16 06:45:00.\n",
      "No data between 2016-07-16 07:45:00 and 2016-07-16 08:30:00.\n",
      "No data between 2016-07-16 08:30:00 and 2016-07-16 09:30:00.\n",
      "No data between 2016-07-16 09:30:00 and 2016-07-16 10:00:00.\n",
      "No data between 2016-07-16 10:00:00 and 2016-07-16 11:00:00.\n",
      "No data between 2016-07-16 11:15:00 and 2016-07-16 11:45:00.\n",
      "No data between 2016-07-16 11:45:00 and 2016-07-16 12:15:00.\n",
      "No data between 2016-07-16 13:00:00 and 2016-07-16 14:15:00.\n",
      "No data between 2016-07-16 15:00:00 and 2016-07-16 15:30:00.\n",
      "No data between 2016-07-16 15:30:00 and 2016-07-16 16:00:00.\n",
      "No data between 2016-07-16 18:15:00 and 2016-07-16 18:45:00.\n",
      "No data between 2016-07-16 19:45:00 and 2016-07-16 20:15:00.\n",
      "No data between 2016-07-16 21:00:00 and 2016-07-16 21:30:00.\n",
      "No data between 2016-07-16 23:30:00 and 2016-07-17 00:15:00.\n",
      "No data between 2016-07-17 03:00:00 and 2016-07-17 03:30:00.\n",
      "No data between 2016-07-17 07:15:00 and 2016-07-17 08:00:00.\n",
      "No data between 2016-07-17 08:00:00 and 2016-07-17 08:30:00.\n",
      "No data between 2016-07-17 08:30:00 and 2016-07-17 09:30:00.\n",
      "No data between 2016-07-17 09:30:00 and 2016-07-17 10:00:00.\n",
      "No data between 2016-07-17 10:00:00 and 2016-07-17 12:00:00.\n",
      "No data between 2016-07-17 13:30:00 and 2016-07-17 14:00:00.\n",
      "No data between 2016-07-17 14:00:00 and 2016-07-17 14:30:00.\n",
      "No data between 2016-07-17 16:45:00 and 2016-07-17 17:30:00.\n",
      "No data between 2016-07-17 22:30:00 and 2016-07-17 23:00:00.\n",
      "No data between 2016-07-17 23:45:00 and 2016-07-18 00:15:00.\n",
      "No data between 2016-07-18 00:45:00 and 2016-07-18 01:15:00.\n",
      "No data between 2016-07-18 01:15:00 and 2016-07-18 01:45:00.\n",
      "No data between 2016-07-18 04:15:00 and 2016-07-18 05:15:00.\n",
      "No data between 2016-07-18 05:15:00 and 2016-07-18 05:45:00.\n",
      "No data between 2016-07-18 05:45:00 and 2016-07-18 06:15:00.\n",
      "No data between 2016-07-18 07:30:00 and 2016-07-18 08:15:00.\n",
      "No data between 2016-07-18 08:15:00 and 2016-07-18 08:45:00.\n",
      "No data between 2016-07-18 08:45:00 and 2016-07-18 09:30:00.\n",
      "No data between 2016-07-18 10:15:00 and 2016-07-18 11:15:00.\n",
      "No data between 2016-07-18 11:30:00 and 2016-07-18 12:00:00.\n",
      "No data between 2016-07-18 12:00:00 and 2016-07-18 13:00:00.\n",
      "No data between 2016-07-18 16:00:00 and 2016-07-18 16:30:00.\n",
      "No data between 2016-07-18 17:00:00 and 2016-07-18 17:30:00.\n",
      "No data between 2016-07-18 18:45:00 and 2016-07-18 19:30:00.\n",
      "No data between 2016-07-18 20:45:00 and 2016-07-18 21:15:00.\n",
      "No data between 2016-07-18 21:15:00 and 2016-07-18 21:45:00.\n",
      "No data between 2016-07-19 00:15:00 and 2016-07-19 00:45:00.\n",
      "No data between 2016-07-19 02:30:00 and 2016-07-19 03:00:00.\n",
      "No data between 2016-07-19 04:15:00 and 2016-07-19 04:45:00.\n",
      "No data between 2016-07-19 04:45:00 and 2016-07-19 05:15:00.\n",
      "No data between 2016-07-19 06:15:00 and 2016-07-19 06:45:00.\n",
      "No data between 2016-07-19 06:45:00 and 2016-07-19 07:15:00.\n",
      "No data between 2016-07-19 07:15:00 and 2016-07-19 08:00:00.\n",
      "No data between 2016-07-19 08:00:00 and 2016-07-19 09:00:00.\n",
      "No data between 2016-07-19 09:00:00 and 2016-07-19 09:30:00.\n",
      "No data between 2016-07-19 09:30:00 and 2016-07-19 10:00:00.\n",
      "No data between 2016-07-19 10:00:00 and 2016-07-19 10:45:00.\n",
      "No data between 2016-07-19 10:45:00 and 2016-07-19 11:45:00.\n",
      "No data between 2016-07-19 12:00:00 and 2016-07-19 12:30:00.\n",
      "No data between 2016-07-19 13:00:00 and 2016-07-19 14:00:00.\n",
      "No data between 2016-07-19 14:15:00 and 2016-07-19 15:00:00.\n",
      "No data between 2016-07-19 15:00:00 and 2016-07-19 15:30:00.\n",
      "No data between 2016-07-19 15:30:00 and 2016-07-19 16:00:00.\n",
      "No data between 2016-07-19 17:15:00 and 2016-07-19 17:45:00.\n",
      "No data between 2016-07-20 02:30:00 and 2016-07-20 03:00:00.\n",
      "No data between 2016-07-20 06:15:00 and 2016-07-20 06:45:00.\n",
      "No data between 2016-07-20 07:15:00 and 2016-07-20 07:45:00.\n",
      "No data between 2016-07-20 07:45:00 and 2016-07-20 08:30:00.\n",
      "No data between 2016-07-20 08:45:00 and 2016-07-20 10:15:00.\n",
      "No data between 2016-07-20 10:15:00 and 2016-07-20 10:45:00.\n",
      "No data between 2016-07-21 03:00:00 and 2016-07-21 03:30:00.\n",
      "No data between 2016-07-21 04:00:00 and 2016-07-21 04:30:00.\n",
      "No data between 2016-07-21 05:15:00 and 2016-07-21 05:45:00.\n",
      "No data between 2016-07-21 07:00:00 and 2016-07-21 07:30:00.\n",
      "No data between 2016-07-21 07:30:00 and 2016-07-21 08:00:00.\n",
      "No data between 2016-07-21 08:00:00 and 2016-07-21 08:30:00.\n",
      "No data between 2016-07-21 09:00:00 and 2016-07-21 09:30:00.\n",
      "No data between 2016-07-21 10:15:00 and 2016-07-21 10:45:00.\n",
      "No data between 2016-07-21 12:15:00 and 2016-07-21 12:45:00.\n",
      "No data between 2016-07-24 17:45:00 and 2016-07-24 18:15:00.\n",
      "No data between 2016-08-10 10:45:00 and 2016-08-10 11:15:00.\n",
      "No data between 2016-08-22 08:15:00 and 2016-08-22 08:45:00.\n",
      "No data between 2016-08-22 09:15:00 and 2016-08-22 09:45:00.\n",
      "No data between 2016-08-26 22:15:00 and 2016-08-26 22:45:00.\n",
      "No data between 2016-09-19 02:15:00 and 2016-09-19 02:45:00.\n",
      "No data between 2016-09-19 02:45:00 and 2016-09-19 05:15:00.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "No data between 2016-10-02 09:45:00 and 2016-10-02 10:15:00.\n",
      "No data between 2016-10-02 10:15:00 and 2016-10-02 10:45:00.\n",
      "No data between 2016-10-05 04:15:00 and 2016-10-05 04:45:00.\n",
      "No data between 2016-10-14 21:15:00 and 2016-10-14 21:45:00.\n",
      "No data between 2016-10-18 02:00:00 and 2016-10-18 02:30:00.\n",
      "No data between 2016-10-19 06:15:00 and 2016-10-19 06:45:00.\n",
      "No data between 2016-10-20 09:45:00 and 2016-10-20 10:15:00.\n",
      "No data between 2016-10-21 08:45:00 and 2016-10-21 09:15:00.\n",
      "No data between 2016-10-24 09:00:00 and 2016-10-24 09:30:00.\n",
      "No data between 2016-11-06 06:15:00 and 2016-11-06 06:45:00.\n",
      "No data between 2016-11-27 00:15:00 and 2016-11-27 00:45:00.\n",
      "No data between 2016-11-30 18:30:00 and 2016-11-30 19:00:00.\n",
      "No data between 2016-12-01 01:00:00 and 2016-12-01 06:15:00.\n",
      "No data between 2016-12-11 10:45:00 and 2016-12-11 11:15:00.\n",
      "No data between 2016-12-16 08:15:00 and 2016-12-16 08:45:00.\n",
      "No data between 2016-12-16 10:00:00 and 2016-12-16 10:30:00.\n",
      "No data between 2017-01-12 05:00:00 and 2017-01-12 05:30:00.\n",
      "No data between 2017-01-13 00:15:00 and 2017-01-13 00:45:00.\n",
      "No data between 2017-01-14 00:45:00 and 2017-01-14 01:15:00.\n",
      "No data between 2017-01-14 08:00:00 and 2017-01-14 08:30:00.\n",
      "No data between 2017-01-14 09:15:00 and 2017-01-14 10:00:00.\n",
      "No data between 2017-01-14 18:45:00 and 2017-01-14 19:15:00.\n",
      "No data between 2017-01-15 01:30:00 and 2017-01-15 02:00:00.\n",
      "No data between 2017-01-15 03:30:00 and 2017-01-15 04:00:00.\n",
      "No data between 2017-01-15 06:45:00 and 2017-01-15 07:15:00.\n",
      "No data between 2017-01-15 08:45:00 and 2017-01-15 09:30:00.\n",
      "No data between 2017-01-15 11:30:00 and 2017-01-15 12:00:00.\n",
      "No data between 2017-01-15 17:00:00 and 2017-01-15 17:30:00.\n",
      "No data between 2017-01-15 22:45:00 and 2017-01-15 23:15:00.\n",
      "No data between 2017-01-16 05:30:00 and 2017-01-16 06:00:00.\n",
      "No data between 2017-01-16 07:45:00 and 2017-01-16 08:15:00.\n",
      "No data between 2017-01-16 08:30:00 and 2017-01-16 09:00:00.\n",
      "No data between 2017-01-16 09:00:00 and 2017-01-16 10:00:00.\n",
      "No data between 2017-01-16 12:30:00 and 2017-01-16 13:00:00.\n",
      "No data between 2017-01-16 16:45:00 and 2017-01-16 17:15:00.\n",
      "No data between 2017-01-17 00:45:00 and 2017-01-17 01:15:00.\n",
      "No data between 2017-01-17 10:00:00 and 2017-01-17 10:30:00.\n",
      "No data between 2017-01-17 12:00:00 and 2017-01-17 12:30:00.\n",
      "No data between 2017-01-18 05:15:00 and 2017-01-18 05:45:00.\n",
      "No data between 2017-01-18 11:00:00 and 2017-01-18 11:30:00.\n",
      "No data between 2017-01-18 11:45:00 and 2017-01-18 12:15:00.\n",
      "No data between 2017-01-18 22:30:00 and 2017-01-18 23:00:00.\n",
      "No data between 2017-01-19 06:15:00 and 2017-01-19 06:45:00.\n",
      "No data between 2017-01-19 09:00:00 and 2017-01-19 09:30:00.\n",
      "No data between 2017-01-19 09:30:00 and 2017-01-19 10:00:00.\n",
      "No data between 2017-01-19 10:00:00 and 2017-01-19 10:30:00.\n",
      "No data between 2017-01-19 10:45:00 and 2017-01-19 11:15:00.\n",
      "No data between 2017-01-19 11:45:00 and 2017-01-19 12:15:00.\n",
      "No data between 2017-01-19 12:15:00 and 2017-01-19 12:45:00.\n",
      "No data between 2017-01-19 12:45:00 and 2017-01-19 13:15:00.\n",
      "No data between 2017-01-19 14:00:00 and 2017-01-19 14:30:00.\n",
      "No data between 2017-01-19 18:45:00 and 2017-01-19 19:15:00.\n",
      "No data between 2017-01-23 20:45:00 and 2017-01-23 21:15:00.\n",
      "No data between 2017-01-23 21:15:00 and 2017-01-23 22:00:00.\n",
      "No data between 2017-01-23 22:00:00 and 2017-01-23 22:45:00.\n",
      "No data between 2017-01-24 03:00:00 and 2017-01-24 03:30:00.\n",
      "No data between 2017-01-24 03:30:00 and 2017-01-24 04:00:00.\n",
      "No data between 2017-01-24 04:15:00 and 2017-01-24 04:45:00.\n",
      "No data between 2017-01-24 04:45:00 and 2017-01-24 05:15:00.\n",
      "No data between 2017-01-24 06:30:00 and 2017-01-24 07:00:00.\n",
      "No data between 2017-01-24 07:30:00 and 2017-01-24 09:00:00.\n",
      "No data between 2017-01-24 09:00:00 and 2017-01-24 09:30:00.\n",
      "No data between 2017-01-24 09:30:00 and 2017-01-24 10:00:00.\n",
      "No data between 2017-01-24 10:45:00 and 2017-01-24 11:30:00.\n",
      "No data between 2017-01-24 11:30:00 and 2017-01-24 12:00:00.\n",
      "No data between 2017-02-28 19:30:00 and 2017-03-01 01:30:00.\n",
      "No data between 2017-03-02 19:00:00 and 2017-03-02 20:15:00.\n",
      "No data between 2017-04-15 19:00:00 and 2017-04-15 23:00:00.\n",
      "No data between 2017-06-21 20:00:00 and 2017-06-21 23:00:00.\n",
      "No data between 2017-06-26 17:00:00 and 2017-06-26 17:45:00.\n",
      "No data between 2017-07-18 20:45:00 and 2017-07-18 21:15:00.\n",
      "No data between 2017-09-01 05:00:00 and 2017-09-01 05:30:00.\n",
      "No data between 2017-09-25 08:15:00 and 2017-09-25 10:45:00.\n",
      "No data between 2017-10-29 01:45:00 and 2017-10-29 02:45:00.\n",
      "No data between 2017-12-01 06:30:00 and 2017-12-01 08:00:00.\n",
      "No data between 2017-12-07 16:45:00 and 2017-12-07 17:15:00.\n",
      "No data between 2017-12-11 19:15:00 and 2017-12-11 19:45:00.\n",
      "No data between 2017-12-12 05:45:00 and 2017-12-12 07:15:00.\n",
      "No data between 2017-12-22 17:45:00 and 2017-12-22 18:15:00.\n"
     ]
    }
   ],
   "source": [
    "df_year = pd.read_pickle(\"data/ETH_USD_2016_2018_15min.pkl\")\n",
    "\n",
    "# Checking for missing data\n",
    "delta = datetime.timedelta(minutes=15)\n",
    "for i, row in df_year.iterrows():\n",
    "    if i < len(df_year.index)-1:\n",
    "        current_date = df_year.iloc[i]\n",
    "        next_date = df_year.iloc[i+1]\n",
    "        if next_date[\"time\"] - current_date[\"time\"] > delta:\n",
    "            print(\"No data between {} and {}.\".format(current_date[\"time\"], next_date[\"time\"]))\n",
    "for i, row in df_year.iterrows():\n",
    "    if i < len(df_year.index)-1:\n",
    "        current_date = df_year.iloc[i]\n",
    "        next_date = df_year.iloc[i+1]\n",
    "        if next_date[\"time\"] < current_date[\"time\"]:\n",
    "            print(\"Wrong order between {} and {}.\".format(current_date[\"time\"], next_date[\"time\"]))\n",
    "            "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXoAAAEJCAYAAACaFuz/AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMS4wLCBo\ndHRwOi8vbWF0cGxvdGxpYi5vcmcvpW3flQAAIABJREFUeJzt3Xl8VNX9//HXJ8lkBcK+hSUIKFBl\nkYCguIKKYsUd21qFWvX7tVp/xa+7VttqtXax9qu1tWrRakVL6/Z1BfcdAcUNkbAHMYQtkI0sc35/\nzCRMkkkySWbL5P18PHjk3nPPvfdzB/jMzbnnnmPOOUREJHElxToAERGJLCV6EZEEp0QvIpLglOhF\nRBKcEr2ISIJTohcRSXBK9CIiCU6JXkQkwSnRi4gkuJRYBwDQu3dvl5ubG+swREQ6lOXLl293zvVp\nqV5cJPrc3FyWLVsW6zBERDoUM9sYSj013YiIJDglehGRBKdELyKS4OKijT6YqqoqCgoKqKioiHUo\nnVZ6ejqDBg3C4/HEOhQRaYe4TfQFBQV07dqV3NxczCzW4XQ6zjl27NhBQUEBw4YNi3U4ItIOcdt0\nU1FRQa9evZTkY8TM6NWrl36jEkkAcZvoASX5GNPnL5IY4jrRi4h0dAW7ynhj9baYxqBE34yCggJm\nz57NyJEjGT58OFdccQWVlZWxDqueBQsWcNlll8U6DBFpwgl3vcXcv38U0xiU6JvgnOOMM87gtNNO\nY82aNXz99deUlJRwww03xDo0EelAyiprYh2CEn1TXnvtNdLT05k3bx4AycnJ3HXXXTz00EOUlZWx\nYMECZs+ezTHHHMPIkSP5xS9+Ubfvo48+yuTJkxk/fjyXXHIJNTW+v+guXbpwww03MG7cOKZMmUJh\nYWG9c3q9XnJzc9m9e3dd2ciRIyksLOS5557jsMMOY8KECcyYMaPRvgBz585l0aJFdetdunSpW/7t\nb3/LpEmTGDt2LDfffDMApaWlzJo1i3HjxnHwwQfzxBNPhOGTE5Fgqmq8MTt33HavDPSL577gy2/2\nhPWYYwZ24+bvfqfJ7V988QUTJ06sV9atWzeGDBlCfn4+AEuXLuXzzz8nMzOTSZMmMWvWLLKysnji\niSd499138Xg8XHrppTz22GOcf/75lJaWMmXKFG677Tauvvpq/va3v3HjjTfWHT8pKYnZs2fz1FNP\nMW/ePD788EOGDh1Kv379mDZtGh988AFmxgMPPMCdd97J73//+5Cu9ZVXXmHNmjUsXboU5xynnnoq\nb731FkVFRQwcOJDnn38egOLi4tZ+jCISopKKanpkpcbk3B0i0cer448/nl69egFwxhln8M4775CS\nksLy5cuZNGkSAOXl5fTt2xeA1NRUTjnlFAAmTpzI4sWLGx1zzpw5/PKXv2TevHksXLiQOXPmAL7n\nBXPmzGHr1q1UVla2qm/7K6+8wiuvvMKECRMAKCkpYc2aNRx55JFceeWVXHPNNZxyyikceeSRbf8w\nRKRZqwv3MuWAXjE5d4dI9M3deUfKmDFj6jWDAOzZs4dNmzYxYsQIVqxY0aj7oZnhnOOCCy7g9ttv\nb3RMj8dTt09ycjLV1dWN6kydOpX8/HyKiop4+umn6+74L7/8cubPn8+pp57KG2+8wS233NJo35SU\nFLxe36+HXq+37sGxc47rrruOSy65pNE+K1as4IUXXuDGG29k+vTp/PznPw/h0xGR1vrLm2tjlujV\nRt+E6dOnU1ZWxiOPPAJATU0NV155JXPnziUzMxOAxYsXs3PnTsrLy3n66ac54ogjmD59OosWLWLb\nNl93qp07d7JxY0gjiQK+L4vTTz+d+fPnM3r06LrfGIqLi8nJyQHg4YcfDrpvbm4uy5cvB+DZZ5+l\nqqoKgBNPPJGHHnqIkpISALZs2cK2bdv45ptvyMzM5LzzzuOqq65ixYoVrf2YRCREb6wuori8Kibn\n7hB39LFgZjz11FNceuml/OpXv8Lr9XLyySfz61//uq7O5MmTOfPMMykoKOC8884jLy8PgFtvvZUT\nTjgBr9eLx+Ph3nvvZejQoSGfe86cOUyaNIkFCxbUld1yyy2cffbZ9OjRg+OOO47169c32u+iiy5i\n9uzZjBs3jpkzZ5KVlQXACSecwKpVq5g6dSrge0j76KOPkp+fz1VXXUVSUhIej4f77ruvLR+ViISo\ndF812RnRHzvKnHNRP2lDeXl5ruHEI6tWrWL06NExiqhlCxYsYNmyZdxzzz2xDiWi4v3vQSTe5V77\nfN3ykvlHM6Jvl2Zqt46ZLXfO5bVUT003IiJRUlEVmz71arppo7lz5zJ37txYhyEiHUh5jBJ9XN/R\nx0OzUmemz18kvGL1lmzcJvr09HR27NihZBMjtePRp6enxzoUkYRRXtm4S3U0hNR0Y2Y/A34MOOAz\nYB4wAFgI9AKWAz90zlWaWRrwCDAR2AHMcc5taG1ggwYNoqCggKKiotbuKmFSO8OUiIRHrO7oW0z0\nZpYD/BQY45wrN7MngXOBk4G7nHMLzewvwIXAff6fu5xzI8zsXOA3wJzWBubxeDSzkYgklHhvo08B\nMswsBcgEtgLHAbWvjj4MnOZfnu1fx799umkGCxERyvbFaaJ3zm0Bfgdswpfgi/E11ex2ztU2OBUA\nOf7lHGCzf99qf/1G7/2a2cVmtszMlql5RkQ6g38t3xyT87aY6M2sB7679GHAQCALmNneEzvn7nfO\n5Tnn8vr06dPew4mIxL0tu8pjct5Qmm5mAOudc0XOuSrgP8ARQHd/Uw7AIGCLf3kLMBjAvz0b30NZ\nEZFO7bQJOS1XioBQEv0mYIqZZfrb2qcDXwKvA2f561wAPONffta/jn/7a059JEVEYjb5SCht9B/i\ne6i6Al/XyiTgfuAaYL6Z5eNrg3/Qv8uDQC9/+Xzg2gjELSLS4eyrjk2iD6kfvXPuZuDmBsXrgMlB\n6lYAZ7c/NBGRxBKrsW7i9s1YEZFEk5mawm9f/opNO8qiel4NaiYiEiVPfezrs3Lv62tZ9+uTSUqK\nzitGuqMXEQmzb4srWPxlYbN1qr3R66OiRC8iEmZn3vceFz2yrNk61d7oPZhVohcRCbMtu30vRuVv\nK2myzsl3vx21h7NK9CIiETLjD282uW3DjjJG3fQSL362NeJxKNGLiMTQk8siP/6NEr2ISAxF46Gs\nEr2ISAz9cMrQiJ9DiV5EJIYyUpMjfg4lehGRGEpJinwaVqIXEYkhT3Lk345VohcRiSFPsu7oRUSk\nnZToRUQi7OgDm54utSYK8zIp0YuIRFhOj4wmt0Vj/EolehGRCGvupj0ag1gq0YuIRNhZE5ueFHz0\ngK4RP78SvYhIhA3sHrzpZtygbDJTIz//kxK9iEiEWRMt8c9cNi0q51eiFxFJcEr0IiIR9O61x2HR\nmRq2SUr0IiIRlNNE+3w0Rf4pgIiI1PP21cc22+Uy3JToRUQirGHLzeCemVE9v5puREQSnBK9iEik\n6WGsiEhia6offbQo0YuIJDglehGRCAvsR//fxwyP+vmV6EVEouiamaOifk4lehGRBKdELyISRt6A\nAebzbzsJgC5psX1lSYleRCSMvAGvvKb4J/5O9yTHKhxAiV5EJKyiMQdsaynRi4iEURzm+dASvZl1\nN7NFZvaVma0ys6lm1tPMFpvZGv/PHv66ZmZ/MrN8M/vUzA6N7CWIiMQPbxxm+lDv6O8GXnLOjQLG\nAauAa4FXnXMjgVf96wAnASP9fy4G7gtrxCIicawmGrN9t1KLid7MsoGjgAcBnHOVzrndwGzgYX+1\nh4HT/MuzgUeczwdAdzMbEPbIRUTiUBzm+ZDu6IcBRcDfzexjM3vAzLKAfs65rf463wL9/Ms5wOaA\n/Qv8ZSIiCc910KabFOBQ4D7n3ASglP3NNAA435W16urM7GIzW2Zmy4qKilqzq4hI3OqQTTf47sgL\nnHMf+tcX4Uv8hbVNMv6f2/zbtwCDA/Yf5C+rxzl3v3MuzzmX16dPn7bGLyISV+Iwz7ec6J1z3wKb\nzewgf9F04EvgWeACf9kFwDP+5WeB8/29b6YAxQFNPCIiCS0ee92E+l7u5cBjZpYKrAPm4fuSeNLM\nLgQ2Auf4674AnAzkA2X+uiIinUKHTfTOuU+AvCCbpgep64CftDMuEZEOqaO20YuISIiU6EVEEly1\nEr2ISGLTHb2ISIKrrlGiFxFJaLqjFxFJcNVeb6xDaESJXkQkjHRHLyKS4NTrRkQkwelhrIhIgluy\nqjDWITSiRC8iEkYL3tsQ6xAaUaIXEQmTGq9j3ODusQ6jESV6EZEw+enCj1m5eTcAh+Rkxzia/ZTo\nRUTC5PlP90+9cdMpY2IYSX1K9CIibbCrtJJdpZVNbs/wJEcxmuaFOvGIiIgEmPCrxQBsuGNW0O1J\ncXQbHUehiIgkjuQka1Q2sm+XGESiO3oRkYhItvqJ/v3rjqNruicmsSjRi4i0UlVNywOXJTW4ox+Q\nnRGpcFqkphsRkVYaecOLLdZJCdJ0EytK9CIiEZBkSvQiIh3SX99cW2/9ra+LuOGpzxrVc3E0tpkS\nvYhIiLaX7OP2F7+qV3b+Q0t57MNNjepWxdEEJEr0IiIham4I4qK9+6IYSeso0YuIhKimmfaYSbct\nqbc+pGdmpMMJmRK9iEiI8reVhFzXkxw/6TV+IhERiXMfb9oV6xDaRIleRCREI/t2jXUIbaJELyIS\nop5ZqbEOoU2U6EVEQuT1P4y9cdboeuUL5k2KRTghU6IXEQlRjdeX6Mc3mC5wVP9usQgnZEr0IiIh\nqr2jbzhgWWpK/VR6zcxRUYspFEr0IiIhqkv0Dcax8STvXx83uDsXH3VAVONqiRK9iEiIakcnbjjW\nfGCf+QHd0oNOOhJLSvQiIiG6etFKoPE0gakBiX5wz9iNO98UJXoRkRDtKqsCGjfdBLbZnzlxUFRj\nCoUSvYhIKwWbVOTgHF/Pm3jsgRNyojezZDP72Mz+z78+zMw+NLN8M3vCzFL95Wn+9Xz/9tzIhC4i\nEhsl+6o55qA+9cr+7/Ij2XDHrBhF1LzW3NFfAawKWP8NcJdzbgSwC7jQX34hsMtffpe/nohIwkgy\nY8bofgCckxd/TTUNhZTozWwQMAt4wL9uwHHAIn+Vh4HT/Muz/ev4t0/31xeRKKqoqiH32ue59/X8\nWIeScMxgxuh+pKUkMffwYbEOp0Wh3tH/EbgaqJ0ypRew2zlX7V8vAHL8yznAZgD/9mJ/fRGJotqJ\nMH778uoYR5J4enVJo392OqtvPYkxA+OvTb6hFhO9mZ0CbHPOLQ/nic3sYjNbZmbLioqKwnloEWng\n2+KKWIfQpNxrnyf32ufJ37Y31qG0KDvDw7jB3cnpHn9dKJsTyh39EcCpZrYBWIivyeZuoLuZpfjr\nDAK2+Je3AIMB/NuzgR0ND+qcu985l+ecy+vTp0/DzSLSToGTIU25/dXYBdKMtUX7J/KY8Ye3YhhJ\naIrLq1i5eXesw2i1FhO9c+4659wg51wucC7wmnPuB8DrwFn+ahcAz/iXn/Wv49/+mnPxNB+6SOfQ\n3LR38WL679+sW77lu2NiGEnopo/qG+sQWq09/eivAeabWT6+NvgH/eUPAr385fOBa9sXooi0RY3X\nW2/9ow07KausbqJ27PWI87Hed5ZWAvDqV9tiHEnrpbRcZT/n3BvAG/7ldcDkIHUqgLPDEJuItENV\nTf07+rP/8j5d01L47Bcnxiii5tUOARyvPt9SHOsQ2kxvxookqH3V3kZle/fF7x394i8LYx1Ckwr3\nVHD+Q0sBOKhfx5tOUIleJEFlpiYHLY/XR2Yvfv5trENo0gfr9vcn+X8zRsYwkrZRohdJUE0NlTvs\nuheiHElw+6prYh1CyK5Y+End8ptfd7zu4Er0Igkq3tu8KyobNy154zDmhjFdcHhubAJpByV6kQT1\n2AcbYx1Cs6q9jRN9aRz2CvI2aOoaPSD+34RtSIleJEE9/H58J/oVm3wvHt1+xiF1Zec9uDSs5yjY\nVcai5QXtOkZ1wB39Ab2z2htSTLSqe6WISLhc9MgyALqm709DKzfvxut1jSbfbosnP9rM1f/+FIBZ\nhwwgo4mH0y1Zv720bvmxiw5rd1yxoDt6EYmK8krfaJp/f3d9vfKGzxIOuD48D4trkzzAW2va9gB1\n+cZdFJf7ZpW6+btjGJDdsca4qaVEL9IJffnNnqifc0epbzTNv721jpe/2N+VctYhAxrV3bijtFFZ\neyzbsLPV++wo2ceZ973Hufd/AMCYDtg2X0uJXqSTyM7w1C3/YXH0hy6unZaiuLyKS/6xfzDclOTG\naejo374R1nM/88k3rd5n4q1L6q0Hi7Oj6LiRi0irpKXs/+++ZNU2Drzhxaiev/ZFrdLK/f3nTxnr\nu5t/66pjI3rubf6x+UNx3X8+5fUg49kc2K9LOEOKKj2MFekktu3dR1Zqcl2irazxUuN1lFVW0zXd\n08Le7VdR1fgFqXu+fygAg3vWb/vO7ZXZ7vN1TUtp05APjy/dzONLNzc+XhQ+o0jRHb1IJzGqf1e+\nk5Ndr2z49S9wyC2vBE3C7fXI+xt4fOmmuvXU5Pq9Xs6YkFO33HC20aG92t+NsSpIP/2WNPU5fHrL\nCe0NJ6aU6EUSVJe0FH50xP75TFOSjaXr9z+UPOag/RP+fLO7PGzn3Vddw4btpfz8mS+47j+f1ZVX\n1tRPon+YM77JY2zeVcbdS9a0eriBiqoaqmt8Cb66xnH48P2zmL6+uuXhhS99bEWjsveuPY5uHfhu\nHpToRRKWc47A7ugNJ7F+Y/X+JLp5V/gS/U8f/5hjfvdGvbLNO8uCjqbZlHVFpdy15GsueKjpF6gu\n+ceyehOff124l1E3vcSIG15kw/ZSqr2OvKE96rbP+/tHbC0u57J/rmBPRRXfFldw95I1rAuY5eq1\nIG3zAzvYtIHBqI1eJEF5HfVePJoYkPQauuChpWy4Y1ZYzvvyF/WHG77/rbX8+oWv6pWtue2ksJzn\n5S8K+dERw8hITa73ALX2i6Zhk9DU218DfJOIvLfWNyLlXUu+Zvb4gUw9oBeJSoleJEF5nSMwzYXh\nZdM2aZjkATyt7Kq4tbiczTvLmTysZ6Nto3/+EgCXHH1Ao213v7om6PG++rb+ROTPfPJN0C6Y//xx\nx3wTtiE13YgkKOd8d7Qp/gyfZDHK9GEw9fbXOOev71Pq70XzSZAJuv/65rqQj1c7LWBLDh/RO+Rj\nxjMlepEEVON1VHm9pKYk1Q3KVVZZw2njBza5T0eYKu+vb67l+qc+47R73w2p/tLrpzO3jcMKX3bs\niDbtF4+U6EUS0M7SSpzzPZDt1y0NgG4ZKfTuktbkPqf87ztRie2rX81sdvu//mtqk9v+9Fo+//xw\nU5PbA224YxZ9u6U3OQELwNBm+uufO3lwSOfpCJToRRLQe2u3+3/uwAJa6ptLetB0P/JwSvc0P4rk\npNz67fBVNaH31rnqxIMalU3xP2T93+9NqCt77MeHseGOWbwZ8EbuPd/3bR8zoBurfjmTQT3a/9JW\nvNDDWJEE1Md/537l8Qcy/8mVgK/NvqXhf0fd9FLYet+MHtCNIT0z6nrh3DhrND84bGiT9ZfMP5qs\nNN+XwItXHMlJd78NwMPvbQha/4wJOfzn4y2cO2kwv5x9MMXlVfTuksrpE3JISd5/nceP6cfKm08g\nO8PD5Y9/DMBhQR7qTj2gF+tvPxlo3Funo1OiF0lAVy3yDdGbnGQE5qyUELreFOwqC8vd7LwjcumV\nlVqX6H98ZONeMYFG9N0/lkzgLE63Pr8qaP3fnDWW4X27cOG0YaSmJNGnq+/LLVi/98AB3SD4AGW9\nmmnW6uiU6EUS0Bb/m669u+5PXo7Qet5M+83rbb6r/0fA9IVnTxxU1ztmWph7rxx1YB88yUn8pJUP\nTO8+dzyl++o3T312ywmt7u7Z0SjRiySQiqoaRt30EumeJCqqvAzrlVXXQu+cq0v8B/TOYt32psd8\nd861qfnipqc/r1s2MyYM6cGdZ43lxO/0b/WxmnPUyLZ9ccwen9OorCMPVhaqxP4aE+lkdpf5ZkOq\nqPI9wExKsnoJ+/uTh/Dbs8a2eCf89CdbwhbTOXmDGzWdhOKiI4c1uW384O7tCanTUaIXSSC1094F\n+tnxBwLQu0sayUnG2XmDW5w/tS1t9N6AKQEXXjyl1fs35FzT29oy/HBnpkQvkkDeCDJC41kTB7Hh\njln1ujWmBrRJ/+TY4Y32CfXN0UAbAqb/m5zbuFdLa01pMPbM+VP399g59qC+7T5+Z6JEL5JA7ntz\nbUj1+men1y2P6NuFkX27cOeZY+vKLvnHclYHjAezr7qmxWF+l23cVbfcUjfOUMwY06/e+pCeidOv\nPdqU6EUSSG0bPcCTlzT9hunBAROQVNc4Fs8/mnMmDeaxgEG8LvnHsrrl//nXp8z7+0esDDLGTK3A\nqQoj4aXPv2XDHbPC1s+/M1GiF0kQgW+1jh7QjUMazCbVlMC28Nze+2d22rCjrG75uZW+kR0feX9/\n98mG3vcP+3tkG3vEtOT0Qxv3mJHQqHulSAJYvnFn3YPYw4f34p8Xhf4w1BuQ6XMCXjYK1rvy3ysK\nWL+9hAcvmESPrNR622qH+Q188SmcGrbZS+h0Ry/SwT3zyRbOvO99frTA19QydlDruh56m+jdctTI\nPkHLV2zazZF3vt6o/EfTcgE4d9KQVp0/FH+cM57hfSLzBdIZ6I5epIO7YuEn9dbzt+1tomZw3gb9\nGA/q15XVhXsp3FPBys27GRekz3rJvmoqq33DIG/bU8HkX79at612tMxw+rqwddck9emOXiTBfHdc\n02POB+MaJPqXf3YUs8cP5Ktv9zL73neb7G1z+eO+ibSn/+HNeuUtjU7ZFsMCnh1I6ynRiySYGaP7\ntVwpQLCmm9KAF5Ju+M9nQferbYvfW1H/5aVI9L5pOPWftI4SvUgH9MDb68i99vmgb8JmpbWuRbZh\n0w3AklX77+JnjR0QdL8+TYz2GIkhftcWlYT9mJ1Ji4nezAab2etm9qWZfWFmV/jLe5rZYjNb4//Z\nw19uZvYnM8s3s0/N7NBIX4RIZ1M7dO89r9Wf/HrZjTNafayWhi7+ZndF0PLVhfWTb79uaWHv4177\nJXPK2NY1R0l9oXz1VwNXOudWmFlXYLmZLQbmAq865+4ws2uBa4FrgJOAkf4/hwH3+X+KSJh9u2df\n3fK///vwZqcKbMo5k5qfMu/5z7bWW+/fLZ1v91Tw+NJNVAfM/vTuNce1+twt6er/7aSyOvRZpqSx\nFu/onXNbnXMr/Mt7gVVADjAbeNhf7WHgNP/ybOAR5/MB0N3Mgv/uJyLtEjhmzcShPVq17+pbZ/Ll\nL08kLaV1D08/uH563fK/lhfULQebzKO9umf6+uo7mhnhTFrUqsY8M8sFJgAfAv2cc7Vf9d8CtU+A\ncoDNAbsV+Mvq3xaISLv9e0VBy5Wa0NoEHwtXTB9JWkoSZ09MnIm6YyHkr2Az6wL8G/h/zrk9gduc\nr39Wq75yzexiM1tmZsuKiopas6uIdBIZqcn87PgDSY3wODqJLqRPz8w8+JL8Y865//iLC2ubZPw/\nax/TbwECv34H+cvqcc7d75zLc87l9ekT/A08EYmNA1rotx7qODoSH0LpdWPAg8Aq59wfAjY9C1zg\nX74AeCag/Hx/75spQHFAE4+ItNOOkn0tV2qns/IGBS0f45+0+7nLp/HA+Xl15Z/eckLEY5K2C6WN\n/gjgh8BnZlb7rvX1wB3Ak2Z2IbAROMe/7QXgZCAfKAPmhTVikU5u4q1LGpX99YcTw3qOwuLgXSpf\nuOLIuuVpAaNUdusE8652ZC0meufcO0BTHW2nNyzwt9f/pJ1xiUgrZLYwNWBr9e3mm5gkb2iPehOK\nBIrEUAcSGXrCIZIASsM8h+rZeYM4JCeb//3+hGbrfXj9dL74xYlhPbeEn0avFEkAbXlRqjl9u6bz\n3OXTWqzXr1t6i3Uk9nRHL5IAWvuylHQuSvQiCSASA4lJ4lCiF5GQDOqR0XIliUtK9CIdSE1T8/5F\nwd3njo/ZuaV9lOhFOpBg48/P/E7/qJzbE4FByyQ69Dcn0oG89lXAhCCH+AaFPW5036ice3CPzKic\nR8JPiV6kA3nwnfV1y8v9LzJt2F4alXP3yEqNynkk/JToRTqQwj2+oQl+OGVo3ZytyS3MENVe/dVX\nvsPTC1MiHcTeiip2llYCcPqhOTz/6Vbeyd8e8XFm/u+n0/hmd3lEzyGRpUQv0kG8sXr/vA21d/PR\n0LtLWtjfvJXoUtONSAexaWdZ3XK3dE9dv/Z+2Wpakebpjl6kg3hv7XZg/zyxF0zNJbdXFsccpIl7\npHlK9CIdxLv5OwD4/mFDAEhKMo4dFZ2uldKxqelGpIOYNsI30cd5U4bEOBLpaJToRTqIQ/0jVB7Q\nO3oPYiUxqOlGJI7kXvt83XL+bSeR4m+Pd86xpnAv4GuyEWkNJXqRODXqppd48r+m8uJnW/nb2+tb\n3kGkCUr0InGirLL+dIDVXscZf34vRtFIIlGiF4kDgU02zblw2rAIRyKJSA9jReLMT6ePbFR28VEH\nAHD1zIOiHY4kAN3Ri0TBV9/u4fMtezhr4qBG297L315v/bTxA3n2ky1s2FHG6ltnApCWksz1J4+O\nSqySeJToRaJg5h/fBgia6L//wId1y98Z2I0D+nThmcumsXlnGWkpyVGLURKXEr1IDN21+Ou65fnH\nH1jXbJOd4SE7JztWYUmCURu9SAw99O7+bpPB2uZFwkGJXiSG9lb4ulS+ffWxMY5EEpmabkRCdOo9\n7zC4Ryb3/uBQAJ75ZAsPv7eBHpmpvPrVNs6dNJgfHDaUQwbVb3KprvEGPZ7X6+qWB/fUfKwSOUr0\nIiH6tKCYTwuKuRffkARXLPyk3vaFH21m4UebmTG6L9edPJrhfXxj0oy44cW6OsH6y4/q3zWicYso\n0YuEwLn9d98tvdy0ZNU2lqzaFvKxn71sWpvjEgmFEr1ICK5/6vOg5RcdOYwbZo3B63VsL93H5Nte\nDVrvkJxsrpk5iiE9M0lNSaK/ZoWSKFKiFwlB0d59QctrX2JKSjL6dk3nsR8fxqurtrF80y5+csxw\nxgzsxsDsDI04KTGlRC/Sgq8exarZAAAKAklEQVS+3cOSVYX1ypbMP5rcXpmY1U/gR4zozRH+CUJE\n4oUSvUgLat9qBUhJMm47/WBG9NXkH9JxdOp+9Fc+ubJuMgcRgA/X7WBvRVXd+iPvb6hbPnfSYPJ/\nfTJzJmkqP+lYOuUd/Ql3vcnXhSUA/HtFARvumBXjiCTWdpVWcsmjy1m6fmfQ7WceOog7zhwb5ahE\nwqNDJ/r31m7n+3/zDQg165ABLNu4k6y0FGaM7kd1jWP99hJeX11EdoaHsYOy2bKrnILd5VRW13+B\nJbC73IzR/fhsy25ye2Ux9/BcDs7JZkB2OrWd6zzJSewo2cfcv3/E788Zx5JVhdz50up6xztvyhDG\nDerOCWP6k5mWTEqSsbO0kt+9spozDx1E7y5pDOiejmF4naPG66hxDq93//L6olJ2l1f5xjzJ8FBd\n46j2eqn2OqprHLvLKinYVc5tL6wC4LJjR5CRmkzhngp6ZqWSmpJEanISa4tKMDN6ZaUyfnB3endJ\no7SymvLKGgr37GPsoGy6pKXg8dfvkemhxrm4GEyrvLKGjNS2xVFd46WyxkuGx7f/rrIqNu8s4/qn\nPuOEMf3Jzkih2uvYWVrJI+9vpGRfdbPH+/0549oUh0g8sMD+wWE7qNlM4G4gGXjAOXdHc/Xz8vLc\nsmXLWn2eHz+8rO4h2bDeWazfXtpk3VH9u9Knaxpvr/ENCfvkJVM556/vN6o3MDudb4orWh1LIjKD\nHpmp7C6rJOAlTsYM6MaXW/fQI9PDmIHdMIyu6SlkZ3hYt72UiUN7cN8ba/nzDw4lIzWZ+95Yy5y8\nwYBvFqXszFR6+7+MkpMMT3ISSWYU7qngi2+KAfjdK/sH++rfLZ1teysY1juLvl3TKS6vIr+ohMzU\nZCqqauia7sGAqhov1TWOKq+Xiirfl3lyklHjDf3f+OMXTWHq8F6A70ZidP9u9MhKbecnKRIZZrbc\nOZfXYr1wJ3ozSwa+Bo4HCoCPgO85575sap+2JvrSfdWsLSph7KDugK8L3Kn3vMPW4grm5A3m598d\nQ1Za07+0VNV4Gel/a/E3Zx7CWRMHk5xk3PzM52SkpnBA7ywe/XAjnxYU1+2T4UmmR6aHb4oruOmU\nMbz8+bdcMWMkB+dks3zjTtZvL+PYg/rw2lfbuPX5VXX7XThtGJt2lnHid/rjdY5te3xfJklJRrIZ\nyUlGUu3PJKO6xsuA7AwKdpUxIDuD1JQkUpKNlCQjJSmJaq+XbukehvXJomtaCl4HFVU1ZHiScf5r\nq6zxUlJRTcGucpZv3MWeiiryhvYgMzWF1JQktpfso8brqKiqobSyhq27y/nzG2vrYj5/6lC8zvF1\nYQnrikrZXuLrYjjlgJ58sM7XxDGkZyaFeyrwJCe1eFfcVpNze/L1tr0kmzG8TxcKdpUxvG8X+nVL\nJys1mX3+39A8yb7PyJOcRHFZFX26puF1jgfeWc+Ppw1jRN8uDO6Z6evLnpyEJyWJlCQjNTlJ3R+l\nQ4plop8K3OKcO9G/fh2Ac+72pvZpa6KPd9v2VNAtw0O6J/bNINHgnOO9tTvo3SWNqxetpHeXNF79\nahtPXDyF7pmppHuS2FFaiXP+L6JqL1uLy9m0s4z+3dLJzkwlO8NDhieZob0y6ddNLxWJNCfURB+J\nNvocYHPAegFwWMNKZnYxcDHAkCGJ2YuhbydLVGZW14f8mSZe6x/aKyuaIYkIMexe6Zy73zmX55zL\n69OnT6zCEBFJeJFI9FuAwQHrg/xlIiISA5FI9B8BI81smJmlAucCz0bgPCIiEoKwt9E756rN7DLg\nZXzdKx9yzn0R7vOIiEhoIvLClHPuBeCFSBxbRERap1OPdSMi0hko0YuIJDglehGRBBeRsW5aHYRZ\nEbAx1nFEQG9ge6yDiJLOdK3Qua5X1xq/hjrnWnwRKS4SfaIys2WhvJ6cCDrTtULnul5da8enphsR\nkQSnRC8ikuCU6CPr/lgHEEWd6Vqhc12vrrWDUxu9iEiC0x29iEiCU6JvAzN7yMy2mdnnLdSbZGbV\nZnaWf/1YM/sk4E+FmZ0Wnajbpq3X6i+708y+MLNVZvYnM4v7aZzaeb2/MbPP/X/mRD7a9mnpWs3s\nGDMrDvj3+vOAbTPNbLWZ5ZvZtdGLum3aea0h/ZuIZ0r0bbMAmNlcBf+Uir8BXqktc8697pwb75wb\nDxwHlAVuj1MLaMO1mtnhwBHAWOBgYBJwdMSiDJ8FtO16ZwGHAuPxTbTzP2bWLXJhhsUCWrhW4O3a\nf7POuV9C3fXfC5wEjAG+Z2ZjIhpp+y2gDdfain3jmhJ9Gzjn3gJ2tlDtcuDfwLYmtp8FvOicKwtn\nbOHWjmt1QDqQCqQBHqAwEjGGUzuudwzwlnOu2jlXCnxKnCeHEK81mMlAvnNunXOuElgIzA5rcGHW\njmtt177xQok+AswsBzgduK+ZaucCj0cnoshp6lqdc+8DrwNb/X9eds6tanyEjqWZv9uVwEwzyzSz\n3sCx1J+Ap6OaamYrzexFM/uOvyzYdKE50Q8t7IJda0KIyDDFwh+Ba5xz3mDN0mY2ADgE35j9HV3Q\nazWzEcBofDOMASw2syOdc2/HIMZwCnq9zrlXzGwS8B5QBLwP1MQmxLBZge8V+xIzOxl4GhgZ45gi\nJaGvVYk+MvKAhf5E0Bs42cyqnXNP+7efAzzlnKuKVYBhFPRa8f0n+cA5VwJgZi8CU4GOnuib/Lt1\nzt0G3AZgZv8Evo5dmO3nnNsTsPyCmf3Z/9tKwk0X2tS1Ouc60rg3TVLTTQQ454Y553Kdc7nAIuDS\ngCQP8D0SoNkGmr3WTcDRZpZiZh58D2I7fNNNU9drZslm1gvAzMbiewgd7w/am2Vm/Wt7SpnZZHz5\nYgcJOF1oM9eaEHRH3wZm9jhwDNDbzAqAm/E9bMQ595cW9s3Fdzf0ZkSDDJN2XOsifD2LPsP3YPYl\n59xzkY22/dpxvR7gbX+u2AOc55yrjmy07RPCtZ4F/Lf/N7Ry4Fzne8Oyw00X2o5rDbqvc+7BqF9E\nO+jNWBGRBKemGxGRBKdELyKS4JToRUQSnBK9iEiCU6IXEYmQ1gyIZmZHmdmKhoPl+be1a4BAJXoR\nkchZQOhjHm0C5gL/DCwMxwCBSvQiIhESbEA0MxtuZi+Z2XIze9vMRvnrbnDOfQp4Gx6Gdg4QqEQv\nIhJd9wOXO+cmAv8D/Lm5yuEYIFBvxoqIRImZdQEOB/4V0Mye1sI+7R4gUIleRCR6koDd/smHQnU6\n7RwgUE03IiJR4h8lc72ZnQ1gPuNa2K3dAwQq0YuIRIh/QLT3gYPMrMDMLgR+AFxoZiuBL/DPzmW+\neYgLgLOBv5pZ7UBxi4C1+AYIXAmsbO0AgRrUTEQkwemOXkQkwSnRi4gkOCV6EZEEp0QvIpLglOhF\nRBKcEr2ISIJTohcRSXBK9CIiCe7/AxzMNgLbuaARAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<matplotlib.figure.Figure at 0x7f971888abe0>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.plot(df_year.time,df_year.open, label = \"Open values\")\n",
    "plt.legend(loc='upper left')\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2018-03-06 19:30:00\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-03-05 18:30:00</td>\n",
       "      <td>856.48</td>\n",
       "      <td>856.49</td>\n",
       "      <td>856.49</td>\n",
       "      <td>856.48</td>\n",
       "      <td>43.935593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-03-05 18:45:00</td>\n",
       "      <td>856.48</td>\n",
       "      <td>859.81</td>\n",
       "      <td>856.48</td>\n",
       "      <td>858.86</td>\n",
       "      <td>766.554688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-03-05 19:00:00</td>\n",
       "      <td>858.85</td>\n",
       "      <td>860.00</td>\n",
       "      <td>858.86</td>\n",
       "      <td>859.74</td>\n",
       "      <td>645.814996</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-03-05 19:15:00</td>\n",
       "      <td>859.00</td>\n",
       "      <td>859.76</td>\n",
       "      <td>859.75</td>\n",
       "      <td>859.54</td>\n",
       "      <td>363.956895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-03-05 19:30:00</td>\n",
       "      <td>856.09</td>\n",
       "      <td>859.72</td>\n",
       "      <td>859.72</td>\n",
       "      <td>856.09</td>\n",
       "      <td>478.473793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-03-05 19:45:00</td>\n",
       "      <td>853.86</td>\n",
       "      <td>857.07</td>\n",
       "      <td>856.09</td>\n",
       "      <td>855.51</td>\n",
       "      <td>630.221570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-03-05 20:00:00</td>\n",
       "      <td>855.35</td>\n",
       "      <td>856.87</td>\n",
       "      <td>855.51</td>\n",
       "      <td>855.56</td>\n",
       "      <td>405.935938</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2018-03-05 20:15:00</td>\n",
       "      <td>854.65</td>\n",
       "      <td>856.40</td>\n",
       "      <td>855.56</td>\n",
       "      <td>854.66</td>\n",
       "      <td>515.947029</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-03-05 20:30:00</td>\n",
       "      <td>852.70</td>\n",
       "      <td>854.66</td>\n",
       "      <td>854.66</td>\n",
       "      <td>853.00</td>\n",
       "      <td>660.237229</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-03-05 20:45:00</td>\n",
       "      <td>852.01</td>\n",
       "      <td>853.39</td>\n",
       "      <td>852.99</td>\n",
       "      <td>853.06</td>\n",
       "      <td>674.913281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-03-05 21:00:00</td>\n",
       "      <td>853.05</td>\n",
       "      <td>853.39</td>\n",
       "      <td>853.05</td>\n",
       "      <td>853.39</td>\n",
       "      <td>353.052420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2018-03-05 21:15:00</td>\n",
       "      <td>853.05</td>\n",
       "      <td>853.39</td>\n",
       "      <td>853.39</td>\n",
       "      <td>853.07</td>\n",
       "      <td>335.011459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-03-05 21:30:00</td>\n",
       "      <td>850.00</td>\n",
       "      <td>853.07</td>\n",
       "      <td>853.06</td>\n",
       "      <td>851.60</td>\n",
       "      <td>1312.261316</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-03-05 21:45:00</td>\n",
       "      <td>851.00</td>\n",
       "      <td>852.76</td>\n",
       "      <td>851.61</td>\n",
       "      <td>852.65</td>\n",
       "      <td>639.853622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-03-05 22:00:00</td>\n",
       "      <td>851.37</td>\n",
       "      <td>854.09</td>\n",
       "      <td>852.64</td>\n",
       "      <td>853.63</td>\n",
       "      <td>585.624937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-03-05 22:15:00</td>\n",
       "      <td>852.71</td>\n",
       "      <td>854.61</td>\n",
       "      <td>853.54</td>\n",
       "      <td>854.31</td>\n",
       "      <td>260.135859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-03-05 22:30:00</td>\n",
       "      <td>853.67</td>\n",
       "      <td>854.31</td>\n",
       "      <td>854.30</td>\n",
       "      <td>854.18</td>\n",
       "      <td>329.971765</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-03-05 22:45:00</td>\n",
       "      <td>852.70</td>\n",
       "      <td>854.50</td>\n",
       "      <td>854.19</td>\n",
       "      <td>853.93</td>\n",
       "      <td>252.594546</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-03-05 23:00:00</td>\n",
       "      <td>853.42</td>\n",
       "      <td>854.50</td>\n",
       "      <td>853.76</td>\n",
       "      <td>853.42</td>\n",
       "      <td>305.443990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-03-05 23:15:00</td>\n",
       "      <td>851.51</td>\n",
       "      <td>853.43</td>\n",
       "      <td>853.43</td>\n",
       "      <td>852.45</td>\n",
       "      <td>378.303331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-03-05 23:30:00</td>\n",
       "      <td>851.51</td>\n",
       "      <td>852.68</td>\n",
       "      <td>852.46</td>\n",
       "      <td>852.04</td>\n",
       "      <td>295.210846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-03-05 23:45:00</td>\n",
       "      <td>848.83</td>\n",
       "      <td>852.38</td>\n",
       "      <td>852.05</td>\n",
       "      <td>848.83</td>\n",
       "      <td>1002.927028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-03-06 00:00:00</td>\n",
       "      <td>845.00</td>\n",
       "      <td>848.83</td>\n",
       "      <td>848.83</td>\n",
       "      <td>845.01</td>\n",
       "      <td>1060.817136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-03-06 00:15:00</td>\n",
       "      <td>841.50</td>\n",
       "      <td>845.01</td>\n",
       "      <td>845.01</td>\n",
       "      <td>841.51</td>\n",
       "      <td>1580.089714</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-03-06 00:30:00</td>\n",
       "      <td>841.27</td>\n",
       "      <td>842.72</td>\n",
       "      <td>841.51</td>\n",
       "      <td>841.28</td>\n",
       "      <td>864.545325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2018-03-06 00:45:00</td>\n",
       "      <td>841.20</td>\n",
       "      <td>841.30</td>\n",
       "      <td>841.28</td>\n",
       "      <td>841.21</td>\n",
       "      <td>732.524099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-03-06 01:00:00</td>\n",
       "      <td>839.00</td>\n",
       "      <td>841.21</td>\n",
       "      <td>841.21</td>\n",
       "      <td>839.10</td>\n",
       "      <td>1278.663657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018-03-06 01:15:00</td>\n",
       "      <td>838.88</td>\n",
       "      <td>839.50</td>\n",
       "      <td>839.10</td>\n",
       "      <td>838.95</td>\n",
       "      <td>338.720061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-03-06 01:30:00</td>\n",
       "      <td>838.95</td>\n",
       "      <td>841.00</td>\n",
       "      <td>838.95</td>\n",
       "      <td>840.00</td>\n",
       "      <td>674.456015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2018-03-06 01:45:00</td>\n",
       "      <td>839.99</td>\n",
       "      <td>842.92</td>\n",
       "      <td>840.00</td>\n",
       "      <td>842.75</td>\n",
       "      <td>549.472468</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>2018-03-06 12:00:00</td>\n",
       "      <td>833.34</td>\n",
       "      <td>834.96</td>\n",
       "      <td>833.34</td>\n",
       "      <td>833.50</td>\n",
       "      <td>326.062875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>2018-03-06 12:15:00</td>\n",
       "      <td>830.00</td>\n",
       "      <td>834.24</td>\n",
       "      <td>833.50</td>\n",
       "      <td>830.01</td>\n",
       "      <td>333.174393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>2018-03-06 12:30:00</td>\n",
       "      <td>828.75</td>\n",
       "      <td>831.00</td>\n",
       "      <td>830.01</td>\n",
       "      <td>829.64</td>\n",
       "      <td>449.343862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>2018-03-06 12:45:00</td>\n",
       "      <td>828.60</td>\n",
       "      <td>830.38</td>\n",
       "      <td>829.65</td>\n",
       "      <td>830.26</td>\n",
       "      <td>371.290560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>2018-03-06 13:00:00</td>\n",
       "      <td>829.00</td>\n",
       "      <td>830.26</td>\n",
       "      <td>830.26</td>\n",
       "      <td>829.00</td>\n",
       "      <td>454.789752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>2018-03-06 13:15:00</td>\n",
       "      <td>828.00</td>\n",
       "      <td>829.75</td>\n",
       "      <td>829.01</td>\n",
       "      <td>828.00</td>\n",
       "      <td>371.369208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>2018-03-06 13:30:00</td>\n",
       "      <td>823.18</td>\n",
       "      <td>828.00</td>\n",
       "      <td>828.00</td>\n",
       "      <td>823.18</td>\n",
       "      <td>731.498006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>2018-03-06 13:45:00</td>\n",
       "      <td>821.00</td>\n",
       "      <td>824.81</td>\n",
       "      <td>823.18</td>\n",
       "      <td>824.46</td>\n",
       "      <td>682.935872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>2018-03-06 14:00:00</td>\n",
       "      <td>822.20</td>\n",
       "      <td>824.50</td>\n",
       "      <td>824.00</td>\n",
       "      <td>823.38</td>\n",
       "      <td>406.937281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>2018-03-06 14:15:00</td>\n",
       "      <td>822.68</td>\n",
       "      <td>825.00</td>\n",
       "      <td>823.38</td>\n",
       "      <td>823.90</td>\n",
       "      <td>1052.106272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>2018-03-06 14:30:00</td>\n",
       "      <td>823.62</td>\n",
       "      <td>829.42</td>\n",
       "      <td>823.87</td>\n",
       "      <td>829.41</td>\n",
       "      <td>776.623191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>2018-03-06 14:45:00</td>\n",
       "      <td>829.00</td>\n",
       "      <td>829.42</td>\n",
       "      <td>829.42</td>\n",
       "      <td>829.40</td>\n",
       "      <td>579.413136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>2018-03-06 15:00:00</td>\n",
       "      <td>829.38</td>\n",
       "      <td>829.42</td>\n",
       "      <td>829.40</td>\n",
       "      <td>829.42</td>\n",
       "      <td>479.022323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>2018-03-06 15:15:00</td>\n",
       "      <td>829.40</td>\n",
       "      <td>830.00</td>\n",
       "      <td>829.42</td>\n",
       "      <td>829.96</td>\n",
       "      <td>618.087375</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>2018-03-06 15:30:00</td>\n",
       "      <td>829.96</td>\n",
       "      <td>831.00</td>\n",
       "      <td>829.97</td>\n",
       "      <td>830.51</td>\n",
       "      <td>383.885179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>2018-03-06 15:45:00</td>\n",
       "      <td>830.51</td>\n",
       "      <td>831.15</td>\n",
       "      <td>830.51</td>\n",
       "      <td>831.15</td>\n",
       "      <td>423.077223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>2018-03-06 16:00:00</td>\n",
       "      <td>830.00</td>\n",
       "      <td>831.51</td>\n",
       "      <td>831.14</td>\n",
       "      <td>830.01</td>\n",
       "      <td>753.964558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>2018-03-06 16:15:00</td>\n",
       "      <td>827.00</td>\n",
       "      <td>830.01</td>\n",
       "      <td>830.00</td>\n",
       "      <td>827.14</td>\n",
       "      <td>684.248704</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>2018-03-06 16:30:00</td>\n",
       "      <td>826.42</td>\n",
       "      <td>828.57</td>\n",
       "      <td>827.23</td>\n",
       "      <td>828.37</td>\n",
       "      <td>606.958136</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>2018-03-06 16:45:00</td>\n",
       "      <td>827.07</td>\n",
       "      <td>828.38</td>\n",
       "      <td>828.38</td>\n",
       "      <td>827.07</td>\n",
       "      <td>345.303085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>2018-03-06 17:00:00</td>\n",
       "      <td>823.50</td>\n",
       "      <td>827.39</td>\n",
       "      <td>827.07</td>\n",
       "      <td>824.61</td>\n",
       "      <td>932.804091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>2018-03-06 17:15:00</td>\n",
       "      <td>820.00</td>\n",
       "      <td>825.13</td>\n",
       "      <td>824.79</td>\n",
       "      <td>820.75</td>\n",
       "      <td>1280.534398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>2018-03-06 17:30:00</td>\n",
       "      <td>816.30</td>\n",
       "      <td>820.22</td>\n",
       "      <td>820.22</td>\n",
       "      <td>819.44</td>\n",
       "      <td>1405.331856</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>2018-03-06 17:45:00</td>\n",
       "      <td>816.01</td>\n",
       "      <td>819.44</td>\n",
       "      <td>819.44</td>\n",
       "      <td>816.73</td>\n",
       "      <td>1306.261941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>2018-03-06 18:00:00</td>\n",
       "      <td>816.44</td>\n",
       "      <td>821.99</td>\n",
       "      <td>816.44</td>\n",
       "      <td>821.21</td>\n",
       "      <td>920.348629</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>2018-03-06 18:15:00</td>\n",
       "      <td>820.92</td>\n",
       "      <td>822.50</td>\n",
       "      <td>821.21</td>\n",
       "      <td>820.98</td>\n",
       "      <td>407.356682</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2018-03-06 18:30:00</td>\n",
       "      <td>818.00</td>\n",
       "      <td>820.99</td>\n",
       "      <td>820.99</td>\n",
       "      <td>819.00</td>\n",
       "      <td>548.444364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>2018-03-06 18:45:00</td>\n",
       "      <td>811.81</td>\n",
       "      <td>819.00</td>\n",
       "      <td>819.00</td>\n",
       "      <td>811.99</td>\n",
       "      <td>1455.093729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>2018-03-06 19:00:00</td>\n",
       "      <td>804.45</td>\n",
       "      <td>812.00</td>\n",
       "      <td>812.00</td>\n",
       "      <td>807.09</td>\n",
       "      <td>2371.577347</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2018-03-06 19:15:00</td>\n",
       "      <td>803.53</td>\n",
       "      <td>809.99</td>\n",
       "      <td>807.10</td>\n",
       "      <td>804.15</td>\n",
       "      <td>1528.919896</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  time     low    high    open   close       volume\n",
       "0  2018-03-05 18:30:00  856.48  856.49  856.49  856.48    43.935593\n",
       "1  2018-03-05 18:45:00  856.48  859.81  856.48  858.86   766.554688\n",
       "2  2018-03-05 19:00:00  858.85  860.00  858.86  859.74   645.814996\n",
       "3  2018-03-05 19:15:00  859.00  859.76  859.75  859.54   363.956895\n",
       "4  2018-03-05 19:30:00  856.09  859.72  859.72  856.09   478.473793\n",
       "5  2018-03-05 19:45:00  853.86  857.07  856.09  855.51   630.221570\n",
       "6  2018-03-05 20:00:00  855.35  856.87  855.51  855.56   405.935938\n",
       "7  2018-03-05 20:15:00  854.65  856.40  855.56  854.66   515.947029\n",
       "8  2018-03-05 20:30:00  852.70  854.66  854.66  853.00   660.237229\n",
       "9  2018-03-05 20:45:00  852.01  853.39  852.99  853.06   674.913281\n",
       "10 2018-03-05 21:00:00  853.05  853.39  853.05  853.39   353.052420\n",
       "11 2018-03-05 21:15:00  853.05  853.39  853.39  853.07   335.011459\n",
       "12 2018-03-05 21:30:00  850.00  853.07  853.06  851.60  1312.261316\n",
       "13 2018-03-05 21:45:00  851.00  852.76  851.61  852.65   639.853622\n",
       "14 2018-03-05 22:00:00  851.37  854.09  852.64  853.63   585.624937\n",
       "15 2018-03-05 22:15:00  852.71  854.61  853.54  854.31   260.135859\n",
       "16 2018-03-05 22:30:00  853.67  854.31  854.30  854.18   329.971765\n",
       "17 2018-03-05 22:45:00  852.70  854.50  854.19  853.93   252.594546\n",
       "18 2018-03-05 23:00:00  853.42  854.50  853.76  853.42   305.443990\n",
       "19 2018-03-05 23:15:00  851.51  853.43  853.43  852.45   378.303331\n",
       "20 2018-03-05 23:30:00  851.51  852.68  852.46  852.04   295.210846\n",
       "21 2018-03-05 23:45:00  848.83  852.38  852.05  848.83  1002.927028\n",
       "22 2018-03-06 00:00:00  845.00  848.83  848.83  845.01  1060.817136\n",
       "23 2018-03-06 00:15:00  841.50  845.01  845.01  841.51  1580.089714\n",
       "24 2018-03-06 00:30:00  841.27  842.72  841.51  841.28   864.545325\n",
       "25 2018-03-06 00:45:00  841.20  841.30  841.28  841.21   732.524099\n",
       "26 2018-03-06 01:00:00  839.00  841.21  841.21  839.10  1278.663657\n",
       "27 2018-03-06 01:15:00  838.88  839.50  839.10  838.95   338.720061\n",
       "28 2018-03-06 01:30:00  838.95  841.00  838.95  840.00   674.456015\n",
       "29 2018-03-06 01:45:00  839.99  842.92  840.00  842.75   549.472468\n",
       "..                 ...     ...     ...     ...     ...          ...\n",
       "70 2018-03-06 12:00:00  833.34  834.96  833.34  833.50   326.062875\n",
       "71 2018-03-06 12:15:00  830.00  834.24  833.50  830.01   333.174393\n",
       "72 2018-03-06 12:30:00  828.75  831.00  830.01  829.64   449.343862\n",
       "73 2018-03-06 12:45:00  828.60  830.38  829.65  830.26   371.290560\n",
       "74 2018-03-06 13:00:00  829.00  830.26  830.26  829.00   454.789752\n",
       "75 2018-03-06 13:15:00  828.00  829.75  829.01  828.00   371.369208\n",
       "76 2018-03-06 13:30:00  823.18  828.00  828.00  823.18   731.498006\n",
       "77 2018-03-06 13:45:00  821.00  824.81  823.18  824.46   682.935872\n",
       "78 2018-03-06 14:00:00  822.20  824.50  824.00  823.38   406.937281\n",
       "79 2018-03-06 14:15:00  822.68  825.00  823.38  823.90  1052.106272\n",
       "80 2018-03-06 14:30:00  823.62  829.42  823.87  829.41   776.623191\n",
       "81 2018-03-06 14:45:00  829.00  829.42  829.42  829.40   579.413136\n",
       "82 2018-03-06 15:00:00  829.38  829.42  829.40  829.42   479.022323\n",
       "83 2018-03-06 15:15:00  829.40  830.00  829.42  829.96   618.087375\n",
       "84 2018-03-06 15:30:00  829.96  831.00  829.97  830.51   383.885179\n",
       "85 2018-03-06 15:45:00  830.51  831.15  830.51  831.15   423.077223\n",
       "86 2018-03-06 16:00:00  830.00  831.51  831.14  830.01   753.964558\n",
       "87 2018-03-06 16:15:00  827.00  830.01  830.00  827.14   684.248704\n",
       "88 2018-03-06 16:30:00  826.42  828.57  827.23  828.37   606.958136\n",
       "89 2018-03-06 16:45:00  827.07  828.38  828.38  827.07   345.303085\n",
       "90 2018-03-06 17:00:00  823.50  827.39  827.07  824.61   932.804091\n",
       "91 2018-03-06 17:15:00  820.00  825.13  824.79  820.75  1280.534398\n",
       "92 2018-03-06 17:30:00  816.30  820.22  820.22  819.44  1405.331856\n",
       "93 2018-03-06 17:45:00  816.01  819.44  819.44  816.73  1306.261941\n",
       "94 2018-03-06 18:00:00  816.44  821.99  816.44  821.21   920.348629\n",
       "95 2018-03-06 18:15:00  820.92  822.50  821.21  820.98   407.356682\n",
       "96 2018-03-06 18:30:00  818.00  820.99  820.99  819.00   548.444364\n",
       "97 2018-03-06 18:45:00  811.81  819.00  819.00  811.99  1455.093729\n",
       "98 2018-03-06 19:00:00  804.45  812.00  812.00  807.09  2371.577347\n",
       "99 2018-03-06 19:15:00  803.53  809.99  807.10  804.15  1528.919896\n",
       "\n",
       "[100 rows x 6 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "start = datetime.datetime.utcnow() - datetime.timedelta(minutes=15)*100\n",
    "end = datetime.datetime.utcnow()\n",
    "\n",
    "df = client.get_historical_data(start,end)\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>low</th>\n",
       "      <th>high</th>\n",
       "      <th>open</th>\n",
       "      <th>close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2018-03-06 20:47:00</td>\n",
       "      <td>654.80</td>\n",
       "      <td>655.99</td>\n",
       "      <td>654.80</td>\n",
       "      <td>655.29</td>\n",
       "      <td>4.706267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2018-03-06 20:46:00</td>\n",
       "      <td>653.98</td>\n",
       "      <td>654.80</td>\n",
       "      <td>653.98</td>\n",
       "      <td>654.80</td>\n",
       "      <td>10.108862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2018-03-06 20:45:00</td>\n",
       "      <td>653.97</td>\n",
       "      <td>653.98</td>\n",
       "      <td>653.97</td>\n",
       "      <td>653.98</td>\n",
       "      <td>5.340647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2018-03-06 20:44:00</td>\n",
       "      <td>653.98</td>\n",
       "      <td>653.98</td>\n",
       "      <td>653.98</td>\n",
       "      <td>653.98</td>\n",
       "      <td>0.753588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2018-03-06 20:43:00</td>\n",
       "      <td>652.60</td>\n",
       "      <td>653.98</td>\n",
       "      <td>652.60</td>\n",
       "      <td>653.98</td>\n",
       "      <td>3.023344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2018-03-06 20:42:00</td>\n",
       "      <td>652.55</td>\n",
       "      <td>652.60</td>\n",
       "      <td>652.55</td>\n",
       "      <td>652.59</td>\n",
       "      <td>18.132344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2018-03-06 20:41:00</td>\n",
       "      <td>652.55</td>\n",
       "      <td>652.55</td>\n",
       "      <td>652.55</td>\n",
       "      <td>652.55</td>\n",
       "      <td>0.173963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2018-03-06 20:40:00</td>\n",
       "      <td>651.99</td>\n",
       "      <td>652.55</td>\n",
       "      <td>651.99</td>\n",
       "      <td>652.55</td>\n",
       "      <td>1.963688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2018-03-06 20:39:00</td>\n",
       "      <td>651.90</td>\n",
       "      <td>651.91</td>\n",
       "      <td>651.90</td>\n",
       "      <td>651.91</td>\n",
       "      <td>4.196280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2018-03-06 20:38:00</td>\n",
       "      <td>651.90</td>\n",
       "      <td>651.90</td>\n",
       "      <td>651.90</td>\n",
       "      <td>651.90</td>\n",
       "      <td>0.450456</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2018-03-06 20:37:00</td>\n",
       "      <td>651.91</td>\n",
       "      <td>651.91</td>\n",
       "      <td>651.91</td>\n",
       "      <td>651.91</td>\n",
       "      <td>10.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2018-03-06 20:36:00</td>\n",
       "      <td>651.90</td>\n",
       "      <td>652.54</td>\n",
       "      <td>652.54</td>\n",
       "      <td>651.90</td>\n",
       "      <td>17.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2018-03-06 20:35:00</td>\n",
       "      <td>652.54</td>\n",
       "      <td>652.54</td>\n",
       "      <td>652.54</td>\n",
       "      <td>652.54</td>\n",
       "      <td>1.038912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2018-03-06 20:33:00</td>\n",
       "      <td>653.00</td>\n",
       "      <td>653.00</td>\n",
       "      <td>653.00</td>\n",
       "      <td>653.00</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2018-03-06 20:32:00</td>\n",
       "      <td>654.20</td>\n",
       "      <td>654.25</td>\n",
       "      <td>654.25</td>\n",
       "      <td>654.20</td>\n",
       "      <td>1.626925</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2018-03-06 20:31:00</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.26</td>\n",
       "      <td>0.562000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2018-03-06 20:30:00</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.26</td>\n",
       "      <td>1.923889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2018-03-06 20:29:00</td>\n",
       "      <td>654.25</td>\n",
       "      <td>654.26</td>\n",
       "      <td>654.25</td>\n",
       "      <td>654.26</td>\n",
       "      <td>3.416105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2018-03-06 20:27:00</td>\n",
       "      <td>654.30</td>\n",
       "      <td>654.30</td>\n",
       "      <td>654.30</td>\n",
       "      <td>654.30</td>\n",
       "      <td>0.688071</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2018-03-06 20:26:00</td>\n",
       "      <td>654.30</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.30</td>\n",
       "      <td>5.804519</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2018-03-06 20:25:00</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>1.640821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2018-03-06 20:24:00</td>\n",
       "      <td>654.80</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.80</td>\n",
       "      <td>1.288618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2018-03-06 20:23:00</td>\n",
       "      <td>654.80</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>654.81</td>\n",
       "      <td>0.510487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2018-03-06 20:22:00</td>\n",
       "      <td>654.80</td>\n",
       "      <td>654.80</td>\n",
       "      <td>654.80</td>\n",
       "      <td>654.80</td>\n",
       "      <td>3.065392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2018-03-06 20:21:00</td>\n",
       "      <td>654.80</td>\n",
       "      <td>654.86</td>\n",
       "      <td>654.85</td>\n",
       "      <td>654.86</td>\n",
       "      <td>1.514186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2018-03-06 20:20:00</td>\n",
       "      <td>654.30</td>\n",
       "      <td>654.88</td>\n",
       "      <td>654.88</td>\n",
       "      <td>654.30</td>\n",
       "      <td>8.756561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2018-03-06 20:19:00</td>\n",
       "      <td>654.88</td>\n",
       "      <td>654.89</td>\n",
       "      <td>654.89</td>\n",
       "      <td>654.88</td>\n",
       "      <td>0.237684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018-03-06 20:18:00</td>\n",
       "      <td>654.30</td>\n",
       "      <td>654.95</td>\n",
       "      <td>654.95</td>\n",
       "      <td>654.89</td>\n",
       "      <td>2.582167</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2018-03-06 20:17:00</td>\n",
       "      <td>654.30</td>\n",
       "      <td>655.00</td>\n",
       "      <td>655.00</td>\n",
       "      <td>654.95</td>\n",
       "      <td>7.433799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2018-03-06 20:16:00</td>\n",
       "      <td>655.00</td>\n",
       "      <td>656.08</td>\n",
       "      <td>656.08</td>\n",
       "      <td>656.08</td>\n",
       "      <td>5.996687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>2018-03-06 16:29:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>0.871042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>2018-03-06 16:28:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>3.075579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>2018-03-06 16:27:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>0.071214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>2018-03-06 16:24:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>0.066466</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>2018-03-06 16:23:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>3.687820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>2018-03-06 16:22:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>0.833204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>2018-03-06 16:20:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>36.395920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>2018-03-06 16:19:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>1.094348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>2018-03-06 16:18:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>0.128319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>2018-03-06 16:16:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>673.00</td>\n",
       "      <td>673.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>7.659028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>2018-03-06 16:15:00</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.01</td>\n",
       "      <td>44.679372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>2018-03-06 16:14:00</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>0.386987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>2018-03-06 16:13:00</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.02</td>\n",
       "      <td>0.478832</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>2018-03-06 16:11:00</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.01</td>\n",
       "      <td>0.080000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>2018-03-06 16:10:00</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.01</td>\n",
       "      <td>4.856741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>2018-03-06 16:07:00</td>\n",
       "      <td>673.01</td>\n",
       "      <td>673.13</td>\n",
       "      <td>673.13</td>\n",
       "      <td>673.01</td>\n",
       "      <td>2.916186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>2018-03-06 16:06:00</td>\n",
       "      <td>673.02</td>\n",
       "      <td>673.56</td>\n",
       "      <td>673.56</td>\n",
       "      <td>673.27</td>\n",
       "      <td>3.883835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>2018-03-06 16:05:00</td>\n",
       "      <td>672.11</td>\n",
       "      <td>673.97</td>\n",
       "      <td>673.97</td>\n",
       "      <td>672.11</td>\n",
       "      <td>25.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>2018-03-06 16:03:00</td>\n",
       "      <td>673.22</td>\n",
       "      <td>674.23</td>\n",
       "      <td>673.22</td>\n",
       "      <td>673.98</td>\n",
       "      <td>14.874706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>2018-03-06 16:02:00</td>\n",
       "      <td>672.21</td>\n",
       "      <td>673.18</td>\n",
       "      <td>672.21</td>\n",
       "      <td>673.18</td>\n",
       "      <td>15.661113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>2018-03-06 16:00:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.85</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.85</td>\n",
       "      <td>1.816638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>2018-03-06 15:59:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>0.060000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>2018-03-06 15:58:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.00</td>\n",
       "      <td>0.779630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>2018-03-06 15:57:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>7.277108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>2018-03-06 15:56:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>1.337218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>2018-03-06 15:53:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>1.750674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>2018-03-06 15:52:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>3.000033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>2018-03-06 15:51:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>0.109414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>2018-03-06 15:50:00</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>3.884583</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>2018-03-06 15:49:00</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>672.01</td>\n",
       "      <td>0.194181</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>242 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   time     low    high    open   close     volume\n",
       "0   2018-03-06 20:47:00  654.80  655.99  654.80  655.29   4.706267\n",
       "1   2018-03-06 20:46:00  653.98  654.80  653.98  654.80  10.108862\n",
       "2   2018-03-06 20:45:00  653.97  653.98  653.97  653.98   5.340647\n",
       "3   2018-03-06 20:44:00  653.98  653.98  653.98  653.98   0.753588\n",
       "4   2018-03-06 20:43:00  652.60  653.98  652.60  653.98   3.023344\n",
       "5   2018-03-06 20:42:00  652.55  652.60  652.55  652.59  18.132344\n",
       "6   2018-03-06 20:41:00  652.55  652.55  652.55  652.55   0.173963\n",
       "7   2018-03-06 20:40:00  651.99  652.55  651.99  652.55   1.963688\n",
       "8   2018-03-06 20:39:00  651.90  651.91  651.90  651.91   4.196280\n",
       "9   2018-03-06 20:38:00  651.90  651.90  651.90  651.90   0.450456\n",
       "10  2018-03-06 20:37:00  651.91  651.91  651.91  651.91  10.000000\n",
       "11  2018-03-06 20:36:00  651.90  652.54  652.54  651.90  17.000000\n",
       "12  2018-03-06 20:35:00  652.54  652.54  652.54  652.54   1.038912\n",
       "13  2018-03-06 20:33:00  653.00  653.00  653.00  653.00   1.000000\n",
       "14  2018-03-06 20:32:00  654.20  654.25  654.25  654.20   1.626925\n",
       "15  2018-03-06 20:31:00  654.26  654.26  654.26  654.26   0.562000\n",
       "16  2018-03-06 20:30:00  654.26  654.26  654.26  654.26   1.923889\n",
       "17  2018-03-06 20:29:00  654.25  654.26  654.25  654.26   3.416105\n",
       "18  2018-03-06 20:27:00  654.30  654.30  654.30  654.30   0.688071\n",
       "19  2018-03-06 20:26:00  654.30  654.81  654.81  654.30   5.804519\n",
       "20  2018-03-06 20:25:00  654.81  654.81  654.81  654.81   1.640821\n",
       "21  2018-03-06 20:24:00  654.80  654.81  654.81  654.80   1.288618\n",
       "22  2018-03-06 20:23:00  654.80  654.81  654.81  654.81   0.510487\n",
       "23  2018-03-06 20:22:00  654.80  654.80  654.80  654.80   3.065392\n",
       "24  2018-03-06 20:21:00  654.80  654.86  654.85  654.86   1.514186\n",
       "25  2018-03-06 20:20:00  654.30  654.88  654.88  654.30   8.756561\n",
       "26  2018-03-06 20:19:00  654.88  654.89  654.89  654.88   0.237684\n",
       "27  2018-03-06 20:18:00  654.30  654.95  654.95  654.89   2.582167\n",
       "28  2018-03-06 20:17:00  654.30  655.00  655.00  654.95   7.433799\n",
       "29  2018-03-06 20:16:00  655.00  656.08  656.08  656.08   5.996687\n",
       "..                  ...     ...     ...     ...     ...        ...\n",
       "212 2018-03-06 16:29:00  672.00  672.01  672.01  672.01   0.871042\n",
       "213 2018-03-06 16:28:00  672.01  672.01  672.01  672.01   3.075579\n",
       "214 2018-03-06 16:27:00  672.01  672.01  672.01  672.01   0.071214\n",
       "215 2018-03-06 16:24:00  672.01  672.01  672.01  672.01   0.066466\n",
       "216 2018-03-06 16:23:00  672.00  672.00  672.00  672.00   3.687820\n",
       "217 2018-03-06 16:22:00  672.00  672.00  672.00  672.00   0.833204\n",
       "218 2018-03-06 16:20:00  672.01  672.01  672.01  672.01  36.395920\n",
       "219 2018-03-06 16:19:00  672.01  672.01  672.01  672.01   1.094348\n",
       "220 2018-03-06 16:18:00  672.01  672.01  672.01  672.01   0.128319\n",
       "221 2018-03-06 16:16:00  672.01  673.00  673.00  672.01   7.659028\n",
       "222 2018-03-06 16:15:00  673.01  673.02  673.02  673.01  44.679372\n",
       "223 2018-03-06 16:14:00  673.02  673.02  673.02  673.02   0.386987\n",
       "224 2018-03-06 16:13:00  673.02  673.02  673.02  673.02   0.478832\n",
       "225 2018-03-06 16:11:00  673.01  673.01  673.01  673.01   0.080000\n",
       "226 2018-03-06 16:10:00  673.01  673.01  673.01  673.01   4.856741\n",
       "227 2018-03-06 16:07:00  673.01  673.13  673.13  673.01   2.916186\n",
       "228 2018-03-06 16:06:00  673.02  673.56  673.56  673.27   3.883835\n",
       "229 2018-03-06 16:05:00  672.11  673.97  673.97  672.11  25.000000\n",
       "230 2018-03-06 16:03:00  673.22  674.23  673.22  673.98  14.874706\n",
       "231 2018-03-06 16:02:00  672.21  673.18  672.21  673.18  15.661113\n",
       "232 2018-03-06 16:00:00  672.01  672.85  672.01  672.85   1.816638\n",
       "233 2018-03-06 15:59:00  672.00  672.00  672.00  672.00   0.060000\n",
       "234 2018-03-06 15:58:00  672.00  672.01  672.01  672.00   0.779630\n",
       "235 2018-03-06 15:57:00  672.01  672.01  672.01  672.01   7.277108\n",
       "236 2018-03-06 15:56:00  672.00  672.01  672.00  672.01   1.337218\n",
       "237 2018-03-06 15:53:00  672.01  672.01  672.01  672.01   1.750674\n",
       "238 2018-03-06 15:52:00  672.01  672.01  672.01  672.01   3.000033\n",
       "239 2018-03-06 15:51:00  672.01  672.01  672.01  672.01   0.109414\n",
       "240 2018-03-06 15:50:00  672.00  672.01  672.00  672.01   3.884583\n",
       "241 2018-03-06 15:49:00  672.01  672.01  672.01  672.01   0.194181\n",
       "\n",
       "[242 rows x 6 columns]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "public_client = gdax.PublicClient()\n",
    "data = public_client.get_product_historic_rates('ETH-EUR', granularity=60)\n",
    "df = pd.DataFrame(data, columns=['time','low','high','open', 'close', 'volume'])\n",
    "df.time = pd.to_datetime(df['time'], unit='s')\n",
    "display(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}