XGB_TUNER_TRAINER.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "10cff7fc",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T02:59:55.789850Z",
     "start_time": "2021-04-14T02:59:53.293875Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "    <div class=\"bk-root\">\n",
       "        <a href=\"https://bokeh.org\" target=\"_blank\" class=\"bk-logo bk-logo-small bk-logo-notebook\"></a>\n",
       "        <span id=\"1002\">Loading BokehJS ...</span>\n",
       "    </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "\n",
       "(function(root) {\n",
       "  function now() {\n",
       "    return new Date();\n",
       "  }\n",
       "\n",
       "  var force = true;\n",
       "\n",
       "  if (typeof root._bokeh_onload_callbacks === \"undefined\" || force === true) {\n",
       "    root._bokeh_onload_callbacks = [];\n",
       "    root._bokeh_is_loading = undefined;\n",
       "  }\n",
       "\n",
       "  var JS_MIME_TYPE = 'application/javascript';\n",
       "  var HTML_MIME_TYPE = 'text/html';\n",
       "  var EXEC_MIME_TYPE = 'application/vnd.bokehjs_exec.v0+json';\n",
       "  var CLASS_NAME = 'output_bokeh rendered_html';\n",
       "\n",
       "  /**\n",
       "   * Render data to the DOM node\n",
       "   */\n",
       "  function render(props, node) {\n",
       "    var script = document.createElement(\"script\");\n",
       "    node.appendChild(script);\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when an output is cleared or removed\n",
       "   */\n",
       "  function handleClearOutput(event, handle) {\n",
       "    var cell = handle.cell;\n",
       "\n",
       "    var id = cell.output_area._bokeh_element_id;\n",
       "    var server_id = cell.output_area._bokeh_server_id;\n",
       "    // Clean up Bokeh references\n",
       "    if (id != null && id in Bokeh.index) {\n",
       "      Bokeh.index[id].model.document.clear();\n",
       "      delete Bokeh.index[id];\n",
       "    }\n",
       "\n",
       "    if (server_id !== undefined) {\n",
       "      // Clean up Bokeh references\n",
       "      var cmd = \"from bokeh.io.state import curstate; print(curstate().uuid_to_server['\" + server_id + \"'].get_sessions()[0].document.roots[0]._id)\";\n",
       "      cell.notebook.kernel.execute(cmd, {\n",
       "        iopub: {\n",
       "          output: function(msg) {\n",
       "            var id = msg.content.text.trim();\n",
       "            if (id in Bokeh.index) {\n",
       "              Bokeh.index[id].model.document.clear();\n",
       "              delete Bokeh.index[id];\n",
       "            }\n",
       "          }\n",
       "        }\n",
       "      });\n",
       "      // Destroy server and session\n",
       "      var cmd = \"import bokeh.io.notebook as ion; ion.destroy_server('\" + server_id + \"')\";\n",
       "      cell.notebook.kernel.execute(cmd);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  /**\n",
       "   * Handle when a new output is added\n",
       "   */\n",
       "  function handleAddOutput(event, handle) {\n",
       "    var output_area = handle.output_area;\n",
       "    var output = handle.output;\n",
       "\n",
       "    // limit handleAddOutput to display_data with EXEC_MIME_TYPE content only\n",
       "    if ((output.output_type != \"display_data\") || (!Object.prototype.hasOwnProperty.call(output.data, EXEC_MIME_TYPE))) {\n",
       "      return\n",
       "    }\n",
       "\n",
       "    var toinsert = output_area.element.find(\".\" + CLASS_NAME.split(' ')[0]);\n",
       "\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"id\"] !== undefined) {\n",
       "      toinsert[toinsert.length - 1].firstChild.textContent = output.data[JS_MIME_TYPE];\n",
       "      // store reference to embed id on output_area\n",
       "      output_area._bokeh_element_id = output.metadata[EXEC_MIME_TYPE][\"id\"];\n",
       "    }\n",
       "    if (output.metadata[EXEC_MIME_TYPE][\"server_id\"] !== undefined) {\n",
       "      var bk_div = document.createElement(\"div\");\n",
       "      bk_div.innerHTML = output.data[HTML_MIME_TYPE];\n",
       "      var script_attrs = bk_div.children[0].attributes;\n",
       "      for (var i = 0; i < script_attrs.length; i++) {\n",
       "        toinsert[toinsert.length - 1].firstChild.setAttribute(script_attrs[i].name, script_attrs[i].value);\n",
       "        toinsert[toinsert.length - 1].firstChild.textContent = bk_div.children[0].textContent\n",
       "      }\n",
       "      // store reference to server id on output_area\n",
       "      output_area._bokeh_server_id = output.metadata[EXEC_MIME_TYPE][\"server_id\"];\n",
       "    }\n",
       "  }\n",
       "\n",
       "  function register_renderer(events, OutputArea) {\n",
       "\n",
       "    function append_mime(data, metadata, element) {\n",
       "      // create a DOM node to render to\n",
       "      var toinsert = this.create_output_subarea(\n",
       "        metadata,\n",
       "        CLASS_NAME,\n",
       "        EXEC_MIME_TYPE\n",
       "      );\n",
       "      this.keyboard_manager.register_events(toinsert);\n",
       "      // Render to node\n",
       "      var props = {data: data, metadata: metadata[EXEC_MIME_TYPE]};\n",
       "      render(props, toinsert[toinsert.length - 1]);\n",
       "      element.append(toinsert);\n",
       "      return toinsert\n",
       "    }\n",
       "\n",
       "    /* Handle when an output is cleared or removed */\n",
       "    events.on('clear_output.CodeCell', handleClearOutput);\n",
       "    events.on('delete.Cell', handleClearOutput);\n",
       "\n",
       "    /* Handle when a new output is added */\n",
       "    events.on('output_added.OutputArea', handleAddOutput);\n",
       "\n",
       "    /**\n",
       "     * Register the mime type and append_mime function with output_area\n",
       "     */\n",
       "    OutputArea.prototype.register_mime_type(EXEC_MIME_TYPE, append_mime, {\n",
       "      /* Is output safe? */\n",
       "      safe: true,\n",
       "      /* Index of renderer in `output_area.display_order` */\n",
       "      index: 0\n",
       "    });\n",
       "  }\n",
       "\n",
       "  // register the mime type if in Jupyter Notebook environment and previously unregistered\n",
       "  if (root.Jupyter !== undefined) {\n",
       "    var events = require('base/js/events');\n",
       "    var OutputArea = require('notebook/js/outputarea').OutputArea;\n",
       "\n",
       "    if (OutputArea.prototype.mime_types().indexOf(EXEC_MIME_TYPE) == -1) {\n",
       "      register_renderer(events, OutputArea);\n",
       "    }\n",
       "  }\n",
       "\n",
       "  \n",
       "  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n",
       "    root._bokeh_timeout = Date.now() + 5000;\n",
       "    root._bokeh_failed_load = false;\n",
       "  }\n",
       "\n",
       "  var NB_LOAD_WARNING = {'data': {'text/html':\n",
       "     \"<div style='background-color: #fdd'>\\n\"+\n",
       "     \"<p>\\n\"+\n",
       "     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n",
       "     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n",
       "     \"</p>\\n\"+\n",
       "     \"<ul>\\n\"+\n",
       "     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n",
       "     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n",
       "     \"</ul>\\n\"+\n",
       "     \"<code>\\n\"+\n",
       "     \"from bokeh.resources import INLINE\\n\"+\n",
       "     \"output_notebook(resources=INLINE)\\n\"+\n",
       "     \"</code>\\n\"+\n",
       "     \"</div>\"}};\n",
       "\n",
       "  function display_loaded() {\n",
       "    var el = document.getElementById(\"1002\");\n",
       "    if (el != null) {\n",
       "      el.textContent = \"BokehJS is loading...\";\n",
       "    }\n",
       "    if (root.Bokeh !== undefined) {\n",
       "      if (el != null) {\n",
       "        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n",
       "      }\n",
       "    } else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(display_loaded, 100)\n",
       "    }\n",
       "  }\n",
       "\n",
       "\n",
       "  function run_callbacks() {\n",
       "    try {\n",
       "      root._bokeh_onload_callbacks.forEach(function(callback) {\n",
       "        if (callback != null)\n",
       "          callback();\n",
       "      });\n",
       "    } finally {\n",
       "      delete root._bokeh_onload_callbacks\n",
       "    }\n",
       "    console.debug(\"Bokeh: all callbacks have finished\");\n",
       "  }\n",
       "\n",
       "  function load_libs(css_urls, js_urls, callback) {\n",
       "    if (css_urls == null) css_urls = [];\n",
       "    if (js_urls == null) js_urls = [];\n",
       "\n",
       "    root._bokeh_onload_callbacks.push(callback);\n",
       "    if (root._bokeh_is_loading > 0) {\n",
       "      console.debug(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n",
       "      return null;\n",
       "    }\n",
       "    if (js_urls == null || js_urls.length === 0) {\n",
       "      run_callbacks();\n",
       "      return null;\n",
       "    }\n",
       "    console.debug(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n",
       "    root._bokeh_is_loading = css_urls.length + js_urls.length;\n",
       "\n",
       "    function on_load() {\n",
       "      root._bokeh_is_loading--;\n",
       "      if (root._bokeh_is_loading === 0) {\n",
       "        console.debug(\"Bokeh: all BokehJS libraries/stylesheets loaded\");\n",
       "        run_callbacks()\n",
       "      }\n",
       "    }\n",
       "\n",
       "    function on_error(url) {\n",
       "      console.error(\"failed to load \" + url);\n",
       "    }\n",
       "\n",
       "    for (let i = 0; i < css_urls.length; i++) {\n",
       "      const url = css_urls[i];\n",
       "      const element = document.createElement(\"link\");\n",
       "      element.onload = on_load;\n",
       "      element.onerror = on_error.bind(null, url);\n",
       "      element.rel = \"stylesheet\";\n",
       "      element.type = \"text/css\";\n",
       "      element.href = url;\n",
       "      console.debug(\"Bokeh: injecting link tag for BokehJS stylesheet: \", url);\n",
       "      document.body.appendChild(element);\n",
       "    }\n",
       "\n",
       "    const hashes = {\"https://cdn.bokeh.org/bokeh/release/bokeh-2.3.1.min.js\": \"YF85VygJKMVnHE+lLv2AM93Vbstr0yo2TbIu5v8se5Rq3UQAUmcuh4aaJwNlpKwa\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.3.1.min.js\": \"KKuas3gevv3PvrlkyCMzffFeaMq5we/a2QsP5AUoS3mJ0jmaCL7jirFJN3GoE/lM\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.3.1.min.js\": \"MK/uFc3YT18pkvvXRl66tTHjP0/dxoSH2e/eiNMFIguKlun2+WVqaPTWmUy/zvh4\"};\n",
       "\n",
       "    for (let i = 0; i < js_urls.length; i++) {\n",
       "      const url = js_urls[i];\n",
       "      const element = document.createElement('script');\n",
       "      element.onload = on_load;\n",
       "      element.onerror = on_error.bind(null, url);\n",
       "      element.async = false;\n",
       "      element.src = url;\n",
       "      if (url in hashes) {\n",
       "        element.crossOrigin = \"anonymous\";\n",
       "        element.integrity = \"sha384-\" + hashes[url];\n",
       "      }\n",
       "      console.debug(\"Bokeh: injecting script tag for BokehJS library: \", url);\n",
       "      document.head.appendChild(element);\n",
       "    }\n",
       "  };\n",
       "\n",
       "  function inject_raw_css(css) {\n",
       "    const element = document.createElement(\"style\");\n",
       "    element.appendChild(document.createTextNode(css));\n",
       "    document.body.appendChild(element);\n",
       "  }\n",
       "\n",
       "  \n",
       "  var js_urls = [\"https://cdn.bokeh.org/bokeh/release/bokeh-2.3.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.3.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.3.1.min.js\"];\n",
       "  var css_urls = [];\n",
       "  \n",
       "\n",
       "  var inline_js = [\n",
       "    function(Bokeh) {\n",
       "      Bokeh.set_log_level(\"info\");\n",
       "    },\n",
       "    function(Bokeh) {\n",
       "    \n",
       "    \n",
       "    }\n",
       "  ];\n",
       "\n",
       "  function run_inline_js() {\n",
       "    \n",
       "    if (root.Bokeh !== undefined || force === true) {\n",
       "      \n",
       "    for (var i = 0; i < inline_js.length; i++) {\n",
       "      inline_js[i].call(root, root.Bokeh);\n",
       "    }\n",
       "    if (force === true) {\n",
       "        display_loaded();\n",
       "      }} else if (Date.now() < root._bokeh_timeout) {\n",
       "      setTimeout(run_inline_js, 100);\n",
       "    } else if (!root._bokeh_failed_load) {\n",
       "      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n",
       "      root._bokeh_failed_load = true;\n",
       "    } else if (force !== true) {\n",
       "      var cell = $(document.getElementById(\"1002\")).parents('.cell').data().cell;\n",
       "      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n",
       "    }\n",
       "\n",
       "  }\n",
       "\n",
       "  if (root._bokeh_is_loading === 0) {\n",
       "    console.debug(\"Bokeh: BokehJS loaded, going straight to plotting\");\n",
       "    run_inline_js();\n",
       "  } else {\n",
       "    load_libs(css_urls, js_urls, function() {\n",
       "      console.debug(\"Bokeh: BokehJS plotting callback run at\", now());\n",
       "      run_inline_js();\n",
       "    });\n",
       "  }\n",
       "}(window));"
      ],
      "application/vnd.bokehjs_load.v0+json": "\n(function(root) {\n  function now() {\n    return new Date();\n  }\n\n  var force = true;\n\n  if (typeof root._bokeh_onload_callbacks === \"undefined\" || force === true) {\n    root._bokeh_onload_callbacks = [];\n    root._bokeh_is_loading = undefined;\n  }\n\n  \n\n  \n  if (typeof (root._bokeh_timeout) === \"undefined\" || force === true) {\n    root._bokeh_timeout = Date.now() + 5000;\n    root._bokeh_failed_load = false;\n  }\n\n  var NB_LOAD_WARNING = {'data': {'text/html':\n     \"<div style='background-color: #fdd'>\\n\"+\n     \"<p>\\n\"+\n     \"BokehJS does not appear to have successfully loaded. If loading BokehJS from CDN, this \\n\"+\n     \"may be due to a slow or bad network connection. Possible fixes:\\n\"+\n     \"</p>\\n\"+\n     \"<ul>\\n\"+\n     \"<li>re-rerun `output_notebook()` to attempt to load from CDN again, or</li>\\n\"+\n     \"<li>use INLINE resources instead, as so:</li>\\n\"+\n     \"</ul>\\n\"+\n     \"<code>\\n\"+\n     \"from bokeh.resources import INLINE\\n\"+\n     \"output_notebook(resources=INLINE)\\n\"+\n     \"</code>\\n\"+\n     \"</div>\"}};\n\n  function display_loaded() {\n    var el = document.getElementById(\"1002\");\n    if (el != null) {\n      el.textContent = \"BokehJS is loading...\";\n    }\n    if (root.Bokeh !== undefined) {\n      if (el != null) {\n        el.textContent = \"BokehJS \" + root.Bokeh.version + \" successfully loaded.\";\n      }\n    } else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(display_loaded, 100)\n    }\n  }\n\n\n  function run_callbacks() {\n    try {\n      root._bokeh_onload_callbacks.forEach(function(callback) {\n        if (callback != null)\n          callback();\n      });\n    } finally {\n      delete root._bokeh_onload_callbacks\n    }\n    console.debug(\"Bokeh: all callbacks have finished\");\n  }\n\n  function load_libs(css_urls, js_urls, callback) {\n    if (css_urls == null) css_urls = [];\n    if (js_urls == null) js_urls = [];\n\n    root._bokeh_onload_callbacks.push(callback);\n    if (root._bokeh_is_loading > 0) {\n      console.debug(\"Bokeh: BokehJS is being loaded, scheduling callback at\", now());\n      return null;\n    }\n    if (js_urls == null || js_urls.length === 0) {\n      run_callbacks();\n      return null;\n    }\n    console.debug(\"Bokeh: BokehJS not loaded, scheduling load and callback at\", now());\n    root._bokeh_is_loading = css_urls.length + js_urls.length;\n\n    function on_load() {\n      root._bokeh_is_loading--;\n      if (root._bokeh_is_loading === 0) {\n        console.debug(\"Bokeh: all BokehJS libraries/stylesheets loaded\");\n        run_callbacks()\n      }\n    }\n\n    function on_error(url) {\n      console.error(\"failed to load \" + url);\n    }\n\n    for (let i = 0; i < css_urls.length; i++) {\n      const url = css_urls[i];\n      const element = document.createElement(\"link\");\n      element.onload = on_load;\n      element.onerror = on_error.bind(null, url);\n      element.rel = \"stylesheet\";\n      element.type = \"text/css\";\n      element.href = url;\n      console.debug(\"Bokeh: injecting link tag for BokehJS stylesheet: \", url);\n      document.body.appendChild(element);\n    }\n\n    const hashes = {\"https://cdn.bokeh.org/bokeh/release/bokeh-2.3.1.min.js\": \"YF85VygJKMVnHE+lLv2AM93Vbstr0yo2TbIu5v8se5Rq3UQAUmcuh4aaJwNlpKwa\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.3.1.min.js\": \"KKuas3gevv3PvrlkyCMzffFeaMq5we/a2QsP5AUoS3mJ0jmaCL7jirFJN3GoE/lM\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.3.1.min.js\": \"MK/uFc3YT18pkvvXRl66tTHjP0/dxoSH2e/eiNMFIguKlun2+WVqaPTWmUy/zvh4\"};\n\n    for (let i = 0; i < js_urls.length; i++) {\n      const url = js_urls[i];\n      const element = document.createElement('script');\n      element.onload = on_load;\n      element.onerror = on_error.bind(null, url);\n      element.async = false;\n      element.src = url;\n      if (url in hashes) {\n        element.crossOrigin = \"anonymous\";\n        element.integrity = \"sha384-\" + hashes[url];\n      }\n      console.debug(\"Bokeh: injecting script tag for BokehJS library: \", url);\n      document.head.appendChild(element);\n    }\n  };\n\n  function inject_raw_css(css) {\n    const element = document.createElement(\"style\");\n    element.appendChild(document.createTextNode(css));\n    document.body.appendChild(element);\n  }\n\n  \n  var js_urls = [\"https://cdn.bokeh.org/bokeh/release/bokeh-2.3.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-widgets-2.3.1.min.js\", \"https://cdn.bokeh.org/bokeh/release/bokeh-tables-2.3.1.min.js\"];\n  var css_urls = [];\n  \n\n  var inline_js = [\n    function(Bokeh) {\n      Bokeh.set_log_level(\"info\");\n    },\n    function(Bokeh) {\n    \n    \n    }\n  ];\n\n  function run_inline_js() {\n    \n    if (root.Bokeh !== undefined || force === true) {\n      \n    for (var i = 0; i < inline_js.length; i++) {\n      inline_js[i].call(root, root.Bokeh);\n    }\n    if (force === true) {\n        display_loaded();\n      }} else if (Date.now() < root._bokeh_timeout) {\n      setTimeout(run_inline_js, 100);\n    } else if (!root._bokeh_failed_load) {\n      console.log(\"Bokeh: BokehJS failed to load within specified timeout.\");\n      root._bokeh_failed_load = true;\n    } else if (force !== true) {\n      var cell = $(document.getElementById(\"1002\")).parents('.cell').data().cell;\n      cell.output_area.append_execute_result(NB_LOAD_WARNING)\n    }\n\n  }\n\n  if (root._bokeh_is_loading === 0) {\n    console.debug(\"Bokeh: BokehJS loaded, going straight to plotting\");\n    run_inline_js();\n  } else {\n    load_libs(css_urls, js_urls, function() {\n      console.debug(\"Bokeh: BokehJS plotting callback run at\", now());\n      run_inline_js();\n    });\n  }\n}(window));"
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import xgboost\n",
    "import tqdm\n",
    "import pandas as pd\n",
    "import ast \n",
    "import os.path\n",
    "import os\n",
    "pd.set_option('plotting.backend', 'pandas_bokeh')\n",
    "import pandas_bokeh\n",
    "pandas_bokeh.output_notebook()\n",
    "import joblib\n",
    "import sklearn\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "import optuna \n",
    "from optuna import Trial, visualization\n",
    "from optuna.samplers import TPESampler\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c3544053",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T02:59:56.265516Z",
     "start_time": "2021-04-14T02:59:56.247134Z"
    }
   },
   "outputs": [],
   "source": [
    "tokens_list_df = pd.read_csv('./data_records/tokens_list_df.csv')\n",
    "tokens_list = tokens_list_df['0'].tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "cd647bab",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T02:59:56.815047Z",
     "start_time": "2021-04-14T02:59:56.804726Z"
    }
   },
   "outputs": [],
   "source": [
    "def objective(trial: Trial,X,Y) -> float:\n",
    "    \n",
    "    joblib.dump(study, 'study.pkl')\n",
    "    \n",
    "    train_X,test_X,train_y,test_y = sklearn.model_selection.train_test_split(X, Y, test_size = 0.30,random_state = 101)\n",
    "\n",
    "    param = {\"n_estimators\" : trial.suggest_int('n_estimators', 0, 1000),\n",
    "            'max_depth':trial.suggest_int('max_depth', 2, 25),\n",
    "            'reg_alpha':trial.suggest_int('reg_alpha', 0, 5),\n",
    "            'reg_lambda':trial.suggest_int('reg_lambda', 0, 5),\n",
    "            'min_child_weight':trial.suggest_int('min_child_weight', 0, 5),\n",
    "            'gamma':trial.suggest_int('gamma', 0, 5),\n",
    "            'learning_rate':trial.suggest_loguniform('learning_rate',0.005,0.5),\n",
    "            'colsample_bytree':trial.suggest_discrete_uniform('colsample_bytree',0.1,1,0.01),\n",
    "            'nthread' : -1,\n",
    "            'tree_method':'hist'}\n",
    "    model = xgboost.XGBRegressor(**param)\n",
    "\n",
    "    model.fit(train_X,train_y)\n",
    "\n",
    "    return sklearn.model_selection.cross_val_score(model,test_X,test_y).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "503f8e4d",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T03:00:11.764721Z",
     "start_time": "2021-04-14T03:00:02.694039Z"
    }
   },
   "outputs": [],
   "source": [
    "globals()[f'pnls_df_{1346049}'] = pd.read_excel(f'./data_records_13_4_2021/instwise/1346049.xlsx',parse_dates=['last_trade_time'])\n",
    "del globals()[f'pnls_df_{1346049}']['Unnamed: 0']\n",
    "del globals()[f'pnls_df_{1346049}']['Unnamed: 0.1']\n",
    "\n",
    "globals()[f'pnls_df_{1346049}'] = globals()[f'pnls_df_{1346049}'].replace({'\\'': '\"'}, regex=True)\n",
    "ohlc_df = pd.io.json.json_normalize(globals()[f'pnls_df_{1346049}'].ohlc.apply(json.loads))\n",
    "\n",
    "globals()[f'pnls_df_OHLC{1346049}'] = pd.concat([globals()[f'pnls_df_{1346049}'],ohlc_df],axis=1)\n",
    "del_column_list = ['tradable', 'mode', 'instrument_token', 'ohlc','timestamp', 'depth','last_trade_time']\n",
    "globals()[f'pnls_df_OHLC{1346049}'].drop(del_column_list, axis = 1, inplace = True)\n",
    "\n",
    "x=globals()[f'pnls_df_OHLC{1346049}'].drop([len(globals()[f'pnls_df_OHLC{1346049}'].index)-1]) \n",
    "\n",
    "y = globals()[f'pnls_df_OHLC{1346049}']['last_price'][1:].to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "20c15421",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-13T22:19:45.770197Z",
     "start_time": "2021-04-13T22:19:45.766744Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# for one_key in x.keys():\n",
    "#     print('-'*55)\n",
    "#     print(f'Training for {one_key}')\n",
    "    \n",
    "#     locals()[f'y_{one_key}'] = locals()[f'pnls_df_OHLC{1346049}'][one_key][1:].to_numpy()\n",
    "    \n",
    "#     file_name = f'./xgb_models_tick_data/xgbmodel_{one_key}'\n",
    "#     if(os.path.isfile(file_name)):\n",
    "#         continue\n",
    "    \n",
    "#     study = optuna.create_study(direction='maximize',sampler=TPESampler())\n",
    "#     study.optimize(lambda trial : objective(trial,x,globals()[f'y_{one_key}']),n_trials= 100)\n",
    "#     print('Best trial: score {},\\nparams {}'.format(study.best_trial.value,study.best_trial.params))\n",
    "\n",
    "#     locals()[f'train_params_{one_key}'] = study.best_trial.params\n",
    "#     locals()[f'train_params_{one_key}']['nthread'] = -1\n",
    "#     locals()[f'train_params_{one_key}']['tree_method'] = 'hist'\n",
    "    \n",
    "#     this_best_params_df = pd.DataFrame(locals()[f'train_params_{one_key}'],index=[0])\n",
    "#     this_best_params_df.to_excel(f'./xgb_models_tick_data/this_best_params_df_{one_key}.xlsx')\n",
    "    \n",
    "#     locals()[f'xgbmodel_{one_key}']  = xgboost.XGBRegressor(**locals()[f'train_params_{one_key}'])\n",
    "#     locals()[f'xgbmodel_{one_key}'].fit(x,locals()[f'y_{one_key}'])\n",
    "#     locals()[f'xgbmodel_{one_key}'].save_model(f'./xgb_models_tick_data/xgbmodel_{one_key}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "55a846c2",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2a506a14",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "18f9fea2",
   "metadata": {
    "ExecuteTime": {
     "start_time": "2021-04-13T22:19:33.340Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "tkn_counter = 1\n",
    "for one_tkn in tqdm.tqdm(tokens_list):\n",
    "    print('*'*55)\n",
    "    print(f'Training for TKN : {one_tkn} : {tkn_counter}')\n",
    "    tkn_counter = tkn_counter+1\n",
    "    file_read_name = f'./data_records/instwise/{one_tkn}.xlsx'\n",
    "    \n",
    "    if(not os.path.isfile(file_read_name)):\n",
    "        continue\n",
    "    \n",
    "    locals()[f'pnls_df_{one_tkn}'] = pd.read_excel(file_read_name)\n",
    "    \n",
    "#     del locals()[f'pnls_df_{one_tkn}']['Unnamed: 0']\n",
    "#     del locals()[f'pnls_df_{one_tkn}']['Unnamed: 0.1']\n",
    "\n",
    "    locals()[f'pnls_df_{one_tkn}'] = locals()[f'pnls_df_{one_tkn}'].replace({'\\'': '\"'}, regex=True)\n",
    "    ohlc_df = pd.io.json.json_normalize(locals()[f'pnls_df_{one_tkn}'].ohlc.apply(json.loads))\n",
    "\n",
    "    locals()[f'pnls_df_OHLC{one_tkn}'] = pd.concat([locals()[f'pnls_df_{one_tkn}'],ohlc_df],axis=1)\n",
    "    del_column_list = ['tradable', 'mode', 'instrument_token', 'ohlc','timestamp', 'depth','last_trade_time']\n",
    "    locals()[f'pnls_df_OHLC{one_tkn}'].drop(del_column_list, axis = 1, inplace = True)\n",
    "\n",
    "    x=locals()[f'pnls_df_OHLC{one_tkn}'].drop([len(locals()[f'pnls_df_OHLC{one_tkn}'].index)-1]) \n",
    "    \n",
    "    for one_key in x.keys():\n",
    "        locals()[f'xgb_model_{one_key}'] = xgboost.Booster({'nthread':4})\n",
    "        locals()[f'xgb_model_{one_key}'].load_model(f\"./xgb_models_tick_data/xgbmodel_{one_key}\")\n",
    "        print(f'   for key : {one_key}')\n",
    "        one_para = pd.read_excel(f'./xgb_models_tick_data/this_best_params_df_{one_key}.xlsx')\n",
    "        del one_para['Unnamed: 0']\n",
    "        one_para_dict = one_para.to_dict('index')[0]\n",
    "        update_para = {'process_type': 'default','refresh_leaf': True}\n",
    "        one_para = {**one_para_dict, **update_para}\n",
    "        \n",
    "        del one_para['n_estimators']\n",
    "        locals()[f'y_{one_key}'] = globals()[f'pnls_df_OHLC{one_tkn}'][one_key][1:].to_numpy()\n",
    "        locals()[f'xgb_model_{one_key}'] = xgboost.train(one_para, \n",
    "                          dtrain=xgboost.DMatrix(x, locals()[f'y_{one_key}']), \n",
    "                          xgb_model=globals()[f'xgb_model_{one_key}'])\n",
    "        \n",
    "        locals()[f'xgb_model_{one_key}'].save_model(f'./xgb_models_tick_data/xgbmodel_{one_key}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cd49d687",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1c340fc3",
   "metadata": {
    "ExecuteTime": {
     "start_time": "2021-04-13T22:19:33.357Z"
    }
   },
   "outputs": [],
   "source": [
    "for i in rangeege(4):\n",
    "    \n",
    "    tkn_counter = 1\n",
    "    for one_tkn in tqdm.tqdm(tokens_list):\n",
    "        print('*'*55)\n",
    "        print(f'Training for TKN : {one_tkn} : {tkn_counter}')\n",
    "        tkn_counter = tkn_counter+1\n",
    "        file_read_name = f'./data_records/instwise/{one_tkn}.xlsx'\n",
    "\n",
    "        if(not os.path.isfile(file_read_name)):\n",
    "            continue\n",
    "\n",
    "        locals()[f'pnls_df_{one_tkn}'] = pd.read_excel(file_read_name)\n",
    "\n",
    "    #     del locals()[f'pnls_df_{one_tkn}']['Unnamed: 0']\n",
    "    #     del locals()[f'pnls_df_{one_tkn}']['Unnamed: 0.1']\n",
    "\n",
    "        locals()[f'pnls_df_{one_tkn}'] = locals()[f'pnls_df_{one_tkn}'].replace({'\\'': '\"'}, regex=True)\n",
    "        ohlc_df = pd.io.json.json_normalize(locals()[f'pnls_df_{one_tkn}'].ohlc.apply(json.loads))\n",
    "\n",
    "        locals()[f'pnls_df_OHLC{one_tkn}'] = pd.concat([locals()[f'pnls_df_{one_tkn}'],ohlc_df],axis=1)\n",
    "        del_column_list = ['tradable', 'mode', 'instrument_token', 'ohlc','timestamp', 'depth','last_trade_time']\n",
    "        locals()[f'pnls_df_OHLC{one_tkn}'].drop(del_column_list, axis = 1, inplace = True)\n",
    "\n",
    "        x=locals()[f'pnls_df_OHLC{one_tkn}'].drop([len(locals()[f'pnls_df_OHLC{one_tkn}'].index)-1]) \n",
    "\n",
    "        for one_key in x.keys():\n",
    "            locals()[f'xgb_model_{one_key}'] = xgboost.Booster({'nthread':4})\n",
    "            locals()[f'xgb_model_{one_key}'].load_model(f\"./xgb_models_tick_data/xgbmodel_{one_key}\")\n",
    "            print(f'   for key : {one_key}')\n",
    "            one_para = pd.read_excel(f'./xgb_models_tick_data/this_best_params_df_{one_key}.xlsx')\n",
    "            del one_para['Unnamed: 0']\n",
    "            one_para_dict = one_para.to_dict('index')[0]\n",
    "            update_para = {'process_type': 'default','refresh_leaf': True}\n",
    "            one_para = {**one_para_dict, **update_para}\n",
    "\n",
    "            del one_para['n_estimators']\n",
    "            locals()[f'y_{one_key}'] = globals()[f'pnls_df_OHLC{one_tkn}'][one_key][1:].to_numpy()\n",
    "            locals()[f'xgb_model_{one_key}'] = xgboost.train(one_para, \n",
    "                              dtrain=xgboost.DMatrix(x, locals()[f'y_{one_key}']), \n",
    "                              xgb_model=globals()[f'xgb_model_{one_key}'])\n",
    "\n",
    "            locals()[f'xgb_model_{one_key}'].save_model(f'./xgb_models_tick_data/xgbmodel_{one_key}') \n",
    "    \n",
    "    \n",
    "    \n",
    "    tkn_counter = 1\n",
    "    for one_tkn in tqdm.tqdm(tokens_list):\n",
    "        print('*'*55)\n",
    "        print(f'Training for TKN : {one_tkn} : {tkn_counter}')\n",
    "        tkn_counter = tkn_counter+1\n",
    "        file_read_name =./data_records_13_4_2021/13_4_2021/ds_13_4_2021/instwise/{one_tkn}.xlsx'\n",
    "\n",
    "        if(not os.path.isfile(file_read_name)):\n",
    "            continue\n",
    "\n",
    "        locals()[f'pnls_df_{one_tkn}'] = pd.read_excel(file_read_name)\n",
    "\n",
    "        del locals()[f'pnls_df_{one_tkn}']['Unnamed: 0']\n",
    "        del locals()[f'pnls_df_{one_tkn}']['Unnamed: 0.1']\n",
    "\n",
    "        locals()[f'pnls_df_{one_tkn}'] = locals()[f'pnls_df_{one_tkn}'].replace({'\\'': '\"'}, regex=True)\n",
    "        ohlc_df = pd.io.json.json_normalize(locals()[f'pnls_df_{one_tkn}'].ohlc.apply(json.loads))\n",
    "\n",
    "        locals()[f'pnls_df_OHLC{one_tkn}'] = pd.concat([locals()[f'pnls_df_{one_tkn}'],ohlc_df],axis=1)\n",
    "        del_column_list = ['tradable', 'mode', 'instrument_token', 'ohlc','timestamp', 'depth','last_trade_time']\n",
    "        locals()[f'pnls_df_OHLC{one_tkn}'].drop(del_column_list, axis = 1, inplace = True)\n",
    "\n",
    "        x=locals()[f'pnls_df_OHLC{one_tkn}'].drop([len(locals()[f'pnls_df_OHLC{one_tkn}'].index)-1]) \n",
    "\n",
    "        for one_key in x.keys():\n",
    "            locals()[f'xgb_model_{one_key}'] = xgboost.Booster({'nthread':4})\n",
    "            locals()[f'xgb_model_{one_key}'].load_model(f\"./xgb_models_tick_data/xgbmodel_{one_key}\")\n",
    "            print(f'   for key : {one_key}')\n",
    "            one_para = pd.read_excel(f'./xgb_models_tick_data/this_best_params_df_{one_key}.xlsx')\n",
    "            del one_para['Unnamed: 0']\n",
    "            one_para_dict = one_para.to_dict('index')[0]\n",
    "            update_para = {'process_type': 'default','refresh_leaf': True}\n",
    "            one_para = {**one_para_dict, **update_para}\n",
    "\n",
    "            del one_para['n_estimators']\n",
    "            locals()[f'y_{one_key}'] = globals()[f'pnls_df_OHLC{one_tkn}'][one_key][1:].to_numpy()\n",
    "            locals()[f'xgb_model_{one_key}'] = xgboost.train(one_para, \n",
    "                              dtrain=xgboost.DMatrix(x, locals()[f'y_{one_key}']), \n",
    "                              xgb_model=globals()[f'xgb_model_{one_key}'])\n",
    "\n",
    "            locals()[f'xgb_model_{one_key}'].save_model(f'./xgb_models_tick_data/xgbmodel_{one_key}') \n",
    "    \n",
    "    \n",
    "    \n",
    "    \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2a244893",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dfc5bc5b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "597fcc85",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "bdab63fc",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T03:00:20.188586Z",
     "start_time": "2021-04-14T03:00:20.169814Z"
    }
   },
   "outputs": [],
   "source": [
    "future_window = 30\n",
    "initial_dmat = xgboost.DMatrix(x[:1].values)\n",
    "all_future_json_list_for_df = []"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "00c5e707",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T03:00:30.443242Z",
     "start_time": "2021-04-14T03:00:23.041482Z"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-------------------------------------------------------\n",
      "######  Future number : 0 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 1 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 2 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 3 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 4 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 5 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 6 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 7 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 8 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 9 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 10 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 11 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 12 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 13 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 14 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 15 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 16 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 17 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 18 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 19 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 20 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 21 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 22 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 23 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 24 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 25 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 26 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 27 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 28 #######\n",
      "-------------------------------------------------------\n",
      "######  Future number : 29 #######\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>last_price</th>\n",
       "      <th>last_quantity</th>\n",
       "      <th>average_price</th>\n",
       "      <th>volume</th>\n",
       "      <th>buy_quantity</th>\n",
       "      <th>sell_quantity</th>\n",
       "      <th>change</th>\n",
       "      <th>oi</th>\n",
       "      <th>oi_day_high</th>\n",
       "      <th>oi_day_low</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1816.485107</td>\n",
       "      <td>57.569672</td>\n",
       "      <td>7.363746e+07</td>\n",
       "      <td>314419072.0</td>\n",
       "      <td>-16449.578125</td>\n",
       "      <td>186760.484375</td>\n",
       "      <td>-21.332952</td>\n",
       "      <td>-564.909241</td>\n",
       "      <td>-135.322327</td>\n",
       "      <td>-1561.769287</td>\n",
       "      <td>2097.895996</td>\n",
       "      <td>390.813141</td>\n",
       "      <td>30.190094</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1913.340698</td>\n",
       "      <td>71.195473</td>\n",
       "      <td>1.595248e+07</td>\n",
       "      <td>207377776.0</td>\n",
       "      <td>-948.697754</td>\n",
       "      <td>299327.312500</td>\n",
       "      <td>-24.665676</td>\n",
       "      <td>-919.451294</td>\n",
       "      <td>-44.441879</td>\n",
       "      <td>2516.954834</td>\n",
       "      <td>2062.648926</td>\n",
       "      <td>-3390.158691</td>\n",
       "      <td>265.005890</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1914.494019</td>\n",
       "      <td>715.969299</td>\n",
       "      <td>8.424998e+06</td>\n",
       "      <td>265690848.0</td>\n",
       "      <td>23801.148438</td>\n",
       "      <td>342228.718750</td>\n",
       "      <td>-37.920193</td>\n",
       "      <td>-1313.313354</td>\n",
       "      <td>-4255.713379</td>\n",
       "      <td>10694.279297</td>\n",
       "      <td>2059.400146</td>\n",
       "      <td>-1055.480957</td>\n",
       "      <td>-182.269440</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1914.911987</td>\n",
       "      <td>652.632935</td>\n",
       "      <td>-6.046951e+07</td>\n",
       "      <td>160671456.0</td>\n",
       "      <td>83986.671875</td>\n",
       "      <td>426172.656250</td>\n",
       "      <td>-11.928080</td>\n",
       "      <td>-1325.533447</td>\n",
       "      <td>-3710.478271</td>\n",
       "      <td>11782.777344</td>\n",
       "      <td>2066.801025</td>\n",
       "      <td>-5144.340820</td>\n",
       "      <td>-137.536819</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1856.286499</td>\n",
       "      <td>635.785645</td>\n",
       "      <td>2.808407e+06</td>\n",
       "      <td>210989984.0</td>\n",
       "      <td>145676.234375</td>\n",
       "      <td>482335.593750</td>\n",
       "      <td>-25.437271</td>\n",
       "      <td>-1958.645142</td>\n",
       "      <td>-3479.791992</td>\n",
       "      <td>30814.396484</td>\n",
       "      <td>2033.564331</td>\n",
       "      <td>-382.427246</td>\n",
       "      <td>-209.502625</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1915.342651</td>\n",
       "      <td>879.765198</td>\n",
       "      <td>-1.334331e+07</td>\n",
       "      <td>171629856.0</td>\n",
       "      <td>216942.937500</td>\n",
       "      <td>608640.125000</td>\n",
       "      <td>-13.515894</td>\n",
       "      <td>-1180.619995</td>\n",
       "      <td>-3515.385498</td>\n",
       "      <td>8301.915039</td>\n",
       "      <td>2045.789917</td>\n",
       "      <td>-4573.145996</td>\n",
       "      <td>-219.107620</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1856.191772</td>\n",
       "      <td>579.299805</td>\n",
       "      <td>1.453884e+07</td>\n",
       "      <td>227475616.0</td>\n",
       "      <td>218734.687500</td>\n",
       "      <td>589379.937500</td>\n",
       "      <td>-37.869518</td>\n",
       "      <td>-2218.303223</td>\n",
       "      <td>-3373.118408</td>\n",
       "      <td>19958.339844</td>\n",
       "      <td>2033.606323</td>\n",
       "      <td>-1263.097046</td>\n",
       "      <td>-166.907410</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1915.136597</td>\n",
       "      <td>735.898132</td>\n",
       "      <td>1.156647e+06</td>\n",
       "      <td>189568768.0</td>\n",
       "      <td>266656.281250</td>\n",
       "      <td>610680.687500</td>\n",
       "      <td>-30.201790</td>\n",
       "      <td>-1155.470947</td>\n",
       "      <td>-3410.431152</td>\n",
       "      <td>-9592.418945</td>\n",
       "      <td>2046.406372</td>\n",
       "      <td>-4158.181152</td>\n",
       "      <td>-289.130066</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1917.086792</td>\n",
       "      <td>907.906677</td>\n",
       "      <td>-9.203951e+05</td>\n",
       "      <td>182481664.0</td>\n",
       "      <td>320933.968750</td>\n",
       "      <td>614079.187500</td>\n",
       "      <td>-30.011307</td>\n",
       "      <td>-1178.545532</td>\n",
       "      <td>-3428.309326</td>\n",
       "      <td>-1595.852295</td>\n",
       "      <td>2046.965942</td>\n",
       "      <td>-5159.833984</td>\n",
       "      <td>-262.818054</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1856.221069</td>\n",
       "      <td>620.798096</td>\n",
       "      <td>-3.476800e+06</td>\n",
       "      <td>227355936.0</td>\n",
       "      <td>301389.218750</td>\n",
       "      <td>525394.062500</td>\n",
       "      <td>-38.339783</td>\n",
       "      <td>-2207.943359</td>\n",
       "      <td>-3400.871582</td>\n",
       "      <td>24259.140625</td>\n",
       "      <td>2031.107300</td>\n",
       "      <td>-1356.616699</td>\n",
       "      <td>-153.884949</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1854.385132</td>\n",
       "      <td>397.698486</td>\n",
       "      <td>2.299089e+06</td>\n",
       "      <td>234265952.0</td>\n",
       "      <td>285730.031250</td>\n",
       "      <td>454577.218750</td>\n",
       "      <td>-35.895473</td>\n",
       "      <td>-2232.739990</td>\n",
       "      <td>-3414.283203</td>\n",
       "      <td>28724.882812</td>\n",
       "      <td>2032.252319</td>\n",
       "      <td>-544.359863</td>\n",
       "      <td>-156.481628</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1915.140503</td>\n",
       "      <td>761.584839</td>\n",
       "      <td>6.410777e+06</td>\n",
       "      <td>203534688.0</td>\n",
       "      <td>322201.062500</td>\n",
       "      <td>482762.875000</td>\n",
       "      <td>-33.128048</td>\n",
       "      <td>-1199.815674</td>\n",
       "      <td>-3423.466309</td>\n",
       "      <td>1979.571899</td>\n",
       "      <td>2045.906860</td>\n",
       "      <td>-2367.476318</td>\n",
       "      <td>-233.393265</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1917.077026</td>\n",
       "      <td>780.563477</td>\n",
       "      <td>-1.439292e+07</td>\n",
       "      <td>198703840.0</td>\n",
       "      <td>362564.375000</td>\n",
       "      <td>516293.812500</td>\n",
       "      <td>-29.137291</td>\n",
       "      <td>-1240.012573</td>\n",
       "      <td>-3426.639648</td>\n",
       "      <td>-179.555634</td>\n",
       "      <td>2045.410278</td>\n",
       "      <td>-5356.428223</td>\n",
       "      <td>-238.944046</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1856.372437</td>\n",
       "      <td>669.544128</td>\n",
       "      <td>-3.117014e+06</td>\n",
       "      <td>235838240.0</td>\n",
       "      <td>330494.281250</td>\n",
       "      <td>462664.000000</td>\n",
       "      <td>-35.577023</td>\n",
       "      <td>-2158.834473</td>\n",
       "      <td>-3404.439453</td>\n",
       "      <td>26928.675781</td>\n",
       "      <td>2030.929077</td>\n",
       "      <td>-1572.948730</td>\n",
       "      <td>-161.715515</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1854.385132</td>\n",
       "      <td>735.645874</td>\n",
       "      <td>-4.909888e+06</td>\n",
       "      <td>251251168.0</td>\n",
       "      <td>291343.281250</td>\n",
       "      <td>412274.656250</td>\n",
       "      <td>-36.609982</td>\n",
       "      <td>-2148.982666</td>\n",
       "      <td>-3398.785156</td>\n",
       "      <td>26438.968750</td>\n",
       "      <td>2030.742554</td>\n",
       "      <td>-1664.104004</td>\n",
       "      <td>-131.382996</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1854.385132</td>\n",
       "      <td>762.295471</td>\n",
       "      <td>2.829692e+07</td>\n",
       "      <td>247167328.0</td>\n",
       "      <td>276622.187500</td>\n",
       "      <td>387809.625000</td>\n",
       "      <td>-38.574551</td>\n",
       "      <td>-2274.299316</td>\n",
       "      <td>-3392.243408</td>\n",
       "      <td>32909.023438</td>\n",
       "      <td>2032.138550</td>\n",
       "      <td>-604.065308</td>\n",
       "      <td>-160.912292</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1915.140503</td>\n",
       "      <td>849.906921</td>\n",
       "      <td>-4.207212e+06</td>\n",
       "      <td>190389376.0</td>\n",
       "      <td>322161.437500</td>\n",
       "      <td>420295.156250</td>\n",
       "      <td>-26.690952</td>\n",
       "      <td>-1255.618774</td>\n",
       "      <td>-3409.380371</td>\n",
       "      <td>5706.876465</td>\n",
       "      <td>2046.642456</td>\n",
       "      <td>-5624.663086</td>\n",
       "      <td>-217.276077</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1856.322632</td>\n",
       "      <td>541.108521</td>\n",
       "      <td>1.438686e+07</td>\n",
       "      <td>248548448.0</td>\n",
       "      <td>285395.406250</td>\n",
       "      <td>375767.406250</td>\n",
       "      <td>-40.163792</td>\n",
       "      <td>-2212.298584</td>\n",
       "      <td>-3389.010010</td>\n",
       "      <td>27497.234375</td>\n",
       "      <td>2030.814331</td>\n",
       "      <td>-909.207886</td>\n",
       "      <td>-163.663757</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1915.140503</td>\n",
       "      <td>756.755432</td>\n",
       "      <td>1.435739e+07</td>\n",
       "      <td>169698656.0</td>\n",
       "      <td>339675.562500</td>\n",
       "      <td>389530.562500</td>\n",
       "      <td>-27.734726</td>\n",
       "      <td>-1255.566650</td>\n",
       "      <td>-3424.883789</td>\n",
       "      <td>7482.292969</td>\n",
       "      <td>2046.723267</td>\n",
       "      <td>-3505.386475</td>\n",
       "      <td>-226.581253</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1917.101440</td>\n",
       "      <td>798.983887</td>\n",
       "      <td>-1.169052e+07</td>\n",
       "      <td>191478528.0</td>\n",
       "      <td>379767.625000</td>\n",
       "      <td>412108.875000</td>\n",
       "      <td>-29.882816</td>\n",
       "      <td>-1252.893066</td>\n",
       "      <td>-3416.902100</td>\n",
       "      <td>4626.066406</td>\n",
       "      <td>2045.295776</td>\n",
       "      <td>-5904.089355</td>\n",
       "      <td>-200.946976</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1856.372437</td>\n",
       "      <td>751.472717</td>\n",
       "      <td>1.714759e+07</td>\n",
       "      <td>243807712.0</td>\n",
       "      <td>321429.843750</td>\n",
       "      <td>374719.843750</td>\n",
       "      <td>-44.011059</td>\n",
       "      <td>-2206.864746</td>\n",
       "      <td>-3395.597412</td>\n",
       "      <td>30039.072266</td>\n",
       "      <td>2030.814331</td>\n",
       "      <td>-1112.801147</td>\n",
       "      <td>-118.395683</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1915.142456</td>\n",
       "      <td>795.078857</td>\n",
       "      <td>-1.544363e+06</td>\n",
       "      <td>170304992.0</td>\n",
       "      <td>356999.875000</td>\n",
       "      <td>388902.250000</td>\n",
       "      <td>-26.188274</td>\n",
       "      <td>-1302.895752</td>\n",
       "      <td>-3417.666016</td>\n",
       "      <td>7309.410645</td>\n",
       "      <td>2045.399048</td>\n",
       "      <td>-6005.833496</td>\n",
       "      <td>-216.987015</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1856.368530</td>\n",
       "      <td>671.634888</td>\n",
       "      <td>1.733783e+07</td>\n",
       "      <td>246097120.0</td>\n",
       "      <td>319857.218750</td>\n",
       "      <td>366163.093750</td>\n",
       "      <td>-35.481113</td>\n",
       "      <td>-2196.949219</td>\n",
       "      <td>-3378.726318</td>\n",
       "      <td>31348.394531</td>\n",
       "      <td>2030.814331</td>\n",
       "      <td>-1227.598022</td>\n",
       "      <td>-144.544617</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1915.142456</td>\n",
       "      <td>918.744812</td>\n",
       "      <td>-1.218276e+07</td>\n",
       "      <td>176720704.0</td>\n",
       "      <td>361434.562500</td>\n",
       "      <td>385108.437500</td>\n",
       "      <td>-27.353500</td>\n",
       "      <td>-1293.436279</td>\n",
       "      <td>-3410.869385</td>\n",
       "      <td>6390.068848</td>\n",
       "      <td>2045.183960</td>\n",
       "      <td>-5813.546875</td>\n",
       "      <td>-163.804886</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1856.372437</td>\n",
       "      <td>543.185303</td>\n",
       "      <td>1.850518e+07</td>\n",
       "      <td>245924640.0</td>\n",
       "      <td>315606.343750</td>\n",
       "      <td>363683.218750</td>\n",
       "      <td>-36.719280</td>\n",
       "      <td>-2196.949219</td>\n",
       "      <td>-3379.090088</td>\n",
       "      <td>31348.394531</td>\n",
       "      <td>2030.836792</td>\n",
       "      <td>-1488.567139</td>\n",
       "      <td>-143.704773</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1915.142456</td>\n",
       "      <td>862.151672</td>\n",
       "      <td>1.610905e+07</td>\n",
       "      <td>177472576.0</td>\n",
       "      <td>364996.187500</td>\n",
       "      <td>379355.750000</td>\n",
       "      <td>-28.725571</td>\n",
       "      <td>-1268.917114</td>\n",
       "      <td>-3424.333496</td>\n",
       "      <td>6456.279785</td>\n",
       "      <td>2046.738647</td>\n",
       "      <td>-4125.535645</td>\n",
       "      <td>-166.108109</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1917.129761</td>\n",
       "      <td>675.879333</td>\n",
       "      <td>8.666871e+05</td>\n",
       "      <td>191765248.0</td>\n",
       "      <td>397978.875000</td>\n",
       "      <td>398387.031250</td>\n",
       "      <td>-28.582642</td>\n",
       "      <td>-1252.840942</td>\n",
       "      <td>-3409.903320</td>\n",
       "      <td>4774.937500</td>\n",
       "      <td>2045.309448</td>\n",
       "      <td>-5572.333496</td>\n",
       "      <td>-237.884476</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1917.129761</td>\n",
       "      <td>1324.077026</td>\n",
       "      <td>-2.227624e+07</td>\n",
       "      <td>208799968.0</td>\n",
       "      <td>468873.562500</td>\n",
       "      <td>423077.281250</td>\n",
       "      <td>-25.482124</td>\n",
       "      <td>-1226.050171</td>\n",
       "      <td>-3441.982422</td>\n",
       "      <td>6507.084473</td>\n",
       "      <td>2045.521606</td>\n",
       "      <td>-5643.447266</td>\n",
       "      <td>-204.275101</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1856.363647</td>\n",
       "      <td>945.642090</td>\n",
       "      <td>1.612693e+07</td>\n",
       "      <td>243351136.0</td>\n",
       "      <td>419646.093750</td>\n",
       "      <td>373832.375000</td>\n",
       "      <td>-32.099285</td>\n",
       "      <td>-2163.343262</td>\n",
       "      <td>-3426.697998</td>\n",
       "      <td>29806.681641</td>\n",
       "      <td>2031.211060</td>\n",
       "      <td>-1975.224121</td>\n",
       "      <td>-28.801445</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1915.196167</td>\n",
       "      <td>1041.084961</td>\n",
       "      <td>-7.771239e+05</td>\n",
       "      <td>197590560.0</td>\n",
       "      <td>464075.281250</td>\n",
       "      <td>390106.687500</td>\n",
       "      <td>-21.367409</td>\n",
       "      <td>-1215.922852</td>\n",
       "      <td>-3443.325928</td>\n",
       "      <td>8433.034180</td>\n",
       "      <td>2045.796753</td>\n",
       "      <td>-6834.288574</td>\n",
       "      <td>-205.971390</td>\n",
       "      <td>373.73941</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     last_price  last_quantity  average_price       volume   buy_quantity  \\\n",
       "0   1816.485107      57.569672   7.363746e+07  314419072.0  -16449.578125   \n",
       "1   1913.340698      71.195473   1.595248e+07  207377776.0    -948.697754   \n",
       "2   1914.494019     715.969299   8.424998e+06  265690848.0   23801.148438   \n",
       "3   1914.911987     652.632935  -6.046951e+07  160671456.0   83986.671875   \n",
       "4   1856.286499     635.785645   2.808407e+06  210989984.0  145676.234375   \n",
       "5   1915.342651     879.765198  -1.334331e+07  171629856.0  216942.937500   \n",
       "6   1856.191772     579.299805   1.453884e+07  227475616.0  218734.687500   \n",
       "7   1915.136597     735.898132   1.156647e+06  189568768.0  266656.281250   \n",
       "8   1917.086792     907.906677  -9.203951e+05  182481664.0  320933.968750   \n",
       "9   1856.221069     620.798096  -3.476800e+06  227355936.0  301389.218750   \n",
       "10  1854.385132     397.698486   2.299089e+06  234265952.0  285730.031250   \n",
       "11  1915.140503     761.584839   6.410777e+06  203534688.0  322201.062500   \n",
       "12  1917.077026     780.563477  -1.439292e+07  198703840.0  362564.375000   \n",
       "13  1856.372437     669.544128  -3.117014e+06  235838240.0  330494.281250   \n",
       "14  1854.385132     735.645874  -4.909888e+06  251251168.0  291343.281250   \n",
       "15  1854.385132     762.295471   2.829692e+07  247167328.0  276622.187500   \n",
       "16  1915.140503     849.906921  -4.207212e+06  190389376.0  322161.437500   \n",
       "17  1856.322632     541.108521   1.438686e+07  248548448.0  285395.406250   \n",
       "18  1915.140503     756.755432   1.435739e+07  169698656.0  339675.562500   \n",
       "19  1917.101440     798.983887  -1.169052e+07  191478528.0  379767.625000   \n",
       "20  1856.372437     751.472717   1.714759e+07  243807712.0  321429.843750   \n",
       "21  1915.142456     795.078857  -1.544363e+06  170304992.0  356999.875000   \n",
       "22  1856.368530     671.634888   1.733783e+07  246097120.0  319857.218750   \n",
       "23  1915.142456     918.744812  -1.218276e+07  176720704.0  361434.562500   \n",
       "24  1856.372437     543.185303   1.850518e+07  245924640.0  315606.343750   \n",
       "25  1915.142456     862.151672   1.610905e+07  177472576.0  364996.187500   \n",
       "26  1917.129761     675.879333   8.666871e+05  191765248.0  397978.875000   \n",
       "27  1917.129761    1324.077026  -2.227624e+07  208799968.0  468873.562500   \n",
       "28  1856.363647     945.642090   1.612693e+07  243351136.0  419646.093750   \n",
       "29  1915.196167    1041.084961  -7.771239e+05  197590560.0  464075.281250   \n",
       "\n",
       "    sell_quantity     change           oi  oi_day_high    oi_day_low  \\\n",
       "0   186760.484375 -21.332952  -564.909241  -135.322327  -1561.769287   \n",
       "1   299327.312500 -24.665676  -919.451294   -44.441879   2516.954834   \n",
       "2   342228.718750 -37.920193 -1313.313354 -4255.713379  10694.279297   \n",
       "3   426172.656250 -11.928080 -1325.533447 -3710.478271  11782.777344   \n",
       "4   482335.593750 -25.437271 -1958.645142 -3479.791992  30814.396484   \n",
       "5   608640.125000 -13.515894 -1180.619995 -3515.385498   8301.915039   \n",
       "6   589379.937500 -37.869518 -2218.303223 -3373.118408  19958.339844   \n",
       "7   610680.687500 -30.201790 -1155.470947 -3410.431152  -9592.418945   \n",
       "8   614079.187500 -30.011307 -1178.545532 -3428.309326  -1595.852295   \n",
       "9   525394.062500 -38.339783 -2207.943359 -3400.871582  24259.140625   \n",
       "10  454577.218750 -35.895473 -2232.739990 -3414.283203  28724.882812   \n",
       "11  482762.875000 -33.128048 -1199.815674 -3423.466309   1979.571899   \n",
       "12  516293.812500 -29.137291 -1240.012573 -3426.639648   -179.555634   \n",
       "13  462664.000000 -35.577023 -2158.834473 -3404.439453  26928.675781   \n",
       "14  412274.656250 -36.609982 -2148.982666 -3398.785156  26438.968750   \n",
       "15  387809.625000 -38.574551 -2274.299316 -3392.243408  32909.023438   \n",
       "16  420295.156250 -26.690952 -1255.618774 -3409.380371   5706.876465   \n",
       "17  375767.406250 -40.163792 -2212.298584 -3389.010010  27497.234375   \n",
       "18  389530.562500 -27.734726 -1255.566650 -3424.883789   7482.292969   \n",
       "19  412108.875000 -29.882816 -1252.893066 -3416.902100   4626.066406   \n",
       "20  374719.843750 -44.011059 -2206.864746 -3395.597412  30039.072266   \n",
       "21  388902.250000 -26.188274 -1302.895752 -3417.666016   7309.410645   \n",
       "22  366163.093750 -35.481113 -2196.949219 -3378.726318  31348.394531   \n",
       "23  385108.437500 -27.353500 -1293.436279 -3410.869385   6390.068848   \n",
       "24  363683.218750 -36.719280 -2196.949219 -3379.090088  31348.394531   \n",
       "25  379355.750000 -28.725571 -1268.917114 -3424.333496   6456.279785   \n",
       "26  398387.031250 -28.582642 -1252.840942 -3409.903320   4774.937500   \n",
       "27  423077.281250 -25.482124 -1226.050171 -3441.982422   6507.084473   \n",
       "28  373832.375000 -32.099285 -2163.343262 -3426.697998  29806.681641   \n",
       "29  390106.687500 -21.367409 -1215.922852 -3443.325928   8433.034180   \n",
       "\n",
       "           open         high         low      close  \n",
       "0   2097.895996   390.813141   30.190094  373.73941  \n",
       "1   2062.648926 -3390.158691  265.005890  373.73941  \n",
       "2   2059.400146 -1055.480957 -182.269440  373.73941  \n",
       "3   2066.801025 -5144.340820 -137.536819  373.73941  \n",
       "4   2033.564331  -382.427246 -209.502625  373.73941  \n",
       "5   2045.789917 -4573.145996 -219.107620  373.73941  \n",
       "6   2033.606323 -1263.097046 -166.907410  373.73941  \n",
       "7   2046.406372 -4158.181152 -289.130066  373.73941  \n",
       "8   2046.965942 -5159.833984 -262.818054  373.73941  \n",
       "9   2031.107300 -1356.616699 -153.884949  373.73941  \n",
       "10  2032.252319  -544.359863 -156.481628  373.73941  \n",
       "11  2045.906860 -2367.476318 -233.393265  373.73941  \n",
       "12  2045.410278 -5356.428223 -238.944046  373.73941  \n",
       "13  2030.929077 -1572.948730 -161.715515  373.73941  \n",
       "14  2030.742554 -1664.104004 -131.382996  373.73941  \n",
       "15  2032.138550  -604.065308 -160.912292  373.73941  \n",
       "16  2046.642456 -5624.663086 -217.276077  373.73941  \n",
       "17  2030.814331  -909.207886 -163.663757  373.73941  \n",
       "18  2046.723267 -3505.386475 -226.581253  373.73941  \n",
       "19  2045.295776 -5904.089355 -200.946976  373.73941  \n",
       "20  2030.814331 -1112.801147 -118.395683  373.73941  \n",
       "21  2045.399048 -6005.833496 -216.987015  373.73941  \n",
       "22  2030.814331 -1227.598022 -144.544617  373.73941  \n",
       "23  2045.183960 -5813.546875 -163.804886  373.73941  \n",
       "24  2030.836792 -1488.567139 -143.704773  373.73941  \n",
       "25  2046.738647 -4125.535645 -166.108109  373.73941  \n",
       "26  2045.309448 -5572.333496 -237.884476  373.73941  \n",
       "27  2045.521606 -5643.447266 -204.275101  373.73941  \n",
       "28  2031.211060 -1975.224121  -28.801445  373.73941  \n",
       "29  2045.796753 -6834.288574 -205.971390  373.73941  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for one_future in range(future_window):\n",
    "    this_future_dict = {}\n",
    "    print('-'*55)\n",
    "    print(f'######  Future number : {one_future} #######')\n",
    "\n",
    "    for one_key in x.keys():\n",
    "        globals()[f'xgb_model_{one_key}'] = xgboost.Booster({'nthread':4})\n",
    "        globals()[f'xgb_model_{one_key}'].load_model(f\"./xgb_models_tick_data/xgbmodel_{one_key}\")\n",
    "        locals()[one_key] = globals()[f'xgb_model_{one_key}'].predict(initial_dmat)\n",
    "#         print(f'Predicted {one_key} : {locals()[one_key][0]}')\n",
    "        this_future_dict[f'{one_key}'] = locals()[one_key][0]\n",
    "            \n",
    "#     print(this_future_dict)\n",
    "    this_future_dict_df = pd.DataFrame(this_future_dict,index=[0])\n",
    "    initial_dmat = xgboost.DMatrix(this_future_dict_df)\n",
    "    all_future_json_list_for_df.append(this_future_dict)\n",
    "    \n",
    "all_future_df = pd.DataFrame(all_future_json_list_for_df)\n",
    "all_future_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "853ab90c",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-04-14T03:00:39.346920Z",
     "start_time": "2021-04-14T03:00:38.643215Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"910023c1-e311-48e4-9c34-1588713c5fc8\" data-root-id=\"1003\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"2bd0297a-4126-4eec-b09f-ecf96c1dacc8\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1014\"}],\"center\":[{\"id\":\"1017\"},{\"id\":\"1021\"},{\"id\":\"1052\"}],\"height\":400,\"left\":[{\"id\":\"1018\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1040\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1004\"},\"toolbar\":{\"id\":\"1029\"},\"x_range\":{\"id\":\"1006\"},\"x_scale\":{\"id\":\"1010\"},\"y_range\":{\"id\":\"1008\"},\"y_scale\":{\"id\":\"1012\"}},\"id\":\"1003\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1028\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"label\":{\"value\":\" last_price\"},\"renderers\":[{\"id\":\"1040\"}]},\"id\":\"1053\",\"type\":\"LegendItem\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"last_price\"}},\"id\":\"1038\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1046\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"axis\":{\"id\":\"1018\"},\"dimension\":1,\"ticker\":null},\"id\":\"1021\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1048\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1023\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"source\":{\"id\":\"1036\"}},\"id\":\"1041\",\"type\":\"CDSView\"},{\"attributes\":{},\"id\":\"1027\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"1025\",\"type\":\"SaveTool\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"last_price\"}},\"id\":\"1039\",\"type\":\"Line\"},{\"attributes\":{\"overlay\":{\"id\":\"1028\"}},\"id\":\"1024\",\"type\":\"BoxZoomTool\"},{\"attributes\":{\"axis_label\":\"last_price\",\"formatter\":{\"id\":\"1043\"},\"major_label_policy\":{\"id\":\"1045\"},\"ticker\":{\"id\":\"1019\"}},\"id\":\"1018\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1012\",\"type\":\"LinearScale\"},{\"attributes\":{\"data_source\":{\"id\":\"1036\"},\"glyph\":{\"id\":\"1038\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1039\"},\"view\":{\"id\":\"1041\"}},\"id\":\"1040\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1053\"}]},\"id\":\"1052\",\"type\":\"Legend\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1040\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"last_price\",\"@{last_price}\"]]},\"id\":\"1054\",\"type\":\"HoverTool\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"last_price\":{\"__ndarray__\":\"AAAAwPBhnEAAAADgXOWdQAAAAOD56Z1AAAAA4KXrnUAAAABgJQGdQAAAAOBe7Z1AAAAAYMQAnUAAAADgi+ydQAAAAOBY9J1AAAAAYOIAnUAAAABgivmcQAAAAOCP7J1AAAAA4E70nUAAAABgfQGdQAAAAGCK+ZxAAAAAYIr5nEAAAADgj+ydQAAAAGBKAZ1AAAAA4I/snUAAAADgZ/SdQAAAAGB9AZ1AAAAA4JHsnUAAAABgeQGdQAAAAOCR7J1AAAAAYH0BnUAAAADgkeydQAAAAOCE9J1AAAAA4IT0nUAAAABgdAGdQAAAAODI7J1A\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1050\"},\"selection_policy\":{\"id\":\"1049\"}},\"id\":\"1036\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"1026\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"1019\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"1049\",\"type\":\"UnionRenderers\"},{\"attributes\":{\"formatter\":{\"id\":\"1046\"},\"major_label_policy\":{\"id\":\"1048\"},\"ticker\":{\"id\":\"1015\"}},\"id\":\"1014\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1050\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"1008\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"1004\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"1043\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"axis\":{\"id\":\"1014\"},\"ticker\":null},\"id\":\"1017\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1015\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"1045\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1022\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"1010\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1006\",\"type\":\"DataRange1d\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1023\"},\"tools\":[{\"id\":\"1022\"},{\"id\":\"1023\"},{\"id\":\"1024\"},{\"id\":\"1025\"},{\"id\":\"1026\"},{\"id\":\"1027\"},{\"id\":\"1054\"}]},\"id\":\"1029\",\"type\":\"Toolbar\"}],\"root_ids\":[\"1003\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"2bd0297a-4126-4eec-b09f-ecf96c1dacc8\",\"root_ids\":[\"1003\"],\"roots\":{\"1003\":\"910023c1-e311-48e4-9c34-1588713c5fc8\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1003"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"dc3ce4f4-82c7-4c41-aaad-25bc70b9e318\" data-root-id=\"1116\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"8831b7ce-4273-43b8-8a47-8ad56210480b\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1127\"}],\"center\":[{\"id\":\"1130\"},{\"id\":\"1134\"},{\"id\":\"1165\"}],\"height\":400,\"left\":[{\"id\":\"1131\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1153\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1117\"},\"toolbar\":{\"id\":\"1142\"},\"x_range\":{\"id\":\"1119\"},\"x_scale\":{\"id\":\"1123\"},\"y_range\":{\"id\":\"1121\"},\"y_scale\":{\"id\":\"1125\"}},\"id\":\"1116\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"1125\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1123\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1128\",\"type\":\"BasicTicker\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"last_quantity\"}},\"id\":\"1152\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1117\",\"type\":\"Title\"},{\"attributes\":{\"source\":{\"id\":\"1149\"}},\"id\":\"1154\",\"type\":\"CDSView\"},{\"attributes\":{},\"id\":\"1121\",\"type\":\"DataRange1d\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1153\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"last_quantity\",\"@{last_quantity}\"]]},\"id\":\"1167\",\"type\":\"HoverTool\"},{\"attributes\":{\"axis\":{\"id\":\"1131\"},\"dimension\":1,\"ticker\":null},\"id\":\"1134\",\"type\":\"Grid\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1166\"}]},\"id\":\"1165\",\"type\":\"Legend\"},{\"attributes\":{},\"id\":\"1132\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"1140\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"1135\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"1162\",\"type\":\"UnionRenderers\"},{\"attributes\":{\"overlay\":{\"id\":\"1141\"}},\"id\":\"1137\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"1163\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"1161\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1138\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"1139\",\"type\":\"ResetTool\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1141\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"last_quantity\":{\"__ndarray__\":\"AAAAAOvITEAAAACggsxRQAAAACDBX4ZAAAAAQBBlhEAAAAAASd6DQAAAACAffotAAAAAAGYagkAAAABgL/+GQAAAAOBAX4xAAAAAgGJmg0AAAAAALdt4QAAAAMCtzIdAAAAAAIJkiEAAAABgWuyEQAAAAMAq/YZAAAAAIF3Sh0AAAABgQY+KQAAAAEDe6IBAAAAAIAumh0AAAAAA3/eIQAAAACDIe4dAAAAAgKHYiEAAAABAFP2EQAAAAGD1tYxAAAAAgHv5gEAAAACgNvGKQAAAAOAIH4VAAAAA4E6wlEAAAAAAI42NQAAAAABXRJBA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1163\"},\"selection_policy\":{\"id\":\"1162\"}},\"id\":\"1149\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"last_quantity\"}},\"id\":\"1151\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1158\",\"type\":\"AllLabels\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1136\"},\"tools\":[{\"id\":\"1135\"},{\"id\":\"1136\"},{\"id\":\"1137\"},{\"id\":\"1138\"},{\"id\":\"1139\"},{\"id\":\"1140\"},{\"id\":\"1167\"}]},\"id\":\"1142\",\"type\":\"Toolbar\"},{\"attributes\":{\"data_source\":{\"id\":\"1149\"},\"glyph\":{\"id\":\"1151\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1152\"},\"view\":{\"id\":\"1154\"}},\"id\":\"1153\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"1156\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1159\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"axis\":{\"id\":\"1127\"},\"ticker\":null},\"id\":\"1130\",\"type\":\"Grid\"},{\"attributes\":{\"label\":{\"value\":\" last_quantity\"},\"renderers\":[{\"id\":\"1153\"}]},\"id\":\"1166\",\"type\":\"LegendItem\"},{\"attributes\":{\"formatter\":{\"id\":\"1159\"},\"major_label_policy\":{\"id\":\"1161\"},\"ticker\":{\"id\":\"1128\"}},\"id\":\"1127\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1136\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"1119\",\"type\":\"DataRange1d\"},{\"attributes\":{\"axis_label\":\"last_quantity\",\"formatter\":{\"id\":\"1156\"},\"major_label_policy\":{\"id\":\"1158\"},\"ticker\":{\"id\":\"1132\"}},\"id\":\"1131\",\"type\":\"LinearAxis\"}],\"root_ids\":[\"1116\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"8831b7ce-4273-43b8-8a47-8ad56210480b\",\"root_ids\":[\"1116\"],\"roots\":{\"1116\":\"dc3ce4f4-82c7-4c41-aaad-25bc70b9e318\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1116"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"192c2862-692d-4389-a01f-4c2f5b7ea9cf\" data-root-id=\"1239\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"169a03c8-ab2f-4aad-8953-126f51a8a98b\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1250\"}],\"center\":[{\"id\":\"1253\"},{\"id\":\"1257\"},{\"id\":\"1288\"}],\"height\":400,\"left\":[{\"id\":\"1254\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1276\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1240\"},\"toolbar\":{\"id\":\"1265\"},\"x_range\":{\"id\":\"1242\"},\"x_scale\":{\"id\":\"1246\"},\"y_range\":{\"id\":\"1244\"},\"y_scale\":{\"id\":\"1248\"}},\"id\":\"1239\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"1244\",\"type\":\"DataRange1d\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1276\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"average_price\",\"@{average_price}\"]]},\"id\":\"1290\",\"type\":\"HoverTool\"},{\"attributes\":{},\"id\":\"1248\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1285\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"1286\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"1259\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"axis_label\":\"average_price\",\"formatter\":{\"id\":\"1279\"},\"major_label_policy\":{\"id\":\"1281\"},\"ticker\":{\"id\":\"1255\"}},\"id\":\"1254\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1246\",\"type\":\"LinearScale\"},{\"attributes\":{\"axis\":{\"id\":\"1254\"},\"dimension\":1,\"ticker\":null},\"id\":\"1257\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1255\",\"type\":\"BasicTicker\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1259\"},\"tools\":[{\"id\":\"1258\"},{\"id\":\"1259\"},{\"id\":\"1260\"},{\"id\":\"1261\"},{\"id\":\"1262\"},{\"id\":\"1263\"},{\"id\":\"1290\"}]},\"id\":\"1265\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"1279\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1263\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"1258\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"1281\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1251\",\"type\":\"BasicTicker\"},{\"attributes\":{\"overlay\":{\"id\":\"1264\"}},\"id\":\"1260\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"1242\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"1261\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"1262\",\"type\":\"ResetTool\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"average_price\"}},\"id\":\"1274\",\"type\":\"Line\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"average_price\":{\"__ndarray__\":\"AAAAQHmOkUEAAACATG1uQQAAAMDEEWBBAAAAQIjVjMEAAACAK21FQQAAAMBJc2nBAAAA4Aq7a0EAAABAJ6YxQQAAAECWFizBAAAAAKCGSsEAAABgaIpBQQAAAECGdFhBAAAA4Mpza8EAAADA6sdHwQAAAODPulLBAAAAYG38ekEAAAAAmwxQwQAAAODVcGtBAAAAAHJia0EAAABgQkxmwQAAACBsWnBBAAAAIKuQN8EAAABg3ohwQQAAAMCcPGfBAAAA4N2lcUEAAADAv7luQQAAACD+cipBAAAAwIg+dcEAAABAesJuQQAAAMBHtyfB\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1286\"},\"selection_policy\":{\"id\":\"1285\"}},\"id\":\"1272\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"1282\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"data_source\":{\"id\":\"1272\"},\"glyph\":{\"id\":\"1274\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1275\"},\"view\":{\"id\":\"1277\"}},\"id\":\"1276\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"formatter\":{\"id\":\"1282\"},\"major_label_policy\":{\"id\":\"1284\"},\"ticker\":{\"id\":\"1251\"}},\"id\":\"1250\",\"type\":\"LinearAxis\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"average_price\"}},\"id\":\"1275\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1284\",\"type\":\"AllLabels\"},{\"attributes\":{\"source\":{\"id\":\"1272\"}},\"id\":\"1277\",\"type\":\"CDSView\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1289\"}]},\"id\":\"1288\",\"type\":\"Legend\"},{\"attributes\":{\"axis\":{\"id\":\"1250\"},\"ticker\":null},\"id\":\"1253\",\"type\":\"Grid\"},{\"attributes\":{\"label\":{\"value\":\" average_price\"},\"renderers\":[{\"id\":\"1276\"}]},\"id\":\"1289\",\"type\":\"LegendItem\"},{\"attributes\":{},\"id\":\"1240\",\"type\":\"Title\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1264\",\"type\":\"BoxAnnotation\"}],\"root_ids\":[\"1239\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"169a03c8-ab2f-4aad-8953-126f51a8a98b\",\"root_ids\":[\"1239\"],\"roots\":{\"1239\":\"192c2862-692d-4389-a01f-4c2f5b7ea9cf\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1239"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"56955e0f-f97a-4bce-a211-f69df22448cc\" data-root-id=\"1372\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"276f723c-09a6-420c-88f1-3d7ee3323b8e\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1383\"}],\"center\":[{\"id\":\"1386\"},{\"id\":\"1390\"},{\"id\":\"1421\"}],\"height\":400,\"left\":[{\"id\":\"1387\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1409\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1373\"},\"toolbar\":{\"id\":\"1398\"},\"x_range\":{\"id\":\"1375\"},\"x_scale\":{\"id\":\"1379\"},\"y_range\":{\"id\":\"1377\"},\"y_scale\":{\"id\":\"1381\"}},\"id\":\"1372\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"1419\",\"type\":\"Selection\"},{\"attributes\":{\"axis_label\":\"volume\",\"formatter\":{\"id\":\"1412\"},\"major_label_policy\":{\"id\":\"1414\"},\"ticker\":{\"id\":\"1388\"}},\"id\":\"1387\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1388\",\"type\":\"BasicTicker\"},{\"attributes\":{\"axis\":{\"id\":\"1387\"},\"dimension\":1,\"ticker\":null},\"id\":\"1390\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1412\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1392\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1392\"},\"tools\":[{\"id\":\"1391\"},{\"id\":\"1392\"},{\"id\":\"1393\"},{\"id\":\"1394\"},{\"id\":\"1395\"},{\"id\":\"1396\"},{\"id\":\"1423\"}]},\"id\":\"1398\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"1414\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1396\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"1391\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"1397\"}},\"id\":\"1393\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"1394\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"1395\",\"type\":\"ResetTool\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"volume\":{\"__ndarray__\":\"AAAAgKe9skEAAADgqrioQQAAAMA9rK9BAAAAwE0no0EAAABA5yapQQAAAEC6daRBAAAAQAEeq0EAAAAALpmmQQAAAADmwKVBAAAAQFoaq0EAAADAOu2rQQAAAMBiQ6hBAAAAwPWvp0EAAABANh2sQQAAAMCT861BAAAAwPJ2rUEAAAAAObKmQQAAAMAYoa1BAAAAwMo6pEEAAAAAdtOmQQAAAMBrEK1BAAAAwEtNpEEAAADASVatQQAAAIAWEaVBAAAAQAZRrUEAAACACCilQQAAAAA23KZBAAAAwBHkqEEAAADAfAKtQQAAAED8jadB\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1419\"},\"selection_policy\":{\"id\":\"1418\"}},\"id\":\"1405\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"1415\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1381\",\"type\":\"LinearScale\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"volume\"}},\"id\":\"1407\",\"type\":\"Line\"},{\"attributes\":{\"data_source\":{\"id\":\"1405\"},\"glyph\":{\"id\":\"1407\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1408\"},\"view\":{\"id\":\"1410\"}},\"id\":\"1409\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"1417\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"volume\"}},\"id\":\"1408\",\"type\":\"Line\"},{\"attributes\":{\"source\":{\"id\":\"1405\"}},\"id\":\"1410\",\"type\":\"CDSView\"},{\"attributes\":{},\"id\":\"1379\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1384\",\"type\":\"BasicTicker\"},{\"attributes\":{\"label\":{\"value\":\" volume\"},\"renderers\":[{\"id\":\"1409\"}]},\"id\":\"1422\",\"type\":\"LegendItem\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1422\"}]},\"id\":\"1421\",\"type\":\"Legend\"},{\"attributes\":{},\"id\":\"1373\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"1377\",\"type\":\"DataRange1d\"},{\"attributes\":{\"formatter\":{\"id\":\"1415\"},\"major_label_policy\":{\"id\":\"1417\"},\"ticker\":{\"id\":\"1384\"}},\"id\":\"1383\",\"type\":\"LinearAxis\"},{\"attributes\":{\"axis\":{\"id\":\"1383\"},\"ticker\":null},\"id\":\"1386\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1375\",\"type\":\"DataRange1d\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1409\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"volume\",\"@{volume}\"]]},\"id\":\"1423\",\"type\":\"HoverTool\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1397\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"1418\",\"type\":\"UnionRenderers\"}],\"root_ids\":[\"1372\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"276f723c-09a6-420c-88f1-3d7ee3323b8e\",\"root_ids\":[\"1372\"],\"roots\":{\"1372\":\"56955e0f-f97a-4bce-a211-f69df22448cc\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1372"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"557a58ad-bc19-4aaa-ad01-dffebe5d8b66\" data-root-id=\"1515\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"b24f9c06-f076-4645-9f1d-b3bcb5f5734a\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1526\"}],\"center\":[{\"id\":\"1529\"},{\"id\":\"1533\"},{\"id\":\"1564\"}],\"height\":400,\"left\":[{\"id\":\"1530\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1552\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1516\"},\"toolbar\":{\"id\":\"1541\"},\"x_range\":{\"id\":\"1518\"},\"x_scale\":{\"id\":\"1522\"},\"y_range\":{\"id\":\"1520\"},\"y_scale\":{\"id\":\"1524\"}},\"id\":\"1515\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"axis_label\":\"buy_quantity\",\"formatter\":{\"id\":\"1555\"},\"major_label_policy\":{\"id\":\"1557\"},\"ticker\":{\"id\":\"1531\"}},\"id\":\"1530\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1555\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1535\"},\"tools\":[{\"id\":\"1534\"},{\"id\":\"1535\"},{\"id\":\"1536\"},{\"id\":\"1537\"},{\"id\":\"1538\"},{\"id\":\"1539\"},{\"id\":\"1566\"}]},\"id\":\"1541\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"1527\",\"type\":\"BasicTicker\"},{\"attributes\":{\"data_source\":{\"id\":\"1548\"},\"glyph\":{\"id\":\"1550\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1551\"},\"view\":{\"id\":\"1553\"}},\"id\":\"1552\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"1557\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1539\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"1522\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1534\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"1540\"}},\"id\":\"1536\",\"type\":\"BoxZoomTool\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"buy_quantity\":{\"__ndarray__\":\"AAAAAGUQ0MAAAAAAlaWNwAAAAIBJPtdAAAAAwCqB9EAAAADgYcgBQQAAAIB3ewpBAAAAgHWzCkEAAAAggUYQQQAAAOCXlhNBAAAA4DRlEkEAAAAgiHARQQAAAEBkqhNBAAAAgBEhFkEAAAAg+SsUQQAAACA9yBFBAAAAwDjiEEEAAADAxakTQQAAAKBNaxFBAAAAQG67FEEAAACA3i0XQQAAAGBXnhNBAAAAgB/KFUEAAADgxIUTQQAAAEBqDxZBAAAAYFlDE0EAAADAEEcWQQAAAIBrShhBAAAAQCaeHEEAAABg+JwZQQAAACAtUxxB\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1562\"},\"selection_policy\":{\"id\":\"1561\"}},\"id\":\"1548\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"1537\",\"type\":\"SaveTool\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"buy_quantity\"}},\"id\":\"1550\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1538\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"1524\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1516\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"1558\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1560\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1518\",\"type\":\"DataRange1d\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"buy_quantity\"}},\"id\":\"1551\",\"type\":\"Line\"},{\"attributes\":{\"label\":{\"value\":\" buy_quantity\"},\"renderers\":[{\"id\":\"1552\"}]},\"id\":\"1565\",\"type\":\"LegendItem\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1565\"}]},\"id\":\"1564\",\"type\":\"Legend\"},{\"attributes\":{\"source\":{\"id\":\"1548\"}},\"id\":\"1553\",\"type\":\"CDSView\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1552\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"buy_quantity\",\"@{buy_quantity}\"]]},\"id\":\"1566\",\"type\":\"HoverTool\"},{\"attributes\":{\"formatter\":{\"id\":\"1558\"},\"major_label_policy\":{\"id\":\"1560\"},\"ticker\":{\"id\":\"1527\"}},\"id\":\"1526\",\"type\":\"LinearAxis\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1540\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"axis\":{\"id\":\"1526\"},\"ticker\":null},\"id\":\"1529\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1561\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"1535\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"1562\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"1520\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"1531\",\"type\":\"BasicTicker\"},{\"attributes\":{\"axis\":{\"id\":\"1530\"},\"dimension\":1,\"ticker\":null},\"id\":\"1533\",\"type\":\"Grid\"}],\"root_ids\":[\"1515\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"b24f9c06-f076-4645-9f1d-b3bcb5f5734a\",\"root_ids\":[\"1515\"],\"roots\":{\"1515\":\"557a58ad-bc19-4aaa-ad01-dffebe5d8b66\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1515"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"36107052-af32-499f-91d4-df1e18a5d21f\" data-root-id=\"1668\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"e331f436-1ac3-47a1-bfaa-ea5fe1b954c2\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1679\"}],\"center\":[{\"id\":\"1682\"},{\"id\":\"1686\"},{\"id\":\"1717\"}],\"height\":400,\"left\":[{\"id\":\"1683\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1705\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1669\"},\"toolbar\":{\"id\":\"1694\"},\"x_range\":{\"id\":\"1671\"},\"x_scale\":{\"id\":\"1675\"},\"y_range\":{\"id\":\"1673\"},\"y_scale\":{\"id\":\"1677\"}},\"id\":\"1668\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"1687\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"1693\"}},\"id\":\"1689\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"1690\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"1677\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1691\",\"type\":\"ResetTool\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"sell_quantity\"}},\"id\":\"1703\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1711\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1675\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"1673\",\"type\":\"DataRange1d\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"sell_quantity\":{\"__ndarray__\":\"AAAA4EPMBkEAAABA/UQSQQAAAOBS4xRBAAAAoPICGkEAAABgfnAdQQAAAEAAkyJBAAAA4If8IUEAAABg8aIiQQAAAGB+vSJBAAAAIKQIIEEAAADgxL4bQQAAAIArdx1BAAAAQBeDH0EAAAAAID0cQQAAAKDKKRlBAAAAgIarF0EAAACgHKcZQQAAAKBd7xZBAAAAQGrGF0EAAACAMycZQQAAAGD/3hZBAAAAAJm8F0EAAABgTFkWQQAAAMBRgRdBAAAA4IwyFkEAAAAAbycXQQAAACDMUBhBAAAAIJXSGUEAAACAIdEWQQAAAMBqzxdB\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1715\"},\"selection_policy\":{\"id\":\"1714\"}},\"id\":\"1701\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"formatter\":{\"id\":\"1711\"},\"major_label_policy\":{\"id\":\"1713\"},\"ticker\":{\"id\":\"1680\"}},\"id\":\"1679\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1671\",\"type\":\"DataRange1d\"},{\"attributes\":{\"data_source\":{\"id\":\"1701\"},\"glyph\":{\"id\":\"1703\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1704\"},\"view\":{\"id\":\"1706\"}},\"id\":\"1705\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"1713\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"sell_quantity\"}},\"id\":\"1704\",\"type\":\"Line\"},{\"attributes\":{\"source\":{\"id\":\"1701\"}},\"id\":\"1706\",\"type\":\"CDSView\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1688\"},\"tools\":[{\"id\":\"1687\"},{\"id\":\"1688\"},{\"id\":\"1689\"},{\"id\":\"1690\"},{\"id\":\"1691\"},{\"id\":\"1692\"},{\"id\":\"1719\"}]},\"id\":\"1694\",\"type\":\"Toolbar\"},{\"attributes\":{\"label\":{\"value\":\" sell_quantity\"},\"renderers\":[{\"id\":\"1705\"}]},\"id\":\"1718\",\"type\":\"LegendItem\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1718\"}]},\"id\":\"1717\",\"type\":\"Legend\"},{\"attributes\":{\"axis\":{\"id\":\"1679\"},\"ticker\":null},\"id\":\"1682\",\"type\":\"Grid\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1705\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"sell_quantity\",\"@{sell_quantity}\"]]},\"id\":\"1719\",\"type\":\"HoverTool\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1693\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"1680\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"1714\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"1715\",\"type\":\"Selection\"},{\"attributes\":{\"axis_label\":\"sell_quantity\",\"formatter\":{\"id\":\"1708\"},\"major_label_policy\":{\"id\":\"1710\"},\"ticker\":{\"id\":\"1684\"}},\"id\":\"1683\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1688\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"axis\":{\"id\":\"1683\"},\"dimension\":1,\"ticker\":null},\"id\":\"1686\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1708\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1669\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"1684\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"1710\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1692\",\"type\":\"HelpTool\"}],\"root_ids\":[\"1668\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"e331f436-1ac3-47a1-bfaa-ea5fe1b954c2\",\"root_ids\":[\"1668\"],\"roots\":{\"1668\":\"36107052-af32-499f-91d4-df1e18a5d21f\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1668"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"bcbedbe0-f3c2-4701-a971-941723105dec\" data-root-id=\"1831\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"03275d3c-74da-4e82-bddb-5fd6550180ea\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"1842\"}],\"center\":[{\"id\":\"1845\"},{\"id\":\"1849\"},{\"id\":\"1880\"}],\"height\":400,\"left\":[{\"id\":\"1846\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"1868\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"1832\"},\"toolbar\":{\"id\":\"1857\"},\"x_range\":{\"id\":\"1834\"},\"x_scale\":{\"id\":\"1838\"},\"y_range\":{\"id\":\"1836\"},\"y_scale\":{\"id\":\"1840\"}},\"id\":\"1831\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"data_source\":{\"id\":\"1864\"},\"glyph\":{\"id\":\"1866\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"1867\"},\"view\":{\"id\":\"1869\"}},\"id\":\"1868\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"1876\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"change\"}},\"id\":\"1867\",\"type\":\"Line\"},{\"attributes\":{\"source\":{\"id\":\"1864\"}},\"id\":\"1869\",\"type\":\"CDSView\"},{\"attributes\":{\"formatter\":{\"id\":\"1874\"},\"major_label_policy\":{\"id\":\"1876\"},\"ticker\":{\"id\":\"1843\"}},\"id\":\"1842\",\"type\":\"LinearAxis\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"1851\"},\"tools\":[{\"id\":\"1850\"},{\"id\":\"1851\"},{\"id\":\"1852\"},{\"id\":\"1853\"},{\"id\":\"1854\"},{\"id\":\"1855\"},{\"id\":\"1882\"}]},\"id\":\"1857\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"1838\",\"type\":\"LinearScale\"},{\"attributes\":{\"label\":{\"value\":\" change\"},\"renderers\":[{\"id\":\"1868\"}]},\"id\":\"1881\",\"type\":\"LegendItem\"},{\"attributes\":{},\"id\":\"1836\",\"type\":\"DataRange1d\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"1881\"}]},\"id\":\"1880\",\"type\":\"Legend\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"1868\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"change\",\"@{change}\"]]},\"id\":\"1882\",\"type\":\"HoverTool\"},{\"attributes\":{},\"id\":\"1843\",\"type\":\"BasicTicker\"},{\"attributes\":{\"axis\":{\"id\":\"1842\"},\"ticker\":null},\"id\":\"1845\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1877\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"1834\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"1878\",\"type\":\"Selection\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"1856\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"change\":{\"__ndarray__\":\"AAAAYDxVNcAAAADAaao4wAAAAODI9ULAAAAAQC3bJ8AAAAAA8W85wAAAAEAjCCvAAAAAYEzvQsAAAACAqDM+wAAAAADlAj7AAAAAAH4rQ8AAAADgnvJBwAAAAOBjkEDAAAAAgCUjPcAAAADg28lBwAAAAOATTkLAAAAA4IpJQ8AAAABA4rA6wAAAACD3FETAAAAAABe8O8AAAABAAOI9wAAAAGBqAUbAAAAAwDIwOsAAAAAglb1BwAAAAAB/WjvAAAAAYBFcQsAAAAAAv7k8wAAAAAAolTzAAAAAgGx7OcAAAABgtQxAwAAAAIAOXjXA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"1878\"},\"selection_policy\":{\"id\":\"1877\"}},\"id\":\"1864\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"axis_label\":\"change\",\"formatter\":{\"id\":\"1871\"},\"major_label_policy\":{\"id\":\"1873\"},\"ticker\":{\"id\":\"1847\"}},\"id\":\"1846\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"1871\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1851\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"1832\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"1853\",\"type\":\"SaveTool\"},{\"attributes\":{\"axis\":{\"id\":\"1846\"},\"dimension\":1,\"ticker\":null},\"id\":\"1849\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"1873\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"1847\",\"type\":\"BasicTicker\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"change\"}},\"id\":\"1866\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"1855\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"1850\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"1840\",\"type\":\"LinearScale\"},{\"attributes\":{\"overlay\":{\"id\":\"1856\"}},\"id\":\"1852\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"1874\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"1854\",\"type\":\"ResetTool\"}],\"root_ids\":[\"1831\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"03275d3c-74da-4e82-bddb-5fd6550180ea\",\"root_ids\":[\"1831\"],\"roots\":{\"1831\":\"bcbedbe0-f3c2-4701-a971-941723105dec\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "1831"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"2b2070de-9130-4b44-8518-ee7fe71cdde3\" data-root-id=\"2004\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"a849b193-df16-451c-a240-b08a2d5f7d6b\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"2015\"}],\"center\":[{\"id\":\"2018\"},{\"id\":\"2022\"},{\"id\":\"2053\"}],\"height\":400,\"left\":[{\"id\":\"2019\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"2041\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"2005\"},\"toolbar\":{\"id\":\"2030\"},\"x_range\":{\"id\":\"2007\"},\"x_scale\":{\"id\":\"2011\"},\"y_range\":{\"id\":\"2009\"},\"y_scale\":{\"id\":\"2013\"}},\"id\":\"2004\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"2049\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"oi\"}},\"id\":\"2040\",\"type\":\"Line\"},{\"attributes\":{\"data_source\":{\"id\":\"2037\"},\"glyph\":{\"id\":\"2039\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"2040\"},\"view\":{\"id\":\"2042\"}},\"id\":\"2041\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"2005\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"2009\",\"type\":\"DataRange1d\"},{\"attributes\":{\"source\":{\"id\":\"2037\"}},\"id\":\"2042\",\"type\":\"CDSView\"},{\"attributes\":{\"label\":{\"value\":\" oi\"},\"renderers\":[{\"id\":\"2041\"}]},\"id\":\"2054\",\"type\":\"LegendItem\"},{\"attributes\":{},\"id\":\"2013\",\"type\":\"LinearScale\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"2054\"}]},\"id\":\"2053\",\"type\":\"Legend\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"oi\"}},\"id\":\"2039\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"2011\",\"type\":\"LinearScale\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"2041\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"oi\",\"@{oi}\"]]},\"id\":\"2055\",\"type\":\"HoverTool\"},{\"attributes\":{},\"id\":\"2016\",\"type\":\"BasicTicker\"},{\"attributes\":{\"axis_label\":\"oi\",\"formatter\":{\"id\":\"2044\"},\"major_label_policy\":{\"id\":\"2046\"},\"ticker\":{\"id\":\"2020\"}},\"id\":\"2019\",\"type\":\"LinearAxis\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"2029\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"2050\",\"type\":\"UnionRenderers\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"2024\"},\"tools\":[{\"id\":\"2023\"},{\"id\":\"2024\"},{\"id\":\"2025\"},{\"id\":\"2026\"},{\"id\":\"2027\"},{\"id\":\"2028\"},{\"id\":\"2055\"}]},\"id\":\"2030\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"2051\",\"type\":\"Selection\"},{\"attributes\":{\"formatter\":{\"id\":\"2047\"},\"major_label_policy\":{\"id\":\"2049\"},\"ticker\":{\"id\":\"2016\"}},\"id\":\"2015\",\"type\":\"LinearAxis\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"oi\":{\"__ndarray__\":\"AAAAIEangcAAAABAnLuMwAAAAOBAhZTAAAAAQCK2lMAAAACglJqewAAAAOB6cpLAAAAAQJtUocAAAABA4g2SwAAAAKAuapLAAAAAAOM/ocAAAADgenGhwAAAAEBDv5LAAAAA4Axgk8AAAABAq92gwAAAACD3yaDAAAAAQJnEocAAAACgeZ6TwAAAAOCYSKHAAAAAQESek8AAAACAkpOTwAAAAMC6PaHAAAAAQJVblMAAAAAA5imhwAAAAMC+NZTAAAAAAOYpocAAAAAgq9OTwAAAACBdk5PAAAAAYDMok8AAAADAr+agwAAAAACx/5LA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"2051\"},\"selection_policy\":{\"id\":\"2050\"}},\"id\":\"2037\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"2007\",\"type\":\"DataRange1d\"},{\"attributes\":{\"axis\":{\"id\":\"2015\"},\"ticker\":null},\"id\":\"2018\",\"type\":\"Grid\"},{\"attributes\":{\"axis\":{\"id\":\"2019\"},\"dimension\":1,\"ticker\":null},\"id\":\"2022\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2044\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2020\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"2024\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"2046\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"2023\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"2028\",\"type\":\"HelpTool\"},{\"attributes\":{\"overlay\":{\"id\":\"2029\"}},\"id\":\"2025\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"2026\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"2027\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"2047\",\"type\":\"BasicTickFormatter\"}],\"root_ids\":[\"2004\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"a849b193-df16-451c-a240-b08a2d5f7d6b\",\"root_ids\":[\"2004\"],\"roots\":{\"2004\":\"2b2070de-9130-4b44-8518-ee7fe71cdde3\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "2004"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"16e092da-dca4-4272-93e7-6935fc29877a\" data-root-id=\"2187\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"1da3a0bd-59d8-4a7b-a9bd-f40d18ad5c8a\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"2198\"}],\"center\":[{\"id\":\"2201\"},{\"id\":\"2205\"},{\"id\":\"2236\"}],\"height\":400,\"left\":[{\"id\":\"2202\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"2224\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"2188\"},\"toolbar\":{\"id\":\"2213\"},\"x_range\":{\"id\":\"2190\"},\"x_scale\":{\"id\":\"2194\"},\"y_range\":{\"id\":\"2192\"},\"y_scale\":{\"id\":\"2196\"}},\"id\":\"2187\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"source\":{\"id\":\"2220\"}},\"id\":\"2225\",\"type\":\"CDSView\"},{\"attributes\":{\"label\":{\"value\":\" oi_day_high\"},\"renderers\":[{\"id\":\"2224\"}]},\"id\":\"2237\",\"type\":\"LegendItem\"},{\"attributes\":{\"data_source\":{\"id\":\"2220\"},\"glyph\":{\"id\":\"2222\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"2223\"},\"view\":{\"id\":\"2225\"}},\"id\":\"2224\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"2196\",\"type\":\"LinearScale\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"2237\"}]},\"id\":\"2236\",\"type\":\"Legend\"},{\"attributes\":{\"formatter\":{\"id\":\"2230\"},\"major_label_policy\":{\"id\":\"2232\"},\"ticker\":{\"id\":\"2199\"}},\"id\":\"2198\",\"type\":\"LinearAxis\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"oi_day_high\":{\"__ndarray__\":\"AAAAgFDqYMAAAACAjzhGwAAAAKC2n7DAAAAA4PT8rMAAAACAlS+rwAAAAGDFdqvAAAAAoDxaqsAAAADA3KSqwAAAAGCeyKrAAAAAQL6RqsAAAAAAkayqwAAAAMDuvqrAAAAAgEfFqsAAAAAA4ZiqwAAAAACSjarAAAAAoHyAqsAAAADAwqKqwAAAACAFeqrAAAAAgMTBqsAAAADgzbGqwAAAAOAxh6rAAAAAAFWzqsAAAADgc2WqwAAAACC9parAAAAAIC5mqsAAAADAqsCqwAAAAIDOo6rAAAAAAPfjqsAAAABgZcWqwAAAAOCm5qrA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"2234\"},\"selection_policy\":{\"id\":\"2233\"}},\"id\":\"2220\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"oi_day_high\"}},\"id\":\"2222\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"2199\",\"type\":\"BasicTicker\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"2224\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"oi_day_high\",\"@{oi_day_high}\"]]},\"id\":\"2238\",\"type\":\"HoverTool\"},{\"attributes\":{},\"id\":\"2188\",\"type\":\"Title\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"2212\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"2194\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"2207\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"2233\",\"type\":\"UnionRenderers\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"2207\"},\"tools\":[{\"id\":\"2206\"},{\"id\":\"2207\"},{\"id\":\"2208\"},{\"id\":\"2209\"},{\"id\":\"2210\"},{\"id\":\"2211\"},{\"id\":\"2238\"}]},\"id\":\"2213\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"2234\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"2192\",\"type\":\"DataRange1d\"},{\"attributes\":{\"axis_label\":\"oi_day_high\",\"formatter\":{\"id\":\"2227\"},\"major_label_policy\":{\"id\":\"2229\"},\"ticker\":{\"id\":\"2203\"}},\"id\":\"2202\",\"type\":\"LinearAxis\"},{\"attributes\":{\"axis\":{\"id\":\"2202\"},\"dimension\":1,\"ticker\":null},\"id\":\"2205\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2203\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"2190\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"2227\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2211\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"2206\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"2229\",\"type\":\"AllLabels\"},{\"attributes\":{\"overlay\":{\"id\":\"2212\"}},\"id\":\"2208\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"2209\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"2210\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"2230\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"axis\":{\"id\":\"2198\"},\"ticker\":null},\"id\":\"2201\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2232\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"oi_day_high\"}},\"id\":\"2223\",\"type\":\"Line\"}],\"root_ids\":[\"2187\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"1da3a0bd-59d8-4a7b-a9bd-f40d18ad5c8a\",\"root_ids\":[\"2187\"],\"roots\":{\"2187\":\"16e092da-dca4-4272-93e7-6935fc29877a\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "2187"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"e2e921fa-1b2b-46e5-b995-a496c1af8a64\" data-root-id=\"2380\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"5c138860-c2a2-4bb5-90bd-432d7643fa45\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"2391\"}],\"center\":[{\"id\":\"2394\"},{\"id\":\"2398\"},{\"id\":\"2429\"}],\"height\":400,\"left\":[{\"id\":\"2395\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"2417\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"2381\"},\"toolbar\":{\"id\":\"2406\"},\"x_range\":{\"id\":\"2383\"},\"x_scale\":{\"id\":\"2387\"},\"y_range\":{\"id\":\"2385\"},\"y_scale\":{\"id\":\"2389\"}},\"id\":\"2380\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"oi_day_low\":{\"__ndarray__\":\"AAAAwBNnmMAAAADg6KmjQAAAAMAj48RAAAAAgGMDx0AAAABgmRfeQAAAACD1NsBAAAAAwJV900AAAACgNbzCwAAAAMBo75jAAAAAAMmw10AAAACAOA3cQAAAAKBJ7p5AAAAAwMdxZsAAAABAK0zaQAAAAAC+0dlAAAAAwKAR4EAAAABg4Eq2QAAAAABP2tpAAAAAAEs6vUAAAAAAERKyQAAAAKDEVd1AAAAAIGmNvEAAAABAGZ3eQAAAAKAR9rhAAAAAQBmd3kAAAACgRzi5QAAAAADwprJAAAAAoBVruUAAAACgqxvdQAAAAGCEeMBA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"2427\"},\"selection_policy\":{\"id\":\"2426\"}},\"id\":\"2413\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"2405\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"axis\":{\"id\":\"2391\"},\"ticker\":null},\"id\":\"2394\",\"type\":\"Grid\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"oi_day_low\"}},\"id\":\"2415\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"2387\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"2426\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"2383\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"2427\",\"type\":\"Selection\"},{\"attributes\":{\"formatter\":{\"id\":\"2423\"},\"major_label_policy\":{\"id\":\"2425\"},\"ticker\":{\"id\":\"2392\"}},\"id\":\"2391\",\"type\":\"LinearAxis\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"2400\"},\"tools\":[{\"id\":\"2399\"},{\"id\":\"2400\"},{\"id\":\"2401\"},{\"id\":\"2402\"},{\"id\":\"2403\"},{\"id\":\"2404\"},{\"id\":\"2431\"}]},\"id\":\"2406\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"2389\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"2400\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"axis_label\":\"oi_day_low\",\"formatter\":{\"id\":\"2420\"},\"major_label_policy\":{\"id\":\"2422\"},\"ticker\":{\"id\":\"2396\"}},\"id\":\"2395\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"2420\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2396\",\"type\":\"BasicTicker\"},{\"attributes\":{\"axis\":{\"id\":\"2395\"},\"dimension\":1,\"ticker\":null},\"id\":\"2398\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2422\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"2404\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"2399\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"2405\"}},\"id\":\"2401\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"2402\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"2403\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"2423\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2425\",\"type\":\"AllLabels\"},{\"attributes\":{\"source\":{\"id\":\"2413\"}},\"id\":\"2418\",\"type\":\"CDSView\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"oi_day_low\"}},\"id\":\"2416\",\"type\":\"Line\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"2417\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"oi_day_low\",\"@{oi_day_low}\"]]},\"id\":\"2431\",\"type\":\"HoverTool\"},{\"attributes\":{\"label\":{\"value\":\" oi_day_low\"},\"renderers\":[{\"id\":\"2417\"}]},\"id\":\"2430\",\"type\":\"LegendItem\"},{\"attributes\":{},\"id\":\"2381\",\"type\":\"Title\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"2430\"}]},\"id\":\"2429\",\"type\":\"Legend\"},{\"attributes\":{\"data_source\":{\"id\":\"2413\"},\"glyph\":{\"id\":\"2415\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"2416\"},\"view\":{\"id\":\"2418\"}},\"id\":\"2417\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"2392\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"2385\",\"type\":\"DataRange1d\"}],\"root_ids\":[\"2380\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"5c138860-c2a2-4bb5-90bd-432d7643fa45\",\"root_ids\":[\"2380\"],\"roots\":{\"2380\":\"e2e921fa-1b2b-46e5-b995-a496c1af8a64\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "2380"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"9f6106a9-1616-4537-a0df-3b44acb0377f\" data-root-id=\"2583\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"7d232c10-6f5c-421b-b7d8-eaff9f924b5a\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"2594\"}],\"center\":[{\"id\":\"2597\"},{\"id\":\"2601\"},{\"id\":\"2632\"}],\"height\":400,\"left\":[{\"id\":\"2598\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"2620\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"2584\"},\"toolbar\":{\"id\":\"2609\"},\"x_range\":{\"id\":\"2586\"},\"x_scale\":{\"id\":\"2590\"},\"y_range\":{\"id\":\"2588\"},\"y_scale\":{\"id\":\"2592\"}},\"id\":\"2583\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"2630\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"2599\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"2595\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"2592\",\"type\":\"LinearScale\"},{\"attributes\":{\"formatter\":{\"id\":\"2626\"},\"major_label_policy\":{\"id\":\"2628\"},\"ticker\":{\"id\":\"2595\"}},\"id\":\"2594\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"2590\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"2603\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"axis\":{\"id\":\"2598\"},\"dimension\":1,\"ticker\":null},\"id\":\"2601\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2623\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2607\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"2602\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"2625\",\"type\":\"AllLabels\"},{\"attributes\":{\"overlay\":{\"id\":\"2608\"}},\"id\":\"2604\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"2605\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"2606\",\"type\":\"ResetTool\"},{\"attributes\":{\"axis\":{\"id\":\"2594\"},\"ticker\":null},\"id\":\"2597\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2626\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2588\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"2628\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"open\"}},\"id\":\"2619\",\"type\":\"Line\"},{\"attributes\":{\"data_source\":{\"id\":\"2616\"},\"glyph\":{\"id\":\"2618\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"2619\"},\"view\":{\"id\":\"2621\"}},\"id\":\"2620\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"source\":{\"id\":\"2616\"}},\"id\":\"2621\",\"type\":\"CDSView\"},{\"attributes\":{},\"id\":\"2584\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"2586\",\"type\":\"DataRange1d\"},{\"attributes\":{\"label\":{\"value\":\" open\"},\"renderers\":[{\"id\":\"2620\"}]},\"id\":\"2633\",\"type\":\"LegendItem\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"open\":{\"__ndarray__\":\"AAAAwMpjoEAAAABATB2gQAAAAODMFqBAAAAAIJoloEAAAADgQcafQAAAAOAo959AAAAA4GzGn0AAAAAgoPmfQAAAACDd+59AAAAA4G28n0AAAABgAsGfQAAAAKCg959AAAAAIKT1n0AAAABgt7ufQAAAAGD4up9AAAAA4I3An0AAAADgkfqfQAAAAOBBu59AAAAAoOT6n0AAAADgLvWfQAAAAOBBu59AAAAAoJj1n0AAAADgQbufQAAAAGC89J9AAAAA4Fi7n0AAAABg9PqfQAAAAOA89Z9AAAAAIBb2n0AAAAAg2LyfQAAAAOAv959A\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"2630\"},\"selection_policy\":{\"id\":\"2629\"}},\"id\":\"2616\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"2633\"}]},\"id\":\"2632\",\"type\":\"Legend\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"open\"}},\"id\":\"2618\",\"type\":\"Line\"},{\"attributes\":{\"axis_label\":\"open\",\"formatter\":{\"id\":\"2623\"},\"major_label_policy\":{\"id\":\"2625\"},\"ticker\":{\"id\":\"2599\"}},\"id\":\"2598\",\"type\":\"LinearAxis\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"2620\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"open\",\"@{open}\"]]},\"id\":\"2634\",\"type\":\"HoverTool\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"2608\",\"type\":\"BoxAnnotation\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"2603\"},\"tools\":[{\"id\":\"2602\"},{\"id\":\"2603\"},{\"id\":\"2604\"},{\"id\":\"2605\"},{\"id\":\"2606\"},{\"id\":\"2607\"},{\"id\":\"2634\"}]},\"id\":\"2609\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"2629\",\"type\":\"UnionRenderers\"}],\"root_ids\":[\"2583\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"7d232c10-6f5c-421b-b7d8-eaff9f924b5a\",\"root_ids\":[\"2583\"],\"roots\":{\"2583\":\"9f6106a9-1616-4537-a0df-3b44acb0377f\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "2583"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"016c29cb-875d-4c11-81e1-931b3aa41b06\" data-root-id=\"2796\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"399a14fa-d976-4bb6-9765-2a51b2070e77\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"2807\"}],\"center\":[{\"id\":\"2810\"},{\"id\":\"2814\"},{\"id\":\"2845\"}],\"height\":400,\"left\":[{\"id\":\"2811\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"2833\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"2797\"},\"toolbar\":{\"id\":\"2822\"},\"x_range\":{\"id\":\"2799\"},\"x_scale\":{\"id\":\"2803\"},\"y_range\":{\"id\":\"2801\"},\"y_scale\":{\"id\":\"2805\"}},\"id\":\"2796\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"2836\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2815\",\"type\":\"PanTool\"},{\"attributes\":{},\"id\":\"2816\",\"type\":\"WheelZoomTool\"},{\"attributes\":{},\"id\":\"2820\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"2801\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"2838\",\"type\":\"AllLabels\"},{\"attributes\":{\"overlay\":{\"id\":\"2821\"}},\"id\":\"2817\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"2818\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"2819\",\"type\":\"ResetTool\"},{\"attributes\":{},\"id\":\"2839\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"2841\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"2797\",\"type\":\"Title\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"high\"}},\"id\":\"2832\",\"type\":\"Line\"},{\"attributes\":{},\"id\":\"2799\",\"type\":\"DataRange1d\"},{\"attributes\":{\"axis\":{\"id\":\"2807\"},\"ticker\":null},\"id\":\"2810\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2803\",\"type\":\"LinearScale\"},{\"attributes\":{\"label\":{\"value\":\" high\"},\"renderers\":[{\"id\":\"2833\"}]},\"id\":\"2846\",\"type\":\"LegendItem\"},{\"attributes\":{},\"id\":\"2805\",\"type\":\"LinearScale\"},{\"attributes\":{\"source\":{\"id\":\"2829\"}},\"id\":\"2834\",\"type\":\"CDSView\"},{\"attributes\":{\"data_source\":{\"id\":\"2829\"},\"glyph\":{\"id\":\"2831\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"2832\"},\"view\":{\"id\":\"2834\"}},\"id\":\"2833\",\"type\":\"GlyphRenderer\"},{\"attributes\":{\"formatter\":{\"id\":\"2839\"},\"major_label_policy\":{\"id\":\"2841\"},\"ticker\":{\"id\":\"2808\"}},\"id\":\"2807\",\"type\":\"LinearAxis\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"2846\"}]},\"id\":\"2845\",\"type\":\"Legend\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"high\":{\"__ndarray__\":\"AAAAoAJteEAAAABAUXyqwAAAAIDsfZDAAAAAQFcYtMAAAAAA1uZ3wAAAAGAl3bHAAAAAYGO8k8AAAABgLj6wwAAAAIDVJ7TAAAAAgHcylcAAAAAA4QKBwAAAAODzfqLAAAAAoG3stMAAAACAy5OYwAAAAIBqAJrAAAAAwIXggsAAAADAqfi1wAAAAMCpaYzAAAAA4MViq8AAAADgFhC3wAAAAGA0Y5HAAAAAYNV1t8AAAABgZC6TwAAAAACMtbbAAAAAwERCl8AAAAAgiR2wwAAAAGBVxLXAAAAAgHILtsAAAACA5dyewAAAAOBJsrrA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"2843\"},\"selection_policy\":{\"id\":\"2842\"}},\"id\":\"2829\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"high\"}},\"id\":\"2831\",\"type\":\"Line\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"2833\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"high\",\"@{high}\"]]},\"id\":\"2847\",\"type\":\"HoverTool\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"2821\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"2808\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"2842\",\"type\":\"UnionRenderers\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"2816\"},\"tools\":[{\"id\":\"2815\"},{\"id\":\"2816\"},{\"id\":\"2817\"},{\"id\":\"2818\"},{\"id\":\"2819\"},{\"id\":\"2820\"},{\"id\":\"2847\"}]},\"id\":\"2822\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"2843\",\"type\":\"Selection\"},{\"attributes\":{\"axis_label\":\"high\",\"formatter\":{\"id\":\"2836\"},\"major_label_policy\":{\"id\":\"2838\"},\"ticker\":{\"id\":\"2812\"}},\"id\":\"2811\",\"type\":\"LinearAxis\"},{\"attributes\":{\"axis\":{\"id\":\"2811\"},\"dimension\":1,\"ticker\":null},\"id\":\"2814\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"2812\",\"type\":\"BasicTicker\"}],\"root_ids\":[\"2796\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"399a14fa-d976-4bb6-9765-2a51b2070e77\",\"root_ids\":[\"2796\"],\"roots\":{\"2796\":\"016c29cb-875d-4c11-81e1-931b3aa41b06\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "2796"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"1f9610c3-7bb0-4d8b-a566-3ad90db58304\" data-root-id=\"3019\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"98fbc4c1-4280-4094-898d-95514473d4bc\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"3030\"}],\"center\":[{\"id\":\"3033\"},{\"id\":\"3037\"},{\"id\":\"3068\"}],\"height\":400,\"left\":[{\"id\":\"3034\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"3056\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"3020\"},\"toolbar\":{\"id\":\"3045\"},\"x_range\":{\"id\":\"3022\"},\"x_scale\":{\"id\":\"3026\"},\"y_range\":{\"id\":\"3024\"},\"y_scale\":{\"id\":\"3028\"}},\"id\":\"3019\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"3062\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"3064\",\"type\":\"AllLabels\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"low\"}},\"id\":\"3055\",\"type\":\"Line\"},{\"attributes\":{\"label\":{\"value\":\" low\"},\"renderers\":[{\"id\":\"3056\"}]},\"id\":\"3069\",\"type\":\"LegendItem\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"3069\"}]},\"id\":\"3068\",\"type\":\"Legend\"},{\"attributes\":{},\"id\":\"3024\",\"type\":\"DataRange1d\"},{\"attributes\":{\"axis\":{\"id\":\"3030\"},\"ticker\":null},\"id\":\"3033\",\"type\":\"Grid\"},{\"attributes\":{\"source\":{\"id\":\"3052\"}},\"id\":\"3057\",\"type\":\"CDSView\"},{\"attributes\":{\"axis_label\":\"low\",\"formatter\":{\"id\":\"3059\"},\"major_label_policy\":{\"id\":\"3061\"},\"ticker\":{\"id\":\"3035\"}},\"id\":\"3034\",\"type\":\"LinearAxis\"},{\"attributes\":{\"formatter\":{\"id\":\"3062\"},\"major_label_policy\":{\"id\":\"3064\"},\"ticker\":{\"id\":\"3031\"}},\"id\":\"3030\",\"type\":\"LinearAxis\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"3056\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"low\",\"@{low}\"]]},\"id\":\"3070\",\"type\":\"HoverTool\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"low\":{\"__ndarray__\":\"AAAAAKowPkAAAAAgGJBwQAAAAECfyGbAAAAAoC0xYcAAAACAFTBqwAAAAKBxY2vAAAAAgAndZMAAAADAFBJywAAAAMAWbXDAAAAAgFE8Y8AAAACAaY9jwAAAAKCVLG3AAAAAoDXebcAAAACA5TZkwAAAAIBBbGDAAAAAgDEdZMAAAACg1ShrwAAAAIA9dWTAAAAAoJlSbMAAAACgTR5pwAAAAOBSmV3AAAAAoJUfa8AAAACAbRFiwAAAAKDBeWTAAAAAgI32YcAAAACgdcNkwAAAAKBNvG3AAAAAoM2IacAAAACAK808wAAAAKAVv2nA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"3066\"},\"selection_policy\":{\"id\":\"3065\"}},\"id\":\"3052\",\"type\":\"ColumnDataSource\"},{\"attributes\":{},\"id\":\"3026\",\"type\":\"LinearScale\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"low\"}},\"id\":\"3054\",\"type\":\"Line\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"3044\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"3020\",\"type\":\"Title\"},{\"attributes\":{},\"id\":\"3065\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"3066\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"3028\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"3031\",\"type\":\"BasicTicker\"},{\"attributes\":{},\"id\":\"3035\",\"type\":\"BasicTicker\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"3039\"},\"tools\":[{\"id\":\"3038\"},{\"id\":\"3039\"},{\"id\":\"3040\"},{\"id\":\"3041\"},{\"id\":\"3042\"},{\"id\":\"3043\"},{\"id\":\"3070\"}]},\"id\":\"3045\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"3059\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"3039\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"axis\":{\"id\":\"3034\"},\"dimension\":1,\"ticker\":null},\"id\":\"3037\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"3061\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"3043\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"3038\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"3044\"}},\"id\":\"3040\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"3041\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"3022\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"3042\",\"type\":\"ResetTool\"},{\"attributes\":{\"data_source\":{\"id\":\"3052\"},\"glyph\":{\"id\":\"3054\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"3055\"},\"view\":{\"id\":\"3057\"}},\"id\":\"3056\",\"type\":\"GlyphRenderer\"}],\"root_ids\":[\"3019\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"98fbc4c1-4280-4094-898d-95514473d4bc\",\"root_ids\":[\"3019\"],\"roots\":{\"3019\":\"1f9610c3-7bb0-4d8b-a566-3ad90db58304\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "3019"
      }
     },
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "\n",
       "  <div class=\"bk-root\" id=\"5a7c7b9c-c3b3-4877-80a3-23aaaed291ec\" data-root-id=\"3252\"></div>\n"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/javascript": [
       "(function(root) {\n",
       "  function embed_document(root) {\n",
       "    \n",
       "  var docs_json = {\"9a200913-3eea-42bf-9509-b5d4c723a1ae\":{\"defs\":[],\"roots\":{\"references\":[{\"attributes\":{\"below\":[{\"id\":\"3263\"}],\"center\":[{\"id\":\"3266\"},{\"id\":\"3270\"},{\"id\":\"3301\"}],\"height\":400,\"left\":[{\"id\":\"3267\"}],\"output_backend\":\"webgl\",\"renderers\":[{\"id\":\"3289\"}],\"sizing_mode\":\"fixed\",\"title\":{\"id\":\"3253\"},\"toolbar\":{\"id\":\"3278\"},\"x_range\":{\"id\":\"3255\"},\"x_scale\":{\"id\":\"3259\"},\"y_range\":{\"id\":\"3257\"},\"y_scale\":{\"id\":\"3261\"}},\"id\":\"3252\",\"subtype\":\"Figure\",\"type\":\"Plot\"},{\"attributes\":{},\"id\":\"3264\",\"type\":\"BasicTicker\"},{\"attributes\":{\"line_alpha\":0.1,\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"close\"}},\"id\":\"3288\",\"type\":\"Line\"},{\"attributes\":{\"label\":{\"value\":\" close\"},\"renderers\":[{\"id\":\"3289\"}]},\"id\":\"3302\",\"type\":\"LegendItem\"},{\"attributes\":{\"click_policy\":\"hide\",\"items\":[{\"id\":\"3302\"}]},\"id\":\"3301\",\"type\":\"Legend\"},{\"attributes\":{\"source\":{\"id\":\"3285\"}},\"id\":\"3290\",\"type\":\"CDSView\"},{\"attributes\":{\"axis\":{\"id\":\"3263\"},\"ticker\":null},\"id\":\"3266\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"3257\",\"type\":\"DataRange1d\"},{\"attributes\":{},\"id\":\"3255\",\"type\":\"DataRange1d\"},{\"attributes\":{\"callback\":null,\"mode\":\"vline\",\"renderers\":[{\"id\":\"3289\"}],\"tooltips\":[[\"x\",\"@__x__values_original\"],[\"close\",\"@{close}\"]]},\"id\":\"3303\",\"type\":\"HoverTool\"},{\"attributes\":{\"data\":{\"__x__values\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"__x__values_original\":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29],\"close\":{\"__ndarray__\":\"AAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dAAAAAoNRbd0AAAACg1Ft3QAAAAKDUW3dA\",\"dtype\":\"float64\",\"order\":\"little\",\"shape\":[30]}},\"selected\":{\"id\":\"3299\"},\"selection_policy\":{\"id\":\"3298\"}},\"id\":\"3285\",\"type\":\"ColumnDataSource\"},{\"attributes\":{\"line_color\":\"#1f77b4\",\"line_width\":2,\"x\":{\"field\":\"__x__values\"},\"y\":{\"field\":\"close\"}},\"id\":\"3287\",\"type\":\"Line\"},{\"attributes\":{\"bottom_units\":\"screen\",\"fill_alpha\":0.5,\"fill_color\":\"lightgrey\",\"left_units\":\"screen\",\"level\":\"overlay\",\"line_alpha\":1.0,\"line_color\":\"black\",\"line_dash\":[4,4],\"line_width\":2,\"right_units\":\"screen\",\"syncable\":false,\"top_units\":\"screen\"},\"id\":\"3277\",\"type\":\"BoxAnnotation\"},{\"attributes\":{},\"id\":\"3298\",\"type\":\"UnionRenderers\"},{\"attributes\":{},\"id\":\"3299\",\"type\":\"Selection\"},{\"attributes\":{},\"id\":\"3272\",\"type\":\"WheelZoomTool\"},{\"attributes\":{\"axis\":{\"id\":\"3267\"},\"dimension\":1,\"ticker\":null},\"id\":\"3270\",\"type\":\"Grid\"},{\"attributes\":{},\"id\":\"3292\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{\"axis_label\":\"close\",\"formatter\":{\"id\":\"3292\"},\"major_label_policy\":{\"id\":\"3294\"},\"ticker\":{\"id\":\"3268\"}},\"id\":\"3267\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"3268\",\"type\":\"BasicTicker\"},{\"attributes\":{\"active_multi\":null,\"active_scroll\":{\"id\":\"3272\"},\"tools\":[{\"id\":\"3271\"},{\"id\":\"3272\"},{\"id\":\"3273\"},{\"id\":\"3274\"},{\"id\":\"3275\"},{\"id\":\"3276\"},{\"id\":\"3303\"}]},\"id\":\"3278\",\"type\":\"Toolbar\"},{\"attributes\":{},\"id\":\"3294\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"3276\",\"type\":\"HelpTool\"},{\"attributes\":{},\"id\":\"3271\",\"type\":\"PanTool\"},{\"attributes\":{\"overlay\":{\"id\":\"3277\"}},\"id\":\"3273\",\"type\":\"BoxZoomTool\"},{\"attributes\":{},\"id\":\"3274\",\"type\":\"SaveTool\"},{\"attributes\":{},\"id\":\"3275\",\"type\":\"ResetTool\"},{\"attributes\":{\"data_source\":{\"id\":\"3285\"},\"glyph\":{\"id\":\"3287\"},\"hover_glyph\":null,\"muted_glyph\":null,\"nonselection_glyph\":{\"id\":\"3288\"},\"view\":{\"id\":\"3290\"}},\"id\":\"3289\",\"type\":\"GlyphRenderer\"},{\"attributes\":{},\"id\":\"3295\",\"type\":\"BasicTickFormatter\"},{\"attributes\":{},\"id\":\"3297\",\"type\":\"AllLabels\"},{\"attributes\":{},\"id\":\"3261\",\"type\":\"LinearScale\"},{\"attributes\":{\"formatter\":{\"id\":\"3295\"},\"major_label_policy\":{\"id\":\"3297\"},\"ticker\":{\"id\":\"3264\"}},\"id\":\"3263\",\"type\":\"LinearAxis\"},{\"attributes\":{},\"id\":\"3259\",\"type\":\"LinearScale\"},{\"attributes\":{},\"id\":\"3253\",\"type\":\"Title\"}],\"root_ids\":[\"3252\"]},\"title\":\"Bokeh Application\",\"version\":\"2.3.1\"}};\n",
       "  var render_items = [{\"docid\":\"9a200913-3eea-42bf-9509-b5d4c723a1ae\",\"root_ids\":[\"3252\"],\"roots\":{\"3252\":\"5a7c7b9c-c3b3-4877-80a3-23aaaed291ec\"}}];\n",
       "  root.Bokeh.embed.embed_items_notebook(docs_json, render_items);\n",
       "\n",
       "  }\n",
       "  if (root.Bokeh !== undefined) {\n",
       "    embed_document(root);\n",
       "  } else {\n",
       "    var attempts = 0;\n",
       "    var timer = setInterval(function(root) {\n",
       "      if (root.Bokeh !== undefined) {\n",
       "        clearInterval(timer);\n",
       "        embed_document(root);\n",
       "      } else {\n",
       "        attempts++;\n",
       "        if (attempts > 100) {\n",
       "          clearInterval(timer);\n",
       "          console.log(\"Bokeh: ERROR: Unable to run BokehJS code because BokehJS library is missing\");\n",
       "        }\n",
       "      }\n",
       "    }, 10, root)\n",
       "  }\n",
       "})(window);"
      ],
      "application/vnd.bokehjs_exec.v0+json": ""
     },
     "metadata": {
      "application/vnd.bokehjs_exec.v0+json": {
       "id": "3252"
      }
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "for one_key in x.keys():\n",
    "    plt = all_future_df[one_key].plot()\n",
    "#     plt.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b284c84c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a59434df",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "hide_input": false,
  "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.9.4"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}