2day_hyundaiHI.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ba3a1fbd-362a-4555-88b1-c84fcf28ffd8",
   "metadata": {},
   "outputs": [],
   "source": [
    "import yfinance as yf\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from pandas_datareader import data\n",
    "\n",
    "yf.pdr_override()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "a04e2b2e-c7cd-4112-b2b7-a55a790eeee0",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  1 of 1 completed\n"
     ]
    }
   ],
   "source": [
    "df = data.get_data_yahoo('329180.KS', start='2021-01-01', end='2022-01-01')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "9ac20bdf-dd8b-4e71-9bef-ded035d22910",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "DatetimeIndex: 70 entries, 2021-09-17 to 2021-12-30\n",
      "Data columns (total 6 columns):\n",
      " #   Column     Non-Null Count  Dtype  \n",
      "---  ------     --------------  -----  \n",
      " 0   Open       70 non-null     float64\n",
      " 1   High       70 non-null     float64\n",
      " 2   Low        70 non-null     float64\n",
      " 3   Close      70 non-null     float64\n",
      " 4   Adj Close  70 non-null     float64\n",
      " 5   Volume     70 non-null     int64  \n",
      "dtypes: float64(5), int64(1)\n",
      "memory usage: 3.8 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c2d91543-15fa-4e9e-b121-238e530236e3",
   "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",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>70.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>70.000000</td>\n",
       "      <td>7.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>105972.857143</td>\n",
       "      <td>108492.857143</td>\n",
       "      <td>103397.142857</td>\n",
       "      <td>105782.857143</td>\n",
       "      <td>105782.857143</td>\n",
       "      <td>6.950395e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>7360.803387</td>\n",
       "      <td>8345.671818</td>\n",
       "      <td>6844.080727</td>\n",
       "      <td>7375.084798</td>\n",
       "      <td>7375.084798</td>\n",
       "      <td>2.083669e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>90000.000000</td>\n",
       "      <td>92800.000000</td>\n",
       "      <td>89700.000000</td>\n",
       "      <td>91500.000000</td>\n",
       "      <td>91500.000000</td>\n",
       "      <td>1.222110e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>100625.000000</td>\n",
       "      <td>103000.000000</td>\n",
       "      <td>99200.000000</td>\n",
       "      <td>100625.000000</td>\n",
       "      <td>100625.000000</td>\n",
       "      <td>1.851488e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>107250.000000</td>\n",
       "      <td>109750.000000</td>\n",
       "      <td>105500.000000</td>\n",
       "      <td>107500.000000</td>\n",
       "      <td>107500.000000</td>\n",
       "      <td>2.755110e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>111875.000000</td>\n",
       "      <td>114000.000000</td>\n",
       "      <td>108500.000000</td>\n",
       "      <td>111875.000000</td>\n",
       "      <td>111875.000000</td>\n",
       "      <td>4.590720e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>118500.000000</td>\n",
       "      <td>135000.000000</td>\n",
       "      <td>113500.000000</td>\n",
       "      <td>118500.000000</td>\n",
       "      <td>118500.000000</td>\n",
       "      <td>1.737353e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open           High            Low          Close  \\\n",
       "count      70.000000      70.000000      70.000000      70.000000   \n",
       "mean   105972.857143  108492.857143  103397.142857  105782.857143   \n",
       "std      7360.803387    8345.671818    6844.080727    7375.084798   \n",
       "min     90000.000000   92800.000000   89700.000000   91500.000000   \n",
       "25%    100625.000000  103000.000000   99200.000000  100625.000000   \n",
       "50%    107250.000000  109750.000000  105500.000000  107500.000000   \n",
       "75%    111875.000000  114000.000000  108500.000000  111875.000000   \n",
       "max    118500.000000  135000.000000  113500.000000  118500.000000   \n",
       "\n",
       "           Adj Close        Volume  \n",
       "count      70.000000  7.000000e+01  \n",
       "mean   105782.857143  6.950395e+05  \n",
       "std      7375.084798  2.083669e+06  \n",
       "min     91500.000000  1.222110e+05  \n",
       "25%    100625.000000  1.851488e+05  \n",
       "50%    107500.000000  2.755110e+05  \n",
       "75%    111875.000000  4.590720e+05  \n",
       "max    118500.000000  1.737353e+07  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "af4946ff-bf52-45f6-be63-0d8f35667520",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "118500.0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max(df['Close'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b89034c3-f688-4439-a0a5-4022ca798e0b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "91500.0"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min(df['Close'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a4207e21-ea89-4fea-8377-3e18d378db3f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "105782.85714285714"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.mean(df['Close'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "2368145a-4329-4bf2-a9d2-00d78461b39e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(70, 6)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "1e802d1b-e0a5-4565-959c-f363ccd8f397",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2021-09-17    111500.0\n",
       "2021-09-23     99100.0\n",
       "2021-09-24     99200.0\n",
       "2021-09-27     97000.0\n",
       "2021-09-28    100000.0\n",
       "                ...   \n",
       "2021-12-24     92700.0\n",
       "2021-12-27     92700.0\n",
       "2021-12-28     92700.0\n",
       "2021-12-29     93700.0\n",
       "2021-12-30     95200.0\n",
       "Name: Close, Length: 70, dtype: float64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Close']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "53748a5f-d03f-4753-9943-265b25e119d4",
   "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>High</th>\n",
       "      <th>Low</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-09-17</th>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-23</th>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-24</th>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-27</th>\n",
       "      <td>99400.0</td>\n",
       "      <td>96500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-28</th>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-24</th>\n",
       "      <td>93600.0</td>\n",
       "      <td>92200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-27</th>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-28</th>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-29</th>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-30</th>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                High      Low\n",
       "Date                         \n",
       "2021-09-17  135000.0  91000.0\n",
       "2021-09-23  113000.0  99000.0\n",
       "2021-09-24  102000.0  95500.0\n",
       "2021-09-27   99400.0  96500.0\n",
       "2021-09-28  103000.0  97000.0\n",
       "...              ...      ...\n",
       "2021-12-24   93600.0  92200.0\n",
       "2021-12-27   93200.0  92300.0\n",
       "2021-12-28   93500.0  92400.0\n",
       "2021-12-29   95000.0  92800.0\n",
       "2021-12-30   95300.0  92900.0\n",
       "\n",
       "[70 rows x 2 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[['High', 'Low']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "a0de3fa9-16c5-4f91-983c-ded4c8d3db57",
   "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>2021-09-17</th>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-23</th>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-24</th>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High      Low     Close  Adj Close    Volume\n",
       "Date                                                                  \n",
       "2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529\n",
       "2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293\n",
       "2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3c6bef76-c3cd-4908-8528-1da9650a5505",
   "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>2021-09-17</th>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-23</th>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-24</th>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High      Low     Close  Adj Close    Volume\n",
       "Date                                                                  \n",
       "2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529\n",
       "2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293\n",
       "2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[:3]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "17ef4558-573a-45e8-9b01-62ab3f12e37a",
   "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>2021-09-17</th>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-28</th>\n",
       "      <td>98000.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1037427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-29</th>\n",
       "      <td>98300.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>98000.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>1435139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>107500.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>1704373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-07</th>\n",
       "      <td>109000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>474072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-13</th>\n",
       "      <td>101500.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>99800.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>252749</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-15</th>\n",
       "      <td>104500.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>103500.0</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>292470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-25</th>\n",
       "      <td>100500.0</td>\n",
       "      <td>106500.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>516573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-26</th>\n",
       "      <td>106500.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>104000.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>388727</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-27</th>\n",
       "      <td>108500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>771405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-29</th>\n",
       "      <td>113500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>693739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-01</th>\n",
       "      <td>116500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>385442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-03</th>\n",
       "      <td>116000.0</td>\n",
       "      <td>117500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>281713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-05</th>\n",
       "      <td>112000.0</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>330870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-10</th>\n",
       "      <td>109000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>255794</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-11</th>\n",
       "      <td>110000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>164295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-15</th>\n",
       "      <td>112500.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>180931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-19</th>\n",
       "      <td>106000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>105500.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>122211</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-22</th>\n",
       "      <td>108500.0</td>\n",
       "      <td>110500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>137867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-23</th>\n",
       "      <td>110000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>147284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-24</th>\n",
       "      <td>111000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>123175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-25</th>\n",
       "      <td>113500.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>248249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-29</th>\n",
       "      <td>107000.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>177072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-01</th>\n",
       "      <td>106000.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>103500.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>142292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-02</th>\n",
       "      <td>106000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>213861</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-06</th>\n",
       "      <td>109500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>162493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-10</th>\n",
       "      <td>106500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>105500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>224135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-17</th>\n",
       "      <td>90000.0</td>\n",
       "      <td>93400.0</td>\n",
       "      <td>89700.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>1686560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-21</th>\n",
       "      <td>92200.0</td>\n",
       "      <td>94900.0</td>\n",
       "      <td>91300.0</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>411144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-29</th>\n",
       "      <td>93500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>258296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-30</th>\n",
       "      <td>94400.0</td>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>232685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High       Low     Close  Adj Close    Volume\n",
       "Date                                                                   \n",
       "2021-09-17  111000.0  135000.0   91000.0  111500.0   111500.0  17373529\n",
       "2021-09-28   98000.0  103000.0   97000.0  100000.0   100000.0   1037427\n",
       "2021-09-29   98300.0  108000.0   98000.0  107500.0   107500.0   1435139\n",
       "2021-09-30  107500.0  117000.0  106000.0  115500.0   115500.0   1704373\n",
       "2021-10-07  109000.0  112000.0  107000.0  109500.0   109500.0    474072\n",
       "2021-10-13  101500.0  103000.0   99800.0  102000.0   102000.0    252749\n",
       "2021-10-15  104500.0  107000.0  103500.0  105000.0   105000.0    292470\n",
       "2021-10-25  100500.0  106500.0  100000.0  106000.0   106000.0    516573\n",
       "2021-10-26  106500.0  109500.0  104000.0  108500.0   108500.0    388727\n",
       "2021-10-27  108500.0  116500.0  108000.0  113500.0   113500.0    771405\n",
       "2021-10-29  113500.0  119000.0  113000.0  117000.0   117000.0    693739\n",
       "2021-11-01  116500.0  119000.0  113500.0  118500.0   118500.0    385442\n",
       "2021-11-03  116000.0  117500.0  112500.0  116500.0   116500.0    281713\n",
       "2021-11-05  112000.0  114500.0  108500.0  113500.0   113500.0    330870\n",
       "2021-11-10  109000.0  111500.0  106000.0  111000.0   111000.0    255794\n",
       "2021-11-11  110000.0  112000.0  109500.0  112000.0   112000.0    164295\n",
       "2021-11-15  112500.0  114000.0  111000.0  114000.0   114000.0    180931\n",
       "2021-11-19  106000.0  109500.0  105500.0  109000.0   109000.0    122211\n",
       "2021-11-22  108500.0  110500.0  107500.0  109000.0   109000.0    137867\n",
       "2021-11-23  110000.0  111500.0  108500.0  111000.0   111000.0    147284\n",
       "2021-11-24  111000.0  113500.0  110000.0  112500.0   112500.0    123175\n",
       "2021-11-25  113500.0  116000.0  112000.0  114000.0   114000.0    248249\n",
       "2021-11-29  107000.0  110000.0  107000.0  108500.0   108500.0    177072\n",
       "2021-12-01  106000.0  109000.0  103500.0  108000.0   108000.0    142292\n",
       "2021-12-02  106000.0  114000.0  106000.0  113500.0   113500.0    213861\n",
       "2021-12-06  109500.0  113500.0  108500.0  112500.0   112500.0    162493\n",
       "2021-12-10  106500.0  107500.0  105500.0  107500.0   107500.0    224135\n",
       "2021-12-17   90000.0   93400.0   89700.0   91500.0    91500.0   1686560\n",
       "2021-12-21   92200.0   94900.0   91300.0   94000.0    94000.0    411144\n",
       "2021-12-29   93500.0   95000.0   92800.0   93700.0    93700.0    258296\n",
       "2021-12-30   94400.0   95300.0   92900.0   95200.0    95200.0    232685"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Open'] < df['Close']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "c332f1ad-685f-47a0-bfd0-6e914d03075f",
   "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>2021-11-01</th>\n",
       "      <td>116500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>385442</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High       Low     Close  Adj Close  Volume\n",
       "Date                                                                 \n",
       "2021-11-01  116500.0  119000.0  113500.0  118500.0   118500.0  385442"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Close'] == df['Close'].max()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d6d5448a-d12a-4c3d-8295-4b7243f3f107",
   "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>2021-09-17</th>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-23</th>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-24</th>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-27</th>\n",
       "      <td>98300.0</td>\n",
       "      <td>99400.0</td>\n",
       "      <td>96500.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>672212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-28</th>\n",
       "      <td>98000.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1037427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-24</th>\n",
       "      <td>93000.0</td>\n",
       "      <td>93600.0</td>\n",
       "      <td>92200.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>220253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-27</th>\n",
       "      <td>92700.0</td>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>191739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-28</th>\n",
       "      <td>92800.0</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>217210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-29</th>\n",
       "      <td>93500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>258296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-30</th>\n",
       "      <td>94400.0</td>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>232685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High      Low     Close  Adj Close    Volume\n",
       "Date                                                                  \n",
       "2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529\n",
       "2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293\n",
       "2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592\n",
       "2021-09-27   98300.0   99400.0  96500.0   97000.0    97000.0    672212\n",
       "2021-09-28   98000.0  103000.0  97000.0  100000.0   100000.0   1037427\n",
       "...              ...       ...      ...       ...        ...       ...\n",
       "2021-12-24   93000.0   93600.0  92200.0   92700.0    92700.0    220253\n",
       "2021-12-27   92700.0   93200.0  92300.0   92700.0    92700.0    191739\n",
       "2021-12-28   92800.0   93500.0  92400.0   92700.0    92700.0    217210\n",
       "2021-12-29   93500.0   95000.0  92800.0   93700.0    93700.0    258296\n",
       "2021-12-30   94400.0   95300.0  92900.0   95200.0    95200.0    232685\n",
       "\n",
       "[70 rows x 6 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df[df['Close'] >= 90000]\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "e595316f-7698-48ec-92f6-106478630867",
   "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>2021-09-17</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-09-24</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-09-27</td>\n",
       "      <td>98300.0</td>\n",
       "      <td>99400.0</td>\n",
       "      <td>96500.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>672212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-09-28</td>\n",
       "      <td>98000.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1037427</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>65</th>\n",
       "      <td>2021-12-24</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>93600.0</td>\n",
       "      <td>92200.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>220253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>191739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2021-12-28</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>217210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2021-12-29</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>258296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2021-12-30</td>\n",
       "      <td>94400.0</td>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>232685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date      Open      High      Low     Close  Adj Close    Volume\n",
       "0  2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529\n",
       "1  2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293\n",
       "2  2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592\n",
       "3  2021-09-27   98300.0   99400.0  96500.0   97000.0    97000.0    672212\n",
       "4  2021-09-28   98000.0  103000.0  97000.0  100000.0   100000.0   1037427\n",
       "..        ...       ...       ...      ...       ...        ...       ...\n",
       "65 2021-12-24   93000.0   93600.0  92200.0   92700.0    92700.0    220253\n",
       "66 2021-12-27   92700.0   93200.0  92300.0   92700.0    92700.0    191739\n",
       "67 2021-12-28   92800.0   93500.0  92400.0   92700.0    92700.0    217210\n",
       "68 2021-12-29   93500.0   95000.0  92800.0   93700.0    93700.0    258296\n",
       "69 2021-12-30   94400.0   95300.0  92900.0   95200.0    95200.0    232685\n",
       "\n",
       "[70 rows x 7 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.reset_index(inplace=True)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6b1a8b82-7b60-4eeb-a69c-8f066fee6a47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0    2021-09-17\n",
       "1    2021-09-23\n",
       "2    2021-09-24\n",
       "3    2021-09-27\n",
       "4    2021-09-28\n",
       "        ...    \n",
       "65   2021-12-24\n",
       "66   2021-12-27\n",
       "67   2021-12-28\n",
       "68   2021-12-29\n",
       "69   2021-12-30\n",
       "Name: Date, Length: 70, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1['Date']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b59ea6bc-480b-4349-a0eb-bdf18275e197",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "DatetimeIndex(['2021-09-17', '2021-09-23', '2021-09-24', '2021-09-27',\n",
       "               '2021-09-28', '2021-09-29', '2021-09-30', '2021-10-01',\n",
       "               '2021-10-05', '2021-10-06', '2021-10-07', '2021-10-08',\n",
       "               '2021-10-12', '2021-10-13', '2021-10-14', '2021-10-15',\n",
       "               '2021-10-18', '2021-10-19', '2021-10-20', '2021-10-21',\n",
       "               '2021-10-22', '2021-10-25', '2021-10-26', '2021-10-27',\n",
       "               '2021-10-28', '2021-10-29', '2021-11-01', '2021-11-02',\n",
       "               '2021-11-03', '2021-11-04', '2021-11-05', '2021-11-08',\n",
       "               '2021-11-09', '2021-11-10', '2021-11-11', '2021-11-12',\n",
       "               '2021-11-15', '2021-11-16', '2021-11-17', '2021-11-18',\n",
       "               '2021-11-19', '2021-11-22', '2021-11-23', '2021-11-24',\n",
       "               '2021-11-25', '2021-11-26', '2021-11-29', '2021-11-30',\n",
       "               '2021-12-01', '2021-12-02', '2021-12-03', '2021-12-06',\n",
       "               '2021-12-07', '2021-12-08', '2021-12-09', '2021-12-10',\n",
       "               '2021-12-13', '2021-12-14', '2021-12-15', '2021-12-16',\n",
       "               '2021-12-17', '2021-12-20', '2021-12-21', '2021-12-22',\n",
       "               '2021-12-23', '2021-12-24', '2021-12-27', '2021-12-28',\n",
       "               '2021-12-29', '2021-12-30'],\n",
       "              dtype='datetime64[ns]', name='Date', freq=None)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['Close'] > 90000].index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "b8ef3f2b-2988-4146-aa87-3c8c3508128a",
   "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>2021-09-17</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-09-24</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-09-27</td>\n",
       "      <td>98300.0</td>\n",
       "      <td>99400.0</td>\n",
       "      <td>96500.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>672212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-09-28</td>\n",
       "      <td>98000.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1037427</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>65</th>\n",
       "      <td>2021-12-24</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>93600.0</td>\n",
       "      <td>92200.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>220253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>191739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2021-12-28</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>217210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2021-12-29</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>258296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2021-12-30</td>\n",
       "      <td>94400.0</td>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>232685</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date      Open      High      Low     Close  Adj Close    Volume\n",
       "0  2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529\n",
       "1  2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293\n",
       "2  2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592\n",
       "3  2021-09-27   98300.0   99400.0  96500.0   97000.0    97000.0    672212\n",
       "4  2021-09-28   98000.0  103000.0  97000.0  100000.0   100000.0   1037427\n",
       "..        ...       ...       ...      ...       ...        ...       ...\n",
       "65 2021-12-24   93000.0   93600.0  92200.0   92700.0    92700.0    220253\n",
       "66 2021-12-27   92700.0   93200.0  92300.0   92700.0    92700.0    191739\n",
       "67 2021-12-28   92800.0   93500.0  92400.0   92700.0    92700.0    217210\n",
       "68 2021-12-29   93500.0   95000.0  92800.0   93700.0    93700.0    258296\n",
       "69 2021-12-30   94400.0   95300.0  92900.0   95200.0    95200.0    232685\n",
       "\n",
       "[70 rows x 7 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.reset_index(drop=True)\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f58c492b-caa1-4f88-ae95-b42182f070e5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Open           111000.0\n",
       "High           135000.0\n",
       "Low             91000.0\n",
       "Close          111500.0\n",
       "Adj Close      111500.0\n",
       "Volume       17373529.0\n",
       "Name: 2021-09-17 00:00:00, dtype: float64"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc['2021-09-17']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "efee8b39-42dd-4bb7-b1c5-635aa67c7c6a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "High    135000.0\n",
       "Low      91000.0\n",
       "Name: 2021-09-17 00:00:00, dtype: float64"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc['2021-09-17', ['High', 'Low']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "abfaec85-90a0-4aa4-b296-0e421767e1cd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Open         106000.0\n",
       "High         109500.0\n",
       "Low          105500.0\n",
       "Close        109000.0\n",
       "Adj Close    109000.0\n",
       "Volume       122211.0\n",
       "Name: 2021-11-19 00:00:00, dtype: float64"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[40]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "6bf82bf4-cc49-44d6-9148-09e4bd526dbb",
   "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>2021-12-30</th>\n",
       "      <td>94400.0</td>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>232685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-29</th>\n",
       "      <td>93500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>258296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-28</th>\n",
       "      <td>92800.0</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>217210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-27</th>\n",
       "      <td>92700.0</td>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>191739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-24</th>\n",
       "      <td>93000.0</td>\n",
       "      <td>93600.0</td>\n",
       "      <td>92200.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>220253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-28</th>\n",
       "      <td>98000.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1037427</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-27</th>\n",
       "      <td>98300.0</td>\n",
       "      <td>99400.0</td>\n",
       "      <td>96500.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>672212</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-24</th>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-23</th>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-17</th>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High      Low     Close  Adj Close    Volume\n",
       "Date                                                                  \n",
       "2021-12-30   94400.0   95300.0  92900.0   95200.0    95200.0    232685\n",
       "2021-12-29   93500.0   95000.0  92800.0   93700.0    93700.0    258296\n",
       "2021-12-28   92800.0   93500.0  92400.0   92700.0    92700.0    217210\n",
       "2021-12-27   92700.0   93200.0  92300.0   92700.0    92700.0    191739\n",
       "2021-12-24   93000.0   93600.0  92200.0   92700.0    92700.0    220253\n",
       "...              ...       ...      ...       ...        ...       ...\n",
       "2021-09-28   98000.0  103000.0  97000.0  100000.0   100000.0   1037427\n",
       "2021-09-27   98300.0   99400.0  96500.0   97000.0    97000.0    672212\n",
       "2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592\n",
       "2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293\n",
       "2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529\n",
       "\n",
       "[70 rows x 6 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_index(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "eb2f2fc7-2968-450b-8788-e9c9fbe77e36",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date\n",
       "2021-11-01    118500.0\n",
       "2021-10-29    117000.0\n",
       "2021-11-03    116500.0\n",
       "2021-11-02    116000.0\n",
       "2021-09-30    115500.0\n",
       "                ...   \n",
       "2021-12-27     92700.0\n",
       "2021-12-28     92700.0\n",
       "2021-12-23     92300.0\n",
       "2021-12-20     91900.0\n",
       "2021-12-17     91500.0\n",
       "Name: Close, Length: 70, dtype: float64"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Close'].sort_values(ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "6d535620-5ad5-4286-91b2-1e92d90a692e",
   "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>2021-11-01</th>\n",
       "      <td>116500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>385442</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-29</th>\n",
       "      <td>113500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>693739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-03</th>\n",
       "      <td>116000.0</td>\n",
       "      <td>117500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>281713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-11-02</th>\n",
       "      <td>118500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>368462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-09-30</th>\n",
       "      <td>107500.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>1704373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-27</th>\n",
       "      <td>92700.0</td>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>191739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-28</th>\n",
       "      <td>92800.0</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>217210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-23</th>\n",
       "      <td>92700.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>214082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-20</th>\n",
       "      <td>92100.0</td>\n",
       "      <td>93400.0</td>\n",
       "      <td>91600.0</td>\n",
       "      <td>91900.0</td>\n",
       "      <td>91900.0</td>\n",
       "      <td>462510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-17</th>\n",
       "      <td>90000.0</td>\n",
       "      <td>93400.0</td>\n",
       "      <td>89700.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>1686560</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>70 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open      High       Low     Close  Adj Close   Volume\n",
       "Date                                                                  \n",
       "2021-11-01  116500.0  119000.0  113500.0  118500.0   118500.0   385442\n",
       "2021-10-29  113500.0  119000.0  113000.0  117000.0   117000.0   693739\n",
       "2021-11-03  116000.0  117500.0  112500.0  116500.0   116500.0   281713\n",
       "2021-11-02  118500.0  119000.0  113500.0  116000.0   116000.0   368462\n",
       "2021-09-30  107500.0  117000.0  106000.0  115500.0   115500.0  1704373\n",
       "...              ...       ...       ...       ...        ...      ...\n",
       "2021-12-27   92700.0   93200.0   92300.0   92700.0    92700.0   191739\n",
       "2021-12-28   92800.0   93500.0   92400.0   92700.0    92700.0   217210\n",
       "2021-12-23   92700.0   92800.0   91500.0   92300.0    92300.0   214082\n",
       "2021-12-20   92100.0   93400.0   91600.0   91900.0    91900.0   462510\n",
       "2021-12-17   90000.0   93400.0   89700.0   91500.0    91500.0  1686560\n",
       "\n",
       "[70 rows x 6 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='Close', ascending=False)\n",
    "\n",
    "# 위 두 코드의 차이점은 df['Close']만 가져와서 정렬하느냐,\n",
    "#                     df를 먼저 가져오고, 'Close'기준으로 정렬하느냐임"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "eb54b0ae-b654-4282-8f41-d5ee32fd37d9",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[*********************100%***********************]  1 of 1 completed\n"
     ]
    }
   ],
   "source": [
    "df = data.get_data_yahoo('329180.KS', start='2021-01-01', end='2022-01-01')\n",
    "df.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2340c32a-7124-49fe-892f-13a8a303a564",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Datetime split 1\n",
    "\n",
    "df['Year'] = [s.year for s in df['Date']]\n",
    "df['Month'] = [d.month for d in df['Date']]\n",
    "df['Day'] = [d.day for d in df['Date']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "d68014c3-3a62-4a07-9187-8966ef6f82d6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Datetime split 2\n",
    "import datetime\n",
    "\n",
    "df['Year'] = df['Date'].dt.year\n",
    "df['Month'] = df['Date'].dt.month\n",
    "df['Day'] = df['Date'].dt.day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "4153d5da-085d-423b-ac42-7b24f43407ef",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 70 entries, 0 to 69\n",
      "Data columns (total 10 columns):\n",
      " #   Column     Non-Null Count  Dtype         \n",
      "---  ------     --------------  -----         \n",
      " 0   Date       70 non-null     datetime64[ns]\n",
      " 1   Open       70 non-null     float64       \n",
      " 2   High       70 non-null     float64       \n",
      " 3   Low        70 non-null     float64       \n",
      " 4   Close      70 non-null     float64       \n",
      " 5   Adj Close  70 non-null     float64       \n",
      " 6   Volume     70 non-null     int64         \n",
      " 7   Year       70 non-null     int64         \n",
      " 8   Month      70 non-null     int64         \n",
      " 9   Day        70 non-null     int64         \n",
      "dtypes: datetime64[ns](1), float64(5), int64(4)\n",
      "memory usage: 5.6 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "5389fa55-4b58-4966-ad0d-a5cdfe740d78",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2021-09-17</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>91000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>17373529</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-09-23</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>99000.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>99100.0</td>\n",
       "      <td>2914293</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-09-24</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>95500.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>99200.0</td>\n",
       "      <td>2262592</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2021-09-27</td>\n",
       "      <td>98300.0</td>\n",
       "      <td>99400.0</td>\n",
       "      <td>96500.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>672212</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-09-28</td>\n",
       "      <td>98000.0</td>\n",
       "      <td>103000.0</td>\n",
       "      <td>97000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>1037427</td>\n",
       "      <td>2021</td>\n",
       "      <td>9</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Date      Open      High      Low     Close  Adj Close    Volume  \\\n",
       "0 2021-09-17  111000.0  135000.0  91000.0  111500.0   111500.0  17373529   \n",
       "1 2021-09-23  112000.0  113000.0  99000.0   99100.0    99100.0   2914293   \n",
       "2 2021-09-24  100000.0  102000.0  95500.0   99200.0    99200.0   2262592   \n",
       "3 2021-09-27   98300.0   99400.0  96500.0   97000.0    97000.0    672212   \n",
       "4 2021-09-28   98000.0  103000.0  97000.0  100000.0   100000.0   1037427   \n",
       "\n",
       "   Year  Month  Day  \n",
       "0  2021      9   17  \n",
       "1  2021      9   23  \n",
       "2  2021      9   24  \n",
       "3  2021      9   27  \n",
       "4  2021      9   28  "
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "50e02a1a-d9ad-4990-bde8-6484388036eb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Month\n",
       "9     3.914224e+06\n",
       "10    4.895261e+05\n",
       "11    2.161131e+05\n",
       "12    3.271688e+05\n",
       "Name: Volume, dtype: float64"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Volume'].groupby(df['Month']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "0b6df8e9-0b15-42a4-a7b3-d8f4666a4622",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Date         0\n",
       "Open         0\n",
       "High         0\n",
       "Low          0\n",
       "Close        0\n",
       "Adj Close    0\n",
       "Volume       0\n",
       "Year         0\n",
       "Month        0\n",
       "Day          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "90ba985f-25dc-4816-a66d-38db6a6cbd3e",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>Day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2021-12-01</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>103500.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>142292</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2021-12-02</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>213861</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2021-12-03</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>180027</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2021-12-06</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>162493</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2021-12-07</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>188247</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2021-12-08</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>213352</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2021-12-09</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>393768</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2021-12-10</td>\n",
       "      <td>106500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>105500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>224135</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2021-12-13</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>105500.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>199659</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2021-12-14</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>101000.0</td>\n",
       "      <td>101000.0</td>\n",
       "      <td>101000.0</td>\n",
       "      <td>325488</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2021-12-15</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>100500.0</td>\n",
       "      <td>98600.0</td>\n",
       "      <td>98900.0</td>\n",
       "      <td>98900.0</td>\n",
       "      <td>297616</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2021-12-16</td>\n",
       "      <td>98600.0</td>\n",
       "      <td>99500.0</td>\n",
       "      <td>95100.0</td>\n",
       "      <td>95700.0</td>\n",
       "      <td>95700.0</td>\n",
       "      <td>448758</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2021-12-17</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>93400.0</td>\n",
       "      <td>89700.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>1686560</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2021-12-20</td>\n",
       "      <td>92100.0</td>\n",
       "      <td>93400.0</td>\n",
       "      <td>91600.0</td>\n",
       "      <td>91900.0</td>\n",
       "      <td>91900.0</td>\n",
       "      <td>462510</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2021-12-21</td>\n",
       "      <td>92200.0</td>\n",
       "      <td>94900.0</td>\n",
       "      <td>91300.0</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>94000.0</td>\n",
       "      <td>411144</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2021-12-22</td>\n",
       "      <td>94500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92100.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>313539</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2021-12-23</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>91500.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>214082</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2021-12-24</td>\n",
       "      <td>93000.0</td>\n",
       "      <td>93600.0</td>\n",
       "      <td>92200.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>220253</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2021-12-27</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>93200.0</td>\n",
       "      <td>92300.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>191739</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2021-12-28</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>92400.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>92700.0</td>\n",
       "      <td>217210</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>2021-12-29</td>\n",
       "      <td>93500.0</td>\n",
       "      <td>95000.0</td>\n",
       "      <td>92800.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>93700.0</td>\n",
       "      <td>258296</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>2021-12-30</td>\n",
       "      <td>94400.0</td>\n",
       "      <td>95300.0</td>\n",
       "      <td>92900.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>95200.0</td>\n",
       "      <td>232685</td>\n",
       "      <td>2021</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2021-11-01</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>385442</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2021-11-02</td>\n",
       "      <td>118500.0</td>\n",
       "      <td>119000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>368462</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2021-11-03</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>117500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>281713</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2021-11-04</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>292430</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021-11-05</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>330870</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2021-11-08</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>176789</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2021-11-09</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>115500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>335982</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2021-11-10</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>255794</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>164295</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2021-11-12</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>169377</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2021-11-15</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>180931</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2021-11-16</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>145772</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2021-11-17</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>113000.0</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>179729</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2021-11-18</td>\n",
       "      <td>108000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>105500.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>175355</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2021-11-19</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>105500.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>122211</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2021-11-22</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>110500.0</td>\n",
       "      <td>107500.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>109000.0</td>\n",
       "      <td>137867</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2021-11-23</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>147284</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2021-11-24</td>\n",
       "      <td>111000.0</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>123175</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2021-11-25</td>\n",
       "      <td>113500.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>112000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>114000.0</td>\n",
       "      <td>248249</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2021-11-26</td>\n",
       "      <td>114500.0</td>\n",
       "      <td>116500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>111500.0</td>\n",
       "      <td>171573</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2021-11-29</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>107000.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>108500.0</td>\n",
       "      <td>177072</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>109500.0</td>\n",
       "      <td>106000.0</td>\n",
       "      <td>106500.0</td>\n",
       "      <td>106500.0</td>\n",
       "      <td>184116</td>\n",
       "      <td>2021</td>\n",
       "      <td>11</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Date      Open      High       Low     Close  Adj Close   Volume  \\\n",
       "48 2021-12-01  106000.0  109000.0  103500.0  108000.0   108000.0   142292   \n",
       "49 2021-12-02  106000.0  114000.0  106000.0  113500.0   113500.0   213861   \n",
       "50 2021-12-03  113000.0  114500.0  111000.0  111000.0   111000.0   180027   \n",
       "51 2021-12-06  109500.0  113500.0  108500.0  112500.0   112500.0   162493   \n",
       "52 2021-12-07  113000.0  114500.0  109500.0  110000.0   110000.0   188247   \n",
       "53 2021-12-08  111000.0  111000.0  107500.0  108000.0   108000.0   213352   \n",
       "54 2021-12-09  108000.0  109500.0  107000.0  107000.0   107000.0   393768   \n",
       "55 2021-12-10  106500.0  107500.0  105500.0  107500.0   107500.0   224135   \n",
       "56 2021-12-13  107000.0  108000.0  105500.0  106000.0   106000.0   199659   \n",
       "57 2021-12-14  105000.0  106000.0  101000.0  101000.0   101000.0   325488   \n",
       "58 2021-12-15  100000.0  100500.0   98600.0   98900.0    98900.0   297616   \n",
       "59 2021-12-16   98600.0   99500.0   95100.0   95700.0    95700.0   448758   \n",
       "60 2021-12-17   90000.0   93400.0   89700.0   91500.0    91500.0  1686560   \n",
       "61 2021-12-20   92100.0   93400.0   91600.0   91900.0    91900.0   462510   \n",
       "62 2021-12-21   92200.0   94900.0   91300.0   94000.0    94000.0   411144   \n",
       "63 2021-12-22   94500.0   95000.0   92100.0   92700.0    92700.0   313539   \n",
       "64 2021-12-23   92700.0   92800.0   91500.0   92300.0    92300.0   214082   \n",
       "65 2021-12-24   93000.0   93600.0   92200.0   92700.0    92700.0   220253   \n",
       "66 2021-12-27   92700.0   93200.0   92300.0   92700.0    92700.0   191739   \n",
       "67 2021-12-28   92800.0   93500.0   92400.0   92700.0    92700.0   217210   \n",
       "68 2021-12-29   93500.0   95000.0   92800.0   93700.0    93700.0   258296   \n",
       "69 2021-12-30   94400.0   95300.0   92900.0   95200.0    95200.0   232685   \n",
       "26 2021-11-01  116500.0  119000.0  113500.0  118500.0   118500.0   385442   \n",
       "27 2021-11-02  118500.0  119000.0  113500.0  116000.0   116000.0   368462   \n",
       "28 2021-11-03  116000.0  117500.0  112500.0  116500.0   116500.0   281713   \n",
       "29 2021-11-04  117000.0  117000.0  112000.0  112500.0   112500.0   292430   \n",
       "30 2021-11-05  112000.0  114500.0  108500.0  113500.0   113500.0   330870   \n",
       "31 2021-11-08  114000.0  114000.0  110000.0  112000.0   112000.0   176789   \n",
       "32 2021-11-09  113500.0  115500.0  108500.0  109500.0   109500.0   335982   \n",
       "33 2021-11-10  109000.0  111500.0  106000.0  111000.0   111000.0   255794   \n",
       "34 2021-11-11  110000.0  112000.0  109500.0  112000.0   112000.0   164295   \n",
       "35 2021-11-12  112000.0  114000.0  111000.0  112000.0   112000.0   169377   \n",
       "36 2021-11-15  112500.0  114000.0  111000.0  114000.0   114000.0   180931   \n",
       "37 2021-11-16  114500.0  114500.0  111000.0  111500.0   111500.0   145772   \n",
       "38 2021-11-17  111500.0  113000.0  108000.0  108500.0   108500.0   179729   \n",
       "39 2021-11-18  108000.0  109500.0  105500.0  106000.0   106000.0   175355   \n",
       "40 2021-11-19  106000.0  109500.0  105500.0  109000.0   109000.0   122211   \n",
       "41 2021-11-22  108500.0  110500.0  107500.0  109000.0   109000.0   137867   \n",
       "42 2021-11-23  110000.0  111500.0  108500.0  111000.0   111000.0   147284   \n",
       "43 2021-11-24  111000.0  113500.0  110000.0  112500.0   112500.0   123175   \n",
       "44 2021-11-25  113500.0  116000.0  112000.0  114000.0   114000.0   248249   \n",
       "45 2021-11-26  114500.0  116500.0  111500.0  111500.0   111500.0   171573   \n",
       "46 2021-11-29  107000.0  110000.0  107000.0  108500.0   108500.0   177072   \n",
       "47 2021-11-30  109500.0  109500.0  106000.0  106500.0   106500.0   184116   \n",
       "\n",
       "    Year  Month  Day  \n",
       "48  2021     12    1  \n",
       "49  2021     12    2  \n",
       "50  2021     12    3  \n",
       "51  2021     12    6  \n",
       "52  2021     12    7  \n",
       "53  2021     12    8  \n",
       "54  2021     12    9  \n",
       "55  2021     12   10  \n",
       "56  2021     12   13  \n",
       "57  2021     12   14  \n",
       "58  2021     12   15  \n",
       "59  2021     12   16  \n",
       "60  2021     12   17  \n",
       "61  2021     12   20  \n",
       "62  2021     12   21  \n",
       "63  2021     12   22  \n",
       "64  2021     12   23  \n",
       "65  2021     12   24  \n",
       "66  2021     12   27  \n",
       "67  2021     12   28  \n",
       "68  2021     12   29  \n",
       "69  2021     12   30  \n",
       "26  2021     11    1  \n",
       "27  2021     11    2  \n",
       "28  2021     11    3  \n",
       "29  2021     11    4  \n",
       "30  2021     11    5  \n",
       "31  2021     11    8  \n",
       "32  2021     11    9  \n",
       "33  2021     11   10  \n",
       "34  2021     11   11  \n",
       "35  2021     11   12  \n",
       "36  2021     11   15  \n",
       "37  2021     11   16  \n",
       "38  2021     11   17  \n",
       "39  2021     11   18  \n",
       "40  2021     11   19  \n",
       "41  2021     11   22  \n",
       "42  2021     11   23  \n",
       "43  2021     11   24  \n",
       "44  2021     11   25  \n",
       "45  2021     11   26  \n",
       "46  2021     11   29  \n",
       "47  2021     11   30  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dec_df = df[df['Month'] == 12]\n",
    "nov_df = df[df['Month'] == 11]\n",
    "\n",
    "dec_nov_df = pd.concat([dec_df, nov_df])\n",
    "dec_nov_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "47a00cf6-c833-4af4-a73c-f1574dd8fb53",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  },
  "toc-autonumbering": true
 },
 "nbformat": 4,
 "nbformat_minor": 5
}