scraping_stock_data.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPzNzV3Ak1+N82mOKFa8vZm",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/JosueAfouda/TUTORIALS/blob/main/scraping_stock_data.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# <center> Web Scraping des données boursières des entreprises du S&P500, CAC40, DAX, FTSE100 et NIKKEI225"
      ],
      "metadata": {
        "id": "TSyMsUsmUz-s"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "QeRIM8gOTtX7"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import requests\n",
        "from bs4 import BeautifulSoup"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "# SP500"
      ],
      "metadata": {
        "id": "STp-TqyzX7n7"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_html(\"https://en.wikipedia.org/wiki/List_of_S%26P_500_companies\")[0]\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "pU3M4N5ZX7Pc",
        "outputId": "c4684f85-60ea-4b81-cb14-34d512c77bba"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Symbol              Security             GICS Sector  \\\n",
              "0      MMM                    3M             Industrials   \n",
              "1      AOS           A. O. Smith             Industrials   \n",
              "2      ABT                Abbott             Health Care   \n",
              "3     ABBV                AbbVie             Health Care   \n",
              "4      ACN             Accenture  Information Technology   \n",
              "..     ...                   ...                     ...   \n",
              "498    YUM           Yum! Brands  Consumer Discretionary   \n",
              "499   ZBRA    Zebra Technologies  Information Technology   \n",
              "500    ZBH         Zimmer Biomet             Health Care   \n",
              "501   ZION  Zions Bancorporation              Financials   \n",
              "502    ZTS                Zoetis             Health Care   \n",
              "\n",
              "                      GICS Sub-Industry    Headquarters Location  Date added  \\\n",
              "0              Industrial Conglomerates    Saint Paul, Minnesota  1957-03-04   \n",
              "1                     Building Products     Milwaukee, Wisconsin  2017-07-26   \n",
              "2                 Health Care Equipment  North Chicago, Illinois  1957-03-04   \n",
              "3                       Pharmaceuticals  North Chicago, Illinois  2012-12-31   \n",
              "4        IT Consulting & Other Services          Dublin, Ireland  2011-07-06   \n",
              "..                                  ...                      ...         ...   \n",
              "498                         Restaurants     Louisville, Kentucky  1997-10-06   \n",
              "499  Electronic Equipment & Instruments   Lincolnshire, Illinois  2019-12-23   \n",
              "500               Health Care Equipment          Warsaw, Indiana  2001-08-07   \n",
              "501                      Regional Banks     Salt Lake City, Utah  2001-06-22   \n",
              "502                     Pharmaceuticals   Parsippany, New Jersey  2013-06-21   \n",
              "\n",
              "         CIK      Founded  \n",
              "0      66740         1902  \n",
              "1      91142         1916  \n",
              "2       1800         1888  \n",
              "3    1551152  2013 (1888)  \n",
              "4    1467373         1989  \n",
              "..       ...          ...  \n",
              "498  1041061         1997  \n",
              "499   877212         1969  \n",
              "500  1136869         1927  \n",
              "501   109380         1873  \n",
              "502  1555280         1952  \n",
              "\n",
              "[503 rows x 8 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1c0b427b-dd32-4aec-8d05-0f5b7f717709\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Symbol</th>\n",
              "      <th>Security</th>\n",
              "      <th>GICS Sector</th>\n",
              "      <th>GICS Sub-Industry</th>\n",
              "      <th>Headquarters Location</th>\n",
              "      <th>Date added</th>\n",
              "      <th>CIK</th>\n",
              "      <th>Founded</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>MMM</td>\n",
              "      <td>3M</td>\n",
              "      <td>Industrials</td>\n",
              "      <td>Industrial Conglomerates</td>\n",
              "      <td>Saint Paul, Minnesota</td>\n",
              "      <td>1957-03-04</td>\n",
              "      <td>66740</td>\n",
              "      <td>1902</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>AOS</td>\n",
              "      <td>A. O. Smith</td>\n",
              "      <td>Industrials</td>\n",
              "      <td>Building Products</td>\n",
              "      <td>Milwaukee, Wisconsin</td>\n",
              "      <td>2017-07-26</td>\n",
              "      <td>91142</td>\n",
              "      <td>1916</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>ABT</td>\n",
              "      <td>Abbott</td>\n",
              "      <td>Health Care</td>\n",
              "      <td>Health Care Equipment</td>\n",
              "      <td>North Chicago, Illinois</td>\n",
              "      <td>1957-03-04</td>\n",
              "      <td>1800</td>\n",
              "      <td>1888</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>ABBV</td>\n",
              "      <td>AbbVie</td>\n",
              "      <td>Health Care</td>\n",
              "      <td>Pharmaceuticals</td>\n",
              "      <td>North Chicago, Illinois</td>\n",
              "      <td>2012-12-31</td>\n",
              "      <td>1551152</td>\n",
              "      <td>2013 (1888)</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>ACN</td>\n",
              "      <td>Accenture</td>\n",
              "      <td>Information Technology</td>\n",
              "      <td>IT Consulting &amp; Other Services</td>\n",
              "      <td>Dublin, Ireland</td>\n",
              "      <td>2011-07-06</td>\n",
              "      <td>1467373</td>\n",
              "      <td>1989</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>498</th>\n",
              "      <td>YUM</td>\n",
              "      <td>Yum! Brands</td>\n",
              "      <td>Consumer Discretionary</td>\n",
              "      <td>Restaurants</td>\n",
              "      <td>Louisville, Kentucky</td>\n",
              "      <td>1997-10-06</td>\n",
              "      <td>1041061</td>\n",
              "      <td>1997</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>499</th>\n",
              "      <td>ZBRA</td>\n",
              "      <td>Zebra Technologies</td>\n",
              "      <td>Information Technology</td>\n",
              "      <td>Electronic Equipment &amp; Instruments</td>\n",
              "      <td>Lincolnshire, Illinois</td>\n",
              "      <td>2019-12-23</td>\n",
              "      <td>877212</td>\n",
              "      <td>1969</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>500</th>\n",
              "      <td>ZBH</td>\n",
              "      <td>Zimmer Biomet</td>\n",
              "      <td>Health Care</td>\n",
              "      <td>Health Care Equipment</td>\n",
              "      <td>Warsaw, Indiana</td>\n",
              "      <td>2001-08-07</td>\n",
              "      <td>1136869</td>\n",
              "      <td>1927</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>501</th>\n",
              "      <td>ZION</td>\n",
              "      <td>Zions Bancorporation</td>\n",
              "      <td>Financials</td>\n",
              "      <td>Regional Banks</td>\n",
              "      <td>Salt Lake City, Utah</td>\n",
              "      <td>2001-06-22</td>\n",
              "      <td>109380</td>\n",
              "      <td>1873</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>502</th>\n",
              "      <td>ZTS</td>\n",
              "      <td>Zoetis</td>\n",
              "      <td>Health Care</td>\n",
              "      <td>Pharmaceuticals</td>\n",
              "      <td>Parsippany, New Jersey</td>\n",
              "      <td>2013-06-21</td>\n",
              "      <td>1555280</td>\n",
              "      <td>1952</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>503 rows × 8 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1c0b427b-dd32-4aec-8d05-0f5b7f717709')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-1c0b427b-dd32-4aec-8d05-0f5b7f717709 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-1c0b427b-dd32-4aec-8d05-0f5b7f717709');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-3ed14e35-5b1e-4ef5-9fec-a9ff496a023d\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3ed14e35-5b1e-4ef5-9fec-a9ff496a023d')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-3ed14e35-5b1e-4ef5-9fec-a9ff496a023d button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "type(df)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bvoevbHYYF5y",
        "outputId": "7c576fd8-5435-4581-ccdf-0e1d23730df3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "pandas.core.frame.DataFrame"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "tickers = df['Symbol'].to_list()\n",
        "tickers"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3HLHpSukYI8Y",
        "outputId": "ce861d7e-545a-474e-d608-b478d7623210"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['MMM',\n",
              " 'AOS',\n",
              " 'ABT',\n",
              " 'ABBV',\n",
              " 'ACN',\n",
              " 'ADM',\n",
              " 'ADBE',\n",
              " 'ADP',\n",
              " 'AES',\n",
              " 'AFL',\n",
              " 'A',\n",
              " 'ABNB',\n",
              " 'APD',\n",
              " 'AKAM',\n",
              " 'ALK',\n",
              " 'ALB',\n",
              " 'ARE',\n",
              " 'ALGN',\n",
              " 'ALLE',\n",
              " 'LNT',\n",
              " 'ALL',\n",
              " 'GOOGL',\n",
              " 'GOOG',\n",
              " 'MO',\n",
              " 'AMZN',\n",
              " 'AMCR',\n",
              " 'AMD',\n",
              " 'AEE',\n",
              " 'AAL',\n",
              " 'AEP',\n",
              " 'AXP',\n",
              " 'AIG',\n",
              " 'AMT',\n",
              " 'AWK',\n",
              " 'AMP',\n",
              " 'AME',\n",
              " 'AMGN',\n",
              " 'APH',\n",
              " 'ADI',\n",
              " 'ANSS',\n",
              " 'AON',\n",
              " 'APA',\n",
              " 'AAPL',\n",
              " 'AMAT',\n",
              " 'APTV',\n",
              " 'ACGL',\n",
              " 'ANET',\n",
              " 'AJG',\n",
              " 'AIZ',\n",
              " 'T',\n",
              " 'ATO',\n",
              " 'ADSK',\n",
              " 'AZO',\n",
              " 'AVB',\n",
              " 'AVY',\n",
              " 'AXON',\n",
              " 'BKR',\n",
              " 'BALL',\n",
              " 'BAC',\n",
              " 'BBWI',\n",
              " 'BAX',\n",
              " 'BDX',\n",
              " 'WRB',\n",
              " 'BRK.B',\n",
              " 'BBY',\n",
              " 'BIO',\n",
              " 'TECH',\n",
              " 'BIIB',\n",
              " 'BLK',\n",
              " 'BX',\n",
              " 'BK',\n",
              " 'BA',\n",
              " 'BKNG',\n",
              " 'BWA',\n",
              " 'BXP',\n",
              " 'BSX',\n",
              " 'BMY',\n",
              " 'AVGO',\n",
              " 'BR',\n",
              " 'BRO',\n",
              " 'BF.B',\n",
              " 'BG',\n",
              " 'CHRW',\n",
              " 'CDNS',\n",
              " 'CZR',\n",
              " 'CPT',\n",
              " 'CPB',\n",
              " 'COF',\n",
              " 'CAH',\n",
              " 'KMX',\n",
              " 'CCL',\n",
              " 'CARR',\n",
              " 'CTLT',\n",
              " 'CAT',\n",
              " 'CBOE',\n",
              " 'CBRE',\n",
              " 'CDW',\n",
              " 'CE',\n",
              " 'COR',\n",
              " 'CNC',\n",
              " 'CNP',\n",
              " 'CDAY',\n",
              " 'CF',\n",
              " 'CRL',\n",
              " 'SCHW',\n",
              " 'CHTR',\n",
              " 'CVX',\n",
              " 'CMG',\n",
              " 'CB',\n",
              " 'CHD',\n",
              " 'CI',\n",
              " 'CINF',\n",
              " 'CTAS',\n",
              " 'CSCO',\n",
              " 'C',\n",
              " 'CFG',\n",
              " 'CLX',\n",
              " 'CME',\n",
              " 'CMS',\n",
              " 'KO',\n",
              " 'CTSH',\n",
              " 'CL',\n",
              " 'CMCSA',\n",
              " 'CMA',\n",
              " 'CAG',\n",
              " 'COP',\n",
              " 'ED',\n",
              " 'STZ',\n",
              " 'CEG',\n",
              " 'COO',\n",
              " 'CPRT',\n",
              " 'GLW',\n",
              " 'CTVA',\n",
              " 'CSGP',\n",
              " 'COST',\n",
              " 'CTRA',\n",
              " 'CCI',\n",
              " 'CSX',\n",
              " 'CMI',\n",
              " 'CVS',\n",
              " 'DHI',\n",
              " 'DHR',\n",
              " 'DRI',\n",
              " 'DVA',\n",
              " 'DE',\n",
              " 'DAL',\n",
              " 'XRAY',\n",
              " 'DVN',\n",
              " 'DXCM',\n",
              " 'FANG',\n",
              " 'DLR',\n",
              " 'DFS',\n",
              " 'DIS',\n",
              " 'DG',\n",
              " 'DLTR',\n",
              " 'D',\n",
              " 'DPZ',\n",
              " 'DOV',\n",
              " 'DOW',\n",
              " 'DTE',\n",
              " 'DUK',\n",
              " 'DD',\n",
              " 'EMN',\n",
              " 'ETN',\n",
              " 'EBAY',\n",
              " 'ECL',\n",
              " 'EIX',\n",
              " 'EW',\n",
              " 'EA',\n",
              " 'ELV',\n",
              " 'LLY',\n",
              " 'EMR',\n",
              " 'ENPH',\n",
              " 'ETR',\n",
              " 'EOG',\n",
              " 'EPAM',\n",
              " 'EQT',\n",
              " 'EFX',\n",
              " 'EQIX',\n",
              " 'EQR',\n",
              " 'ESS',\n",
              " 'EL',\n",
              " 'ETSY',\n",
              " 'EG',\n",
              " 'EVRG',\n",
              " 'ES',\n",
              " 'EXC',\n",
              " 'EXPE',\n",
              " 'EXPD',\n",
              " 'EXR',\n",
              " 'XOM',\n",
              " 'FFIV',\n",
              " 'FDS',\n",
              " 'FICO',\n",
              " 'FAST',\n",
              " 'FRT',\n",
              " 'FDX',\n",
              " 'FITB',\n",
              " 'FSLR',\n",
              " 'FE',\n",
              " 'FIS',\n",
              " 'FI',\n",
              " 'FLT',\n",
              " 'FMC',\n",
              " 'F',\n",
              " 'FTNT',\n",
              " 'FTV',\n",
              " 'FOXA',\n",
              " 'FOX',\n",
              " 'BEN',\n",
              " 'FCX',\n",
              " 'GRMN',\n",
              " 'IT',\n",
              " 'GEHC',\n",
              " 'GEN',\n",
              " 'GNRC',\n",
              " 'GD',\n",
              " 'GE',\n",
              " 'GIS',\n",
              " 'GM',\n",
              " 'GPC',\n",
              " 'GILD',\n",
              " 'GL',\n",
              " 'GPN',\n",
              " 'GS',\n",
              " 'HAL',\n",
              " 'HIG',\n",
              " 'HAS',\n",
              " 'HCA',\n",
              " 'PEAK',\n",
              " 'HSIC',\n",
              " 'HSY',\n",
              " 'HES',\n",
              " 'HPE',\n",
              " 'HLT',\n",
              " 'HOLX',\n",
              " 'HD',\n",
              " 'HON',\n",
              " 'HRL',\n",
              " 'HST',\n",
              " 'HWM',\n",
              " 'HPQ',\n",
              " 'HUBB',\n",
              " 'HUM',\n",
              " 'HBAN',\n",
              " 'HII',\n",
              " 'IBM',\n",
              " 'IEX',\n",
              " 'IDXX',\n",
              " 'ITW',\n",
              " 'ILMN',\n",
              " 'INCY',\n",
              " 'IR',\n",
              " 'PODD',\n",
              " 'INTC',\n",
              " 'ICE',\n",
              " 'IFF',\n",
              " 'IP',\n",
              " 'IPG',\n",
              " 'INTU',\n",
              " 'ISRG',\n",
              " 'IVZ',\n",
              " 'INVH',\n",
              " 'IQV',\n",
              " 'IRM',\n",
              " 'JBHT',\n",
              " 'JKHY',\n",
              " 'J',\n",
              " 'JNJ',\n",
              " 'JCI',\n",
              " 'JPM',\n",
              " 'JNPR',\n",
              " 'K',\n",
              " 'KVUE',\n",
              " 'KDP',\n",
              " 'KEY',\n",
              " 'KEYS',\n",
              " 'KMB',\n",
              " 'KIM',\n",
              " 'KMI',\n",
              " 'KLAC',\n",
              " 'KHC',\n",
              " 'KR',\n",
              " 'LHX',\n",
              " 'LH',\n",
              " 'LRCX',\n",
              " 'LW',\n",
              " 'LVS',\n",
              " 'LDOS',\n",
              " 'LEN',\n",
              " 'LIN',\n",
              " 'LYV',\n",
              " 'LKQ',\n",
              " 'LMT',\n",
              " 'L',\n",
              " 'LOW',\n",
              " 'LULU',\n",
              " 'LYB',\n",
              " 'MTB',\n",
              " 'MRO',\n",
              " 'MPC',\n",
              " 'MKTX',\n",
              " 'MAR',\n",
              " 'MMC',\n",
              " 'MLM',\n",
              " 'MAS',\n",
              " 'MA',\n",
              " 'MTCH',\n",
              " 'MKC',\n",
              " 'MCD',\n",
              " 'MCK',\n",
              " 'MDT',\n",
              " 'MRK',\n",
              " 'META',\n",
              " 'MET',\n",
              " 'MTD',\n",
              " 'MGM',\n",
              " 'MCHP',\n",
              " 'MU',\n",
              " 'MSFT',\n",
              " 'MAA',\n",
              " 'MRNA',\n",
              " 'MHK',\n",
              " 'MOH',\n",
              " 'TAP',\n",
              " 'MDLZ',\n",
              " 'MPWR',\n",
              " 'MNST',\n",
              " 'MCO',\n",
              " 'MS',\n",
              " 'MOS',\n",
              " 'MSI',\n",
              " 'MSCI',\n",
              " 'NDAQ',\n",
              " 'NTAP',\n",
              " 'NFLX',\n",
              " 'NEM',\n",
              " 'NWSA',\n",
              " 'NWS',\n",
              " 'NEE',\n",
              " 'NKE',\n",
              " 'NI',\n",
              " 'NDSN',\n",
              " 'NSC',\n",
              " 'NTRS',\n",
              " 'NOC',\n",
              " 'NCLH',\n",
              " 'NRG',\n",
              " 'NUE',\n",
              " 'NVDA',\n",
              " 'NVR',\n",
              " 'NXPI',\n",
              " 'ORLY',\n",
              " 'OXY',\n",
              " 'ODFL',\n",
              " 'OMC',\n",
              " 'ON',\n",
              " 'OKE',\n",
              " 'ORCL',\n",
              " 'OTIS',\n",
              " 'PCAR',\n",
              " 'PKG',\n",
              " 'PANW',\n",
              " 'PARA',\n",
              " 'PH',\n",
              " 'PAYX',\n",
              " 'PAYC',\n",
              " 'PYPL',\n",
              " 'PNR',\n",
              " 'PEP',\n",
              " 'PFE',\n",
              " 'PCG',\n",
              " 'PM',\n",
              " 'PSX',\n",
              " 'PNW',\n",
              " 'PXD',\n",
              " 'PNC',\n",
              " 'POOL',\n",
              " 'PPG',\n",
              " 'PPL',\n",
              " 'PFG',\n",
              " 'PG',\n",
              " 'PGR',\n",
              " 'PLD',\n",
              " 'PRU',\n",
              " 'PEG',\n",
              " 'PTC',\n",
              " 'PSA',\n",
              " 'PHM',\n",
              " 'QRVO',\n",
              " 'PWR',\n",
              " 'QCOM',\n",
              " 'DGX',\n",
              " 'RL',\n",
              " 'RJF',\n",
              " 'RTX',\n",
              " 'O',\n",
              " 'REG',\n",
              " 'REGN',\n",
              " 'RF',\n",
              " 'RSG',\n",
              " 'RMD',\n",
              " 'RVTY',\n",
              " 'RHI',\n",
              " 'ROK',\n",
              " 'ROL',\n",
              " 'ROP',\n",
              " 'ROST',\n",
              " 'RCL',\n",
              " 'SPGI',\n",
              " 'CRM',\n",
              " 'SBAC',\n",
              " 'SLB',\n",
              " 'STX',\n",
              " 'SEE',\n",
              " 'SRE',\n",
              " 'NOW',\n",
              " 'SHW',\n",
              " 'SPG',\n",
              " 'SWKS',\n",
              " 'SJM',\n",
              " 'SNA',\n",
              " 'SEDG',\n",
              " 'SO',\n",
              " 'LUV',\n",
              " 'SWK',\n",
              " 'SBUX',\n",
              " 'STT',\n",
              " 'STLD',\n",
              " 'STE',\n",
              " 'SYK',\n",
              " 'SYF',\n",
              " 'SNPS',\n",
              " 'SYY',\n",
              " 'TMUS',\n",
              " 'TROW',\n",
              " 'TTWO',\n",
              " 'TPR',\n",
              " 'TRGP',\n",
              " 'TGT',\n",
              " 'TEL',\n",
              " 'TDY',\n",
              " 'TFX',\n",
              " 'TER',\n",
              " 'TSLA',\n",
              " 'TXN',\n",
              " 'TXT',\n",
              " 'TMO',\n",
              " 'TJX',\n",
              " 'TSCO',\n",
              " 'TT',\n",
              " 'TDG',\n",
              " 'TRV',\n",
              " 'TRMB',\n",
              " 'TFC',\n",
              " 'TYL',\n",
              " 'TSN',\n",
              " 'USB',\n",
              " 'UDR',\n",
              " 'ULTA',\n",
              " 'UNP',\n",
              " 'UAL',\n",
              " 'UPS',\n",
              " 'URI',\n",
              " 'UNH',\n",
              " 'UHS',\n",
              " 'VLO',\n",
              " 'VTR',\n",
              " 'VLTO',\n",
              " 'VRSN',\n",
              " 'VRSK',\n",
              " 'VZ',\n",
              " 'VRTX',\n",
              " 'VFC',\n",
              " 'VTRS',\n",
              " 'VICI',\n",
              " 'V',\n",
              " 'VMC',\n",
              " 'WAB',\n",
              " 'WBA',\n",
              " 'WMT',\n",
              " 'WBD',\n",
              " 'WM',\n",
              " 'WAT',\n",
              " 'WEC',\n",
              " 'WFC',\n",
              " 'WELL',\n",
              " 'WST',\n",
              " 'WDC',\n",
              " 'WRK',\n",
              " 'WY',\n",
              " 'WHR',\n",
              " 'WMB',\n",
              " 'WTW',\n",
              " 'GWW',\n",
              " 'WYNN',\n",
              " 'XEL',\n",
              " 'XYL',\n",
              " 'YUM',\n",
              " 'ZBRA',\n",
              " 'ZBH',\n",
              " 'ZION',\n",
              " 'ZTS']"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "tickers_companies_dict = dict(\n",
        "    zip(df['Symbol'], df['Security'])\n",
        ")\n",
        "tickers_companies_dict"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qokrPnFFYYR6",
        "outputId": "2fc28ac7-2923-4f10-810a-c26e8fc2ba17"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'MMM': '3M',\n",
              " 'AOS': 'A. O. Smith',\n",
              " 'ABT': 'Abbott',\n",
              " 'ABBV': 'AbbVie',\n",
              " 'ACN': 'Accenture',\n",
              " 'ADM': 'ADM',\n",
              " 'ADBE': 'Adobe Inc.',\n",
              " 'ADP': 'ADP',\n",
              " 'AES': 'AES Corporation',\n",
              " 'AFL': 'Aflac',\n",
              " 'A': 'Agilent Technologies',\n",
              " 'ABNB': 'Airbnb',\n",
              " 'APD': 'Air Products and Chemicals',\n",
              " 'AKAM': 'Akamai',\n",
              " 'ALK': 'Alaska Air Group',\n",
              " 'ALB': 'Albemarle Corporation',\n",
              " 'ARE': 'Alexandria Real Estate Equities',\n",
              " 'ALGN': 'Align Technology',\n",
              " 'ALLE': 'Allegion',\n",
              " 'LNT': 'Alliant Energy',\n",
              " 'ALL': 'Allstate',\n",
              " 'GOOGL': 'Alphabet Inc. (Class A)',\n",
              " 'GOOG': 'Alphabet Inc. (Class C)',\n",
              " 'MO': 'Altria',\n",
              " 'AMZN': 'Amazon',\n",
              " 'AMCR': 'Amcor',\n",
              " 'AMD': 'AMD',\n",
              " 'AEE': 'Ameren',\n",
              " 'AAL': 'American Airlines Group',\n",
              " 'AEP': 'American Electric Power',\n",
              " 'AXP': 'American Express',\n",
              " 'AIG': 'American International Group',\n",
              " 'AMT': 'American Tower',\n",
              " 'AWK': 'American Water Works',\n",
              " 'AMP': 'Ameriprise Financial',\n",
              " 'AME': 'Ametek',\n",
              " 'AMGN': 'Amgen',\n",
              " 'APH': 'Amphenol',\n",
              " 'ADI': 'Analog Devices',\n",
              " 'ANSS': 'Ansys',\n",
              " 'AON': 'Aon',\n",
              " 'APA': 'APA Corporation',\n",
              " 'AAPL': 'Apple Inc.',\n",
              " 'AMAT': 'Applied Materials',\n",
              " 'APTV': 'Aptiv',\n",
              " 'ACGL': 'Arch Capital Group',\n",
              " 'ANET': 'Arista Networks',\n",
              " 'AJG': 'Arthur J. Gallagher & Co.',\n",
              " 'AIZ': 'Assurant',\n",
              " 'T': 'AT&T',\n",
              " 'ATO': 'Atmos Energy',\n",
              " 'ADSK': 'Autodesk',\n",
              " 'AZO': 'AutoZone',\n",
              " 'AVB': 'AvalonBay Communities',\n",
              " 'AVY': 'Avery Dennison',\n",
              " 'AXON': 'Axon Enterprise',\n",
              " 'BKR': 'Baker Hughes',\n",
              " 'BALL': 'Ball Corporation',\n",
              " 'BAC': 'Bank of America',\n",
              " 'BBWI': 'Bath & Body Works, Inc.',\n",
              " 'BAX': 'Baxter International',\n",
              " 'BDX': 'Becton Dickinson',\n",
              " 'WRB': 'Berkley',\n",
              " 'BRK.B': 'Berkshire Hathaway',\n",
              " 'BBY': 'Best Buy',\n",
              " 'BIO': 'Bio-Rad',\n",
              " 'TECH': 'Bio-Techne',\n",
              " 'BIIB': 'Biogen',\n",
              " 'BLK': 'BlackRock',\n",
              " 'BX': 'Blackstone',\n",
              " 'BK': 'BNY Mellon',\n",
              " 'BA': 'Boeing',\n",
              " 'BKNG': 'Booking Holdings',\n",
              " 'BWA': 'BorgWarner',\n",
              " 'BXP': 'Boston Properties',\n",
              " 'BSX': 'Boston Scientific',\n",
              " 'BMY': 'Bristol Myers Squibb',\n",
              " 'AVGO': 'Broadcom Inc.',\n",
              " 'BR': 'Broadridge Financial Solutions',\n",
              " 'BRO': 'Brown & Brown',\n",
              " 'BF.B': 'Brown–Forman',\n",
              " 'BG': 'Bunge Global SA',\n",
              " 'CHRW': 'C.H. Robinson',\n",
              " 'CDNS': 'Cadence Design Systems',\n",
              " 'CZR': 'Caesars Entertainment',\n",
              " 'CPT': 'Camden Property Trust',\n",
              " 'CPB': 'Campbell Soup Company',\n",
              " 'COF': 'Capital One',\n",
              " 'CAH': 'Cardinal Health',\n",
              " 'KMX': 'CarMax',\n",
              " 'CCL': 'Carnival',\n",
              " 'CARR': 'Carrier Global',\n",
              " 'CTLT': 'Catalent',\n",
              " 'CAT': 'Caterpillar Inc.',\n",
              " 'CBOE': 'Cboe Global Markets',\n",
              " 'CBRE': 'CBRE Group',\n",
              " 'CDW': 'CDW',\n",
              " 'CE': 'Celanese',\n",
              " 'COR': 'Cencora',\n",
              " 'CNC': 'Centene Corporation',\n",
              " 'CNP': 'CenterPoint Energy',\n",
              " 'CDAY': 'Ceridian',\n",
              " 'CF': 'CF Industries',\n",
              " 'CRL': 'Charles River Laboratories',\n",
              " 'SCHW': 'Charles Schwab Corporation',\n",
              " 'CHTR': 'Charter Communications',\n",
              " 'CVX': 'Chevron Corporation',\n",
              " 'CMG': 'Chipotle Mexican Grill',\n",
              " 'CB': 'Chubb Limited',\n",
              " 'CHD': 'Church & Dwight',\n",
              " 'CI': 'Cigna',\n",
              " 'CINF': 'Cincinnati Financial',\n",
              " 'CTAS': 'Cintas',\n",
              " 'CSCO': 'Cisco',\n",
              " 'C': 'Citigroup',\n",
              " 'CFG': 'Citizens Financial Group',\n",
              " 'CLX': 'Clorox',\n",
              " 'CME': 'CME Group',\n",
              " 'CMS': 'CMS Energy',\n",
              " 'KO': 'Coca-Cola Company (The)',\n",
              " 'CTSH': 'Cognizant',\n",
              " 'CL': 'Colgate-Palmolive',\n",
              " 'CMCSA': 'Comcast',\n",
              " 'CMA': 'Comerica',\n",
              " 'CAG': 'Conagra Brands',\n",
              " 'COP': 'ConocoPhillips',\n",
              " 'ED': 'Consolidated Edison',\n",
              " 'STZ': 'Constellation Brands',\n",
              " 'CEG': 'Constellation Energy',\n",
              " 'COO': 'CooperCompanies',\n",
              " 'CPRT': 'Copart',\n",
              " 'GLW': 'Corning Inc.',\n",
              " 'CTVA': 'Corteva',\n",
              " 'CSGP': 'CoStar Group',\n",
              " 'COST': 'Costco',\n",
              " 'CTRA': 'Coterra',\n",
              " 'CCI': 'Crown Castle',\n",
              " 'CSX': 'CSX',\n",
              " 'CMI': 'Cummins',\n",
              " 'CVS': 'CVS Health',\n",
              " 'DHI': 'D.R. Horton',\n",
              " 'DHR': 'Danaher Corporation',\n",
              " 'DRI': 'Darden Restaurants',\n",
              " 'DVA': 'DaVita Inc.',\n",
              " 'DE': 'John Deere',\n",
              " 'DAL': 'Delta Air Lines',\n",
              " 'XRAY': 'Dentsply Sirona',\n",
              " 'DVN': 'Devon Energy',\n",
              " 'DXCM': 'Dexcom',\n",
              " 'FANG': 'Diamondback Energy',\n",
              " 'DLR': 'Digital Realty',\n",
              " 'DFS': 'Discover Financial',\n",
              " 'DIS': 'Disney',\n",
              " 'DG': 'Dollar General',\n",
              " 'DLTR': 'Dollar Tree',\n",
              " 'D': 'Dominion Energy',\n",
              " 'DPZ': \"Domino's\",\n",
              " 'DOV': 'Dover Corporation',\n",
              " 'DOW': 'Dow Inc.',\n",
              " 'DTE': 'DTE Energy',\n",
              " 'DUK': 'Duke Energy',\n",
              " 'DD': 'DuPont',\n",
              " 'EMN': 'Eastman Chemical Company',\n",
              " 'ETN': 'Eaton Corporation',\n",
              " 'EBAY': 'eBay',\n",
              " 'ECL': 'Ecolab',\n",
              " 'EIX': 'Edison International',\n",
              " 'EW': 'Edwards Lifesciences',\n",
              " 'EA': 'Electronic Arts',\n",
              " 'ELV': 'Elevance Health',\n",
              " 'LLY': 'Eli Lilly and Company',\n",
              " 'EMR': 'Emerson Electric',\n",
              " 'ENPH': 'Enphase',\n",
              " 'ETR': 'Entergy',\n",
              " 'EOG': 'EOG Resources',\n",
              " 'EPAM': 'EPAM Systems',\n",
              " 'EQT': 'EQT',\n",
              " 'EFX': 'Equifax',\n",
              " 'EQIX': 'Equinix',\n",
              " 'EQR': 'Equity Residential',\n",
              " 'ESS': 'Essex Property Trust',\n",
              " 'EL': 'Estée Lauder Companies (The)',\n",
              " 'ETSY': 'Etsy',\n",
              " 'EG': 'Everest Re',\n",
              " 'EVRG': 'Evergy',\n",
              " 'ES': 'Eversource',\n",
              " 'EXC': 'Exelon',\n",
              " 'EXPE': 'Expedia Group',\n",
              " 'EXPD': 'Expeditors International',\n",
              " 'EXR': 'Extra Space Storage',\n",
              " 'XOM': 'ExxonMobil',\n",
              " 'FFIV': 'F5, Inc.',\n",
              " 'FDS': 'FactSet',\n",
              " 'FICO': 'Fair Isaac',\n",
              " 'FAST': 'Fastenal',\n",
              " 'FRT': 'Federal Realty',\n",
              " 'FDX': 'FedEx',\n",
              " 'FITB': 'Fifth Third Bank',\n",
              " 'FSLR': 'First Solar',\n",
              " 'FE': 'FirstEnergy',\n",
              " 'FIS': 'FIS',\n",
              " 'FI': 'Fiserv',\n",
              " 'FLT': 'Fleetcor',\n",
              " 'FMC': 'FMC Corporation',\n",
              " 'F': 'Ford Motor Company',\n",
              " 'FTNT': 'Fortinet',\n",
              " 'FTV': 'Fortive',\n",
              " 'FOXA': 'Fox Corporation (Class A)',\n",
              " 'FOX': 'Fox Corporation (Class B)',\n",
              " 'BEN': 'Franklin Templeton',\n",
              " 'FCX': 'Freeport-McMoRan',\n",
              " 'GRMN': 'Garmin',\n",
              " 'IT': 'Gartner',\n",
              " 'GEHC': 'GE HealthCare',\n",
              " 'GEN': 'Gen Digital',\n",
              " 'GNRC': 'Generac',\n",
              " 'GD': 'General Dynamics',\n",
              " 'GE': 'General Electric',\n",
              " 'GIS': 'General Mills',\n",
              " 'GM': 'General Motors',\n",
              " 'GPC': 'Genuine Parts Company',\n",
              " 'GILD': 'Gilead Sciences',\n",
              " 'GL': 'Globe Life',\n",
              " 'GPN': 'Global Payments',\n",
              " 'GS': 'Goldman Sachs',\n",
              " 'HAL': 'Halliburton',\n",
              " 'HIG': 'Hartford (The)',\n",
              " 'HAS': 'Hasbro',\n",
              " 'HCA': 'HCA Healthcare',\n",
              " 'PEAK': 'Healthpeak',\n",
              " 'HSIC': 'Henry Schein',\n",
              " 'HSY': \"Hershey's\",\n",
              " 'HES': 'Hess Corporation',\n",
              " 'HPE': 'Hewlett Packard Enterprise',\n",
              " 'HLT': 'Hilton Worldwide',\n",
              " 'HOLX': 'Hologic',\n",
              " 'HD': 'Home Depot (The)',\n",
              " 'HON': 'Honeywell',\n",
              " 'HRL': 'Hormel Foods',\n",
              " 'HST': 'Host Hotels & Resorts',\n",
              " 'HWM': 'Howmet Aerospace',\n",
              " 'HPQ': 'HP Inc.',\n",
              " 'HUBB': 'Hubbell Incorporated',\n",
              " 'HUM': 'Humana',\n",
              " 'HBAN': 'Huntington Bancshares',\n",
              " 'HII': 'Huntington Ingalls Industries',\n",
              " 'IBM': 'IBM',\n",
              " 'IEX': 'IDEX Corporation',\n",
              " 'IDXX': 'Idexx Laboratories',\n",
              " 'ITW': 'Illinois Tool Works',\n",
              " 'ILMN': 'Illumina',\n",
              " 'INCY': 'Incyte',\n",
              " 'IR': 'Ingersoll Rand',\n",
              " 'PODD': 'Insulet',\n",
              " 'INTC': 'Intel',\n",
              " 'ICE': 'Intercontinental Exchange',\n",
              " 'IFF': 'International Flavors & Fragrances',\n",
              " 'IP': 'International Paper',\n",
              " 'IPG': 'Interpublic Group of Companies (The)',\n",
              " 'INTU': 'Intuit',\n",
              " 'ISRG': 'Intuitive Surgical',\n",
              " 'IVZ': 'Invesco',\n",
              " 'INVH': 'Invitation Homes',\n",
              " 'IQV': 'IQVIA',\n",
              " 'IRM': 'Iron Mountain',\n",
              " 'JBHT': 'J.B. Hunt',\n",
              " 'JKHY': 'Jack Henry & Associates',\n",
              " 'J': 'Jacobs Solutions',\n",
              " 'JNJ': 'Johnson & Johnson',\n",
              " 'JCI': 'Johnson Controls',\n",
              " 'JPM': 'JPMorgan Chase',\n",
              " 'JNPR': 'Juniper Networks',\n",
              " 'K': 'Kellanova',\n",
              " 'KVUE': 'Kenvue',\n",
              " 'KDP': 'Keurig Dr Pepper',\n",
              " 'KEY': 'KeyCorp',\n",
              " 'KEYS': 'Keysight',\n",
              " 'KMB': 'Kimberly-Clark',\n",
              " 'KIM': 'Kimco Realty',\n",
              " 'KMI': 'Kinder Morgan',\n",
              " 'KLAC': 'KLA Corporation',\n",
              " 'KHC': 'Kraft Heinz',\n",
              " 'KR': 'Kroger',\n",
              " 'LHX': 'L3Harris',\n",
              " 'LH': 'LabCorp',\n",
              " 'LRCX': 'Lam Research',\n",
              " 'LW': 'Lamb Weston',\n",
              " 'LVS': 'Las Vegas Sands',\n",
              " 'LDOS': 'Leidos',\n",
              " 'LEN': 'Lennar',\n",
              " 'LIN': 'Linde plc',\n",
              " 'LYV': 'Live Nation Entertainment',\n",
              " 'LKQ': 'LKQ Corporation',\n",
              " 'LMT': 'Lockheed Martin',\n",
              " 'L': 'Loews Corporation',\n",
              " 'LOW': \"Lowe's\",\n",
              " 'LULU': 'Lululemon Athletica',\n",
              " 'LYB': 'LyondellBasell',\n",
              " 'MTB': 'M&T Bank',\n",
              " 'MRO': 'Marathon Oil',\n",
              " 'MPC': 'Marathon Petroleum',\n",
              " 'MKTX': 'MarketAxess',\n",
              " 'MAR': 'Marriott International',\n",
              " 'MMC': 'Marsh McLennan',\n",
              " 'MLM': 'Martin Marietta Materials',\n",
              " 'MAS': 'Masco',\n",
              " 'MA': 'Mastercard',\n",
              " 'MTCH': 'Match Group',\n",
              " 'MKC': 'McCormick & Company',\n",
              " 'MCD': \"McDonald's\",\n",
              " 'MCK': 'McKesson',\n",
              " 'MDT': 'Medtronic',\n",
              " 'MRK': 'Merck & Co.',\n",
              " 'META': 'Meta Platforms',\n",
              " 'MET': 'MetLife',\n",
              " 'MTD': 'Mettler Toledo',\n",
              " 'MGM': 'MGM Resorts',\n",
              " 'MCHP': 'Microchip Technology',\n",
              " 'MU': 'Micron Technology',\n",
              " 'MSFT': 'Microsoft',\n",
              " 'MAA': 'Mid-America Apartment Communities',\n",
              " 'MRNA': 'Moderna',\n",
              " 'MHK': 'Mohawk Industries',\n",
              " 'MOH': 'Molina Healthcare',\n",
              " 'TAP': 'Molson Coors Beverage Company',\n",
              " 'MDLZ': 'Mondelez International',\n",
              " 'MPWR': 'Monolithic Power Systems',\n",
              " 'MNST': 'Monster Beverage',\n",
              " 'MCO': \"Moody's Corporation\",\n",
              " 'MS': 'Morgan Stanley',\n",
              " 'MOS': 'Mosaic Company (The)',\n",
              " 'MSI': 'Motorola Solutions',\n",
              " 'MSCI': 'MSCI',\n",
              " 'NDAQ': 'Nasdaq, Inc.',\n",
              " 'NTAP': 'NetApp',\n",
              " 'NFLX': 'Netflix',\n",
              " 'NEM': 'Newmont',\n",
              " 'NWSA': 'News Corp (Class A)',\n",
              " 'NWS': 'News Corp (Class B)',\n",
              " 'NEE': 'NextEra Energy',\n",
              " 'NKE': 'Nike, Inc.',\n",
              " 'NI': 'NiSource',\n",
              " 'NDSN': 'Nordson Corporation',\n",
              " 'NSC': 'Norfolk Southern Railway',\n",
              " 'NTRS': 'Northern Trust',\n",
              " 'NOC': 'Northrop Grumman',\n",
              " 'NCLH': 'Norwegian Cruise Line Holdings',\n",
              " 'NRG': 'NRG Energy',\n",
              " 'NUE': 'Nucor',\n",
              " 'NVDA': 'Nvidia',\n",
              " 'NVR': 'NVR, Inc.',\n",
              " 'NXPI': 'NXP Semiconductors',\n",
              " 'ORLY': \"O'Reilly Auto Parts\",\n",
              " 'OXY': 'Occidental Petroleum',\n",
              " 'ODFL': 'Old Dominion',\n",
              " 'OMC': 'Omnicom Group',\n",
              " 'ON': 'ON Semiconductor',\n",
              " 'OKE': 'ONEOK',\n",
              " 'ORCL': 'Oracle Corporation',\n",
              " 'OTIS': 'Otis Worldwide',\n",
              " 'PCAR': 'Paccar',\n",
              " 'PKG': 'Packaging Corporation of America',\n",
              " 'PANW': 'Palo Alto Networks',\n",
              " 'PARA': 'Paramount Global',\n",
              " 'PH': 'Parker Hannifin',\n",
              " 'PAYX': 'Paychex',\n",
              " 'PAYC': 'Paycom',\n",
              " 'PYPL': 'PayPal',\n",
              " 'PNR': 'Pentair',\n",
              " 'PEP': 'PepsiCo',\n",
              " 'PFE': 'Pfizer',\n",
              " 'PCG': 'PG&E Corporation',\n",
              " 'PM': 'Philip Morris International',\n",
              " 'PSX': 'Phillips 66',\n",
              " 'PNW': 'Pinnacle West',\n",
              " 'PXD': 'Pioneer Natural Resources',\n",
              " 'PNC': 'PNC Financial Services',\n",
              " 'POOL': 'Pool Corporation',\n",
              " 'PPG': 'PPG Industries',\n",
              " 'PPL': 'PPL Corporation',\n",
              " 'PFG': 'Principal Financial Group',\n",
              " 'PG': 'Procter & Gamble',\n",
              " 'PGR': 'Progressive Corporation',\n",
              " 'PLD': 'Prologis',\n",
              " 'PRU': 'Prudential Financial',\n",
              " 'PEG': 'Public Service Enterprise Group',\n",
              " 'PTC': 'PTC',\n",
              " 'PSA': 'Public Storage',\n",
              " 'PHM': 'PulteGroup',\n",
              " 'QRVO': 'Qorvo',\n",
              " 'PWR': 'Quanta Services',\n",
              " 'QCOM': 'Qualcomm',\n",
              " 'DGX': 'Quest Diagnostics',\n",
              " 'RL': 'Ralph Lauren Corporation',\n",
              " 'RJF': 'Raymond James',\n",
              " 'RTX': 'RTX Corporation',\n",
              " 'O': 'Realty Income',\n",
              " 'REG': 'Regency Centers',\n",
              " 'REGN': 'Regeneron',\n",
              " 'RF': 'Regions Financial Corporation',\n",
              " 'RSG': 'Republic Services',\n",
              " 'RMD': 'ResMed',\n",
              " 'RVTY': 'Revvity',\n",
              " 'RHI': 'Robert Half',\n",
              " 'ROK': 'Rockwell Automation',\n",
              " 'ROL': 'Rollins, Inc.',\n",
              " 'ROP': 'Roper Technologies',\n",
              " 'ROST': 'Ross Stores',\n",
              " 'RCL': 'Royal Caribbean Group',\n",
              " 'SPGI': 'S&P Global',\n",
              " 'CRM': 'Salesforce',\n",
              " 'SBAC': 'SBA Communications',\n",
              " 'SLB': 'Schlumberger',\n",
              " 'STX': 'Seagate Technology',\n",
              " 'SEE': 'Sealed Air',\n",
              " 'SRE': 'Sempra Energy',\n",
              " 'NOW': 'ServiceNow',\n",
              " 'SHW': 'Sherwin-Williams',\n",
              " 'SPG': 'Simon Property Group',\n",
              " 'SWKS': 'Skyworks Solutions',\n",
              " 'SJM': 'J.M. Smucker Company (The)',\n",
              " 'SNA': 'Snap-on',\n",
              " 'SEDG': 'SolarEdge',\n",
              " 'SO': 'Southern Company',\n",
              " 'LUV': 'Southwest Airlines',\n",
              " 'SWK': 'Stanley Black & Decker',\n",
              " 'SBUX': 'Starbucks',\n",
              " 'STT': 'State Street Corporation',\n",
              " 'STLD': 'Steel Dynamics',\n",
              " 'STE': 'Steris',\n",
              " 'SYK': 'Stryker Corporation',\n",
              " 'SYF': 'Synchrony Financial',\n",
              " 'SNPS': 'Synopsys',\n",
              " 'SYY': 'Sysco',\n",
              " 'TMUS': 'T-Mobile US',\n",
              " 'TROW': 'T. Rowe Price',\n",
              " 'TTWO': 'Take-Two Interactive',\n",
              " 'TPR': 'Tapestry, Inc.',\n",
              " 'TRGP': 'Targa Resources',\n",
              " 'TGT': 'Target Corporation',\n",
              " 'TEL': 'TE Connectivity',\n",
              " 'TDY': 'Teledyne Technologies',\n",
              " 'TFX': 'Teleflex',\n",
              " 'TER': 'Teradyne',\n",
              " 'TSLA': 'Tesla, Inc.',\n",
              " 'TXN': 'Texas Instruments',\n",
              " 'TXT': 'Textron',\n",
              " 'TMO': 'Thermo Fisher Scientific',\n",
              " 'TJX': 'TJX Companies',\n",
              " 'TSCO': 'Tractor Supply',\n",
              " 'TT': 'Trane Technologies',\n",
              " 'TDG': 'TransDigm Group',\n",
              " 'TRV': 'Travelers Companies (The)',\n",
              " 'TRMB': 'Trimble Inc.',\n",
              " 'TFC': 'Truist',\n",
              " 'TYL': 'Tyler Technologies',\n",
              " 'TSN': 'Tyson Foods',\n",
              " 'USB': 'U.S. Bank',\n",
              " 'UDR': 'UDR, Inc.',\n",
              " 'ULTA': 'Ulta Beauty',\n",
              " 'UNP': 'Union Pacific Corporation',\n",
              " 'UAL': 'United Airlines Holdings',\n",
              " 'UPS': 'United Parcel Service',\n",
              " 'URI': 'United Rentals',\n",
              " 'UNH': 'UnitedHealth Group',\n",
              " 'UHS': 'Universal Health Services',\n",
              " 'VLO': 'Valero Energy',\n",
              " 'VTR': 'Ventas',\n",
              " 'VLTO': 'Veralto',\n",
              " 'VRSN': 'Verisign',\n",
              " 'VRSK': 'Verisk',\n",
              " 'VZ': 'Verizon',\n",
              " 'VRTX': 'Vertex Pharmaceuticals',\n",
              " 'VFC': 'VF Corporation',\n",
              " 'VTRS': 'Viatris',\n",
              " 'VICI': 'Vici Properties',\n",
              " 'V': 'Visa Inc.',\n",
              " 'VMC': 'Vulcan Materials Company',\n",
              " 'WAB': 'Wabtec',\n",
              " 'WBA': 'Walgreens Boots Alliance',\n",
              " 'WMT': 'Walmart',\n",
              " 'WBD': 'Warner Bros. Discovery',\n",
              " 'WM': 'Waste Management',\n",
              " 'WAT': 'Waters Corporation',\n",
              " 'WEC': 'WEC Energy Group',\n",
              " 'WFC': 'Wells Fargo',\n",
              " 'WELL': 'Welltower',\n",
              " 'WST': 'West Pharmaceutical Services',\n",
              " 'WDC': 'Western Digital',\n",
              " 'WRK': 'WestRock',\n",
              " 'WY': 'Weyerhaeuser',\n",
              " 'WHR': 'Whirlpool Corporation',\n",
              " 'WMB': 'Williams Companies',\n",
              " 'WTW': 'Willis Towers Watson',\n",
              " 'GWW': 'W. W. Grainger',\n",
              " 'WYNN': 'Wynn Resorts',\n",
              " 'XEL': 'Xcel Energy',\n",
              " 'XYL': 'Xylem Inc.',\n",
              " 'YUM': 'Yum! Brands',\n",
              " 'ZBRA': 'Zebra Technologies',\n",
              " 'ZBH': 'Zimmer Biomet',\n",
              " 'ZION': 'Zions Bancorporation',\n",
              " 'ZTS': 'Zoetis'}"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def get_sp500_components():\n",
        "  df = pd.read_html(\"https://en.wikipedia.org/wiki/List_of_S%26P_500_companies\")[0]\n",
        "  tickers = df['Symbol'].to_list()\n",
        "  tickers_companies_dict = dict(zip(df['Symbol'], df['Security']))\n",
        "  return tickers, tickers_companies_dict"
      ],
      "metadata": {
        "id": "TrKzHaYdYr6X"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import yfinance as yf"
      ],
      "metadata": {
        "id": "gCdZs_ZIZOYz"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "def load_data(symbol, start, end):\n",
        "  return yf.download(symbol, start, end)"
      ],
      "metadata": {
        "id": "PMQ7-BJ-a60y"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "tickers_sp500, tickers_companies_dict_sp500 = get_sp500_components()"
      ],
      "metadata": {
        "id": "78NoUmDMbHOy"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "company = 'Amazon'\n",
        "[c for c in tickers_companies_dict_sp500.keys() if tickers_companies_dict_sp500[c] == company]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "w_jP0wdBe0d7",
        "outputId": "4ba9cd67-bfcd-4d35-95ff-2d027b57418b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['AMZN']"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import datetime\n",
        "amzn_df = load_data(\n",
        "    [c for c in tickers_companies_dict_sp500.keys() if tickers_companies_dict_sp500[c] == company],\n",
        "    start = datetime.date(2022, 1, 1),\n",
        "    end = datetime.date.today()\n",
        ")\n",
        "amzn_df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 472
        },
        "id": "pH7bMvg3fppy",
        "outputId": "0ff9f950-ded9-4858-ff9c-995387ffa9ab"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\r[*********************100%%**********************]  1 of 1 completed\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Open        High         Low       Close   Adj Close  \\\n",
              "Date                                                                     \n",
              "2022-01-03  167.550003  170.703506  166.160507  170.404495  170.404495   \n",
              "2022-01-04  170.438004  171.399994  166.349503  167.522003  167.522003   \n",
              "2022-01-05  166.882996  167.126495  164.356995  164.356995  164.356995   \n",
              "2022-01-06  163.450500  164.800003  161.936996  163.253998  163.253998   \n",
              "2022-01-07  163.839005  165.243500  162.031006  162.554001  162.554001   \n",
              "...                ...         ...         ...         ...         ...   \n",
              "2023-11-24  146.699997  147.199997  145.320007  146.740005  146.740005   \n",
              "2023-11-27  147.529999  149.259995  146.880005  147.729996  147.729996   \n",
              "2023-11-28  146.979996  147.600006  145.529999  147.029999  147.029999   \n",
              "2023-11-29  147.850006  148.539993  145.970001  146.320007  146.320007   \n",
              "2023-11-30  144.759995  146.929993  144.330002  146.089996  146.089996   \n",
              "\n",
              "              Volume  \n",
              "Date                  \n",
              "2022-01-03  63520000  \n",
              "2022-01-04  70726000  \n",
              "2022-01-05  64302000  \n",
              "2022-01-06  51958000  \n",
              "2022-01-07  46606000  \n",
              "...              ...  \n",
              "2023-11-24  22378400  \n",
              "2023-11-27  53762400  \n",
              "2023-11-28  42711700  \n",
              "2023-11-29  40610900  \n",
              "2023-11-30  65757400  \n",
              "\n",
              "[481 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-859e1849-4ed3-4d7f-870d-493de75fd163\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Open</th>\n",
              "      <th>High</th>\n",
              "      <th>Low</th>\n",
              "      <th>Close</th>\n",
              "      <th>Adj Close</th>\n",
              "      <th>Volume</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2022-01-03</th>\n",
              "      <td>167.550003</td>\n",
              "      <td>170.703506</td>\n",
              "      <td>166.160507</td>\n",
              "      <td>170.404495</td>\n",
              "      <td>170.404495</td>\n",
              "      <td>63520000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2022-01-04</th>\n",
              "      <td>170.438004</td>\n",
              "      <td>171.399994</td>\n",
              "      <td>166.349503</td>\n",
              "      <td>167.522003</td>\n",
              "      <td>167.522003</td>\n",
              "      <td>70726000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2022-01-05</th>\n",
              "      <td>166.882996</td>\n",
              "      <td>167.126495</td>\n",
              "      <td>164.356995</td>\n",
              "      <td>164.356995</td>\n",
              "      <td>164.356995</td>\n",
              "      <td>64302000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2022-01-06</th>\n",
              "      <td>163.450500</td>\n",
              "      <td>164.800003</td>\n",
              "      <td>161.936996</td>\n",
              "      <td>163.253998</td>\n",
              "      <td>163.253998</td>\n",
              "      <td>51958000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2022-01-07</th>\n",
              "      <td>163.839005</td>\n",
              "      <td>165.243500</td>\n",
              "      <td>162.031006</td>\n",
              "      <td>162.554001</td>\n",
              "      <td>162.554001</td>\n",
              "      <td>46606000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-24</th>\n",
              "      <td>146.699997</td>\n",
              "      <td>147.199997</td>\n",
              "      <td>145.320007</td>\n",
              "      <td>146.740005</td>\n",
              "      <td>146.740005</td>\n",
              "      <td>22378400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-27</th>\n",
              "      <td>147.529999</td>\n",
              "      <td>149.259995</td>\n",
              "      <td>146.880005</td>\n",
              "      <td>147.729996</td>\n",
              "      <td>147.729996</td>\n",
              "      <td>53762400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-28</th>\n",
              "      <td>146.979996</td>\n",
              "      <td>147.600006</td>\n",
              "      <td>145.529999</td>\n",
              "      <td>147.029999</td>\n",
              "      <td>147.029999</td>\n",
              "      <td>42711700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-29</th>\n",
              "      <td>147.850006</td>\n",
              "      <td>148.539993</td>\n",
              "      <td>145.970001</td>\n",
              "      <td>146.320007</td>\n",
              "      <td>146.320007</td>\n",
              "      <td>40610900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-30</th>\n",
              "      <td>144.759995</td>\n",
              "      <td>146.929993</td>\n",
              "      <td>144.330002</td>\n",
              "      <td>146.089996</td>\n",
              "      <td>146.089996</td>\n",
              "      <td>65757400</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>481 rows × 6 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-859e1849-4ed3-4d7f-870d-493de75fd163')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-859e1849-4ed3-4d7f-870d-493de75fd163 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-859e1849-4ed3-4d7f-870d-493de75fd163');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-74e56e43-142b-4407-9f16-1b38e881d541\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-74e56e43-142b-4407-9f16-1b38e881d541')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-74e56e43-142b-4407-9f16-1b38e881d541 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "all_sp500_df = load_data(\n",
        "    tickers_sp500,\n",
        "    start = datetime.date(2023, 11, 1),\n",
        "    end = datetime.date.today()\n",
        ")\n",
        "all_sp500_df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "TJbwcFfBf_0H",
        "outputId": "e82cadd4-b88f-465d-9369-6ab69a18081d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "[*********************100%%**********************]  503 of 503 completed"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "ERROR:yfinance:\n",
            "2 Failed downloads:\n",
            "ERROR:yfinance:['BRK.B']: Exception('%ticker%: No timezone found, symbol may be delisted')\n",
            "ERROR:yfinance:['BF.B']: Exception('%ticker%: No price data found, symbol may be delisted (1d 2023-11-01 -> 2023-12-01)')\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                      Adj Close                                             \\\n",
              "                              A    AAL        AAPL        ABBV        ABNB   \n",
              "Date                                                                         \n",
              "2023-11-01 00:00:00  102.860001  11.14  173.741104  142.470001  119.470001   \n",
              "2023-11-02 00:00:00  104.470001  11.40  177.336380  143.259995  115.500000   \n",
              "2023-11-03 00:00:00  109.019997  11.98  176.417572  141.419998  122.639999   \n",
              "2023-11-06 00:00:00  107.529999  11.66  178.994186  141.199997  118.169998   \n",
              "2023-11-07 00:00:00  110.540001  11.75  181.580780  142.160004  121.080002   \n",
              "2023-11-08 00:00:00  109.389999  12.01  182.649368  142.029999  117.660004   \n",
              "2023-11-09 00:00:00  107.739998  11.75  182.169998  138.039993  115.519997   \n",
              "2023-11-10 00:00:00  108.470001  11.80  186.399994  138.589996  118.150002   \n",
              "2023-11-13 00:00:00  107.459999  11.78  184.800003  138.639999  119.150002   \n",
              "2023-11-14 00:00:00  111.610001  12.25  187.440002  138.059998  126.680000   \n",
              "2023-11-15 00:00:00  113.599998  12.42  188.009995  137.600006  128.350006   \n",
              "2023-11-16 00:00:00  114.190002  12.19  189.710007  138.279999  126.279999   \n",
              "2023-11-17 00:00:00  113.150002  12.29  189.690002  138.300003  127.150002   \n",
              "2023-11-20 00:00:00  113.980003  12.40  191.449997  138.309998  129.699997   \n",
              "2023-11-21 00:00:00  123.919998  12.13  190.639999  138.729996  126.820000   \n",
              "2023-11-22 00:00:00  123.989998  12.31  191.309998  138.470001  129.039993   \n",
              "2023-11-24 00:00:00  126.620003  12.31  189.970001  138.669998  128.369995   \n",
              "2023-11-27 00:00:00  125.010002  12.18  189.789993  139.089996  129.000000   \n",
              "2023-11-28 00:00:00  124.709999  12.17  190.399994  138.080002  127.559998   \n",
              "2023-11-29 00:00:00  127.589996  12.23  189.369995  138.500000  126.480003   \n",
              "2023-11-30 00:00:00  127.800003  12.43  189.949997  142.389999  126.339996   \n",
              "\n",
              "                                                                    \\\n",
              "                            ABT       ACGL         ACN        ADBE   \n",
              "Date                                                                 \n",
              "2023-11-01 00:00:00   95.010002  90.000000  300.640015  544.500000   \n",
              "2023-11-02 00:00:00   95.959999  85.940002  308.119995  558.710022   \n",
              "2023-11-03 00:00:00   95.839996  85.550003  313.489990  563.659973   \n",
              "2023-11-06 00:00:00   95.000000  85.160004  313.089996  565.450012   \n",
              "2023-11-07 00:00:00   94.800003  85.410004  315.190002  585.200012   \n",
              "2023-11-08 00:00:00   94.739998  84.120003  317.820007  585.309998   \n",
              "2023-11-09 00:00:00   93.550003  84.669998  314.220001  577.739990   \n",
              "2023-11-10 00:00:00   93.970001  85.949997  319.690002  597.219971   \n",
              "2023-11-13 00:00:00   95.790001  86.570000  315.630005  590.340027   \n",
              "2023-11-14 00:00:00   97.080002  85.500000  320.489990  604.330017   \n",
              "2023-11-15 00:00:00   98.000000  82.660004  325.500000  595.309998   \n",
              "2023-11-16 00:00:00  100.260002  83.709999  327.320007  602.059998   \n",
              "2023-11-17 00:00:00   99.550003  83.599998  327.829987  602.659973   \n",
              "2023-11-20 00:00:00  101.199997  84.459999  330.899994  612.700012   \n",
              "2023-11-21 00:00:00  101.910004  86.129997  330.260010  610.989990   \n",
              "2023-11-22 00:00:00  102.699997  85.949997  333.130005  619.719971   \n",
              "2023-11-24 00:00:00  102.870003  86.599998  334.040009  619.429993   \n",
              "2023-11-27 00:00:00  102.709999  87.000000  332.429993  619.270020   \n",
              "2023-11-28 00:00:00  102.059998  84.449997  332.559998  623.320007   \n",
              "2023-11-29 00:00:00  103.629997  82.379997  333.339996  617.390015   \n",
              "2023-11-30 00:00:00  104.290001  83.690002  333.140015  611.010010   \n",
              "\n",
              "                                 ...    Volume                               \\\n",
              "                            ADI  ...      WYNN      XEL       XOM      XRAY   \n",
              "Date                             ...                                          \n",
              "2023-11-01 00:00:00  159.240005  ...   1773400  5029500  28984900   4349600   \n",
              "2023-11-02 00:00:00  164.339996  ...   1839800  3961300  25212700   8659200   \n",
              "2023-11-03 00:00:00  167.919998  ...   1866100  3920600  30549000   5097400   \n",
              "2023-11-06 00:00:00  167.570007  ...   2470600  3139700  19097300   4935000   \n",
              "2023-11-07 00:00:00  168.110001  ...   1994000  3515300  20272500   3418500   \n",
              "2023-11-08 00:00:00  168.910004  ...   2621400  3953300  19184100   3766000   \n",
              "2023-11-09 00:00:00  167.130005  ...   5825500  3871700  18380500   5385300   \n",
              "2023-11-10 00:00:00  172.320007  ...  15054500  2912100  17825500   5625200   \n",
              "2023-11-13 00:00:00  170.660004  ...   3779800  2960500  15308400   3955600   \n",
              "2023-11-14 00:00:00  177.580002  ...   4061300  4250000  18260500   4303800   \n",
              "2023-11-15 00:00:00  180.779999  ...   2544600  3439500  20137600   4925400   \n",
              "2023-11-16 00:00:00  179.839996  ...   3022800  3970800  22469100   3552800   \n",
              "2023-11-17 00:00:00  183.050003  ...   1678400  4327900  22984900   2413300   \n",
              "2023-11-20 00:00:00  183.820007  ...   2117800  6312100  17458800   3186400   \n",
              "2023-11-21 00:00:00  181.250000  ...   1554700  4139200  14989000   4266300   \n",
              "2023-11-22 00:00:00  182.669998  ...   1400000  4060400  18072000   3155000   \n",
              "2023-11-24 00:00:00  183.050003  ...   1008100  1357700   9480800   1294200   \n",
              "2023-11-27 00:00:00  183.770004  ...   1889400  2834500  18013500   3186700   \n",
              "2023-11-28 00:00:00  183.199997  ...   3616000  3667100  20629500   3279400   \n",
              "2023-11-29 00:00:00  182.710007  ...   3810200  4314000  26802100   4093000   \n",
              "2023-11-30 00:00:00  183.380005  ...   2324200  4797100  29246900  15902300   \n",
              "\n",
              "                                                                          \n",
              "                         XYL      YUM      ZBH    ZBRA     ZION      ZTS  \n",
              "Date                                                                      \n",
              "2023-11-01 00:00:00  2128900  2788100  1503100  822900  2261800  7269900  \n",
              "2023-11-02 00:00:00  1666600  1920500  3030300  758500  3026800  4137800  \n",
              "2023-11-03 00:00:00  1852500  1754600  2140100  540800  2598900  1974700  \n",
              "2023-11-06 00:00:00  1324300  1537900  2443700  373800  1551900  2112500  \n",
              "2023-11-07 00:00:00  1385100  1408000  2699200  613300  1763500  2938200  \n",
              "2023-11-08 00:00:00  1062400  1015300  1524700  525900  1755000  3326300  \n",
              "2023-11-09 00:00:00  1533100  1096900  1729100  486900  1875000  3479300  \n",
              "2023-11-10 00:00:00  1322000  1317200  1965900  602300  1649200  2108500  \n",
              "2023-11-13 00:00:00  1261100  1230500  1702200  411200  1240300  1544900  \n",
              "2023-11-14 00:00:00  1500400  1353700  1909700  542700  3270200  1421500  \n",
              "2023-11-15 00:00:00  1297000  1309400  3648600  501600  2444400  1714100  \n",
              "2023-11-16 00:00:00  1314800  1554600  2300700  275700  2217300  1566900  \n",
              "2023-11-17 00:00:00  1286600  1089600  2991400  340600  2136200  2425100  \n",
              "2023-11-20 00:00:00  1147100   915000  1345100  330600  1589000  1056700  \n",
              "2023-11-21 00:00:00  1353600   983700  1629300  360500  2311600  1423800  \n",
              "2023-11-22 00:00:00  1627700   980600  1246200  550100  1441300  1501500  \n",
              "2023-11-24 00:00:00   797400   555600   605500  195200   584000   635200  \n",
              "2023-11-27 00:00:00  1058800  1143800  1301400  528600  1424200  1442700  \n",
              "2023-11-28 00:00:00  1293400  1392800  1212800  424900  1922800  1348900  \n",
              "2023-11-29 00:00:00  1184100  1240100  1311200  372900  2755200  1524400  \n",
              "2023-11-30 00:00:00  2587200  2608900  2678200  492400  2686100  2581900  \n",
              "\n",
              "[21 rows x 3018 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2ec289ac-7d75-4782-9681-bcf8b60e8c0a\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead tr th {\n",
              "        text-align: left;\n",
              "    }\n",
              "\n",
              "    .dataframe thead tr:last-of-type th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th colspan=\"10\" halign=\"left\">Adj Close</th>\n",
              "      <th>...</th>\n",
              "      <th colspan=\"10\" halign=\"left\">Volume</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th></th>\n",
              "      <th>A</th>\n",
              "      <th>AAL</th>\n",
              "      <th>AAPL</th>\n",
              "      <th>ABBV</th>\n",
              "      <th>ABNB</th>\n",
              "      <th>ABT</th>\n",
              "      <th>ACGL</th>\n",
              "      <th>ACN</th>\n",
              "      <th>ADBE</th>\n",
              "      <th>ADI</th>\n",
              "      <th>...</th>\n",
              "      <th>WYNN</th>\n",
              "      <th>XEL</th>\n",
              "      <th>XOM</th>\n",
              "      <th>XRAY</th>\n",
              "      <th>XYL</th>\n",
              "      <th>YUM</th>\n",
              "      <th>ZBH</th>\n",
              "      <th>ZBRA</th>\n",
              "      <th>ZION</th>\n",
              "      <th>ZTS</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2023-11-01 00:00:00</th>\n",
              "      <td>102.860001</td>\n",
              "      <td>11.14</td>\n",
              "      <td>173.741104</td>\n",
              "      <td>142.470001</td>\n",
              "      <td>119.470001</td>\n",
              "      <td>95.010002</td>\n",
              "      <td>90.000000</td>\n",
              "      <td>300.640015</td>\n",
              "      <td>544.500000</td>\n",
              "      <td>159.240005</td>\n",
              "      <td>...</td>\n",
              "      <td>1773400</td>\n",
              "      <td>5029500</td>\n",
              "      <td>28984900</td>\n",
              "      <td>4349600</td>\n",
              "      <td>2128900</td>\n",
              "      <td>2788100</td>\n",
              "      <td>1503100</td>\n",
              "      <td>822900</td>\n",
              "      <td>2261800</td>\n",
              "      <td>7269900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-02 00:00:00</th>\n",
              "      <td>104.470001</td>\n",
              "      <td>11.40</td>\n",
              "      <td>177.336380</td>\n",
              "      <td>143.259995</td>\n",
              "      <td>115.500000</td>\n",
              "      <td>95.959999</td>\n",
              "      <td>85.940002</td>\n",
              "      <td>308.119995</td>\n",
              "      <td>558.710022</td>\n",
              "      <td>164.339996</td>\n",
              "      <td>...</td>\n",
              "      <td>1839800</td>\n",
              "      <td>3961300</td>\n",
              "      <td>25212700</td>\n",
              "      <td>8659200</td>\n",
              "      <td>1666600</td>\n",
              "      <td>1920500</td>\n",
              "      <td>3030300</td>\n",
              "      <td>758500</td>\n",
              "      <td>3026800</td>\n",
              "      <td>4137800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-03 00:00:00</th>\n",
              "      <td>109.019997</td>\n",
              "      <td>11.98</td>\n",
              "      <td>176.417572</td>\n",
              "      <td>141.419998</td>\n",
              "      <td>122.639999</td>\n",
              "      <td>95.839996</td>\n",
              "      <td>85.550003</td>\n",
              "      <td>313.489990</td>\n",
              "      <td>563.659973</td>\n",
              "      <td>167.919998</td>\n",
              "      <td>...</td>\n",
              "      <td>1866100</td>\n",
              "      <td>3920600</td>\n",
              "      <td>30549000</td>\n",
              "      <td>5097400</td>\n",
              "      <td>1852500</td>\n",
              "      <td>1754600</td>\n",
              "      <td>2140100</td>\n",
              "      <td>540800</td>\n",
              "      <td>2598900</td>\n",
              "      <td>1974700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-06 00:00:00</th>\n",
              "      <td>107.529999</td>\n",
              "      <td>11.66</td>\n",
              "      <td>178.994186</td>\n",
              "      <td>141.199997</td>\n",
              "      <td>118.169998</td>\n",
              "      <td>95.000000</td>\n",
              "      <td>85.160004</td>\n",
              "      <td>313.089996</td>\n",
              "      <td>565.450012</td>\n",
              "      <td>167.570007</td>\n",
              "      <td>...</td>\n",
              "      <td>2470600</td>\n",
              "      <td>3139700</td>\n",
              "      <td>19097300</td>\n",
              "      <td>4935000</td>\n",
              "      <td>1324300</td>\n",
              "      <td>1537900</td>\n",
              "      <td>2443700</td>\n",
              "      <td>373800</td>\n",
              "      <td>1551900</td>\n",
              "      <td>2112500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-07 00:00:00</th>\n",
              "      <td>110.540001</td>\n",
              "      <td>11.75</td>\n",
              "      <td>181.580780</td>\n",
              "      <td>142.160004</td>\n",
              "      <td>121.080002</td>\n",
              "      <td>94.800003</td>\n",
              "      <td>85.410004</td>\n",
              "      <td>315.190002</td>\n",
              "      <td>585.200012</td>\n",
              "      <td>168.110001</td>\n",
              "      <td>...</td>\n",
              "      <td>1994000</td>\n",
              "      <td>3515300</td>\n",
              "      <td>20272500</td>\n",
              "      <td>3418500</td>\n",
              "      <td>1385100</td>\n",
              "      <td>1408000</td>\n",
              "      <td>2699200</td>\n",
              "      <td>613300</td>\n",
              "      <td>1763500</td>\n",
              "      <td>2938200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-08 00:00:00</th>\n",
              "      <td>109.389999</td>\n",
              "      <td>12.01</td>\n",
              "      <td>182.649368</td>\n",
              "      <td>142.029999</td>\n",
              "      <td>117.660004</td>\n",
              "      <td>94.739998</td>\n",
              "      <td>84.120003</td>\n",
              "      <td>317.820007</td>\n",
              "      <td>585.309998</td>\n",
              "      <td>168.910004</td>\n",
              "      <td>...</td>\n",
              "      <td>2621400</td>\n",
              "      <td>3953300</td>\n",
              "      <td>19184100</td>\n",
              "      <td>3766000</td>\n",
              "      <td>1062400</td>\n",
              "      <td>1015300</td>\n",
              "      <td>1524700</td>\n",
              "      <td>525900</td>\n",
              "      <td>1755000</td>\n",
              "      <td>3326300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-09 00:00:00</th>\n",
              "      <td>107.739998</td>\n",
              "      <td>11.75</td>\n",
              "      <td>182.169998</td>\n",
              "      <td>138.039993</td>\n",
              "      <td>115.519997</td>\n",
              "      <td>93.550003</td>\n",
              "      <td>84.669998</td>\n",
              "      <td>314.220001</td>\n",
              "      <td>577.739990</td>\n",
              "      <td>167.130005</td>\n",
              "      <td>...</td>\n",
              "      <td>5825500</td>\n",
              "      <td>3871700</td>\n",
              "      <td>18380500</td>\n",
              "      <td>5385300</td>\n",
              "      <td>1533100</td>\n",
              "      <td>1096900</td>\n",
              "      <td>1729100</td>\n",
              "      <td>486900</td>\n",
              "      <td>1875000</td>\n",
              "      <td>3479300</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-10 00:00:00</th>\n",
              "      <td>108.470001</td>\n",
              "      <td>11.80</td>\n",
              "      <td>186.399994</td>\n",
              "      <td>138.589996</td>\n",
              "      <td>118.150002</td>\n",
              "      <td>93.970001</td>\n",
              "      <td>85.949997</td>\n",
              "      <td>319.690002</td>\n",
              "      <td>597.219971</td>\n",
              "      <td>172.320007</td>\n",
              "      <td>...</td>\n",
              "      <td>15054500</td>\n",
              "      <td>2912100</td>\n",
              "      <td>17825500</td>\n",
              "      <td>5625200</td>\n",
              "      <td>1322000</td>\n",
              "      <td>1317200</td>\n",
              "      <td>1965900</td>\n",
              "      <td>602300</td>\n",
              "      <td>1649200</td>\n",
              "      <td>2108500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-13 00:00:00</th>\n",
              "      <td>107.459999</td>\n",
              "      <td>11.78</td>\n",
              "      <td>184.800003</td>\n",
              "      <td>138.639999</td>\n",
              "      <td>119.150002</td>\n",
              "      <td>95.790001</td>\n",
              "      <td>86.570000</td>\n",
              "      <td>315.630005</td>\n",
              "      <td>590.340027</td>\n",
              "      <td>170.660004</td>\n",
              "      <td>...</td>\n",
              "      <td>3779800</td>\n",
              "      <td>2960500</td>\n",
              "      <td>15308400</td>\n",
              "      <td>3955600</td>\n",
              "      <td>1261100</td>\n",
              "      <td>1230500</td>\n",
              "      <td>1702200</td>\n",
              "      <td>411200</td>\n",
              "      <td>1240300</td>\n",
              "      <td>1544900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-14 00:00:00</th>\n",
              "      <td>111.610001</td>\n",
              "      <td>12.25</td>\n",
              "      <td>187.440002</td>\n",
              "      <td>138.059998</td>\n",
              "      <td>126.680000</td>\n",
              "      <td>97.080002</td>\n",
              "      <td>85.500000</td>\n",
              "      <td>320.489990</td>\n",
              "      <td>604.330017</td>\n",
              "      <td>177.580002</td>\n",
              "      <td>...</td>\n",
              "      <td>4061300</td>\n",
              "      <td>4250000</td>\n",
              "      <td>18260500</td>\n",
              "      <td>4303800</td>\n",
              "      <td>1500400</td>\n",
              "      <td>1353700</td>\n",
              "      <td>1909700</td>\n",
              "      <td>542700</td>\n",
              "      <td>3270200</td>\n",
              "      <td>1421500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-15 00:00:00</th>\n",
              "      <td>113.599998</td>\n",
              "      <td>12.42</td>\n",
              "      <td>188.009995</td>\n",
              "      <td>137.600006</td>\n",
              "      <td>128.350006</td>\n",
              "      <td>98.000000</td>\n",
              "      <td>82.660004</td>\n",
              "      <td>325.500000</td>\n",
              "      <td>595.309998</td>\n",
              "      <td>180.779999</td>\n",
              "      <td>...</td>\n",
              "      <td>2544600</td>\n",
              "      <td>3439500</td>\n",
              "      <td>20137600</td>\n",
              "      <td>4925400</td>\n",
              "      <td>1297000</td>\n",
              "      <td>1309400</td>\n",
              "      <td>3648600</td>\n",
              "      <td>501600</td>\n",
              "      <td>2444400</td>\n",
              "      <td>1714100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-16 00:00:00</th>\n",
              "      <td>114.190002</td>\n",
              "      <td>12.19</td>\n",
              "      <td>189.710007</td>\n",
              "      <td>138.279999</td>\n",
              "      <td>126.279999</td>\n",
              "      <td>100.260002</td>\n",
              "      <td>83.709999</td>\n",
              "      <td>327.320007</td>\n",
              "      <td>602.059998</td>\n",
              "      <td>179.839996</td>\n",
              "      <td>...</td>\n",
              "      <td>3022800</td>\n",
              "      <td>3970800</td>\n",
              "      <td>22469100</td>\n",
              "      <td>3552800</td>\n",
              "      <td>1314800</td>\n",
              "      <td>1554600</td>\n",
              "      <td>2300700</td>\n",
              "      <td>275700</td>\n",
              "      <td>2217300</td>\n",
              "      <td>1566900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-17 00:00:00</th>\n",
              "      <td>113.150002</td>\n",
              "      <td>12.29</td>\n",
              "      <td>189.690002</td>\n",
              "      <td>138.300003</td>\n",
              "      <td>127.150002</td>\n",
              "      <td>99.550003</td>\n",
              "      <td>83.599998</td>\n",
              "      <td>327.829987</td>\n",
              "      <td>602.659973</td>\n",
              "      <td>183.050003</td>\n",
              "      <td>...</td>\n",
              "      <td>1678400</td>\n",
              "      <td>4327900</td>\n",
              "      <td>22984900</td>\n",
              "      <td>2413300</td>\n",
              "      <td>1286600</td>\n",
              "      <td>1089600</td>\n",
              "      <td>2991400</td>\n",
              "      <td>340600</td>\n",
              "      <td>2136200</td>\n",
              "      <td>2425100</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-20 00:00:00</th>\n",
              "      <td>113.980003</td>\n",
              "      <td>12.40</td>\n",
              "      <td>191.449997</td>\n",
              "      <td>138.309998</td>\n",
              "      <td>129.699997</td>\n",
              "      <td>101.199997</td>\n",
              "      <td>84.459999</td>\n",
              "      <td>330.899994</td>\n",
              "      <td>612.700012</td>\n",
              "      <td>183.820007</td>\n",
              "      <td>...</td>\n",
              "      <td>2117800</td>\n",
              "      <td>6312100</td>\n",
              "      <td>17458800</td>\n",
              "      <td>3186400</td>\n",
              "      <td>1147100</td>\n",
              "      <td>915000</td>\n",
              "      <td>1345100</td>\n",
              "      <td>330600</td>\n",
              "      <td>1589000</td>\n",
              "      <td>1056700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-21 00:00:00</th>\n",
              "      <td>123.919998</td>\n",
              "      <td>12.13</td>\n",
              "      <td>190.639999</td>\n",
              "      <td>138.729996</td>\n",
              "      <td>126.820000</td>\n",
              "      <td>101.910004</td>\n",
              "      <td>86.129997</td>\n",
              "      <td>330.260010</td>\n",
              "      <td>610.989990</td>\n",
              "      <td>181.250000</td>\n",
              "      <td>...</td>\n",
              "      <td>1554700</td>\n",
              "      <td>4139200</td>\n",
              "      <td>14989000</td>\n",
              "      <td>4266300</td>\n",
              "      <td>1353600</td>\n",
              "      <td>983700</td>\n",
              "      <td>1629300</td>\n",
              "      <td>360500</td>\n",
              "      <td>2311600</td>\n",
              "      <td>1423800</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-22 00:00:00</th>\n",
              "      <td>123.989998</td>\n",
              "      <td>12.31</td>\n",
              "      <td>191.309998</td>\n",
              "      <td>138.470001</td>\n",
              "      <td>129.039993</td>\n",
              "      <td>102.699997</td>\n",
              "      <td>85.949997</td>\n",
              "      <td>333.130005</td>\n",
              "      <td>619.719971</td>\n",
              "      <td>182.669998</td>\n",
              "      <td>...</td>\n",
              "      <td>1400000</td>\n",
              "      <td>4060400</td>\n",
              "      <td>18072000</td>\n",
              "      <td>3155000</td>\n",
              "      <td>1627700</td>\n",
              "      <td>980600</td>\n",
              "      <td>1246200</td>\n",
              "      <td>550100</td>\n",
              "      <td>1441300</td>\n",
              "      <td>1501500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-24 00:00:00</th>\n",
              "      <td>126.620003</td>\n",
              "      <td>12.31</td>\n",
              "      <td>189.970001</td>\n",
              "      <td>138.669998</td>\n",
              "      <td>128.369995</td>\n",
              "      <td>102.870003</td>\n",
              "      <td>86.599998</td>\n",
              "      <td>334.040009</td>\n",
              "      <td>619.429993</td>\n",
              "      <td>183.050003</td>\n",
              "      <td>...</td>\n",
              "      <td>1008100</td>\n",
              "      <td>1357700</td>\n",
              "      <td>9480800</td>\n",
              "      <td>1294200</td>\n",
              "      <td>797400</td>\n",
              "      <td>555600</td>\n",
              "      <td>605500</td>\n",
              "      <td>195200</td>\n",
              "      <td>584000</td>\n",
              "      <td>635200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-27 00:00:00</th>\n",
              "      <td>125.010002</td>\n",
              "      <td>12.18</td>\n",
              "      <td>189.789993</td>\n",
              "      <td>139.089996</td>\n",
              "      <td>129.000000</td>\n",
              "      <td>102.709999</td>\n",
              "      <td>87.000000</td>\n",
              "      <td>332.429993</td>\n",
              "      <td>619.270020</td>\n",
              "      <td>183.770004</td>\n",
              "      <td>...</td>\n",
              "      <td>1889400</td>\n",
              "      <td>2834500</td>\n",
              "      <td>18013500</td>\n",
              "      <td>3186700</td>\n",
              "      <td>1058800</td>\n",
              "      <td>1143800</td>\n",
              "      <td>1301400</td>\n",
              "      <td>528600</td>\n",
              "      <td>1424200</td>\n",
              "      <td>1442700</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-28 00:00:00</th>\n",
              "      <td>124.709999</td>\n",
              "      <td>12.17</td>\n",
              "      <td>190.399994</td>\n",
              "      <td>138.080002</td>\n",
              "      <td>127.559998</td>\n",
              "      <td>102.059998</td>\n",
              "      <td>84.449997</td>\n",
              "      <td>332.559998</td>\n",
              "      <td>623.320007</td>\n",
              "      <td>183.199997</td>\n",
              "      <td>...</td>\n",
              "      <td>3616000</td>\n",
              "      <td>3667100</td>\n",
              "      <td>20629500</td>\n",
              "      <td>3279400</td>\n",
              "      <td>1293400</td>\n",
              "      <td>1392800</td>\n",
              "      <td>1212800</td>\n",
              "      <td>424900</td>\n",
              "      <td>1922800</td>\n",
              "      <td>1348900</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-29 00:00:00</th>\n",
              "      <td>127.589996</td>\n",
              "      <td>12.23</td>\n",
              "      <td>189.369995</td>\n",
              "      <td>138.500000</td>\n",
              "      <td>126.480003</td>\n",
              "      <td>103.629997</td>\n",
              "      <td>82.379997</td>\n",
              "      <td>333.339996</td>\n",
              "      <td>617.390015</td>\n",
              "      <td>182.710007</td>\n",
              "      <td>...</td>\n",
              "      <td>3810200</td>\n",
              "      <td>4314000</td>\n",
              "      <td>26802100</td>\n",
              "      <td>4093000</td>\n",
              "      <td>1184100</td>\n",
              "      <td>1240100</td>\n",
              "      <td>1311200</td>\n",
              "      <td>372900</td>\n",
              "      <td>2755200</td>\n",
              "      <td>1524400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-30 00:00:00</th>\n",
              "      <td>127.800003</td>\n",
              "      <td>12.43</td>\n",
              "      <td>189.949997</td>\n",
              "      <td>142.389999</td>\n",
              "      <td>126.339996</td>\n",
              "      <td>104.290001</td>\n",
              "      <td>83.690002</td>\n",
              "      <td>333.140015</td>\n",
              "      <td>611.010010</td>\n",
              "      <td>183.380005</td>\n",
              "      <td>...</td>\n",
              "      <td>2324200</td>\n",
              "      <td>4797100</td>\n",
              "      <td>29246900</td>\n",
              "      <td>15902300</td>\n",
              "      <td>2587200</td>\n",
              "      <td>2608900</td>\n",
              "      <td>2678200</td>\n",
              "      <td>492400</td>\n",
              "      <td>2686100</td>\n",
              "      <td>2581900</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>21 rows × 3018 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2ec289ac-7d75-4782-9681-bcf8b60e8c0a')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-2ec289ac-7d75-4782-9681-bcf8b60e8c0a button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-2ec289ac-7d75-4782-9681-bcf8b60e8c0a');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-897dff0b-b25c-42d2-9962-e8063df378e8\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-897dff0b-b25c-42d2-9962-e8063df378e8')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-897dff0b-b25c-42d2-9962-e8063df378e8 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "all_sp500_close_df = all_sp500_df['Close']\n",
        "all_sp500_close_df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "w2JuuEr1guS6",
        "outputId": "c1b67747-31b1-4617-9b61-bd7b43ca8460"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                              A    AAL        AAPL        ABBV        ABNB  \\\n",
              "Date                                                                         \n",
              "2023-11-01 00:00:00  102.860001  11.14  173.970001  142.470001  119.470001   \n",
              "2023-11-02 00:00:00  104.470001  11.40  177.570007  143.259995  115.500000   \n",
              "2023-11-03 00:00:00  109.019997  11.98  176.649994  141.419998  122.639999   \n",
              "2023-11-06 00:00:00  107.529999  11.66  179.229996  141.199997  118.169998   \n",
              "2023-11-07 00:00:00  110.540001  11.75  181.820007  142.160004  121.080002   \n",
              "2023-11-08 00:00:00  109.389999  12.01  182.889999  142.029999  117.660004   \n",
              "2023-11-09 00:00:00  107.739998  11.75  182.410004  138.039993  115.519997   \n",
              "2023-11-10 00:00:00  108.470001  11.80  186.399994  138.589996  118.150002   \n",
              "2023-11-13 00:00:00  107.459999  11.78  184.800003  138.639999  119.150002   \n",
              "2023-11-14 00:00:00  111.610001  12.25  187.440002  138.059998  126.680000   \n",
              "2023-11-15 00:00:00  113.599998  12.42  188.009995  137.600006  128.350006   \n",
              "2023-11-16 00:00:00  114.190002  12.19  189.710007  138.279999  126.279999   \n",
              "2023-11-17 00:00:00  113.150002  12.29  189.690002  138.300003  127.150002   \n",
              "2023-11-20 00:00:00  113.980003  12.40  191.449997  138.309998  129.699997   \n",
              "2023-11-21 00:00:00  123.919998  12.13  190.639999  138.729996  126.820000   \n",
              "2023-11-22 00:00:00  123.989998  12.31  191.309998  138.470001  129.039993   \n",
              "2023-11-24 00:00:00  126.620003  12.31  189.970001  138.669998  128.369995   \n",
              "2023-11-27 00:00:00  125.010002  12.18  189.789993  139.089996  129.000000   \n",
              "2023-11-28 00:00:00  124.709999  12.17  190.399994  138.080002  127.559998   \n",
              "2023-11-29 00:00:00  127.589996  12.23  189.369995  138.500000  126.480003   \n",
              "2023-11-30 00:00:00  127.800003  12.43  189.949997  142.389999  126.339996   \n",
              "\n",
              "                            ABT       ACGL         ACN        ADBE  \\\n",
              "Date                                                                 \n",
              "2023-11-01 00:00:00   95.010002  90.000000  300.640015  544.500000   \n",
              "2023-11-02 00:00:00   95.959999  85.940002  308.119995  558.710022   \n",
              "2023-11-03 00:00:00   95.839996  85.550003  313.489990  563.659973   \n",
              "2023-11-06 00:00:00   95.000000  85.160004  313.089996  565.450012   \n",
              "2023-11-07 00:00:00   94.800003  85.410004  315.190002  585.200012   \n",
              "2023-11-08 00:00:00   94.739998  84.120003  317.820007  585.309998   \n",
              "2023-11-09 00:00:00   93.550003  84.669998  314.220001  577.739990   \n",
              "2023-11-10 00:00:00   93.970001  85.949997  319.690002  597.219971   \n",
              "2023-11-13 00:00:00   95.790001  86.570000  315.630005  590.340027   \n",
              "2023-11-14 00:00:00   97.080002  85.500000  320.489990  604.330017   \n",
              "2023-11-15 00:00:00   98.000000  82.660004  325.500000  595.309998   \n",
              "2023-11-16 00:00:00  100.260002  83.709999  327.320007  602.059998   \n",
              "2023-11-17 00:00:00   99.550003  83.599998  327.829987  602.659973   \n",
              "2023-11-20 00:00:00  101.199997  84.459999  330.899994  612.700012   \n",
              "2023-11-21 00:00:00  101.910004  86.129997  330.260010  610.989990   \n",
              "2023-11-22 00:00:00  102.699997  85.949997  333.130005  619.719971   \n",
              "2023-11-24 00:00:00  102.870003  86.599998  334.040009  619.429993   \n",
              "2023-11-27 00:00:00  102.709999  87.000000  332.429993  619.270020   \n",
              "2023-11-28 00:00:00  102.059998  84.449997  332.559998  623.320007   \n",
              "2023-11-29 00:00:00  103.629997  82.379997  333.339996  617.390015   \n",
              "2023-11-30 00:00:00  104.290001  83.690002  333.140015  611.010010   \n",
              "\n",
              "                            ADI  ...       WYNN        XEL         XOM  \\\n",
              "Date                             ...                                     \n",
              "2023-11-01 00:00:00  159.240005  ...  86.940002  60.540001  105.639999   \n",
              "2023-11-02 00:00:00  164.339996  ...  89.750000  61.070000  109.110001   \n",
              "2023-11-03 00:00:00  167.919998  ...  92.760002  61.029999  107.779999   \n",
              "2023-11-06 00:00:00  167.570007  ...  95.139999  60.560001  105.870003   \n",
              "2023-11-07 00:00:00  168.110001  ...  93.180000  59.830002  104.209999   \n",
              "2023-11-08 00:00:00  168.910004  ...  92.900002  59.080002  102.930000   \n",
              "2023-11-09 00:00:00  167.130005  ...  90.650002  58.700001  102.959999   \n",
              "2023-11-10 00:00:00  172.320007  ...  85.489998  59.200001  103.750000   \n",
              "2023-11-13 00:00:00  170.660004  ...  84.540001  58.270000  104.839996   \n",
              "2023-11-14 00:00:00  177.580002  ...  87.120003  60.299999  104.290001   \n",
              "2023-11-15 00:00:00  180.779999  ...  87.459999  60.090000  103.660004   \n",
              "2023-11-16 00:00:00  179.839996  ...  86.059998  60.700001  102.459999   \n",
              "2023-11-17 00:00:00  183.050003  ...  86.870003  60.560001  104.959999   \n",
              "2023-11-20 00:00:00  183.820007  ...  87.169998  60.060001  104.500000   \n",
              "2023-11-21 00:00:00  181.250000  ...  86.860001  60.020000  104.459999   \n",
              "2023-11-22 00:00:00  182.669998  ...  87.529999  60.430000  104.010002   \n",
              "2023-11-24 00:00:00  183.050003  ...  88.309998  60.520000  104.570000   \n",
              "2023-11-27 00:00:00  183.770004  ...  87.059998  60.450001  103.959999   \n",
              "2023-11-28 00:00:00  183.199997  ...  84.940002  60.970001  103.900002   \n",
              "2023-11-29 00:00:00  182.710007  ...  83.669998  60.000000  102.339996   \n",
              "2023-11-30 00:00:00  183.380005  ...  84.419998  60.840000  102.739998   \n",
              "\n",
              "                          XRAY         XYL         YUM         ZBH  \\\n",
              "Date                                                                 \n",
              "2023-11-01 00:00:00  30.840000   94.480003  121.300003  105.070000   \n",
              "2023-11-02 00:00:00  28.540001   94.309998  124.269997  110.199997   \n",
              "2023-11-03 00:00:00  29.209999   96.930000  126.339996  108.750000   \n",
              "2023-11-06 00:00:00  28.559999   96.160004  126.389999  109.300003   \n",
              "2023-11-07 00:00:00  28.400000   96.769997  125.480003  105.930000   \n",
              "2023-11-08 00:00:00  27.680000   96.809998  125.610001  104.860001   \n",
              "2023-11-09 00:00:00  27.250000   96.820000  124.709999  104.120003   \n",
              "2023-11-10 00:00:00  28.389999   98.459999  125.949997  105.419998   \n",
              "2023-11-13 00:00:00  27.910000   98.510002  125.309998  105.820000   \n",
              "2023-11-14 00:00:00  28.940001  101.199997  127.529999  108.070000   \n",
              "2023-11-15 00:00:00  29.320000  100.239998  126.620003  110.500000   \n",
              "2023-11-16 00:00:00  29.600000  101.260002  127.830002  111.550003   \n",
              "2023-11-17 00:00:00  29.690001  101.160004  127.660004  111.669998   \n",
              "2023-11-20 00:00:00  29.940001  100.209999  128.119995  112.500000   \n",
              "2023-11-21 00:00:00  30.990000  101.019997  128.240005  112.900002   \n",
              "2023-11-22 00:00:00  31.360001  102.220001  128.940002  113.830002   \n",
              "2023-11-24 00:00:00  31.320000  103.260002  128.509995  113.430000   \n",
              "2023-11-27 00:00:00  31.480000  103.180000  127.690002  113.839996   \n",
              "2023-11-28 00:00:00  31.480000  102.639999  126.389999  113.089996   \n",
              "2023-11-29 00:00:00  31.330000  103.500000  125.519997  113.919998   \n",
              "2023-11-30 00:00:00  31.750000  105.129997  125.550003  116.309998   \n",
              "\n",
              "                           ZBRA       ZION         ZTS  \n",
              "Date                                                    \n",
              "2023-11-01 00:00:00  197.990005  31.020000  151.440002  \n",
              "2023-11-02 00:00:00  207.000000  33.230000  160.910004  \n",
              "2023-11-03 00:00:00  214.300003  34.759998  162.229996  \n",
              "2023-11-06 00:00:00  206.020004  34.180000  163.169998  \n",
              "2023-11-07 00:00:00  208.039993  34.099998  167.160004  \n",
              "2023-11-08 00:00:00  206.440002  33.759998  170.869995  \n",
              "2023-11-09 00:00:00  202.520004  32.549999  170.630005  \n",
              "2023-11-10 00:00:00  206.179993  32.919998  169.320007  \n",
              "2023-11-13 00:00:00  202.610001  32.709999  168.830002  \n",
              "2023-11-14 00:00:00  215.660004  35.369999  172.649994  \n",
              "2023-11-15 00:00:00  216.960007  36.080002  174.619995  \n",
              "2023-11-16 00:00:00  215.479996  35.709999  176.539993  \n",
              "2023-11-17 00:00:00  218.020004  36.070000  174.800003  \n",
              "2023-11-20 00:00:00  220.539993  35.779999  176.059998  \n",
              "2023-11-21 00:00:00  222.410004  34.310001  178.729996  \n",
              "2023-11-22 00:00:00  225.860001  34.410000  179.350006  \n",
              "2023-11-24 00:00:00  228.919998  34.349998  180.210007  \n",
              "2023-11-27 00:00:00  231.500000  34.400002  178.789993  \n",
              "2023-11-28 00:00:00  233.889999  34.549999  176.970001  \n",
              "2023-11-29 00:00:00  236.619995  35.439999  175.789993  \n",
              "2023-11-30 00:00:00  236.979996  35.630001  176.669998  \n",
              "\n",
              "[21 rows x 503 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7a97a67d-c26b-478b-8cc5-7fdd632f025f\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>A</th>\n",
              "      <th>AAL</th>\n",
              "      <th>AAPL</th>\n",
              "      <th>ABBV</th>\n",
              "      <th>ABNB</th>\n",
              "      <th>ABT</th>\n",
              "      <th>ACGL</th>\n",
              "      <th>ACN</th>\n",
              "      <th>ADBE</th>\n",
              "      <th>ADI</th>\n",
              "      <th>...</th>\n",
              "      <th>WYNN</th>\n",
              "      <th>XEL</th>\n",
              "      <th>XOM</th>\n",
              "      <th>XRAY</th>\n",
              "      <th>XYL</th>\n",
              "      <th>YUM</th>\n",
              "      <th>ZBH</th>\n",
              "      <th>ZBRA</th>\n",
              "      <th>ZION</th>\n",
              "      <th>ZTS</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Date</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2023-11-01 00:00:00</th>\n",
              "      <td>102.860001</td>\n",
              "      <td>11.14</td>\n",
              "      <td>173.970001</td>\n",
              "      <td>142.470001</td>\n",
              "      <td>119.470001</td>\n",
              "      <td>95.010002</td>\n",
              "      <td>90.000000</td>\n",
              "      <td>300.640015</td>\n",
              "      <td>544.500000</td>\n",
              "      <td>159.240005</td>\n",
              "      <td>...</td>\n",
              "      <td>86.940002</td>\n",
              "      <td>60.540001</td>\n",
              "      <td>105.639999</td>\n",
              "      <td>30.840000</td>\n",
              "      <td>94.480003</td>\n",
              "      <td>121.300003</td>\n",
              "      <td>105.070000</td>\n",
              "      <td>197.990005</td>\n",
              "      <td>31.020000</td>\n",
              "      <td>151.440002</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-02 00:00:00</th>\n",
              "      <td>104.470001</td>\n",
              "      <td>11.40</td>\n",
              "      <td>177.570007</td>\n",
              "      <td>143.259995</td>\n",
              "      <td>115.500000</td>\n",
              "      <td>95.959999</td>\n",
              "      <td>85.940002</td>\n",
              "      <td>308.119995</td>\n",
              "      <td>558.710022</td>\n",
              "      <td>164.339996</td>\n",
              "      <td>...</td>\n",
              "      <td>89.750000</td>\n",
              "      <td>61.070000</td>\n",
              "      <td>109.110001</td>\n",
              "      <td>28.540001</td>\n",
              "      <td>94.309998</td>\n",
              "      <td>124.269997</td>\n",
              "      <td>110.199997</td>\n",
              "      <td>207.000000</td>\n",
              "      <td>33.230000</td>\n",
              "      <td>160.910004</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-03 00:00:00</th>\n",
              "      <td>109.019997</td>\n",
              "      <td>11.98</td>\n",
              "      <td>176.649994</td>\n",
              "      <td>141.419998</td>\n",
              "      <td>122.639999</td>\n",
              "      <td>95.839996</td>\n",
              "      <td>85.550003</td>\n",
              "      <td>313.489990</td>\n",
              "      <td>563.659973</td>\n",
              "      <td>167.919998</td>\n",
              "      <td>...</td>\n",
              "      <td>92.760002</td>\n",
              "      <td>61.029999</td>\n",
              "      <td>107.779999</td>\n",
              "      <td>29.209999</td>\n",
              "      <td>96.930000</td>\n",
              "      <td>126.339996</td>\n",
              "      <td>108.750000</td>\n",
              "      <td>214.300003</td>\n",
              "      <td>34.759998</td>\n",
              "      <td>162.229996</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-06 00:00:00</th>\n",
              "      <td>107.529999</td>\n",
              "      <td>11.66</td>\n",
              "      <td>179.229996</td>\n",
              "      <td>141.199997</td>\n",
              "      <td>118.169998</td>\n",
              "      <td>95.000000</td>\n",
              "      <td>85.160004</td>\n",
              "      <td>313.089996</td>\n",
              "      <td>565.450012</td>\n",
              "      <td>167.570007</td>\n",
              "      <td>...</td>\n",
              "      <td>95.139999</td>\n",
              "      <td>60.560001</td>\n",
              "      <td>105.870003</td>\n",
              "      <td>28.559999</td>\n",
              "      <td>96.160004</td>\n",
              "      <td>126.389999</td>\n",
              "      <td>109.300003</td>\n",
              "      <td>206.020004</td>\n",
              "      <td>34.180000</td>\n",
              "      <td>163.169998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-07 00:00:00</th>\n",
              "      <td>110.540001</td>\n",
              "      <td>11.75</td>\n",
              "      <td>181.820007</td>\n",
              "      <td>142.160004</td>\n",
              "      <td>121.080002</td>\n",
              "      <td>94.800003</td>\n",
              "      <td>85.410004</td>\n",
              "      <td>315.190002</td>\n",
              "      <td>585.200012</td>\n",
              "      <td>168.110001</td>\n",
              "      <td>...</td>\n",
              "      <td>93.180000</td>\n",
              "      <td>59.830002</td>\n",
              "      <td>104.209999</td>\n",
              "      <td>28.400000</td>\n",
              "      <td>96.769997</td>\n",
              "      <td>125.480003</td>\n",
              "      <td>105.930000</td>\n",
              "      <td>208.039993</td>\n",
              "      <td>34.099998</td>\n",
              "      <td>167.160004</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-08 00:00:00</th>\n",
              "      <td>109.389999</td>\n",
              "      <td>12.01</td>\n",
              "      <td>182.889999</td>\n",
              "      <td>142.029999</td>\n",
              "      <td>117.660004</td>\n",
              "      <td>94.739998</td>\n",
              "      <td>84.120003</td>\n",
              "      <td>317.820007</td>\n",
              "      <td>585.309998</td>\n",
              "      <td>168.910004</td>\n",
              "      <td>...</td>\n",
              "      <td>92.900002</td>\n",
              "      <td>59.080002</td>\n",
              "      <td>102.930000</td>\n",
              "      <td>27.680000</td>\n",
              "      <td>96.809998</td>\n",
              "      <td>125.610001</td>\n",
              "      <td>104.860001</td>\n",
              "      <td>206.440002</td>\n",
              "      <td>33.759998</td>\n",
              "      <td>170.869995</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-09 00:00:00</th>\n",
              "      <td>107.739998</td>\n",
              "      <td>11.75</td>\n",
              "      <td>182.410004</td>\n",
              "      <td>138.039993</td>\n",
              "      <td>115.519997</td>\n",
              "      <td>93.550003</td>\n",
              "      <td>84.669998</td>\n",
              "      <td>314.220001</td>\n",
              "      <td>577.739990</td>\n",
              "      <td>167.130005</td>\n",
              "      <td>...</td>\n",
              "      <td>90.650002</td>\n",
              "      <td>58.700001</td>\n",
              "      <td>102.959999</td>\n",
              "      <td>27.250000</td>\n",
              "      <td>96.820000</td>\n",
              "      <td>124.709999</td>\n",
              "      <td>104.120003</td>\n",
              "      <td>202.520004</td>\n",
              "      <td>32.549999</td>\n",
              "      <td>170.630005</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-10 00:00:00</th>\n",
              "      <td>108.470001</td>\n",
              "      <td>11.80</td>\n",
              "      <td>186.399994</td>\n",
              "      <td>138.589996</td>\n",
              "      <td>118.150002</td>\n",
              "      <td>93.970001</td>\n",
              "      <td>85.949997</td>\n",
              "      <td>319.690002</td>\n",
              "      <td>597.219971</td>\n",
              "      <td>172.320007</td>\n",
              "      <td>...</td>\n",
              "      <td>85.489998</td>\n",
              "      <td>59.200001</td>\n",
              "      <td>103.750000</td>\n",
              "      <td>28.389999</td>\n",
              "      <td>98.459999</td>\n",
              "      <td>125.949997</td>\n",
              "      <td>105.419998</td>\n",
              "      <td>206.179993</td>\n",
              "      <td>32.919998</td>\n",
              "      <td>169.320007</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-13 00:00:00</th>\n",
              "      <td>107.459999</td>\n",
              "      <td>11.78</td>\n",
              "      <td>184.800003</td>\n",
              "      <td>138.639999</td>\n",
              "      <td>119.150002</td>\n",
              "      <td>95.790001</td>\n",
              "      <td>86.570000</td>\n",
              "      <td>315.630005</td>\n",
              "      <td>590.340027</td>\n",
              "      <td>170.660004</td>\n",
              "      <td>...</td>\n",
              "      <td>84.540001</td>\n",
              "      <td>58.270000</td>\n",
              "      <td>104.839996</td>\n",
              "      <td>27.910000</td>\n",
              "      <td>98.510002</td>\n",
              "      <td>125.309998</td>\n",
              "      <td>105.820000</td>\n",
              "      <td>202.610001</td>\n",
              "      <td>32.709999</td>\n",
              "      <td>168.830002</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-14 00:00:00</th>\n",
              "      <td>111.610001</td>\n",
              "      <td>12.25</td>\n",
              "      <td>187.440002</td>\n",
              "      <td>138.059998</td>\n",
              "      <td>126.680000</td>\n",
              "      <td>97.080002</td>\n",
              "      <td>85.500000</td>\n",
              "      <td>320.489990</td>\n",
              "      <td>604.330017</td>\n",
              "      <td>177.580002</td>\n",
              "      <td>...</td>\n",
              "      <td>87.120003</td>\n",
              "      <td>60.299999</td>\n",
              "      <td>104.290001</td>\n",
              "      <td>28.940001</td>\n",
              "      <td>101.199997</td>\n",
              "      <td>127.529999</td>\n",
              "      <td>108.070000</td>\n",
              "      <td>215.660004</td>\n",
              "      <td>35.369999</td>\n",
              "      <td>172.649994</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-15 00:00:00</th>\n",
              "      <td>113.599998</td>\n",
              "      <td>12.42</td>\n",
              "      <td>188.009995</td>\n",
              "      <td>137.600006</td>\n",
              "      <td>128.350006</td>\n",
              "      <td>98.000000</td>\n",
              "      <td>82.660004</td>\n",
              "      <td>325.500000</td>\n",
              "      <td>595.309998</td>\n",
              "      <td>180.779999</td>\n",
              "      <td>...</td>\n",
              "      <td>87.459999</td>\n",
              "      <td>60.090000</td>\n",
              "      <td>103.660004</td>\n",
              "      <td>29.320000</td>\n",
              "      <td>100.239998</td>\n",
              "      <td>126.620003</td>\n",
              "      <td>110.500000</td>\n",
              "      <td>216.960007</td>\n",
              "      <td>36.080002</td>\n",
              "      <td>174.619995</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-16 00:00:00</th>\n",
              "      <td>114.190002</td>\n",
              "      <td>12.19</td>\n",
              "      <td>189.710007</td>\n",
              "      <td>138.279999</td>\n",
              "      <td>126.279999</td>\n",
              "      <td>100.260002</td>\n",
              "      <td>83.709999</td>\n",
              "      <td>327.320007</td>\n",
              "      <td>602.059998</td>\n",
              "      <td>179.839996</td>\n",
              "      <td>...</td>\n",
              "      <td>86.059998</td>\n",
              "      <td>60.700001</td>\n",
              "      <td>102.459999</td>\n",
              "      <td>29.600000</td>\n",
              "      <td>101.260002</td>\n",
              "      <td>127.830002</td>\n",
              "      <td>111.550003</td>\n",
              "      <td>215.479996</td>\n",
              "      <td>35.709999</td>\n",
              "      <td>176.539993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-17 00:00:00</th>\n",
              "      <td>113.150002</td>\n",
              "      <td>12.29</td>\n",
              "      <td>189.690002</td>\n",
              "      <td>138.300003</td>\n",
              "      <td>127.150002</td>\n",
              "      <td>99.550003</td>\n",
              "      <td>83.599998</td>\n",
              "      <td>327.829987</td>\n",
              "      <td>602.659973</td>\n",
              "      <td>183.050003</td>\n",
              "      <td>...</td>\n",
              "      <td>86.870003</td>\n",
              "      <td>60.560001</td>\n",
              "      <td>104.959999</td>\n",
              "      <td>29.690001</td>\n",
              "      <td>101.160004</td>\n",
              "      <td>127.660004</td>\n",
              "      <td>111.669998</td>\n",
              "      <td>218.020004</td>\n",
              "      <td>36.070000</td>\n",
              "      <td>174.800003</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-20 00:00:00</th>\n",
              "      <td>113.980003</td>\n",
              "      <td>12.40</td>\n",
              "      <td>191.449997</td>\n",
              "      <td>138.309998</td>\n",
              "      <td>129.699997</td>\n",
              "      <td>101.199997</td>\n",
              "      <td>84.459999</td>\n",
              "      <td>330.899994</td>\n",
              "      <td>612.700012</td>\n",
              "      <td>183.820007</td>\n",
              "      <td>...</td>\n",
              "      <td>87.169998</td>\n",
              "      <td>60.060001</td>\n",
              "      <td>104.500000</td>\n",
              "      <td>29.940001</td>\n",
              "      <td>100.209999</td>\n",
              "      <td>128.119995</td>\n",
              "      <td>112.500000</td>\n",
              "      <td>220.539993</td>\n",
              "      <td>35.779999</td>\n",
              "      <td>176.059998</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-21 00:00:00</th>\n",
              "      <td>123.919998</td>\n",
              "      <td>12.13</td>\n",
              "      <td>190.639999</td>\n",
              "      <td>138.729996</td>\n",
              "      <td>126.820000</td>\n",
              "      <td>101.910004</td>\n",
              "      <td>86.129997</td>\n",
              "      <td>330.260010</td>\n",
              "      <td>610.989990</td>\n",
              "      <td>181.250000</td>\n",
              "      <td>...</td>\n",
              "      <td>86.860001</td>\n",
              "      <td>60.020000</td>\n",
              "      <td>104.459999</td>\n",
              "      <td>30.990000</td>\n",
              "      <td>101.019997</td>\n",
              "      <td>128.240005</td>\n",
              "      <td>112.900002</td>\n",
              "      <td>222.410004</td>\n",
              "      <td>34.310001</td>\n",
              "      <td>178.729996</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-22 00:00:00</th>\n",
              "      <td>123.989998</td>\n",
              "      <td>12.31</td>\n",
              "      <td>191.309998</td>\n",
              "      <td>138.470001</td>\n",
              "      <td>129.039993</td>\n",
              "      <td>102.699997</td>\n",
              "      <td>85.949997</td>\n",
              "      <td>333.130005</td>\n",
              "      <td>619.719971</td>\n",
              "      <td>182.669998</td>\n",
              "      <td>...</td>\n",
              "      <td>87.529999</td>\n",
              "      <td>60.430000</td>\n",
              "      <td>104.010002</td>\n",
              "      <td>31.360001</td>\n",
              "      <td>102.220001</td>\n",
              "      <td>128.940002</td>\n",
              "      <td>113.830002</td>\n",
              "      <td>225.860001</td>\n",
              "      <td>34.410000</td>\n",
              "      <td>179.350006</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-24 00:00:00</th>\n",
              "      <td>126.620003</td>\n",
              "      <td>12.31</td>\n",
              "      <td>189.970001</td>\n",
              "      <td>138.669998</td>\n",
              "      <td>128.369995</td>\n",
              "      <td>102.870003</td>\n",
              "      <td>86.599998</td>\n",
              "      <td>334.040009</td>\n",
              "      <td>619.429993</td>\n",
              "      <td>183.050003</td>\n",
              "      <td>...</td>\n",
              "      <td>88.309998</td>\n",
              "      <td>60.520000</td>\n",
              "      <td>104.570000</td>\n",
              "      <td>31.320000</td>\n",
              "      <td>103.260002</td>\n",
              "      <td>128.509995</td>\n",
              "      <td>113.430000</td>\n",
              "      <td>228.919998</td>\n",
              "      <td>34.349998</td>\n",
              "      <td>180.210007</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-27 00:00:00</th>\n",
              "      <td>125.010002</td>\n",
              "      <td>12.18</td>\n",
              "      <td>189.789993</td>\n",
              "      <td>139.089996</td>\n",
              "      <td>129.000000</td>\n",
              "      <td>102.709999</td>\n",
              "      <td>87.000000</td>\n",
              "      <td>332.429993</td>\n",
              "      <td>619.270020</td>\n",
              "      <td>183.770004</td>\n",
              "      <td>...</td>\n",
              "      <td>87.059998</td>\n",
              "      <td>60.450001</td>\n",
              "      <td>103.959999</td>\n",
              "      <td>31.480000</td>\n",
              "      <td>103.180000</td>\n",
              "      <td>127.690002</td>\n",
              "      <td>113.839996</td>\n",
              "      <td>231.500000</td>\n",
              "      <td>34.400002</td>\n",
              "      <td>178.789993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-28 00:00:00</th>\n",
              "      <td>124.709999</td>\n",
              "      <td>12.17</td>\n",
              "      <td>190.399994</td>\n",
              "      <td>138.080002</td>\n",
              "      <td>127.559998</td>\n",
              "      <td>102.059998</td>\n",
              "      <td>84.449997</td>\n",
              "      <td>332.559998</td>\n",
              "      <td>623.320007</td>\n",
              "      <td>183.199997</td>\n",
              "      <td>...</td>\n",
              "      <td>84.940002</td>\n",
              "      <td>60.970001</td>\n",
              "      <td>103.900002</td>\n",
              "      <td>31.480000</td>\n",
              "      <td>102.639999</td>\n",
              "      <td>126.389999</td>\n",
              "      <td>113.089996</td>\n",
              "      <td>233.889999</td>\n",
              "      <td>34.549999</td>\n",
              "      <td>176.970001</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-29 00:00:00</th>\n",
              "      <td>127.589996</td>\n",
              "      <td>12.23</td>\n",
              "      <td>189.369995</td>\n",
              "      <td>138.500000</td>\n",
              "      <td>126.480003</td>\n",
              "      <td>103.629997</td>\n",
              "      <td>82.379997</td>\n",
              "      <td>333.339996</td>\n",
              "      <td>617.390015</td>\n",
              "      <td>182.710007</td>\n",
              "      <td>...</td>\n",
              "      <td>83.669998</td>\n",
              "      <td>60.000000</td>\n",
              "      <td>102.339996</td>\n",
              "      <td>31.330000</td>\n",
              "      <td>103.500000</td>\n",
              "      <td>125.519997</td>\n",
              "      <td>113.919998</td>\n",
              "      <td>236.619995</td>\n",
              "      <td>35.439999</td>\n",
              "      <td>175.789993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2023-11-30 00:00:00</th>\n",
              "      <td>127.800003</td>\n",
              "      <td>12.43</td>\n",
              "      <td>189.949997</td>\n",
              "      <td>142.389999</td>\n",
              "      <td>126.339996</td>\n",
              "      <td>104.290001</td>\n",
              "      <td>83.690002</td>\n",
              "      <td>333.140015</td>\n",
              "      <td>611.010010</td>\n",
              "      <td>183.380005</td>\n",
              "      <td>...</td>\n",
              "      <td>84.419998</td>\n",
              "      <td>60.840000</td>\n",
              "      <td>102.739998</td>\n",
              "      <td>31.750000</td>\n",
              "      <td>105.129997</td>\n",
              "      <td>125.550003</td>\n",
              "      <td>116.309998</td>\n",
              "      <td>236.979996</td>\n",
              "      <td>35.630001</td>\n",
              "      <td>176.669998</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>21 rows × 503 columns</p>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7a97a67d-c26b-478b-8cc5-7fdd632f025f')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-7a97a67d-c26b-478b-8cc5-7fdd632f025f button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-7a97a67d-c26b-478b-8cc5-7fdd632f025f');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-43df58ee-1069-47fc-a7dc-60e0f4f1a1dd\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-43df58ee-1069-47fc-a7dc-60e0f4f1a1dd')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-43df58ee-1069-47fc-a7dc-60e0f4f1a1dd button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "mG_IaWYdigft"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}