02-Getting data from yfinance.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "4c66452d",
   "metadata": {},
   "source": [
    "## Importing libraries and dependencies"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "15de817e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# yfinance is where we will pull our data from\n",
    "import yfinance as yf\n",
    "# pandas for dealing with DataFrames\n",
    "import pandas as pd\n",
    "# numpy for using mathematical functions\n",
    "import numpy as np\n",
    "# matplotlib for visualization\n",
    "import matplotlib.pyplot as plt\n",
    "# Turning off the warnings\n",
    "# pd.options.mode.chained_assignment = None\n",
    "# request library\n",
    "import requests"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f39c2302",
   "metadata": {},
   "source": [
    "## Pulling data for 1 ticker using yfinance"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "6a2408ba",
   "metadata": {},
   "source": [
    "### 1. Getting used to the syntax for downloading data from yfinance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "425f0285",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  1 of 1 completed\n"
     ]
    }
   ],
   "source": [
    "# pulling data of APPL stock from start of 2010 till now\n",
    "# if we do not put in the end date then by default it would be today's date\n",
    "Apple = yf.download('AAPL', start = '2010-01-01')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "0322b325",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>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>2010-01-04</th>\n",
       "      <td>7.622500</td>\n",
       "      <td>7.660714</td>\n",
       "      <td>7.585000</td>\n",
       "      <td>7.643214</td>\n",
       "      <td>6.544689</td>\n",
       "      <td>493729600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-05</th>\n",
       "      <td>7.664286</td>\n",
       "      <td>7.699643</td>\n",
       "      <td>7.616071</td>\n",
       "      <td>7.656429</td>\n",
       "      <td>6.556004</td>\n",
       "      <td>601904800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-06</th>\n",
       "      <td>7.656429</td>\n",
       "      <td>7.686786</td>\n",
       "      <td>7.526786</td>\n",
       "      <td>7.534643</td>\n",
       "      <td>6.451721</td>\n",
       "      <td>552160000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-07</th>\n",
       "      <td>7.562500</td>\n",
       "      <td>7.571429</td>\n",
       "      <td>7.466071</td>\n",
       "      <td>7.520714</td>\n",
       "      <td>6.439795</td>\n",
       "      <td>477131200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-08</th>\n",
       "      <td>7.510714</td>\n",
       "      <td>7.571429</td>\n",
       "      <td>7.466429</td>\n",
       "      <td>7.570714</td>\n",
       "      <td>6.482608</td>\n",
       "      <td>447610800</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>2022-04-05</th>\n",
       "      <td>177.500000</td>\n",
       "      <td>178.300003</td>\n",
       "      <td>174.419998</td>\n",
       "      <td>175.059998</td>\n",
       "      <td>175.059998</td>\n",
       "      <td>73401800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-06</th>\n",
       "      <td>172.360001</td>\n",
       "      <td>173.630005</td>\n",
       "      <td>170.130005</td>\n",
       "      <td>171.830002</td>\n",
       "      <td>171.830002</td>\n",
       "      <td>89058800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-07</th>\n",
       "      <td>171.160004</td>\n",
       "      <td>173.360001</td>\n",
       "      <td>169.850006</td>\n",
       "      <td>172.139999</td>\n",
       "      <td>172.139999</td>\n",
       "      <td>77594700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-08</th>\n",
       "      <td>171.779999</td>\n",
       "      <td>171.779999</td>\n",
       "      <td>169.199997</td>\n",
       "      <td>170.089996</td>\n",
       "      <td>170.089996</td>\n",
       "      <td>76515900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-11</th>\n",
       "      <td>168.710007</td>\n",
       "      <td>169.020004</td>\n",
       "      <td>165.500000</td>\n",
       "      <td>165.750000</td>\n",
       "      <td>165.750000</td>\n",
       "      <td>71874788</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3090 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Open        High         Low       Close   Adj Close  \\\n",
       "Date                                                                     \n",
       "2010-01-04    7.622500    7.660714    7.585000    7.643214    6.544689   \n",
       "2010-01-05    7.664286    7.699643    7.616071    7.656429    6.556004   \n",
       "2010-01-06    7.656429    7.686786    7.526786    7.534643    6.451721   \n",
       "2010-01-07    7.562500    7.571429    7.466071    7.520714    6.439795   \n",
       "2010-01-08    7.510714    7.571429    7.466429    7.570714    6.482608   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "2022-04-05  177.500000  178.300003  174.419998  175.059998  175.059998   \n",
       "2022-04-06  172.360001  173.630005  170.130005  171.830002  171.830002   \n",
       "2022-04-07  171.160004  173.360001  169.850006  172.139999  172.139999   \n",
       "2022-04-08  171.779999  171.779999  169.199997  170.089996  170.089996   \n",
       "2022-04-11  168.710007  169.020004  165.500000  165.750000  165.750000   \n",
       "\n",
       "               Volume  \n",
       "Date                   \n",
       "2010-01-04  493729600  \n",
       "2010-01-05  601904800  \n",
       "2010-01-06  552160000  \n",
       "2010-01-07  477131200  \n",
       "2010-01-08  447610800  \n",
       "...               ...  \n",
       "2022-04-05   73401800  \n",
       "2022-04-06   89058800  \n",
       "2022-04-07   77594700  \n",
       "2022-04-08   76515900  \n",
       "2022-04-11   71874788  \n",
       "\n",
       "[3090 rows x 6 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lets see what data are we getting for APPL stock\n",
    "# As you can see that the start date in the data is January 04 not 01 it is because of the weekend holidays when the market was close\n",
    "Apple"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "b60404b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# reading tickers_spy.csv\n",
    "tickers = pd.read_csv(\"tickers_spy.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "0814f627",
   "metadata": {},
   "outputs": [],
   "source": [
    "tickers = tickers.values.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8dadc269",
   "metadata": {},
   "outputs": [],
   "source": [
    "tickers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "e76b75c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "flat_tickers = [item for sublist in tickers for item in sublist]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bf010084",
   "metadata": {},
   "outputs": [],
   "source": [
    "flat_tickers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "f39430b3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  505 of 505 completed\n"
     ]
    }
   ],
   "source": [
    "stocks = yf.download(flat_tickers, start = '2010-01-01')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "0296141a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>AAP</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>ABBV</th>\n",
       "      <th>ABC</th>\n",
       "      <th>ABMD</th>\n",
       "      <th>ABT</th>\n",
       "      <th>ACN</th>\n",
       "      <th>ADBE</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>2010-01-04</th>\n",
       "      <td>20.182621</td>\n",
       "      <td>4.496877</td>\n",
       "      <td>38.154903</td>\n",
       "      <td>6.544688</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.101797</td>\n",
       "      <td>8.740000</td>\n",
       "      <td>19.778837</td>\n",
       "      <td>33.334301</td>\n",
       "      <td>37.090000</td>\n",
       "      <td>...</td>\n",
       "      <td>4741400.0</td>\n",
       "      <td>2670400.0</td>\n",
       "      <td>27809100.0</td>\n",
       "      <td>1051400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2962274.0</td>\n",
       "      <td>805872.0</td>\n",
       "      <td>168800.0</td>\n",
       "      <td>3974600.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-05</th>\n",
       "      <td>19.963375</td>\n",
       "      <td>5.005957</td>\n",
       "      <td>37.928116</td>\n",
       "      <td>6.556004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.944105</td>\n",
       "      <td>8.530000</td>\n",
       "      <td>19.619041</td>\n",
       "      <td>33.540310</td>\n",
       "      <td>37.700001</td>\n",
       "      <td>...</td>\n",
       "      <td>5644300.0</td>\n",
       "      <td>4321400.0</td>\n",
       "      <td>30174700.0</td>\n",
       "      <td>763400.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3298757.0</td>\n",
       "      <td>1769643.0</td>\n",
       "      <td>168800.0</td>\n",
       "      <td>5605500.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-06</th>\n",
       "      <td>19.892447</td>\n",
       "      <td>4.798555</td>\n",
       "      <td>38.258835</td>\n",
       "      <td>6.451721</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.736616</td>\n",
       "      <td>8.400000</td>\n",
       "      <td>19.727999</td>\n",
       "      <td>33.896866</td>\n",
       "      <td>37.619999</td>\n",
       "      <td>...</td>\n",
       "      <td>2738800.0</td>\n",
       "      <td>2164500.0</td>\n",
       "      <td>35044700.0</td>\n",
       "      <td>1595100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4178981.0</td>\n",
       "      <td>1315619.0</td>\n",
       "      <td>385300.0</td>\n",
       "      <td>12615200.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-07</th>\n",
       "      <td>19.866661</td>\n",
       "      <td>4.939965</td>\n",
       "      <td>38.249397</td>\n",
       "      <td>6.439795</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.388035</td>\n",
       "      <td>8.400000</td>\n",
       "      <td>19.891426</td>\n",
       "      <td>33.865170</td>\n",
       "      <td>36.889999</td>\n",
       "      <td>...</td>\n",
       "      <td>2388500.0</td>\n",
       "      <td>3041700.0</td>\n",
       "      <td>27192100.0</td>\n",
       "      <td>1096100.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2452472.0</td>\n",
       "      <td>1734005.0</td>\n",
       "      <td>183600.0</td>\n",
       "      <td>24716800.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-08</th>\n",
       "      <td>19.860210</td>\n",
       "      <td>4.845691</td>\n",
       "      <td>38.400570</td>\n",
       "      <td>6.482610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.620428</td>\n",
       "      <td>8.230000</td>\n",
       "      <td>19.993120</td>\n",
       "      <td>33.730465</td>\n",
       "      <td>36.689999</td>\n",
       "      <td>...</td>\n",
       "      <td>1539800.0</td>\n",
       "      <td>1599100.0</td>\n",
       "      <td>24891800.0</td>\n",
       "      <td>803600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3772392.0</td>\n",
       "      <td>2213985.0</td>\n",
       "      <td>266500.0</td>\n",
       "      <td>6903000.0</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-04</th>\n",
       "      <td>134.809998</td>\n",
       "      <td>18.230000</td>\n",
       "      <td>211.919998</td>\n",
       "      <td>178.440002</td>\n",
       "      <td>161.889999</td>\n",
       "      <td>154.750000</td>\n",
       "      <td>325.700012</td>\n",
       "      <td>118.879997</td>\n",
       "      <td>344.470001</td>\n",
       "      <td>468.809998</td>\n",
       "      <td>...</td>\n",
       "      <td>2171400.0</td>\n",
       "      <td>2082300.0</td>\n",
       "      <td>20869400.0</td>\n",
       "      <td>1036400.0</td>\n",
       "      <td>850700.0</td>\n",
       "      <td>1980400.0</td>\n",
       "      <td>1349700.0</td>\n",
       "      <td>492300.0</td>\n",
       "      <td>1220400.0</td>\n",
       "      <td>2603600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-05</th>\n",
       "      <td>133.259995</td>\n",
       "      <td>17.840000</td>\n",
       "      <td>211.729996</td>\n",
       "      <td>175.059998</td>\n",
       "      <td>163.429993</td>\n",
       "      <td>155.759995</td>\n",
       "      <td>322.660004</td>\n",
       "      <td>119.480003</td>\n",
       "      <td>342.820007</td>\n",
       "      <td>458.579987</td>\n",
       "      <td>...</td>\n",
       "      <td>2807100.0</td>\n",
       "      <td>2979400.0</td>\n",
       "      <td>21753100.0</td>\n",
       "      <td>1410600.0</td>\n",
       "      <td>1346100.0</td>\n",
       "      <td>2010900.0</td>\n",
       "      <td>2187100.0</td>\n",
       "      <td>456700.0</td>\n",
       "      <td>1384200.0</td>\n",
       "      <td>2059300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-06</th>\n",
       "      <td>132.710007</td>\n",
       "      <td>17.379999</td>\n",
       "      <td>212.830002</td>\n",
       "      <td>171.830002</td>\n",
       "      <td>168.910004</td>\n",
       "      <td>158.139999</td>\n",
       "      <td>313.760010</td>\n",
       "      <td>119.940002</td>\n",
       "      <td>340.260010</td>\n",
       "      <td>444.329987</td>\n",
       "      <td>...</td>\n",
       "      <td>2926500.0</td>\n",
       "      <td>3350600.0</td>\n",
       "      <td>24768200.0</td>\n",
       "      <td>1706000.0</td>\n",
       "      <td>1271300.0</td>\n",
       "      <td>1683100.0</td>\n",
       "      <td>2057700.0</td>\n",
       "      <td>442300.0</td>\n",
       "      <td>1568200.0</td>\n",
       "      <td>2843500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-07</th>\n",
       "      <td>135.929993</td>\n",
       "      <td>16.950001</td>\n",
       "      <td>217.580002</td>\n",
       "      <td>172.139999</td>\n",
       "      <td>173.279999</td>\n",
       "      <td>162.919998</td>\n",
       "      <td>317.519989</td>\n",
       "      <td>123.370003</td>\n",
       "      <td>341.769989</td>\n",
       "      <td>452.720001</td>\n",
       "      <td>...</td>\n",
       "      <td>3437600.0</td>\n",
       "      <td>3228700.0</td>\n",
       "      <td>26122000.0</td>\n",
       "      <td>1240400.0</td>\n",
       "      <td>1153100.0</td>\n",
       "      <td>2008900.0</td>\n",
       "      <td>1800200.0</td>\n",
       "      <td>464500.0</td>\n",
       "      <td>1093500.0</td>\n",
       "      <td>2781400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-08</th>\n",
       "      <td>134.869995</td>\n",
       "      <td>16.590000</td>\n",
       "      <td>225.740005</td>\n",
       "      <td>170.089996</td>\n",
       "      <td>174.960007</td>\n",
       "      <td>165.440002</td>\n",
       "      <td>314.529999</td>\n",
       "      <td>123.250000</td>\n",
       "      <td>338.920013</td>\n",
       "      <td>445.339996</td>\n",
       "      <td>...</td>\n",
       "      <td>2418800.0</td>\n",
       "      <td>2115100.0</td>\n",
       "      <td>24863600.0</td>\n",
       "      <td>1252100.0</td>\n",
       "      <td>1363500.0</td>\n",
       "      <td>1743200.0</td>\n",
       "      <td>1107600.0</td>\n",
       "      <td>387600.0</td>\n",
       "      <td>889300.0</td>\n",
       "      <td>2455500.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3093 rows × 3030 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Adj Close                                                 \\\n",
       "                     A        AAL         AAP        AAPL        ABBV   \n",
       "Date                                                                    \n",
       "2010-01-04   20.182621   4.496877   38.154903    6.544688         NaN   \n",
       "2010-01-05   19.963375   5.005957   37.928116    6.556004         NaN   \n",
       "2010-01-06   19.892447   4.798555   38.258835    6.451721         NaN   \n",
       "2010-01-07   19.866661   4.939965   38.249397    6.439795         NaN   \n",
       "2010-01-08   19.860210   4.845691   38.400570    6.482610         NaN   \n",
       "...                ...        ...         ...         ...         ...   \n",
       "2022-04-04  134.809998  18.230000  211.919998  178.440002  161.889999   \n",
       "2022-04-05  133.259995  17.840000  211.729996  175.059998  163.429993   \n",
       "2022-04-06  132.710007  17.379999  212.830002  171.830002  168.910004   \n",
       "2022-04-07  135.929993  16.950001  217.580002  172.139999  173.279999   \n",
       "2022-04-08  134.869995  16.590000  225.740005  170.089996  174.960007   \n",
       "\n",
       "                                                                        ...  \\\n",
       "                   ABC        ABMD         ABT         ACN        ADBE  ...   \n",
       "Date                                                                    ...   \n",
       "2010-01-04   22.101797    8.740000   19.778837   33.334301   37.090000  ...   \n",
       "2010-01-05   21.944105    8.530000   19.619041   33.540310   37.700001  ...   \n",
       "2010-01-06   21.736616    8.400000   19.727999   33.896866   37.619999  ...   \n",
       "2010-01-07   21.388035    8.400000   19.891426   33.865170   36.889999  ...   \n",
       "2010-01-08   21.620428    8.230000   19.993120   33.730465   36.689999  ...   \n",
       "...                ...         ...         ...         ...         ...  ...   \n",
       "2022-04-04  154.750000  325.700012  118.879997  344.470001  468.809998  ...   \n",
       "2022-04-05  155.759995  322.660004  119.480003  342.820007  458.579987  ...   \n",
       "2022-04-06  158.139999  313.760010  119.940002  340.260010  444.329987  ...   \n",
       "2022-04-07  162.919998  317.519989  123.370003  341.769989  452.720001  ...   \n",
       "2022-04-08  165.440002  314.529999  123.250000  338.920013  445.339996  ...   \n",
       "\n",
       "               Volume                                                          \\\n",
       "                 WYNN        XEL         XOM       XRAY        XYL        YUM   \n",
       "Date                                                                            \n",
       "2010-01-04  4741400.0  2670400.0  27809100.0  1051400.0        NaN  2962274.0   \n",
       "2010-01-05  5644300.0  4321400.0  30174700.0   763400.0        NaN  3298757.0   \n",
       "2010-01-06  2738800.0  2164500.0  35044700.0  1595100.0        NaN  4178981.0   \n",
       "2010-01-07  2388500.0  3041700.0  27192100.0  1096100.0        NaN  2452472.0   \n",
       "2010-01-08  1539800.0  1599100.0  24891800.0   803600.0        NaN  3772392.0   \n",
       "...               ...        ...         ...        ...        ...        ...   \n",
       "2022-04-04  2171400.0  2082300.0  20869400.0  1036400.0   850700.0  1980400.0   \n",
       "2022-04-05  2807100.0  2979400.0  21753100.0  1410600.0  1346100.0  2010900.0   \n",
       "2022-04-06  2926500.0  3350600.0  24768200.0  1706000.0  1271300.0  1683100.0   \n",
       "2022-04-07  3437600.0  3228700.0  26122000.0  1240400.0  1153100.0  2008900.0   \n",
       "2022-04-08  2418800.0  2115100.0  24863600.0  1252100.0  1363500.0  1743200.0   \n",
       "\n",
       "                                                        \n",
       "                  ZBH      ZBRA        ZION        ZTS  \n",
       "Date                                                    \n",
       "2010-01-04   805872.0  168800.0   3974600.0        NaN  \n",
       "2010-01-05  1769643.0  168800.0   5605500.0        NaN  \n",
       "2010-01-06  1315619.0  385300.0  12615200.0        NaN  \n",
       "2010-01-07  1734005.0  183600.0  24716800.0        NaN  \n",
       "2010-01-08  2213985.0  266500.0   6903000.0        NaN  \n",
       "...               ...       ...         ...        ...  \n",
       "2022-04-04  1349700.0  492300.0   1220400.0  2603600.0  \n",
       "2022-04-05  2187100.0  456700.0   1384200.0  2059300.0  \n",
       "2022-04-06  2057700.0  442300.0   1568200.0  2843500.0  \n",
       "2022-04-07  1800200.0  464500.0   1093500.0  2781400.0  \n",
       "2022-04-08  1107600.0  387600.0    889300.0  2455500.0  \n",
       "\n",
       "[3093 rows x 3030 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "9f8b0a36",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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>AAP</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>ABBV</th>\n",
       "      <th>ABC</th>\n",
       "      <th>ABMD</th>\n",
       "      <th>ABT</th>\n",
       "      <th>ACN</th>\n",
       "      <th>ADBE</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>2022-01-19</th>\n",
       "      <td>140.209869</td>\n",
       "      <td>17.309999</td>\n",
       "      <td>232.646133</td>\n",
       "      <td>166.018478</td>\n",
       "      <td>135.210007</td>\n",
       "      <td>131.959732</td>\n",
       "      <td>302.019989</td>\n",
       "      <td>126.050003</td>\n",
       "      <td>343.739990</td>\n",
       "      <td>516.580017</td>\n",
       "      <td>...</td>\n",
       "      <td>3154800.0</td>\n",
       "      <td>3758100.0</td>\n",
       "      <td>26431600.0</td>\n",
       "      <td>1027000.0</td>\n",
       "      <td>1529200.0</td>\n",
       "      <td>2100100.0</td>\n",
       "      <td>1795084.0</td>\n",
       "      <td>308200.0</td>\n",
       "      <td>1939400.0</td>\n",
       "      <td>2159600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-20</th>\n",
       "      <td>139.261353</td>\n",
       "      <td>16.760000</td>\n",
       "      <td>227.672363</td>\n",
       "      <td>164.300659</td>\n",
       "      <td>133.029999</td>\n",
       "      <td>132.448151</td>\n",
       "      <td>302.750000</td>\n",
       "      <td>124.709999</td>\n",
       "      <td>342.690002</td>\n",
       "      <td>510.850006</td>\n",
       "      <td>...</td>\n",
       "      <td>3178300.0</td>\n",
       "      <td>3737200.0</td>\n",
       "      <td>26774600.0</td>\n",
       "      <td>1147900.0</td>\n",
       "      <td>1268600.0</td>\n",
       "      <td>2929400.0</td>\n",
       "      <td>1734314.0</td>\n",
       "      <td>320000.0</td>\n",
       "      <td>1186500.0</td>\n",
       "      <td>2844200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-21</th>\n",
       "      <td>137.294449</td>\n",
       "      <td>16.299999</td>\n",
       "      <td>224.515335</td>\n",
       "      <td>162.203354</td>\n",
       "      <td>131.979996</td>\n",
       "      <td>131.092575</td>\n",
       "      <td>304.570007</td>\n",
       "      <td>125.830002</td>\n",
       "      <td>335.630005</td>\n",
       "      <td>499.910004</td>\n",
       "      <td>...</td>\n",
       "      <td>3871800.0</td>\n",
       "      <td>4885400.0</td>\n",
       "      <td>35995200.0</td>\n",
       "      <td>1271100.0</td>\n",
       "      <td>4093100.0</td>\n",
       "      <td>2130000.0</td>\n",
       "      <td>3061366.0</td>\n",
       "      <td>488900.0</td>\n",
       "      <td>1996000.0</td>\n",
       "      <td>2633000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-24</th>\n",
       "      <td>137.903488</td>\n",
       "      <td>16.410000</td>\n",
       "      <td>231.127197</td>\n",
       "      <td>161.414337</td>\n",
       "      <td>132.160004</td>\n",
       "      <td>131.122467</td>\n",
       "      <td>311.940002</td>\n",
       "      <td>123.820000</td>\n",
       "      <td>339.000000</td>\n",
       "      <td>519.659973</td>\n",
       "      <td>...</td>\n",
       "      <td>5484500.0</td>\n",
       "      <td>4502300.0</td>\n",
       "      <td>41507000.0</td>\n",
       "      <td>1739500.0</td>\n",
       "      <td>1501200.0</td>\n",
       "      <td>2927300.0</td>\n",
       "      <td>2113045.0</td>\n",
       "      <td>853600.0</td>\n",
       "      <td>2327900.0</td>\n",
       "      <td>4093400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-25</th>\n",
       "      <td>134.359070</td>\n",
       "      <td>16.459999</td>\n",
       "      <td>228.516205</td>\n",
       "      <td>159.576691</td>\n",
       "      <td>133.089996</td>\n",
       "      <td>130.634064</td>\n",
       "      <td>296.839996</td>\n",
       "      <td>123.269997</td>\n",
       "      <td>334.950012</td>\n",
       "      <td>502.720001</td>\n",
       "      <td>...</td>\n",
       "      <td>3114200.0</td>\n",
       "      <td>4756500.0</td>\n",
       "      <td>39278400.0</td>\n",
       "      <td>1785600.0</td>\n",
       "      <td>1636300.0</td>\n",
       "      <td>2667400.0</td>\n",
       "      <td>2417410.0</td>\n",
       "      <td>537900.0</td>\n",
       "      <td>3832600.0</td>\n",
       "      <td>2673200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-26</th>\n",
       "      <td>133.300705</td>\n",
       "      <td>16.240000</td>\n",
       "      <td>223.492783</td>\n",
       "      <td>159.486801</td>\n",
       "      <td>134.229996</td>\n",
       "      <td>130.125717</td>\n",
       "      <td>297.140015</td>\n",
       "      <td>120.070000</td>\n",
       "      <td>329.890015</td>\n",
       "      <td>500.809998</td>\n",
       "      <td>...</td>\n",
       "      <td>3153000.0</td>\n",
       "      <td>4062100.0</td>\n",
       "      <td>35252400.0</td>\n",
       "      <td>1560900.0</td>\n",
       "      <td>1233300.0</td>\n",
       "      <td>1958600.0</td>\n",
       "      <td>2914591.0</td>\n",
       "      <td>592500.0</td>\n",
       "      <td>2315800.0</td>\n",
       "      <td>4532700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-27</th>\n",
       "      <td>131.882935</td>\n",
       "      <td>15.780000</td>\n",
       "      <td>223.482864</td>\n",
       "      <td>159.017410</td>\n",
       "      <td>135.970001</td>\n",
       "      <td>134.252274</td>\n",
       "      <td>277.299988</td>\n",
       "      <td>120.440002</td>\n",
       "      <td>333.359985</td>\n",
       "      <td>493.049988</td>\n",
       "      <td>...</td>\n",
       "      <td>2870400.0</td>\n",
       "      <td>4442200.0</td>\n",
       "      <td>29174700.0</td>\n",
       "      <td>1074100.0</td>\n",
       "      <td>1096900.0</td>\n",
       "      <td>2680500.0</td>\n",
       "      <td>1933928.0</td>\n",
       "      <td>624500.0</td>\n",
       "      <td>1781200.0</td>\n",
       "      <td>4606200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-28</th>\n",
       "      <td>136.845154</td>\n",
       "      <td>15.640000</td>\n",
       "      <td>226.570389</td>\n",
       "      <td>170.113266</td>\n",
       "      <td>137.919998</td>\n",
       "      <td>136.355408</td>\n",
       "      <td>277.250000</td>\n",
       "      <td>125.349998</td>\n",
       "      <td>342.850006</td>\n",
       "      <td>518.159973</td>\n",
       "      <td>...</td>\n",
       "      <td>2296000.0</td>\n",
       "      <td>3430400.0</td>\n",
       "      <td>30595700.0</td>\n",
       "      <td>898800.0</td>\n",
       "      <td>1122300.0</td>\n",
       "      <td>3465700.0</td>\n",
       "      <td>2317912.0</td>\n",
       "      <td>569200.0</td>\n",
       "      <td>2186800.0</td>\n",
       "      <td>2963800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-01-31</th>\n",
       "      <td>139.101624</td>\n",
       "      <td>16.469999</td>\n",
       "      <td>229.836594</td>\n",
       "      <td>174.557602</td>\n",
       "      <td>136.889999</td>\n",
       "      <td>135.757355</td>\n",
       "      <td>295.869995</td>\n",
       "      <td>127.459999</td>\n",
       "      <td>353.579987</td>\n",
       "      <td>534.299988</td>\n",
       "      <td>...</td>\n",
       "      <td>2949500.0</td>\n",
       "      <td>3475800.0</td>\n",
       "      <td>36085500.0</td>\n",
       "      <td>1262300.0</td>\n",
       "      <td>1507600.0</td>\n",
       "      <td>2414100.0</td>\n",
       "      <td>1487217.0</td>\n",
       "      <td>364800.0</td>\n",
       "      <td>1503400.0</td>\n",
       "      <td>2591500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-01</th>\n",
       "      <td>140.808929</td>\n",
       "      <td>16.830000</td>\n",
       "      <td>233.102829</td>\n",
       "      <td>174.387817</td>\n",
       "      <td>137.000000</td>\n",
       "      <td>137.212616</td>\n",
       "      <td>301.350006</td>\n",
       "      <td>127.199997</td>\n",
       "      <td>353.420013</td>\n",
       "      <td>535.979980</td>\n",
       "      <td>...</td>\n",
       "      <td>2931600.0</td>\n",
       "      <td>3372400.0</td>\n",
       "      <td>61033100.0</td>\n",
       "      <td>1539000.0</td>\n",
       "      <td>1380000.0</td>\n",
       "      <td>1485800.0</td>\n",
       "      <td>1066874.0</td>\n",
       "      <td>330000.0</td>\n",
       "      <td>1158000.0</td>\n",
       "      <td>2143200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-02</th>\n",
       "      <td>144.013901</td>\n",
       "      <td>16.959999</td>\n",
       "      <td>234.969223</td>\n",
       "      <td>175.616257</td>\n",
       "      <td>138.619995</td>\n",
       "      <td>135.637756</td>\n",
       "      <td>307.959991</td>\n",
       "      <td>130.039993</td>\n",
       "      <td>359.470001</td>\n",
       "      <td>533.090027</td>\n",
       "      <td>...</td>\n",
       "      <td>2750900.0</td>\n",
       "      <td>2559800.0</td>\n",
       "      <td>30299300.0</td>\n",
       "      <td>1269500.0</td>\n",
       "      <td>1326600.0</td>\n",
       "      <td>1640300.0</td>\n",
       "      <td>2534933.0</td>\n",
       "      <td>482800.0</td>\n",
       "      <td>948100.0</td>\n",
       "      <td>2494300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-03</th>\n",
       "      <td>141.567734</td>\n",
       "      <td>16.570000</td>\n",
       "      <td>230.809525</td>\n",
       "      <td>172.679993</td>\n",
       "      <td>140.729996</td>\n",
       "      <td>137.431900</td>\n",
       "      <td>290.519989</td>\n",
       "      <td>130.110001</td>\n",
       "      <td>345.549988</td>\n",
       "      <td>510.829987</td>\n",
       "      <td>...</td>\n",
       "      <td>2631400.0</td>\n",
       "      <td>2530600.0</td>\n",
       "      <td>28529400.0</td>\n",
       "      <td>941700.0</td>\n",
       "      <td>3649700.0</td>\n",
       "      <td>1172600.0</td>\n",
       "      <td>1927336.0</td>\n",
       "      <td>487800.0</td>\n",
       "      <td>1243100.0</td>\n",
       "      <td>1734500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-04</th>\n",
       "      <td>140.898788</td>\n",
       "      <td>16.450001</td>\n",
       "      <td>225.349274</td>\n",
       "      <td>172.389999</td>\n",
       "      <td>140.649994</td>\n",
       "      <td>136.166031</td>\n",
       "      <td>295.649994</td>\n",
       "      <td>129.710007</td>\n",
       "      <td>347.500000</td>\n",
       "      <td>513.539978</td>\n",
       "      <td>...</td>\n",
       "      <td>2884400.0</td>\n",
       "      <td>2517300.0</td>\n",
       "      <td>32197500.0</td>\n",
       "      <td>892600.0</td>\n",
       "      <td>2564500.0</td>\n",
       "      <td>1381100.0</td>\n",
       "      <td>1807547.0</td>\n",
       "      <td>394600.0</td>\n",
       "      <td>1207400.0</td>\n",
       "      <td>1919800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-07</th>\n",
       "      <td>140.149963</td>\n",
       "      <td>17.280001</td>\n",
       "      <td>224.306870</td>\n",
       "      <td>171.660004</td>\n",
       "      <td>142.529999</td>\n",
       "      <td>138.956924</td>\n",
       "      <td>289.839996</td>\n",
       "      <td>128.050003</td>\n",
       "      <td>343.959991</td>\n",
       "      <td>507.100006</td>\n",
       "      <td>...</td>\n",
       "      <td>3352500.0</td>\n",
       "      <td>2652900.0</td>\n",
       "      <td>34949200.0</td>\n",
       "      <td>892000.0</td>\n",
       "      <td>1330000.0</td>\n",
       "      <td>1666600.0</td>\n",
       "      <td>6482408.0</td>\n",
       "      <td>299800.0</td>\n",
       "      <td>809400.0</td>\n",
       "      <td>3303900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-08</th>\n",
       "      <td>140.589279</td>\n",
       "      <td>18.260000</td>\n",
       "      <td>228.536072</td>\n",
       "      <td>174.830002</td>\n",
       "      <td>143.509995</td>\n",
       "      <td>141.777740</td>\n",
       "      <td>309.029999</td>\n",
       "      <td>128.649994</td>\n",
       "      <td>345.070007</td>\n",
       "      <td>511.309998</td>\n",
       "      <td>...</td>\n",
       "      <td>3248100.0</td>\n",
       "      <td>4155200.0</td>\n",
       "      <td>34356300.0</td>\n",
       "      <td>1247800.0</td>\n",
       "      <td>1750800.0</td>\n",
       "      <td>2345200.0</td>\n",
       "      <td>4657660.0</td>\n",
       "      <td>615200.0</td>\n",
       "      <td>1998800.0</td>\n",
       "      <td>2880500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-09</th>\n",
       "      <td>144.213593</td>\n",
       "      <td>18.760000</td>\n",
       "      <td>230.501755</td>\n",
       "      <td>176.279999</td>\n",
       "      <td>143.199997</td>\n",
       "      <td>142.455521</td>\n",
       "      <td>315.920013</td>\n",
       "      <td>130.490005</td>\n",
       "      <td>355.529999</td>\n",
       "      <td>521.750000</td>\n",
       "      <td>...</td>\n",
       "      <td>3521600.0</td>\n",
       "      <td>3921800.0</td>\n",
       "      <td>40106100.0</td>\n",
       "      <td>1505100.0</td>\n",
       "      <td>1920400.0</td>\n",
       "      <td>3703000.0</td>\n",
       "      <td>2209865.0</td>\n",
       "      <td>678600.0</td>\n",
       "      <td>1351700.0</td>\n",
       "      <td>2026900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-10</th>\n",
       "      <td>141.437943</td>\n",
       "      <td>18.709999</td>\n",
       "      <td>221.120056</td>\n",
       "      <td>172.119995</td>\n",
       "      <td>142.710007</td>\n",
       "      <td>141.080002</td>\n",
       "      <td>307.109985</td>\n",
       "      <td>127.760002</td>\n",
       "      <td>342.390015</td>\n",
       "      <td>495.019989</td>\n",
       "      <td>...</td>\n",
       "      <td>3357400.0</td>\n",
       "      <td>3232500.0</td>\n",
       "      <td>28527700.0</td>\n",
       "      <td>2286700.0</td>\n",
       "      <td>1505500.0</td>\n",
       "      <td>2178600.0</td>\n",
       "      <td>2519071.0</td>\n",
       "      <td>772700.0</td>\n",
       "      <td>2554400.0</td>\n",
       "      <td>2809000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-11</th>\n",
       "      <td>136.984924</td>\n",
       "      <td>17.610001</td>\n",
       "      <td>221.328552</td>\n",
       "      <td>168.639999</td>\n",
       "      <td>142.009995</td>\n",
       "      <td>140.240005</td>\n",
       "      <td>294.820007</td>\n",
       "      <td>125.489998</td>\n",
       "      <td>329.179993</td>\n",
       "      <td>473.970001</td>\n",
       "      <td>...</td>\n",
       "      <td>4205400.0</td>\n",
       "      <td>3546800.0</td>\n",
       "      <td>42002100.0</td>\n",
       "      <td>1805400.0</td>\n",
       "      <td>1364400.0</td>\n",
       "      <td>2929300.0</td>\n",
       "      <td>1900556.0</td>\n",
       "      <td>1276000.0</td>\n",
       "      <td>1226200.0</td>\n",
       "      <td>3714600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-14</th>\n",
       "      <td>134.998062</td>\n",
       "      <td>17.430000</td>\n",
       "      <td>222.658859</td>\n",
       "      <td>168.880005</td>\n",
       "      <td>143.000000</td>\n",
       "      <td>140.179993</td>\n",
       "      <td>290.429993</td>\n",
       "      <td>122.779999</td>\n",
       "      <td>326.130005</td>\n",
       "      <td>474.010010</td>\n",
       "      <td>...</td>\n",
       "      <td>2323500.0</td>\n",
       "      <td>4491300.0</td>\n",
       "      <td>34652800.0</td>\n",
       "      <td>1092600.0</td>\n",
       "      <td>1469400.0</td>\n",
       "      <td>2660300.0</td>\n",
       "      <td>1146699.0</td>\n",
       "      <td>659000.0</td>\n",
       "      <td>2020800.0</td>\n",
       "      <td>3381900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-15</th>\n",
       "      <td>135.696960</td>\n",
       "      <td>18.840000</td>\n",
       "      <td>220.991013</td>\n",
       "      <td>172.789993</td>\n",
       "      <td>144.759995</td>\n",
       "      <td>141.479996</td>\n",
       "      <td>304.700012</td>\n",
       "      <td>123.980003</td>\n",
       "      <td>329.410004</td>\n",
       "      <td>479.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>4095700.0</td>\n",
       "      <td>10095000.0</td>\n",
       "      <td>25075100.0</td>\n",
       "      <td>2334600.0</td>\n",
       "      <td>1173600.0</td>\n",
       "      <td>4146800.0</td>\n",
       "      <td>1553961.0</td>\n",
       "      <td>616000.0</td>\n",
       "      <td>1631400.0</td>\n",
       "      <td>3618400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-16</th>\n",
       "      <td>134.938141</td>\n",
       "      <td>18.820000</td>\n",
       "      <td>220.782516</td>\n",
       "      <td>172.550003</td>\n",
       "      <td>145.869995</td>\n",
       "      <td>142.729996</td>\n",
       "      <td>325.420013</td>\n",
       "      <td>123.680000</td>\n",
       "      <td>333.720001</td>\n",
       "      <td>477.700012</td>\n",
       "      <td>...</td>\n",
       "      <td>4118900.0</td>\n",
       "      <td>3148800.0</td>\n",
       "      <td>21733800.0</td>\n",
       "      <td>3441300.0</td>\n",
       "      <td>778700.0</td>\n",
       "      <td>2172500.0</td>\n",
       "      <td>1778604.0</td>\n",
       "      <td>538900.0</td>\n",
       "      <td>1230700.0</td>\n",
       "      <td>2916900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-17</th>\n",
       "      <td>130.045822</td>\n",
       "      <td>18.219999</td>\n",
       "      <td>218.816833</td>\n",
       "      <td>168.880005</td>\n",
       "      <td>144.970001</td>\n",
       "      <td>142.110001</td>\n",
       "      <td>307.109985</td>\n",
       "      <td>120.580002</td>\n",
       "      <td>322.910004</td>\n",
       "      <td>457.709991</td>\n",
       "      <td>...</td>\n",
       "      <td>2704600.0</td>\n",
       "      <td>3545000.0</td>\n",
       "      <td>23738800.0</td>\n",
       "      <td>991600.0</td>\n",
       "      <td>939100.0</td>\n",
       "      <td>2689500.0</td>\n",
       "      <td>1307379.0</td>\n",
       "      <td>609300.0</td>\n",
       "      <td>1110000.0</td>\n",
       "      <td>2435500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-18</th>\n",
       "      <td>131.843002</td>\n",
       "      <td>17.870001</td>\n",
       "      <td>217.218475</td>\n",
       "      <td>167.300003</td>\n",
       "      <td>144.029999</td>\n",
       "      <td>141.500000</td>\n",
       "      <td>298.380005</td>\n",
       "      <td>116.790001</td>\n",
       "      <td>321.179993</td>\n",
       "      <td>442.559998</td>\n",
       "      <td>...</td>\n",
       "      <td>3008900.0</td>\n",
       "      <td>3664200.0</td>\n",
       "      <td>23394800.0</td>\n",
       "      <td>1804100.0</td>\n",
       "      <td>1361500.0</td>\n",
       "      <td>2359400.0</td>\n",
       "      <td>1234352.0</td>\n",
       "      <td>536200.0</td>\n",
       "      <td>1701600.0</td>\n",
       "      <td>2558900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-22</th>\n",
       "      <td>130.285461</td>\n",
       "      <td>17.430000</td>\n",
       "      <td>205.265488</td>\n",
       "      <td>164.320007</td>\n",
       "      <td>145.559998</td>\n",
       "      <td>140.559998</td>\n",
       "      <td>296.640015</td>\n",
       "      <td>117.510002</td>\n",
       "      <td>321.109985</td>\n",
       "      <td>438.399994</td>\n",
       "      <td>...</td>\n",
       "      <td>4338800.0</td>\n",
       "      <td>3556500.0</td>\n",
       "      <td>35947800.0</td>\n",
       "      <td>1880500.0</td>\n",
       "      <td>1686000.0</td>\n",
       "      <td>1863800.0</td>\n",
       "      <td>2144769.0</td>\n",
       "      <td>549600.0</td>\n",
       "      <td>1223400.0</td>\n",
       "      <td>2347300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-23</th>\n",
       "      <td>125.802490</td>\n",
       "      <td>16.639999</td>\n",
       "      <td>195.377487</td>\n",
       "      <td>160.070007</td>\n",
       "      <td>146.759995</td>\n",
       "      <td>139.470001</td>\n",
       "      <td>290.679993</td>\n",
       "      <td>117.250000</td>\n",
       "      <td>313.160004</td>\n",
       "      <td>429.450012</td>\n",
       "      <td>...</td>\n",
       "      <td>2156100.0</td>\n",
       "      <td>3701500.0</td>\n",
       "      <td>25385000.0</td>\n",
       "      <td>1463500.0</td>\n",
       "      <td>1120800.0</td>\n",
       "      <td>2272500.0</td>\n",
       "      <td>1475990.0</td>\n",
       "      <td>569000.0</td>\n",
       "      <td>1148800.0</td>\n",
       "      <td>2070600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-24</th>\n",
       "      <td>127.949112</td>\n",
       "      <td>16.959999</td>\n",
       "      <td>199.358505</td>\n",
       "      <td>162.740005</td>\n",
       "      <td>145.270004</td>\n",
       "      <td>137.860001</td>\n",
       "      <td>306.920013</td>\n",
       "      <td>118.720001</td>\n",
       "      <td>316.170013</td>\n",
       "      <td>463.820007</td>\n",
       "      <td>...</td>\n",
       "      <td>4455400.0</td>\n",
       "      <td>4720400.0</td>\n",
       "      <td>46199900.0</td>\n",
       "      <td>2101300.0</td>\n",
       "      <td>3113500.0</td>\n",
       "      <td>2447600.0</td>\n",
       "      <td>1470634.0</td>\n",
       "      <td>508700.0</td>\n",
       "      <td>2880200.0</td>\n",
       "      <td>2903200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-25</th>\n",
       "      <td>133.520370</td>\n",
       "      <td>17.459999</td>\n",
       "      <td>204.084106</td>\n",
       "      <td>164.850006</td>\n",
       "      <td>149.539993</td>\n",
       "      <td>141.919998</td>\n",
       "      <td>312.299988</td>\n",
       "      <td>122.410004</td>\n",
       "      <td>322.510010</td>\n",
       "      <td>465.540009</td>\n",
       "      <td>...</td>\n",
       "      <td>2605700.0</td>\n",
       "      <td>4985000.0</td>\n",
       "      <td>28310300.0</td>\n",
       "      <td>2660000.0</td>\n",
       "      <td>1535500.0</td>\n",
       "      <td>1498200.0</td>\n",
       "      <td>1641614.0</td>\n",
       "      <td>440600.0</td>\n",
       "      <td>1941000.0</td>\n",
       "      <td>1742600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-02-28</th>\n",
       "      <td>130.155655</td>\n",
       "      <td>17.250000</td>\n",
       "      <td>203.001968</td>\n",
       "      <td>165.119995</td>\n",
       "      <td>147.770004</td>\n",
       "      <td>142.529999</td>\n",
       "      <td>310.739990</td>\n",
       "      <td>120.620003</td>\n",
       "      <td>316.019989</td>\n",
       "      <td>467.679993</td>\n",
       "      <td>...</td>\n",
       "      <td>2395600.0</td>\n",
       "      <td>4173000.0</td>\n",
       "      <td>32204600.0</td>\n",
       "      <td>7547500.0</td>\n",
       "      <td>2033200.0</td>\n",
       "      <td>2235500.0</td>\n",
       "      <td>2497647.0</td>\n",
       "      <td>541100.0</td>\n",
       "      <td>1732500.0</td>\n",
       "      <td>2220200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-01</th>\n",
       "      <td>131.723190</td>\n",
       "      <td>16.290001</td>\n",
       "      <td>199.715897</td>\n",
       "      <td>163.199997</td>\n",
       "      <td>147.690002</td>\n",
       "      <td>141.970001</td>\n",
       "      <td>313.489990</td>\n",
       "      <td>118.169998</td>\n",
       "      <td>311.350006</td>\n",
       "      <td>466.679993</td>\n",
       "      <td>...</td>\n",
       "      <td>4410200.0</td>\n",
       "      <td>4585200.0</td>\n",
       "      <td>40002300.0</td>\n",
       "      <td>5353600.0</td>\n",
       "      <td>1197900.0</td>\n",
       "      <td>1835700.0</td>\n",
       "      <td>7107800.0</td>\n",
       "      <td>462100.0</td>\n",
       "      <td>3224100.0</td>\n",
       "      <td>1669100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-02</th>\n",
       "      <td>132.951263</td>\n",
       "      <td>16.370001</td>\n",
       "      <td>207.558807</td>\n",
       "      <td>166.559998</td>\n",
       "      <td>149.570007</td>\n",
       "      <td>143.000000</td>\n",
       "      <td>315.850006</td>\n",
       "      <td>120.360001</td>\n",
       "      <td>318.329987</td>\n",
       "      <td>471.179993</td>\n",
       "      <td>...</td>\n",
       "      <td>6974200.0</td>\n",
       "      <td>3256200.0</td>\n",
       "      <td>44321400.0</td>\n",
       "      <td>4347600.0</td>\n",
       "      <td>1305600.0</td>\n",
       "      <td>1269200.0</td>\n",
       "      <td>2070900.0</td>\n",
       "      <td>409400.0</td>\n",
       "      <td>1935100.0</td>\n",
       "      <td>1355300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-03</th>\n",
       "      <td>136.954971</td>\n",
       "      <td>15.710000</td>\n",
       "      <td>206.764587</td>\n",
       "      <td>166.229996</td>\n",
       "      <td>150.410004</td>\n",
       "      <td>145.470001</td>\n",
       "      <td>311.179993</td>\n",
       "      <td>120.970001</td>\n",
       "      <td>318.950012</td>\n",
       "      <td>459.079987</td>\n",
       "      <td>...</td>\n",
       "      <td>4454900.0</td>\n",
       "      <td>2822100.0</td>\n",
       "      <td>30196600.0</td>\n",
       "      <td>3276600.0</td>\n",
       "      <td>1313400.0</td>\n",
       "      <td>1331500.0</td>\n",
       "      <td>1504100.0</td>\n",
       "      <td>241700.0</td>\n",
       "      <td>1874000.0</td>\n",
       "      <td>1052200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-04</th>\n",
       "      <td>133.680115</td>\n",
       "      <td>14.590000</td>\n",
       "      <td>205.126511</td>\n",
       "      <td>163.169998</td>\n",
       "      <td>150.559998</td>\n",
       "      <td>147.300003</td>\n",
       "      <td>313.720001</td>\n",
       "      <td>121.410004</td>\n",
       "      <td>314.160004</td>\n",
       "      <td>452.130005</td>\n",
       "      <td>...</td>\n",
       "      <td>5060200.0</td>\n",
       "      <td>3515300.0</td>\n",
       "      <td>42802200.0</td>\n",
       "      <td>2580500.0</td>\n",
       "      <td>1756300.0</td>\n",
       "      <td>1666700.0</td>\n",
       "      <td>1363800.0</td>\n",
       "      <td>532500.0</td>\n",
       "      <td>1760600.0</td>\n",
       "      <td>1467800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-07</th>\n",
       "      <td>130.135681</td>\n",
       "      <td>12.840000</td>\n",
       "      <td>199.854889</td>\n",
       "      <td>159.300003</td>\n",
       "      <td>149.449997</td>\n",
       "      <td>144.839996</td>\n",
       "      <td>298.640015</td>\n",
       "      <td>118.860001</td>\n",
       "      <td>305.019989</td>\n",
       "      <td>437.970001</td>\n",
       "      <td>...</td>\n",
       "      <td>6379900.0</td>\n",
       "      <td>4388600.0</td>\n",
       "      <td>55207900.0</td>\n",
       "      <td>1842100.0</td>\n",
       "      <td>1360200.0</td>\n",
       "      <td>2689000.0</td>\n",
       "      <td>1654900.0</td>\n",
       "      <td>504900.0</td>\n",
       "      <td>1815500.0</td>\n",
       "      <td>1825000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-08</th>\n",
       "      <td>129.117294</td>\n",
       "      <td>13.510000</td>\n",
       "      <td>199.130173</td>\n",
       "      <td>157.440002</td>\n",
       "      <td>147.149994</td>\n",
       "      <td>144.410004</td>\n",
       "      <td>290.390015</td>\n",
       "      <td>116.110001</td>\n",
       "      <td>301.619995</td>\n",
       "      <td>431.529999</td>\n",
       "      <td>...</td>\n",
       "      <td>4978600.0</td>\n",
       "      <td>2883100.0</td>\n",
       "      <td>72082300.0</td>\n",
       "      <td>2031300.0</td>\n",
       "      <td>1594200.0</td>\n",
       "      <td>2287200.0</td>\n",
       "      <td>1719000.0</td>\n",
       "      <td>407600.0</td>\n",
       "      <td>1698600.0</td>\n",
       "      <td>2414400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-09</th>\n",
       "      <td>133.051102</td>\n",
       "      <td>14.300000</td>\n",
       "      <td>203.399094</td>\n",
       "      <td>162.949997</td>\n",
       "      <td>148.839996</td>\n",
       "      <td>145.830002</td>\n",
       "      <td>306.739990</td>\n",
       "      <td>118.389999</td>\n",
       "      <td>309.420013</td>\n",
       "      <td>450.869995</td>\n",
       "      <td>...</td>\n",
       "      <td>5575500.0</td>\n",
       "      <td>2866900.0</td>\n",
       "      <td>65466700.0</td>\n",
       "      <td>2484900.0</td>\n",
       "      <td>1317500.0</td>\n",
       "      <td>1477400.0</td>\n",
       "      <td>1201900.0</td>\n",
       "      <td>346100.0</td>\n",
       "      <td>1409100.0</td>\n",
       "      <td>2630400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-10</th>\n",
       "      <td>134.119431</td>\n",
       "      <td>14.200000</td>\n",
       "      <td>203.438797</td>\n",
       "      <td>158.520004</td>\n",
       "      <td>149.169998</td>\n",
       "      <td>146.169998</td>\n",
       "      <td>305.619995</td>\n",
       "      <td>117.000000</td>\n",
       "      <td>309.519989</td>\n",
       "      <td>438.950012</td>\n",
       "      <td>...</td>\n",
       "      <td>2337900.0</td>\n",
       "      <td>1945200.0</td>\n",
       "      <td>44644200.0</td>\n",
       "      <td>3860600.0</td>\n",
       "      <td>1759100.0</td>\n",
       "      <td>2448500.0</td>\n",
       "      <td>1441500.0</td>\n",
       "      <td>250300.0</td>\n",
       "      <td>1230600.0</td>\n",
       "      <td>1995100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-11</th>\n",
       "      <td>130.105728</td>\n",
       "      <td>14.020000</td>\n",
       "      <td>202.604874</td>\n",
       "      <td>154.729996</td>\n",
       "      <td>149.059998</td>\n",
       "      <td>144.559998</td>\n",
       "      <td>286.790009</td>\n",
       "      <td>114.019997</td>\n",
       "      <td>311.579987</td>\n",
       "      <td>416.380005</td>\n",
       "      <td>...</td>\n",
       "      <td>3624700.0</td>\n",
       "      <td>3031500.0</td>\n",
       "      <td>35303400.0</td>\n",
       "      <td>3332700.0</td>\n",
       "      <td>1389800.0</td>\n",
       "      <td>2080500.0</td>\n",
       "      <td>2031200.0</td>\n",
       "      <td>410300.0</td>\n",
       "      <td>1138200.0</td>\n",
       "      <td>1589700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-14</th>\n",
       "      <td>127.380013</td>\n",
       "      <td>14.250000</td>\n",
       "      <td>197.730362</td>\n",
       "      <td>150.619995</td>\n",
       "      <td>152.100006</td>\n",
       "      <td>146.149994</td>\n",
       "      <td>277.549988</td>\n",
       "      <td>115.519997</td>\n",
       "      <td>307.679993</td>\n",
       "      <td>411.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>6019000.0</td>\n",
       "      <td>2392600.0</td>\n",
       "      <td>37462600.0</td>\n",
       "      <td>2510900.0</td>\n",
       "      <td>1173600.0</td>\n",
       "      <td>3414100.0</td>\n",
       "      <td>1384800.0</td>\n",
       "      <td>330200.0</td>\n",
       "      <td>1525200.0</td>\n",
       "      <td>2044800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-15</th>\n",
       "      <td>130.075775</td>\n",
       "      <td>15.570000</td>\n",
       "      <td>202.793503</td>\n",
       "      <td>155.089996</td>\n",
       "      <td>155.880005</td>\n",
       "      <td>151.389999</td>\n",
       "      <td>289.640015</td>\n",
       "      <td>117.480003</td>\n",
       "      <td>316.230011</td>\n",
       "      <td>421.660004</td>\n",
       "      <td>...</td>\n",
       "      <td>4779700.0</td>\n",
       "      <td>4454600.0</td>\n",
       "      <td>47957900.0</td>\n",
       "      <td>2054400.0</td>\n",
       "      <td>1094300.0</td>\n",
       "      <td>1670300.0</td>\n",
       "      <td>1269000.0</td>\n",
       "      <td>341100.0</td>\n",
       "      <td>1117400.0</td>\n",
       "      <td>1261600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-16</th>\n",
       "      <td>134.788376</td>\n",
       "      <td>16.469999</td>\n",
       "      <td>206.020004</td>\n",
       "      <td>159.589996</td>\n",
       "      <td>156.050003</td>\n",
       "      <td>150.500000</td>\n",
       "      <td>294.529999</td>\n",
       "      <td>119.480003</td>\n",
       "      <td>324.910004</td>\n",
       "      <td>442.359985</td>\n",
       "      <td>...</td>\n",
       "      <td>4677800.0</td>\n",
       "      <td>3809300.0</td>\n",
       "      <td>37812300.0</td>\n",
       "      <td>2533600.0</td>\n",
       "      <td>1568100.0</td>\n",
       "      <td>2152800.0</td>\n",
       "      <td>1599300.0</td>\n",
       "      <td>321400.0</td>\n",
       "      <td>1999400.0</td>\n",
       "      <td>2064000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-17</th>\n",
       "      <td>136.605530</td>\n",
       "      <td>16.549999</td>\n",
       "      <td>208.179993</td>\n",
       "      <td>160.619995</td>\n",
       "      <td>158.589996</td>\n",
       "      <td>152.199997</td>\n",
       "      <td>307.649994</td>\n",
       "      <td>121.199997</td>\n",
       "      <td>319.500000</td>\n",
       "      <td>444.359985</td>\n",
       "      <td>...</td>\n",
       "      <td>2918300.0</td>\n",
       "      <td>3974500.0</td>\n",
       "      <td>34041900.0</td>\n",
       "      <td>2638900.0</td>\n",
       "      <td>1648100.0</td>\n",
       "      <td>1483500.0</td>\n",
       "      <td>1830200.0</td>\n",
       "      <td>537900.0</td>\n",
       "      <td>1884600.0</td>\n",
       "      <td>2199700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-18</th>\n",
       "      <td>138.901917</td>\n",
       "      <td>16.750000</td>\n",
       "      <td>206.339996</td>\n",
       "      <td>163.979996</td>\n",
       "      <td>159.199997</td>\n",
       "      <td>152.000000</td>\n",
       "      <td>304.329987</td>\n",
       "      <td>122.449997</td>\n",
       "      <td>323.950012</td>\n",
       "      <td>453.329987</td>\n",
       "      <td>...</td>\n",
       "      <td>3715600.0</td>\n",
       "      <td>5750300.0</td>\n",
       "      <td>41461500.0</td>\n",
       "      <td>6863700.0</td>\n",
       "      <td>4327800.0</td>\n",
       "      <td>3361800.0</td>\n",
       "      <td>2951500.0</td>\n",
       "      <td>930700.0</td>\n",
       "      <td>4135800.0</td>\n",
       "      <td>2613700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-21</th>\n",
       "      <td>137.923462</td>\n",
       "      <td>16.090000</td>\n",
       "      <td>205.750000</td>\n",
       "      <td>165.380005</td>\n",
       "      <td>160.050003</td>\n",
       "      <td>153.179993</td>\n",
       "      <td>306.739990</td>\n",
       "      <td>121.760002</td>\n",
       "      <td>324.500000</td>\n",
       "      <td>453.589996</td>\n",
       "      <td>...</td>\n",
       "      <td>2647900.0</td>\n",
       "      <td>2559000.0</td>\n",
       "      <td>33089300.0</td>\n",
       "      <td>2982200.0</td>\n",
       "      <td>1643700.0</td>\n",
       "      <td>1930700.0</td>\n",
       "      <td>1444100.0</td>\n",
       "      <td>491300.0</td>\n",
       "      <td>1779800.0</td>\n",
       "      <td>1891000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-22</th>\n",
       "      <td>139.071655</td>\n",
       "      <td>16.559999</td>\n",
       "      <td>209.399994</td>\n",
       "      <td>168.820007</td>\n",
       "      <td>160.009995</td>\n",
       "      <td>152.110001</td>\n",
       "      <td>313.339996</td>\n",
       "      <td>121.889999</td>\n",
       "      <td>327.470001</td>\n",
       "      <td>466.450012</td>\n",
       "      <td>...</td>\n",
       "      <td>2732300.0</td>\n",
       "      <td>2351000.0</td>\n",
       "      <td>23132200.0</td>\n",
       "      <td>2983300.0</td>\n",
       "      <td>1678300.0</td>\n",
       "      <td>1179300.0</td>\n",
       "      <td>1819700.0</td>\n",
       "      <td>455800.0</td>\n",
       "      <td>1805000.0</td>\n",
       "      <td>2374700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-23</th>\n",
       "      <td>133.969666</td>\n",
       "      <td>16.209999</td>\n",
       "      <td>213.339996</td>\n",
       "      <td>170.210007</td>\n",
       "      <td>158.419998</td>\n",
       "      <td>151.529999</td>\n",
       "      <td>311.029999</td>\n",
       "      <td>116.919998</td>\n",
       "      <td>320.500000</td>\n",
       "      <td>422.899994</td>\n",
       "      <td>...</td>\n",
       "      <td>1636700.0</td>\n",
       "      <td>2511300.0</td>\n",
       "      <td>27716300.0</td>\n",
       "      <td>1584900.0</td>\n",
       "      <td>1819800.0</td>\n",
       "      <td>1798900.0</td>\n",
       "      <td>2420000.0</td>\n",
       "      <td>325800.0</td>\n",
       "      <td>1498600.0</td>\n",
       "      <td>2115200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-24</th>\n",
       "      <td>136.196182</td>\n",
       "      <td>16.719999</td>\n",
       "      <td>214.669998</td>\n",
       "      <td>174.070007</td>\n",
       "      <td>160.279999</td>\n",
       "      <td>152.610001</td>\n",
       "      <td>321.470001</td>\n",
       "      <td>117.820000</td>\n",
       "      <td>325.290009</td>\n",
       "      <td>432.140015</td>\n",
       "      <td>...</td>\n",
       "      <td>2598900.0</td>\n",
       "      <td>2257800.0</td>\n",
       "      <td>19871600.0</td>\n",
       "      <td>1350300.0</td>\n",
       "      <td>1075600.0</td>\n",
       "      <td>1858300.0</td>\n",
       "      <td>2393500.0</td>\n",
       "      <td>311000.0</td>\n",
       "      <td>1329500.0</td>\n",
       "      <td>3445900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-25</th>\n",
       "      <td>135.497269</td>\n",
       "      <td>17.010000</td>\n",
       "      <td>215.580002</td>\n",
       "      <td>174.720001</td>\n",
       "      <td>161.330002</td>\n",
       "      <td>154.690002</td>\n",
       "      <td>318.880005</td>\n",
       "      <td>118.949997</td>\n",
       "      <td>327.709991</td>\n",
       "      <td>431.619995</td>\n",
       "      <td>...</td>\n",
       "      <td>1655500.0</td>\n",
       "      <td>1698900.0</td>\n",
       "      <td>22398300.0</td>\n",
       "      <td>1113800.0</td>\n",
       "      <td>811200.0</td>\n",
       "      <td>1254700.0</td>\n",
       "      <td>1129700.0</td>\n",
       "      <td>294300.0</td>\n",
       "      <td>1996200.0</td>\n",
       "      <td>2363100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-28</th>\n",
       "      <td>135.207718</td>\n",
       "      <td>17.299999</td>\n",
       "      <td>210.490005</td>\n",
       "      <td>175.600006</td>\n",
       "      <td>161.970001</td>\n",
       "      <td>154.729996</td>\n",
       "      <td>321.809998</td>\n",
       "      <td>119.989998</td>\n",
       "      <td>330.739990</td>\n",
       "      <td>450.010010</td>\n",
       "      <td>...</td>\n",
       "      <td>2013300.0</td>\n",
       "      <td>1684200.0</td>\n",
       "      <td>21552400.0</td>\n",
       "      <td>1339900.0</td>\n",
       "      <td>860000.0</td>\n",
       "      <td>1280800.0</td>\n",
       "      <td>1603300.0</td>\n",
       "      <td>319500.0</td>\n",
       "      <td>1344300.0</td>\n",
       "      <td>2995800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-29</th>\n",
       "      <td>138.203018</td>\n",
       "      <td>18.160000</td>\n",
       "      <td>215.449997</td>\n",
       "      <td>178.960007</td>\n",
       "      <td>162.179993</td>\n",
       "      <td>155.039993</td>\n",
       "      <td>331.500000</td>\n",
       "      <td>120.190002</td>\n",
       "      <td>340.690002</td>\n",
       "      <td>466.329987</td>\n",
       "      <td>...</td>\n",
       "      <td>2771000.0</td>\n",
       "      <td>2527000.0</td>\n",
       "      <td>27036300.0</td>\n",
       "      <td>2238800.0</td>\n",
       "      <td>1023000.0</td>\n",
       "      <td>1692400.0</td>\n",
       "      <td>1712200.0</td>\n",
       "      <td>292100.0</td>\n",
       "      <td>1257700.0</td>\n",
       "      <td>2557400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-30</th>\n",
       "      <td>135.247665</td>\n",
       "      <td>18.049999</td>\n",
       "      <td>211.820007</td>\n",
       "      <td>177.770004</td>\n",
       "      <td>163.750000</td>\n",
       "      <td>155.139999</td>\n",
       "      <td>328.510010</td>\n",
       "      <td>120.379997</td>\n",
       "      <td>338.459991</td>\n",
       "      <td>460.059998</td>\n",
       "      <td>...</td>\n",
       "      <td>1456900.0</td>\n",
       "      <td>1582100.0</td>\n",
       "      <td>22079000.0</td>\n",
       "      <td>1735800.0</td>\n",
       "      <td>720500.0</td>\n",
       "      <td>2022800.0</td>\n",
       "      <td>1150200.0</td>\n",
       "      <td>316500.0</td>\n",
       "      <td>1257100.0</td>\n",
       "      <td>2612700.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-03-31</th>\n",
       "      <td>132.122574</td>\n",
       "      <td>18.250000</td>\n",
       "      <td>206.960007</td>\n",
       "      <td>174.610001</td>\n",
       "      <td>162.110001</td>\n",
       "      <td>154.710007</td>\n",
       "      <td>331.239990</td>\n",
       "      <td>118.360001</td>\n",
       "      <td>337.230011</td>\n",
       "      <td>455.619995</td>\n",
       "      <td>...</td>\n",
       "      <td>2382900.0</td>\n",
       "      <td>3045300.0</td>\n",
       "      <td>27861500.0</td>\n",
       "      <td>1677900.0</td>\n",
       "      <td>1415500.0</td>\n",
       "      <td>3932200.0</td>\n",
       "      <td>1363100.0</td>\n",
       "      <td>575600.0</td>\n",
       "      <td>1578300.0</td>\n",
       "      <td>2477600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-01</th>\n",
       "      <td>133.759995</td>\n",
       "      <td>18.240000</td>\n",
       "      <td>207.479996</td>\n",
       "      <td>174.309998</td>\n",
       "      <td>162.679993</td>\n",
       "      <td>156.520004</td>\n",
       "      <td>338.640015</td>\n",
       "      <td>118.580002</td>\n",
       "      <td>340.640015</td>\n",
       "      <td>458.190002</td>\n",
       "      <td>...</td>\n",
       "      <td>3116600.0</td>\n",
       "      <td>2598100.0</td>\n",
       "      <td>18665800.0</td>\n",
       "      <td>1838400.0</td>\n",
       "      <td>913200.0</td>\n",
       "      <td>2884000.0</td>\n",
       "      <td>1616900.0</td>\n",
       "      <td>505200.0</td>\n",
       "      <td>2479500.0</td>\n",
       "      <td>1831400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-04</th>\n",
       "      <td>134.809998</td>\n",
       "      <td>18.230000</td>\n",
       "      <td>211.919998</td>\n",
       "      <td>178.440002</td>\n",
       "      <td>161.889999</td>\n",
       "      <td>154.750000</td>\n",
       "      <td>325.700012</td>\n",
       "      <td>118.879997</td>\n",
       "      <td>344.470001</td>\n",
       "      <td>468.809998</td>\n",
       "      <td>...</td>\n",
       "      <td>2171400.0</td>\n",
       "      <td>2082300.0</td>\n",
       "      <td>20869400.0</td>\n",
       "      <td>1036400.0</td>\n",
       "      <td>850700.0</td>\n",
       "      <td>1980400.0</td>\n",
       "      <td>1349700.0</td>\n",
       "      <td>492300.0</td>\n",
       "      <td>1220400.0</td>\n",
       "      <td>2603600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-05</th>\n",
       "      <td>133.259995</td>\n",
       "      <td>17.840000</td>\n",
       "      <td>211.729996</td>\n",
       "      <td>175.059998</td>\n",
       "      <td>163.429993</td>\n",
       "      <td>155.759995</td>\n",
       "      <td>322.660004</td>\n",
       "      <td>119.480003</td>\n",
       "      <td>342.820007</td>\n",
       "      <td>458.579987</td>\n",
       "      <td>...</td>\n",
       "      <td>2807100.0</td>\n",
       "      <td>2979400.0</td>\n",
       "      <td>21753100.0</td>\n",
       "      <td>1410600.0</td>\n",
       "      <td>1346100.0</td>\n",
       "      <td>2010900.0</td>\n",
       "      <td>2187100.0</td>\n",
       "      <td>456700.0</td>\n",
       "      <td>1384200.0</td>\n",
       "      <td>2059300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-06</th>\n",
       "      <td>132.710007</td>\n",
       "      <td>17.379999</td>\n",
       "      <td>212.830002</td>\n",
       "      <td>171.830002</td>\n",
       "      <td>168.910004</td>\n",
       "      <td>158.139999</td>\n",
       "      <td>313.760010</td>\n",
       "      <td>119.940002</td>\n",
       "      <td>340.260010</td>\n",
       "      <td>444.329987</td>\n",
       "      <td>...</td>\n",
       "      <td>2926500.0</td>\n",
       "      <td>3350600.0</td>\n",
       "      <td>24768200.0</td>\n",
       "      <td>1706000.0</td>\n",
       "      <td>1271300.0</td>\n",
       "      <td>1683100.0</td>\n",
       "      <td>2057700.0</td>\n",
       "      <td>442300.0</td>\n",
       "      <td>1568200.0</td>\n",
       "      <td>2843500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-07</th>\n",
       "      <td>135.929993</td>\n",
       "      <td>16.950001</td>\n",
       "      <td>217.580002</td>\n",
       "      <td>172.139999</td>\n",
       "      <td>173.279999</td>\n",
       "      <td>162.919998</td>\n",
       "      <td>317.519989</td>\n",
       "      <td>123.370003</td>\n",
       "      <td>341.769989</td>\n",
       "      <td>452.720001</td>\n",
       "      <td>...</td>\n",
       "      <td>3437600.0</td>\n",
       "      <td>3228700.0</td>\n",
       "      <td>26122000.0</td>\n",
       "      <td>1240400.0</td>\n",
       "      <td>1153100.0</td>\n",
       "      <td>2008900.0</td>\n",
       "      <td>1800200.0</td>\n",
       "      <td>464500.0</td>\n",
       "      <td>1093500.0</td>\n",
       "      <td>2781400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-08</th>\n",
       "      <td>134.869995</td>\n",
       "      <td>16.590000</td>\n",
       "      <td>225.740005</td>\n",
       "      <td>170.089996</td>\n",
       "      <td>174.960007</td>\n",
       "      <td>165.440002</td>\n",
       "      <td>314.529999</td>\n",
       "      <td>123.250000</td>\n",
       "      <td>338.920013</td>\n",
       "      <td>445.339996</td>\n",
       "      <td>...</td>\n",
       "      <td>2418800.0</td>\n",
       "      <td>2115100.0</td>\n",
       "      <td>24863600.0</td>\n",
       "      <td>1252100.0</td>\n",
       "      <td>1363500.0</td>\n",
       "      <td>1743200.0</td>\n",
       "      <td>1107600.0</td>\n",
       "      <td>387600.0</td>\n",
       "      <td>889300.0</td>\n",
       "      <td>2455500.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>57 rows × 3030 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Adj Close                                                 \\\n",
       "                     A        AAL         AAP        AAPL        ABBV   \n",
       "Date                                                                    \n",
       "2022-01-19  140.209869  17.309999  232.646133  166.018478  135.210007   \n",
       "2022-01-20  139.261353  16.760000  227.672363  164.300659  133.029999   \n",
       "2022-01-21  137.294449  16.299999  224.515335  162.203354  131.979996   \n",
       "2022-01-24  137.903488  16.410000  231.127197  161.414337  132.160004   \n",
       "2022-01-25  134.359070  16.459999  228.516205  159.576691  133.089996   \n",
       "2022-01-26  133.300705  16.240000  223.492783  159.486801  134.229996   \n",
       "2022-01-27  131.882935  15.780000  223.482864  159.017410  135.970001   \n",
       "2022-01-28  136.845154  15.640000  226.570389  170.113266  137.919998   \n",
       "2022-01-31  139.101624  16.469999  229.836594  174.557602  136.889999   \n",
       "2022-02-01  140.808929  16.830000  233.102829  174.387817  137.000000   \n",
       "2022-02-02  144.013901  16.959999  234.969223  175.616257  138.619995   \n",
       "2022-02-03  141.567734  16.570000  230.809525  172.679993  140.729996   \n",
       "2022-02-04  140.898788  16.450001  225.349274  172.389999  140.649994   \n",
       "2022-02-07  140.149963  17.280001  224.306870  171.660004  142.529999   \n",
       "2022-02-08  140.589279  18.260000  228.536072  174.830002  143.509995   \n",
       "2022-02-09  144.213593  18.760000  230.501755  176.279999  143.199997   \n",
       "2022-02-10  141.437943  18.709999  221.120056  172.119995  142.710007   \n",
       "2022-02-11  136.984924  17.610001  221.328552  168.639999  142.009995   \n",
       "2022-02-14  134.998062  17.430000  222.658859  168.880005  143.000000   \n",
       "2022-02-15  135.696960  18.840000  220.991013  172.789993  144.759995   \n",
       "2022-02-16  134.938141  18.820000  220.782516  172.550003  145.869995   \n",
       "2022-02-17  130.045822  18.219999  218.816833  168.880005  144.970001   \n",
       "2022-02-18  131.843002  17.870001  217.218475  167.300003  144.029999   \n",
       "2022-02-22  130.285461  17.430000  205.265488  164.320007  145.559998   \n",
       "2022-02-23  125.802490  16.639999  195.377487  160.070007  146.759995   \n",
       "2022-02-24  127.949112  16.959999  199.358505  162.740005  145.270004   \n",
       "2022-02-25  133.520370  17.459999  204.084106  164.850006  149.539993   \n",
       "2022-02-28  130.155655  17.250000  203.001968  165.119995  147.770004   \n",
       "2022-03-01  131.723190  16.290001  199.715897  163.199997  147.690002   \n",
       "2022-03-02  132.951263  16.370001  207.558807  166.559998  149.570007   \n",
       "2022-03-03  136.954971  15.710000  206.764587  166.229996  150.410004   \n",
       "2022-03-04  133.680115  14.590000  205.126511  163.169998  150.559998   \n",
       "2022-03-07  130.135681  12.840000  199.854889  159.300003  149.449997   \n",
       "2022-03-08  129.117294  13.510000  199.130173  157.440002  147.149994   \n",
       "2022-03-09  133.051102  14.300000  203.399094  162.949997  148.839996   \n",
       "2022-03-10  134.119431  14.200000  203.438797  158.520004  149.169998   \n",
       "2022-03-11  130.105728  14.020000  202.604874  154.729996  149.059998   \n",
       "2022-03-14  127.380013  14.250000  197.730362  150.619995  152.100006   \n",
       "2022-03-15  130.075775  15.570000  202.793503  155.089996  155.880005   \n",
       "2022-03-16  134.788376  16.469999  206.020004  159.589996  156.050003   \n",
       "2022-03-17  136.605530  16.549999  208.179993  160.619995  158.589996   \n",
       "2022-03-18  138.901917  16.750000  206.339996  163.979996  159.199997   \n",
       "2022-03-21  137.923462  16.090000  205.750000  165.380005  160.050003   \n",
       "2022-03-22  139.071655  16.559999  209.399994  168.820007  160.009995   \n",
       "2022-03-23  133.969666  16.209999  213.339996  170.210007  158.419998   \n",
       "2022-03-24  136.196182  16.719999  214.669998  174.070007  160.279999   \n",
       "2022-03-25  135.497269  17.010000  215.580002  174.720001  161.330002   \n",
       "2022-03-28  135.207718  17.299999  210.490005  175.600006  161.970001   \n",
       "2022-03-29  138.203018  18.160000  215.449997  178.960007  162.179993   \n",
       "2022-03-30  135.247665  18.049999  211.820007  177.770004  163.750000   \n",
       "2022-03-31  132.122574  18.250000  206.960007  174.610001  162.110001   \n",
       "2022-04-01  133.759995  18.240000  207.479996  174.309998  162.679993   \n",
       "2022-04-04  134.809998  18.230000  211.919998  178.440002  161.889999   \n",
       "2022-04-05  133.259995  17.840000  211.729996  175.059998  163.429993   \n",
       "2022-04-06  132.710007  17.379999  212.830002  171.830002  168.910004   \n",
       "2022-04-07  135.929993  16.950001  217.580002  172.139999  173.279999   \n",
       "2022-04-08  134.869995  16.590000  225.740005  170.089996  174.960007   \n",
       "\n",
       "                                                                        ...  \\\n",
       "                   ABC        ABMD         ABT         ACN        ADBE  ...   \n",
       "Date                                                                    ...   \n",
       "2022-01-19  131.959732  302.019989  126.050003  343.739990  516.580017  ...   \n",
       "2022-01-20  132.448151  302.750000  124.709999  342.690002  510.850006  ...   \n",
       "2022-01-21  131.092575  304.570007  125.830002  335.630005  499.910004  ...   \n",
       "2022-01-24  131.122467  311.940002  123.820000  339.000000  519.659973  ...   \n",
       "2022-01-25  130.634064  296.839996  123.269997  334.950012  502.720001  ...   \n",
       "2022-01-26  130.125717  297.140015  120.070000  329.890015  500.809998  ...   \n",
       "2022-01-27  134.252274  277.299988  120.440002  333.359985  493.049988  ...   \n",
       "2022-01-28  136.355408  277.250000  125.349998  342.850006  518.159973  ...   \n",
       "2022-01-31  135.757355  295.869995  127.459999  353.579987  534.299988  ...   \n",
       "2022-02-01  137.212616  301.350006  127.199997  353.420013  535.979980  ...   \n",
       "2022-02-02  135.637756  307.959991  130.039993  359.470001  533.090027  ...   \n",
       "2022-02-03  137.431900  290.519989  130.110001  345.549988  510.829987  ...   \n",
       "2022-02-04  136.166031  295.649994  129.710007  347.500000  513.539978  ...   \n",
       "2022-02-07  138.956924  289.839996  128.050003  343.959991  507.100006  ...   \n",
       "2022-02-08  141.777740  309.029999  128.649994  345.070007  511.309998  ...   \n",
       "2022-02-09  142.455521  315.920013  130.490005  355.529999  521.750000  ...   \n",
       "2022-02-10  141.080002  307.109985  127.760002  342.390015  495.019989  ...   \n",
       "2022-02-11  140.240005  294.820007  125.489998  329.179993  473.970001  ...   \n",
       "2022-02-14  140.179993  290.429993  122.779999  326.130005  474.010010  ...   \n",
       "2022-02-15  141.479996  304.700012  123.980003  329.410004  479.500000  ...   \n",
       "2022-02-16  142.729996  325.420013  123.680000  333.720001  477.700012  ...   \n",
       "2022-02-17  142.110001  307.109985  120.580002  322.910004  457.709991  ...   \n",
       "2022-02-18  141.500000  298.380005  116.790001  321.179993  442.559998  ...   \n",
       "2022-02-22  140.559998  296.640015  117.510002  321.109985  438.399994  ...   \n",
       "2022-02-23  139.470001  290.679993  117.250000  313.160004  429.450012  ...   \n",
       "2022-02-24  137.860001  306.920013  118.720001  316.170013  463.820007  ...   \n",
       "2022-02-25  141.919998  312.299988  122.410004  322.510010  465.540009  ...   \n",
       "2022-02-28  142.529999  310.739990  120.620003  316.019989  467.679993  ...   \n",
       "2022-03-01  141.970001  313.489990  118.169998  311.350006  466.679993  ...   \n",
       "2022-03-02  143.000000  315.850006  120.360001  318.329987  471.179993  ...   \n",
       "2022-03-03  145.470001  311.179993  120.970001  318.950012  459.079987  ...   \n",
       "2022-03-04  147.300003  313.720001  121.410004  314.160004  452.130005  ...   \n",
       "2022-03-07  144.839996  298.640015  118.860001  305.019989  437.970001  ...   \n",
       "2022-03-08  144.410004  290.390015  116.110001  301.619995  431.529999  ...   \n",
       "2022-03-09  145.830002  306.739990  118.389999  309.420013  450.869995  ...   \n",
       "2022-03-10  146.169998  305.619995  117.000000  309.519989  438.950012  ...   \n",
       "2022-03-11  144.559998  286.790009  114.019997  311.579987  416.380005  ...   \n",
       "2022-03-14  146.149994  277.549988  115.519997  307.679993  411.500000  ...   \n",
       "2022-03-15  151.389999  289.640015  117.480003  316.230011  421.660004  ...   \n",
       "2022-03-16  150.500000  294.529999  119.480003  324.910004  442.359985  ...   \n",
       "2022-03-17  152.199997  307.649994  121.199997  319.500000  444.359985  ...   \n",
       "2022-03-18  152.000000  304.329987  122.449997  323.950012  453.329987  ...   \n",
       "2022-03-21  153.179993  306.739990  121.760002  324.500000  453.589996  ...   \n",
       "2022-03-22  152.110001  313.339996  121.889999  327.470001  466.450012  ...   \n",
       "2022-03-23  151.529999  311.029999  116.919998  320.500000  422.899994  ...   \n",
       "2022-03-24  152.610001  321.470001  117.820000  325.290009  432.140015  ...   \n",
       "2022-03-25  154.690002  318.880005  118.949997  327.709991  431.619995  ...   \n",
       "2022-03-28  154.729996  321.809998  119.989998  330.739990  450.010010  ...   \n",
       "2022-03-29  155.039993  331.500000  120.190002  340.690002  466.329987  ...   \n",
       "2022-03-30  155.139999  328.510010  120.379997  338.459991  460.059998  ...   \n",
       "2022-03-31  154.710007  331.239990  118.360001  337.230011  455.619995  ...   \n",
       "2022-04-01  156.520004  338.640015  118.580002  340.640015  458.190002  ...   \n",
       "2022-04-04  154.750000  325.700012  118.879997  344.470001  468.809998  ...   \n",
       "2022-04-05  155.759995  322.660004  119.480003  342.820007  458.579987  ...   \n",
       "2022-04-06  158.139999  313.760010  119.940002  340.260010  444.329987  ...   \n",
       "2022-04-07  162.919998  317.519989  123.370003  341.769989  452.720001  ...   \n",
       "2022-04-08  165.440002  314.529999  123.250000  338.920013  445.339996  ...   \n",
       "\n",
       "               Volume                                                \\\n",
       "                 WYNN         XEL         XOM       XRAY        XYL   \n",
       "Date                                                                  \n",
       "2022-01-19  3154800.0   3758100.0  26431600.0  1027000.0  1529200.0   \n",
       "2022-01-20  3178300.0   3737200.0  26774600.0  1147900.0  1268600.0   \n",
       "2022-01-21  3871800.0   4885400.0  35995200.0  1271100.0  4093100.0   \n",
       "2022-01-24  5484500.0   4502300.0  41507000.0  1739500.0  1501200.0   \n",
       "2022-01-25  3114200.0   4756500.0  39278400.0  1785600.0  1636300.0   \n",
       "2022-01-26  3153000.0   4062100.0  35252400.0  1560900.0  1233300.0   \n",
       "2022-01-27  2870400.0   4442200.0  29174700.0  1074100.0  1096900.0   \n",
       "2022-01-28  2296000.0   3430400.0  30595700.0   898800.0  1122300.0   \n",
       "2022-01-31  2949500.0   3475800.0  36085500.0  1262300.0  1507600.0   \n",
       "2022-02-01  2931600.0   3372400.0  61033100.0  1539000.0  1380000.0   \n",
       "2022-02-02  2750900.0   2559800.0  30299300.0  1269500.0  1326600.0   \n",
       "2022-02-03  2631400.0   2530600.0  28529400.0   941700.0  3649700.0   \n",
       "2022-02-04  2884400.0   2517300.0  32197500.0   892600.0  2564500.0   \n",
       "2022-02-07  3352500.0   2652900.0  34949200.0   892000.0  1330000.0   \n",
       "2022-02-08  3248100.0   4155200.0  34356300.0  1247800.0  1750800.0   \n",
       "2022-02-09  3521600.0   3921800.0  40106100.0  1505100.0  1920400.0   \n",
       "2022-02-10  3357400.0   3232500.0  28527700.0  2286700.0  1505500.0   \n",
       "2022-02-11  4205400.0   3546800.0  42002100.0  1805400.0  1364400.0   \n",
       "2022-02-14  2323500.0   4491300.0  34652800.0  1092600.0  1469400.0   \n",
       "2022-02-15  4095700.0  10095000.0  25075100.0  2334600.0  1173600.0   \n",
       "2022-02-16  4118900.0   3148800.0  21733800.0  3441300.0   778700.0   \n",
       "2022-02-17  2704600.0   3545000.0  23738800.0   991600.0   939100.0   \n",
       "2022-02-18  3008900.0   3664200.0  23394800.0  1804100.0  1361500.0   \n",
       "2022-02-22  4338800.0   3556500.0  35947800.0  1880500.0  1686000.0   \n",
       "2022-02-23  2156100.0   3701500.0  25385000.0  1463500.0  1120800.0   \n",
       "2022-02-24  4455400.0   4720400.0  46199900.0  2101300.0  3113500.0   \n",
       "2022-02-25  2605700.0   4985000.0  28310300.0  2660000.0  1535500.0   \n",
       "2022-02-28  2395600.0   4173000.0  32204600.0  7547500.0  2033200.0   \n",
       "2022-03-01  4410200.0   4585200.0  40002300.0  5353600.0  1197900.0   \n",
       "2022-03-02  6974200.0   3256200.0  44321400.0  4347600.0  1305600.0   \n",
       "2022-03-03  4454900.0   2822100.0  30196600.0  3276600.0  1313400.0   \n",
       "2022-03-04  5060200.0   3515300.0  42802200.0  2580500.0  1756300.0   \n",
       "2022-03-07  6379900.0   4388600.0  55207900.0  1842100.0  1360200.0   \n",
       "2022-03-08  4978600.0   2883100.0  72082300.0  2031300.0  1594200.0   \n",
       "2022-03-09  5575500.0   2866900.0  65466700.0  2484900.0  1317500.0   \n",
       "2022-03-10  2337900.0   1945200.0  44644200.0  3860600.0  1759100.0   \n",
       "2022-03-11  3624700.0   3031500.0  35303400.0  3332700.0  1389800.0   \n",
       "2022-03-14  6019000.0   2392600.0  37462600.0  2510900.0  1173600.0   \n",
       "2022-03-15  4779700.0   4454600.0  47957900.0  2054400.0  1094300.0   \n",
       "2022-03-16  4677800.0   3809300.0  37812300.0  2533600.0  1568100.0   \n",
       "2022-03-17  2918300.0   3974500.0  34041900.0  2638900.0  1648100.0   \n",
       "2022-03-18  3715600.0   5750300.0  41461500.0  6863700.0  4327800.0   \n",
       "2022-03-21  2647900.0   2559000.0  33089300.0  2982200.0  1643700.0   \n",
       "2022-03-22  2732300.0   2351000.0  23132200.0  2983300.0  1678300.0   \n",
       "2022-03-23  1636700.0   2511300.0  27716300.0  1584900.0  1819800.0   \n",
       "2022-03-24  2598900.0   2257800.0  19871600.0  1350300.0  1075600.0   \n",
       "2022-03-25  1655500.0   1698900.0  22398300.0  1113800.0   811200.0   \n",
       "2022-03-28  2013300.0   1684200.0  21552400.0  1339900.0   860000.0   \n",
       "2022-03-29  2771000.0   2527000.0  27036300.0  2238800.0  1023000.0   \n",
       "2022-03-30  1456900.0   1582100.0  22079000.0  1735800.0   720500.0   \n",
       "2022-03-31  2382900.0   3045300.0  27861500.0  1677900.0  1415500.0   \n",
       "2022-04-01  3116600.0   2598100.0  18665800.0  1838400.0   913200.0   \n",
       "2022-04-04  2171400.0   2082300.0  20869400.0  1036400.0   850700.0   \n",
       "2022-04-05  2807100.0   2979400.0  21753100.0  1410600.0  1346100.0   \n",
       "2022-04-06  2926500.0   3350600.0  24768200.0  1706000.0  1271300.0   \n",
       "2022-04-07  3437600.0   3228700.0  26122000.0  1240400.0  1153100.0   \n",
       "2022-04-08  2418800.0   2115100.0  24863600.0  1252100.0  1363500.0   \n",
       "\n",
       "                                                                   \n",
       "                  YUM        ZBH       ZBRA       ZION        ZTS  \n",
       "Date                                                               \n",
       "2022-01-19  2100100.0  1795084.0   308200.0  1939400.0  2159600.0  \n",
       "2022-01-20  2929400.0  1734314.0   320000.0  1186500.0  2844200.0  \n",
       "2022-01-21  2130000.0  3061366.0   488900.0  1996000.0  2633000.0  \n",
       "2022-01-24  2927300.0  2113045.0   853600.0  2327900.0  4093400.0  \n",
       "2022-01-25  2667400.0  2417410.0   537900.0  3832600.0  2673200.0  \n",
       "2022-01-26  1958600.0  2914591.0   592500.0  2315800.0  4532700.0  \n",
       "2022-01-27  2680500.0  1933928.0   624500.0  1781200.0  4606200.0  \n",
       "2022-01-28  3465700.0  2317912.0   569200.0  2186800.0  2963800.0  \n",
       "2022-01-31  2414100.0  1487217.0   364800.0  1503400.0  2591500.0  \n",
       "2022-02-01  1485800.0  1066874.0   330000.0  1158000.0  2143200.0  \n",
       "2022-02-02  1640300.0  2534933.0   482800.0   948100.0  2494300.0  \n",
       "2022-02-03  1172600.0  1927336.0   487800.0  1243100.0  1734500.0  \n",
       "2022-02-04  1381100.0  1807547.0   394600.0  1207400.0  1919800.0  \n",
       "2022-02-07  1666600.0  6482408.0   299800.0   809400.0  3303900.0  \n",
       "2022-02-08  2345200.0  4657660.0   615200.0  1998800.0  2880500.0  \n",
       "2022-02-09  3703000.0  2209865.0   678600.0  1351700.0  2026900.0  \n",
       "2022-02-10  2178600.0  2519071.0   772700.0  2554400.0  2809000.0  \n",
       "2022-02-11  2929300.0  1900556.0  1276000.0  1226200.0  3714600.0  \n",
       "2022-02-14  2660300.0  1146699.0   659000.0  2020800.0  3381900.0  \n",
       "2022-02-15  4146800.0  1553961.0   616000.0  1631400.0  3618400.0  \n",
       "2022-02-16  2172500.0  1778604.0   538900.0  1230700.0  2916900.0  \n",
       "2022-02-17  2689500.0  1307379.0   609300.0  1110000.0  2435500.0  \n",
       "2022-02-18  2359400.0  1234352.0   536200.0  1701600.0  2558900.0  \n",
       "2022-02-22  1863800.0  2144769.0   549600.0  1223400.0  2347300.0  \n",
       "2022-02-23  2272500.0  1475990.0   569000.0  1148800.0  2070600.0  \n",
       "2022-02-24  2447600.0  1470634.0   508700.0  2880200.0  2903200.0  \n",
       "2022-02-25  1498200.0  1641614.0   440600.0  1941000.0  1742600.0  \n",
       "2022-02-28  2235500.0  2497647.0   541100.0  1732500.0  2220200.0  \n",
       "2022-03-01  1835700.0  7107800.0   462100.0  3224100.0  1669100.0  \n",
       "2022-03-02  1269200.0  2070900.0   409400.0  1935100.0  1355300.0  \n",
       "2022-03-03  1331500.0  1504100.0   241700.0  1874000.0  1052200.0  \n",
       "2022-03-04  1666700.0  1363800.0   532500.0  1760600.0  1467800.0  \n",
       "2022-03-07  2689000.0  1654900.0   504900.0  1815500.0  1825000.0  \n",
       "2022-03-08  2287200.0  1719000.0   407600.0  1698600.0  2414400.0  \n",
       "2022-03-09  1477400.0  1201900.0   346100.0  1409100.0  2630400.0  \n",
       "2022-03-10  2448500.0  1441500.0   250300.0  1230600.0  1995100.0  \n",
       "2022-03-11  2080500.0  2031200.0   410300.0  1138200.0  1589700.0  \n",
       "2022-03-14  3414100.0  1384800.0   330200.0  1525200.0  2044800.0  \n",
       "2022-03-15  1670300.0  1269000.0   341100.0  1117400.0  1261600.0  \n",
       "2022-03-16  2152800.0  1599300.0   321400.0  1999400.0  2064000.0  \n",
       "2022-03-17  1483500.0  1830200.0   537900.0  1884600.0  2199700.0  \n",
       "2022-03-18  3361800.0  2951500.0   930700.0  4135800.0  2613700.0  \n",
       "2022-03-21  1930700.0  1444100.0   491300.0  1779800.0  1891000.0  \n",
       "2022-03-22  1179300.0  1819700.0   455800.0  1805000.0  2374700.0  \n",
       "2022-03-23  1798900.0  2420000.0   325800.0  1498600.0  2115200.0  \n",
       "2022-03-24  1858300.0  2393500.0   311000.0  1329500.0  3445900.0  \n",
       "2022-03-25  1254700.0  1129700.0   294300.0  1996200.0  2363100.0  \n",
       "2022-03-28  1280800.0  1603300.0   319500.0  1344300.0  2995800.0  \n",
       "2022-03-29  1692400.0  1712200.0   292100.0  1257700.0  2557400.0  \n",
       "2022-03-30  2022800.0  1150200.0   316500.0  1257100.0  2612700.0  \n",
       "2022-03-31  3932200.0  1363100.0   575600.0  1578300.0  2477600.0  \n",
       "2022-04-01  2884000.0  1616900.0   505200.0  2479500.0  1831400.0  \n",
       "2022-04-04  1980400.0  1349700.0   492300.0  1220400.0  2603600.0  \n",
       "2022-04-05  2010900.0  2187100.0   456700.0  1384200.0  2059300.0  \n",
       "2022-04-06  1683100.0  2057700.0   442300.0  1568200.0  2843500.0  \n",
       "2022-04-07  2008900.0  1800200.0   464500.0  1093500.0  2781400.0  \n",
       "2022-04-08  1743200.0  1107600.0   387600.0   889300.0  2455500.0  \n",
       "\n",
       "[57 rows x 3030 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "f1f2c308",
   "metadata": {},
   "outputs": [],
   "source": [
    "# saving stocks data to csv\n",
    "stocks.to_csv(\"stocks_spy_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "83bde4c3",
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks = pd.read_csv(\"stocks_spy_data.csv\", header = [0,1], index_col = [0], parse_dates = [0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "a66a5a28",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MultiIndex([('Adj Close',    'A'),\n",
       "            ('Adj Close',  'AAL'),\n",
       "            ('Adj Close',  'AAP'),\n",
       "            ('Adj Close', 'AAPL'),\n",
       "            ('Adj Close', 'ABBV'),\n",
       "            ('Adj Close',  'ABC'),\n",
       "            ('Adj Close', 'ABMD'),\n",
       "            ('Adj Close',  'ABT'),\n",
       "            ('Adj Close',  'ACN'),\n",
       "            ('Adj Close', 'ADBE'),\n",
       "            ...\n",
       "            (   'Volume', 'WYNN'),\n",
       "            (   'Volume',  'XEL'),\n",
       "            (   'Volume',  'XOM'),\n",
       "            (   'Volume', 'XRAY'),\n",
       "            (   'Volume',  'XYL'),\n",
       "            (   'Volume',  'YUM'),\n",
       "            (   'Volume',  'ZBH'),\n",
       "            (   'Volume', 'ZBRA'),\n",
       "            (   'Volume', 'ZION'),\n",
       "            (   'Volume',  'ZTS')],\n",
       "           length=3030)"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "266d66c0",
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks.drop(\"Open\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "391473cd",
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks.drop(\"High\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "id": "205a8750",
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks.drop(\"Low\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "1140966d",
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks.drop(\"Close\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "id": "5bec6ed6",
   "metadata": {},
   "outputs": [],
   "source": [
    "stocks.drop(\"Volume\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "b13d0a40",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead 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=\"21\" halign=\"left\">Adj Close</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>A</th>\n",
       "      <th>AAL</th>\n",
       "      <th>AAP</th>\n",
       "      <th>AAPL</th>\n",
       "      <th>ABBV</th>\n",
       "      <th>ABC</th>\n",
       "      <th>ABMD</th>\n",
       "      <th>ABT</th>\n",
       "      <th>ACN</th>\n",
       "      <th>ADBE</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>2010-01-04</th>\n",
       "      <td>20.182621</td>\n",
       "      <td>4.496877</td>\n",
       "      <td>38.154903</td>\n",
       "      <td>6.544688</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.101797</td>\n",
       "      <td>8.740000</td>\n",
       "      <td>19.778837</td>\n",
       "      <td>33.334301</td>\n",
       "      <td>37.090000</td>\n",
       "      <td>...</td>\n",
       "      <td>42.508530</td>\n",
       "      <td>13.786248</td>\n",
       "      <td>43.185627</td>\n",
       "      <td>32.782581</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.794689</td>\n",
       "      <td>53.299198</td>\n",
       "      <td>28.670000</td>\n",
       "      <td>11.376088</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-05</th>\n",
       "      <td>19.963375</td>\n",
       "      <td>5.005957</td>\n",
       "      <td>37.928116</td>\n",
       "      <td>6.556004</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.944105</td>\n",
       "      <td>8.530000</td>\n",
       "      <td>19.619041</td>\n",
       "      <td>33.540310</td>\n",
       "      <td>37.700001</td>\n",
       "      <td>...</td>\n",
       "      <td>45.093864</td>\n",
       "      <td>13.622756</td>\n",
       "      <td>43.354244</td>\n",
       "      <td>32.392876</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.730406</td>\n",
       "      <td>54.986431</td>\n",
       "      <td>28.620001</td>\n",
       "      <td>11.777194</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-06</th>\n",
       "      <td>19.892447</td>\n",
       "      <td>4.798555</td>\n",
       "      <td>38.258835</td>\n",
       "      <td>6.451721</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.736616</td>\n",
       "      <td>8.400000</td>\n",
       "      <td>19.727999</td>\n",
       "      <td>33.896866</td>\n",
       "      <td>37.619999</td>\n",
       "      <td>...</td>\n",
       "      <td>44.502361</td>\n",
       "      <td>13.648920</td>\n",
       "      <td>43.728966</td>\n",
       "      <td>32.606281</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.596510</td>\n",
       "      <td>54.968670</td>\n",
       "      <td>28.400000</td>\n",
       "      <td>12.801298</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-07</th>\n",
       "      <td>19.866661</td>\n",
       "      <td>4.939965</td>\n",
       "      <td>38.249397</td>\n",
       "      <td>6.439795</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.388035</td>\n",
       "      <td>8.400000</td>\n",
       "      <td>19.891426</td>\n",
       "      <td>33.865170</td>\n",
       "      <td>36.889999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.452759</td>\n",
       "      <td>13.590055</td>\n",
       "      <td>43.591572</td>\n",
       "      <td>33.033108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.591158</td>\n",
       "      <td>56.229664</td>\n",
       "      <td>27.690001</td>\n",
       "      <td>14.235043</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010-01-08</th>\n",
       "      <td>19.860210</td>\n",
       "      <td>4.845691</td>\n",
       "      <td>38.400570</td>\n",
       "      <td>6.482610</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21.620428</td>\n",
       "      <td>8.230000</td>\n",
       "      <td>19.993120</td>\n",
       "      <td>33.730465</td>\n",
       "      <td>36.689999</td>\n",
       "      <td>...</td>\n",
       "      <td>45.127102</td>\n",
       "      <td>13.596595</td>\n",
       "      <td>43.416714</td>\n",
       "      <td>33.033108</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18.596510</td>\n",
       "      <td>55.048595</td>\n",
       "      <td>27.600000</td>\n",
       "      <td>14.004617</td>\n",
       "      <td>NaN</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",
       "      <td>...</td>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-04</th>\n",
       "      <td>134.809998</td>\n",
       "      <td>18.230000</td>\n",
       "      <td>211.919998</td>\n",
       "      <td>178.440002</td>\n",
       "      <td>161.889999</td>\n",
       "      <td>154.750000</td>\n",
       "      <td>325.700012</td>\n",
       "      <td>118.879997</td>\n",
       "      <td>344.470001</td>\n",
       "      <td>468.809998</td>\n",
       "      <td>...</td>\n",
       "      <td>81.839996</td>\n",
       "      <td>72.699997</td>\n",
       "      <td>83.160004</td>\n",
       "      <td>48.680000</td>\n",
       "      <td>86.760002</td>\n",
       "      <td>117.699997</td>\n",
       "      <td>125.860001</td>\n",
       "      <td>431.239990</td>\n",
       "      <td>64.099998</td>\n",
       "      <td>188.740005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-05</th>\n",
       "      <td>133.259995</td>\n",
       "      <td>17.840000</td>\n",
       "      <td>211.729996</td>\n",
       "      <td>175.059998</td>\n",
       "      <td>163.429993</td>\n",
       "      <td>155.759995</td>\n",
       "      <td>322.660004</td>\n",
       "      <td>119.480003</td>\n",
       "      <td>342.820007</td>\n",
       "      <td>458.579987</td>\n",
       "      <td>...</td>\n",
       "      <td>79.070000</td>\n",
       "      <td>73.070000</td>\n",
       "      <td>82.730003</td>\n",
       "      <td>48.630001</td>\n",
       "      <td>86.889999</td>\n",
       "      <td>117.639999</td>\n",
       "      <td>129.130005</td>\n",
       "      <td>423.720001</td>\n",
       "      <td>64.400002</td>\n",
       "      <td>188.399994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-06</th>\n",
       "      <td>132.710007</td>\n",
       "      <td>17.379999</td>\n",
       "      <td>212.830002</td>\n",
       "      <td>171.830002</td>\n",
       "      <td>168.910004</td>\n",
       "      <td>158.139999</td>\n",
       "      <td>313.760010</td>\n",
       "      <td>119.940002</td>\n",
       "      <td>340.260010</td>\n",
       "      <td>444.329987</td>\n",
       "      <td>...</td>\n",
       "      <td>76.169998</td>\n",
       "      <td>74.989998</td>\n",
       "      <td>83.650002</td>\n",
       "      <td>48.270000</td>\n",
       "      <td>86.709999</td>\n",
       "      <td>118.620003</td>\n",
       "      <td>127.849998</td>\n",
       "      <td>422.899994</td>\n",
       "      <td>63.669998</td>\n",
       "      <td>191.380005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-07</th>\n",
       "      <td>135.929993</td>\n",
       "      <td>16.950001</td>\n",
       "      <td>217.580002</td>\n",
       "      <td>172.139999</td>\n",
       "      <td>173.279999</td>\n",
       "      <td>162.919998</td>\n",
       "      <td>317.519989</td>\n",
       "      <td>123.370003</td>\n",
       "      <td>341.769989</td>\n",
       "      <td>452.720001</td>\n",
       "      <td>...</td>\n",
       "      <td>73.970001</td>\n",
       "      <td>74.570000</td>\n",
       "      <td>85.050003</td>\n",
       "      <td>48.070000</td>\n",
       "      <td>86.720001</td>\n",
       "      <td>120.400002</td>\n",
       "      <td>129.910004</td>\n",
       "      <td>418.399994</td>\n",
       "      <td>63.180000</td>\n",
       "      <td>197.929993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-04-08</th>\n",
       "      <td>134.869995</td>\n",
       "      <td>16.590000</td>\n",
       "      <td>225.740005</td>\n",
       "      <td>170.089996</td>\n",
       "      <td>174.960007</td>\n",
       "      <td>165.440002</td>\n",
       "      <td>314.529999</td>\n",
       "      <td>123.250000</td>\n",
       "      <td>338.920013</td>\n",
       "      <td>445.339996</td>\n",
       "      <td>...</td>\n",
       "      <td>72.230003</td>\n",
       "      <td>74.820000</td>\n",
       "      <td>86.839996</td>\n",
       "      <td>48.049999</td>\n",
       "      <td>86.669998</td>\n",
       "      <td>119.169998</td>\n",
       "      <td>129.619995</td>\n",
       "      <td>415.630005</td>\n",
       "      <td>63.889999</td>\n",
       "      <td>200.089996</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3093 rows × 505 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Adj Close                                                 \\\n",
       "                     A        AAL         AAP        AAPL        ABBV   \n",
       "Date                                                                    \n",
       "2010-01-04   20.182621   4.496877   38.154903    6.544688         NaN   \n",
       "2010-01-05   19.963375   5.005957   37.928116    6.556004         NaN   \n",
       "2010-01-06   19.892447   4.798555   38.258835    6.451721         NaN   \n",
       "2010-01-07   19.866661   4.939965   38.249397    6.439795         NaN   \n",
       "2010-01-08   19.860210   4.845691   38.400570    6.482610         NaN   \n",
       "...                ...        ...         ...         ...         ...   \n",
       "2022-04-04  134.809998  18.230000  211.919998  178.440002  161.889999   \n",
       "2022-04-05  133.259995  17.840000  211.729996  175.059998  163.429993   \n",
       "2022-04-06  132.710007  17.379999  212.830002  171.830002  168.910004   \n",
       "2022-04-07  135.929993  16.950001  217.580002  172.139999  173.279999   \n",
       "2022-04-08  134.869995  16.590000  225.740005  170.089996  174.960007   \n",
       "\n",
       "                                                                        ...  \\\n",
       "                   ABC        ABMD         ABT         ACN        ADBE  ...   \n",
       "Date                                                                    ...   \n",
       "2010-01-04   22.101797    8.740000   19.778837   33.334301   37.090000  ...   \n",
       "2010-01-05   21.944105    8.530000   19.619041   33.540310   37.700001  ...   \n",
       "2010-01-06   21.736616    8.400000   19.727999   33.896866   37.619999  ...   \n",
       "2010-01-07   21.388035    8.400000   19.891426   33.865170   36.889999  ...   \n",
       "2010-01-08   21.620428    8.230000   19.993120   33.730465   36.689999  ...   \n",
       "...                ...         ...         ...         ...         ...  ...   \n",
       "2022-04-04  154.750000  325.700012  118.879997  344.470001  468.809998  ...   \n",
       "2022-04-05  155.759995  322.660004  119.480003  342.820007  458.579987  ...   \n",
       "2022-04-06  158.139999  313.760010  119.940002  340.260010  444.329987  ...   \n",
       "2022-04-07  162.919998  317.519989  123.370003  341.769989  452.720001  ...   \n",
       "2022-04-08  165.440002  314.529999  123.250000  338.920013  445.339996  ...   \n",
       "\n",
       "                                                                               \\\n",
       "                 WYNN        XEL        XOM       XRAY        XYL         YUM   \n",
       "Date                                                                            \n",
       "2010-01-04  42.508530  13.786248  43.185627  32.782581        NaN   18.794689   \n",
       "2010-01-05  45.093864  13.622756  43.354244  32.392876        NaN   18.730406   \n",
       "2010-01-06  44.502361  13.648920  43.728966  32.606281        NaN   18.596510   \n",
       "2010-01-07  45.452759  13.590055  43.591572  33.033108        NaN   18.591158   \n",
       "2010-01-08  45.127102  13.596595  43.416714  33.033108        NaN   18.596510   \n",
       "...               ...        ...        ...        ...        ...         ...   \n",
       "2022-04-04  81.839996  72.699997  83.160004  48.680000  86.760002  117.699997   \n",
       "2022-04-05  79.070000  73.070000  82.730003  48.630001  86.889999  117.639999   \n",
       "2022-04-06  76.169998  74.989998  83.650002  48.270000  86.709999  118.620003   \n",
       "2022-04-07  73.970001  74.570000  85.050003  48.070000  86.720001  120.400002   \n",
       "2022-04-08  72.230003  74.820000  86.839996  48.049999  86.669998  119.169998   \n",
       "\n",
       "                                                           \n",
       "                   ZBH        ZBRA       ZION         ZTS  \n",
       "Date                                                       \n",
       "2010-01-04   53.299198   28.670000  11.376088         NaN  \n",
       "2010-01-05   54.986431   28.620001  11.777194         NaN  \n",
       "2010-01-06   54.968670   28.400000  12.801298         NaN  \n",
       "2010-01-07   56.229664   27.690001  14.235043         NaN  \n",
       "2010-01-08   55.048595   27.600000  14.004617         NaN  \n",
       "...                ...         ...        ...         ...  \n",
       "2022-04-04  125.860001  431.239990  64.099998  188.740005  \n",
       "2022-04-05  129.130005  423.720001  64.400002  188.399994  \n",
       "2022-04-06  127.849998  422.899994  63.669998  191.380005  \n",
       "2022-04-07  129.910004  418.399994  63.180000  197.929993  \n",
       "2022-04-08  129.619995  415.630005  63.889999  200.089996  \n",
       "\n",
       "[3093 rows x 505 columns]"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "stocks"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "159a283c",
   "metadata": {},
   "outputs": [],
   "source": [
    "# saving stocks data to csv\n",
    "stocks.to_csv(\"stocks_spy_adj_close.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "399e6763",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}