python-dashboards.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Data dashboards with Python\n",
    "\n",
    "### What are dashboards?\n",
    "\n",
    "Dashboards are used to summarise data. Often this means different, but related datasets visualised together.\n",
    "\n",
    "They can also be interactive (making them simple apps!), and focus on making related information easy to understand. Ideally, they answer a single clear question (of any scope).\n",
    "\n",
    "Dashboard skills are often asked for in job adverts - since they are great for summarising technical data to non-technical colleagues.\n",
    "\n",
    "However, they can have utility in any setting where you work with data.\n",
    "\n",
    "### Popular dashboard software\n",
    "\n",
    "- Tableau (owned by Salesforce). This costs money beyond the free trial, and if you use the free version (Tableau public), your projects will be publically available.\n",
    "- Microsoft Power BI. 1GB free data analysis per user, else 10 dollars a month.\n",
    "- And a whole load more that cost a bunch. Why? Because Dashboards are used a lot in businesses to communicate data to other team members.\n",
    "\n",
    "### The Dash package for Python\n",
    "\n",
    "- **Dash** is a free and open source dashboard package for Python, though there is an enterprise version. \n",
    "- Dash open source: pure python, you and your laptop. You'd need javascript front-end coding knowledge to customise beyond the basics.\n",
    "- Dash enterprise: more libraries, customer support, front-end customisability, drag and drop, etc.\n",
    "- Dash is built by Plotly. Plotly is a company, also the name of their graphing package/library for Python.\n",
    "- Both Dash and plotly.py run on plotly.js, a JavaScript charting library.\n",
    "- Plotly.py is an interactive, high-level library with capability to make many charts, these can be integrated into Dash apps/Jupyter/HTML etc.\n",
    "- Dash is built on Plotly.js (charts and graphics), React (javascript library to build interactive user interfaces), and Flask (lightweight web app framework - gives web-browser functionality)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Example 1: Hello world with Dash, following LinkedIn Learning\n",
    "\n",
    "import dash\n",
    "from dash import html\n",
    "\n",
    "# Constructor\n",
    "app = dash.Dash(__name__)\n",
    "\n",
    "\"\"\"\n",
    "Layout below: describes what a dash app will look like.\n",
    "It's a heirarchical tree of components.\n",
    "With the html dash library we can directly create html objects by their 'tags'.\n",
    "We create a paragraph object with the P tag, rendered as a paragraph by dash.\n",
    "For all the Dash HTML components:\n",
    "https://dash.plotly.com/dash-html-components\n",
    "\n",
    "Also dash core components for graphs, drop down menus, etc. (dcc)\n",
    "https://dash.plotly.com/dash-core-components\n",
    "\"\"\"\n",
    "\n",
    "app.layout = html.P(\"Hello world\")\n",
    "\n",
    "# Debugging - gives access to 'hot reloading' (real time reloading)\n",
    "if __name__ == \"__main__\":\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Example 2: plotting gold prices\n",
    "\n",
    "import dash\n",
    "from dash import html\n",
    "# Here we import dcc (dash core components - we only use it for the graph)\n",
    "from dash import dcc\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "\n",
    "# Data import, only 2 of the columns\n",
    "metal_prices = pd.read_csv('data/precious_metals_prices_2018_2021.csv', usecols=[\"DateTime\",\"Gold\"])\n",
    "\n",
    "# We'll use plotly express to generate the graphic (a quick visualising package - with reasonable defaults)\n",
    "figure1 = px.line(metal_prices, x = \"DateTime\", y = \"Gold\", title = \"Precious metal prices 2018-2021\")\n",
    "\n",
    "app = dash.Dash(__name__)\n",
    "app.title = \"Precious metal prices 2018-2021\"\n",
    "\n",
    "# Div tag = html division or section\n",
    "app.layout = html.Div(\n",
    "    id=\"app-container\",\n",
    "    children=[\n",
    "        html.H1(\"Precious metal prices 2018-2021\"),\n",
    "        html.P(\"Results in USD/oz\"),\n",
    "        dcc.Graph(figure=figure1)]\n",
    ")\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Templates configuration\n",
      "-----------------------\n",
      "    Default template: 'plotly'\n",
      "    Available templates:\n",
      "        ['ggplot2', 'seaborn', 'simple_white', 'plotly',\n",
      "         'plotly_white', 'plotly_dark', 'presentation', 'xgridoff',\n",
      "         'ygridoff', 'gridon', 'none']\n",
      "\n"
     ]
    },
    {
     "data": {
      "application/vnd.plotly.v1+json": {
       "config": {
        "plotlyServerURL": "https://plot.ly"
       },
       "data": [
        {
         "hovertemplate": "DateTime=%{x}<br>Gold=%{y}<extra></extra>",
         "legendgroup": "",
         "line": {
          "color": "#636efa",
          "dash": "solid"
         },
         "marker": {
          "symbol": "circle"
         },
         "mode": "lines",
         "name": "",
         "orientation": "v",
         "showlegend": false,
         "type": "scatter",
         "x": [
          "2018-01-02 00:00:00",
          "2018-01-03 00:00:00",
          "2018-01-04 00:00:00",
          "2018-01-05 00:00:00",
          "2018-01-08 00:00:00",
          "2018-01-09 00:00:00",
          "2018-01-10 00:00:00",
          "2018-01-11 00:00:00",
          "2018-01-12 00:00:00",
          "2018-01-15 00:00:00",
          "2018-01-16 00:00:00",
          "2018-01-17 00:00:00",
          "2018-01-18 00:00:00",
          "2018-01-19 00:00:00",
          "2018-01-22 00:00:00",
          "2018-01-23 00:00:00",
          "2018-01-24 00:00:00",
          "2018-01-25 00:00:00",
          "2018-01-26 00:00:00",
          "2018-01-29 00:00:00",
          "2018-01-30 00:00:00",
          "2018-01-31 00:00:00",
          "2018-02-01 00:00:00",
          "2018-02-02 00:00:00",
          "2018-02-05 00:00:00",
          "2018-02-06 00:00:00",
          "2018-02-07 00:00:00",
          "2018-02-08 00:00:00",
          "2018-02-09 00:00:00",
          "2018-02-12 00:00:00",
          "2018-02-13 00:00:00",
          "2018-02-14 00:00:00",
          "2018-02-15 00:00:00",
          "2018-02-16 00:00:00",
          "2018-02-19 00:00:00",
          "2018-02-20 00:00:00",
          "2018-02-21 00:00:00",
          "2018-02-22 00:00:00",
          "2018-02-23 00:00:00",
          "2018-02-26 00:00:00",
          "2018-02-27 00:00:00",
          "2018-02-28 00:00:00",
          "2018-03-01 00:00:00",
          "2018-03-02 00:00:00",
          "2018-03-05 00:00:00",
          "2018-03-06 00:00:00",
          "2018-03-07 00:00:00",
          "2018-03-08 00:00:00",
          "2018-03-09 00:00:00",
          "2018-03-12 00:00:00",
          "2018-03-13 00:00:00",
          "2018-03-14 00:00:00",
          "2018-03-15 00:00:00",
          "2018-03-16 00:00:00",
          "2018-03-19 00:00:00",
          "2018-03-20 00:00:00",
          "2018-03-21 00:00:00",
          "2018-03-22 00:00:00",
          "2018-03-23 00:00:00",
          "2018-03-26 00:00:00",
          "2018-03-27 00:00:00",
          "2018-03-28 00:00:00",
          "2018-03-29 00:00:00",
          "2018-04-03 00:00:00",
          "2018-04-04 00:00:00",
          "2018-04-05 00:00:00",
          "2018-04-06 00:00:00",
          "2018-04-09 00:00:00",
          "2018-04-10 00:00:00",
          "2018-04-11 00:00:00",
          "2018-04-12 00:00:00",
          "2018-04-13 00:00:00",
          "2018-04-16 00:00:00",
          "2018-04-17 00:00:00",
          "2018-04-18 00:00:00",
          "2018-04-19 00:00:00",
          "2018-04-20 00:00:00",
          "2018-04-23 00:00:00",
          "2018-04-24 00:00:00",
          "2018-04-25 00:00:00",
          "2018-04-26 00:00:00",
          "2018-04-27 00:00:00",
          "2018-04-30 00:00:00",
          "2018-05-02 00:00:00",
          "2018-05-03 00:00:00",
          "2018-05-04 00:00:00",
          "2018-05-07 00:00:00",
          "2018-05-08 00:00:00",
          "2018-05-09 00:00:00",
          "2018-05-11 00:00:00",
          "2018-05-14 00:00:00",
          "2018-05-15 00:00:00",
          "2018-05-16 00:00:00",
          "2018-05-17 00:00:00",
          "2018-05-18 00:00:00",
          "2018-05-22 00:00:00",
          "2018-05-23 00:00:00",
          "2018-05-24 00:00:00",
          "2018-05-25 00:00:00",
          "2018-05-28 00:00:00",
          "2018-05-29 00:00:00",
          "2018-05-30 00:00:00",
          "2018-06-01 00:00:00",
          "2018-06-04 00:00:00",
          "2018-06-05 00:00:00",
          "2018-06-06 00:00:00",
          "2018-06-07 00:00:00",
          "2018-06-08 00:00:00",
          "2018-06-11 00:00:00",
          "2018-06-12 00:00:00",
          "2018-06-13 00:00:00",
          "2018-06-14 00:00:00",
          "2018-06-15 00:00:00",
          "2018-06-18 00:00:00",
          "2018-06-19 00:00:00",
          "2018-06-20 00:00:00",
          "2018-06-21 00:00:00",
          "2018-06-22 00:00:00",
          "2018-06-25 00:00:00",
          "2018-06-26 00:00:00",
          "2018-06-27 00:00:00",
          "2018-06-28 00:00:00",
          "2018-06-29 00:00:00",
          "2018-07-02 00:00:00",
          "2018-07-03 00:00:00",
          "2018-07-04 00:00:00",
          "2018-07-05 00:00:00",
          "2018-07-06 00:00:00",
          "2018-07-09 00:00:00",
          "2018-07-10 00:00:00",
          "2018-07-11 00:00:00",
          "2018-07-12 00:00:00",
          "2018-07-13 00:00:00",
          "2018-07-16 00:00:00",
          "2018-07-17 00:00:00",
          "2018-07-18 00:00:00",
          "2018-07-19 00:00:00",
          "2018-07-20 00:00:00",
          "2018-07-23 00:00:00",
          "2018-07-24 00:00:00",
          "2018-07-25 00:00:00",
          "2018-07-26 00:00:00",
          "2018-07-27 00:00:00",
          "2018-07-30 00:00:00",
          "2018-07-31 00:00:00",
          "2018-08-01 00:00:00",
          "2018-08-02 00:00:00",
          "2018-08-03 00:00:00",
          "2018-08-06 00:00:00",
          "2018-08-07 00:00:00",
          "2018-08-08 00:00:00",
          "2018-08-09 00:00:00",
          "2018-08-10 00:00:00",
          "2018-08-13 00:00:00",
          "2018-08-14 00:00:00",
          "2018-08-15 00:00:00",
          "2018-08-16 00:00:00",
          "2018-08-17 00:00:00",
          "2018-08-20 00:00:00",
          "2018-08-21 00:00:00",
          "2018-08-22 00:00:00",
          "2018-08-23 00:00:00",
          "2018-08-24 00:00:00",
          "2018-08-27 00:00:00",
          "2018-08-28 00:00:00",
          "2018-08-29 00:00:00",
          "2018-08-30 00:00:00",
          "2018-08-31 00:00:00",
          "2018-09-03 00:00:00",
          "2018-09-04 00:00:00",
          "2018-09-05 00:00:00",
          "2018-09-06 00:00:00",
          "2018-09-07 00:00:00",
          "2018-09-10 00:00:00",
          "2018-09-11 00:00:00",
          "2018-09-12 00:00:00",
          "2018-09-13 00:00:00",
          "2018-09-14 00:00:00",
          "2018-09-17 00:00:00",
          "2018-09-18 00:00:00",
          "2018-09-19 00:00:00",
          "2018-09-20 00:00:00",
          "2018-09-21 00:00:00",
          "2018-09-24 00:00:00",
          "2018-09-25 00:00:00",
          "2018-09-26 00:00:00",
          "2018-09-27 00:00:00",
          "2018-09-28 00:00:00",
          "2018-10-01 00:00:00",
          "2018-10-02 00:00:00",
          "2018-10-04 00:00:00",
          "2018-10-05 00:00:00",
          "2018-10-08 00:00:00",
          "2018-10-09 00:00:00",
          "2018-10-10 00:00:00",
          "2018-10-11 00:00:00",
          "2018-10-12 00:00:00",
          "2018-10-15 00:00:00",
          "2018-10-16 00:00:00",
          "2018-10-17 00:00:00",
          "2018-10-18 00:00:00",
          "2018-10-19 00:00:00",
          "2018-10-22 00:00:00",
          "2018-10-23 00:00:00",
          "2018-10-24 00:00:00",
          "2018-10-25 00:00:00",
          "2018-10-26 00:00:00",
          "2018-10-29 00:00:00",
          "2018-10-30 00:00:00",
          "2018-10-31 00:00:00",
          "2018-11-01 00:00:00",
          "2018-11-02 00:00:00",
          "2018-11-05 00:00:00",
          "2018-11-06 00:00:00",
          "2018-11-07 00:00:00",
          "2018-11-08 00:00:00",
          "2018-11-09 00:00:00",
          "2018-11-12 00:00:00",
          "2018-11-13 00:00:00",
          "2018-11-14 00:00:00",
          "2018-11-15 00:00:00",
          "2018-11-16 00:00:00",
          "2018-11-19 00:00:00",
          "2018-11-20 00:00:00",
          "2018-11-21 00:00:00",
          "2018-11-22 00:00:00",
          "2018-11-23 00:00:00",
          "2018-11-26 00:00:00",
          "2018-11-27 00:00:00",
          "2018-11-28 00:00:00",
          "2018-11-29 00:00:00",
          "2018-11-30 00:00:00",
          "2018-12-03 00:00:00",
          "2018-12-04 00:00:00",
          "2018-12-05 00:00:00",
          "2018-12-06 00:00:00",
          "2018-12-07 00:00:00",
          "2018-12-10 00:00:00",
          "2018-12-11 00:00:00",
          "2018-12-12 00:00:00",
          "2018-12-13 00:00:00",
          "2018-12-14 00:00:00",
          "2018-12-17 00:00:00",
          "2018-12-18 00:00:00",
          "2018-12-19 00:00:00",
          "2018-12-20 00:00:00",
          "2018-12-21 00:00:00",
          "2018-12-27 00:00:00",
          "2018-12-28 00:00:00",
          "2019-01-02 00:00:00",
          "2019-01-03 00:00:00",
          "2019-01-04 00:00:00",
          "2019-01-07 00:00:00",
          "2019-01-08 00:00:00",
          "2019-01-09 00:00:00",
          "2019-01-10 00:00:00",
          "2019-01-11 00:00:00",
          "2019-01-14 00:00:00",
          "2019-01-15 00:00:00",
          "2019-01-16 00:00:00",
          "2019-01-17 00:00:00",
          "2019-01-18 00:00:00",
          "2019-01-21 00:00:00",
          "2019-01-22 00:00:00",
          "2019-01-23 00:00:00",
          "2019-01-24 00:00:00",
          "2019-01-25 00:00:00",
          "2019-01-28 00:00:00",
          "2019-01-29 00:00:00",
          "2019-01-30 00:00:00",
          "2019-01-31 00:00:00",
          "2019-02-01 00:00:00",
          "2019-02-04 00:00:00",
          "2019-02-05 00:00:00",
          "2019-02-06 00:00:00",
          "2019-02-07 00:00:00",
          "2019-02-08 00:00:00",
          "2019-02-11 00:00:00",
          "2019-02-12 00:00:00",
          "2019-02-13 00:00:00",
          "2019-02-14 00:00:00",
          "2019-02-15 00:00:00",
          "2019-02-18 00:00:00",
          "2019-02-19 00:00:00",
          "2019-02-20 00:00:00",
          "2019-02-21 00:00:00",
          "2019-02-22 00:00:00",
          "2019-02-25 00:00:00",
          "2019-02-26 00:00:00",
          "2019-02-27 00:00:00",
          "2019-02-28 00:00:00",
          "2019-03-01 00:00:00",
          "2019-03-04 00:00:00",
          "2019-03-05 00:00:00",
          "2019-03-06 00:00:00",
          "2019-03-07 00:00:00",
          "2019-03-08 00:00:00",
          "2019-03-11 00:00:00",
          "2019-03-12 00:00:00",
          "2019-03-13 00:00:00",
          "2019-03-14 00:00:00",
          "2019-03-15 00:00:00",
          "2019-03-18 00:00:00",
          "2019-03-19 00:00:00",
          "2019-03-20 00:00:00",
          "2019-03-21 00:00:00",
          "2019-03-22 00:00:00",
          "2019-03-25 00:00:00",
          "2019-03-26 00:00:00",
          "2019-03-27 00:00:00",
          "2019-03-28 00:00:00",
          "2019-03-29 00:00:00",
          "2019-04-01 00:00:00",
          "2019-04-02 00:00:00",
          "2019-04-03 00:00:00",
          "2019-04-04 00:00:00",
          "2019-04-05 00:00:00",
          "2019-04-08 00:00:00",
          "2019-04-09 00:00:00",
          "2019-04-10 00:00:00",
          "2019-04-11 00:00:00",
          "2019-04-12 00:00:00",
          "2019-04-15 00:00:00",
          "2019-04-16 00:00:00",
          "2019-04-17 00:00:00",
          "2019-04-18 00:00:00",
          "2019-04-23 00:00:00",
          "2019-04-24 00:00:00",
          "2019-04-25 00:00:00",
          "2019-04-26 00:00:00",
          "2019-04-29 00:00:00",
          "2019-04-30 00:00:00",
          "2019-05-02 00:00:00",
          "2019-05-03 00:00:00",
          "2019-05-06 00:00:00",
          "2019-05-07 00:00:00",
          "2019-05-08 00:00:00",
          "2019-05-09 00:00:00",
          "2019-05-10 00:00:00",
          "2019-05-13 00:00:00",
          "2019-05-14 00:00:00",
          "2019-05-15 00:00:00",
          "2019-05-16 00:00:00",
          "2019-05-17 00:00:00",
          "2019-05-20 00:00:00",
          "2019-05-21 00:00:00",
          "2019-05-22 00:00:00",
          "2019-05-23 00:00:00",
          "2019-05-24 00:00:00",
          "2019-05-27 00:00:00",
          "2019-05-28 00:00:00",
          "2019-05-29 00:00:00",
          "2019-05-31 00:00:00",
          "2019-06-03 00:00:00",
          "2019-06-04 00:00:00",
          "2019-06-05 00:00:00",
          "2019-06-06 00:00:00",
          "2019-06-07 00:00:00",
          "2019-06-11 00:00:00",
          "2019-06-12 00:00:00",
          "2019-06-13 00:00:00",
          "2019-06-14 00:00:00",
          "2019-06-17 00:00:00",
          "2019-06-18 00:00:00",
          "2019-06-19 00:00:00",
          "2019-06-21 00:00:00",
          "2019-06-24 00:00:00",
          "2019-06-25 00:00:00",
          "2019-06-26 00:00:00",
          "2019-06-27 00:00:00",
          "2019-06-28 00:00:00",
          "2019-07-01 00:00:00",
          "2019-07-02 00:00:00",
          "2019-07-03 00:00:00",
          "2019-07-04 00:00:00",
          "2019-07-05 00:00:00",
          "2019-07-08 00:00:00",
          "2019-07-09 00:00:00",
          "2019-07-10 00:00:00",
          "2019-07-11 00:00:00",
          "2019-07-12 00:00:00",
          "2019-07-15 00:00:00",
          "2019-07-16 00:00:00",
          "2019-07-17 00:00:00",
          "2019-07-18 00:00:00",
          "2019-07-19 00:00:00",
          "2019-07-22 00:00:00",
          "2019-07-23 00:00:00",
          "2019-07-24 00:00:00",
          "2019-07-25 00:00:00",
          "2019-07-26 00:00:00",
          "2019-07-29 00:00:00",
          "2019-07-30 00:00:00",
          "2019-07-31 00:00:00",
          "2019-08-01 00:00:00",
          "2019-08-02 00:00:00",
          "2019-08-05 00:00:00",
          "2019-08-06 00:00:00",
          "2019-08-07 00:00:00",
          "2019-08-08 00:00:00",
          "2019-08-09 00:00:00",
          "2019-08-12 00:00:00",
          "2019-08-13 00:00:00",
          "2019-08-14 00:00:00",
          "2019-08-15 00:00:00",
          "2019-08-16 00:00:00",
          "2019-08-19 00:00:00",
          "2019-08-20 00:00:00",
          "2019-08-21 00:00:00",
          "2019-08-22 00:00:00",
          "2019-08-23 00:00:00",
          "2019-08-26 00:00:00",
          "2019-08-27 00:00:00",
          "2019-08-28 00:00:00",
          "2019-08-29 00:00:00",
          "2019-08-30 00:00:00",
          "2019-09-02 00:00:00",
          "2019-09-03 00:00:00",
          "2019-09-04 00:00:00",
          "2019-09-05 00:00:00",
          "2019-09-06 00:00:00",
          "2019-09-09 00:00:00",
          "2019-09-10 00:00:00",
          "2019-09-11 00:00:00",
          "2019-09-12 00:00:00",
          "2019-09-13 00:00:00",
          "2019-09-16 00:00:00",
          "2019-09-17 00:00:00",
          "2019-09-18 00:00:00",
          "2019-09-19 00:00:00",
          "2019-09-20 00:00:00",
          "2019-09-23 00:00:00",
          "2019-09-24 00:00:00",
          "2019-09-25 00:00:00",
          "2019-09-26 00:00:00",
          "2019-09-27 00:00:00",
          "2019-09-30 00:00:00",
          "2019-10-01 00:00:00",
          "2019-10-02 00:00:00",
          "2019-10-04 00:00:00",
          "2019-10-07 00:00:00",
          "2019-10-08 00:00:00",
          "2019-10-09 00:00:00",
          "2019-10-10 00:00:00",
          "2019-10-11 00:00:00",
          "2019-10-14 00:00:00",
          "2019-10-15 00:00:00",
          "2019-10-16 00:00:00",
          "2019-10-17 00:00:00",
          "2019-10-18 00:00:00",
          "2019-10-21 00:00:00",
          "2019-10-22 00:00:00",
          "2019-10-23 00:00:00",
          "2019-10-24 00:00:00",
          "2019-10-25 00:00:00",
          "2019-10-28 00:00:00",
          "2019-10-29 00:00:00",
          "2019-10-30 00:00:00",
          "2019-10-31 00:00:00",
          "2019-11-01 00:00:00",
          "2019-11-04 00:00:00",
          "2019-11-05 00:00:00",
          "2019-11-06 00:00:00",
          "2019-11-07 00:00:00",
          "2019-11-08 00:00:00",
          "2019-11-11 00:00:00",
          "2019-11-12 00:00:00",
          "2019-11-13 00:00:00",
          "2019-11-14 00:00:00",
          "2019-11-15 00:00:00",
          "2019-11-18 00:00:00",
          "2019-11-19 00:00:00",
          "2019-11-20 00:00:00",
          "2019-11-21 00:00:00",
          "2019-11-22 00:00:00",
          "2019-11-25 00:00:00",
          "2019-11-26 00:00:00",
          "2019-11-27 00:00:00",
          "2019-11-28 00:00:00",
          "2019-11-29 00:00:00",
          "2019-12-02 00:00:00",
          "2019-12-03 00:00:00",
          "2019-12-04 00:00:00",
          "2019-12-05 00:00:00",
          "2019-12-06 00:00:00",
          "2019-12-09 00:00:00",
          "2019-12-10 00:00:00",
          "2019-12-11 00:00:00",
          "2019-12-12 00:00:00",
          "2019-12-13 00:00:00",
          "2019-12-16 00:00:00",
          "2019-12-17 00:00:00",
          "2019-12-18 00:00:00",
          "2019-12-19 00:00:00",
          "2019-12-20 00:00:00",
          "2019-12-23 00:00:00",
          "2019-12-27 00:00:00",
          "2019-12-30 00:00:00",
          "2020-01-02 00:00:00",
          "2020-01-03 00:00:00",
          "2020-01-06 00:00:00",
          "2020-01-07 00:00:00",
          "2020-01-08 00:00:00",
          "2020-01-09 00:00:00",
          "2020-01-10 00:00:00",
          "2020-01-13 00:00:00",
          "2020-01-14 00:00:00",
          "2020-01-15 00:00:00",
          "2020-01-16 00:00:00",
          "2020-01-17 00:00:00",
          "2020-01-20 00:00:00",
          "2020-01-21 00:00:00",
          "2020-01-22 00:00:00",
          "2020-01-23 00:00:00",
          "2020-01-24 00:00:00",
          "2020-01-27 00:00:00",
          "2020-01-28 00:00:00",
          "2020-01-29 00:00:00",
          "2020-01-30 00:00:00",
          "2020-01-31 00:00:00",
          "2020-02-03 00:00:00",
          "2020-02-04 00:00:00",
          "2020-02-05 00:00:00",
          "2020-02-06 00:00:00",
          "2020-02-07 00:00:00",
          "2020-02-10 00:00:00",
          "2020-02-11 00:00:00",
          "2020-02-12 00:00:00",
          "2020-02-13 00:00:00",
          "2020-02-14 00:00:00",
          "2020-02-17 00:00:00",
          "2020-02-18 00:00:00",
          "2020-02-19 00:00:00",
          "2020-02-20 00:00:00",
          "2020-02-21 00:00:00",
          "2020-02-24 00:00:00",
          "2020-02-25 00:00:00",
          "2020-02-26 00:00:00",
          "2020-02-27 00:00:00",
          "2020-02-28 00:00:00",
          "2020-03-02 00:00:00",
          "2020-03-03 00:00:00",
          "2020-03-04 00:00:00",
          "2020-03-05 00:00:00",
          "2020-03-06 00:00:00",
          "2020-03-09 00:00:00",
          "2020-03-10 00:00:00",
          "2020-03-11 00:00:00",
          "2020-03-12 00:00:00",
          "2020-03-13 00:00:00",
          "2020-03-16 00:00:00",
          "2020-03-17 00:00:00",
          "2020-03-18 00:00:00",
          "2020-03-19 00:00:00",
          "2020-03-20 00:00:00",
          "2020-03-23 00:00:00",
          "2020-03-24 00:00:00",
          "2020-03-25 00:00:00",
          "2020-03-26 00:00:00",
          "2020-03-27 00:00:00",
          "2020-03-30 00:00:00",
          "2020-03-31 00:00:00",
          "2020-04-01 00:00:00",
          "2020-04-02 00:00:00",
          "2020-04-03 00:00:00",
          "2020-04-06 00:00:00",
          "2020-04-07 00:00:00",
          "2020-04-08 00:00:00",
          "2020-04-09 00:00:00",
          "2020-04-14 00:00:00",
          "2020-04-15 00:00:00",
          "2020-04-16 00:00:00",
          "2020-04-17 00:00:00",
          "2020-04-20 00:00:00",
          "2020-04-21 00:00:00",
          "2020-04-22 00:00:00",
          "2020-04-23 00:00:00",
          "2020-04-24 00:00:00",
          "2020-04-27 00:00:00",
          "2020-04-28 00:00:00",
          "2020-04-29 00:00:00",
          "2020-04-30 00:00:00",
          "2020-05-04 00:00:00",
          "2020-05-05 00:00:00",
          "2020-05-06 00:00:00",
          "2020-05-07 00:00:00",
          "2020-05-08 00:00:00",
          "2020-05-11 00:00:00",
          "2020-05-12 00:00:00",
          "2020-05-13 00:00:00",
          "2020-05-14 00:00:00",
          "2020-05-15 00:00:00",
          "2020-05-18 00:00:00",
          "2020-05-19 00:00:00",
          "2020-05-20 00:00:00",
          "2020-05-22 00:00:00",
          "2020-05-25 00:00:00",
          "2020-05-26 00:00:00",
          "2020-05-27 00:00:00",
          "2020-05-28 00:00:00",
          "2020-05-29 00:00:00",
          "2020-06-02 00:00:00",
          "2020-06-03 00:00:00",
          "2020-06-04 00:00:00",
          "2020-06-05 00:00:00",
          "2020-06-08 00:00:00",
          "2020-06-09 00:00:00",
          "2020-06-10 00:00:00",
          "2020-06-12 00:00:00",
          "2020-06-15 00:00:00",
          "2020-06-16 00:00:00",
          "2020-06-17 00:00:00",
          "2020-06-18 00:00:00",
          "2020-06-19 00:00:00",
          "2020-06-22 00:00:00",
          "2020-06-23 00:00:00",
          "2020-06-24 00:00:00",
          "2020-06-25 00:00:00",
          "2020-06-26 00:00:00",
          "2020-06-29 00:00:00",
          "2020-06-30 00:00:00",
          "2020-07-01 00:00:00",
          "2020-07-02 00:00:00",
          "2020-07-03 00:00:00",
          "2020-07-06 00:00:00",
          "2020-07-07 00:00:00",
          "2020-07-08 00:00:00",
          "2020-07-09 00:00:00",
          "2020-07-10 00:00:00",
          "2020-07-13 00:00:00",
          "2020-07-14 00:00:00",
          "2020-07-15 00:00:00",
          "2020-07-16 00:00:00",
          "2020-07-17 00:00:00",
          "2020-07-20 00:00:00",
          "2020-07-21 00:00:00",
          "2020-07-22 00:00:00",
          "2020-07-23 00:00:00",
          "2020-07-24 00:00:00",
          "2020-07-27 00:00:00",
          "2020-07-28 00:00:00",
          "2020-07-29 00:00:00",
          "2020-07-30 00:00:00",
          "2020-07-31 00:00:00",
          "2020-08-03 00:00:00",
          "2020-08-04 00:00:00",
          "2020-08-05 00:00:00",
          "2020-08-06 00:00:00",
          "2020-08-07 00:00:00",
          "2020-08-10 00:00:00",
          "2020-08-11 00:00:00",
          "2020-08-12 00:00:00",
          "2020-08-13 00:00:00",
          "2020-08-14 00:00:00",
          "2020-08-17 00:00:00",
          "2020-08-18 00:00:00",
          "2020-08-19 00:00:00",
          "2020-08-20 00:00:00",
          "2020-08-21 00:00:00",
          "2020-08-24 00:00:00",
          "2020-08-25 00:00:00",
          "2020-08-26 00:00:00",
          "2020-08-27 00:00:00",
          "2020-08-28 00:00:00",
          "2020-08-31 00:00:00",
          "2020-09-01 00:00:00",
          "2020-09-02 00:00:00",
          "2020-09-03 00:00:00",
          "2020-09-04 00:00:00",
          "2020-09-07 00:00:00",
          "2020-09-08 00:00:00",
          "2020-09-09 00:00:00",
          "2020-09-10 00:00:00",
          "2020-09-11 00:00:00",
          "2020-09-14 00:00:00",
          "2020-09-15 00:00:00",
          "2020-09-16 00:00:00",
          "2020-09-17 00:00:00",
          "2020-09-18 00:00:00",
          "2020-09-21 00:00:00",
          "2020-09-22 00:00:00",
          "2020-09-23 00:00:00",
          "2020-09-24 00:00:00",
          "2020-09-25 00:00:00",
          "2020-09-28 00:00:00",
          "2020-09-29 00:00:00",
          "2020-09-30 00:00:00",
          "2020-10-01 00:00:00",
          "2020-10-02 00:00:00",
          "2020-10-05 00:00:00",
          "2020-10-06 00:00:00",
          "2020-10-07 00:00:00",
          "2020-10-08 00:00:00",
          "2020-10-09 00:00:00",
          "2020-10-12 00:00:00",
          "2020-10-13 00:00:00",
          "2020-10-14 00:00:00",
          "2020-10-15 00:00:00",
          "2020-10-16 00:00:00",
          "2020-10-19 00:00:00",
          "2020-10-20 00:00:00",
          "2020-10-21 00:00:00",
          "2020-10-22 00:00:00",
          "2020-10-23 00:00:00",
          "2020-10-26 00:00:00",
          "2020-10-27 00:00:00",
          "2020-10-28 00:00:00",
          "2020-10-29 00:00:00",
          "2020-10-30 00:00:00",
          "2020-11-02 00:00:00",
          "2020-11-03 00:00:00",
          "2020-11-04 00:00:00",
          "2020-11-05 00:00:00",
          "2020-11-06 00:00:00",
          "2020-11-09 00:00:00",
          "2020-11-10 00:00:00",
          "2020-11-11 00:00:00",
          "2020-11-12 00:00:00",
          "2020-11-13 00:00:00",
          "2020-11-16 00:00:00",
          "2020-11-17 00:00:00",
          "2020-11-18 00:00:00",
          "2020-11-19 00:00:00",
          "2020-11-20 00:00:00",
          "2020-11-23 00:00:00",
          "2020-11-24 00:00:00",
          "2020-11-25 00:00:00",
          "2020-11-26 00:00:00",
          "2020-11-27 00:00:00",
          "2020-11-30 00:00:00",
          "2020-12-01 00:00:00",
          "2020-12-02 00:00:00",
          "2020-12-03 00:00:00",
          "2020-12-04 00:00:00",
          "2020-12-07 00:00:00",
          "2020-12-08 00:00:00",
          "2020-12-09 00:00:00",
          "2020-12-10 00:00:00",
          "2020-12-11 00:00:00",
          "2020-12-14 00:00:00",
          "2020-12-15 00:00:00",
          "2020-12-16 00:00:00",
          "2020-12-17 00:00:00",
          "2020-12-18 00:00:00",
          "2020-12-21 00:00:00",
          "2020-12-22 00:00:00",
          "2020-12-23 00:00:00",
          "2020-12-28 00:00:00",
          "2020-12-29 00:00:00",
          "2020-12-30 00:00:00",
          "2021-01-04 00:00:00",
          "2021-01-05 00:00:00",
          "2021-01-06 00:00:00",
          "2021-01-07 00:00:00",
          "2021-01-08 00:00:00",
          "2021-01-11 00:00:00",
          "2021-01-12 00:00:00",
          "2021-01-13 00:00:00",
          "2021-01-14 00:00:00",
          "2021-01-15 00:00:00",
          "2021-01-18 00:00:00",
          "2021-01-19 00:00:00",
          "2021-01-20 00:00:00",
          "2021-01-21 00:00:00",
          "2021-01-22 00:00:00",
          "2021-01-25 00:00:00",
          "2021-01-26 00:00:00",
          "2021-01-27 00:00:00",
          "2021-01-28 00:00:00",
          "2021-01-29 00:00:00",
          "2021-02-01 00:00:00",
          "2021-02-02 00:00:00",
          "2021-02-03 00:00:00",
          "2021-02-04 00:00:00",
          "2021-02-05 00:00:00",
          "2021-02-08 00:00:00",
          "2021-02-09 00:00:00",
          "2021-02-10 00:00:00",
          "2021-02-11 00:00:00",
          "2021-02-12 00:00:00",
          "2021-02-15 00:00:00",
          "2021-02-16 00:00:00",
          "2021-02-17 00:00:00",
          "2021-02-18 00:00:00",
          "2021-02-19 00:00:00",
          "2021-02-22 00:00:00",
          "2021-02-23 00:00:00",
          "2021-02-24 00:00:00",
          "2021-02-25 00:00:00",
          "2021-02-26 00:00:00",
          "2021-03-01 00:00:00",
          "2021-03-02 00:00:00",
          "2021-03-03 00:00:00",
          "2021-03-04 00:00:00",
          "2021-03-05 00:00:00",
          "2021-03-08 00:00:00",
          "2021-03-09 00:00:00",
          "2021-03-10 00:00:00",
          "2021-03-11 00:00:00",
          "2021-03-12 00:00:00",
          "2021-03-15 00:00:00",
          "2021-03-16 00:00:00",
          "2021-03-17 00:00:00",
          "2021-03-18 00:00:00",
          "2021-03-19 00:00:00",
          "2021-03-22 00:00:00",
          "2021-03-23 00:00:00",
          "2021-03-24 00:00:00",
          "2021-03-25 00:00:00",
          "2021-03-26 00:00:00",
          "2021-03-29 00:00:00",
          "2021-03-30 00:00:00",
          "2021-03-31 00:00:00",
          "2021-04-01 00:00:00",
          "2021-04-06 00:00:00",
          "2021-04-07 00:00:00",
          "2021-04-08 00:00:00",
          "2021-04-09 00:00:00",
          "2021-04-12 00:00:00",
          "2021-04-13 00:00:00",
          "2021-04-14 00:00:00",
          "2021-04-15 00:00:00",
          "2021-04-16 00:00:00",
          "2021-04-19 00:00:00",
          "2021-04-20 00:00:00",
          "2021-04-21 00:00:00",
          "2021-04-22 00:00:00",
          "2021-04-23 00:00:00",
          "2021-04-26 00:00:00",
          "2021-04-27 00:00:00",
          "2021-04-28 00:00:00",
          "2021-04-29 00:00:00",
          "2021-04-30 00:00:00",
          "2021-05-03 00:00:00",
          "2021-05-04 00:00:00",
          "2021-05-05 00:00:00",
          "2021-05-06 00:00:00",
          "2021-05-07 00:00:00",
          "2021-05-10 00:00:00",
          "2021-05-11 00:00:00",
          "2021-05-12 00:00:00",
          "2021-05-14 00:00:00",
          "2021-05-17 00:00:00",
          "2021-05-18 00:00:00",
          "2021-05-19 00:00:00",
          "2021-05-20 00:00:00",
          "2021-05-21 00:00:00",
          "2021-05-25 00:00:00",
          "2021-05-26 00:00:00",
          "2021-05-27 00:00:00",
          "2021-05-28 00:00:00",
          "2021-05-31 00:00:00",
          "2021-06-01 00:00:00",
          "2021-06-02 00:00:00",
          "2021-06-04 00:00:00",
          "2021-06-07 00:00:00",
          "2021-06-08 00:00:00",
          "2021-06-09 00:00:00",
          "2021-06-10 00:00:00",
          "2021-06-11 00:00:00",
          "2021-06-14 00:00:00",
          "2021-06-15 00:00:00",
          "2021-06-16 00:00:00",
          "2021-06-17 00:00:00",
          "2021-06-18 00:00:00",
          "2021-06-21 00:00:00",
          "2021-06-22 00:00:00",
          "2021-06-23 00:00:00",
          "2021-06-24 00:00:00",
          "2021-06-25 00:00:00",
          "2021-06-28 00:00:00",
          "2021-06-29 00:00:00",
          "2021-06-30 00:00:00",
          "2021-07-01 00:00:00",
          "2021-07-02 00:00:00",
          "2021-07-05 00:00:00",
          "2021-07-06 00:00:00",
          "2021-07-07 00:00:00",
          "2021-07-08 00:00:00",
          "2021-07-09 00:00:00",
          "2021-07-12 00:00:00",
          "2021-07-13 00:00:00",
          "2021-07-14 00:00:00",
          "2021-07-15 00:00:00",
          "2021-07-16 00:00:00",
          "2021-07-19 00:00:00",
          "2021-07-20 00:00:00",
          "2021-07-21 00:00:00",
          "2021-07-22 00:00:00",
          "2021-07-23 00:00:00",
          "2021-07-26 00:00:00",
          "2021-07-27 00:00:00",
          "2021-07-28 00:00:00",
          "2021-07-29 00:00:00",
          "2021-07-30 00:00:00"
         ],
         "xaxis": "x",
         "y": [
          1317,
          1320,
          1315,
          1323,
          1322,
          1320,
          1328,
          1320,
          1333,
          1342,
          1337,
          1340,
          1333,
          1335,
          1336,
          1339,
          1354,
          1361,
          1353,
          1354,
          1345,
          1344,
          1343,
          1354,
          1343,
          1342,
          1329,
          1314,
          1322,
          1324,
          1329,
          1342,
          1359,
          1355,
          1354,
          1349,
          1336,
          1329,
          1327,
          1341,
          1325,
          1322,
          1310,
          1332,
          1322,
          1329,
          1337,
          1332,
          1327,
          1324,
          1332,
          1327,
          1325,
          1315,
          1314,
          1308,
          1330,
          1329,
          1344,
          1347,
          1350,
          1344,
          1335,
          1345,
          1335,
          1330,
          1330,
          1339,
          1342,
          1348,
          1348,
          1344,
          1352,
          1348,
          1355,
          1353,
          1345,
          1328,
          1333,
          1323,
          1326,
          1319,
          1324,
          1314,
          1318,
          1320,
          1317,
          1314,
          1313,
          1325,
          1323,
          1307,
          1290,
          1299,
          1295,
          1299,
          1295,
          1304,
          1304,
          1300,
          1308,
          1305,
          1305,
          1296,
          1294,
          1307,
          1307,
          1301,
          1302,
          1301,
          1300,
          1309,
          1299,
          1282,
          1279,
          1277,
          1268,
          1271,
          1270,
          1257,
          1258,
          1257,
          1254,
          1252,
          1248,
          1265,
          1259,
          1258,
          1265,
          1256,
          1255,
          1247,
          1245,
          1241,
          1235,
          1226,
          1219,
          1236,
          1235,
          1227,
          1227,
          1236,
          1226,
          1226,
          1227,
          1223,
          1223,
          1220,
          1213,
          1214,
          1219,
          1218,
          1216,
          1210,
          1198,
          1192,
          1186,
          1184,
          1188,
          1197,
          1199,
          1197,
          1196,
          1213,
          1215,
          1208,
          1205,
          1210,
          1203,
          1197,
          1199,
          1206,
          1197,
          1196,
          1200,
          1197,
          1212,
          1207,
          1207,
          1205,
          1207,
          1210,
          1197,
          1202,
          1207,
          1204,
          1193,
          1187,
          1188,
          1204,
          1209,
          1209,
          1187,
          1190,
          1194,
          1210,
          1222,
          1233,
          1230,
          1228,
          1229,
          1233,
          1223,
          1242,
          1235,
          1235,
          1242,
          1234,
          1233,
          1220,
          1235,
          1237,
          1234,
          1234,
          1236,
          1228,
          1214,
          1210,
          1206,
          1210,
          1215,
          1227,
          1227,
          1229,
          1227,
          1233,
          1228,
          1228,
          1222,
          1219,
          1228,
          1223,
          1229,
          1245,
          1244,
          1248,
          1241,
          1250,
          1249,
          1249,
          1243,
          1240,
          1241,
          1249,
          1261,
          1257,
          1256,
          1273,
          1286,
          1297,
          1295,
          1283,
          1292,
          1285,
          1292,
          1299,
          1296,
          1296,
          1296,
          1296,
          1295,
          1287,
          1286,
          1283,
          1286,
          1289,
          1293,
          1304,
          1312,
          1320,
          1331,
          1324,
          1315,
          1320,
          1317,
          1319,
          1317,
          1314,
          1312,
          1314,
          1309,
          1317,
          1326,
          1329,
          1350,
          1335,
          1328,
          1337,
          1334,
          1323,
          1324,
          1310,
          1290,
          1287,
          1285,
          1290,
          1303,
          1301,
          1298,
          1308,
          1303,
          1302,
          1310,
          1314,
          1305,
          1321,
          1313,
          1319,
          1326,
          1319,
          1304,
          1303,
          1299,
          1292,
          1296,
          1287,
          1293,
          1306,
          1309,
          1302,
          1312,
          1299,
          1292,
          1277,
          1281,
          1281,
          1272,
          1277,
          1282,
          1289,
          1281,
          1283,
          1267,
          1280,
          1285,
          1288,
          1288,
          1284,
          1288,
          1294,
          1301,
          1298,
          1298,
          1284,
          1280,
          1278,
          1275,
          1276,
          1290,
          1293,
          1281,
          1285,
          1292,
          1323,
          1327,
          1345,
          1341,
          1346,
          1336,
          1335,
          1342,
          1350,
          1342,
          1356,
          1349,
          1407,
          1422,
          1432,
          1408,
          1407,
          1414,
          1397,
          1393,
          1429,
          1427,
          1393,
          1406,
          1394,
          1417,
          1419,
          1409,
          1421,
          1417,
          1410,
          1422,
          1438,
          1430,
          1427,
          1425,
          1422,
          1426,
          1425,
          1425,
          1434,
          1408,
          1443,
          1465,
          1472,
          1502,
          1501,
          1514,
          1502,
          1497,
          1520,
          1522,
          1512,
          1508,
          1507,
          1504,
          1502,
          1512,
          1534,
          1532,
          1543,
          1551,
          1535,
          1529,
          1547,
          1547,
          1528,
          1507,
          1510,
          1500,
          1496,
          1525,
          1511,
          1504,
          1500,
          1504,
          1510,
          1509,
          1525,
          1523,
          1533,
          1511,
          1500,
          1487,
          1478,
          1499,
          1503,
          1511,
          1508,
          1512,
          1514,
          1488,
          1491,
          1491,
          1496,
          1499,
          1494,
          1496,
          1491,
          1497,
          1497,
          1518,
          1495,
          1499,
          1495,
          1511,
          1513,
          1514,
          1495,
          1487,
          1487,
          1460,
          1466,
          1457,
          1463,
          1472,
          1466,
          1467,
          1476,
          1479,
          1473,
          1472,
          1461,
          1461,
          1457,
          1462,
          1458,
          1461,
          1480,
          1474,
          1480,
          1466,
          1468,
          1466,
          1471,
          1487,
          1470,
          1483,
          1479,
          1482,
          1482,
          1480,
          1488,
          1516,
          1517,
          1526,
          1549,
          1563,
          1571,
          1572,
          1554,
          1556,
          1554,
          1544,
          1554,
          1553,
          1557,
          1566,
          1559,
          1558,
          1558,
          1575,
          1586,
          1582,
          1575,
          1585,
          1584,
          1583,
          1567,
          1558,
          1571,
          1570,
          1575,
          1574,
          1569,
          1578,
          1579,
          1584,
          1602,
          1610,
          1620,
          1643,
          1677,
          1657,
          1648,
          1654,
          1612,
          1602,
          1623,
          1639,
          1655,
          1672,
          1685,
          1655,
          1660,
          1580,
          1543,
          1487,
          1536,
          1504,
          1488,
          1506,
          1526,
          1610,
          1619,
          1645,
          1620,
          1624,
          1612,
          1589,
          1607,
          1621,
          1640,
          1653,
          1657,
          1657,
          1741,
          1727,
          1731,
          1697,
          1687,
          1686,
          1707,
          1737,
          1736,
          1720,
          1714,
          1706,
          1718,
          1710,
          1698,
          1696,
          1694,
          1723,
          1710,
          1706,
          1711,
          1718,
          1744,
          1751,
          1743,
          1756,
          1739,
          1730,
          1728,
          1705,
          1731,
          1734,
          1742,
          1702,
          1711,
          1687,
          1696,
          1720,
          1728,
          1734,
          1716,
          1731,
          1734,
          1730,
          1741,
          1757,
          1768,
          1771,
          1767,
          1757,
          1780,
          1770,
          1781,
          1771,
          1776,
          1788,
          1798,
          1819,
          1818,
          1811,
          1812,
          1803,
          1814,
          1811,
          1811,
          1821,
          1844,
          1855,
          1884,
          1910,
          1945,
          1944,
          1960,
          1961,
          1964,
          1967,
          1990,
          2048,
          2063,
          2053,
          2052,
          1964,
          1943,
          1942,
          1955,
          1974,
          1997,
          1998,
          1932,
          1924,
          1954,
          1935,
          1932,
          1942,
          1964,
          1980,
          1989,
          1960,
          1938,
          1946,
          1936,
          1922,
          1945,
          1964,
          1957,
          1949,
          1956,
          1973,
          1939,
          1958,
          1907,
          1918,
          1877,
          1863,
          1864,
          1877,
          1887,
          1898,
          1896,
          1914,
          1918,
          1924,
          1891,
          1903,
          1925,
          1932,
          1902,
          1909,
          1902,
          1912,
          1919,
          1907,
          1927,
          1911,
          1917,
          1911,
          1901,
          1885,
          1878,
          1895,
          1892,
          1912,
          1907,
          1932,
          1952,
          1870,
          1876,
          1871,
          1875,
          1895,
          1893,
          1898,
          1882,
          1862,
          1878,
          1837,
          1806,
          1818,
          1817,
          1784,
          1776,
          1821,
          1828,
          1839,
          1845,
          1860,
          1875,
          1858,
          1851,
          1842,
          1838,
          1852,
          1861,
          1892,
          1886,
          1888,
          1890,
          1872,
          1889,
          1880,
          1887,
          1943,
          1953,
          1939,
          1923,
          1872,
          1846,
          1855,
          1863,
          1854,
          1840,
          1832,
          1841,
          1869,
          1862,
          1852,
          1860,
          1865,
          1838,
          1865,
          1869,
          1864,
          1837,
          1845,
          1803,
          1813,
          1839,
          1842,
          1853,
          1848,
          1821,
          1824,
          1813,
          1786,
          1779,
          1782,
          1810,
          1806,
          1795,
          1780,
          1733,
          1741,
          1732,
          1714,
          1716,
          1700,
          1694,
          1722,
          1721,
          1731,
          1712,
          1729,
          1737,
          1736,
          1734,
          1742,
          1735,
          1731,
          1732,
          1739,
          1739,
          1720,
          1688,
          1690,
          1725,
          1742,
          1735,
          1758,
          1746,
          1742,
          1752,
          1740,
          1759,
          1779,
          1777,
          1779,
          1800,
          1790,
          1776,
          1783,
          1789,
          1777,
          1762,
          1771,
          1792,
          1801,
          1784,
          1813,
          1842,
          1842,
          1833,
          1835,
          1837,
          1853,
          1871,
          1892,
          1874,
          1880,
          1888,
          1909,
          1902,
          1896,
          1908,
          1903,
          1910,
          1896,
          1895,
          1888,
          1895,
          1898,
          1889,
          1867,
          1869,
          1863,
          1790,
          1780,
          1777,
          1786,
          1789,
          1783,
          1783,
          1784,
          1763,
          1770,
          1778,
          1789,
          1789,
          1815,
          1806,
          1809,
          1812,
          1807,
          1810,
          1832,
          1829,
          1824,
          1813,
          1817,
          1812,
          1807,
          1800,
          1812,
          1807,
          1802,
          1826,
          1828
         ],
         "yaxis": "y"
        }
       ],
       "layout": {
        "legend": {
         "tracegroupgap": 0
        },
        "template": {
         "data": {
          "bar": [
           {
            "error_x": {
             "color": "#f2f5fa"
            },
            "error_y": {
             "color": "#f2f5fa"
            },
            "marker": {
             "line": {
              "color": "rgb(17,17,17)",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "bar"
           }
          ],
          "barpolar": [
           {
            "marker": {
             "line": {
              "color": "rgb(17,17,17)",
              "width": 0.5
             },
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "barpolar"
           }
          ],
          "carpet": [
           {
            "aaxis": {
             "endlinecolor": "#A2B1C6",
             "gridcolor": "#506784",
             "linecolor": "#506784",
             "minorgridcolor": "#506784",
             "startlinecolor": "#A2B1C6"
            },
            "baxis": {
             "endlinecolor": "#A2B1C6",
             "gridcolor": "#506784",
             "linecolor": "#506784",
             "minorgridcolor": "#506784",
             "startlinecolor": "#A2B1C6"
            },
            "type": "carpet"
           }
          ],
          "choropleth": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "choropleth"
           }
          ],
          "contour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "contour"
           }
          ],
          "contourcarpet": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "contourcarpet"
           }
          ],
          "heatmap": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmap"
           }
          ],
          "heatmapgl": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "heatmapgl"
           }
          ],
          "histogram": [
           {
            "marker": {
             "pattern": {
              "fillmode": "overlay",
              "size": 10,
              "solidity": 0.2
             }
            },
            "type": "histogram"
           }
          ],
          "histogram2d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2d"
           }
          ],
          "histogram2dcontour": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "histogram2dcontour"
           }
          ],
          "mesh3d": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "type": "mesh3d"
           }
          ],
          "parcoords": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "parcoords"
           }
          ],
          "pie": [
           {
            "automargin": true,
            "type": "pie"
           }
          ],
          "scatter": [
           {
            "marker": {
             "line": {
              "color": "#283442"
             }
            },
            "type": "scatter"
           }
          ],
          "scatter3d": [
           {
            "line": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatter3d"
           }
          ],
          "scattercarpet": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattercarpet"
           }
          ],
          "scattergeo": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattergeo"
           }
          ],
          "scattergl": [
           {
            "marker": {
             "line": {
              "color": "#283442"
             }
            },
            "type": "scattergl"
           }
          ],
          "scattermapbox": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scattermapbox"
           }
          ],
          "scatterpolar": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolar"
           }
          ],
          "scatterpolargl": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterpolargl"
           }
          ],
          "scatterternary": [
           {
            "marker": {
             "colorbar": {
              "outlinewidth": 0,
              "ticks": ""
             }
            },
            "type": "scatterternary"
           }
          ],
          "surface": [
           {
            "colorbar": {
             "outlinewidth": 0,
             "ticks": ""
            },
            "colorscale": [
             [
              0,
              "#0d0887"
             ],
             [
              0.1111111111111111,
              "#46039f"
             ],
             [
              0.2222222222222222,
              "#7201a8"
             ],
             [
              0.3333333333333333,
              "#9c179e"
             ],
             [
              0.4444444444444444,
              "#bd3786"
             ],
             [
              0.5555555555555556,
              "#d8576b"
             ],
             [
              0.6666666666666666,
              "#ed7953"
             ],
             [
              0.7777777777777778,
              "#fb9f3a"
             ],
             [
              0.8888888888888888,
              "#fdca26"
             ],
             [
              1,
              "#f0f921"
             ]
            ],
            "type": "surface"
           }
          ],
          "table": [
           {
            "cells": {
             "fill": {
              "color": "#506784"
             },
             "line": {
              "color": "rgb(17,17,17)"
             }
            },
            "header": {
             "fill": {
              "color": "#2a3f5f"
             },
             "line": {
              "color": "rgb(17,17,17)"
             }
            },
            "type": "table"
           }
          ]
         },
         "layout": {
          "annotationdefaults": {
           "arrowcolor": "#f2f5fa",
           "arrowhead": 0,
           "arrowwidth": 1
          },
          "autotypenumbers": "strict",
          "coloraxis": {
           "colorbar": {
            "outlinewidth": 0,
            "ticks": ""
           }
          },
          "colorscale": {
           "diverging": [
            [
             0,
             "#8e0152"
            ],
            [
             0.1,
             "#c51b7d"
            ],
            [
             0.2,
             "#de77ae"
            ],
            [
             0.3,
             "#f1b6da"
            ],
            [
             0.4,
             "#fde0ef"
            ],
            [
             0.5,
             "#f7f7f7"
            ],
            [
             0.6,
             "#e6f5d0"
            ],
            [
             0.7,
             "#b8e186"
            ],
            [
             0.8,
             "#7fbc41"
            ],
            [
             0.9,
             "#4d9221"
            ],
            [
             1,
             "#276419"
            ]
           ],
           "sequential": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ],
           "sequentialminus": [
            [
             0,
             "#0d0887"
            ],
            [
             0.1111111111111111,
             "#46039f"
            ],
            [
             0.2222222222222222,
             "#7201a8"
            ],
            [
             0.3333333333333333,
             "#9c179e"
            ],
            [
             0.4444444444444444,
             "#bd3786"
            ],
            [
             0.5555555555555556,
             "#d8576b"
            ],
            [
             0.6666666666666666,
             "#ed7953"
            ],
            [
             0.7777777777777778,
             "#fb9f3a"
            ],
            [
             0.8888888888888888,
             "#fdca26"
            ],
            [
             1,
             "#f0f921"
            ]
           ]
          },
          "colorway": [
           "#636efa",
           "#EF553B",
           "#00cc96",
           "#ab63fa",
           "#FFA15A",
           "#19d3f3",
           "#FF6692",
           "#B6E880",
           "#FF97FF",
           "#FECB52"
          ],
          "font": {
           "color": "#f2f5fa"
          },
          "geo": {
           "bgcolor": "rgb(17,17,17)",
           "lakecolor": "rgb(17,17,17)",
           "landcolor": "rgb(17,17,17)",
           "showlakes": true,
           "showland": true,
           "subunitcolor": "#506784"
          },
          "hoverlabel": {
           "align": "left"
          },
          "hovermode": "closest",
          "mapbox": {
           "style": "dark"
          },
          "paper_bgcolor": "rgb(17,17,17)",
          "plot_bgcolor": "rgb(17,17,17)",
          "polar": {
           "angularaxis": {
            "gridcolor": "#506784",
            "linecolor": "#506784",
            "ticks": ""
           },
           "bgcolor": "rgb(17,17,17)",
           "radialaxis": {
            "gridcolor": "#506784",
            "linecolor": "#506784",
            "ticks": ""
           }
          },
          "scene": {
           "xaxis": {
            "backgroundcolor": "rgb(17,17,17)",
            "gridcolor": "#506784",
            "gridwidth": 2,
            "linecolor": "#506784",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "#C8D4E3"
           },
           "yaxis": {
            "backgroundcolor": "rgb(17,17,17)",
            "gridcolor": "#506784",
            "gridwidth": 2,
            "linecolor": "#506784",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "#C8D4E3"
           },
           "zaxis": {
            "backgroundcolor": "rgb(17,17,17)",
            "gridcolor": "#506784",
            "gridwidth": 2,
            "linecolor": "#506784",
            "showbackground": true,
            "ticks": "",
            "zerolinecolor": "#C8D4E3"
           }
          },
          "shapedefaults": {
           "line": {
            "color": "#f2f5fa"
           }
          },
          "sliderdefaults": {
           "bgcolor": "#C8D4E3",
           "bordercolor": "rgb(17,17,17)",
           "borderwidth": 1,
           "tickwidth": 0
          },
          "ternary": {
           "aaxis": {
            "gridcolor": "#506784",
            "linecolor": "#506784",
            "ticks": ""
           },
           "baxis": {
            "gridcolor": "#506784",
            "linecolor": "#506784",
            "ticks": ""
           },
           "bgcolor": "rgb(17,17,17)",
           "caxis": {
            "gridcolor": "#506784",
            "linecolor": "#506784",
            "ticks": ""
           }
          },
          "title": {
           "x": 0.05
          },
          "updatemenudefaults": {
           "bgcolor": "#506784",
           "borderwidth": 0
          },
          "xaxis": {
           "automargin": true,
           "gridcolor": "#283442",
           "linecolor": "#506784",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "#283442",
           "zerolinewidth": 2
          },
          "yaxis": {
           "automargin": true,
           "gridcolor": "#283442",
           "linecolor": "#506784",
           "ticks": "",
           "title": {
            "standoff": 15
           },
           "zerolinecolor": "#283442",
           "zerolinewidth": 2
          }
         }
        },
        "title": {
         "text": "Precious metal prices 2018-2021"
        },
        "xaxis": {
         "anchor": "y",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "DateTime"
         }
        },
        "yaxis": {
         "anchor": "x",
         "domain": [
          0,
          1
         ],
         "title": {
          "text": "Gold"
         }
        }
       }
      },
      "text/html": [
       "<div>                            <div id=\"9b8dba7b-03e5-4a73-bbe7-551095ec55bd\" class=\"plotly-graph-div\" style=\"height:525px; width:100%;\"></div>            <script type=\"text/javascript\">                require([\"plotly\"], function(Plotly) {                    window.PLOTLYENV=window.PLOTLYENV || {};                                    if (document.getElementById(\"9b8dba7b-03e5-4a73-bbe7-551095ec55bd\")) {                    Plotly.newPlot(                        \"9b8dba7b-03e5-4a73-bbe7-551095ec55bd\",                        [{\"hovertemplate\":\"DateTime=%{x}\\u003cbr\\u003eGold=%{y}\\u003cextra\\u003e\\u003c\\u002fextra\\u003e\",\"legendgroup\":\"\",\"line\":{\"color\":\"#636efa\",\"dash\":\"solid\"},\"marker\":{\"symbol\":\"circle\"},\"mode\":\"lines\",\"name\":\"\",\"orientation\":\"v\",\"showlegend\":false,\"x\":[\"2018-01-02 00:00:00\",\"2018-01-03 00:00:00\",\"2018-01-04 00:00:00\",\"2018-01-05 00:00:00\",\"2018-01-08 00:00:00\",\"2018-01-09 00:00:00\",\"2018-01-10 00:00:00\",\"2018-01-11 00:00:00\",\"2018-01-12 00:00:00\",\"2018-01-15 00:00:00\",\"2018-01-16 00:00:00\",\"2018-01-17 00:00:00\",\"2018-01-18 00:00:00\",\"2018-01-19 00:00:00\",\"2018-01-22 00:00:00\",\"2018-01-23 00:00:00\",\"2018-01-24 00:00:00\",\"2018-01-25 00:00:00\",\"2018-01-26 00:00:00\",\"2018-01-29 00:00:00\",\"2018-01-30 00:00:00\",\"2018-01-31 00:00:00\",\"2018-02-01 00:00:00\",\"2018-02-02 00:00:00\",\"2018-02-05 00:00:00\",\"2018-02-06 00:00:00\",\"2018-02-07 00:00:00\",\"2018-02-08 00:00:00\",\"2018-02-09 00:00:00\",\"2018-02-12 00:00:00\",\"2018-02-13 00:00:00\",\"2018-02-14 00:00:00\",\"2018-02-15 00:00:00\",\"2018-02-16 00:00:00\",\"2018-02-19 00:00:00\",\"2018-02-20 00:00:00\",\"2018-02-21 00:00:00\",\"2018-02-22 00:00:00\",\"2018-02-23 00:00:00\",\"2018-02-26 00:00:00\",\"2018-02-27 00:00:00\",\"2018-02-28 00:00:00\",\"2018-03-01 00:00:00\",\"2018-03-02 00:00:00\",\"2018-03-05 00:00:00\",\"2018-03-06 00:00:00\",\"2018-03-07 00:00:00\",\"2018-03-08 00:00:00\",\"2018-03-09 00:00:00\",\"2018-03-12 00:00:00\",\"2018-03-13 00:00:00\",\"2018-03-14 00:00:00\",\"2018-03-15 00:00:00\",\"2018-03-16 00:00:00\",\"2018-03-19 00:00:00\",\"2018-03-20 00:00:00\",\"2018-03-21 00:00:00\",\"2018-03-22 00:00:00\",\"2018-03-23 00:00:00\",\"2018-03-26 00:00:00\",\"2018-03-27 00:00:00\",\"2018-03-28 00:00:00\",\"2018-03-29 00:00:00\",\"2018-04-03 00:00:00\",\"2018-04-04 00:00:00\",\"2018-04-05 00:00:00\",\"2018-04-06 00:00:00\",\"2018-04-09 00:00:00\",\"2018-04-10 00:00:00\",\"2018-04-11 00:00:00\",\"2018-04-12 00:00:00\",\"2018-04-13 00:00:00\",\"2018-04-16 00:00:00\",\"2018-04-17 00:00:00\",\"2018-04-18 00:00:00\",\"2018-04-19 00:00:00\",\"2018-04-20 00:00:00\",\"2018-04-23 00:00:00\",\"2018-04-24 00:00:00\",\"2018-04-25 00:00:00\",\"2018-04-26 00:00:00\",\"2018-04-27 00:00:00\",\"2018-04-30 00:00:00\",\"2018-05-02 00:00:00\",\"2018-05-03 00:00:00\",\"2018-05-04 00:00:00\",\"2018-05-07 00:00:00\",\"2018-05-08 00:00:00\",\"2018-05-09 00:00:00\",\"2018-05-11 00:00:00\",\"2018-05-14 00:00:00\",\"2018-05-15 00:00:00\",\"2018-05-16 00:00:00\",\"2018-05-17 00:00:00\",\"2018-05-18 00:00:00\",\"2018-05-22 00:00:00\",\"2018-05-23 00:00:00\",\"2018-05-24 00:00:00\",\"2018-05-25 00:00:00\",\"2018-05-28 00:00:00\",\"2018-05-29 00:00:00\",\"2018-05-30 00:00:00\",\"2018-06-01 00:00:00\",\"2018-06-04 00:00:00\",\"2018-06-05 00:00:00\",\"2018-06-06 00:00:00\",\"2018-06-07 00:00:00\",\"2018-06-08 00:00:00\",\"2018-06-11 00:00:00\",\"2018-06-12 00:00:00\",\"2018-06-13 00:00:00\",\"2018-06-14 00:00:00\",\"2018-06-15 00:00:00\",\"2018-06-18 00:00:00\",\"2018-06-19 00:00:00\",\"2018-06-20 00:00:00\",\"2018-06-21 00:00:00\",\"2018-06-22 00:00:00\",\"2018-06-25 00:00:00\",\"2018-06-26 00:00:00\",\"2018-06-27 00:00:00\",\"2018-06-28 00:00:00\",\"2018-06-29 00:00:00\",\"2018-07-02 00:00:00\",\"2018-07-03 00:00:00\",\"2018-07-04 00:00:00\",\"2018-07-05 00:00:00\",\"2018-07-06 00:00:00\",\"2018-07-09 00:00:00\",\"2018-07-10 00:00:00\",\"2018-07-11 00:00:00\",\"2018-07-12 00:00:00\",\"2018-07-13 00:00:00\",\"2018-07-16 00:00:00\",\"2018-07-17 00:00:00\",\"2018-07-18 00:00:00\",\"2018-07-19 00:00:00\",\"2018-07-20 00:00:00\",\"2018-07-23 00:00:00\",\"2018-07-24 00:00:00\",\"2018-07-25 00:00:00\",\"2018-07-26 00:00:00\",\"2018-07-27 00:00:00\",\"2018-07-30 00:00:00\",\"2018-07-31 00:00:00\",\"2018-08-01 00:00:00\",\"2018-08-02 00:00:00\",\"2018-08-03 00:00:00\",\"2018-08-06 00:00:00\",\"2018-08-07 00:00:00\",\"2018-08-08 00:00:00\",\"2018-08-09 00:00:00\",\"2018-08-10 00:00:00\",\"2018-08-13 00:00:00\",\"2018-08-14 00:00:00\",\"2018-08-15 00:00:00\",\"2018-08-16 00:00:00\",\"2018-08-17 00:00:00\",\"2018-08-20 00:00:00\",\"2018-08-21 00:00:00\",\"2018-08-22 00:00:00\",\"2018-08-23 00:00:00\",\"2018-08-24 00:00:00\",\"2018-08-27 00:00:00\",\"2018-08-28 00:00:00\",\"2018-08-29 00:00:00\",\"2018-08-30 00:00:00\",\"2018-08-31 00:00:00\",\"2018-09-03 00:00:00\",\"2018-09-04 00:00:00\",\"2018-09-05 00:00:00\",\"2018-09-06 00:00:00\",\"2018-09-07 00:00:00\",\"2018-09-10 00:00:00\",\"2018-09-11 00:00:00\",\"2018-09-12 00:00:00\",\"2018-09-13 00:00:00\",\"2018-09-14 00:00:00\",\"2018-09-17 00:00:00\",\"2018-09-18 00:00:00\",\"2018-09-19 00:00:00\",\"2018-09-20 00:00:00\",\"2018-09-21 00:00:00\",\"2018-09-24 00:00:00\",\"2018-09-25 00:00:00\",\"2018-09-26 00:00:00\",\"2018-09-27 00:00:00\",\"2018-09-28 00:00:00\",\"2018-10-01 00:00:00\",\"2018-10-02 00:00:00\",\"2018-10-04 00:00:00\",\"2018-10-05 00:00:00\",\"2018-10-08 00:00:00\",\"2018-10-09 00:00:00\",\"2018-10-10 00:00:00\",\"2018-10-11 00:00:00\",\"2018-10-12 00:00:00\",\"2018-10-15 00:00:00\",\"2018-10-16 00:00:00\",\"2018-10-17 00:00:00\",\"2018-10-18 00:00:00\",\"2018-10-19 00:00:00\",\"2018-10-22 00:00:00\",\"2018-10-23 00:00:00\",\"2018-10-24 00:00:00\",\"2018-10-25 00:00:00\",\"2018-10-26 00:00:00\",\"2018-10-29 00:00:00\",\"2018-10-30 00:00:00\",\"2018-10-31 00:00:00\",\"2018-11-01 00:00:00\",\"2018-11-02 00:00:00\",\"2018-11-05 00:00:00\",\"2018-11-06 00:00:00\",\"2018-11-07 00:00:00\",\"2018-11-08 00:00:00\",\"2018-11-09 00:00:00\",\"2018-11-12 00:00:00\",\"2018-11-13 00:00:00\",\"2018-11-14 00:00:00\",\"2018-11-15 00:00:00\",\"2018-11-16 00:00:00\",\"2018-11-19 00:00:00\",\"2018-11-20 00:00:00\",\"2018-11-21 00:00:00\",\"2018-11-22 00:00:00\",\"2018-11-23 00:00:00\",\"2018-11-26 00:00:00\",\"2018-11-27 00:00:00\",\"2018-11-28 00:00:00\",\"2018-11-29 00:00:00\",\"2018-11-30 00:00:00\",\"2018-12-03 00:00:00\",\"2018-12-04 00:00:00\",\"2018-12-05 00:00:00\",\"2018-12-06 00:00:00\",\"2018-12-07 00:00:00\",\"2018-12-10 00:00:00\",\"2018-12-11 00:00:00\",\"2018-12-12 00:00:00\",\"2018-12-13 00:00:00\",\"2018-12-14 00:00:00\",\"2018-12-17 00:00:00\",\"2018-12-18 00:00:00\",\"2018-12-19 00:00:00\",\"2018-12-20 00:00:00\",\"2018-12-21 00:00:00\",\"2018-12-27 00:00:00\",\"2018-12-28 00:00:00\",\"2019-01-02 00:00:00\",\"2019-01-03 00:00:00\",\"2019-01-04 00:00:00\",\"2019-01-07 00:00:00\",\"2019-01-08 00:00:00\",\"2019-01-09 00:00:00\",\"2019-01-10 00:00:00\",\"2019-01-11 00:00:00\",\"2019-01-14 00:00:00\",\"2019-01-15 00:00:00\",\"2019-01-16 00:00:00\",\"2019-01-17 00:00:00\",\"2019-01-18 00:00:00\",\"2019-01-21 00:00:00\",\"2019-01-22 00:00:00\",\"2019-01-23 00:00:00\",\"2019-01-24 00:00:00\",\"2019-01-25 00:00:00\",\"2019-01-28 00:00:00\",\"2019-01-29 00:00:00\",\"2019-01-30 00:00:00\",\"2019-01-31 00:00:00\",\"2019-02-01 00:00:00\",\"2019-02-04 00:00:00\",\"2019-02-05 00:00:00\",\"2019-02-06 00:00:00\",\"2019-02-07 00:00:00\",\"2019-02-08 00:00:00\",\"2019-02-11 00:00:00\",\"2019-02-12 00:00:00\",\"2019-02-13 00:00:00\",\"2019-02-14 00:00:00\",\"2019-02-15 00:00:00\",\"2019-02-18 00:00:00\",\"2019-02-19 00:00:00\",\"2019-02-20 00:00:00\",\"2019-02-21 00:00:00\",\"2019-02-22 00:00:00\",\"2019-02-25 00:00:00\",\"2019-02-26 00:00:00\",\"2019-02-27 00:00:00\",\"2019-02-28 00:00:00\",\"2019-03-01 00:00:00\",\"2019-03-04 00:00:00\",\"2019-03-05 00:00:00\",\"2019-03-06 00:00:00\",\"2019-03-07 00:00:00\",\"2019-03-08 00:00:00\",\"2019-03-11 00:00:00\",\"2019-03-12 00:00:00\",\"2019-03-13 00:00:00\",\"2019-03-14 00:00:00\",\"2019-03-15 00:00:00\",\"2019-03-18 00:00:00\",\"2019-03-19 00:00:00\",\"2019-03-20 00:00:00\",\"2019-03-21 00:00:00\",\"2019-03-22 00:00:00\",\"2019-03-25 00:00:00\",\"2019-03-26 00:00:00\",\"2019-03-27 00:00:00\",\"2019-03-28 00:00:00\",\"2019-03-29 00:00:00\",\"2019-04-01 00:00:00\",\"2019-04-02 00:00:00\",\"2019-04-03 00:00:00\",\"2019-04-04 00:00:00\",\"2019-04-05 00:00:00\",\"2019-04-08 00:00:00\",\"2019-04-09 00:00:00\",\"2019-04-10 00:00:00\",\"2019-04-11 00:00:00\",\"2019-04-12 00:00:00\",\"2019-04-15 00:00:00\",\"2019-04-16 00:00:00\",\"2019-04-17 00:00:00\",\"2019-04-18 00:00:00\",\"2019-04-23 00:00:00\",\"2019-04-24 00:00:00\",\"2019-04-25 00:00:00\",\"2019-04-26 00:00:00\",\"2019-04-29 00:00:00\",\"2019-04-30 00:00:00\",\"2019-05-02 00:00:00\",\"2019-05-03 00:00:00\",\"2019-05-06 00:00:00\",\"2019-05-07 00:00:00\",\"2019-05-08 00:00:00\",\"2019-05-09 00:00:00\",\"2019-05-10 00:00:00\",\"2019-05-13 00:00:00\",\"2019-05-14 00:00:00\",\"2019-05-15 00:00:00\",\"2019-05-16 00:00:00\",\"2019-05-17 00:00:00\",\"2019-05-20 00:00:00\",\"2019-05-21 00:00:00\",\"2019-05-22 00:00:00\",\"2019-05-23 00:00:00\",\"2019-05-24 00:00:00\",\"2019-05-27 00:00:00\",\"2019-05-28 00:00:00\",\"2019-05-29 00:00:00\",\"2019-05-31 00:00:00\",\"2019-06-03 00:00:00\",\"2019-06-04 00:00:00\",\"2019-06-05 00:00:00\",\"2019-06-06 00:00:00\",\"2019-06-07 00:00:00\",\"2019-06-11 00:00:00\",\"2019-06-12 00:00:00\",\"2019-06-13 00:00:00\",\"2019-06-14 00:00:00\",\"2019-06-17 00:00:00\",\"2019-06-18 00:00:00\",\"2019-06-19 00:00:00\",\"2019-06-21 00:00:00\",\"2019-06-24 00:00:00\",\"2019-06-25 00:00:00\",\"2019-06-26 00:00:00\",\"2019-06-27 00:00:00\",\"2019-06-28 00:00:00\",\"2019-07-01 00:00:00\",\"2019-07-02 00:00:00\",\"2019-07-03 00:00:00\",\"2019-07-04 00:00:00\",\"2019-07-05 00:00:00\",\"2019-07-08 00:00:00\",\"2019-07-09 00:00:00\",\"2019-07-10 00:00:00\",\"2019-07-11 00:00:00\",\"2019-07-12 00:00:00\",\"2019-07-15 00:00:00\",\"2019-07-16 00:00:00\",\"2019-07-17 00:00:00\",\"2019-07-18 00:00:00\",\"2019-07-19 00:00:00\",\"2019-07-22 00:00:00\",\"2019-07-23 00:00:00\",\"2019-07-24 00:00:00\",\"2019-07-25 00:00:00\",\"2019-07-26 00:00:00\",\"2019-07-29 00:00:00\",\"2019-07-30 00:00:00\",\"2019-07-31 00:00:00\",\"2019-08-01 00:00:00\",\"2019-08-02 00:00:00\",\"2019-08-05 00:00:00\",\"2019-08-06 00:00:00\",\"2019-08-07 00:00:00\",\"2019-08-08 00:00:00\",\"2019-08-09 00:00:00\",\"2019-08-12 00:00:00\",\"2019-08-13 00:00:00\",\"2019-08-14 00:00:00\",\"2019-08-15 00:00:00\",\"2019-08-16 00:00:00\",\"2019-08-19 00:00:00\",\"2019-08-20 00:00:00\",\"2019-08-21 00:00:00\",\"2019-08-22 00:00:00\",\"2019-08-23 00:00:00\",\"2019-08-26 00:00:00\",\"2019-08-27 00:00:00\",\"2019-08-28 00:00:00\",\"2019-08-29 00:00:00\",\"2019-08-30 00:00:00\",\"2019-09-02 00:00:00\",\"2019-09-03 00:00:00\",\"2019-09-04 00:00:00\",\"2019-09-05 00:00:00\",\"2019-09-06 00:00:00\",\"2019-09-09 00:00:00\",\"2019-09-10 00:00:00\",\"2019-09-11 00:00:00\",\"2019-09-12 00:00:00\",\"2019-09-13 00:00:00\",\"2019-09-16 00:00:00\",\"2019-09-17 00:00:00\",\"2019-09-18 00:00:00\",\"2019-09-19 00:00:00\",\"2019-09-20 00:00:00\",\"2019-09-23 00:00:00\",\"2019-09-24 00:00:00\",\"2019-09-25 00:00:00\",\"2019-09-26 00:00:00\",\"2019-09-27 00:00:00\",\"2019-09-30 00:00:00\",\"2019-10-01 00:00:00\",\"2019-10-02 00:00:00\",\"2019-10-04 00:00:00\",\"2019-10-07 00:00:00\",\"2019-10-08 00:00:00\",\"2019-10-09 00:00:00\",\"2019-10-10 00:00:00\",\"2019-10-11 00:00:00\",\"2019-10-14 00:00:00\",\"2019-10-15 00:00:00\",\"2019-10-16 00:00:00\",\"2019-10-17 00:00:00\",\"2019-10-18 00:00:00\",\"2019-10-21 00:00:00\",\"2019-10-22 00:00:00\",\"2019-10-23 00:00:00\",\"2019-10-24 00:00:00\",\"2019-10-25 00:00:00\",\"2019-10-28 00:00:00\",\"2019-10-29 00:00:00\",\"2019-10-30 00:00:00\",\"2019-10-31 00:00:00\",\"2019-11-01 00:00:00\",\"2019-11-04 00:00:00\",\"2019-11-05 00:00:00\",\"2019-11-06 00:00:00\",\"2019-11-07 00:00:00\",\"2019-11-08 00:00:00\",\"2019-11-11 00:00:00\",\"2019-11-12 00:00:00\",\"2019-11-13 00:00:00\",\"2019-11-14 00:00:00\",\"2019-11-15 00:00:00\",\"2019-11-18 00:00:00\",\"2019-11-19 00:00:00\",\"2019-11-20 00:00:00\",\"2019-11-21 00:00:00\",\"2019-11-22 00:00:00\",\"2019-11-25 00:00:00\",\"2019-11-26 00:00:00\",\"2019-11-27 00:00:00\",\"2019-11-28 00:00:00\",\"2019-11-29 00:00:00\",\"2019-12-02 00:00:00\",\"2019-12-03 00:00:00\",\"2019-12-04 00:00:00\",\"2019-12-05 00:00:00\",\"2019-12-06 00:00:00\",\"2019-12-09 00:00:00\",\"2019-12-10 00:00:00\",\"2019-12-11 00:00:00\",\"2019-12-12 00:00:00\",\"2019-12-13 00:00:00\",\"2019-12-16 00:00:00\",\"2019-12-17 00:00:00\",\"2019-12-18 00:00:00\",\"2019-12-19 00:00:00\",\"2019-12-20 00:00:00\",\"2019-12-23 00:00:00\",\"2019-12-27 00:00:00\",\"2019-12-30 00:00:00\",\"2020-01-02 00:00:00\",\"2020-01-03 00:00:00\",\"2020-01-06 00:00:00\",\"2020-01-07 00:00:00\",\"2020-01-08 00:00:00\",\"2020-01-09 00:00:00\",\"2020-01-10 00:00:00\",\"2020-01-13 00:00:00\",\"2020-01-14 00:00:00\",\"2020-01-15 00:00:00\",\"2020-01-16 00:00:00\",\"2020-01-17 00:00:00\",\"2020-01-20 00:00:00\",\"2020-01-21 00:00:00\",\"2020-01-22 00:00:00\",\"2020-01-23 00:00:00\",\"2020-01-24 00:00:00\",\"2020-01-27 00:00:00\",\"2020-01-28 00:00:00\",\"2020-01-29 00:00:00\",\"2020-01-30 00:00:00\",\"2020-01-31 00:00:00\",\"2020-02-03 00:00:00\",\"2020-02-04 00:00:00\",\"2020-02-05 00:00:00\",\"2020-02-06 00:00:00\",\"2020-02-07 00:00:00\",\"2020-02-10 00:00:00\",\"2020-02-11 00:00:00\",\"2020-02-12 00:00:00\",\"2020-02-13 00:00:00\",\"2020-02-14 00:00:00\",\"2020-02-17 00:00:00\",\"2020-02-18 00:00:00\",\"2020-02-19 00:00:00\",\"2020-02-20 00:00:00\",\"2020-02-21 00:00:00\",\"2020-02-24 00:00:00\",\"2020-02-25 00:00:00\",\"2020-02-26 00:00:00\",\"2020-02-27 00:00:00\",\"2020-02-28 00:00:00\",\"2020-03-02 00:00:00\",\"2020-03-03 00:00:00\",\"2020-03-04 00:00:00\",\"2020-03-05 00:00:00\",\"2020-03-06 00:00:00\",\"2020-03-09 00:00:00\",\"2020-03-10 00:00:00\",\"2020-03-11 00:00:00\",\"2020-03-12 00:00:00\",\"2020-03-13 00:00:00\",\"2020-03-16 00:00:00\",\"2020-03-17 00:00:00\",\"2020-03-18 00:00:00\",\"2020-03-19 00:00:00\",\"2020-03-20 00:00:00\",\"2020-03-23 00:00:00\",\"2020-03-24 00:00:00\",\"2020-03-25 00:00:00\",\"2020-03-26 00:00:00\",\"2020-03-27 00:00:00\",\"2020-03-30 00:00:00\",\"2020-03-31 00:00:00\",\"2020-04-01 00:00:00\",\"2020-04-02 00:00:00\",\"2020-04-03 00:00:00\",\"2020-04-06 00:00:00\",\"2020-04-07 00:00:00\",\"2020-04-08 00:00:00\",\"2020-04-09 00:00:00\",\"2020-04-14 00:00:00\",\"2020-04-15 00:00:00\",\"2020-04-16 00:00:00\",\"2020-04-17 00:00:00\",\"2020-04-20 00:00:00\",\"2020-04-21 00:00:00\",\"2020-04-22 00:00:00\",\"2020-04-23 00:00:00\",\"2020-04-24 00:00:00\",\"2020-04-27 00:00:00\",\"2020-04-28 00:00:00\",\"2020-04-29 00:00:00\",\"2020-04-30 00:00:00\",\"2020-05-04 00:00:00\",\"2020-05-05 00:00:00\",\"2020-05-06 00:00:00\",\"2020-05-07 00:00:00\",\"2020-05-08 00:00:00\",\"2020-05-11 00:00:00\",\"2020-05-12 00:00:00\",\"2020-05-13 00:00:00\",\"2020-05-14 00:00:00\",\"2020-05-15 00:00:00\",\"2020-05-18 00:00:00\",\"2020-05-19 00:00:00\",\"2020-05-20 00:00:00\",\"2020-05-22 00:00:00\",\"2020-05-25 00:00:00\",\"2020-05-26 00:00:00\",\"2020-05-27 00:00:00\",\"2020-05-28 00:00:00\",\"2020-05-29 00:00:00\",\"2020-06-02 00:00:00\",\"2020-06-03 00:00:00\",\"2020-06-04 00:00:00\",\"2020-06-05 00:00:00\",\"2020-06-08 00:00:00\",\"2020-06-09 00:00:00\",\"2020-06-10 00:00:00\",\"2020-06-12 00:00:00\",\"2020-06-15 00:00:00\",\"2020-06-16 00:00:00\",\"2020-06-17 00:00:00\",\"2020-06-18 00:00:00\",\"2020-06-19 00:00:00\",\"2020-06-22 00:00:00\",\"2020-06-23 00:00:00\",\"2020-06-24 00:00:00\",\"2020-06-25 00:00:00\",\"2020-06-26 00:00:00\",\"2020-06-29 00:00:00\",\"2020-06-30 00:00:00\",\"2020-07-01 00:00:00\",\"2020-07-02 00:00:00\",\"2020-07-03 00:00:00\",\"2020-07-06 00:00:00\",\"2020-07-07 00:00:00\",\"2020-07-08 00:00:00\",\"2020-07-09 00:00:00\",\"2020-07-10 00:00:00\",\"2020-07-13 00:00:00\",\"2020-07-14 00:00:00\",\"2020-07-15 00:00:00\",\"2020-07-16 00:00:00\",\"2020-07-17 00:00:00\",\"2020-07-20 00:00:00\",\"2020-07-21 00:00:00\",\"2020-07-22 00:00:00\",\"2020-07-23 00:00:00\",\"2020-07-24 00:00:00\",\"2020-07-27 00:00:00\",\"2020-07-28 00:00:00\",\"2020-07-29 00:00:00\",\"2020-07-30 00:00:00\",\"2020-07-31 00:00:00\",\"2020-08-03 00:00:00\",\"2020-08-04 00:00:00\",\"2020-08-05 00:00:00\",\"2020-08-06 00:00:00\",\"2020-08-07 00:00:00\",\"2020-08-10 00:00:00\",\"2020-08-11 00:00:00\",\"2020-08-12 00:00:00\",\"2020-08-13 00:00:00\",\"2020-08-14 00:00:00\",\"2020-08-17 00:00:00\",\"2020-08-18 00:00:00\",\"2020-08-19 00:00:00\",\"2020-08-20 00:00:00\",\"2020-08-21 00:00:00\",\"2020-08-24 00:00:00\",\"2020-08-25 00:00:00\",\"2020-08-26 00:00:00\",\"2020-08-27 00:00:00\",\"2020-08-28 00:00:00\",\"2020-08-31 00:00:00\",\"2020-09-01 00:00:00\",\"2020-09-02 00:00:00\",\"2020-09-03 00:00:00\",\"2020-09-04 00:00:00\",\"2020-09-07 00:00:00\",\"2020-09-08 00:00:00\",\"2020-09-09 00:00:00\",\"2020-09-10 00:00:00\",\"2020-09-11 00:00:00\",\"2020-09-14 00:00:00\",\"2020-09-15 00:00:00\",\"2020-09-16 00:00:00\",\"2020-09-17 00:00:00\",\"2020-09-18 00:00:00\",\"2020-09-21 00:00:00\",\"2020-09-22 00:00:00\",\"2020-09-23 00:00:00\",\"2020-09-24 00:00:00\",\"2020-09-25 00:00:00\",\"2020-09-28 00:00:00\",\"2020-09-29 00:00:00\",\"2020-09-30 00:00:00\",\"2020-10-01 00:00:00\",\"2020-10-02 00:00:00\",\"2020-10-05 00:00:00\",\"2020-10-06 00:00:00\",\"2020-10-07 00:00:00\",\"2020-10-08 00:00:00\",\"2020-10-09 00:00:00\",\"2020-10-12 00:00:00\",\"2020-10-13 00:00:00\",\"2020-10-14 00:00:00\",\"2020-10-15 00:00:00\",\"2020-10-16 00:00:00\",\"2020-10-19 00:00:00\",\"2020-10-20 00:00:00\",\"2020-10-21 00:00:00\",\"2020-10-22 00:00:00\",\"2020-10-23 00:00:00\",\"2020-10-26 00:00:00\",\"2020-10-27 00:00:00\",\"2020-10-28 00:00:00\",\"2020-10-29 00:00:00\",\"2020-10-30 00:00:00\",\"2020-11-02 00:00:00\",\"2020-11-03 00:00:00\",\"2020-11-04 00:00:00\",\"2020-11-05 00:00:00\",\"2020-11-06 00:00:00\",\"2020-11-09 00:00:00\",\"2020-11-10 00:00:00\",\"2020-11-11 00:00:00\",\"2020-11-12 00:00:00\",\"2020-11-13 00:00:00\",\"2020-11-16 00:00:00\",\"2020-11-17 00:00:00\",\"2020-11-18 00:00:00\",\"2020-11-19 00:00:00\",\"2020-11-20 00:00:00\",\"2020-11-23 00:00:00\",\"2020-11-24 00:00:00\",\"2020-11-25 00:00:00\",\"2020-11-26 00:00:00\",\"2020-11-27 00:00:00\",\"2020-11-30 00:00:00\",\"2020-12-01 00:00:00\",\"2020-12-02 00:00:00\",\"2020-12-03 00:00:00\",\"2020-12-04 00:00:00\",\"2020-12-07 00:00:00\",\"2020-12-08 00:00:00\",\"2020-12-09 00:00:00\",\"2020-12-10 00:00:00\",\"2020-12-11 00:00:00\",\"2020-12-14 00:00:00\",\"2020-12-15 00:00:00\",\"2020-12-16 00:00:00\",\"2020-12-17 00:00:00\",\"2020-12-18 00:00:00\",\"2020-12-21 00:00:00\",\"2020-12-22 00:00:00\",\"2020-12-23 00:00:00\",\"2020-12-28 00:00:00\",\"2020-12-29 00:00:00\",\"2020-12-30 00:00:00\",\"2021-01-04 00:00:00\",\"2021-01-05 00:00:00\",\"2021-01-06 00:00:00\",\"2021-01-07 00:00:00\",\"2021-01-08 00:00:00\",\"2021-01-11 00:00:00\",\"2021-01-12 00:00:00\",\"2021-01-13 00:00:00\",\"2021-01-14 00:00:00\",\"2021-01-15 00:00:00\",\"2021-01-18 00:00:00\",\"2021-01-19 00:00:00\",\"2021-01-20 00:00:00\",\"2021-01-21 00:00:00\",\"2021-01-22 00:00:00\",\"2021-01-25 00:00:00\",\"2021-01-26 00:00:00\",\"2021-01-27 00:00:00\",\"2021-01-28 00:00:00\",\"2021-01-29 00:00:00\",\"2021-02-01 00:00:00\",\"2021-02-02 00:00:00\",\"2021-02-03 00:00:00\",\"2021-02-04 00:00:00\",\"2021-02-05 00:00:00\",\"2021-02-08 00:00:00\",\"2021-02-09 00:00:00\",\"2021-02-10 00:00:00\",\"2021-02-11 00:00:00\",\"2021-02-12 00:00:00\",\"2021-02-15 00:00:00\",\"2021-02-16 00:00:00\",\"2021-02-17 00:00:00\",\"2021-02-18 00:00:00\",\"2021-02-19 00:00:00\",\"2021-02-22 00:00:00\",\"2021-02-23 00:00:00\",\"2021-02-24 00:00:00\",\"2021-02-25 00:00:00\",\"2021-02-26 00:00:00\",\"2021-03-01 00:00:00\",\"2021-03-02 00:00:00\",\"2021-03-03 00:00:00\",\"2021-03-04 00:00:00\",\"2021-03-05 00:00:00\",\"2021-03-08 00:00:00\",\"2021-03-09 00:00:00\",\"2021-03-10 00:00:00\",\"2021-03-11 00:00:00\",\"2021-03-12 00:00:00\",\"2021-03-15 00:00:00\",\"2021-03-16 00:00:00\",\"2021-03-17 00:00:00\",\"2021-03-18 00:00:00\",\"2021-03-19 00:00:00\",\"2021-03-22 00:00:00\",\"2021-03-23 00:00:00\",\"2021-03-24 00:00:00\",\"2021-03-25 00:00:00\",\"2021-03-26 00:00:00\",\"2021-03-29 00:00:00\",\"2021-03-30 00:00:00\",\"2021-03-31 00:00:00\",\"2021-04-01 00:00:00\",\"2021-04-06 00:00:00\",\"2021-04-07 00:00:00\",\"2021-04-08 00:00:00\",\"2021-04-09 00:00:00\",\"2021-04-12 00:00:00\",\"2021-04-13 00:00:00\",\"2021-04-14 00:00:00\",\"2021-04-15 00:00:00\",\"2021-04-16 00:00:00\",\"2021-04-19 00:00:00\",\"2021-04-20 00:00:00\",\"2021-04-21 00:00:00\",\"2021-04-22 00:00:00\",\"2021-04-23 00:00:00\",\"2021-04-26 00:00:00\",\"2021-04-27 00:00:00\",\"2021-04-28 00:00:00\",\"2021-04-29 00:00:00\",\"2021-04-30 00:00:00\",\"2021-05-03 00:00:00\",\"2021-05-04 00:00:00\",\"2021-05-05 00:00:00\",\"2021-05-06 00:00:00\",\"2021-05-07 00:00:00\",\"2021-05-10 00:00:00\",\"2021-05-11 00:00:00\",\"2021-05-12 00:00:00\",\"2021-05-14 00:00:00\",\"2021-05-17 00:00:00\",\"2021-05-18 00:00:00\",\"2021-05-19 00:00:00\",\"2021-05-20 00:00:00\",\"2021-05-21 00:00:00\",\"2021-05-25 00:00:00\",\"2021-05-26 00:00:00\",\"2021-05-27 00:00:00\",\"2021-05-28 00:00:00\",\"2021-05-31 00:00:00\",\"2021-06-01 00:00:00\",\"2021-06-02 00:00:00\",\"2021-06-04 00:00:00\",\"2021-06-07 00:00:00\",\"2021-06-08 00:00:00\",\"2021-06-09 00:00:00\",\"2021-06-10 00:00:00\",\"2021-06-11 00:00:00\",\"2021-06-14 00:00:00\",\"2021-06-15 00:00:00\",\"2021-06-16 00:00:00\",\"2021-06-17 00:00:00\",\"2021-06-18 00:00:00\",\"2021-06-21 00:00:00\",\"2021-06-22 00:00:00\",\"2021-06-23 00:00:00\",\"2021-06-24 00:00:00\",\"2021-06-25 00:00:00\",\"2021-06-28 00:00:00\",\"2021-06-29 00:00:00\",\"2021-06-30 00:00:00\",\"2021-07-01 00:00:00\",\"2021-07-02 00:00:00\",\"2021-07-05 00:00:00\",\"2021-07-06 00:00:00\",\"2021-07-07 00:00:00\",\"2021-07-08 00:00:00\",\"2021-07-09 00:00:00\",\"2021-07-12 00:00:00\",\"2021-07-13 00:00:00\",\"2021-07-14 00:00:00\",\"2021-07-15 00:00:00\",\"2021-07-16 00:00:00\",\"2021-07-19 00:00:00\",\"2021-07-20 00:00:00\",\"2021-07-21 00:00:00\",\"2021-07-22 00:00:00\",\"2021-07-23 00:00:00\",\"2021-07-26 00:00:00\",\"2021-07-27 00:00:00\",\"2021-07-28 00:00:00\",\"2021-07-29 00:00:00\",\"2021-07-30 00:00:00\"],\"xaxis\":\"x\",\"y\":[1317,1320,1315,1323,1322,1320,1328,1320,1333,1342,1337,1340,1333,1335,1336,1339,1354,1361,1353,1354,1345,1344,1343,1354,1343,1342,1329,1314,1322,1324,1329,1342,1359,1355,1354,1349,1336,1329,1327,1341,1325,1322,1310,1332,1322,1329,1337,1332,1327,1324,1332,1327,1325,1315,1314,1308,1330,1329,1344,1347,1350,1344,1335,1345,1335,1330,1330,1339,1342,1348,1348,1344,1352,1348,1355,1353,1345,1328,1333,1323,1326,1319,1324,1314,1318,1320,1317,1314,1313,1325,1323,1307,1290,1299,1295,1299,1295,1304,1304,1300,1308,1305,1305,1296,1294,1307,1307,1301,1302,1301,1300,1309,1299,1282,1279,1277,1268,1271,1270,1257,1258,1257,1254,1252,1248,1265,1259,1258,1265,1256,1255,1247,1245,1241,1235,1226,1219,1236,1235,1227,1227,1236,1226,1226,1227,1223,1223,1220,1213,1214,1219,1218,1216,1210,1198,1192,1186,1184,1188,1197,1199,1197,1196,1213,1215,1208,1205,1210,1203,1197,1199,1206,1197,1196,1200,1197,1212,1207,1207,1205,1207,1210,1197,1202,1207,1204,1193,1187,1188,1204,1209,1209,1187,1190,1194,1210,1222,1233,1230,1228,1229,1233,1223,1242,1235,1235,1242,1234,1233,1220,1235,1237,1234,1234,1236,1228,1214,1210,1206,1210,1215,1227,1227,1229,1227,1233,1228,1228,1222,1219,1228,1223,1229,1245,1244,1248,1241,1250,1249,1249,1243,1240,1241,1249,1261,1257,1256,1273,1286,1297,1295,1283,1292,1285,1292,1299,1296,1296,1296,1296,1295,1287,1286,1283,1286,1289,1293,1304,1312,1320,1331,1324,1315,1320,1317,1319,1317,1314,1312,1314,1309,1317,1326,1329,1350,1335,1328,1337,1334,1323,1324,1310,1290,1287,1285,1290,1303,1301,1298,1308,1303,1302,1310,1314,1305,1321,1313,1319,1326,1319,1304,1303,1299,1292,1296,1287,1293,1306,1309,1302,1312,1299,1292,1277,1281,1281,1272,1277,1282,1289,1281,1283,1267,1280,1285,1288,1288,1284,1288,1294,1301,1298,1298,1284,1280,1278,1275,1276,1290,1293,1281,1285,1292,1323,1327,1345,1341,1346,1336,1335,1342,1350,1342,1356,1349,1407,1422,1432,1408,1407,1414,1397,1393,1429,1427,1393,1406,1394,1417,1419,1409,1421,1417,1410,1422,1438,1430,1427,1425,1422,1426,1425,1425,1434,1408,1443,1465,1472,1502,1501,1514,1502,1497,1520,1522,1512,1508,1507,1504,1502,1512,1534,1532,1543,1551,1535,1529,1547,1547,1528,1507,1510,1500,1496,1525,1511,1504,1500,1504,1510,1509,1525,1523,1533,1511,1500,1487,1478,1499,1503,1511,1508,1512,1514,1488,1491,1491,1496,1499,1494,1496,1491,1497,1497,1518,1495,1499,1495,1511,1513,1514,1495,1487,1487,1460,1466,1457,1463,1472,1466,1467,1476,1479,1473,1472,1461,1461,1457,1462,1458,1461,1480,1474,1480,1466,1468,1466,1471,1487,1470,1483,1479,1482,1482,1480,1488,1516,1517,1526,1549,1563,1571,1572,1554,1556,1554,1544,1554,1553,1557,1566,1559,1558,1558,1575,1586,1582,1575,1585,1584,1583,1567,1558,1571,1570,1575,1574,1569,1578,1579,1584,1602,1610,1620,1643,1677,1657,1648,1654,1612,1602,1623,1639,1655,1672,1685,1655,1660,1580,1543,1487,1536,1504,1488,1506,1526,1610,1619,1645,1620,1624,1612,1589,1607,1621,1640,1653,1657,1657,1741,1727,1731,1697,1687,1686,1707,1737,1736,1720,1714,1706,1718,1710,1698,1696,1694,1723,1710,1706,1711,1718,1744,1751,1743,1756,1739,1730,1728,1705,1731,1734,1742,1702,1711,1687,1696,1720,1728,1734,1716,1731,1734,1730,1741,1757,1768,1771,1767,1757,1780,1770,1781,1771,1776,1788,1798,1819,1818,1811,1812,1803,1814,1811,1811,1821,1844,1855,1884,1910,1945,1944,1960,1961,1964,1967,1990,2048,2063,2053,2052,1964,1943,1942,1955,1974,1997,1998,1932,1924,1954,1935,1932,1942,1964,1980,1989,1960,1938,1946,1936,1922,1945,1964,1957,1949,1956,1973,1939,1958,1907,1918,1877,1863,1864,1877,1887,1898,1896,1914,1918,1924,1891,1903,1925,1932,1902,1909,1902,1912,1919,1907,1927,1911,1917,1911,1901,1885,1878,1895,1892,1912,1907,1932,1952,1870,1876,1871,1875,1895,1893,1898,1882,1862,1878,1837,1806,1818,1817,1784,1776,1821,1828,1839,1845,1860,1875,1858,1851,1842,1838,1852,1861,1892,1886,1888,1890,1872,1889,1880,1887,1943,1953,1939,1923,1872,1846,1855,1863,1854,1840,1832,1841,1869,1862,1852,1860,1865,1838,1865,1869,1864,1837,1845,1803,1813,1839,1842,1853,1848,1821,1824,1813,1786,1779,1782,1810,1806,1795,1780,1733,1741,1732,1714,1716,1700,1694,1722,1721,1731,1712,1729,1737,1736,1734,1742,1735,1731,1732,1739,1739,1720,1688,1690,1725,1742,1735,1758,1746,1742,1752,1740,1759,1779,1777,1779,1800,1790,1776,1783,1789,1777,1762,1771,1792,1801,1784,1813,1842,1842,1833,1835,1837,1853,1871,1892,1874,1880,1888,1909,1902,1896,1908,1903,1910,1896,1895,1888,1895,1898,1889,1867,1869,1863,1790,1780,1777,1786,1789,1783,1783,1784,1763,1770,1778,1789,1789,1815,1806,1809,1812,1807,1810,1832,1829,1824,1813,1817,1812,1807,1800,1812,1807,1802,1826,1828],\"yaxis\":\"y\",\"type\":\"scatter\"}],                        {\"template\":{\"data\":{\"histogram2dcontour\":[{\"type\":\"histogram2dcontour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"choropleth\":[{\"type\":\"choropleth\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"histogram2d\":[{\"type\":\"histogram2d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmap\":[{\"type\":\"heatmap\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"heatmapgl\":[{\"type\":\"heatmapgl\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"contourcarpet\":[{\"type\":\"contourcarpet\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"contour\":[{\"type\":\"contour\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"surface\":[{\"type\":\"surface\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"},\"colorscale\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]]}],\"mesh3d\":[{\"type\":\"mesh3d\",\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}],\"scatter\":[{\"marker\":{\"line\":{\"color\":\"#283442\"}},\"type\":\"scatter\"}],\"parcoords\":[{\"type\":\"parcoords\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolargl\":[{\"type\":\"scatterpolargl\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"bar\":[{\"error_x\":{\"color\":\"#f2f5fa\"},\"error_y\":{\"color\":\"#f2f5fa\"},\"marker\":{\"line\":{\"color\":\"rgb(17,17,17)\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"bar\"}],\"scattergeo\":[{\"type\":\"scattergeo\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterpolar\":[{\"type\":\"scatterpolar\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"histogram\":[{\"marker\":{\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"histogram\"}],\"scattergl\":[{\"marker\":{\"line\":{\"color\":\"#283442\"}},\"type\":\"scattergl\"}],\"scatter3d\":[{\"type\":\"scatter3d\",\"line\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattermapbox\":[{\"type\":\"scattermapbox\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scatterternary\":[{\"type\":\"scatterternary\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"scattercarpet\":[{\"type\":\"scattercarpet\",\"marker\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}}}],\"carpet\":[{\"aaxis\":{\"endlinecolor\":\"#A2B1C6\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"minorgridcolor\":\"#506784\",\"startlinecolor\":\"#A2B1C6\"},\"baxis\":{\"endlinecolor\":\"#A2B1C6\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"minorgridcolor\":\"#506784\",\"startlinecolor\":\"#A2B1C6\"},\"type\":\"carpet\"}],\"table\":[{\"cells\":{\"fill\":{\"color\":\"#506784\"},\"line\":{\"color\":\"rgb(17,17,17)\"}},\"header\":{\"fill\":{\"color\":\"#2a3f5f\"},\"line\":{\"color\":\"rgb(17,17,17)\"}},\"type\":\"table\"}],\"barpolar\":[{\"marker\":{\"line\":{\"color\":\"rgb(17,17,17)\",\"width\":0.5},\"pattern\":{\"fillmode\":\"overlay\",\"size\":10,\"solidity\":0.2}},\"type\":\"barpolar\"}],\"pie\":[{\"automargin\":true,\"type\":\"pie\"}]},\"layout\":{\"autotypenumbers\":\"strict\",\"colorway\":[\"#636efa\",\"#EF553B\",\"#00cc96\",\"#ab63fa\",\"#FFA15A\",\"#19d3f3\",\"#FF6692\",\"#B6E880\",\"#FF97FF\",\"#FECB52\"],\"font\":{\"color\":\"#f2f5fa\"},\"hovermode\":\"closest\",\"hoverlabel\":{\"align\":\"left\"},\"paper_bgcolor\":\"rgb(17,17,17)\",\"plot_bgcolor\":\"rgb(17,17,17)\",\"polar\":{\"bgcolor\":\"rgb(17,17,17)\",\"angularaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"radialaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"}},\"ternary\":{\"bgcolor\":\"rgb(17,17,17)\",\"aaxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"baxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"},\"caxis\":{\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"ticks\":\"\"}},\"coloraxis\":{\"colorbar\":{\"outlinewidth\":0,\"ticks\":\"\"}},\"colorscale\":{\"sequential\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"sequentialminus\":[[0.0,\"#0d0887\"],[0.1111111111111111,\"#46039f\"],[0.2222222222222222,\"#7201a8\"],[0.3333333333333333,\"#9c179e\"],[0.4444444444444444,\"#bd3786\"],[0.5555555555555556,\"#d8576b\"],[0.6666666666666666,\"#ed7953\"],[0.7777777777777778,\"#fb9f3a\"],[0.8888888888888888,\"#fdca26\"],[1.0,\"#f0f921\"]],\"diverging\":[[0,\"#8e0152\"],[0.1,\"#c51b7d\"],[0.2,\"#de77ae\"],[0.3,\"#f1b6da\"],[0.4,\"#fde0ef\"],[0.5,\"#f7f7f7\"],[0.6,\"#e6f5d0\"],[0.7,\"#b8e186\"],[0.8,\"#7fbc41\"],[0.9,\"#4d9221\"],[1,\"#276419\"]]},\"xaxis\":{\"gridcolor\":\"#283442\",\"linecolor\":\"#506784\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"#283442\",\"automargin\":true,\"zerolinewidth\":2},\"yaxis\":{\"gridcolor\":\"#283442\",\"linecolor\":\"#506784\",\"ticks\":\"\",\"title\":{\"standoff\":15},\"zerolinecolor\":\"#283442\",\"automargin\":true,\"zerolinewidth\":2},\"scene\":{\"xaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\",\"gridwidth\":2},\"yaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\",\"gridwidth\":2},\"zaxis\":{\"backgroundcolor\":\"rgb(17,17,17)\",\"gridcolor\":\"#506784\",\"linecolor\":\"#506784\",\"showbackground\":true,\"ticks\":\"\",\"zerolinecolor\":\"#C8D4E3\",\"gridwidth\":2}},\"shapedefaults\":{\"line\":{\"color\":\"#f2f5fa\"}},\"annotationdefaults\":{\"arrowcolor\":\"#f2f5fa\",\"arrowhead\":0,\"arrowwidth\":1},\"geo\":{\"bgcolor\":\"rgb(17,17,17)\",\"landcolor\":\"rgb(17,17,17)\",\"subunitcolor\":\"#506784\",\"showland\":true,\"showlakes\":true,\"lakecolor\":\"rgb(17,17,17)\"},\"title\":{\"x\":0.05},\"updatemenudefaults\":{\"bgcolor\":\"#506784\",\"borderwidth\":0},\"sliderdefaults\":{\"bgcolor\":\"#C8D4E3\",\"borderwidth\":1,\"bordercolor\":\"rgb(17,17,17)\",\"tickwidth\":0},\"mapbox\":{\"style\":\"dark\"}}},\"xaxis\":{\"anchor\":\"y\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"DateTime\"}},\"yaxis\":{\"anchor\":\"x\",\"domain\":[0.0,1.0],\"title\":{\"text\":\"Gold\"}},\"legend\":{\"tracegroupgap\":0},\"title\":{\"text\":\"Precious metal prices 2018-2021\"}},                        {\"responsive\": true}                    ).then(function(){\n",
       "                            \n",
       "var gd = document.getElementById('9b8dba7b-03e5-4a73-bbe7-551095ec55bd');\n",
       "var x = new MutationObserver(function (mutations, observer) {{\n",
       "        var display = window.getComputedStyle(gd).display;\n",
       "        if (!display || display === 'none') {{\n",
       "            console.log([gd, 'removed!']);\n",
       "            Plotly.purge(gd);\n",
       "            observer.disconnect();\n",
       "        }}\n",
       "}});\n",
       "\n",
       "// Listen for the removal of the full notebook cells\n",
       "var notebookContainer = gd.closest('#notebook-container');\n",
       "if (notebookContainer) {{\n",
       "    x.observe(notebookContainer, {childList: true});\n",
       "}}\n",
       "\n",
       "// Listen for the clearing of the current output cell\n",
       "var outputEl = gd.closest('.output');\n",
       "if (outputEl) {{\n",
       "    x.observe(outputEl, {childList: true});\n",
       "}}\n",
       "\n",
       "                        })                };                });            </script>        </div>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Example 3: customising plot appearance\n",
    "\n",
    "\"\"\"\n",
    "I'm assuming without testing, that we can use any figure generating software to make the base plot used in dash apps\n",
    "E.g., Matplotlib, Seaborn, plotly, plotly.express\n",
    "One way of customising plotly based figures is to use plotly style templates.\n",
    "To see the templates, and the default - we can load up the plotly.io module and print the templates object\n",
    "\"\"\"\n",
    "\n",
    "# These are available templates\n",
    "import plotly.io as pio\n",
    "print(pio.templates)\n",
    "\n",
    "# Change the default from plotly to plotly_dark\n",
    "pio.templates.default = 'plotly_dark'\n",
    "\n",
    "figure2 = px.line(metal_prices, x = \"DateTime\", y = \"Gold\", title = \"Precious metal prices 2018-2021\")\n",
    "figure2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Example 3 cont: customising plot appearance. We can also update figures without changing the default template.\n",
    "\n",
    "# Reset default to original\n",
    "pio.templates.default = 'plotly'\n",
    "\n",
    "import dash\n",
    "from dash import html\n",
    "from dash import dcc\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "\n",
    "metal_prices = pd.read_csv('data/precious_metals_prices_2018_2021.csv', usecols=[\"DateTime\",\"Gold\"])\n",
    "\n",
    "# Many plot features can be defined here in the constructor, and some have to be\n",
    "# But a nice way of doing it is to keep it simple here\n",
    "figure1 = px.line(\n",
    "    metal_prices, \n",
    "    title = \"Precious metal prices 2018-2021\",\n",
    "    x = \"DateTime\", \n",
    "    y = [\"Gold\"],\n",
    "    color_discrete_map={\"Gold\":\"gold\"})\n",
    "\n",
    "# And then use update layout to edit the figure\n",
    "figure1.update_layout(\n",
    "    template=\"plotly_dark\",\n",
    "    yaxis_title=\"Price (USD/oz)\",\n",
    "    xaxis_title=\"Date\",\n",
    "    font=dict(\n",
    "        family=\"Verdana, sans-serif\",\n",
    "        size=10,\n",
    "        color=\"white\"\n",
    "    )\n",
    ")\n",
    "\n",
    "app = dash.Dash(__name__)\n",
    "app.title = \"Precious metal prices 2018-2021\"\n",
    "\n",
    "app.layout = html.Div(\n",
    "    id=\"app-container\",\n",
    "    children=[\n",
    "        html.H1(\"Precious metal prices 2018-2021\"),\n",
    "        html.P(\"Results in USD/oz\"),\n",
    "        dcc.Graph(figure=figure1)]\n",
    ")\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Example 4: Style arguments with CSS \n",
    "\n",
    "import dash\n",
    "from dash import html\n",
    "from dash import dcc\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "\n",
    "metal_prices = pd.read_csv('data/precious_metals_prices_2018_2021.csv', usecols=[\"DateTime\",\"Gold\"])\n",
    "\n",
    "figure1 = px.line(\n",
    "    metal_prices, \n",
    "    title = \"Precious metal prices 2018-2021\",\n",
    "    x = \"DateTime\", \n",
    "    y = [\"Gold\"],\n",
    "    color_discrete_map={\"Gold\":\"gold\"})\n",
    "\n",
    "figure1.update_layout(\n",
    "    template=\"plotly_dark\",\n",
    "    yaxis_title=\"Price (USD/oz)\",\n",
    "    xaxis_title=\"Date\",\n",
    "    font=dict(\n",
    "        family=\"Verdana, sans-serif\",\n",
    "        size=10,\n",
    "        color=\"white\"\n",
    "    )\n",
    ")\n",
    "\n",
    "app = dash.Dash(__name__)\n",
    "app.title = \"Precious metal prices 2018-2021\"\n",
    "\n",
    "# Significant update to labelling of layout section\n",
    "# We can use CSS in here to update the look of our dashboard\n",
    "# Actually camel case not CSS - as we can't have hypens\n",
    "\n",
    "app.layout = html.Div(\n",
    "    id=\"app-container\",\n",
    "    children=[\n",
    "        html.Div(\n",
    "            id=\"header-area\",\n",
    "            # Example of a CSS style addition in the next line\n",
    "            style={\"backgroundColor\": \"black\"},\n",
    "            children=[\n",
    "                html.H1(\n",
    "                    id=\"header-title\",\n",
    "                    style={\"color\": \"white\", \"fontFamily\": \"Verdana, sans-serif\"},\n",
    "                    children=\"Precious Metal Prices\",\n",
    "\n",
    "                ),\n",
    "                html.P(\n",
    "                    id=\"header-description\",\n",
    "                    style={\"color\": \"white\", \"fontFamily\": \"Verdana, sans-serif\"},\n",
    "                    children=(\"The cost of precious metals\", html.Br(), \"between 2018 and 2021\"),\n",
    "                ),\n",
    "            ],\n",
    "        ),\n",
    "        html.Div(\n",
    "            id=\"graph-container\",\n",
    "            children=dcc.Graph(\n",
    "                id=\"price-chart\",\n",
    "                figure=figure1,\n",
    "                config={\"displayModeBar\": False}\n",
    "            ),\n",
    "        ),\n",
    "    ]\n",
    ")\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### From CSS / camelcase additions to external stylesheets\n",
    "\n",
    "- The example we've seen is powerful for a few rules, but inefficient and unweildy for larger apps\n",
    "- Instead we can add external style sheets\n",
    "- Dash will by default search for \"assets\" in a folder of that name (favicon, style sheets, etc.)\n",
    "- We now have that folder in the main directory\n",
    "- No changes are needed to apply that to the code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Example 5: External style assets\n",
    "\n",
    "import dash\n",
    "from dash import html\n",
    "from dash import dcc\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "\n",
    "metal_prices = pd.read_csv('data/precious_metals_prices_2018_2021.csv', usecols=[\"DateTime\",\"Gold\"])\n",
    "\n",
    "figure1 = px.line(\n",
    "    metal_prices, \n",
    "    title = \"Precious metal prices 2018-2021\",\n",
    "    x = \"DateTime\", \n",
    "    y = [\"Gold\"],\n",
    "    color_discrete_map={\"Gold\":\"gold\"})\n",
    "\n",
    "figure1.update_layout(\n",
    "    template=\"plotly_dark\",\n",
    "    yaxis_title=\"Price (USD/oz)\",\n",
    "    xaxis_title=\"Date\",\n",
    "    font=dict(\n",
    "        family=\"Verdana, sans-serif\",\n",
    "        size=10,\n",
    "        color=\"white\"\n",
    "    )\n",
    ")\n",
    "\n",
    "app = dash.Dash(__name__)\n",
    "app.title = \"Precious metal prices 2018-2021\"\n",
    "\n",
    "# Significant update to labelling of layout section\n",
    "# We can use CSS in here to update the look of our dashboard\n",
    "# Actually camel case not CSS - as we can't have hypens\n",
    "\n",
    "app.layout = html.Div(\n",
    "    id=\"app-container\",\n",
    "    children=[\n",
    "        html.Div(\n",
    "            id=\"header-area\",\n",
    "            # Example of a CSS style addition in the next line\n",
    "            style={\"backgroundColor\": \"black\"},\n",
    "            children=[\n",
    "                html.H1(\n",
    "                    id=\"header-title\",\n",
    "                    style={\"color\": \"white\", \"fontFamily\": \"Verdana, sans-serif\"},\n",
    "                    children=\"Precious Metal Prices\",\n",
    "\n",
    "                ),\n",
    "                html.P(\n",
    "                    id=\"header-description\",\n",
    "                    style={\"color\": \"white\", \"fontFamily\": \"Verdana, sans-serif\"},\n",
    "                    children=(\"The cost of precious metals\", html.Br(), \"between 2018 and 2021\"),\n",
    "                ),\n",
    "            ],\n",
    "        ),\n",
    "        html.Div(\n",
    "            id=\"graph-container\",\n",
    "            children=dcc.Graph(\n",
    "                id=\"price-chart\",\n",
    "                figure=figure1,\n",
    "                config={\"displayModeBar\": False}\n",
    "            ),\n",
    "        ),\n",
    "    ]\n",
    ")\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app.run_server(debug=True)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Example 6: Making dash apps interactive. Callbacks.\n",
    "\n",
    "\"\"\"\n",
    "Callbacks are used in Dash to make apps interactive.\n",
    "These are Python functions that are automatically run by Dash when input values are alterred.\n",
    "\n",
    "Note that for this example to render properly we should change the name of the assets folder -\n",
    "as currently Dash will be looking in there for favicon and CSS style elements that we don't want here.\n",
    "\"\"\"\n",
    "\n",
    "import dash\n",
    "from dash import dcc\n",
    "from dash import html\n",
    "from dash.dependencies import Input, Output\n",
    "\n",
    "app = dash.Dash(__name__)\n",
    "\n",
    "app.layout = html.Div([\n",
    "    html.H6(\"Change the value in the text box to see callbacks in action!\"),\n",
    "    html.Div([\n",
    "        \"Input: \",\n",
    "        dcc.Input(id='my-input', value='initial value', type='text')\n",
    "    ]),\n",
    "    html.Br(),\n",
    "    html.Div(id='my-output'),\n",
    "\n",
    "])\n",
    "\n",
    "@app.callback(\n",
    "    Output(component_id='my-output', component_property='children'),\n",
    "    Input(component_id='my-input', component_property='value')\n",
    ")\n",
    "def update_output_div(input_value):\n",
    "    return 'Output: {}'.format(input_value)\n",
    "\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"100%\"\n",
       "            height=\"650\"\n",
       "            src=\"http://127.0.0.1:8050/\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "            \n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x7f2f7c201d50>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Example 7: Making dash apps interactive. Dropdowns, and adding callbacks for the type of metal and the range of dates\n",
    "\n",
    "import dash\n",
    "from dash import dcc\n",
    "from dash import html\n",
    "# Required to make callbacks\n",
    "from dash.dependencies import Output, Input\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "\n",
    "# Read in the data\n",
    "data = pd.read_csv(\"data/precious_metals_prices_2018_2021.csv\")\n",
    "\n",
    "# Ensure DateTime is actually a pandas datetime object\n",
    "data[\"DateTime\"] = pd.to_datetime(data[\"DateTime\"], format=\"%Y-%m-%d\")\n",
    "\n",
    "# Create a plotly plot for use by dcc.Graph()\n",
    "\n",
    "fig = px.line(\n",
    "    data,\n",
    "    title=\"Precious Metal Prices 2018-2021\",\n",
    "    x=\"DateTime\",\n",
    "    y=[\"Gold\"],\n",
    "    color_discrete_map={\"Gold\": \"gold\"}\n",
    ")\n",
    "\n",
    "app = dash.Dash(__name__)\n",
    "app.title = \"Precious Metal Prices 2018-2021\"\n",
    "\n",
    "\"\"\"\n",
    "Below we add a drop down and date range selector. These won't automatically allow interactive data access.\n",
    "For this we need callbacks, which are defined at the end. \n",
    "\"\"\"\n",
    "app.layout = html.Div(\n",
    "    id=\"app-container\",\n",
    "    children=[\n",
    "        html.Div(\n",
    "            id=\"header-area\",\n",
    "            children=[\n",
    "                html.H1(\n",
    "                    id=\"header-title\",\n",
    "                    children=\"Precious Metal Prices\",\n",
    "\n",
    "                ),\n",
    "                html.P(\n",
    "                    id=\"header-description\",\n",
    "                    children=(\"The cost of precious metals\", html.Br(), \"between 2018 and 2021\"),\n",
    "                ),\n",
    "            ],\n",
    "        ),\n",
    "        html.Div(\n",
    "            id=\"menu-area\",\n",
    "            children=[\n",
    "                html.Div(\n",
    "                    children=[\n",
    "                        html.Div(\n",
    "                            className=\"menu-title\",\n",
    "                            children=\"Metal\"\n",
    "                        ),\n",
    "                        dcc.Dropdown(\n",
    "                            id=\"metal-filter\",\n",
    "                            className=\"dropdown\",\n",
    "                            options=[{\"label\": metal, \"value\": metal} for metal in data.columns[1:]],\n",
    "                            clearable=False,\n",
    "                            # Set default value to gold\n",
    "                            value=\"Gold\"\n",
    "\n",
    "                        )\n",
    "                    ]\n",
    "                )\n",
    "            ]\n",
    "        ),\n",
    "        html.Div(\n",
    "                    children=[\n",
    "                        html.Div(\n",
    "                            className=\"menu-title\",\n",
    "                            children=\"Date Range\"\n",
    "                        ),\n",
    "                        dcc.DatePickerRange(\n",
    "                            id=\"date-range\",\n",
    "                            min_date_allowed=data.DateTime.min().date(),\n",
    "                            max_date_allowed=data.DateTime.max().date(),\n",
    "                            start_date=data.DateTime.min().date(),\n",
    "                            end_date=data.DateTime.max().date()\n",
    "                        )\n",
    "                    ]\n",
    "                ),\n",
    "        html.Div(\n",
    "            id=\"graph-container\",\n",
    "            children=dcc.Graph(\n",
    "                id=\"price-chart\",\n",
    "                figure=fig,\n",
    "                config={\"displayModeBar\": False}\n",
    "            ),\n",
    "        ),\n",
    "    ]\n",
    ")\n",
    "\n",
    "# A decorator is used to make a callback\n",
    "\n",
    "@app.callback(\n",
    "    Output(\"price-chart\",\"figure\"),\n",
    "    Input(\"metal-filter\", \"value\"),\n",
    "    Input(\"date-range\",\"start_date\"),\n",
    "    Input(\"date-range\", \"end_date\")\n",
    ")\n",
    "\n",
    "# Then the function to update the chart based on the input to the callback\n",
    "\n",
    "def update_chart(metal,start_date,end_date):\n",
    "    \n",
    "    # Set two conditions to select date range\n",
    "    filtered_data = data.loc[(data.DateTime >= start_date) & (data.DateTime <= end_date)]\n",
    "\n",
    "    fig = px.line(\n",
    "    filtered_data,\n",
    "    title=\"Precious Metal Prices 2018-2021\",\n",
    "    x=\"DateTime\",\n",
    "    y=[metal],\n",
    "    color_discrete_map={\n",
    "        \"Gold\": \"gold\",    \n",
    "        \"Platinum\": \"#E5E4E2\",\n",
    "        \"Silver\": \"silver\",\n",
    "        \"Palladium\": \"#CED0DD\",\n",
    "        \"Rhodium\": \"#E2E7E1\",\n",
    "        \"Iridium\": \"#3D3C3A\",\n",
    "        \"Ruthenium\": \"#C9CBC8\"\n",
    "    }\n",
    "    )\n",
    "    fig.update_layout(\n",
    "        template=\"plotly_dark\",\n",
    "        xaxis_title=\"Date\",\n",
    "        yaxis_title=\"Price (USD/oz)\",\n",
    "        font=dict(\n",
    "            family=\"Verdana, sans-serif\",\n",
    "            size=18,\n",
    "            color=\"white\"\n",
    "        ),\n",
    "    )\n",
    "\n",
    "    return fig\n",
    "\n",
    "if __name__ == \"__main__\":\n",
    "    app.run_server(debug=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Deploying a Dash app to a cloud host\n",
    "\n",
    "## The course example used Heroku\n",
    "\n",
    "The complete set of steps for Heroku is available on Plotlys website:\n",
    "\n",
    "https://dash.plotly.com/deployment\n",
    "\n",
    "However, Heroku no longer has a free tier. \n",
    "\n",
    "AWS Elastic Beanstalk is another option, but need to set it up with card details etc.\n",
    "\n",
    "## Render for hosting Dash apps\n",
    "\n",
    "- Make Render account\n",
    "- Create app script. Insert the following after the app definition line:\n",
    "`server = app.server`\n",
    "- Make requirements.txt file (will be installed on Render service by pip)\n",
    "- git init, add, and commit\n",
    "- gh repo create and push\n",
    "- On Render, go to dashboard, click new web service, enter a public github repo link\n",
    "- change start command: `gunicorn app:server`\n",
    "- follow the rest of the commands, and:\n",
    "[**Here it is!**](https://dash-cloud-aa2t.onrender.com)\n",
    "- To update it, make the commit and then on the Render web service page, click \"manual deploy -> deploy latest commit\"\n",
    "- Note that Render free services spin down after 15 minutes without traffic, and spin up again -> so there would be high latency if someone was to visit this when inactive.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "        <iframe\n",
       "            width=\"100%\"\n",
       "            height=\"650\"\n",
       "            src=\"http://127.0.0.1:8050/\"\n",
       "            frameborder=\"0\"\n",
       "            allowfullscreen\n",
       "            \n",
       "        ></iframe>\n",
       "        "
      ],
      "text/plain": [
       "<IPython.lib.display.IFrame at 0x7f2f5c397650>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "\"\"\"\n",
    "More on Dashboard layout...\n",
    "\n",
    "Panelled dashboards with Dash\n",
    "\n",
    "To achieve panelled dashboards, it's all in the layout.\n",
    "Layout is a heirarchical tree.\n",
    "HTML sections should be properly labelled and formatted for readability.\n",
    "Then make sections within sections.\n",
    "Here, one parent section holds the two graph sections. \n",
    "The parent section is set to row (flex-direction).\n",
    "\n",
    "\"\"\"\n",
    "\n",
    "from dash import Dash, html, dcc\n",
    "import plotly.express as px\n",
    "import pandas as pd\n",
    "\n",
    "app = Dash(__name__)\n",
    "\n",
    "df = pd.DataFrame({\n",
    "    \"Fruit\": [\"Apples\", \"Oranges\", \"Bananas\", \"Apples\", \"Oranges\", \"Bananas\"],\n",
    "    \"Amount\": [4, 1, 2, 2, 4, 5],\n",
    "    \"City\": [\"SF\", \"SF\", \"SF\", \"Montreal\", \"Montreal\", \"Montreal\"]\n",
    "})\n",
    "\n",
    "fig = px.bar(df, x=\"Fruit\", y=\"Amount\", color=\"City\", barmode=\"group\")\n",
    "\n",
    "app.layout = html.Div(\n",
    "    id=\"app-container\",\n",
    "    children=[\n",
    "        html.Div(\n",
    "            id=\"left-panel\",\n",
    "            children=[\n",
    "                dcc.Graph(\n",
    "                    id='left-graph',\n",
    "                    figure=fig\n",
    "                ),\n",
    "            ],\n",
    "        style={'padding': 10, 'flex': 1}\n",
    "        ),\n",
    "\n",
    "        html.Div(\n",
    "            id=\"right-panel\",\n",
    "            children=[\n",
    "                dcc.Graph(\n",
    "                    id='right-graph',\n",
    "                    figure=fig\n",
    "                )\n",
    "            ], \n",
    "        style={'padding': 10, 'flex': 1}\n",
    "        )\n",
    "    ],\n",
    "    style={'display': 'flex', 'flex-direction': 'row', 'background-color': 'blue'}\n",
    ")\n",
    "\n",
    "if __name__ == '__main__':\n",
    "    app.run(debug=True)\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "python-data-science",
   "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.7.15"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}