Gatherer.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "<img src=\"images/splash3.png\">\n",
    "Grabs price and volume for the top 100 cryptos for the past 3 months.\n",
    "\n",
    "OOP update#2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Setup"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sqlite3 as lite\n",
    "import sys\n",
    "import coinmarketcap\n",
    "import requests\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import datetime\n",
    "import matplotlib\n",
    "import matplotlib.pyplot as plt\n",
    "%matplotlib inline\n",
    "pd.set_option(\"display.max_rows\", 200)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Fetch data\n",
    "Uses cryptocompare API to get historical data for target coin the last 3 months, coinmarketcap api to get top-100 coin names. Timestamps are in unix (GMT)."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def fetch_top100():\n",
    "    url = 'https://api.coinmarketcap.com/v2/ticker/'\n",
    "    page = requests.get(url)\n",
    "    data = page.json()['data']\n",
    "    coinlist = pd.DataFrame(data)\n",
    "    return coinlist"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "def fetch_coindata(symbol, comparison_symbol, limit, aggregate):    \n",
    "    url = 'https://min-api.cryptocompare.com/data/histohour?fsym={}&tsym={}&limit={}&aggregate={}'\\\n",
    "            .format(symbol.upper(), comparison_symbol.upper(), limit, aggregate)       \n",
    "    page = requests.get(url)\n",
    "    data = page.json()['Data']\n",
    "    df = pd.DataFrame(data)\n",
    "    df['mid'] = df[[\"high\", \"low\"]].mean(axis=1)\n",
    "    df['timestamp'] = [datetime.datetime.fromtimestamp(d).strftime('%d-%m-%Y %H:%M:%S') for d in df.time]\n",
    "    #df = df.set_index('timestamp')        \n",
    "    return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Store values to database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "def write_to_db():\n",
    "    #Connect to DB\n",
    "    con = None\n",
    "    con = lite.connect('/hdd/db/crypto.db')\n",
    "\n",
    "    #Dump to SQL\n",
    "    with con:\n",
    "        market_data.to_sql(name=top_coins[symbol], con=con, if_exists='replace', index=True)\n",
    "\n",
    "    \"\"\"\"\n",
    "    #Read SQL    \n",
    "    with con:        \n",
    "        cur = con.cursor()    \n",
    "        cur.execute(\"SELECT * FROM btc\")\n",
    "\n",
    "        rows = cur.fetchall()\n",
    "\n",
    "        for row in rows:\n",
    "            print(row)  \n",
    "    \"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Error noticed, skipping coin  MIOTA\n",
      "Error noticed, skipping coin  CENNZ\n",
      "Success!\n"
     ]
    }
   ],
   "source": [
    "top_coins = fetch_top100().loc['symbol']\n",
    "\n",
    "for symbol in range(1, 100):\n",
    "    try:\n",
    "        market_data = fetch_coindata(top_coins[symbol],'BTC','2000','12')\n",
    "        market_data = market_data.drop(market_data.index[len(market_data)-1]) # Only keep the latest timestamped column\n",
    "        write_to_db()\n",
    "    except:\n",
    "        print(\"Error noticed, skipping coin \", top_coins[symbol])\n",
    "        \n",
    "print(\"Success!\")"
   ]
  },
  {
   "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>close</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>open</th>\n",
       "      <th>time</th>\n",
       "      <th>volumefrom</th>\n",
       "      <th>volumeto</th>\n",
       "      <th>mid</th>\n",
       "      <th>timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1521417600</td>\n",
       "      <td>3.131684e+07</td>\n",
       "      <td>1081.88</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>19-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1521460800</td>\n",
       "      <td>7.559852e+07</td>\n",
       "      <td>2518.36</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>19-03-2018 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1521504000</td>\n",
       "      <td>1.352212e+08</td>\n",
       "      <td>4963.87</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>20-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1521547200</td>\n",
       "      <td>7.237028e+07</td>\n",
       "      <td>2554.28</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>20-03-2018 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1521590400</td>\n",
       "      <td>5.661058e+07</td>\n",
       "      <td>1921.20</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>21-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1521633600</td>\n",
       "      <td>3.483557e+07</td>\n",
       "      <td>1148.52</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>21-03-2018 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1521676800</td>\n",
       "      <td>3.055480e+07</td>\n",
       "      <td>1011.33</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>22-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1521720000</td>\n",
       "      <td>2.033199e+07</td>\n",
       "      <td>685.81</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>22-03-2018 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1521763200</td>\n",
       "      <td>1.442959e+07</td>\n",
       "      <td>475.13</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>23-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1521806400</td>\n",
       "      <td>1.987574e+07</td>\n",
       "      <td>631.06</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>23-03-2018 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>1521849600</td>\n",
       "      <td>1.696110e+07</td>\n",
       "      <td>536.85</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>24-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1521892800</td>\n",
       "      <td>1.424799e+07</td>\n",
       "      <td>458.44</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>24-03-2018 13:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1521936000</td>\n",
       "      <td>9.252539e+06</td>\n",
       "      <td>299.14</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>25-03-2018 01:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1521979200</td>\n",
       "      <td>3.689033e+07</td>\n",
       "      <td>1279.28</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>25-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1522022400</td>\n",
       "      <td>1.681919e+07</td>\n",
       "      <td>556.72</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>26-03-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522065600</td>\n",
       "      <td>1.485316e+07</td>\n",
       "      <td>483.07</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>26-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522108800</td>\n",
       "      <td>1.096563e+07</td>\n",
       "      <td>348.12</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>27-03-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522152000</td>\n",
       "      <td>1.218036e+07</td>\n",
       "      <td>387.92</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>27-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522195200</td>\n",
       "      <td>1.125811e+07</td>\n",
       "      <td>356.81</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>28-03-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522238400</td>\n",
       "      <td>8.000800e+06</td>\n",
       "      <td>254.64</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>28-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522281600</td>\n",
       "      <td>1.312502e+07</td>\n",
       "      <td>412.37</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>29-03-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>1522324800</td>\n",
       "      <td>1.121262e+07</td>\n",
       "      <td>348.33</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>29-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>1522368000</td>\n",
       "      <td>1.731958e+07</td>\n",
       "      <td>545.15</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>30-03-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>1522411200</td>\n",
       "      <td>1.353176e+07</td>\n",
       "      <td>434.87</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>30-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522454400</td>\n",
       "      <td>1.021191e+07</td>\n",
       "      <td>324.53</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>31-03-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>1522497600</td>\n",
       "      <td>6.334395e+06</td>\n",
       "      <td>198.90</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>31-03-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522540800</td>\n",
       "      <td>7.373795e+06</td>\n",
       "      <td>231.89</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>01-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>1522584000</td>\n",
       "      <td>8.494887e+06</td>\n",
       "      <td>262.26</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>01-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>0.000030</td>\n",
       "      <td>1522627200</td>\n",
       "      <td>1.617063e+07</td>\n",
       "      <td>499.10</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>02-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>0.000031</td>\n",
       "      <td>1522670400</td>\n",
       "      <td>1.484980e+07</td>\n",
       "      <td>472.14</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>02-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522713600</td>\n",
       "      <td>3.389253e+07</td>\n",
       "      <td>1129.63</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>03-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1522756800</td>\n",
       "      <td>1.259968e+07</td>\n",
       "      <td>420.88</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>03-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1522800000</td>\n",
       "      <td>1.907650e+07</td>\n",
       "      <td>645.12</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>04-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1522843200</td>\n",
       "      <td>7.815200e+06</td>\n",
       "      <td>257.41</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>04-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1522886400</td>\n",
       "      <td>2.526723e+07</td>\n",
       "      <td>837.11</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>05-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1522929600</td>\n",
       "      <td>8.349186e+06</td>\n",
       "      <td>270.27</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>05-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1522972800</td>\n",
       "      <td>8.525377e+06</td>\n",
       "      <td>279.04</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>06-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1523016000</td>\n",
       "      <td>6.988498e+06</td>\n",
       "      <td>228.70</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>06-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1523059200</td>\n",
       "      <td>6.519682e+06</td>\n",
       "      <td>213.25</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>07-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1523102400</td>\n",
       "      <td>4.737171e+06</td>\n",
       "      <td>152.80</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>07-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1523145600</td>\n",
       "      <td>7.063313e+06</td>\n",
       "      <td>231.28</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>08-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1523188800</td>\n",
       "      <td>6.032101e+06</td>\n",
       "      <td>198.08</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>08-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1523232000</td>\n",
       "      <td>1.142017e+07</td>\n",
       "      <td>382.27</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>09-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1523275200</td>\n",
       "      <td>6.343580e+06</td>\n",
       "      <td>212.14</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>09-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1523318400</td>\n",
       "      <td>5.438085e+06</td>\n",
       "      <td>182.47</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>10-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1523361600</td>\n",
       "      <td>8.228800e+06</td>\n",
       "      <td>279.82</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>10-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1523404800</td>\n",
       "      <td>6.883246e+06</td>\n",
       "      <td>236.64</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>11-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1523448000</td>\n",
       "      <td>9.360712e+06</td>\n",
       "      <td>325.88</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>11-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1523491200</td>\n",
       "      <td>1.567847e+07</td>\n",
       "      <td>546.45</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>12-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1523534400</td>\n",
       "      <td>1.183165e+07</td>\n",
       "      <td>405.89</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>12-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1523577600</td>\n",
       "      <td>1.747709e+07</td>\n",
       "      <td>618.93</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>13-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>1523620800</td>\n",
       "      <td>1.839860e+07</td>\n",
       "      <td>679.21</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>13-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>1523664000</td>\n",
       "      <td>9.235827e+06</td>\n",
       "      <td>338.10</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>14-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1523707200</td>\n",
       "      <td>8.143282e+06</td>\n",
       "      <td>302.88</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>14-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1523750400</td>\n",
       "      <td>2.020262e+07</td>\n",
       "      <td>800.96</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>15-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>1523793600</td>\n",
       "      <td>1.525983e+07</td>\n",
       "      <td>627.23</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>15-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1523836800</td>\n",
       "      <td>2.156147e+07</td>\n",
       "      <td>929.10</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>16-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1523880000</td>\n",
       "      <td>1.221810e+07</td>\n",
       "      <td>503.98</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>16-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1523923200</td>\n",
       "      <td>1.245237e+07</td>\n",
       "      <td>523.19</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>17-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1523966400</td>\n",
       "      <td>9.216750e+06</td>\n",
       "      <td>390.39</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>17-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524009600</td>\n",
       "      <td>2.090148e+07</td>\n",
       "      <td>941.78</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>18-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1524052800</td>\n",
       "      <td>9.721423e+06</td>\n",
       "      <td>438.05</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>18-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>1524096000</td>\n",
       "      <td>1.686594e+07</td>\n",
       "      <td>779.53</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>19-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>1524139200</td>\n",
       "      <td>8.562988e+06</td>\n",
       "      <td>395.89</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>19-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>1524182400</td>\n",
       "      <td>1.308026e+07</td>\n",
       "      <td>604.67</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>20-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>1524225600</td>\n",
       "      <td>9.010903e+06</td>\n",
       "      <td>414.54</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>20-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000047</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>1524268800</td>\n",
       "      <td>1.528547e+07</td>\n",
       "      <td>678.69</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>21-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1524312000</td>\n",
       "      <td>9.107297e+06</td>\n",
       "      <td>389.42</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>21-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524355200</td>\n",
       "      <td>6.422876e+06</td>\n",
       "      <td>276.95</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>22-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1524398400</td>\n",
       "      <td>8.114425e+06</td>\n",
       "      <td>359.60</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>22-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1524441600</td>\n",
       "      <td>7.317398e+06</td>\n",
       "      <td>318.32</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>23-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524484800</td>\n",
       "      <td>8.264467e+06</td>\n",
       "      <td>362.61</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>23-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1524528000</td>\n",
       "      <td>8.110176e+06</td>\n",
       "      <td>356.59</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>24-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1524571200</td>\n",
       "      <td>1.055716e+07</td>\n",
       "      <td>470.63</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>24-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000048</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1524614400</td>\n",
       "      <td>2.546189e+07</td>\n",
       "      <td>1106.59</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>25-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1524657600</td>\n",
       "      <td>9.356568e+06</td>\n",
       "      <td>391.11</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>25-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1524700800</td>\n",
       "      <td>8.288558e+06</td>\n",
       "      <td>350.29</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>26-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524744000</td>\n",
       "      <td>8.011168e+06</td>\n",
       "      <td>345.03</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>26-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524787200</td>\n",
       "      <td>1.146119e+07</td>\n",
       "      <td>499.51</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>27-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524830400</td>\n",
       "      <td>7.948145e+06</td>\n",
       "      <td>343.72</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>27-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524873600</td>\n",
       "      <td>7.273042e+06</td>\n",
       "      <td>312.43</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>28-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1524916800</td>\n",
       "      <td>1.754246e+07</td>\n",
       "      <td>777.05</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>28-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1524960000</td>\n",
       "      <td>1.594219e+07</td>\n",
       "      <td>717.34</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>29-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1525003200</td>\n",
       "      <td>8.053422e+06</td>\n",
       "      <td>361.59</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>29-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525046400</td>\n",
       "      <td>1.069514e+07</td>\n",
       "      <td>475.43</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>30-04-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1525089600</td>\n",
       "      <td>6.356512e+06</td>\n",
       "      <td>280.63</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>30-04-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1525132800</td>\n",
       "      <td>9.656039e+06</td>\n",
       "      <td>421.37</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>01-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1525176000</td>\n",
       "      <td>7.843199e+06</td>\n",
       "      <td>345.78</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>01-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525219200</td>\n",
       "      <td>9.570749e+06</td>\n",
       "      <td>426.50</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>02-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525262400</td>\n",
       "      <td>1.415757e+07</td>\n",
       "      <td>644.06</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>02-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>1525305600</td>\n",
       "      <td>8.459946e+06</td>\n",
       "      <td>383.66</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>03-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000046</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525348800</td>\n",
       "      <td>1.574974e+07</td>\n",
       "      <td>714.75</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>03-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525392000</td>\n",
       "      <td>8.652165e+06</td>\n",
       "      <td>384.99</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>04-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525435200</td>\n",
       "      <td>7.369900e+06</td>\n",
       "      <td>326.63</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>04-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>1525478400</td>\n",
       "      <td>8.253814e+06</td>\n",
       "      <td>365.63</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>05-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1525521600</td>\n",
       "      <td>6.371374e+06</td>\n",
       "      <td>276.74</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>05-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1525564800</td>\n",
       "      <td>8.713399e+06</td>\n",
       "      <td>371.18</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>06-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1525608000</td>\n",
       "      <td>5.755066e+06</td>\n",
       "      <td>245.84</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>06-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>1525651200</td>\n",
       "      <td>8.315108e+06</td>\n",
       "      <td>346.46</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>07-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000043</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1525694400</td>\n",
       "      <td>8.440813e+06</td>\n",
       "      <td>351.34</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>07-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1525737600</td>\n",
       "      <td>6.003338e+06</td>\n",
       "      <td>250.02</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>08-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1525780800</td>\n",
       "      <td>7.619678e+06</td>\n",
       "      <td>312.09</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>08-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1525824000</td>\n",
       "      <td>1.044966e+07</td>\n",
       "      <td>419.71</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>09-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1525867200</td>\n",
       "      <td>8.589110e+06</td>\n",
       "      <td>352.24</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>09-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1525910400</td>\n",
       "      <td>8.718304e+06</td>\n",
       "      <td>354.09</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>10-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>1525953600</td>\n",
       "      <td>1.158372e+07</td>\n",
       "      <td>460.91</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>10-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1525996800</td>\n",
       "      <td>2.426385e+07</td>\n",
       "      <td>899.84</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>11-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1526040000</td>\n",
       "      <td>1.345504e+07</td>\n",
       "      <td>497.84</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>11-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1526083200</td>\n",
       "      <td>1.074791e+07</td>\n",
       "      <td>404.85</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>12-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1526126400</td>\n",
       "      <td>1.103305e+07</td>\n",
       "      <td>425.41</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>12-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1526169600</td>\n",
       "      <td>5.012946e+06</td>\n",
       "      <td>194.96</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>13-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1526212800</td>\n",
       "      <td>1.366308e+07</td>\n",
       "      <td>547.04</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>13-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>1526256000</td>\n",
       "      <td>2.843347e+07</td>\n",
       "      <td>1191.61</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>14-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000045</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>1526299200</td>\n",
       "      <td>4.048515e+07</td>\n",
       "      <td>1762.58</td>\n",
       "      <td>0.000044</td>\n",
       "      <td>14-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000041</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1526342400</td>\n",
       "      <td>1.259440e+07</td>\n",
       "      <td>525.94</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>15-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000042</td>\n",
       "      <td>1526385600</td>\n",
       "      <td>1.722131e+07</td>\n",
       "      <td>694.02</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>15-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1526428800</td>\n",
       "      <td>1.522221e+07</td>\n",
       "      <td>587.99</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>16-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000040</td>\n",
       "      <td>1526472000</td>\n",
       "      <td>8.556551e+06</td>\n",
       "      <td>331.53</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>16-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1526515200</td>\n",
       "      <td>8.257754e+06</td>\n",
       "      <td>321.27</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>17-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000039</td>\n",
       "      <td>1526558400</td>\n",
       "      <td>1.171400e+07</td>\n",
       "      <td>441.73</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>17-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1526601600</td>\n",
       "      <td>9.513560e+06</td>\n",
       "      <td>353.02</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>18-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1526644800</td>\n",
       "      <td>9.292571e+06</td>\n",
       "      <td>347.69</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>18-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1526688000</td>\n",
       "      <td>6.283266e+06</td>\n",
       "      <td>235.45</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>19-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1526731200</td>\n",
       "      <td>7.177846e+06</td>\n",
       "      <td>268.72</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>19-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1526774400</td>\n",
       "      <td>8.777462e+06</td>\n",
       "      <td>329.85</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>20-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1526817600</td>\n",
       "      <td>8.348193e+06</td>\n",
       "      <td>315.08</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>20-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>1526860800</td>\n",
       "      <td>9.796113e+06</td>\n",
       "      <td>368.53</td>\n",
       "      <td>0.000038</td>\n",
       "      <td>21-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1526904000</td>\n",
       "      <td>8.500268e+06</td>\n",
       "      <td>313.53</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>21-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>1526947200</td>\n",
       "      <td>6.599243e+06</td>\n",
       "      <td>242.16</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>22-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000037</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>1526990400</td>\n",
       "      <td>1.217824e+07</td>\n",
       "      <td>438.90</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>22-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>1527033600</td>\n",
       "      <td>1.311950e+07</td>\n",
       "      <td>457.14</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>23-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1527076800</td>\n",
       "      <td>1.786907e+07</td>\n",
       "      <td>625.63</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>23-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527120000</td>\n",
       "      <td>8.201852e+06</td>\n",
       "      <td>284.74</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>24-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527163200</td>\n",
       "      <td>1.033750e+07</td>\n",
       "      <td>362.77</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>24-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>1527206400</td>\n",
       "      <td>8.492334e+06</td>\n",
       "      <td>301.28</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>25-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>1527249600</td>\n",
       "      <td>6.599833e+06</td>\n",
       "      <td>233.04</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>25-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527292800</td>\n",
       "      <td>5.865818e+06</td>\n",
       "      <td>206.25</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>26-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527336000</td>\n",
       "      <td>8.106604e+06</td>\n",
       "      <td>284.23</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>26-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527379200</td>\n",
       "      <td>7.887326e+06</td>\n",
       "      <td>275.22</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>27-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527422400</td>\n",
       "      <td>7.338989e+06</td>\n",
       "      <td>254.68</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>27-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527465600</td>\n",
       "      <td>1.214398e+07</td>\n",
       "      <td>409.20</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>28-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1527508800</td>\n",
       "      <td>1.149504e+07</td>\n",
       "      <td>371.72</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>28-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1527552000</td>\n",
       "      <td>1.290175e+07</td>\n",
       "      <td>417.19</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>29-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1527595200</td>\n",
       "      <td>2.408386e+07</td>\n",
       "      <td>780.40</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>29-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1527638400</td>\n",
       "      <td>1.758772e+07</td>\n",
       "      <td>569.36</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>30-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1527681600</td>\n",
       "      <td>1.364426e+07</td>\n",
       "      <td>440.13</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>30-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1527724800</td>\n",
       "      <td>8.727815e+06</td>\n",
       "      <td>283.02</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>31-05-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1527768000</td>\n",
       "      <td>1.204829e+07</td>\n",
       "      <td>391.36</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>31-05-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1527811200</td>\n",
       "      <td>1.874472e+07</td>\n",
       "      <td>631.50</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>01-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1527854400</td>\n",
       "      <td>1.015056e+07</td>\n",
       "      <td>341.29</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>01-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1527897600</td>\n",
       "      <td>1.023729e+07</td>\n",
       "      <td>347.12</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>02-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1527940800</td>\n",
       "      <td>1.078748e+07</td>\n",
       "      <td>370.90</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>02-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1527984000</td>\n",
       "      <td>1.351669e+07</td>\n",
       "      <td>473.90</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>03-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>1528027200</td>\n",
       "      <td>1.185634e+07</td>\n",
       "      <td>409.39</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>03-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1528070400</td>\n",
       "      <td>1.164797e+07</td>\n",
       "      <td>390.95</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>04-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528113600</td>\n",
       "      <td>1.104229e+07</td>\n",
       "      <td>361.70</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>04-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528156800</td>\n",
       "      <td>9.359099e+06</td>\n",
       "      <td>305.76</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>05-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>1528200000</td>\n",
       "      <td>1.021077e+07</td>\n",
       "      <td>336.85</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>05-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528243200</td>\n",
       "      <td>1.031501e+07</td>\n",
       "      <td>339.22</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>06-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528286400</td>\n",
       "      <td>1.036735e+07</td>\n",
       "      <td>339.69</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>06-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000036</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528329600</td>\n",
       "      <td>5.560827e+07</td>\n",
       "      <td>1926.10</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>07-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>1528372800</td>\n",
       "      <td>1.096346e+07</td>\n",
       "      <td>368.60</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>07-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528416000</td>\n",
       "      <td>1.009729e+07</td>\n",
       "      <td>333.47</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>08-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528459200</td>\n",
       "      <td>7.802524e+06</td>\n",
       "      <td>257.93</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>08-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528502400</td>\n",
       "      <td>1.132879e+07</td>\n",
       "      <td>380.52</td>\n",
       "      <td>0.000034</td>\n",
       "      <td>09-06-2018 02:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>0.000032</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>1528545600</td>\n",
       "      <td>1.039457e+07</td>\n",
       "      <td>340.23</td>\n",
       "      <td>0.000033</td>\n",
       "      <td>09-06-2018 14:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        close      high       low      open        time    volumefrom  \\\n",
       "0    0.000034  0.000036  0.000034  0.000034  1521417600  3.131684e+07   \n",
       "1    0.000035  0.000036  0.000031  0.000034  1521460800  7.559852e+07   \n",
       "2    0.000039  0.000041  0.000032  0.000034  1521504000  1.352212e+08   \n",
       "3    0.000034  0.000039  0.000033  0.000039  1521547200  7.237028e+07   \n",
       "4    0.000034  0.000035  0.000033  0.000034  1521590400  5.661058e+07   \n",
       "5    0.000032  0.000034  0.000032  0.000034  1521633600  3.483557e+07   \n",
       "6    0.000033  0.000034  0.000032  0.000032  1521676800  3.055480e+07   \n",
       "7    0.000034  0.000035  0.000032  0.000033  1521720000  2.033199e+07   \n",
       "8    0.000032  0.000034  0.000032  0.000034  1521763200  1.442959e+07   \n",
       "9    0.000031  0.000033  0.000031  0.000032  1521806400  1.987574e+07   \n",
       "10   0.000032  0.000033  0.000031  0.000031  1521849600  1.696110e+07   \n",
       "11   0.000032  0.000033  0.000032  0.000032  1521892800  1.424799e+07   \n",
       "12   0.000032  0.000033  0.000032  0.000032  1521936000  9.252539e+06   \n",
       "13   0.000034  0.000036  0.000032  0.000032  1521979200  3.689033e+07   \n",
       "14   0.000032  0.000034  0.000032  0.000034  1522022400  1.681919e+07   \n",
       "15   0.000032  0.000033  0.000032  0.000032  1522065600  1.485316e+07   \n",
       "16   0.000032  0.000032  0.000031  0.000032  1522108800  1.096563e+07   \n",
       "17   0.000032  0.000032  0.000031  0.000032  1522152000  1.218036e+07   \n",
       "18   0.000032  0.000032  0.000031  0.000032  1522195200  1.125811e+07   \n",
       "19   0.000032  0.000032  0.000032  0.000032  1522238400  8.000800e+06   \n",
       "20   0.000030  0.000032  0.000030  0.000032  1522281600  1.312502e+07   \n",
       "21   0.000031  0.000032  0.000030  0.000030  1522324800  1.121262e+07   \n",
       "22   0.000031  0.000032  0.000030  0.000031  1522368000  1.731958e+07   \n",
       "23   0.000032  0.000033  0.000031  0.000031  1522411200  1.353176e+07   \n",
       "24   0.000031  0.000032  0.000031  0.000032  1522454400  1.021191e+07   \n",
       "25   0.000032  0.000032  0.000031  0.000031  1522497600  6.334395e+06   \n",
       "26   0.000031  0.000032  0.000031  0.000032  1522540800  7.373795e+06   \n",
       "27   0.000030  0.000031  0.000030  0.000031  1522584000  8.494887e+06   \n",
       "28   0.000031  0.000032  0.000030  0.000030  1522627200  1.617063e+07   \n",
       "29   0.000032  0.000033  0.000031  0.000031  1522670400  1.484980e+07   \n",
       "30   0.000033  0.000035  0.000032  0.000032  1522713600  3.389253e+07   \n",
       "31   0.000035  0.000035  0.000033  0.000033  1522756800  1.259968e+07   \n",
       "32   0.000033  0.000036  0.000032  0.000035  1522800000  1.907650e+07   \n",
       "33   0.000033  0.000033  0.000033  0.000033  1522843200  7.815200e+06   \n",
       "34   0.000032  0.000035  0.000032  0.000033  1522886400  2.526723e+07   \n",
       "35   0.000033  0.000033  0.000032  0.000032  1522929600  8.349186e+06   \n",
       "36   0.000032  0.000033  0.000032  0.000033  1522972800  8.525377e+06   \n",
       "37   0.000033  0.000033  0.000032  0.000032  1523016000  6.988498e+06   \n",
       "38   0.000032  0.000033  0.000032  0.000033  1523059200  6.519682e+06   \n",
       "39   0.000032  0.000032  0.000032  0.000032  1523102400  4.737171e+06   \n",
       "40   0.000032  0.000034  0.000032  0.000032  1523145600  7.063313e+06   \n",
       "41   0.000033  0.000033  0.000032  0.000032  1523188800  6.032101e+06   \n",
       "42   0.000033  0.000034  0.000033  0.000033  1523232000  1.142017e+07   \n",
       "43   0.000034  0.000034  0.000033  0.000033  1523275200  6.343580e+06   \n",
       "44   0.000034  0.000034  0.000033  0.000034  1523318400  5.438085e+06   \n",
       "45   0.000034  0.000034  0.000033  0.000033  1523361600  8.228800e+06   \n",
       "46   0.000034  0.000035  0.000034  0.000034  1523404800  6.883246e+06   \n",
       "47   0.000035  0.000035  0.000034  0.000034  1523448000  9.360712e+06   \n",
       "48   0.000033  0.000036  0.000033  0.000035  1523491200  1.567847e+07   \n",
       "49   0.000035  0.000035  0.000033  0.000033  1523534400  1.183165e+07   \n",
       "50   0.000036  0.000036  0.000035  0.000035  1523577600  1.747709e+07   \n",
       "51   0.000036  0.000038  0.000036  0.000036  1523620800  1.839860e+07   \n",
       "52   0.000037  0.000037  0.000035  0.000036  1523664000  9.235827e+06   \n",
       "53   0.000039  0.000039  0.000036  0.000037  1523707200  8.143282e+06   \n",
       "54   0.000040  0.000041  0.000038  0.000038  1523750400  2.020262e+07   \n",
       "55   0.000043  0.000043  0.000039  0.000040  1523793600  1.525983e+07   \n",
       "56   0.000042  0.000045  0.000042  0.000043  1523836800  2.156147e+07   \n",
       "57   0.000043  0.000043  0.000040  0.000042  1523880000  1.221810e+07   \n",
       "58   0.000042  0.000043  0.000041  0.000043  1523923200  1.245237e+07   \n",
       "59   0.000043  0.000044  0.000042  0.000042  1523966400  9.216750e+06   \n",
       "60   0.000044  0.000047  0.000043  0.000043  1524009600  2.090148e+07   \n",
       "61   0.000046  0.000046  0.000044  0.000044  1524052800  9.721423e+06   \n",
       "62   0.000047  0.000047  0.000045  0.000046  1524096000  1.686594e+07   \n",
       "63   0.000046  0.000047  0.000046  0.000047  1524139200  8.562988e+06   \n",
       "64   0.000046  0.000047  0.000045  0.000047  1524182400  1.308026e+07   \n",
       "65   0.000046  0.000047  0.000045  0.000046  1524225600  9.010903e+06   \n",
       "66   0.000042  0.000047  0.000041  0.000046  1524268800  1.528547e+07   \n",
       "67   0.000043  0.000044  0.000042  0.000042  1524312000  9.107297e+06   \n",
       "68   0.000044  0.000044  0.000043  0.000043  1524355200  6.422876e+06   \n",
       "69   0.000044  0.000045  0.000044  0.000044  1524398400  8.114425e+06   \n",
       "70   0.000043  0.000044  0.000043  0.000044  1524441600  7.317398e+06   \n",
       "71   0.000044  0.000045  0.000043  0.000043  1524484800  8.264467e+06   \n",
       "72   0.000044  0.000045  0.000044  0.000044  1524528000  8.110176e+06   \n",
       "73   0.000044  0.000045  0.000044  0.000044  1524571200  1.055716e+07   \n",
       "74   0.000041  0.000048  0.000040  0.000044  1524614400  2.546189e+07   \n",
       "75   0.000042  0.000044  0.000040  0.000041  1524657600  9.356568e+06   \n",
       "76   0.000043  0.000043  0.000041  0.000042  1524700800  8.288558e+06   \n",
       "77   0.000043  0.000044  0.000043  0.000043  1524744000  8.011168e+06   \n",
       "78   0.000043  0.000045  0.000043  0.000043  1524787200  1.146119e+07   \n",
       "79   0.000043  0.000044  0.000043  0.000043  1524830400  7.948145e+06   \n",
       "80   0.000043  0.000043  0.000043  0.000043  1524873600  7.273042e+06   \n",
       "81   0.000045  0.000046  0.000043  0.000043  1524916800  1.754246e+07   \n",
       "82   0.000044  0.000046  0.000043  0.000045  1524960000  1.594219e+07   \n",
       "83   0.000045  0.000045  0.000044  0.000044  1525003200  8.053422e+06   \n",
       "84   0.000044  0.000045  0.000044  0.000045  1525046400  1.069514e+07   \n",
       "85   0.000044  0.000045  0.000044  0.000044  1525089600  6.356512e+06   \n",
       "86   0.000044  0.000044  0.000043  0.000044  1525132800  9.656039e+06   \n",
       "87   0.000045  0.000045  0.000043  0.000044  1525176000  7.843199e+06   \n",
       "88   0.000045  0.000045  0.000044  0.000045  1525219200  9.570749e+06   \n",
       "89   0.000046  0.000046  0.000044  0.000045  1525262400  1.415757e+07   \n",
       "90   0.000045  0.000046  0.000045  0.000046  1525305600  8.459946e+06   \n",
       "91   0.000045  0.000046  0.000044  0.000045  1525348800  1.574974e+07   \n",
       "92   0.000045  0.000045  0.000044  0.000045  1525392000  8.652165e+06   \n",
       "93   0.000044  0.000045  0.000044  0.000045  1525435200  7.369900e+06   \n",
       "94   0.000044  0.000045  0.000044  0.000045  1525478400  8.253814e+06   \n",
       "95   0.000043  0.000044  0.000043  0.000044  1525521600  6.371374e+06   \n",
       "96   0.000042  0.000043  0.000042  0.000043  1525564800  8.713399e+06   \n",
       "97   0.000043  0.000043  0.000042  0.000042  1525608000  5.755066e+06   \n",
       "98   0.000041  0.000043  0.000041  0.000043  1525651200  8.315108e+06   \n",
       "99   0.000042  0.000043  0.000041  0.000041  1525694400  8.440813e+06   \n",
       "100  0.000041  0.000042  0.000041  0.000042  1525737600  6.003338e+06   \n",
       "101  0.000041  0.000041  0.000040  0.000041  1525780800  7.619678e+06   \n",
       "102  0.000041  0.000041  0.000039  0.000041  1525824000  1.044966e+07   \n",
       "103  0.000041  0.000042  0.000040  0.000041  1525867200  8.589110e+06   \n",
       "104  0.000040  0.000041  0.000040  0.000041  1525910400  8.718304e+06   \n",
       "105  0.000039  0.000040  0.000039  0.000040  1525953600  1.158372e+07   \n",
       "106  0.000035  0.000039  0.000035  0.000039  1525996800  2.426385e+07   \n",
       "107  0.000038  0.000038  0.000035  0.000035  1526040000  1.345504e+07   \n",
       "108  0.000038  0.000039  0.000037  0.000038  1526083200  1.074791e+07   \n",
       "109  0.000039  0.000039  0.000038  0.000038  1526126400  1.103305e+07   \n",
       "110  0.000039  0.000039  0.000039  0.000039  1526169600  5.012946e+06   \n",
       "111  0.000041  0.000041  0.000039  0.000039  1526212800  1.366308e+07   \n",
       "112  0.000044  0.000044  0.000040  0.000041  1526256000  2.843347e+07   \n",
       "113  0.000042  0.000045  0.000042  0.000044  1526299200  4.048515e+07   \n",
       "114  0.000042  0.000042  0.000041  0.000042  1526342400  1.259440e+07   \n",
       "115  0.000039  0.000042  0.000039  0.000042  1526385600  1.722131e+07   \n",
       "116  0.000040  0.000040  0.000038  0.000039  1526428800  1.522221e+07   \n",
       "117  0.000039  0.000040  0.000038  0.000040  1526472000  8.556551e+06   \n",
       "118  0.000039  0.000039  0.000038  0.000039  1526515200  8.257754e+06   \n",
       "119  0.000037  0.000039  0.000037  0.000039  1526558400  1.171400e+07   \n",
       "120  0.000037  0.000038  0.000037  0.000037  1526601600  9.513560e+06   \n",
       "121  0.000038  0.000038  0.000037  0.000037  1526644800  9.292571e+06   \n",
       "122  0.000037  0.000038  0.000037  0.000038  1526688000  6.283266e+06   \n",
       "123  0.000037  0.000038  0.000037  0.000037  1526731200  7.177846e+06   \n",
       "124  0.000038  0.000038  0.000037  0.000037  1526774400  8.777462e+06   \n",
       "125  0.000038  0.000038  0.000037  0.000038  1526817600  8.348193e+06   \n",
       "126  0.000037  0.000038  0.000037  0.000038  1526860800  9.796113e+06   \n",
       "127  0.000037  0.000037  0.000037  0.000037  1526904000  8.500268e+06   \n",
       "128  0.000036  0.000037  0.000036  0.000037  1526947200  6.599243e+06   \n",
       "129  0.000036  0.000037  0.000036  0.000036  1526990400  1.217824e+07   \n",
       "130  0.000034  0.000036  0.000034  0.000036  1527033600  1.311950e+07   \n",
       "131  0.000035  0.000036  0.000034  0.000034  1527076800  1.786907e+07   \n",
       "132  0.000035  0.000035  0.000034  0.000035  1527120000  8.201852e+06   \n",
       "133  0.000036  0.000036  0.000034  0.000035  1527163200  1.033750e+07   \n",
       "134  0.000036  0.000036  0.000035  0.000036  1527206400  8.492334e+06   \n",
       "135  0.000035  0.000036  0.000035  0.000036  1527249600  6.599833e+06   \n",
       "136  0.000035  0.000035  0.000035  0.000035  1527292800  5.865818e+06   \n",
       "137  0.000035  0.000035  0.000035  0.000035  1527336000  8.106604e+06   \n",
       "138  0.000035  0.000035  0.000035  0.000035  1527379200  7.887326e+06   \n",
       "139  0.000035  0.000035  0.000034  0.000035  1527422400  7.338989e+06   \n",
       "140  0.000033  0.000035  0.000033  0.000035  1527465600  1.214398e+07   \n",
       "141  0.000032  0.000033  0.000032  0.000033  1527508800  1.149504e+07   \n",
       "142  0.000033  0.000033  0.000032  0.000032  1527552000  1.290175e+07   \n",
       "143  0.000032  0.000034  0.000032  0.000033  1527595200  2.408386e+07   \n",
       "144  0.000033  0.000033  0.000032  0.000032  1527638400  1.758772e+07   \n",
       "145  0.000033  0.000033  0.000032  0.000033  1527681600  1.364426e+07   \n",
       "146  0.000032  0.000033  0.000032  0.000033  1527724800  8.727815e+06   \n",
       "147  0.000033  0.000033  0.000032  0.000032  1527768000  1.204829e+07   \n",
       "148  0.000034  0.000034  0.000033  0.000033  1527811200  1.874472e+07   \n",
       "149  0.000034  0.000034  0.000033  0.000034  1527854400  1.015056e+07   \n",
       "150  0.000034  0.000034  0.000034  0.000034  1527897600  1.023729e+07   \n",
       "151  0.000035  0.000035  0.000034  0.000034  1527940800  1.078748e+07   \n",
       "152  0.000035  0.000036  0.000035  0.000035  1527984000  1.351669e+07   \n",
       "153  0.000034  0.000035  0.000034  0.000035  1528027200  1.185634e+07   \n",
       "154  0.000033  0.000035  0.000033  0.000034  1528070400  1.164797e+07   \n",
       "155  0.000033  0.000033  0.000033  0.000033  1528113600  1.104229e+07   \n",
       "156  0.000032  0.000033  0.000032  0.000033  1528156800  9.359099e+06   \n",
       "157  0.000033  0.000034  0.000032  0.000032  1528200000  1.021077e+07   \n",
       "158  0.000033  0.000033  0.000033  0.000033  1528243200  1.031501e+07   \n",
       "159  0.000033  0.000033  0.000033  0.000033  1528286400  1.036735e+07   \n",
       "160  0.000035  0.000036  0.000033  0.000033  1528329600  5.560827e+07   \n",
       "161  0.000033  0.000035  0.000033  0.000034  1528372800  1.096346e+07   \n",
       "162  0.000033  0.000033  0.000033  0.000033  1528416000  1.009729e+07   \n",
       "163  0.000033  0.000033  0.000033  0.000033  1528459200  7.802524e+06   \n",
       "164  0.000033  0.000034  0.000033  0.000033  1528502400  1.132879e+07   \n",
       "165  0.000033  0.000033  0.000032  0.000033  1528545600  1.039457e+07   \n",
       "\n",
       "     volumeto       mid            timestamp  \n",
       "0     1081.88  0.000035  19-03-2018 01:00:00  \n",
       "1     2518.36  0.000034  19-03-2018 13:00:00  \n",
       "2     4963.87  0.000036  20-03-2018 01:00:00  \n",
       "3     2554.28  0.000036  20-03-2018 13:00:00  \n",
       "4     1921.20  0.000034  21-03-2018 01:00:00  \n",
       "5     1148.52  0.000033  21-03-2018 13:00:00  \n",
       "6     1011.33  0.000033  22-03-2018 01:00:00  \n",
       "7      685.81  0.000034  22-03-2018 13:00:00  \n",
       "8      475.13  0.000033  23-03-2018 01:00:00  \n",
       "9      631.06  0.000032  23-03-2018 13:00:00  \n",
       "10     536.85  0.000032  24-03-2018 01:00:00  \n",
       "11     458.44  0.000032  24-03-2018 13:00:00  \n",
       "12     299.14  0.000032  25-03-2018 01:00:00  \n",
       "13    1279.28  0.000034  25-03-2018 14:00:00  \n",
       "14     556.72  0.000033  26-03-2018 02:00:00  \n",
       "15     483.07  0.000033  26-03-2018 14:00:00  \n",
       "16     348.12  0.000032  27-03-2018 02:00:00  \n",
       "17     387.92  0.000032  27-03-2018 14:00:00  \n",
       "18     356.81  0.000032  28-03-2018 02:00:00  \n",
       "19     254.64  0.000032  28-03-2018 14:00:00  \n",
       "20     412.37  0.000031  29-03-2018 02:00:00  \n",
       "21     348.33  0.000031  29-03-2018 14:00:00  \n",
       "22     545.15  0.000031  30-03-2018 02:00:00  \n",
       "23     434.87  0.000032  30-03-2018 14:00:00  \n",
       "24     324.53  0.000032  31-03-2018 02:00:00  \n",
       "25     198.90  0.000031  31-03-2018 14:00:00  \n",
       "26     231.89  0.000031  01-04-2018 02:00:00  \n",
       "27     262.26  0.000031  01-04-2018 14:00:00  \n",
       "28     499.10  0.000031  02-04-2018 02:00:00  \n",
       "29     472.14  0.000032  02-04-2018 14:00:00  \n",
       "30    1129.63  0.000033  03-04-2018 02:00:00  \n",
       "31     420.88  0.000034  03-04-2018 14:00:00  \n",
       "32     645.12  0.000034  04-04-2018 02:00:00  \n",
       "33     257.41  0.000033  04-04-2018 14:00:00  \n",
       "34     837.11  0.000033  05-04-2018 02:00:00  \n",
       "35     270.27  0.000032  05-04-2018 14:00:00  \n",
       "36     279.04  0.000033  06-04-2018 02:00:00  \n",
       "37     228.70  0.000033  06-04-2018 14:00:00  \n",
       "38     213.25  0.000033  07-04-2018 02:00:00  \n",
       "39     152.80  0.000032  07-04-2018 14:00:00  \n",
       "40     231.28  0.000033  08-04-2018 02:00:00  \n",
       "41     198.08  0.000033  08-04-2018 14:00:00  \n",
       "42     382.27  0.000033  09-04-2018 02:00:00  \n",
       "43     212.14  0.000033  09-04-2018 14:00:00  \n",
       "44     182.47  0.000034  10-04-2018 02:00:00  \n",
       "45     279.82  0.000034  10-04-2018 14:00:00  \n",
       "46     236.64  0.000034  11-04-2018 02:00:00  \n",
       "47     325.88  0.000035  11-04-2018 14:00:00  \n",
       "48     546.45  0.000035  12-04-2018 02:00:00  \n",
       "49     405.89  0.000034  12-04-2018 14:00:00  \n",
       "50     618.93  0.000035  13-04-2018 02:00:00  \n",
       "51     679.21  0.000037  13-04-2018 14:00:00  \n",
       "52     338.10  0.000036  14-04-2018 02:00:00  \n",
       "53     302.88  0.000037  14-04-2018 14:00:00  \n",
       "54     800.96  0.000040  15-04-2018 02:00:00  \n",
       "55     627.23  0.000041  15-04-2018 14:00:00  \n",
       "56     929.10  0.000043  16-04-2018 02:00:00  \n",
       "57     503.98  0.000041  16-04-2018 14:00:00  \n",
       "58     523.19  0.000042  17-04-2018 02:00:00  \n",
       "59     390.39  0.000043  17-04-2018 14:00:00  \n",
       "60     941.78  0.000045  18-04-2018 02:00:00  \n",
       "61     438.05  0.000045  18-04-2018 14:00:00  \n",
       "62     779.53  0.000046  19-04-2018 02:00:00  \n",
       "63     395.89  0.000046  19-04-2018 14:00:00  \n",
       "64     604.67  0.000046  20-04-2018 02:00:00  \n",
       "65     414.54  0.000046  20-04-2018 14:00:00  \n",
       "66     678.69  0.000044  21-04-2018 02:00:00  \n",
       "67     389.42  0.000043  21-04-2018 14:00:00  \n",
       "68     276.95  0.000043  22-04-2018 02:00:00  \n",
       "69     359.60  0.000044  22-04-2018 14:00:00  \n",
       "70     318.32  0.000044  23-04-2018 02:00:00  \n",
       "71     362.61  0.000044  23-04-2018 14:00:00  \n",
       "72     356.59  0.000044  24-04-2018 02:00:00  \n",
       "73     470.63  0.000045  24-04-2018 14:00:00  \n",
       "74    1106.59  0.000044  25-04-2018 02:00:00  \n",
       "75     391.11  0.000042  25-04-2018 14:00:00  \n",
       "76     350.29  0.000042  26-04-2018 02:00:00  \n",
       "77     345.03  0.000043  26-04-2018 14:00:00  \n",
       "78     499.51  0.000044  27-04-2018 02:00:00  \n",
       "79     343.72  0.000043  27-04-2018 14:00:00  \n",
       "80     312.43  0.000043  28-04-2018 02:00:00  \n",
       "81     777.05  0.000044  28-04-2018 14:00:00  \n",
       "82     717.34  0.000045  29-04-2018 02:00:00  \n",
       "83     361.59  0.000045  29-04-2018 14:00:00  \n",
       "84     475.43  0.000045  30-04-2018 02:00:00  \n",
       "85     280.63  0.000044  30-04-2018 14:00:00  \n",
       "86     421.37  0.000044  01-05-2018 02:00:00  \n",
       "87     345.78  0.000044  01-05-2018 14:00:00  \n",
       "88     426.50  0.000044  02-05-2018 02:00:00  \n",
       "89     644.06  0.000045  02-05-2018 14:00:00  \n",
       "90     383.66  0.000045  03-05-2018 02:00:00  \n",
       "91     714.75  0.000045  03-05-2018 14:00:00  \n",
       "92     384.99  0.000044  04-05-2018 02:00:00  \n",
       "93     326.63  0.000044  04-05-2018 14:00:00  \n",
       "94     365.63  0.000044  05-05-2018 02:00:00  \n",
       "95     276.74  0.000043  05-05-2018 14:00:00  \n",
       "96     371.18  0.000043  06-05-2018 02:00:00  \n",
       "97     245.84  0.000043  06-05-2018 14:00:00  \n",
       "98     346.46  0.000042  07-05-2018 02:00:00  \n",
       "99     351.34  0.000042  07-05-2018 14:00:00  \n",
       "100    250.02  0.000042  08-05-2018 02:00:00  \n",
       "101    312.09  0.000041  08-05-2018 14:00:00  \n",
       "102    419.71  0.000040  09-05-2018 02:00:00  \n",
       "103    352.24  0.000041  09-05-2018 14:00:00  \n",
       "104    354.09  0.000041  10-05-2018 02:00:00  \n",
       "105    460.91  0.000040  10-05-2018 14:00:00  \n",
       "106    899.84  0.000037  11-05-2018 02:00:00  \n",
       "107    497.84  0.000037  11-05-2018 14:00:00  \n",
       "108    404.85  0.000038  12-05-2018 02:00:00  \n",
       "109    425.41  0.000039  12-05-2018 14:00:00  \n",
       "110    194.96  0.000039  13-05-2018 02:00:00  \n",
       "111    547.04  0.000040  13-05-2018 14:00:00  \n",
       "112   1191.61  0.000042  14-05-2018 02:00:00  \n",
       "113   1762.58  0.000044  14-05-2018 14:00:00  \n",
       "114    525.94  0.000042  15-05-2018 02:00:00  \n",
       "115    694.02  0.000040  15-05-2018 14:00:00  \n",
       "116    587.99  0.000039  16-05-2018 02:00:00  \n",
       "117    331.53  0.000039  16-05-2018 14:00:00  \n",
       "118    321.27  0.000039  17-05-2018 02:00:00  \n",
       "119    441.73  0.000038  17-05-2018 14:00:00  \n",
       "120    353.02  0.000037  18-05-2018 02:00:00  \n",
       "121    347.69  0.000038  18-05-2018 14:00:00  \n",
       "122    235.45  0.000037  19-05-2018 02:00:00  \n",
       "123    268.72  0.000038  19-05-2018 14:00:00  \n",
       "124    329.85  0.000038  20-05-2018 02:00:00  \n",
       "125    315.08  0.000038  20-05-2018 14:00:00  \n",
       "126    368.53  0.000038  21-05-2018 02:00:00  \n",
       "127    313.53  0.000037  21-05-2018 14:00:00  \n",
       "128    242.16  0.000037  22-05-2018 02:00:00  \n",
       "129    438.90  0.000036  22-05-2018 14:00:00  \n",
       "130    457.14  0.000035  23-05-2018 02:00:00  \n",
       "131    625.63  0.000035  23-05-2018 14:00:00  \n",
       "132    284.74  0.000035  24-05-2018 02:00:00  \n",
       "133    362.77  0.000035  24-05-2018 14:00:00  \n",
       "134    301.28  0.000035  25-05-2018 02:00:00  \n",
       "135    233.04  0.000035  25-05-2018 14:00:00  \n",
       "136    206.25  0.000035  26-05-2018 02:00:00  \n",
       "137    284.23  0.000035  26-05-2018 14:00:00  \n",
       "138    275.22  0.000035  27-05-2018 02:00:00  \n",
       "139    254.68  0.000035  27-05-2018 14:00:00  \n",
       "140    409.20  0.000034  28-05-2018 02:00:00  \n",
       "141    371.72  0.000032  28-05-2018 14:00:00  \n",
       "142    417.19  0.000033  29-05-2018 02:00:00  \n",
       "143    780.40  0.000033  29-05-2018 14:00:00  \n",
       "144    569.36  0.000032  30-05-2018 02:00:00  \n",
       "145    440.13  0.000032  30-05-2018 14:00:00  \n",
       "146    283.02  0.000032  31-05-2018 02:00:00  \n",
       "147    391.36  0.000032  31-05-2018 14:00:00  \n",
       "148    631.50  0.000034  01-06-2018 02:00:00  \n",
       "149    341.29  0.000034  01-06-2018 14:00:00  \n",
       "150    347.12  0.000034  02-06-2018 02:00:00  \n",
       "151    370.90  0.000034  02-06-2018 14:00:00  \n",
       "152    473.90  0.000035  03-06-2018 02:00:00  \n",
       "153    409.39  0.000035  03-06-2018 14:00:00  \n",
       "154    390.95  0.000034  04-06-2018 02:00:00  \n",
       "155    361.70  0.000033  04-06-2018 14:00:00  \n",
       "156    305.76  0.000033  05-06-2018 02:00:00  \n",
       "157    336.85  0.000033  05-06-2018 14:00:00  \n",
       "158    339.22  0.000033  06-06-2018 02:00:00  \n",
       "159    339.69  0.000033  06-06-2018 14:00:00  \n",
       "160   1926.10  0.000034  07-06-2018 02:00:00  \n",
       "161    368.60  0.000034  07-06-2018 14:00:00  \n",
       "162    333.47  0.000033  08-06-2018 02:00:00  \n",
       "163    257.93  0.000033  08-06-2018 14:00:00  \n",
       "164    380.52  0.000034  09-06-2018 02:00:00  \n",
       "165    340.23  0.000033  09-06-2018 14:00:00  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "market_data"
   ]
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}