Part13: Datetime-Timeseries.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "StackOverflow Survey Download Page - https://insights.stackoverflow.com/survey\n",
    "Datetime Formatting Codes - https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior\n",
    "Pandas Date Offset Codes - https://pandas.pydata.org/pandas-docs/stable/user_guide/timeseries.html#dateoffset-objects"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Date</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",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-29</td>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-30</td>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-05-02</td>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-05-03</td>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>2021-04-25</td>\n",
       "      <td>2214.413818</td>\n",
       "      <td>2354.086670</td>\n",
       "      <td>2172.515137</td>\n",
       "      <td>2316.059570</td>\n",
       "      <td>2316.059570</td>\n",
       "      <td>3.181436e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>2021-04-26</td>\n",
       "      <td>2319.478027</td>\n",
       "      <td>2536.337402</td>\n",
       "      <td>2308.315186</td>\n",
       "      <td>2534.481689</td>\n",
       "      <td>2534.481689</td>\n",
       "      <td>3.520833e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>2021-04-27</td>\n",
       "      <td>2534.031250</td>\n",
       "      <td>2676.392822</td>\n",
       "      <td>2485.375000</td>\n",
       "      <td>2662.865234</td>\n",
       "      <td>2662.865234</td>\n",
       "      <td>3.227597e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>2021-04-28</td>\n",
       "      <td>2664.685547</td>\n",
       "      <td>2757.477295</td>\n",
       "      <td>2564.081543</td>\n",
       "      <td>2746.380127</td>\n",
       "      <td>2746.380127</td>\n",
       "      <td>3.426903e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>2021-04-29</td>\n",
       "      <td>2740.722900</td>\n",
       "      <td>2794.663818</td>\n",
       "      <td>2676.119385</td>\n",
       "      <td>2774.577393</td>\n",
       "      <td>2774.577393</td>\n",
       "      <td>3.294136e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date         Open         High          Low        Close  \\\n",
       "0    2020-04-29   198.465195   218.454636   198.124512   216.968231   \n",
       "1    2020-04-30   216.909134   227.529694   206.436920   207.602051   \n",
       "2    2020-05-01   207.901733   217.628021   207.780884   214.219101   \n",
       "3    2020-05-02   214.230087   215.847534   212.878677   215.325378   \n",
       "4    2020-05-03   215.352066   219.270874   208.692368   210.933151   \n",
       "..          ...          ...          ...          ...          ...   \n",
       "361  2021-04-25  2214.413818  2354.086670  2172.515137  2316.059570   \n",
       "362  2021-04-26  2319.478027  2536.337402  2308.315186  2534.481689   \n",
       "363  2021-04-27  2534.031250  2676.392822  2485.375000  2662.865234   \n",
       "364  2021-04-28  2664.685547  2757.477295  2564.081543  2746.380127   \n",
       "365  2021-04-29  2740.722900  2794.663818  2676.119385  2774.577393   \n",
       "\n",
       "       Adj Close        Volume  \n",
       "0     216.968231  2.639755e+10  \n",
       "1     207.602051  2.808919e+10  \n",
       "2     214.219101  2.081632e+10  \n",
       "3     215.325378  1.826088e+10  \n",
       "4     210.933151  2.046903e+10  \n",
       "..           ...           ...  \n",
       "361  2316.059570  3.181436e+10  \n",
       "362  2534.481689  3.520833e+10  \n",
       "363  2662.865234  3.227597e+10  \n",
       "364  2746.380127  3.426903e+10  \n",
       "365  2774.577393  3.294136e+10  \n",
       "\n",
       "[366 rows x 7 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('ETH-USD.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-3-365cc3f400f9>:1: FutureWarning: The pandas.datetime class is deprecated and will be removed from pandas in a future version. Import from datetime module instead.\n",
      "  d_parser = lambda x: pd.datetime.strptime(x, '%Y-%m-%d')\n"
     ]
    }
   ],
   "source": [
    "d_parser = lambda x: pd.datetime.strptime(x, '%Y-%m-%d')\n",
    "df = pd.read_csv('ETH-USD.csv', parse_dates=['Date'], date_parser=d_parser)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Date</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",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-29</td>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-30</td>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-05-02</td>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-05-03</td>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Date        Open        High         Low       Close   Adj Close  \\\n",
       "0 2020-04-29  198.465195  218.454636  198.124512  216.968231  216.968231   \n",
       "1 2020-04-30  216.909134  227.529694  206.436920  207.602051  207.602051   \n",
       "2 2020-05-01  207.901733  217.628021  207.780884  214.219101  214.219101   \n",
       "3 2020-05-02  214.230087  215.847534  212.878677  215.325378  215.325378   \n",
       "4 2020-05-03  215.352066  219.270874  208.692368  210.933151  210.933151   \n",
       "\n",
       "         Volume  \n",
       "0  2.639755e+10  \n",
       "1  2.808919e+10  \n",
       "2  2.081632e+10  \n",
       "3  1.826088e+10  \n",
       "4  2.046903e+10  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Wednesday'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[0, 'Date'].day_name()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</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",
       "      <th>DaysOfWeek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-29</td>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-30</td>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-05-02</td>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-05-03</td>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Date        Open        High         Low       Close   Adj Close  \\\n",
       "0 2020-04-29  198.465195  218.454636  198.124512  216.968231  216.968231   \n",
       "1 2020-04-30  216.909134  227.529694  206.436920  207.602051  207.602051   \n",
       "2 2020-05-01  207.901733  217.628021  207.780884  214.219101  214.219101   \n",
       "3 2020-05-02  214.230087  215.847534  212.878677  215.325378  215.325378   \n",
       "4 2020-05-03  215.352066  219.270874  208.692368  210.933151  210.933151   \n",
       "\n",
       "         Volume DaysOfWeek  \n",
       "0  2.639755e+10  Wednesday  \n",
       "1  2.808919e+10   Thursday  \n",
       "2  2.081632e+10     Friday  \n",
       "3  1.826088e+10   Saturday  \n",
       "4  2.046903e+10     Sunday  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['DaysOfWeek'] = df['Date'].dt.day_name()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 366 entries, 0 to 365\n",
      "Data columns (total 8 columns):\n",
      " #   Column      Non-Null Count  Dtype         \n",
      "---  ------      --------------  -----         \n",
      " 0   Date        366 non-null    datetime64[ns]\n",
      " 1   Open        363 non-null    float64       \n",
      " 2   High        363 non-null    float64       \n",
      " 3   Low         363 non-null    float64       \n",
      " 4   Close       363 non-null    float64       \n",
      " 5   Adj Close   363 non-null    float64       \n",
      " 6   Volume      363 non-null    float64       \n",
      " 7   DaysOfWeek  366 non-null    object        \n",
      "dtypes: datetime64[ns](1), float64(6), object(1)\n",
      "memory usage: 23.0+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2020-04-29 00:00:00')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2021-04-29 00:00:00')"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timedelta('365 days 00:00:00')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Date'].max() - df['Date'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>Date</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",
       "      <th>DaysOfWeek</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-04-29</td>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-04-30</td>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-05-01</td>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-05-02</td>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-05-03</td>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>2020-12-27</td>\n",
       "      <td>635.887146</td>\n",
       "      <td>711.393555</td>\n",
       "      <td>628.334961</td>\n",
       "      <td>682.642334</td>\n",
       "      <td>682.642334</td>\n",
       "      <td>2.609355e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>2020-12-28</td>\n",
       "      <td>683.205811</td>\n",
       "      <td>745.877747</td>\n",
       "      <td>683.205811</td>\n",
       "      <td>730.397339</td>\n",
       "      <td>730.397339</td>\n",
       "      <td>2.422257e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>2020-12-29</td>\n",
       "      <td>730.358704</td>\n",
       "      <td>737.952881</td>\n",
       "      <td>692.149414</td>\n",
       "      <td>731.520142</td>\n",
       "      <td>731.520142</td>\n",
       "      <td>1.871068e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>2020-12-30</td>\n",
       "      <td>731.472839</td>\n",
       "      <td>754.303223</td>\n",
       "      <td>720.988892</td>\n",
       "      <td>751.618958</td>\n",
       "      <td>751.618958</td>\n",
       "      <td>1.729457e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>2020-12-31</td>\n",
       "      <td>751.626648</td>\n",
       "      <td>754.299438</td>\n",
       "      <td>726.511902</td>\n",
       "      <td>737.803406</td>\n",
       "      <td>737.803406</td>\n",
       "      <td>1.392685e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>247 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          Date        Open        High         Low       Close   Adj Close  \\\n",
       "0   2020-04-29  198.465195  218.454636  198.124512  216.968231  216.968231   \n",
       "1   2020-04-30  216.909134  227.529694  206.436920  207.602051  207.602051   \n",
       "2   2020-05-01  207.901733  217.628021  207.780884  214.219101  214.219101   \n",
       "3   2020-05-02  214.230087  215.847534  212.878677  215.325378  215.325378   \n",
       "4   2020-05-03  215.352066  219.270874  208.692368  210.933151  210.933151   \n",
       "..         ...         ...         ...         ...         ...         ...   \n",
       "242 2020-12-27  635.887146  711.393555  628.334961  682.642334  682.642334   \n",
       "243 2020-12-28  683.205811  745.877747  683.205811  730.397339  730.397339   \n",
       "244 2020-12-29  730.358704  737.952881  692.149414  731.520142  731.520142   \n",
       "245 2020-12-30  731.472839  754.303223  720.988892  751.618958  751.618958   \n",
       "246 2020-12-31  751.626648  754.299438  726.511902  737.803406  737.803406   \n",
       "\n",
       "           Volume DaysOfWeek  \n",
       "0    2.639755e+10  Wednesday  \n",
       "1    2.808919e+10   Thursday  \n",
       "2    2.081632e+10     Friday  \n",
       "3    1.826088e+10   Saturday  \n",
       "4    2.046903e+10     Sunday  \n",
       "..            ...        ...  \n",
       "242  2.609355e+10     Sunday  \n",
       "243  2.422257e+10     Monday  \n",
       "244  1.871068e+10    Tuesday  \n",
       "245  1.729457e+10  Wednesday  \n",
       "246  1.392685e+10   Thursday  \n",
       "\n",
       "[247 rows x 8 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filt = (df['Date'] >= pd.to_datetime('2020-04-29')) & (df['Date'] < pd.to_datetime('2021-01-01'))\n",
    "df.loc[filt]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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",
       "      <th>DaysOfWeek</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-04-29</th>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-04-30</th>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-01</th>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-02</th>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-03</th>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</td>\n",
       "      <td>Sunday</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-25</th>\n",
       "      <td>2214.413818</td>\n",
       "      <td>2354.086670</td>\n",
       "      <td>2172.515137</td>\n",
       "      <td>2316.059570</td>\n",
       "      <td>2316.059570</td>\n",
       "      <td>3.181436e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-26</th>\n",
       "      <td>2319.478027</td>\n",
       "      <td>2536.337402</td>\n",
       "      <td>2308.315186</td>\n",
       "      <td>2534.481689</td>\n",
       "      <td>2534.481689</td>\n",
       "      <td>3.520833e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-27</th>\n",
       "      <td>2534.031250</td>\n",
       "      <td>2676.392822</td>\n",
       "      <td>2485.375000</td>\n",
       "      <td>2662.865234</td>\n",
       "      <td>2662.865234</td>\n",
       "      <td>3.227597e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-28</th>\n",
       "      <td>2664.685547</td>\n",
       "      <td>2757.477295</td>\n",
       "      <td>2564.081543</td>\n",
       "      <td>2746.380127</td>\n",
       "      <td>2746.380127</td>\n",
       "      <td>3.426903e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-29</th>\n",
       "      <td>2740.722900</td>\n",
       "      <td>2794.663818</td>\n",
       "      <td>2676.119385</td>\n",
       "      <td>2774.577393</td>\n",
       "      <td>2774.577393</td>\n",
       "      <td>3.294136e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>366 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Open         High          Low        Close    Adj Close  \\\n",
       "Date                                                                          \n",
       "2020-04-29   198.465195   218.454636   198.124512   216.968231   216.968231   \n",
       "2020-04-30   216.909134   227.529694   206.436920   207.602051   207.602051   \n",
       "2020-05-01   207.901733   217.628021   207.780884   214.219101   214.219101   \n",
       "2020-05-02   214.230087   215.847534   212.878677   215.325378   215.325378   \n",
       "2020-05-03   215.352066   219.270874   208.692368   210.933151   210.933151   \n",
       "...                 ...          ...          ...          ...          ...   \n",
       "2021-04-25  2214.413818  2354.086670  2172.515137  2316.059570  2316.059570   \n",
       "2021-04-26  2319.478027  2536.337402  2308.315186  2534.481689  2534.481689   \n",
       "2021-04-27  2534.031250  2676.392822  2485.375000  2662.865234  2662.865234   \n",
       "2021-04-28  2664.685547  2757.477295  2564.081543  2746.380127  2746.380127   \n",
       "2021-04-29  2740.722900  2794.663818  2676.119385  2774.577393  2774.577393   \n",
       "\n",
       "                  Volume DaysOfWeek  \n",
       "Date                                 \n",
       "2020-04-29  2.639755e+10  Wednesday  \n",
       "2020-04-30  2.808919e+10   Thursday  \n",
       "2020-05-01  2.081632e+10     Friday  \n",
       "2020-05-02  1.826088e+10   Saturday  \n",
       "2020-05-03  2.046903e+10     Sunday  \n",
       "...                  ...        ...  \n",
       "2021-04-25  3.181436e+10     Sunday  \n",
       "2021-04-26  3.520833e+10     Monday  \n",
       "2021-04-27  3.227597e+10    Tuesday  \n",
       "2021-04-28  3.426903e+10  Wednesday  \n",
       "2021-04-29  3.294136e+10   Thursday  \n",
       "\n",
       "[366 rows x 7 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.set_index('Date', inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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",
       "      <th>DaysOfWeek</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-04-29</th>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-04-30</th>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-01</th>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-02</th>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-03</th>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</td>\n",
       "      <td>Sunday</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-27</th>\n",
       "      <td>635.887146</td>\n",
       "      <td>711.393555</td>\n",
       "      <td>628.334961</td>\n",
       "      <td>682.642334</td>\n",
       "      <td>682.642334</td>\n",
       "      <td>2.609355e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-28</th>\n",
       "      <td>683.205811</td>\n",
       "      <td>745.877747</td>\n",
       "      <td>683.205811</td>\n",
       "      <td>730.397339</td>\n",
       "      <td>730.397339</td>\n",
       "      <td>2.422257e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-29</th>\n",
       "      <td>730.358704</td>\n",
       "      <td>737.952881</td>\n",
       "      <td>692.149414</td>\n",
       "      <td>731.520142</td>\n",
       "      <td>731.520142</td>\n",
       "      <td>1.871068e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-30</th>\n",
       "      <td>731.472839</td>\n",
       "      <td>754.303223</td>\n",
       "      <td>720.988892</td>\n",
       "      <td>751.618958</td>\n",
       "      <td>751.618958</td>\n",
       "      <td>1.729457e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-31</th>\n",
       "      <td>751.626648</td>\n",
       "      <td>754.299438</td>\n",
       "      <td>726.511902</td>\n",
       "      <td>737.803406</td>\n",
       "      <td>737.803406</td>\n",
       "      <td>1.392685e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>247 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Open        High         Low       Close   Adj Close  \\\n",
       "Date                                                                     \n",
       "2020-04-29  198.465195  218.454636  198.124512  216.968231  216.968231   \n",
       "2020-04-30  216.909134  227.529694  206.436920  207.602051  207.602051   \n",
       "2020-05-01  207.901733  217.628021  207.780884  214.219101  214.219101   \n",
       "2020-05-02  214.230087  215.847534  212.878677  215.325378  215.325378   \n",
       "2020-05-03  215.352066  219.270874  208.692368  210.933151  210.933151   \n",
       "...                ...         ...         ...         ...         ...   \n",
       "2020-12-27  635.887146  711.393555  628.334961  682.642334  682.642334   \n",
       "2020-12-28  683.205811  745.877747  683.205811  730.397339  730.397339   \n",
       "2020-12-29  730.358704  737.952881  692.149414  731.520142  731.520142   \n",
       "2020-12-30  731.472839  754.303223  720.988892  751.618958  751.618958   \n",
       "2020-12-31  751.626648  754.299438  726.511902  737.803406  737.803406   \n",
       "\n",
       "                  Volume DaysOfWeek  \n",
       "Date                                 \n",
       "2020-04-29  2.639755e+10  Wednesday  \n",
       "2020-04-30  2.808919e+10   Thursday  \n",
       "2020-05-01  2.081632e+10     Friday  \n",
       "2020-05-02  1.826088e+10   Saturday  \n",
       "2020-05-03  2.046903e+10     Sunday  \n",
       "...                  ...        ...  \n",
       "2020-12-27  2.609355e+10     Sunday  \n",
       "2020-12-28  2.422257e+10     Monday  \n",
       "2020-12-29  1.871068e+10    Tuesday  \n",
       "2020-12-30  1.729457e+10  Wednesday  \n",
       "2020-12-31  1.392685e+10   Thursday  \n",
       "\n",
       "[247 rows x 7 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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",
       "      <th>DaysOfWeek</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-04-29</th>\n",
       "      <td>198.465195</td>\n",
       "      <td>218.454636</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>216.968231</td>\n",
       "      <td>2.639755e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-04-30</th>\n",
       "      <td>216.909134</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>206.436920</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>207.602051</td>\n",
       "      <td>2.808919e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-01</th>\n",
       "      <td>207.901733</td>\n",
       "      <td>217.628021</td>\n",
       "      <td>207.780884</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>214.219101</td>\n",
       "      <td>2.081632e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-02</th>\n",
       "      <td>214.230087</td>\n",
       "      <td>215.847534</td>\n",
       "      <td>212.878677</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>215.325378</td>\n",
       "      <td>1.826088e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-03</th>\n",
       "      <td>215.352066</td>\n",
       "      <td>219.270874</td>\n",
       "      <td>208.692368</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>210.933151</td>\n",
       "      <td>2.046903e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-04</th>\n",
       "      <td>210.890854</td>\n",
       "      <td>211.828384</td>\n",
       "      <td>199.047729</td>\n",
       "      <td>208.174011</td>\n",
       "      <td>208.174011</td>\n",
       "      <td>2.260245e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-05</th>\n",
       "      <td>208.013000</td>\n",
       "      <td>211.778625</td>\n",
       "      <td>204.031128</td>\n",
       "      <td>206.774399</td>\n",
       "      <td>206.774399</td>\n",
       "      <td>1.900469e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-06</th>\n",
       "      <td>206.481354</td>\n",
       "      <td>211.534622</td>\n",
       "      <td>204.040878</td>\n",
       "      <td>204.055786</td>\n",
       "      <td>204.055786</td>\n",
       "      <td>2.034354e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-07</th>\n",
       "      <td>203.912857</td>\n",
       "      <td>214.392471</td>\n",
       "      <td>202.074844</td>\n",
       "      <td>212.289413</td>\n",
       "      <td>212.289413</td>\n",
       "      <td>2.359474e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-08</th>\n",
       "      <td>212.198242</td>\n",
       "      <td>216.327682</td>\n",
       "      <td>208.830734</td>\n",
       "      <td>212.991577</td>\n",
       "      <td>212.991577</td>\n",
       "      <td>2.044514e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-09</th>\n",
       "      <td>213.142166</td>\n",
       "      <td>214.739120</td>\n",
       "      <td>209.071518</td>\n",
       "      <td>211.600128</td>\n",
       "      <td>211.600128</td>\n",
       "      <td>1.895055e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-10</th>\n",
       "      <td>211.552200</td>\n",
       "      <td>211.552200</td>\n",
       "      <td>182.711166</td>\n",
       "      <td>188.599564</td>\n",
       "      <td>188.599564</td>\n",
       "      <td>2.521158e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-11</th>\n",
       "      <td>188.632187</td>\n",
       "      <td>191.362335</td>\n",
       "      <td>180.718338</td>\n",
       "      <td>185.912842</td>\n",
       "      <td>185.912842</td>\n",
       "      <td>2.005460e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-12</th>\n",
       "      <td>185.877335</td>\n",
       "      <td>191.601349</td>\n",
       "      <td>185.701797</td>\n",
       "      <td>189.312500</td>\n",
       "      <td>189.312500</td>\n",
       "      <td>1.589973e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-13</th>\n",
       "      <td>189.374100</td>\n",
       "      <td>200.197327</td>\n",
       "      <td>189.127701</td>\n",
       "      <td>199.193283</td>\n",
       "      <td>199.193283</td>\n",
       "      <td>1.705466e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-14</th>\n",
       "      <td>198.891510</td>\n",
       "      <td>204.117599</td>\n",
       "      <td>196.868820</td>\n",
       "      <td>202.949097</td>\n",
       "      <td>202.949097</td>\n",
       "      <td>2.015052e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-15</th>\n",
       "      <td>202.955399</td>\n",
       "      <td>203.566391</td>\n",
       "      <td>193.755676</td>\n",
       "      <td>195.622665</td>\n",
       "      <td>195.622665</td>\n",
       "      <td>1.660234e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-16</th>\n",
       "      <td>195.613388</td>\n",
       "      <td>202.771194</td>\n",
       "      <td>194.501587</td>\n",
       "      <td>200.677124</td>\n",
       "      <td>200.677124</td>\n",
       "      <td>1.537908e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-17</th>\n",
       "      <td>200.608871</td>\n",
       "      <td>209.160934</td>\n",
       "      <td>200.102798</td>\n",
       "      <td>207.158691</td>\n",
       "      <td>207.158691</td>\n",
       "      <td>1.547040e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-18</th>\n",
       "      <td>207.179779</td>\n",
       "      <td>215.908463</td>\n",
       "      <td>207.109070</td>\n",
       "      <td>214.525055</td>\n",
       "      <td>214.525055</td>\n",
       "      <td>1.741157e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-19</th>\n",
       "      <td>214.604935</td>\n",
       "      <td>214.604935</td>\n",
       "      <td>210.143051</td>\n",
       "      <td>213.451111</td>\n",
       "      <td>213.451111</td>\n",
       "      <td>1.434619e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-20</th>\n",
       "      <td>213.446243</td>\n",
       "      <td>214.716827</td>\n",
       "      <td>207.975815</td>\n",
       "      <td>210.096741</td>\n",
       "      <td>210.096741</td>\n",
       "      <td>1.273018e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-21</th>\n",
       "      <td>210.129150</td>\n",
       "      <td>211.625183</td>\n",
       "      <td>193.346436</td>\n",
       "      <td>199.883606</td>\n",
       "      <td>199.883606</td>\n",
       "      <td>1.330832e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-22</th>\n",
       "      <td>199.837112</td>\n",
       "      <td>208.591537</td>\n",
       "      <td>198.040863</td>\n",
       "      <td>207.169189</td>\n",
       "      <td>207.169189</td>\n",
       "      <td>1.204159e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-23</th>\n",
       "      <td>207.194489</td>\n",
       "      <td>210.386459</td>\n",
       "      <td>205.294220</td>\n",
       "      <td>208.694397</td>\n",
       "      <td>208.694397</td>\n",
       "      <td>1.066548e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-24</th>\n",
       "      <td>208.716064</td>\n",
       "      <td>210.595078</td>\n",
       "      <td>202.370346</td>\n",
       "      <td>202.370346</td>\n",
       "      <td>202.370346</td>\n",
       "      <td>1.183330e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-25</th>\n",
       "      <td>201.982651</td>\n",
       "      <td>206.361450</td>\n",
       "      <td>200.667557</td>\n",
       "      <td>205.319748</td>\n",
       "      <td>205.319748</td>\n",
       "      <td>1.041504e+10</td>\n",
       "      <td>Monday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-26</th>\n",
       "      <td>205.259567</td>\n",
       "      <td>205.752548</td>\n",
       "      <td>200.264282</td>\n",
       "      <td>201.902313</td>\n",
       "      <td>201.902313</td>\n",
       "      <td>1.015974e+10</td>\n",
       "      <td>Tuesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-27</th>\n",
       "      <td>201.893005</td>\n",
       "      <td>208.863434</td>\n",
       "      <td>201.785065</td>\n",
       "      <td>208.863434</td>\n",
       "      <td>208.863434</td>\n",
       "      <td>1.063103e+10</td>\n",
       "      <td>Wednesday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-28</th>\n",
       "      <td>208.885437</td>\n",
       "      <td>220.276505</td>\n",
       "      <td>206.242661</td>\n",
       "      <td>219.840424</td>\n",
       "      <td>219.840424</td>\n",
       "      <td>1.221247e+10</td>\n",
       "      <td>Thursday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-29</th>\n",
       "      <td>219.925049</td>\n",
       "      <td>224.216873</td>\n",
       "      <td>218.238052</td>\n",
       "      <td>220.675125</td>\n",
       "      <td>220.675125</td>\n",
       "      <td>1.226582e+10</td>\n",
       "      <td>Friday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-30</th>\n",
       "      <td>220.717209</td>\n",
       "      <td>243.943146</td>\n",
       "      <td>218.744461</td>\n",
       "      <td>242.345596</td>\n",
       "      <td>242.345596</td>\n",
       "      <td>1.502740e+10</td>\n",
       "      <td>Saturday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-31</th>\n",
       "      <td>242.351379</td>\n",
       "      <td>244.045258</td>\n",
       "      <td>230.052826</td>\n",
       "      <td>230.975708</td>\n",
       "      <td>230.975708</td>\n",
       "      <td>1.223490e+10</td>\n",
       "      <td>Sunday</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Open        High         Low       Close   Adj Close  \\\n",
       "Date                                                                     \n",
       "2020-04-29  198.465195  218.454636  198.124512  216.968231  216.968231   \n",
       "2020-04-30  216.909134  227.529694  206.436920  207.602051  207.602051   \n",
       "2020-05-01  207.901733  217.628021  207.780884  214.219101  214.219101   \n",
       "2020-05-02  214.230087  215.847534  212.878677  215.325378  215.325378   \n",
       "2020-05-03  215.352066  219.270874  208.692368  210.933151  210.933151   \n",
       "2020-05-04  210.890854  211.828384  199.047729  208.174011  208.174011   \n",
       "2020-05-05  208.013000  211.778625  204.031128  206.774399  206.774399   \n",
       "2020-05-06  206.481354  211.534622  204.040878  204.055786  204.055786   \n",
       "2020-05-07  203.912857  214.392471  202.074844  212.289413  212.289413   \n",
       "2020-05-08  212.198242  216.327682  208.830734  212.991577  212.991577   \n",
       "2020-05-09  213.142166  214.739120  209.071518  211.600128  211.600128   \n",
       "2020-05-10  211.552200  211.552200  182.711166  188.599564  188.599564   \n",
       "2020-05-11  188.632187  191.362335  180.718338  185.912842  185.912842   \n",
       "2020-05-12  185.877335  191.601349  185.701797  189.312500  189.312500   \n",
       "2020-05-13  189.374100  200.197327  189.127701  199.193283  199.193283   \n",
       "2020-05-14  198.891510  204.117599  196.868820  202.949097  202.949097   \n",
       "2020-05-15  202.955399  203.566391  193.755676  195.622665  195.622665   \n",
       "2020-05-16  195.613388  202.771194  194.501587  200.677124  200.677124   \n",
       "2020-05-17  200.608871  209.160934  200.102798  207.158691  207.158691   \n",
       "2020-05-18  207.179779  215.908463  207.109070  214.525055  214.525055   \n",
       "2020-05-19  214.604935  214.604935  210.143051  213.451111  213.451111   \n",
       "2020-05-20  213.446243  214.716827  207.975815  210.096741  210.096741   \n",
       "2020-05-21  210.129150  211.625183  193.346436  199.883606  199.883606   \n",
       "2020-05-22  199.837112  208.591537  198.040863  207.169189  207.169189   \n",
       "2020-05-23  207.194489  210.386459  205.294220  208.694397  208.694397   \n",
       "2020-05-24  208.716064  210.595078  202.370346  202.370346  202.370346   \n",
       "2020-05-25  201.982651  206.361450  200.667557  205.319748  205.319748   \n",
       "2020-05-26  205.259567  205.752548  200.264282  201.902313  201.902313   \n",
       "2020-05-27  201.893005  208.863434  201.785065  208.863434  208.863434   \n",
       "2020-05-28  208.885437  220.276505  206.242661  219.840424  219.840424   \n",
       "2020-05-29  219.925049  224.216873  218.238052  220.675125  220.675125   \n",
       "2020-05-30  220.717209  243.943146  218.744461  242.345596  242.345596   \n",
       "2020-05-31  242.351379  244.045258  230.052826  230.975708  230.975708   \n",
       "\n",
       "                  Volume DaysOfWeek  \n",
       "Date                                 \n",
       "2020-04-29  2.639755e+10  Wednesday  \n",
       "2020-04-30  2.808919e+10   Thursday  \n",
       "2020-05-01  2.081632e+10     Friday  \n",
       "2020-05-02  1.826088e+10   Saturday  \n",
       "2020-05-03  2.046903e+10     Sunday  \n",
       "2020-05-04  2.260245e+10     Monday  \n",
       "2020-05-05  1.900469e+10    Tuesday  \n",
       "2020-05-06  2.034354e+10  Wednesday  \n",
       "2020-05-07  2.359474e+10   Thursday  \n",
       "2020-05-08  2.044514e+10     Friday  \n",
       "2020-05-09  1.895055e+10   Saturday  \n",
       "2020-05-10  2.521158e+10     Sunday  \n",
       "2020-05-11  2.005460e+10     Monday  \n",
       "2020-05-12  1.589973e+10    Tuesday  \n",
       "2020-05-13  1.705466e+10  Wednesday  \n",
       "2020-05-14  2.015052e+10   Thursday  \n",
       "2020-05-15  1.660234e+10     Friday  \n",
       "2020-05-16  1.537908e+10   Saturday  \n",
       "2020-05-17  1.547040e+10     Sunday  \n",
       "2020-05-18  1.741157e+10     Monday  \n",
       "2020-05-19  1.434619e+10    Tuesday  \n",
       "2020-05-20  1.273018e+10  Wednesday  \n",
       "2020-05-21  1.330832e+10   Thursday  \n",
       "2020-05-22  1.204159e+10     Friday  \n",
       "2020-05-23  1.066548e+10   Saturday  \n",
       "2020-05-24  1.183330e+10     Sunday  \n",
       "2020-05-25  1.041504e+10     Monday  \n",
       "2020-05-26  1.015974e+10    Tuesday  \n",
       "2020-05-27  1.063103e+10  Wednesday  \n",
       "2020-05-28  1.221247e+10   Thursday  \n",
       "2020-05-29  1.226582e+10     Friday  \n",
       "2020-05-30  1.502740e+10   Saturday  \n",
       "2020-05-31  1.223490e+10     Sunday  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-04':'2020-05']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "208.3779328787879"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-04':'2020-05']['Close'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "244.04525800000002"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['2020-05']['High'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2020-04-29     218.454636\n",
       "2020-04-30     227.529694\n",
       "2020-05-01     217.628021\n",
       "2020-05-02     215.847534\n",
       "2020-05-03     219.270874\n",
       "                 ...     \n",
       "2021-04-25    2354.086670\n",
       "2021-04-26    2536.337402\n",
       "2021-04-27    2676.392822\n",
       "2021-04-28    2757.477295\n",
       "2021-04-29    2794.663818\n",
       "Name: High, Length: 366, dtype: float64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['High']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.resample.DatetimeIndexResampler object at 0x000001BF91867AF0>"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['High'].resample('D')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2020-04-29     218.454636\n",
       "2020-04-30     227.529694\n",
       "2020-05-01     217.628021\n",
       "2020-05-02     215.847534\n",
       "2020-05-03     219.270874\n",
       "                 ...     \n",
       "2021-04-25    2354.086670\n",
       "2021-04-26    2536.337402\n",
       "2021-04-27    2676.392822\n",
       "2021-04-28    2757.477295\n",
       "2021-04-29    2794.663818\n",
       "Freq: D, Name: High, Length: 366, dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "highs = df['High'].resample('D').max()\n",
    "highs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Date'>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX0AAAESCAYAAAAR2wXeAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8vihELAAAACXBIWXMAAAsTAAALEwEAmpwYAAA3UklEQVR4nO3dd3ykVb348c83vfey2U229w677NJdQFgElCYKegWuBS+iXq7o71pQueqqV8WCNLFQLCBcUEDpS5O+2WV775tNr5M2yWTm+/vjeZKdZJNNMmmT5Pt+vfLKzHnKOc9k8p0z5zlFVBVjjDHjQ8RIF8AYY8zwsaBvjDHjiAV9Y4wZRyzoG2PMOGJB3xhjxhEL+sYYM45EjXQBepOVlaVTp04d6WIYY8yosn79+kpVze6aHvZBf+rUqRQWFo50MYwxZlQRkUPdpVvzjjHGjCMW9I0xZhyxoG+MMeOIBX1jjBlHLOgbY8w4YkHfGGPGkbDvsmmMMabv/AHlUFVjj9utpm+MMWPIuoPVnHv7az1ut6BvjDFjyHNbS4mN6jm0W9A3xpgxIhBQnttaytmzj5t9oYMFfWOMGSN2l9dT6vFywfzcHvexoG+MMWPEvnLnBu78iSk97mNB3xhjxogDlQ0ATMtK7HEfC/rGGDNG7K9sJC81joSYnnvjW9A3xpgx4kBl4wlr+WBB3xhjxgwL+sYYM07UNrVS2+SzoG+MMeNBRX0LALkpcSfcz4K+McaMQgcrG9l6tK7jeWVDKwCZSTEnPM6CvjHGjEL/+9xObnl0U8fzqkanpp+VFHvC4yzoG2PMKFTV0Ep1U2un5wCZiVbTN8aYMae2uZV6r6/jeVVDCxECaQkW9I0xZsypa/bh9QVobQsAUNHQSkZiDJERcsLjLOgbY8woVNvk1PLba/tVDS1kJp64PR8s6BtjzKjj9flpcWv49d42AKoaW3vtuQMW9I0xJqxVNbTw+u4K2vyBjrT2Wj6AJ7im30vPHehD0BeRAhF5RUR2iMg2EflPN/02ETkqIhvdn4uCjvmGiOwVkV0isjoofZmIbHG33SEiJ258MsaYcczj9bF8zUtc+4f3eHpzcUd6bfOxXjsdNf2G1l577kDfavptwC2qOg84FbhJROa7236hqkvdn2cA3G1XAwuAC4G7RSTS3f8e4AZglvtzYR/yN8aYcelIdROqzuN39lV3pNcF1fTrvT5a2wLUt7QNTtBX1RJV3eA+rgd2AJNOcMilwCOq2qKqB4C9wAoRyQNSVPVtVVXgIeCyXktojDHjVJnHC0BWUgzvHTwW9Gubg5p3mtuoc5+nJkT3es5+temLyFTgJOBdN+mLIrJZRP4gIulu2iTgSNBhRW7aJPdx13RjjDHdKK1zRtlesngiByobKa93PgTqurTpdwT9+EEM+iKSBDwO3KyqHpymmhnAUqAEuL19124O1xOkd5fXDSJSKCKFFRUVfS2iMcaMKaUeLyJwvrvm7c6SeuD4Nv32oJ8yWEFfRKJxAv6fVfUJAFUtU1W/qgaA3wIr3N2LgIKgw/OBYjc9v5v046jqfaq6XFWXZ2f3vKq7McaMZWV1XrKSYslLdWbOrGxwav61TT4iI4Sk2CjqvW14BrOm7/aw+T2wQ1V/HpSeF7Tb5cBW9/FTwNUiEisi03Bu2L6nqiVAvYic6p7zWuDJXktojDHjVKnHy4SUOLKTna6Y7UG/pslHWnw0yXFR/W7e6XkhxWPOAD4FbBGRjW7aN4FrRGQpThPNQeDzAKq6TUQeBbbj9Py5SVX97nE3Ag8A8cCz7o8xxphulHm85KfHkxQbRWxURMec+RX1XrKTY1F1eu8MatBX1Tfovj3+mRMcswZY0016IbCw11IZY4yh1ONl2ZR0RITs5NiOOfPL61vISYnD2+qnpmmIbuQaY4wZPl6fn9omHxPclbCykmI7avplHi+5ybFMyUxgf0Ujdc0+EmIiiY7sPaRb0DfGmDBU7nGXP3Rv4jo1/Rb8AaWyoZWclFhm5yZT2dDCoarGPtXywYK+McaEpVJ3YFbXmn5VoxP4c1PimJWbBEDhoRoL+sYYM5p1BP2gmn51UysltU56TrJT0wenC2df+uiDBX1jjAlLZXVOcM91a/rZSTGows5SDwA5KXHkpcaRHOv0x7GavjHGjGKlHi/x0ZGkxDlBPccN/huP1DnPk2MRkY7Ruk2tbX06b1/66RtjjBlmpR4vE1LjaJ+BfnJGAgDr3InX2gdsrbl8Ed42Pxctyuv+RF1Y0DfGmDBUVuclN+XYoijtQX9veQP56fHERjkz1sfHRHL3J5f1+bzWvGOMMWGofQqGdomxUWS5K2PNnZAc8nkt6BtjTJhRVco9LR199NtNyXRq+3Ms6BtjzNhR3dhKqz/QqaYPMCWjPeinhHxuC/rGGBNmug7Maje5vaafG3pN327kGmNMmGlfJrFr884liyfiaW5jZk5SyOe2oG+MMWGmfZnErjX9mTlJfOfD8wd0bmveMcaYMNO+TGJ7X/zBZEHfGGPCTFmdl8zE2D5NldxfFvSNMSbMOKNxB7+WD9amb4wxYePZLSWU1Hkprm3u6JM/2CzoG2NMmLjxzxs6Hl+5LH9I8rDmHWOMCUMfXjJxSM5rQd8YY4bRzlIPNY3OAuf+gHKoqhEAnz9AhDOhJmfMzGRSWvyQ5G/NO8YYM0xa2vxc+Mt/AfD4jadz58t7eGVXBfd9ahlzJ6QQUPjuh+fzseUFQ1YGq+kbY8wwqWn0dTz+zIPreGVXBbkpsXzzb1vZW1EPOJOpJcYOXX3cgr4xxgyTmianWScpNoraJh/z81L48RWLqWxo4bHCIgAK0oem1047C/rGGDNMapucmv71p08F4JqVkzltRiZx0RE8u7WUyAghr8t8O4PN2vSNMWaY1Lo1/YsW5XHGzCxWTMsgMkJYkp/GuweqOWVqOlFDMAo3mAV9Y4wZJjVuTT89MZr5E4/Nif+V82fz2Poivn3xwCZT6wsL+sYYM0za2/TTE2I6pa+cnsnK6ZnDUgZr0zfGmGFS29RKXHQEcdGRI1aGXoO+iBSIyCsiskNEtonIf7rpGSLyoojscX+nBx3zDRHZKyK7RGR1UPoyEdnibrtDRGRoLssYM97tLqvn1V3lI12MTmqafMfV8odbX2r6bcAtqjoPOBW4SUTmA18H1qrqLGCt+xx329XAAuBC4G4Raf9Yuwe4AZjl/lw4iNdijDEdfvr8Lr708PsEAjrSRelQ29RKanz0iJah16CvqiWqusF9XA/sACYBlwIPurs9CFzmPr4UeERVW1T1ALAXWCEieUCKqr6tqgo8FHSMMcYMqh0lHuq9bRypaRrponQYLTX9DiIyFTgJeBfIVdUScD4YgBx3t0nAkaDDity0Se7jrunGGDOoPF4fRTXNAGw96hnh0hxT09RKemKY1/TbiUgS8Dhws6qe6FXsrp1eT5DeXV43iEihiBRWVFT0tYjGGAPA7tL6jsfbiutGsCTHqCrVja2kjYaavohE4wT8P6vqE25ymdtkg/u7/Y5JERA8W1A+UOym53eTfhxVvU9Vl6vq8uzs7L5eizHGALDDDfpZSbFsORoeQX9PeQO1TT4WTkwd0XL0pfeOAL8Hdqjqz4M2PQVc5z6+DngyKP1qEYkVkWk4N2zfc5uA6kXkVPec1wYdY4wxg8IfUP6v8Ah5qXFcsjiP9w5U09jSNtLF4uWdTr343Lk5vew5tPpS0z8D+BRwrohsdH8uAn4MnC8ie4Dz3eeo6jbgUWA78Bxwk6r63XPdCPwO5+buPuDZwbwYY4x5elMxm4rq+PqH5rJ6wQRa2gK8tnvkm4lf2VnO/LwUJgzx3Dq96XVErqq+Qfft8QDn9XDMGmBNN+mFwML+FNAYY/pjy9E64qMj+ciSifgDSkZiDC9uL+OiRXkhn3PdwWo+ff86PnPWNG7+4Ox+H6+qbC/xcPlJI993xUbkGmPGlKKaJvLT4xERoiIjmJObzJHqgXXbLDxYQ31LG798aQ97yup7P6CLmiYf9d42pmQmDqgcg8GCvjFmTCmqaaYg49ic9BmJMVS7c96Efs5jHxqvhDDKt31JxCkZQztXfl9Y0DfGjClFNc3kpx9bXzY9MbpjTdpQHa1tZuGkFOZOSO64Idsfh6qcD42pWRb0jTFmQJwB/g6P10dds69T0M9IiKG22Yc/hOkYyuu9qKrzQZKWwAdmZ1N4sIbWtkDHPiV1zTS3+k9wFifoi0D+EK+K1RcW9I0xo9Zb+yo57Ucv81ihMwlAUbUzCjc4uKYnxqAKdc2+bs/RHX9A+fwfC1mxZi2PrDvC0ZpmJqXHMy8vhbaActBtrmlqbWP1L17nZy/sOuH5DlU1kpcSN6Kza7azoG+MGZV8/gCf/+N6Sj1e1jyzg+ZWf0fbe6eafqIzAra6H008b++r4vltZQD8/MXdNPv85KfHMys3CXBm8CyubeZP7xzC423jzb2VPZ7LH1DeP1LLtOyRv4kLtoiKMWaUap9Q7frTp/LAWwf53j+2Ewgo8dGRTM9O6tivfYKzmn7czH1iQxHJcVHccv5sbnt6OwCT0uKZkZ1EhMCdL+/lUFUTzT6nWWdXWT11zb5uZ9D8x+ZiDlQ2cssF/e/qORQs6BtjRhVV5fENR3lmSwkAN5w9nbjoSO59bR8A16woICn2WGjrb01fVXlxexkXLpzA1Ssms6usgQ2HalhakEZcdCQZiTHsLK1n0aRU5k5IRgQeLSxiw+Eazplz/GjbJzcWMzkjgYsWhj5OYDBZ0DfGjCp3v7qPnz7vtKGLQF5qHP9v9RwiI+CPbx/i+tOnddo/3Q36fe3BU9fso76ljTkTkomLjuRHVyzqsoczVvVHVyxi4aRUmlrb+OfmEn74zx0snpRKZlJsp72La5uZnZtMRER4rBllbfrGmFFDVfnTO4dYUpAGwJzcZESEiAjha6vnsum7FzBnQnKnYzLc5p2+9tU/WuvcDJ6UFt/t9t986mTWXL6QhZOcidMSYqK479rl7Clv4MmNx88hWVLnJW+Ep14IZjV9Y8yosb+ykZI6L186dxbfuWQeOcmdg2l3K7DGx0QSFx3R55p+Sa0XgIk9BP1lUzJYNiWjU9rpMzJJjo3qGITVrqm1jbpmH3lpFvSNMabf2nvJnDkzi8mZfe/znpkYS0V9S5/2La5zavr9CdQiwuTMBA51me6hpM75AAmnmr417xhjwprPH+iY72bdwRompsb1K+ADTM9OZF9FY+874jTvxERGkJUY2/vOQaZmJnaMvG3X/q0hL7X7bw0jwYK+MSas/XXdEc7/xes8t7WU/RUNzO7SZt8Xs3OT2VNe36dRuSW1XvLS4vp943VKZgJFNU34/J1H64LV9I0xps+2FDkrX333qa3sKW9gWlb/BznNyU3G6wv0abbN4tpmJoZQM5+SmYDPr8z61rMcrGzkaG0zv3xpDwC5KRb0jTGmT/ZXNgBQ5mmhtS3A9BCCfvBI2t4cqm5iUnooQf9YuXaWevj+09s5WttMdnJsWEy/0M6CvjEmbKkqO0vquWjRhI604NG2fTUr12kS2ll64qBf7vFSUd/C/LyUfudx8uR0PrlyMuAs5PLijjLOm5vDw59b2e9zDSUL+saYsHW0tpn6ljbOmJnVkRZK805SbBRzJyTz1r6e58gB2FbsAejog98fMVERfP/ShURHCg+9fQh/QLn1kvnMzOn/PYihZEHfGBO21h+qAWDuhBRWTHP6xk8IsX383Lk5rDtYc8LZNrcede4fzJ/Y/5o+QESEkJMcR723jYzEmJA+oIaaBX1jTNj60zuHKMiIZ2lBGg/++wre/Pq5IU9ncN68HPwB5fUTLJK+tbiO6VmJnebu6a/cFKer54wwmVWzKwv6xpiwtK+igXUHa7j21KlERgjxMZE9To3QF0vy04iMEHZ1addvafN3DNw6UNnIjJz+3zMINsHtnjkjhHsPw8GCvjEmLO13B1OtnJ7Ry559ExUZQU5ybMco2Xa3PbWdU9a8RF2Tj/L6lpCbj9q1d8+0oG+MMf1Q5nGC82D2cZ+QGkepp7lT2t/eLwLgwbcPUtvkIye5fyNxj8ujPejnWPOOMcb0WbnHS4RApjs18mDIS43rVNP3+vwdo3R//fLgDKSal5dCbFQECyb2vwfQcLCgb4wJS2WeFrKSYomKHLwwNSElntI6b8di6luO1uHzK0vyU/H5nbSclIHV9M+enc373zk/rEbhBrOgb4wJS6Ue76AHzrzUOJpa/dS3tAHwrz1Ov/2rlhd07NN1uuZQJMSE7wTGFvSNMWGpzOPt6P44WHLdnjWldV7a/AEeXXeEs2dns3LasZvFg51nuLGgb4wJS+X1LUNS0wdnnvs39lZS6vHyiRWTO82b076Q+lgVvt9BjDHjVkubn+rG1kEP+vnuRGq7S+vxu+36Z8zMJCbqWP03XNayHSq91vRF5A8iUi4iW4PSbhORoyKy0f25KGjbN0Rkr4jsEpHVQenLRGSLu+0O6W5dM2OMgY7BUgPtPtlVXmo8Cyam8PTmYo7WNJMaH01yXDTgLHk4a4ADs0aDvtT0HwDuBB7qkv4LVf1ZcIKIzAeuBhYAE4GXRGS2qvqBe4AbgHeAZ4ALgWcHVHpjzJhU0+jMj5MxiN012122dBJrntlBvbet0wjfv3zu1EHPKxz1WtNX1deB6j6e71LgEVVtUdUDwF5ghYjkASmq+rY6faUeAi4LsczGmDGuttlZxDxtCNrXVy9wpmk+UNkY0rz5o91AbuR+UUQ2u80/6W7aJOBI0D5Fbtok93HXdGOMOU5tk1PTT0+IHvRzF2TEdwz4GshcPqNVqEH/HmAGsBQoAW5307trp9cTpHdLRG4QkUIRKayo6HlGPGPM2FTb5NT0U4cg6IsIU90pj/Otpt83qlqmqn5VDQC/BVa4m4qAgqBd84FiNz2/m/Sezn+fqi5X1eXZ2dmhFNEYE+YaW9o61r/tqr2mnxY/NN0ns5OcG8Qp8YP/oRLuQgr6bht9u8uB9p49TwFXi0isiEwDZgHvqWoJUC8ip7q9dq4FnhxAuY0xo9z9bx7ginvepNEdHRusttlHYkxkp66Ug+kad1nDJflpQ3L+cNZr7x0ReRhYBWSJSBHwXWCViCzFaaI5CHweQFW3icijwHagDbjJ7bkDcCNOT6B4nF471nPHmHFse4kHn185UtPE3AmdV6qqbfINyU3cdh+Ync3eNR8a1Hl9Roteg76qXtNN8u9PsP8aYE036YXAwn6VzhgzJtz72j5On5HJ4qCa9e6yBgAOVzlBf2eph7ioSKZmJVLb1ErqEDe9jMeADzYNgzFmiLX5A/z42Z1844ktHbNbtrYFOFjpLJJyuLoJgP/66yY+/cA6/AGlttlHeuL4a28fDhb0jTFDyuN12uy3FXt4ZVc5AAerGmlz57E/4gb9ouom9lc28uzWEmqbWofsJu54Z0HfGDOk2rtfAtyxdi+qyh63aScuOoLD1U3Ue30d0x3f+fJeapp8Q9Jd01jQN8YMsdpmp/vl+fNz2XiklvcOVHO01qndL5uSzqHqpo7VrFbNyWZnaT3Vja1DMjDLWNA3xgyxOjfoX32KM4RnW7GHck8L8dGRnD4ji/0VjXzuoUIAPn/2DJYUpAHO5Ghm8NnUysaYATtY2dgxyrWrOneg1dSsRGKiIijzeCmrbyEnJZbPnz2dfeUNPPH+UcCZIuHvXzid3WUNTM1KGLbyjydW0zfGDMjz20pZ9bNXWbujrNvt7W366QkxHQuTl3u85CQ7699efvKxabhyU+IQEeZMSCY2KnJYyj/eWNA3xgzI81tLAdhT3tDt9vY2/ZS4KCakxFFa56WivqVjLdrlU44tVRg9TvvODyd7hY0xA7KjtB44tvBJV7VNPpLjooiKjHBq+p5myt3mHYD4mEiiIoQYC/jDwtr0jTEhK/N42VHiAeBQVWO3+9Q1+0hze+JMSI3nSLUz12J7TR9g/bfP7xi4ZYaWBX1jTEiOVDfx8HuHAZidm8TBqqZO2+96ZS8er6/TQKsJKceWPwxeCnGop1wwx1jQN8b0m88f4KyfvALAymkZLC1I4/63DhIIKBERgs8f4Dev7aO+pY3EmChOmpwGODX9djkpg7v+rekba0QzxvRbcFPOzR+czeTMBFrbApR4nEFW6w5W4/G2oQoNLW0kxDg9ceblJRMVIcRGRTArJ3lEyj7eWU3fGNNve8udoP/UF89gcX4aPn8AgKM1zcRFRfDrtXuJjYrg5x9byi9e2s2ZM7MAmJKZyM7vX0hkhOAsrWGGmwV9Y0y/7atwumfOyE4CIC/VuSlb6vHy3NZS1h2s5psXzePixXlcvDiv07HjdUrjcGGvvjGm3/aVN5CXGkdirFNvzG0P+nXNHK5uZGZOEp8+c9pIFtH0wIK+Mabf9lU0dNTyAZJjo0iMiaS0roWSOm9Hzd+EHwv6xph+UVX2VTi1+XYiQm5qHKWeZkrrvJ166ZjwYkHfGNMvZZ4WGlramJHdeYK1vNQ4DlU1UdXYajX9MGZB3xjTLx03cYNq+gATUuLZVuyMzp1gQT9sWdA3xvTZtuI6Ht9QBMDM7C5BP/XYYKuJ1rwTtqzLpjGmzy6+4w0AIgSykzuPqM1PPzb/vdX0w5fV9I0x/RZQjhtc9ZElEzseW9APX1bTN8b0WXpCNDVNPr5/6YLjtiXGRvHuN89j45FakmIttIQrq+kbY/rEH1Bqm318+bxZfOq0qd3uk5sSx+oFE4a3YKZfLOgbY/qkpqkVVchMjBnpopgBsKBvjOmTqgZnrdsMC/qjmgV9Y0yfVDU6yyFmJlnQH80s6Btj+qS60anpZyba4iejWa9BX0T+ICLlIrI1KC1DRF4UkT3u7/Sgbd8Qkb0isktEVgelLxORLe62O8Qm0zZmVGkP+ta8M7r1pab/AHBhl7SvA2tVdRaw1n2OiMwHrgYWuMfcLSKR7jH3ADcAs9yfruc0xoSx9jb99ARbz3Y06zXoq+rrQHWX5EuBB93HDwKXBaU/oqotqnoA2AusEJE8IEVV31ZnyfuHgo4xxowCVY0tpCVE2yIoo1yof71cVS0BcH/nuOmTgCNB+xW5aZPcx13TjTGjRE2Tj4wEa9oZ7Qb7I7u7dno9QXr3JxG5QUQKRaSwoqJi0ApnjAldg7eN5DgbaTvahRr0y9wmG9zf5W56EVAQtF8+UOym53eT3i1VvU9Vl6vq8uzs7BCLaIwZTA0tbSRZ0B/1Qg36TwHXuY+vA54MSr9aRGJFZBrODdv33CagehE51e21c23QMcaYUaDB22Zz6owBvf4FReRhYBWQJSJFwHeBHwOPishngMPAVQCquk1EHgW2A23ATarqd091I05PoHjgWffHGDNK1Ht9JMVaz53Rrtegr6rX9LDpvB72XwOs6Sa9EFjYr9IZY8JGfYu16Y8F1vfKGNMrVXXa9K15Z9SzoG+M6VVTqx9VrKY/BljQN8b0qqGlDcB674wBFvSNMb2q97pB35p3Rj0L+saYXrXX9K15Z/SzoG+M6VVDR03fumyOdhb0jTG9amjxAda8MxZY0DfG9Kq9Td+ad0Y/C/rGmF519N6xmv6oZ0HfGNOr9jb9RAv6o54FfWNMrxpa2oiNiiAmykLGaGd/QWNMr7YW1zE5I2Gki2EGgQV9Y0yPDlU1sqWojnf2V3PBgtyRLo4ZBNZAZ4zpxB9Q/vLuIY7Wern3tX0d6R9amDeCpTKDxYK+MaaTl3eW8+0ntwFw3twcVkzLoLqxlQUTU0a4ZGYwWNA3xnTy1CZnJdNbzp/NdWdMJSXORuGOJRb0jTEdvD4/L24v5d9OncyXzps10sUxQ8Bu5BpjOmwrrsPrC3D2rOyRLooZIhb0jRlHAgE94fYtRXUALMpPHY7imBFgzTvGjBPbiz18/Ddvc9lJkwio8uXzZpGbEtdpny1HPWQlxTChS7oZOyzoGzNO/H3jUepb2vjjO4cAeH5bGY/csJKZOckd+2w9WsfCSamIyEgV0wwxa94xZpRpam3D30szTVeqyovbyzhjZiZPf/FMnr/5bETgmt++y6u7yinzeNlSVMfu8npOKkgfopKbcGA1fWPClD+gREZ0rnHXNfm44Jevccniidy4agap8dFER/Zed9tX0cCBykY+fea0jvb6v3x2JVff9w7X37+OaVmJxEZFkJ0Uy/VnTB2KyzFhwmr6xoQZVeUXL+5myf+8QOHB6k7bfvbCLso8LTz83mFO+9Falv/gJd4/XNPrOZ/fVgbA+fOOTaUwKzeZf3z5TL56wWwOVDays7SeNZcvIjXe+uWPZVbTNybMvLqrgl+t3UNsVARfevh9Xr5lFfExkTS3+nls/RHm56WwvcRDTnIsESJ84c8bEGD51Ay+/qG5TEyLP+6cL2wvY0l+KhNSO9+gzUuN56ZzZrLxSB2T0uI4f77NrzPWWU3fmDDzaOERspJi+N11yymp8/K0O0L2jb2VeH0BvnHRXK49bQq/uvokvnLBbErqvOSmxvHSjjIu+fUblNZ5AWhp8/PhX7/BGT9+mU1Halm9cEK3+YkIv7tuOf9z6cJhu0Yzcqymb0wYqWlsZe2Ocj512hTOnJnF7Nwk/vTuIT52SgHPbyslOS6KU6dncpY7eOpUzWDhxFTmTkhmb0UDl975Jv/+wDq+dO5M9lc0sOVoHWfPzubqUwr4zJnTRvjqTDiwoG9MGHl6czGt/gBXnpyPiHDVsgLWPLODnaUentlSwkWL8jrduBUR5rsToc3OTeZnVy3hh8/s4At/3kBkhHDRognc/cllI3U5JgxZ844xYeTx9UXMy0vpCORnz3Zq9Dc/spGmVj/XnTb1hMdfvDiPtbd8gJXTMjh5cho/+eiSoS6yGWUGVNMXkYNAPeAH2lR1uYhkAH8FpgIHgY+pao27/zeAz7j7f1lVnx9I/saMJXvK6tlUVMe3L5nfkTY7NwmAnaX1rJiW0afpEeKiI3nkhlMBbJCVOc5g1PTPUdWlqrrcff51YK2qzgLWus8RkfnA1cAC4ELgbhGJHIT8jRkT/m9DEVERwqVLJ3akiQgXuD1qfnzFoj6fS0Qs4JtuDUXzzqXAg+7jB4HLgtIfUdUWVT0A7AVWDEH+xow6/oDy9/ePsmpONllJsZ22/fSqJbz2tVVMz04aodKZsWSgQV+BF0RkvYjc4KblqmoJgPs7x02fBBwJOrbITTNmXCuubeafW0oo87Rw5cn5x21PjY9mSmbiCJTMjEUD7b1zhqoWi0gO8KKI7DzBvt191+x2AhH3A+QGgMmTJw+wiGakbThcw21PbePzZ8/g4sW2zmqw57aWcPNfN+L1BQA4d15OL0cYMzADCvqqWuz+LheRv+E015SJSJ6qlohIHlDu7l4EFAQdng8U93De+4D7AJYvX96/maVM2PnbhqNsLqrjpr9sYOGkVeOm1nqoqpGMxBiS46LZXVbPfz++meykWF7ZVc6UzER+ePki/uuvm5iVk8ye8nquO30qsVF2m8sMrZCDvogkAhGqWu8+vgD4HvAUcB3wY/f3k+4hTwF/EZGfAxOBWcB7Ayi7GSXePVDF7Nwk9pY38GjhEb62eu5IF2nIPfzeYW79+1YyE2M4c1YW24s97KtoAODykybxz80lfOw3b5McG8V91y4jPSGGmD5MnGbMQA2kpp8L/M3tIRAF/EVVnxORdcCjIvIZ4DBwFYCqbhORR4HtQBtwk6r6B1R6M+T8AeW+1/fj8fr4wOxsth6t48NLJh63+EZPqhpa2F3WwNdWz2HDoRr+b30RX71gzpjuWeL1+fn+P7azbHI6kRHCm3srKfO0cPtVS7ji5EmICFeenM/reyq4aFEeeanHz5VjzFAJOeir6n7guJEfqloFnNfDMWuANaHmaYbfbU9t44/vHCIqQrjn1X0A/PZf+/na6rlccdIkIiJ6Dt6tbQG+89Q2AM6YmUV2Uixrd5azp7yB2bnJPR432r25t5KmVj83nTuTD8zORlWpafKRkRjTsc/K6ZmsnJ45gqU045VNwzBOeX1+YqMiTljjbm7189fCI3xseT7fung+L20vIzU+mp+9sIuvPraJP7xxgLNnZ/P/Vs/pNvj/6Z1D/HNzCV9bPYelBWlkukHv7X1VoyboP/LeYR4tPEJ6QgwZiTGcNiOTc+bkkJYQ3e1rp6o8ubGY5NgoTnODuoh0CvjGjCQL+uNQY0sbq3/5OvPyUrhgfi7PbytjckYCH1k6kZk5Sewo8RAfHcme8npa2wJ8ZMkkUuOjuXKZ053wvHk5PLa+iAfePMi9r+1jamYCa3eW88aeSj6xcjLfvmQ+e8rqueuVvZw+I5ObzpkJQEFGAvnp8by+u4JrT5sS9k08R6qbuO3pbeQkx+H1BdhUVMtj64sASIiJ5H+vXMyHlzgDqd7ZX8WR6ib2VjTw1KZi/v2MqcREWRu9CT+iGt6dY5YvX66FhYUjXYwx5Y61e/j5i7s7nk9Ki6eyoYWWtgAxkRG0+gOd9t/1gwu77VUSCCiX3vUmW47WAXD6jEze2lfF5IwEDlc3kZYQzZ8/u5IFE49NHfCDf2znd28c4LNnTuPWoOkGAHz+AC9tL8Pj9XH6jCwKMhK4+9W9vL67gpXTMjl7djaL81P7tFJUfzy3tZSTp6SRk3zsPoWq8tkHC3l7fxUvfeUDTEyLR1V5Y28le8oaeHJTMbtKPZwzJ4e95Q3sKW/oOPaaFQWsuWzRCZu+jBlqIrI+aKaEY+kW9MeXQEBZ8cOXWFqQ1nFDduW0DBpa2nhqUzHbiz2smpNDQJUnNx5lelYSX109p8fzHa1t5on1RSzMT+WsmVl85dFN1Ht9rJyeyZUn55Od3Hl0qT+g3PLoRp7ZWkrhrR8kJS4anz/AA28e5KUdZbx74NhKUUvyU9lytI4JKXGUeLyowpKCNH5/3fLjRq32xyPvHWZTUR0zc5L42PJ8Vv5wLQFVFk5M5aPL8nl2aynvHqjC6wvwrYvm8bmzpx93jvJ6L998Ygv7KxuZlBbPBQsmsKWolu0lHh77/OnEx1jXSzOyLOgbwBkodcXdb/Grq5dy6dKRGRD9/uEaLr/7Lb536QL+beUUfrV2D79au4fk2Cj++0NzOXV6Ji/vLOOeV/cRUHj1q6vwtvn51+5Kbv37Vj66PJ8fXu7MQ+P1+alsaOHBtw5S1+x8Q3jgrYOsmJbBNy+a123+P3xmB09sOMq0rAQe+4/TOVDZyP1vHuD13RUcrGoiIzGGCxdOICYygm9dPK9f3yxUNeybrcz4YEHfAPDT53dy72v72XDr+aQmjMxaqKrKeT9/jf0VjR3NSZcuncivrj6p037Vja00tbaRn57QkfbVxzbxzJYS7vrEyfz+jQO8sbcSgKgIISYqgqZWP3HREXh9Ac6Zk01ts4/aJh8xkRF87JQCXt9dwW8+tYy46MjjAnRDSxuPFR7h4sV5nZp6jBmNLOgbntniDPlfOS2DP35m5YiWpdzj5ZVd5ewtb2ByRgJXLS8gLrr3JpHNRbV85M43AchKiuGjywpIjInkymX5JMZGUVTTxOSMBG5/YTev764gOzmW7ORY3j9cy9HaZuZOSOahT68gp4/jDIwZrSzoj1N/eOMAv3hpN2fPyubF7WUszk/lvmuXj+ouhBsO11BR38JZs7JIiOlbB7Simib+/v5Rrj9jGkmx1mnNjH0W9MehP71ziG8/uZU5ucnUNfuYmBbPH647ZcSadYwxw6enoG9VnjHqH5uLufXvW1k1J5t7PrnMepMYYwAL+mNSSV0za/65gwUTU/j9dacQaf3FjTEuC/pjzKGqRi67601a2gLc9cmTLeAbYzqxoN+D0djf2uvz8x9/2kBA4akvnsnMHFtezxjTmQX9ICV1zTy3tZQtRXW8uKOMWTlJLJ+aQXFtM3HRkSTFRlHb1EpFQwuV9a3kp8dz20cWkBIXTUp8VLcfEmUeL//YXMK2o3WkJ8bwzYvm9Vr7rmpoYd3Bal7cXk5lQwvLp6SzKD+VumYfNY2tFGQkkJ0cy+zc5I5ujnVNPr719y3sKPFw//WnWMA3xnQr7IN+W0CHpdbd2hbgU79/j73lDaTERXHu3Bze2FPJ1mIPE1PjaG0LUO9tIy0xmqykWAoyEvjXngrO+skrAOSnx5McF01kBGQkxjIzO4nkuCgeLTxCSZ2X5Lgo6r1tFB6q4dTpGSyalIqqUzvfWVpPbFQEM3OSUIWfvbCLkjoviTGRTM5M5PageXKCxUdHMjcvmaKaZirqWwD42uo5nDPXltwzxnQv7LtsxubN0ut/8jAfnJdLVWMrH19eQHpiDHXNPrYV1xEIwPyJKT32Oy+v97K3vIG81HjyUuO6HQC0uaiW7z29ncJDNdzzyZP54PxcoiMj8AcUgR4nztpVWs/b+ypp9Qd4c28V7buV17ewr6IBry/A5IwE7vrEySyclMKDbx3kifePsqPEg89/7HWPi46gza+0BZy09IRo7rjmJJYWpJEcF025x8vh6iZS46NJTYimqKaZco+X13ZXsr+igSmZCUzJTGTVnOxOk5sZY8avUdtPP3PqPE37xO343YAo4gy5Dw6aALdePI/PnjWdI9VNvLO/ipioCHaW1nP/mwc6Fp0GmJ6ViAItPj/LpmaQGh/F3zYcJSkuis+dNZ3PnnX85Fqh8ge026acljY/e8oaiImKICpCmJyRgF+VoppmBMhJibMBRMaYARm1QX/58uW69vW3Ka/30uoP8Py2Mnz+AMlxUSyYmEp0pHDva/t5d38VV5yczyPrDhN8SR9ZMpErl+VTWd9CUU0zW47WERMlRIjw7oFqvK1+TpmWwY+uWNTnJQCNMSbcjerBWakJ0R2jSLtrvpiWlcild77JI+sOc/UpBXz6jGmICHHREZ0m6zLGmPFuVAT93uSlxvPGf5+LP6A28tQYY05gTAR9wJamM8aYPrBIaYwx44gFfWOMGUcs6BtjzDhiQd8YY8YRC/rGGDOOWNA3xphxxIK+McaMI2E/DYOI1AO7gCygEkgF6nrYvadtoRzTnt9gnKu3Y6K7yWswr6W79N5ez8G8zp6uMZRz9fWYrn+/UMrcn/yzAF8/jxlI/v15zwwkn+5ez+F4z3TNc6jy6SmPUM7V12P68loORv5zVDX5uD1UNax/gMIuv+87wb7dbgvxmMJBPNcJj+kur0G+luPSe3s9B/M6e7rGocy/a36hlLk/+QOFg/2aDdZ7ZjCuMzi/4XjPdPc3HIp8espjKK+zL6/lYP/Ngn9GY/PO0yFsC+WYkc5/OM41XMeMdP6hHDPe8w/lmMHOv7/nGq58wvk16/U6R0PzTqGqLm//Pdz5jrW8RipPy8/yC8c8x+p1nSif0VDTv6/L7+HOd6zlNVJ5Wn6WXzjmOVavq8d8wr6mb4wxZvCMhpq+McaYQWJB3xhjxpERD/oioiLyx6DnUSJSISL/GKb8G4Yjn/7kKSKvisiAbvSIyOXuazt3IOfpZ57fEpFtIrJZRDaKyMohzi9fRJ4UkT0isk9EfiUiMSfY/2YRCWkpNfe1vD3o+VdF5LZQztWHvPzu67dNRDaJyFdEZFj+V4fz/yHoOtt/pp5g35D+J0YqvozE/19fjXjQBxqBhSIS7z4/Hzg6guUZK64B3gCuHo7MROQ04BLgZFVdDHwQODKE+QnwBPB3VZ0FzAaSgDUnOOxmINT1M1uAK0QkK8Tj+6NZVZeq6gKc/4eLgO8OQ77Drf06238ODkEeA44vIhLKYlMh/f+JyJAv/RcOQR/gWeBi9/E1wMPtG0RkhYi8JSLvu7/nuOn/EpGlQfu9KSKLQ8lcRFYFf/KLyJ0icr37+KCI/I+IbBCRLYP1yX2iPAfh3EnAGcBncN90vVzjRSKyU0TeEJE7QqwF5QGVqtoCoKqVqlosIstE5DURWS8iz4tInpvnqyLyS/dvulVEVvQzv3MBr6re7+bnB/4L+LSIJIrIz9y/12YR+ZKIfBmYCLwiIq+EcH1tOL0h/qvrBhGZIiJr3bzWishkEUl13zsR7j4JInJERKL7k6mqlgM3AF8UR6SI/FRE1rn5fT6oHP/PveZNIvLjEK6x/TxJ7nW0v+cvddOnisgOEfmt+y3khaBgOih6er+4/i3E90so8eV6EXlMRJ4GXujnNfT0//e6iPxNRLaLyL1B740GEfmeiLwLnNafvEIRLkH/EeBqEYkDFgPvBm3bCZytqicB3wF+6Kb/DrgeQERmA7GqunmIylepqicD9wBfHaI8BtNlwHOquhuoFpGTe9rRfc1/A3xIVc8EskPM8wWgQER2i8jdIvIBN8D9Gvioqi4D/kDnmniiqp4OfMHd1h8LgPXBCarqAQ4DnwWmASe53zr+rKp3AMXAOap6TgjXB3AX8EkRSe2SfifwUHtewB2qWgdsAj7g7vNh4HlV9fU3U1Xdj/O/moMTSOpU9RTgFOBzIjJNRD6E83dfqapLgJ/0++qO8QKXu+/5c4DbRUTcbbOAu9xvIbXAlQPIJ16ONe38bQjfL6HEF3AC8HWqem4/r+syuv//WwHcAiwCZgBXuOmJwFZVXamqb/Qzr34LizVyVXWzOO151wDPdNmcCjwoIrMAxZlzBOAx4Nsi8jXg08ADQ1jEJ9zf6zn2hwpn1wC/dB8/4j7/Zw/7zgX2q+oB9/nDODXLflHVBhFZBpyFEyj+CvwAWAi86MaMSKAk6LCH3WNfF5EUEUlT1do+Zik474fu0s8G7lXVNvf81f29nu6oqkdEHgK+DDQHbTqNY++LP3Is4P4V+DjwCk6N7+4BZN8edC8AFovIR93nqTiB+IPA/ara5JZ1INcswA9F5GwgAEwCct1tB1R1o/t4PTB1APk0q+rSjkxFFjIE75cQ4wvAiyG+jj39/73nfoAjIg8DZwL/B/iBx0PIJyRhEfRdTwE/A1YBmUHp3wdeUdXL3T/cqwCq2iQiLwKXAh8DBnLjs43O33riumxvcX/7GbzXrLc8QyIimThNHwtFRHH+cRTn9e0uP2GQuE0srwKvisgW4CZgm6r29JW1a9Duz6CRbXSpZYpIClAA7O/nufrjl8AG4P4T7NOe91PAj0QkA1gGvBxKhiIyHee9V47z9/qSqj7fZZ8LGbxr/iTON75lquoTkYMce7+0BO3nBwazeUcYuvdLv+KLq7Ef5wdO+P/3TDflbX/udf93hkW4NO+A83Xte6q6pUt6KsduvFzfZdvvgDuAdQOs2RwC5otIrPvV/bwBnGuk8/woTlPDFFWdqqoFQHstvrv8dgLT5VjPiY+HkqmIzHFrS+2WAjuAbHFu8iIi0SKyIGifj7vpZ+I0WfQ0c2B31gIJInKte45I4Hacb3wvAP8h7g04N+gC1APHzzrYD+777FGcZpZ2b3Hsht0ncW7goaoNwHvAr4B/hPKPLSLZwL3AneqMpHweuLH93oCIzBaRRJxr/rS4vZOCrjkUqUC5G/DPAaYM4Fz9sYuhe7+EEl9C0dP/35nACrcpLgLnWoa8Kac7YVPTV9UinH+Orn6C8/XrK3SpKanqehHxcOJaV4/coNCiqkdE5FFgM7AHeD+U84VJntcAXW/iPQ58AidYdcpPVZtF5AvAcyJSiROkQpEE/FpE0nC+xezFaSa6D7jD/aCJwqkpb3OPqRGRt4AUnCa6PlNVFZHLgbtF5Ns4FZhngG/i1EBnA5tFxAf8Fqfd/T7gWREpGUC7PjgfLl8Mev5l4A9uU2MF8O9B2/6K0xS5qh/njxeRjThNDW04TUY/d7f9DqdJZYPbzl4BXKaqz4nTsaFQRFo59lr0Wft7E+e+xNMiUghsxKkYDDlVbXWbrYbi/dLv+BKinv7/bgTedrctAl4H/jYI+fXbqJ6GQUQm4nwdm6uqgRCOXwL8VlX723MkZCORZ29EJMltkxecm5V7VPUXQ5znq8BXVbVwKPMxfReO782xQkRW4bzfLxnhooRV806/uF/r3wW+FWLA/w+cG0O3DnbZwinPPvqcW7PchvN19zcjWxwz3ML4vWkG2aiu6RtjjOmfUVvTN8aETkQKROQVcQZbbROR/3TTM0TkRXGmtnhRRNLd9PPFGTC1xf19btC51ogz8GzYpzQx/Wc1fWPGIXFGuuap6gYRScbpc38ZTg+WalX9sYh8HUhX1f8WkZOAMneU9UKcgWaT3HOditMbbY+qJo3E9Zi+s6BvjEFEnsTp4XQnsEpVS9wPhldVdU6XfQVnYe+J7dNuuOkNFvTDnzXvGDPOuWM0TsLpGJGrqiUA7u+cbg65Eng/OOCb0SNs+ukbY4afOJODPQ7c7E4z0dv+C4D/xZkOwoxCVtM3ZpxyR/U+jjMhXfv8UmVybCbUPJypH9r3z8cZUHStqu4b7vKawWFB35hxyG2X/z2wQ1V/HrTpKeA69/F1wJPu/mk4k4Z9Q1XfHMaimkFmN3KNGYfc+Wv+BWzBmUkTnGkb3sWZrmMyzjTVV6lqtYjcCnwDZwqPdheoarmI/ARnmo+JONNX/05VbxuWCzH9ZkHfGGPGEWveMcaYccSCvjHGjCMW9I0xZhyxoG+MMeOIBX1jjBlHLOgbE0RE/CKy0Z15cpOIfMVd3u5Ex0wVkU8MVxmNGQgL+sZ01qyqS1V1AXA+cBHw3V6OmYrTT92YsGf99I0J0nWmSBGZDqwDsnAWCP8jkOhu/qKqviUi7wDzcBbAfhC4A2ct1FVALHCXqtpqZCYsWNA3Jkh30wOLSA0wF6gHAqrqFZFZwMOqurzr+qcicgOQo6o/EJFY4E2cka0HhvNajOmOzbJpTO/ap56MBu4UkaWAH5jdw/4XAItF5KPu81RgFs43AWNGlAV9Y07Abd7x48w2+V2gDFiCcz/M29NhwJdU9flhKaQx/WA3co3pgYhkA/cCd6rTDpoKlKhqAPgUEOnuWg8kBx36PHCjO3UxIjJbRBIxJgxYTd+YzuJFZCNOU04bzo3b9qmH7wYeF5GrgFeARjd9M9AmIpuAB4Bf4fTo2eBOYVyBs/6sMSPObuQaY8w4Ys07xhgzjljQN8aYccSCvjHGjCMW9I0xZhyxoG+MMeOIBX1jjBlHLOgbY8w4YkHfGGPGkf8PyjDUI/skpjwAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "highs.plot()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>2020-05-03</th>\n",
       "      <td>210.571643</td>\n",
       "      <td>219.746152</td>\n",
       "      <td>206.782672</td>\n",
       "      <td>213.009582</td>\n",
       "      <td>213.009582</td>\n",
       "      <td>2.280659e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-10</th>\n",
       "      <td>209.455810</td>\n",
       "      <td>213.164729</td>\n",
       "      <td>201.401142</td>\n",
       "      <td>206.354983</td>\n",
       "      <td>206.354983</td>\n",
       "      <td>2.145038e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-17</th>\n",
       "      <td>194.564684</td>\n",
       "      <td>200.396733</td>\n",
       "      <td>191.539531</td>\n",
       "      <td>197.260886</td>\n",
       "      <td>197.260886</td>\n",
       "      <td>1.723019e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-24</th>\n",
       "      <td>208.729682</td>\n",
       "      <td>212.346926</td>\n",
       "      <td>203.468543</td>\n",
       "      <td>208.027206</td>\n",
       "      <td>208.027206</td>\n",
       "      <td>1.319095e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-31</th>\n",
       "      <td>214.430614</td>\n",
       "      <td>221.922745</td>\n",
       "      <td>210.856415</td>\n",
       "      <td>218.560335</td>\n",
       "      <td>218.560335</td>\n",
       "      <td>1.184949e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-07</th>\n",
       "      <td>240.949711</td>\n",
       "      <td>247.044625</td>\n",
       "      <td>236.096420</td>\n",
       "      <td>243.019584</td>\n",
       "      <td>243.019584</td>\n",
       "      <td>1.067425e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-14</th>\n",
       "      <td>241.694637</td>\n",
       "      <td>244.453620</td>\n",
       "      <td>236.448057</td>\n",
       "      <td>240.126532</td>\n",
       "      <td>240.126532</td>\n",
       "      <td>8.731830e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-21</th>\n",
       "      <td>231.337021</td>\n",
       "      <td>233.874132</td>\n",
       "      <td>227.127112</td>\n",
       "      <td>230.696699</td>\n",
       "      <td>230.696699</td>\n",
       "      <td>7.388079e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-28</th>\n",
       "      <td>233.836090</td>\n",
       "      <td>238.313642</td>\n",
       "      <td>228.727931</td>\n",
       "      <td>233.338185</td>\n",
       "      <td>233.338185</td>\n",
       "      <td>7.405910e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-05</th>\n",
       "      <td>227.762427</td>\n",
       "      <td>230.581885</td>\n",
       "      <td>224.565665</td>\n",
       "      <td>228.163038</td>\n",
       "      <td>228.163038</td>\n",
       "      <td>5.875103e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-12</th>\n",
       "      <td>239.705473</td>\n",
       "      <td>244.019645</td>\n",
       "      <td>236.053885</td>\n",
       "      <td>241.835227</td>\n",
       "      <td>241.835227</td>\n",
       "      <td>7.580990e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-19</th>\n",
       "      <td>237.536774</td>\n",
       "      <td>239.548998</td>\n",
       "      <td>234.637216</td>\n",
       "      <td>236.946413</td>\n",
       "      <td>236.946413</td>\n",
       "      <td>6.382175e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-26</th>\n",
       "      <td>262.809245</td>\n",
       "      <td>276.521598</td>\n",
       "      <td>260.371288</td>\n",
       "      <td>272.995056</td>\n",
       "      <td>272.995056</td>\n",
       "      <td>8.949403e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-02</th>\n",
       "      <td>333.167175</td>\n",
       "      <td>352.615256</td>\n",
       "      <td>325.187426</td>\n",
       "      <td>341.767853</td>\n",
       "      <td>341.767853</td>\n",
       "      <td>1.367050e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-09</th>\n",
       "      <td>388.381239</td>\n",
       "      <td>399.853389</td>\n",
       "      <td>380.322296</td>\n",
       "      <td>391.049120</td>\n",
       "      <td>391.049120</td>\n",
       "      <td>1.180661e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-16</th>\n",
       "      <td>408.204141</td>\n",
       "      <td>420.667140</td>\n",
       "      <td>396.834760</td>\n",
       "      <td>414.368138</td>\n",
       "      <td>414.368138</td>\n",
       "      <td>1.357380e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-23</th>\n",
       "      <td>413.554796</td>\n",
       "      <td>418.952763</td>\n",
       "      <td>399.760197</td>\n",
       "      <td>407.492872</td>\n",
       "      <td>407.492872</td>\n",
       "      <td>1.120535e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-30</th>\n",
       "      <td>392.610265</td>\n",
       "      <td>405.310987</td>\n",
       "      <td>384.451704</td>\n",
       "      <td>397.919407</td>\n",
       "      <td>397.919407</td>\n",
       "      <td>1.032754e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-06</th>\n",
       "      <td>412.667986</td>\n",
       "      <td>430.283391</td>\n",
       "      <td>380.698861</td>\n",
       "      <td>402.101083</td>\n",
       "      <td>402.101083</td>\n",
       "      <td>2.074615e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-13</th>\n",
       "      <td>360.877136</td>\n",
       "      <td>371.923070</td>\n",
       "      <td>345.158979</td>\n",
       "      <td>362.419460</td>\n",
       "      <td>362.419460</td>\n",
       "      <td>2.018881e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-20</th>\n",
       "      <td>376.062932</td>\n",
       "      <td>385.320147</td>\n",
       "      <td>366.491124</td>\n",
       "      <td>376.843044</td>\n",
       "      <td>376.843044</td>\n",
       "      <td>1.530493e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-27</th>\n",
       "      <td>347.835196</td>\n",
       "      <td>356.486760</td>\n",
       "      <td>335.087058</td>\n",
       "      <td>345.811467</td>\n",
       "      <td>345.811467</td>\n",
       "      <td>1.291341e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-04</th>\n",
       "      <td>354.175463</td>\n",
       "      <td>359.733935</td>\n",
       "      <td>347.871312</td>\n",
       "      <td>353.591962</td>\n",
       "      <td>353.591962</td>\n",
       "      <td>1.076824e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-11</th>\n",
       "      <td>354.450190</td>\n",
       "      <td>360.271256</td>\n",
       "      <td>349.321772</td>\n",
       "      <td>355.830556</td>\n",
       "      <td>355.830556</td>\n",
       "      <td>1.161379e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-18</th>\n",
       "      <td>374.755090</td>\n",
       "      <td>379.378448</td>\n",
       "      <td>368.148944</td>\n",
       "      <td>374.044897</td>\n",
       "      <td>374.044897</td>\n",
       "      <td>1.311041e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-25</th>\n",
       "      <td>393.573369</td>\n",
       "      <td>405.366629</td>\n",
       "      <td>388.227430</td>\n",
       "      <td>397.639648</td>\n",
       "      <td>397.639648</td>\n",
       "      <td>1.427360e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-01</th>\n",
       "      <td>392.699280</td>\n",
       "      <td>400.690879</td>\n",
       "      <td>382.625663</td>\n",
       "      <td>391.290671</td>\n",
       "      <td>391.290671</td>\n",
       "      <td>1.324760e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-08</th>\n",
       "      <td>410.538038</td>\n",
       "      <td>428.229183</td>\n",
       "      <td>400.285178</td>\n",
       "      <td>418.707925</td>\n",
       "      <td>418.707925</td>\n",
       "      <td>1.486526e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-15</th>\n",
       "      <td>458.023080</td>\n",
       "      <td>466.248204</td>\n",
       "      <td>446.700003</td>\n",
       "      <td>457.163408</td>\n",
       "      <td>457.163408</td>\n",
       "      <td>1.236566e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-22</th>\n",
       "      <td>486.093741</td>\n",
       "      <td>508.770735</td>\n",
       "      <td>475.457127</td>\n",
       "      <td>501.244886</td>\n",
       "      <td>501.244886</td>\n",
       "      <td>1.682036e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-29</th>\n",
       "      <td>559.424177</td>\n",
       "      <td>581.045872</td>\n",
       "      <td>532.517805</td>\n",
       "      <td>561.903024</td>\n",
       "      <td>561.903024</td>\n",
       "      <td>2.119506e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-06</th>\n",
       "      <td>594.169617</td>\n",
       "      <td>614.178118</td>\n",
       "      <td>575.311576</td>\n",
       "      <td>597.869489</td>\n",
       "      <td>597.869489</td>\n",
       "      <td>1.737312e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-13</th>\n",
       "      <td>570.837498</td>\n",
       "      <td>582.436489</td>\n",
       "      <td>552.614798</td>\n",
       "      <td>569.122384</td>\n",
       "      <td>569.122384</td>\n",
       "      <td>1.162166e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-20</th>\n",
       "      <td>622.580479</td>\n",
       "      <td>641.229667</td>\n",
       "      <td>610.360352</td>\n",
       "      <td>629.545463</td>\n",
       "      <td>629.545463</td>\n",
       "      <td>1.438747e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-27</th>\n",
       "      <td>620.090812</td>\n",
       "      <td>646.862505</td>\n",
       "      <td>595.787171</td>\n",
       "      <td>626.411813</td>\n",
       "      <td>626.411813</td>\n",
       "      <td>1.615997e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03</th>\n",
       "      <td>734.183838</td>\n",
       "      <td>790.714085</td>\n",
       "      <td>718.902771</td>\n",
       "      <td>775.964295</td>\n",
       "      <td>775.964295</td>\n",
       "      <td>2.182113e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-10</th>\n",
       "      <td>1151.174351</td>\n",
       "      <td>1242.884905</td>\n",
       "      <td>1083.408665</td>\n",
       "      <td>1191.507220</td>\n",
       "      <td>1191.507220</td>\n",
       "      <td>4.311925e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-17</th>\n",
       "      <td>1164.413644</td>\n",
       "      <td>1227.938407</td>\n",
       "      <td>1064.004290</td>\n",
       "      <td>1159.759539</td>\n",
       "      <td>1159.759539</td>\n",
       "      <td>3.704261e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-24</th>\n",
       "      <td>1261.578317</td>\n",
       "      <td>1345.589826</td>\n",
       "      <td>1179.482003</td>\n",
       "      <td>1285.361799</td>\n",
       "      <td>1285.361799</td>\n",
       "      <td>3.904575e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-31</th>\n",
       "      <td>1350.305298</td>\n",
       "      <td>1391.979161</td>\n",
       "      <td>1272.724330</td>\n",
       "      <td>1329.483765</td>\n",
       "      <td>1329.483765</td>\n",
       "      <td>3.910728e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-07</th>\n",
       "      <td>1550.070958</td>\n",
       "      <td>1635.970721</td>\n",
       "      <td>1493.515015</td>\n",
       "      <td>1592.947423</td>\n",
       "      <td>1592.947423</td>\n",
       "      <td>4.011296e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-14</th>\n",
       "      <td>1759.167236</td>\n",
       "      <td>1828.700684</td>\n",
       "      <td>1711.873901</td>\n",
       "      <td>1786.488543</td>\n",
       "      <td>1786.488543</td>\n",
       "      <td>3.926203e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-21</th>\n",
       "      <td>1861.516375</td>\n",
       "      <td>1920.287633</td>\n",
       "      <td>1802.292114</td>\n",
       "      <td>1880.295131</td>\n",
       "      <td>1880.295131</td>\n",
       "      <td>3.171825e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-28</th>\n",
       "      <td>1614.182931</td>\n",
       "      <td>1664.489066</td>\n",
       "      <td>1439.683402</td>\n",
       "      <td>1539.504586</td>\n",
       "      <td>1539.504586</td>\n",
       "      <td>3.286647e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-07</th>\n",
       "      <td>1539.513794</td>\n",
       "      <td>1626.646868</td>\n",
       "      <td>1496.763951</td>\n",
       "      <td>1583.750610</td>\n",
       "      <td>1583.750610</td>\n",
       "      <td>2.282296e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-14</th>\n",
       "      <td>1821.211025</td>\n",
       "      <td>1875.540806</td>\n",
       "      <td>1754.865252</td>\n",
       "      <td>1839.927159</td>\n",
       "      <td>1839.927159</td>\n",
       "      <td>2.386495e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-21</th>\n",
       "      <td>1812.773298</td>\n",
       "      <td>1847.711426</td>\n",
       "      <td>1749.556693</td>\n",
       "      <td>1803.350621</td>\n",
       "      <td>1803.350621</td>\n",
       "      <td>2.353634e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-28</th>\n",
       "      <td>1680.715960</td>\n",
       "      <td>1723.964007</td>\n",
       "      <td>1629.959228</td>\n",
       "      <td>1667.064209</td>\n",
       "      <td>1667.064209</td>\n",
       "      <td>2.338945e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-04</th>\n",
       "      <td>1917.640712</td>\n",
       "      <td>2006.117623</td>\n",
       "      <td>1882.718942</td>\n",
       "      <td>1975.161203</td>\n",
       "      <td>1975.161203</td>\n",
       "      <td>2.847586e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-11</th>\n",
       "      <td>2083.665196</td>\n",
       "      <td>2140.282017</td>\n",
       "      <td>2033.190726</td>\n",
       "      <td>2093.089303</td>\n",
       "      <td>2093.089303</td>\n",
       "      <td>2.629043e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-18</th>\n",
       "      <td>2332.163400</td>\n",
       "      <td>2417.499756</td>\n",
       "      <td>2229.648716</td>\n",
       "      <td>2343.820103</td>\n",
       "      <td>2343.820103</td>\n",
       "      <td>3.404945e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-25</th>\n",
       "      <td>2295.981829</td>\n",
       "      <td>2413.181745</td>\n",
       "      <td>2164.915353</td>\n",
       "      <td>2307.994001</td>\n",
       "      <td>2307.994001</td>\n",
       "      <td>4.072166e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-02</th>\n",
       "      <td>2564.729431</td>\n",
       "      <td>2691.217834</td>\n",
       "      <td>2508.472779</td>\n",
       "      <td>2679.576111</td>\n",
       "      <td>2679.576111</td>\n",
       "      <td>3.367367e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Open         High          Low        Close    Adj Close  \\\n",
       "Date                                                                          \n",
       "2020-05-03   210.571643   219.746152   206.782672   213.009582   213.009582   \n",
       "2020-05-10   209.455810   213.164729   201.401142   206.354983   206.354983   \n",
       "2020-05-17   194.564684   200.396733   191.539531   197.260886   197.260886   \n",
       "2020-05-24   208.729682   212.346926   203.468543   208.027206   208.027206   \n",
       "2020-05-31   214.430614   221.922745   210.856415   218.560335   218.560335   \n",
       "2020-06-07   240.949711   247.044625   236.096420   243.019584   243.019584   \n",
       "2020-06-14   241.694637   244.453620   236.448057   240.126532   240.126532   \n",
       "2020-06-21   231.337021   233.874132   227.127112   230.696699   230.696699   \n",
       "2020-06-28   233.836090   238.313642   228.727931   233.338185   233.338185   \n",
       "2020-07-05   227.762427   230.581885   224.565665   228.163038   228.163038   \n",
       "2020-07-12   239.705473   244.019645   236.053885   241.835227   241.835227   \n",
       "2020-07-19   237.536774   239.548998   234.637216   236.946413   236.946413   \n",
       "2020-07-26   262.809245   276.521598   260.371288   272.995056   272.995056   \n",
       "2020-08-02   333.167175   352.615256   325.187426   341.767853   341.767853   \n",
       "2020-08-09   388.381239   399.853389   380.322296   391.049120   391.049120   \n",
       "2020-08-16   408.204141   420.667140   396.834760   414.368138   414.368138   \n",
       "2020-08-23   413.554796   418.952763   399.760197   407.492872   407.492872   \n",
       "2020-08-30   392.610265   405.310987   384.451704   397.919407   397.919407   \n",
       "2020-09-06   412.667986   430.283391   380.698861   402.101083   402.101083   \n",
       "2020-09-13   360.877136   371.923070   345.158979   362.419460   362.419460   \n",
       "2020-09-20   376.062932   385.320147   366.491124   376.843044   376.843044   \n",
       "2020-09-27   347.835196   356.486760   335.087058   345.811467   345.811467   \n",
       "2020-10-04   354.175463   359.733935   347.871312   353.591962   353.591962   \n",
       "2020-10-11   354.450190   360.271256   349.321772   355.830556   355.830556   \n",
       "2020-10-18   374.755090   379.378448   368.148944   374.044897   374.044897   \n",
       "2020-10-25   393.573369   405.366629   388.227430   397.639648   397.639648   \n",
       "2020-11-01   392.699280   400.690879   382.625663   391.290671   391.290671   \n",
       "2020-11-08   410.538038   428.229183   400.285178   418.707925   418.707925   \n",
       "2020-11-15   458.023080   466.248204   446.700003   457.163408   457.163408   \n",
       "2020-11-22   486.093741   508.770735   475.457127   501.244886   501.244886   \n",
       "2020-11-29   559.424177   581.045872   532.517805   561.903024   561.903024   \n",
       "2020-12-06   594.169617   614.178118   575.311576   597.869489   597.869489   \n",
       "2020-12-13   570.837498   582.436489   552.614798   569.122384   569.122384   \n",
       "2020-12-20   622.580479   641.229667   610.360352   629.545463   629.545463   \n",
       "2020-12-27   620.090812   646.862505   595.787171   626.411813   626.411813   \n",
       "2021-01-03   734.183838   790.714085   718.902771   775.964295   775.964295   \n",
       "2021-01-10  1151.174351  1242.884905  1083.408665  1191.507220  1191.507220   \n",
       "2021-01-17  1164.413644  1227.938407  1064.004290  1159.759539  1159.759539   \n",
       "2021-01-24  1261.578317  1345.589826  1179.482003  1285.361799  1285.361799   \n",
       "2021-01-31  1350.305298  1391.979161  1272.724330  1329.483765  1329.483765   \n",
       "2021-02-07  1550.070958  1635.970721  1493.515015  1592.947423  1592.947423   \n",
       "2021-02-14  1759.167236  1828.700684  1711.873901  1786.488543  1786.488543   \n",
       "2021-02-21  1861.516375  1920.287633  1802.292114  1880.295131  1880.295131   \n",
       "2021-02-28  1614.182931  1664.489066  1439.683402  1539.504586  1539.504586   \n",
       "2021-03-07  1539.513794  1626.646868  1496.763951  1583.750610  1583.750610   \n",
       "2021-03-14  1821.211025  1875.540806  1754.865252  1839.927159  1839.927159   \n",
       "2021-03-21  1812.773298  1847.711426  1749.556693  1803.350621  1803.350621   \n",
       "2021-03-28  1680.715960  1723.964007  1629.959228  1667.064209  1667.064209   \n",
       "2021-04-04  1917.640712  2006.117623  1882.718942  1975.161203  1975.161203   \n",
       "2021-04-11  2083.665196  2140.282017  2033.190726  2093.089303  2093.089303   \n",
       "2021-04-18  2332.163400  2417.499756  2229.648716  2343.820103  2343.820103   \n",
       "2021-04-25  2295.981829  2413.181745  2164.915353  2307.994001  2307.994001   \n",
       "2021-05-02  2564.729431  2691.217834  2508.472779  2679.576111  2679.576111   \n",
       "\n",
       "                  Volume  \n",
       "Date                      \n",
       "2020-05-03  2.280659e+10  \n",
       "2020-05-10  2.145038e+10  \n",
       "2020-05-17  1.723019e+10  \n",
       "2020-05-24  1.319095e+10  \n",
       "2020-05-31  1.184949e+10  \n",
       "2020-06-07  1.067425e+10  \n",
       "2020-06-14  8.731830e+09  \n",
       "2020-06-21  7.388079e+09  \n",
       "2020-06-28  7.405910e+09  \n",
       "2020-07-05  5.875103e+09  \n",
       "2020-07-12  7.580990e+09  \n",
       "2020-07-19  6.382175e+09  \n",
       "2020-07-26  8.949403e+09  \n",
       "2020-08-02  1.367050e+10  \n",
       "2020-08-09  1.180661e+10  \n",
       "2020-08-16  1.357380e+10  \n",
       "2020-08-23  1.120535e+10  \n",
       "2020-08-30  1.032754e+10  \n",
       "2020-09-06  2.074615e+10  \n",
       "2020-09-13  2.018881e+10  \n",
       "2020-09-20  1.530493e+10  \n",
       "2020-09-27  1.291341e+10  \n",
       "2020-10-04  1.076824e+10  \n",
       "2020-10-11  1.161379e+10  \n",
       "2020-10-18  1.311041e+10  \n",
       "2020-10-25  1.427360e+10  \n",
       "2020-11-01  1.324760e+10  \n",
       "2020-11-08  1.486526e+10  \n",
       "2020-11-15  1.236566e+10  \n",
       "2020-11-22  1.682036e+10  \n",
       "2020-11-29  2.119506e+10  \n",
       "2020-12-06  1.737312e+10  \n",
       "2020-12-13  1.162166e+10  \n",
       "2020-12-20  1.438747e+10  \n",
       "2020-12-27  1.615997e+10  \n",
       "2021-01-03  2.182113e+10  \n",
       "2021-01-10  4.311925e+10  \n",
       "2021-01-17  3.704261e+10  \n",
       "2021-01-24  3.904575e+10  \n",
       "2021-01-31  3.910728e+10  \n",
       "2021-02-07  4.011296e+10  \n",
       "2021-02-14  3.926203e+10  \n",
       "2021-02-21  3.171825e+10  \n",
       "2021-02-28  3.286647e+10  \n",
       "2021-03-07  2.282296e+10  \n",
       "2021-03-14  2.386495e+10  \n",
       "2021-03-21  2.353634e+10  \n",
       "2021-03-28  2.338945e+10  \n",
       "2021-04-04  2.847586e+10  \n",
       "2021-04-11  2.629043e+10  \n",
       "2021-04-18  3.404945e+10  \n",
       "2021-04-25  4.072166e+10  \n",
       "2021-05-02  3.367367e+10  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.resample('W').mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Close</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-05-03</th>\n",
       "      <td>213.009582</td>\n",
       "      <td>227.529694</td>\n",
       "      <td>198.124512</td>\n",
       "      <td>1.140330e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-10</th>\n",
       "      <td>206.354983</td>\n",
       "      <td>216.327682</td>\n",
       "      <td>182.711166</td>\n",
       "      <td>1.501527e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-17</th>\n",
       "      <td>197.260886</td>\n",
       "      <td>209.160934</td>\n",
       "      <td>180.718338</td>\n",
       "      <td>1.206113e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-24</th>\n",
       "      <td>208.027206</td>\n",
       "      <td>215.908463</td>\n",
       "      <td>193.346436</td>\n",
       "      <td>9.233662e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-05-31</th>\n",
       "      <td>218.560335</td>\n",
       "      <td>244.045258</td>\n",
       "      <td>200.264282</td>\n",
       "      <td>8.294641e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-07</th>\n",
       "      <td>243.019584</td>\n",
       "      <td>252.222000</td>\n",
       "      <td>230.488052</td>\n",
       "      <td>7.471973e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-14</th>\n",
       "      <td>240.126532</td>\n",
       "      <td>249.888306</td>\n",
       "      <td>229.645065</td>\n",
       "      <td>6.112281e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-21</th>\n",
       "      <td>230.696699</td>\n",
       "      <td>236.394302</td>\n",
       "      <td>221.241760</td>\n",
       "      <td>5.171655e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-06-28</th>\n",
       "      <td>233.338185</td>\n",
       "      <td>248.508026</td>\n",
       "      <td>219.472672</td>\n",
       "      <td>5.184137e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-05</th>\n",
       "      <td>228.163038</td>\n",
       "      <td>232.756119</td>\n",
       "      <td>222.254990</td>\n",
       "      <td>4.112572e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-12</th>\n",
       "      <td>241.835227</td>\n",
       "      <td>248.308868</td>\n",
       "      <td>227.029526</td>\n",
       "      <td>5.306693e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-19</th>\n",
       "      <td>236.946413</td>\n",
       "      <td>244.310516</td>\n",
       "      <td>231.621170</td>\n",
       "      <td>4.467523e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-07-26</th>\n",
       "      <td>272.995056</td>\n",
       "      <td>316.386322</td>\n",
       "      <td>234.852646</td>\n",
       "      <td>6.264582e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-02</th>\n",
       "      <td>341.767853</td>\n",
       "      <td>411.228302</td>\n",
       "      <td>307.721344</td>\n",
       "      <td>9.569350e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-09</th>\n",
       "      <td>391.049120</td>\n",
       "      <td>406.303955</td>\n",
       "      <td>367.935516</td>\n",
       "      <td>8.264626e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-16</th>\n",
       "      <td>414.368138</td>\n",
       "      <td>444.577759</td>\n",
       "      <td>367.923615</td>\n",
       "      <td>9.501660e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-23</th>\n",
       "      <td>407.492872</td>\n",
       "      <td>442.734985</td>\n",
       "      <td>382.814636</td>\n",
       "      <td>7.843745e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-08-30</th>\n",
       "      <td>397.919407</td>\n",
       "      <td>428.663971</td>\n",
       "      <td>374.355377</td>\n",
       "      <td>7.229275e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-06</th>\n",
       "      <td>402.101083</td>\n",
       "      <td>487.211884</td>\n",
       "      <td>316.774353</td>\n",
       "      <td>1.452230e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-13</th>\n",
       "      <td>362.419460</td>\n",
       "      <td>388.959808</td>\n",
       "      <td>326.254364</td>\n",
       "      <td>1.413217e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-20</th>\n",
       "      <td>376.843044</td>\n",
       "      <td>393.901611</td>\n",
       "      <td>356.682739</td>\n",
       "      <td>1.071345e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-09-27</th>\n",
       "      <td>345.811467</td>\n",
       "      <td>375.737030</td>\n",
       "      <td>317.692078</td>\n",
       "      <td>9.039385e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-04</th>\n",
       "      <td>353.591962</td>\n",
       "      <td>369.286987</td>\n",
       "      <td>337.356934</td>\n",
       "      <td>7.537770e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-11</th>\n",
       "      <td>355.830556</td>\n",
       "      <td>378.267151</td>\n",
       "      <td>335.533600</td>\n",
       "      <td>6.968277e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-18</th>\n",
       "      <td>374.044897</td>\n",
       "      <td>387.296173</td>\n",
       "      <td>362.597412</td>\n",
       "      <td>6.555203e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-10-25</th>\n",
       "      <td>397.639648</td>\n",
       "      <td>420.141663</td>\n",
       "      <td>367.601074</td>\n",
       "      <td>9.991517e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-01</th>\n",
       "      <td>391.290671</td>\n",
       "      <td>411.279877</td>\n",
       "      <td>375.092407</td>\n",
       "      <td>9.273320e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-08</th>\n",
       "      <td>418.707925</td>\n",
       "      <td>465.675476</td>\n",
       "      <td>371.312744</td>\n",
       "      <td>1.040568e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-15</th>\n",
       "      <td>457.163408</td>\n",
       "      <td>475.217255</td>\n",
       "      <td>435.163879</td>\n",
       "      <td>8.655959e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-22</th>\n",
       "      <td>501.244886</td>\n",
       "      <td>579.372498</td>\n",
       "      <td>445.501617</td>\n",
       "      <td>1.177425e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-11-29</th>\n",
       "      <td>561.903024</td>\n",
       "      <td>621.173401</td>\n",
       "      <td>485.497314</td>\n",
       "      <td>1.483654e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-06</th>\n",
       "      <td>597.869489</td>\n",
       "      <td>635.160583</td>\n",
       "      <td>563.106628</td>\n",
       "      <td>1.216118e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-13</th>\n",
       "      <td>569.122384</td>\n",
       "      <td>602.917908</td>\n",
       "      <td>532.998413</td>\n",
       "      <td>8.135165e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-20</th>\n",
       "      <td>629.545463</td>\n",
       "      <td>673.834229</td>\n",
       "      <td>577.118408</td>\n",
       "      <td>1.007123e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-27</th>\n",
       "      <td>626.411813</td>\n",
       "      <td>711.393555</td>\n",
       "      <td>560.364258</td>\n",
       "      <td>1.131198e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03</th>\n",
       "      <td>775.964295</td>\n",
       "      <td>1006.565002</td>\n",
       "      <td>683.205811</td>\n",
       "      <td>1.527479e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-10</th>\n",
       "      <td>1191.507220</td>\n",
       "      <td>1347.926147</td>\n",
       "      <td>912.305359</td>\n",
       "      <td>3.018347e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-17</th>\n",
       "      <td>1159.759539</td>\n",
       "      <td>1290.053589</td>\n",
       "      <td>924.922607</td>\n",
       "      <td>2.592983e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-24</th>\n",
       "      <td>1285.361799</td>\n",
       "      <td>1432.300049</td>\n",
       "      <td>1046.596558</td>\n",
       "      <td>2.733203e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-31</th>\n",
       "      <td>1329.483765</td>\n",
       "      <td>1467.784912</td>\n",
       "      <td>1215.311279</td>\n",
       "      <td>2.737510e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-07</th>\n",
       "      <td>1592.947423</td>\n",
       "      <td>1756.510986</td>\n",
       "      <td>1274.357788</td>\n",
       "      <td>2.807907e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-14</th>\n",
       "      <td>1786.488543</td>\n",
       "      <td>1871.603516</td>\n",
       "      <td>1571.579956</td>\n",
       "      <td>2.748342e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-21</th>\n",
       "      <td>1880.295131</td>\n",
       "      <td>2036.286499</td>\n",
       "      <td>1683.906616</td>\n",
       "      <td>2.220277e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-02-28</th>\n",
       "      <td>1539.504586</td>\n",
       "      <td>1936.453735</td>\n",
       "      <td>1300.472168</td>\n",
       "      <td>2.300653e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-07</th>\n",
       "      <td>1583.750610</td>\n",
       "      <td>1730.924194</td>\n",
       "      <td>1416.416138</td>\n",
       "      <td>1.597608e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-14</th>\n",
       "      <td>1839.927159</td>\n",
       "      <td>1937.645508</td>\n",
       "      <td>1670.942017</td>\n",
       "      <td>1.670546e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-21</th>\n",
       "      <td>1803.350621</td>\n",
       "      <td>1889.196655</td>\n",
       "      <td>1705.716064</td>\n",
       "      <td>1.647544e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-03-28</th>\n",
       "      <td>1667.064209</td>\n",
       "      <td>1811.968262</td>\n",
       "      <td>1560.370483</td>\n",
       "      <td>1.637262e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-04</th>\n",
       "      <td>1975.161203</td>\n",
       "      <td>2152.451904</td>\n",
       "      <td>1683.716553</td>\n",
       "      <td>1.993310e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-11</th>\n",
       "      <td>2093.089303</td>\n",
       "      <td>2196.996338</td>\n",
       "      <td>1945.442139</td>\n",
       "      <td>1.840330e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-18</th>\n",
       "      <td>2343.820103</td>\n",
       "      <td>2547.555664</td>\n",
       "      <td>2011.766846</td>\n",
       "      <td>2.383461e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-04-25</th>\n",
       "      <td>2307.994001</td>\n",
       "      <td>2641.094971</td>\n",
       "      <td>2060.143799</td>\n",
       "      <td>2.850516e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-05-02</th>\n",
       "      <td>2679.576111</td>\n",
       "      <td>2794.663818</td>\n",
       "      <td>2308.315186</td>\n",
       "      <td>1.346947e+11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  Close         High          Low        Volume\n",
       "Date                                                           \n",
       "2020-05-03   213.009582   227.529694   198.124512  1.140330e+11\n",
       "2020-05-10   206.354983   216.327682   182.711166  1.501527e+11\n",
       "2020-05-17   197.260886   209.160934   180.718338  1.206113e+11\n",
       "2020-05-24   208.027206   215.908463   193.346436  9.233662e+10\n",
       "2020-05-31   218.560335   244.045258   200.264282  8.294641e+10\n",
       "2020-06-07   243.019584   252.222000   230.488052  7.471973e+10\n",
       "2020-06-14   240.126532   249.888306   229.645065  6.112281e+10\n",
       "2020-06-21   230.696699   236.394302   221.241760  5.171655e+10\n",
       "2020-06-28   233.338185   248.508026   219.472672  5.184137e+10\n",
       "2020-07-05   228.163038   232.756119   222.254990  4.112572e+10\n",
       "2020-07-12   241.835227   248.308868   227.029526  5.306693e+10\n",
       "2020-07-19   236.946413   244.310516   231.621170  4.467523e+10\n",
       "2020-07-26   272.995056   316.386322   234.852646  6.264582e+10\n",
       "2020-08-02   341.767853   411.228302   307.721344  9.569350e+10\n",
       "2020-08-09   391.049120   406.303955   367.935516  8.264626e+10\n",
       "2020-08-16   414.368138   444.577759   367.923615  9.501660e+10\n",
       "2020-08-23   407.492872   442.734985   382.814636  7.843745e+10\n",
       "2020-08-30   397.919407   428.663971   374.355377  7.229275e+10\n",
       "2020-09-06   402.101083   487.211884   316.774353  1.452230e+11\n",
       "2020-09-13   362.419460   388.959808   326.254364  1.413217e+11\n",
       "2020-09-20   376.843044   393.901611   356.682739  1.071345e+11\n",
       "2020-09-27   345.811467   375.737030   317.692078  9.039385e+10\n",
       "2020-10-04   353.591962   369.286987   337.356934  7.537770e+10\n",
       "2020-10-11   355.830556   378.267151   335.533600  6.968277e+10\n",
       "2020-10-18   374.044897   387.296173   362.597412  6.555203e+10\n",
       "2020-10-25   397.639648   420.141663   367.601074  9.991517e+10\n",
       "2020-11-01   391.290671   411.279877   375.092407  9.273320e+10\n",
       "2020-11-08   418.707925   465.675476   371.312744  1.040568e+11\n",
       "2020-11-15   457.163408   475.217255   435.163879  8.655959e+10\n",
       "2020-11-22   501.244886   579.372498   445.501617  1.177425e+11\n",
       "2020-11-29   561.903024   621.173401   485.497314  1.483654e+11\n",
       "2020-12-06   597.869489   635.160583   563.106628  1.216118e+11\n",
       "2020-12-13   569.122384   602.917908   532.998413  8.135165e+10\n",
       "2020-12-20   629.545463   673.834229   577.118408  1.007123e+11\n",
       "2020-12-27   626.411813   711.393555   560.364258  1.131198e+11\n",
       "2021-01-03   775.964295  1006.565002   683.205811  1.527479e+11\n",
       "2021-01-10  1191.507220  1347.926147   912.305359  3.018347e+11\n",
       "2021-01-17  1159.759539  1290.053589   924.922607  2.592983e+11\n",
       "2021-01-24  1285.361799  1432.300049  1046.596558  2.733203e+11\n",
       "2021-01-31  1329.483765  1467.784912  1215.311279  2.737510e+11\n",
       "2021-02-07  1592.947423  1756.510986  1274.357788  2.807907e+11\n",
       "2021-02-14  1786.488543  1871.603516  1571.579956  2.748342e+11\n",
       "2021-02-21  1880.295131  2036.286499  1683.906616  2.220277e+11\n",
       "2021-02-28  1539.504586  1936.453735  1300.472168  2.300653e+11\n",
       "2021-03-07  1583.750610  1730.924194  1416.416138  1.597608e+11\n",
       "2021-03-14  1839.927159  1937.645508  1670.942017  1.670546e+11\n",
       "2021-03-21  1803.350621  1889.196655  1705.716064  1.647544e+11\n",
       "2021-03-28  1667.064209  1811.968262  1560.370483  1.637262e+11\n",
       "2021-04-04  1975.161203  2152.451904  1683.716553  1.993310e+11\n",
       "2021-04-11  2093.089303  2196.996338  1945.442139  1.840330e+11\n",
       "2021-04-18  2343.820103  2547.555664  2011.766846  2.383461e+11\n",
       "2021-04-25  2307.994001  2641.094971  2060.143799  2.850516e+11\n",
       "2021-05-02  2679.576111  2794.663818  2308.315186  1.346947e+11"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.resample('W').agg({'Close': 'mean', 'High': 'max', 'Low': 'min', 'Volume': 'sum'})"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}