{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "a3f3dda9",
   "metadata": {},
   "source": [
    "# Using pandas"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69a4a9d7",
   "metadata": {},
   "source": [
    "## pandas dataframe and series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "8c53ed57",
   "metadata": {},
   "outputs": [],
   "source": [
    "# WITH OANDA\n",
    "import pandas as pd\n",
    "import tpqoa\n",
    "api = tpqoa.tpqoa(\"oandaMY.cfg\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ea03bf76",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<IB connected to 127.0.0.1:7497 clientId=1>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# WITH IBKR\n",
    "import pandas as pd\n",
    "from ib_insync import *\n",
    "util.startLoop()  # not necessary in scripts\n",
    "ib = IB()\n",
    "ib.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2185da2e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "DatetimeIndex: 519 entries, 2022-09-25 21:00:00 to 2024-09-23 21:00:00\n",
      "Data columns (total 6 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   open      519 non-null    float64\n",
      " 1   high      519 non-null    float64\n",
      " 2   low       519 non-null    float64\n",
      " 3   close     519 non-null    float64\n",
      " 4   volume    519 non-null    int64  \n",
      " 5   complete  519 non-null    bool   \n",
      "dtypes: bool(1), float64(4), int64(1)\n",
      "memory usage: 24.8 KB\n"
     ]
    }
   ],
   "source": [
    "# WITH OANDA\n",
    "df = api.get_history(instrument = \"EUR_USD\", start = \"2022-09-24\", end = \"2024-09-24\", granularity = \"D\", price = \"M\")\n",
    "# we change the column names to match IBKR\n",
    "df.rename(columns={\"o\":\"open\",\"h\":\"high\",\"l\":\"low\",\"c\":\"close\",\"time\":\"date\"},inplace=True)\n",
    "df.index.names = ['date']\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "194d4820",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "DatetimeIndex: 519 entries, 2022-09-26 to 2024-09-24\n",
      "Data columns (total 7 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   open      519 non-null    float64\n",
      " 1   high      519 non-null    float64\n",
      " 2   low       519 non-null    float64\n",
      " 3   close     519 non-null    float64\n",
      " 4   volume    519 non-null    float64\n",
      " 5   average   519 non-null    float64\n",
      " 6   barCount  519 non-null    int64  \n",
      "dtypes: float64(6), int64(1)\n",
      "memory usage: 32.4 KB\n"
     ]
    }
   ],
   "source": [
    "# WITH IBKR\n",
    "df = pd.DataFrame(ib.reqHistoricalData( Forex(\"EURUSD\"), endDateTime = \"20240924 00:00:00\", \n",
    "                                  barSizeSetting=\"1 day\", durationStr=\"2 Y\", \n",
    "                                  whatToShow= \"MIDPOINT\", useRTH = True, formatDate=2 )).set_index(\"date\")\n",
    "df.index=pd.to_datetime(df.index)\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "a175b3b3",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-26</th>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-27</th>\n",
       "      <td>0.960775</td>\n",
       "      <td>0.967095</td>\n",
       "      <td>0.956925</td>\n",
       "      <td>0.959385</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-28</th>\n",
       "      <td>0.959100</td>\n",
       "      <td>0.975100</td>\n",
       "      <td>0.953580</td>\n",
       "      <td>0.973460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-29</th>\n",
       "      <td>0.973725</td>\n",
       "      <td>0.981735</td>\n",
       "      <td>0.963575</td>\n",
       "      <td>0.981575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.981700</td>\n",
       "      <td>0.985405</td>\n",
       "      <td>0.973455</td>\n",
       "      <td>0.980155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       "2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0        -1\n",
       "2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
       "2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0        -1\n",
       "2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0        -1"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "651020eb",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.96915\n",
      "0.970995\n"
     ]
    }
   ],
   "source": [
    "# iloc is the method to access pandas dataframe's elements\n",
    "print(df.iloc[0,0])\n",
    "print(df.iloc[0,1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "863df835",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "date\n",
      "2022-09-26    0.970995\n",
      "2022-09-27    0.967095\n",
      "2022-09-28    0.975100\n",
      "2022-09-29    0.981735\n",
      "2022-09-30    0.985405\n",
      "                ...   \n",
      "2024-09-18    1.118935\n",
      "2024-09-19    1.117895\n",
      "2024-09-20    1.118195\n",
      "2024-09-23    1.116730\n",
      "2024-09-24    1.118095\n",
      "Name: high, Length: 519, dtype: float64\n",
      "<class 'pandas.core.series.Series'>\n"
     ]
    }
   ],
   "source": [
    "print(df.high) # this is a series\n",
    "print(type(df.high))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "46817bdf",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "DatetimeIndex(['2022-09-26', '2022-09-27', '2022-09-28', '2022-09-29',\n",
      "               '2022-09-30', '2022-10-03', '2022-10-04', '2022-10-05',\n",
      "               '2022-10-06', '2022-10-07',\n",
      "               ...\n",
      "               '2024-09-11', '2024-09-12', '2024-09-13', '2024-09-16',\n",
      "               '2024-09-17', '2024-09-18', '2024-09-19', '2024-09-20',\n",
      "               '2024-09-23', '2024-09-24'],\n",
      "              dtype='datetime64[ns]', name='date', length=519, freq=None)\n",
      "<class 'pandas.core.indexes.datetimes.DatetimeIndex'>\n"
     ]
    }
   ],
   "source": [
    "print(df.index) # this is not officially a series but an index (it means that it is in order)\n",
    "print(type(df.index))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "935305a7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2022-09-26 00:00:00\n"
     ]
    }
   ],
   "source": [
    "print(df.index[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "4917c3f4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"temp.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "1e2c3132",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "DatetimeIndex: 519 entries, 2022-09-26 to 2024-09-24\n",
      "Data columns (total 7 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   open      519 non-null    float64\n",
      " 1   high      519 non-null    float64\n",
      " 2   low       519 non-null    float64\n",
      " 3   close     519 non-null    float64\n",
      " 4   volume    519 non-null    float64\n",
      " 5   average   519 non-null    float64\n",
      " 6   barCount  519 non-null    int64  \n",
      "dtypes: float64(6), int64(1)\n",
      "memory usage: 32.4 KB\n",
      "None\n"
     ]
    }
   ],
   "source": [
    "temp=pd.read_csv(\"temp.csv\",parse_dates=[\"date\"],index_col=[0]) \n",
    "# parsedate contains the list of columns which are converted to time, you can specify also index instead; \n",
    "# same for index_col\n",
    "print(type(temp))\n",
    "print(temp.info())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "a4996ea5",
   "metadata": {
    "scrolled": true
   },
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-26</th>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-27</th>\n",
       "      <td>0.960775</td>\n",
       "      <td>0.967095</td>\n",
       "      <td>0.956925</td>\n",
       "      <td>0.959385</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-28</th>\n",
       "      <td>0.959100</td>\n",
       "      <td>0.975100</td>\n",
       "      <td>0.953580</td>\n",
       "      <td>0.973460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-29</th>\n",
       "      <td>0.973725</td>\n",
       "      <td>0.981735</td>\n",
       "      <td>0.963575</td>\n",
       "      <td>0.981575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.981700</td>\n",
       "      <td>0.985405</td>\n",
       "      <td>0.973455</td>\n",
       "      <td>0.980155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       "2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0        -1\n",
       "2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
       "2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0        -1\n",
       "2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0        -1"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a6824e55",
   "metadata": {},
   "source": [
    "## Convert string to datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "078becda",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "742620f3",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-09-26</td>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-09-27</td>\n",
       "      <td>0.960775</td>\n",
       "      <td>0.967095</td>\n",
       "      <td>0.956925</td>\n",
       "      <td>0.959385</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-09-28</td>\n",
       "      <td>0.959100</td>\n",
       "      <td>0.975100</td>\n",
       "      <td>0.953580</td>\n",
       "      <td>0.973460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-09-29</td>\n",
       "      <td>0.973725</td>\n",
       "      <td>0.981735</td>\n",
       "      <td>0.963575</td>\n",
       "      <td>0.981575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-09-30</td>\n",
       "      <td>0.981700</td>\n",
       "      <td>0.985405</td>\n",
       "      <td>0.973455</td>\n",
       "      <td>0.980155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         date      open      high       low     close  volume  average  \\\n",
       "0  2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0   \n",
       "1  2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0   \n",
       "2  2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0   \n",
       "3  2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0   \n",
       "4  2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0   \n",
       "\n",
       "   barCount  \n",
       "0        -1  \n",
       "1        -1  \n",
       "2        -1  \n",
       "3        -1  \n",
       "4        -1  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# let's get a series of strings which look like a datetime\n",
    "temp=pd.read_csv(\"temp.csv\") \n",
    "# we do not specify datetime nor index, so the first column will be a series of strings\n",
    "temp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "1a0d8086",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "str"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(temp.date[5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "f2fdba82",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.series.Series'>\n",
      "<class 'pandas._libs.tslibs.timestamps.Timestamp'>\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "0     2022-09-26\n",
       "1     2022-09-27\n",
       "2     2022-09-28\n",
       "3     2022-09-29\n",
       "4     2022-09-30\n",
       "         ...    \n",
       "514   2024-09-18\n",
       "515   2024-09-19\n",
       "516   2024-09-20\n",
       "517   2024-09-23\n",
       "518   2024-09-24\n",
       "Name: date, Length: 519, dtype: datetime64[ns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "b=pd.to_datetime(temp.date)\n",
    "print(type(b))\n",
    "print(type(b[5]))\n",
    "b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "388a1126",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-26</th>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-27</th>\n",
       "      <td>0.960775</td>\n",
       "      <td>0.967095</td>\n",
       "      <td>0.956925</td>\n",
       "      <td>0.959385</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-28</th>\n",
       "      <td>0.959100</td>\n",
       "      <td>0.975100</td>\n",
       "      <td>0.953580</td>\n",
       "      <td>0.973460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-29</th>\n",
       "      <td>0.973725</td>\n",
       "      <td>0.981735</td>\n",
       "      <td>0.963575</td>\n",
       "      <td>0.981575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.981700</td>\n",
       "      <td>0.985405</td>\n",
       "      <td>0.973455</td>\n",
       "      <td>0.980155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</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>2024-09-18</th>\n",
       "      <td>1.111520</td>\n",
       "      <td>1.118935</td>\n",
       "      <td>1.109675</td>\n",
       "      <td>1.111890</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-19</th>\n",
       "      <td>1.111645</td>\n",
       "      <td>1.117895</td>\n",
       "      <td>1.106855</td>\n",
       "      <td>1.116155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-20</th>\n",
       "      <td>1.116280</td>\n",
       "      <td>1.118195</td>\n",
       "      <td>1.113605</td>\n",
       "      <td>1.116345</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-23</th>\n",
       "      <td>1.116540</td>\n",
       "      <td>1.116730</td>\n",
       "      <td>1.108315</td>\n",
       "      <td>1.111125</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-24</th>\n",
       "      <td>1.111310</td>\n",
       "      <td>1.118095</td>\n",
       "      <td>1.110345</td>\n",
       "      <td>1.117965</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>519 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       "2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0        -1\n",
       "2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
       "2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0        -1\n",
       "2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0        -1\n",
       "...              ...       ...       ...       ...     ...      ...       ...\n",
       "2024-09-18  1.111520  1.118935  1.109675  1.111890    -1.0     -1.0        -1\n",
       "2024-09-19  1.111645  1.117895  1.106855  1.116155    -1.0     -1.0        -1\n",
       "2024-09-20  1.116280  1.118195  1.113605  1.116345    -1.0     -1.0        -1\n",
       "2024-09-23  1.116540  1.116730  1.108315  1.111125    -1.0     -1.0        -1\n",
       "2024-09-24  1.111310  1.118095  1.110345  1.117965    -1.0     -1.0        -1\n",
       "\n",
       "[519 rows x 7 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# when we imported the data, we could convert the time column to datetime and set it to index also later.\n",
    "temp=pd.read_csv(\"temp.csv\") \n",
    "temp.set_index(pd.to_datetime(temp.date)).drop(\"date\",axis=1)  # it does not modify temp, you need to state temp="
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ff92d0cb",
   "metadata": {},
   "source": [
    "**to_datetime** can handle many differen formats, such as yyyy-mm-dd, yyyymmdd, yyyy/mm/dd, yyyy mm dd, yyyy-mm-dd. However, always year, month, day, unless you specify the month in letters. Optionally, it accepts also time as hh, hh:mm, hh:mm:ss."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "be2e5bae",
   "metadata": {},
   "source": [
    "## indexing and slicing time series"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "befc984b",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-26</th>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-27</th>\n",
       "      <td>0.960775</td>\n",
       "      <td>0.967095</td>\n",
       "      <td>0.956925</td>\n",
       "      <td>0.959385</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-28</th>\n",
       "      <td>0.959100</td>\n",
       "      <td>0.975100</td>\n",
       "      <td>0.953580</td>\n",
       "      <td>0.973460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-29</th>\n",
       "      <td>0.973725</td>\n",
       "      <td>0.981735</td>\n",
       "      <td>0.963575</td>\n",
       "      <td>0.981575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-30</th>\n",
       "      <td>0.981700</td>\n",
       "      <td>0.985405</td>\n",
       "      <td>0.973455</td>\n",
       "      <td>0.980155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       "2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0        -1\n",
       "2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
       "2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0        -1\n",
       "2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0        -1"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "temp=pd.read_csv(\"temp.csv\",parse_dates=[\"date\"],index_col=[0]) \n",
    "temp.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a7a220f6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "open        1.09933\n",
       "high        1.09933\n",
       "low         1.09297\n",
       "close       1.09415\n",
       "volume     -1.00000\n",
       "average    -1.00000\n",
       "barCount   -1.00000\n",
       "Name: 2023-12-20 00:00:00, dtype: float64"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loc is the method to slice the dataframe along TIME\n",
    "temp.loc[\"2023-12-20\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "d9aa5324",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-02-01</th>\n",
       "      <td>1.086500</td>\n",
       "      <td>1.100125</td>\n",
       "      <td>1.085225</td>\n",
       "      <td>1.098940</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-02</th>\n",
       "      <td>1.098805</td>\n",
       "      <td>1.103335</td>\n",
       "      <td>1.088535</td>\n",
       "      <td>1.090935</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-03</th>\n",
       "      <td>1.091125</td>\n",
       "      <td>1.094015</td>\n",
       "      <td>1.079270</td>\n",
       "      <td>1.079460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-06</th>\n",
       "      <td>1.078675</td>\n",
       "      <td>1.079900</td>\n",
       "      <td>1.070945</td>\n",
       "      <td>1.072605</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-07</th>\n",
       "      <td>1.072160</td>\n",
       "      <td>1.076675</td>\n",
       "      <td>1.066925</td>\n",
       "      <td>1.072670</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-08</th>\n",
       "      <td>1.072480</td>\n",
       "      <td>1.076085</td>\n",
       "      <td>1.070945</td>\n",
       "      <td>1.071080</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-09</th>\n",
       "      <td>1.071210</td>\n",
       "      <td>1.079095</td>\n",
       "      <td>1.070930</td>\n",
       "      <td>1.073970</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-10</th>\n",
       "      <td>1.074020</td>\n",
       "      <td>1.075285</td>\n",
       "      <td>1.066630</td>\n",
       "      <td>1.067390</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-13</th>\n",
       "      <td>1.068250</td>\n",
       "      <td>1.072995</td>\n",
       "      <td>1.065555</td>\n",
       "      <td>1.072320</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-14</th>\n",
       "      <td>1.072150</td>\n",
       "      <td>1.080480</td>\n",
       "      <td>1.070685</td>\n",
       "      <td>1.073680</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-15</th>\n",
       "      <td>1.073475</td>\n",
       "      <td>1.074460</td>\n",
       "      <td>1.066050</td>\n",
       "      <td>1.068995</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-16</th>\n",
       "      <td>1.069020</td>\n",
       "      <td>1.072250</td>\n",
       "      <td>1.065460</td>\n",
       "      <td>1.067420</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-17</th>\n",
       "      <td>1.067490</td>\n",
       "      <td>1.069850</td>\n",
       "      <td>1.061285</td>\n",
       "      <td>1.069490</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-20</th>\n",
       "      <td>1.069115</td>\n",
       "      <td>1.070460</td>\n",
       "      <td>1.067015</td>\n",
       "      <td>1.068510</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-21</th>\n",
       "      <td>1.068430</td>\n",
       "      <td>1.069835</td>\n",
       "      <td>1.063745</td>\n",
       "      <td>1.064840</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-22</th>\n",
       "      <td>1.065075</td>\n",
       "      <td>1.066400</td>\n",
       "      <td>1.059910</td>\n",
       "      <td>1.060395</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-23</th>\n",
       "      <td>1.060555</td>\n",
       "      <td>1.062780</td>\n",
       "      <td>1.057715</td>\n",
       "      <td>1.059550</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-24</th>\n",
       "      <td>1.059780</td>\n",
       "      <td>1.061445</td>\n",
       "      <td>1.053620</td>\n",
       "      <td>1.054850</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-27</th>\n",
       "      <td>1.054830</td>\n",
       "      <td>1.062000</td>\n",
       "      <td>1.053300</td>\n",
       "      <td>1.060940</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-02-28</th>\n",
       "      <td>1.060535</td>\n",
       "      <td>1.064535</td>\n",
       "      <td>1.057415</td>\n",
       "      <td>1.057520</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2023-02-01  1.086500  1.100125  1.085225  1.098940    -1.0     -1.0        -1\n",
       "2023-02-02  1.098805  1.103335  1.088535  1.090935    -1.0     -1.0        -1\n",
       "2023-02-03  1.091125  1.094015  1.079270  1.079460    -1.0     -1.0        -1\n",
       "2023-02-06  1.078675  1.079900  1.070945  1.072605    -1.0     -1.0        -1\n",
       "2023-02-07  1.072160  1.076675  1.066925  1.072670    -1.0     -1.0        -1\n",
       "2023-02-08  1.072480  1.076085  1.070945  1.071080    -1.0     -1.0        -1\n",
       "2023-02-09  1.071210  1.079095  1.070930  1.073970    -1.0     -1.0        -1\n",
       "2023-02-10  1.074020  1.075285  1.066630  1.067390    -1.0     -1.0        -1\n",
       "2023-02-13  1.068250  1.072995  1.065555  1.072320    -1.0     -1.0        -1\n",
       "2023-02-14  1.072150  1.080480  1.070685  1.073680    -1.0     -1.0        -1\n",
       "2023-02-15  1.073475  1.074460  1.066050  1.068995    -1.0     -1.0        -1\n",
       "2023-02-16  1.069020  1.072250  1.065460  1.067420    -1.0     -1.0        -1\n",
       "2023-02-17  1.067490  1.069850  1.061285  1.069490    -1.0     -1.0        -1\n",
       "2023-02-20  1.069115  1.070460  1.067015  1.068510    -1.0     -1.0        -1\n",
       "2023-02-21  1.068430  1.069835  1.063745  1.064840    -1.0     -1.0        -1\n",
       "2023-02-22  1.065075  1.066400  1.059910  1.060395    -1.0     -1.0        -1\n",
       "2023-02-23  1.060555  1.062780  1.057715  1.059550    -1.0     -1.0        -1\n",
       "2023-02-24  1.059780  1.061445  1.053620  1.054850    -1.0     -1.0        -1\n",
       "2023-02-27  1.054830  1.062000  1.053300  1.060940    -1.0     -1.0        -1\n",
       "2023-02-28  1.060535  1.064535  1.057415  1.057520    -1.0     -1.0        -1"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.loc[\"2023-02\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "f6d544c3",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-01-03</th>\n",
       "      <td>1.067675</td>\n",
       "      <td>1.068035</td>\n",
       "      <td>1.051955</td>\n",
       "      <td>1.054750</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-04</th>\n",
       "      <td>1.054820</td>\n",
       "      <td>1.063565</td>\n",
       "      <td>1.054090</td>\n",
       "      <td>1.060215</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-05</th>\n",
       "      <td>1.060325</td>\n",
       "      <td>1.063160</td>\n",
       "      <td>1.051505</td>\n",
       "      <td>1.052185</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-06</th>\n",
       "      <td>1.052170</td>\n",
       "      <td>1.064820</td>\n",
       "      <td>1.048290</td>\n",
       "      <td>1.064400</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-09</th>\n",
       "      <td>1.064150</td>\n",
       "      <td>1.076070</td>\n",
       "      <td>1.063970</td>\n",
       "      <td>1.072960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</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>2023-12-22</th>\n",
       "      <td>1.100250</td>\n",
       "      <td>1.104035</td>\n",
       "      <td>1.099385</td>\n",
       "      <td>1.101260</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-26</th>\n",
       "      <td>1.101895</td>\n",
       "      <td>1.104510</td>\n",
       "      <td>1.100870</td>\n",
       "      <td>1.104235</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-27</th>\n",
       "      <td>1.104200</td>\n",
       "      <td>1.112280</td>\n",
       "      <td>1.102845</td>\n",
       "      <td>1.110510</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-28</th>\n",
       "      <td>1.110215</td>\n",
       "      <td>1.113950</td>\n",
       "      <td>1.105520</td>\n",
       "      <td>1.106120</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-12-29</th>\n",
       "      <td>1.106445</td>\n",
       "      <td>1.108455</td>\n",
       "      <td>1.103815</td>\n",
       "      <td>1.104095</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>258 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2023-01-03  1.067675  1.068035  1.051955  1.054750    -1.0     -1.0        -1\n",
       "2023-01-04  1.054820  1.063565  1.054090  1.060215    -1.0     -1.0        -1\n",
       "2023-01-05  1.060325  1.063160  1.051505  1.052185    -1.0     -1.0        -1\n",
       "2023-01-06  1.052170  1.064820  1.048290  1.064400    -1.0     -1.0        -1\n",
       "2023-01-09  1.064150  1.076070  1.063970  1.072960    -1.0     -1.0        -1\n",
       "...              ...       ...       ...       ...     ...      ...       ...\n",
       "2023-12-22  1.100250  1.104035  1.099385  1.101260    -1.0     -1.0        -1\n",
       "2023-12-26  1.101895  1.104510  1.100870  1.104235    -1.0     -1.0        -1\n",
       "2023-12-27  1.104200  1.112280  1.102845  1.110510    -1.0     -1.0        -1\n",
       "2023-12-28  1.110215  1.113950  1.105520  1.106120    -1.0     -1.0        -1\n",
       "2023-12-29  1.106445  1.108455  1.103815  1.104095    -1.0     -1.0        -1\n",
       "\n",
       "[258 rows x 7 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.loc[\"2023\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "e9e320c7",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-01-17</th>\n",
       "      <td>1.081985</td>\n",
       "      <td>1.086945</td>\n",
       "      <td>1.077445</td>\n",
       "      <td>1.078800</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-18</th>\n",
       "      <td>1.078975</td>\n",
       "      <td>1.088760</td>\n",
       "      <td>1.076600</td>\n",
       "      <td>1.079395</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-19</th>\n",
       "      <td>1.079015</td>\n",
       "      <td>1.084015</td>\n",
       "      <td>1.078235</td>\n",
       "      <td>1.083175</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-20</th>\n",
       "      <td>1.083220</td>\n",
       "      <td>1.085915</td>\n",
       "      <td>1.080240</td>\n",
       "      <td>1.085660</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-23</th>\n",
       "      <td>1.086645</td>\n",
       "      <td>1.092685</td>\n",
       "      <td>1.084630</td>\n",
       "      <td>1.087200</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-24</th>\n",
       "      <td>1.087200</td>\n",
       "      <td>1.089815</td>\n",
       "      <td>1.083520</td>\n",
       "      <td>1.088575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-25</th>\n",
       "      <td>1.088805</td>\n",
       "      <td>1.092380</td>\n",
       "      <td>1.085735</td>\n",
       "      <td>1.091560</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-26</th>\n",
       "      <td>1.091550</td>\n",
       "      <td>1.092960</td>\n",
       "      <td>1.085055</td>\n",
       "      <td>1.089265</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-27</th>\n",
       "      <td>1.089050</td>\n",
       "      <td>1.090045</td>\n",
       "      <td>1.083785</td>\n",
       "      <td>1.086900</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2023-01-17  1.081985  1.086945  1.077445  1.078800    -1.0     -1.0        -1\n",
       "2023-01-18  1.078975  1.088760  1.076600  1.079395    -1.0     -1.0        -1\n",
       "2023-01-19  1.079015  1.084015  1.078235  1.083175    -1.0     -1.0        -1\n",
       "2023-01-20  1.083220  1.085915  1.080240  1.085660    -1.0     -1.0        -1\n",
       "2023-01-23  1.086645  1.092685  1.084630  1.087200    -1.0     -1.0        -1\n",
       "2023-01-24  1.087200  1.089815  1.083520  1.088575    -1.0     -1.0        -1\n",
       "2023-01-25  1.088805  1.092380  1.085735  1.091560    -1.0     -1.0        -1\n",
       "2023-01-26  1.091550  1.092960  1.085055  1.089265    -1.0     -1.0        -1\n",
       "2023-01-27  1.089050  1.090045  1.083785  1.086900    -1.0     -1.0        -1"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.loc[\"2023-01-17\":\"2023-01-28\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "d3f15e19",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-01-17</th>\n",
       "      <td>1.081985</td>\n",
       "      <td>1.086945</td>\n",
       "      <td>1.077445</td>\n",
       "      <td>1.078800</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-18</th>\n",
       "      <td>1.078975</td>\n",
       "      <td>1.088760</td>\n",
       "      <td>1.076600</td>\n",
       "      <td>1.079395</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-19</th>\n",
       "      <td>1.079015</td>\n",
       "      <td>1.084015</td>\n",
       "      <td>1.078235</td>\n",
       "      <td>1.083175</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-20</th>\n",
       "      <td>1.083220</td>\n",
       "      <td>1.085915</td>\n",
       "      <td>1.080240</td>\n",
       "      <td>1.085660</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-23</th>\n",
       "      <td>1.086645</td>\n",
       "      <td>1.092685</td>\n",
       "      <td>1.084630</td>\n",
       "      <td>1.087200</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</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>2024-09-18</th>\n",
       "      <td>1.111520</td>\n",
       "      <td>1.118935</td>\n",
       "      <td>1.109675</td>\n",
       "      <td>1.111890</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-19</th>\n",
       "      <td>1.111645</td>\n",
       "      <td>1.117895</td>\n",
       "      <td>1.106855</td>\n",
       "      <td>1.116155</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-20</th>\n",
       "      <td>1.116280</td>\n",
       "      <td>1.118195</td>\n",
       "      <td>1.113605</td>\n",
       "      <td>1.116345</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-23</th>\n",
       "      <td>1.116540</td>\n",
       "      <td>1.116730</td>\n",
       "      <td>1.108315</td>\n",
       "      <td>1.111125</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-24</th>\n",
       "      <td>1.111310</td>\n",
       "      <td>1.118095</td>\n",
       "      <td>1.110345</td>\n",
       "      <td>1.117965</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>439 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2023-01-17  1.081985  1.086945  1.077445  1.078800    -1.0     -1.0        -1\n",
       "2023-01-18  1.078975  1.088760  1.076600  1.079395    -1.0     -1.0        -1\n",
       "2023-01-19  1.079015  1.084015  1.078235  1.083175    -1.0     -1.0        -1\n",
       "2023-01-20  1.083220  1.085915  1.080240  1.085660    -1.0     -1.0        -1\n",
       "2023-01-23  1.086645  1.092685  1.084630  1.087200    -1.0     -1.0        -1\n",
       "...              ...       ...       ...       ...     ...      ...       ...\n",
       "2024-09-18  1.111520  1.118935  1.109675  1.111890    -1.0     -1.0        -1\n",
       "2024-09-19  1.111645  1.117895  1.106855  1.116155    -1.0     -1.0        -1\n",
       "2024-09-20  1.116280  1.118195  1.113605  1.116345    -1.0     -1.0        -1\n",
       "2024-09-23  1.116540  1.116730  1.108315  1.111125    -1.0     -1.0        -1\n",
       "2024-09-24  1.111310  1.118095  1.110345  1.117965    -1.0     -1.0        -1\n",
       "\n",
       "[439 rows x 7 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.loc[\"2023-01-17\":]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "8f2669dd",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2023-01-19</th>\n",
       "      <td>1.079015</td>\n",
       "      <td>1.084015</td>\n",
       "      <td>1.078235</td>\n",
       "      <td>1.083175</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2023-01-26</th>\n",
       "      <td>1.091550</td>\n",
       "      <td>1.092960</td>\n",
       "      <td>1.085055</td>\n",
       "      <td>1.089265</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2023-01-19  1.079015  1.084015  1.078235  1.083175    -1.0     -1.0        -1\n",
       "2023-01-26  1.091550  1.092960  1.085055  1.089265    -1.0     -1.0        -1"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# PAY ATTENTION: in this case arguments must be a list!!! and the precise date with TIME must be inserted\n",
    "temp.loc[[\"2023-01-19\",\"2023-01-26\"]] "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe95a5b7",
   "metadata": {},
   "source": [
    "## Downsampling data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "1db1d3d5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "99d0f48d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "DatetimeIndex: 519 entries, 2022-09-26 to 2024-09-24\n",
      "Data columns (total 7 columns):\n",
      " #   Column    Non-Null Count  Dtype  \n",
      "---  ------    --------------  -----  \n",
      " 0   open      519 non-null    float64\n",
      " 1   high      519 non-null    float64\n",
      " 2   low       519 non-null    float64\n",
      " 3   close     519 non-null    float64\n",
      " 4   volume    519 non-null    float64\n",
      " 5   average   519 non-null    float64\n",
      " 6   barCount  519 non-null    int64  \n",
      "dtypes: float64(6), int64(1)\n",
      "memory usage: 32.4 KB\n"
     ]
    }
   ],
   "source": [
    "temp=pd.read_csv(\"temp.csv\",parse_dates=[\"date\"],index_col=[0]) \n",
    "temp.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "0857b9ca",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "DatetimeIndexResampler [freq=<Week: weekday=6>, axis=0, closed=right, label=right, convention=start, origin=start_day]\n"
     ]
    }
   ],
   "source": [
    "print(temp.resample(\"W\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "655d66a1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[(Timestamp('2022-10-02 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
      "2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0        -1\n",
      "2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
      "2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0        -1\n",
      "2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0        -1), (Timestamp('2022-10-09 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-10-03  0.979600  0.984465  0.975285  0.982575    -1.0     -1.0        -1\n",
      "2022-10-04  0.982575  0.999990  0.980620  0.998655    -1.0     -1.0        -1\n",
      "2022-10-05  0.998750  0.999510  0.983485  0.988445    -1.0     -1.0        -1\n",
      "2022-10-06  0.988375  0.992670  0.978840  0.979080    -1.0     -1.0        -1\n",
      "2022-10-07  0.978825  0.981700  0.972615  0.973350    -1.0     -1.0        -1), (Timestamp('2022-10-16 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-10-10  0.973575  0.975345  0.968180  0.970190    -1.0     -1.0        -1\n",
      "2022-10-11  0.970185  0.977485  0.967005  0.970785    -1.0     -1.0        -1\n",
      "2022-10-12  0.970550  0.973515  0.966775  0.970310    -1.0     -1.0        -1\n",
      "2022-10-13  0.970075  0.980620  0.963145  0.977445    -1.0     -1.0        -1\n",
      "2022-10-14  0.977325  0.980885  0.970750  0.972015    -1.0     -1.0        -1), (Timestamp('2022-10-23 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-10-17  0.971950  0.985230  0.971950  0.984235    -1.0     -1.0        -1\n",
      "2022-10-18  0.984175  0.987590  0.981275  0.985860    -1.0     -1.0        -1\n",
      "2022-10-19  0.986200  0.987265  0.975745  0.977285    -1.0     -1.0        -1\n",
      "2022-10-20  0.977255  0.984570  0.975450  0.978545    -1.0     -1.0        -1\n",
      "2022-10-21  0.978675  0.986940  0.970485  0.986080    -1.0     -1.0        -1), (Timestamp('2022-10-30 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-10-24  0.987675  0.989935  0.980690  0.987450    -1.0     -1.0        -1\n",
      "2022-10-25  0.987325  0.997690  0.984840  0.996530    -1.0     -1.0        -1\n",
      "2022-10-26  0.996625  1.008875  0.994345  1.007925    -1.0     -1.0        -1\n",
      "2022-10-27  1.008325  1.009380  0.995770  0.996395    -1.0     -1.0        -1\n",
      "2022-10-28  0.996500  0.999820  0.992665  0.996500    -1.0     -1.0        -1), (Timestamp('2022-11-06 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-10-31  0.995875  0.996585  0.987295  0.988160    -1.0     -1.0        -1\n",
      "2022-11-01  0.988150  0.995415  0.985295  0.988085    -1.0     -1.0        -1\n",
      "2022-11-02  0.988310  0.997615  0.981305  0.981620    -1.0     -1.0        -1\n",
      "2022-11-03  0.981725  0.983975  0.973015  0.974820    -1.0     -1.0        -1\n",
      "2022-11-04  0.974750  0.996680  0.974265  0.995470    -1.0     -1.0        -1), (Timestamp('2022-11-13 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-11-07  0.991650  1.003455  0.990915  1.001945    -1.0     -1.0        -1\n",
      "2022-11-08  1.002010  1.009635  0.997155  1.007400    -1.0     -1.0        -1\n",
      "2022-11-09  1.007765  1.008840  0.999300  1.001095    -1.0     -1.0        -1\n",
      "2022-11-10  1.000925  1.022200  0.993565  1.020790    -1.0     -1.0        -1\n",
      "2022-11-11  1.019975  1.036430  1.016310  1.034465    -1.0     -1.0        -1), (Timestamp('2022-11-20 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-11-14  1.031790  1.035880  1.027150  1.032685    -1.0     -1.0        -1\n",
      "2022-11-15  1.033205  1.048205  1.028015  1.034950    -1.0     -1.0        -1\n",
      "2022-11-16  1.034450  1.043875  1.033085  1.039480    -1.0     -1.0        -1\n",
      "2022-11-17  1.039290  1.040680  1.030530  1.036145    -1.0     -1.0        -1\n",
      "2022-11-18  1.036175  1.039615  1.031380  1.032425    -1.0     -1.0        -1), (Timestamp('2022-11-27 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-11-21  1.032500  1.033335  1.022255  1.024095    -1.0     -1.0        -1\n",
      "2022-11-22  1.024270  1.030825  1.023970  1.030470    -1.0     -1.0        -1\n",
      "2022-11-23  1.030350  1.040515  1.029660  1.039615    -1.0     -1.0        -1\n",
      "2022-11-24  1.039440  1.044870  1.038180  1.041005    -1.0     -1.0        -1\n",
      "2022-11-25  1.041045  1.042940  1.035475  1.039645    -1.0     -1.0        -1), (Timestamp('2022-12-04 00:00:00', freq='W-SUN'),                open      high       low     close  volume  average  barCount\n",
      "date                                                                        \n",
      "2022-11-28  1.03767  1.049705  1.033020  1.033935    -1.0     -1.0        -1\n",
      "2022-11-29  1.03383  1.039455  1.031995  1.032750    -1.0     -1.0        -1\n",
      "2022-11-30  1.03340  1.042885  1.029030  1.040600    -1.0     -1.0        -1\n",
      "2022-12-01  1.04016  1.053415  1.039320  1.051865    -1.0     -1.0        -1\n",
      "2022-12-02  1.05216  1.054525  1.042840  1.053565    -1.0     -1.0        -1), (Timestamp('2022-12-11 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-12-05  1.053900  1.059495  1.048025  1.049135    -1.0     -1.0        -1\n",
      "2022-12-06  1.049225  1.053290  1.045950  1.046730    -1.0     -1.0        -1\n",
      "2022-12-07  1.046755  1.054990  1.044335  1.050435    -1.0     -1.0        -1\n",
      "2022-12-08  1.050900  1.056495  1.048955  1.055740    -1.0     -1.0        -1\n",
      "2022-12-09  1.055625  1.058855  1.050355  1.054505    -1.0     -1.0        -1), (Timestamp('2022-12-18 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-12-12  1.053290  1.058025  1.050595  1.053735    -1.0     -1.0        -1\n",
      "2022-12-13  1.053400  1.067340  1.052805  1.063265    -1.0     -1.0        -1\n",
      "2022-12-14  1.063025  1.069545  1.061905  1.068200    -1.0     -1.0        -1\n",
      "2022-12-15  1.068275  1.073695  1.059225  1.062865    -1.0     -1.0        -1\n",
      "2022-12-16  1.062300  1.066320  1.058485  1.058495    -1.0     -1.0        -1), (Timestamp('2022-12-25 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-12-19  1.059770  1.065815  1.057590  1.060695    -1.0     -1.0        -1\n",
      "2022-12-20  1.060675  1.065880  1.057900  1.062515    -1.0     -1.0        -1\n",
      "2022-12-21  1.062575  1.064585  1.059035  1.060440    -1.0     -1.0        -1\n",
      "2022-12-22  1.060850  1.065950  1.057330  1.059765    -1.0     -1.0        -1\n",
      "2022-12-23  1.059520  1.063300  1.058680  1.061870    -1.0     -1.0        -1), (Timestamp('2023-01-01 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2022-12-26  1.062170  1.063765  1.059850  1.063695    -1.0     -1.0        -1\n",
      "2022-12-27  1.063650  1.066965  1.061155  1.063970    -1.0     -1.0        -1\n",
      "2022-12-28  1.064425  1.067460  1.060670  1.061245    -1.0     -1.0        -1\n",
      "2022-12-29  1.061325  1.069065  1.061120  1.066110    -1.0     -1.0        -1\n",
      "2022-12-30  1.066630  1.071330  1.063855  1.070200    -1.0     -1.0        -1), (Timestamp('2023-01-08 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-01-03  1.067675  1.068035  1.051955  1.054750    -1.0     -1.0        -1\n",
      "2023-01-04  1.054820  1.063565  1.054090  1.060215    -1.0     -1.0        -1\n",
      "2023-01-05  1.060325  1.063160  1.051505  1.052185    -1.0     -1.0        -1\n",
      "2023-01-06  1.052170  1.064820  1.048290  1.064400    -1.0     -1.0        -1), (Timestamp('2023-01-15 00:00:00', freq='W-SUN'),                 open      high       low    close  volume  average  barCount\n",
      "date                                                                        \n",
      "2023-01-09  1.064150  1.076070  1.063970  1.07296    -1.0     -1.0        -1\n",
      "2023-01-10  1.072955  1.075950  1.071205  1.07331    -1.0     -1.0        -1\n",
      "2023-01-11  1.073440  1.077645  1.072550  1.07582    -1.0     -1.0        -1\n",
      "2023-01-12  1.076105  1.086720  1.072905  1.08537    -1.0     -1.0        -1\n",
      "2023-01-13  1.087600  1.087600  1.078050  1.08290    -1.0     -1.0        -1), (Timestamp('2023-01-22 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-01-16  1.083225  1.087435  1.080155  1.082115    -1.0     -1.0        -1\n",
      "2023-01-17  1.081985  1.086945  1.077445  1.078800    -1.0     -1.0        -1\n",
      "2023-01-18  1.078975  1.088760  1.076600  1.079395    -1.0     -1.0        -1\n",
      "2023-01-19  1.079015  1.084015  1.078235  1.083175    -1.0     -1.0        -1\n",
      "2023-01-20  1.083220  1.085915  1.080240  1.085660    -1.0     -1.0        -1), (Timestamp('2023-01-29 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-01-23  1.086645  1.092685  1.084630  1.087200    -1.0     -1.0        -1\n",
      "2023-01-24  1.087200  1.089815  1.083520  1.088575    -1.0     -1.0        -1\n",
      "2023-01-25  1.088805  1.092380  1.085735  1.091560    -1.0     -1.0        -1\n",
      "2023-01-26  1.091550  1.092960  1.085055  1.089265    -1.0     -1.0        -1\n",
      "2023-01-27  1.089050  1.090045  1.083785  1.086900    -1.0     -1.0        -1), (Timestamp('2023-02-05 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-01-30  1.086755  1.091385  1.083930  1.085040    -1.0     -1.0        -1\n",
      "2023-01-31  1.085025  1.087505  1.080220  1.086370    -1.0     -1.0        -1\n",
      "2023-02-01  1.086500  1.100125  1.085225  1.098940    -1.0     -1.0        -1\n",
      "2023-02-02  1.098805  1.103335  1.088535  1.090935    -1.0     -1.0        -1\n",
      "2023-02-03  1.091125  1.094015  1.079270  1.079460    -1.0     -1.0        -1), (Timestamp('2023-02-12 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-02-06  1.078675  1.079900  1.070945  1.072605    -1.0     -1.0        -1\n",
      "2023-02-07  1.072160  1.076675  1.066925  1.072670    -1.0     -1.0        -1\n",
      "2023-02-08  1.072480  1.076085  1.070945  1.071080    -1.0     -1.0        -1\n",
      "2023-02-09  1.071210  1.079095  1.070930  1.073970    -1.0     -1.0        -1\n",
      "2023-02-10  1.074020  1.075285  1.066630  1.067390    -1.0     -1.0        -1), (Timestamp('2023-02-19 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-02-13  1.068250  1.072995  1.065555  1.072320    -1.0     -1.0        -1\n",
      "2023-02-14  1.072150  1.080480  1.070685  1.073680    -1.0     -1.0        -1\n",
      "2023-02-15  1.073475  1.074460  1.066050  1.068995    -1.0     -1.0        -1\n",
      "2023-02-16  1.069020  1.072250  1.065460  1.067420    -1.0     -1.0        -1\n",
      "2023-02-17  1.067490  1.069850  1.061285  1.069490    -1.0     -1.0        -1), (Timestamp('2023-02-26 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-02-20  1.069115  1.070460  1.067015  1.068510    -1.0     -1.0        -1\n",
      "2023-02-21  1.068430  1.069835  1.063745  1.064840    -1.0     -1.0        -1\n",
      "2023-02-22  1.065075  1.066400  1.059910  1.060395    -1.0     -1.0        -1\n",
      "2023-02-23  1.060555  1.062780  1.057715  1.059550    -1.0     -1.0        -1\n",
      "2023-02-24  1.059780  1.061445  1.053620  1.054850    -1.0     -1.0        -1), (Timestamp('2023-03-05 00:00:00', freq='W-SUN'),                 open      high       low    close  volume  average  barCount\n",
      "date                                                                        \n",
      "2023-02-27  1.054830  1.062000  1.053300  1.06094    -1.0     -1.0        -1\n",
      "2023-02-28  1.060535  1.064535  1.057415  1.05752    -1.0     -1.0        -1\n",
      "2023-03-01  1.057825  1.069160  1.056535  1.06680    -1.0     -1.0        -1\n",
      "2023-03-02  1.066875  1.067290  1.057660  1.05967    -1.0     -1.0        -1\n",
      "2023-03-03  1.059780  1.063875  1.058835  1.06351    -1.0     -1.0        -1), (Timestamp('2023-03-12 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-03-06  1.062550  1.069450  1.062225  1.068035    -1.0     -1.0        -1\n",
      "2023-03-07  1.068110  1.069455  1.054615  1.054960    -1.0     -1.0        -1\n",
      "2023-03-08  1.054825  1.057410  1.052440  1.054540    -1.0     -1.0        -1\n",
      "2023-03-09  1.054825  1.059130  1.053810  1.058065    -1.0     -1.0        -1\n",
      "2023-03-10  1.058275  1.070095  1.057400  1.064180    -1.0     -1.0        -1), (Timestamp('2023-03-19 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-03-13  1.067875  1.074855  1.065030  1.073120    -1.0     -1.0        -1\n",
      "2023-03-14  1.072850  1.074985  1.067885  1.073285    -1.0     -1.0        -1\n",
      "2023-03-15  1.073575  1.075990  1.051615  1.057730    -1.0     -1.0        -1\n",
      "2023-03-16  1.057875  1.063565  1.055115  1.061000    -1.0     -1.0        -1\n",
      "2023-03-17  1.061005  1.068535  1.060940  1.065885    -1.0     -1.0        -1), (Timestamp('2023-03-26 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-03-20  1.068685  1.073105  1.063130  1.072110    -1.0     -1.0        -1\n",
      "2023-03-21  1.071980  1.078870  1.070400  1.076685    -1.0     -1.0        -1\n",
      "2023-03-22  1.076830  1.091250  1.075895  1.085555    -1.0     -1.0        -1\n",
      "2023-03-23  1.085945  1.093005  1.082405  1.083080    -1.0     -1.0        -1\n",
      "2023-03-24  1.083200  1.083895  1.071320  1.075840    -1.0     -1.0        -1), (Timestamp('2023-04-02 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-03-27  1.077225  1.080025  1.074500  1.079755    -1.0     -1.0        -1\n",
      "2023-03-28  1.079650  1.084870  1.079585  1.084460    -1.0     -1.0        -1\n",
      "2023-03-29  1.084350  1.087180  1.081775  1.084425    -1.0     -1.0        -1\n",
      "2023-03-30  1.084305  1.092645  1.082370  1.090570    -1.0     -1.0        -1\n",
      "2023-03-31  1.090600  1.092575  1.083685  1.084075    -1.0     -1.0        -1), (Timestamp('2023-04-09 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-04-03  1.084400  1.091680  1.078830  1.089895    -1.0     -1.0        -1\n",
      "2023-04-04  1.090520  1.097335  1.088280  1.095315    -1.0     -1.0        -1\n",
      "2023-04-05  1.095155  1.096965  1.089105  1.090260    -1.0     -1.0        -1\n",
      "2023-04-06  1.090270  1.093765  1.088460  1.092175    -1.0     -1.0        -1\n",
      "2023-04-07  1.092205  1.092405  1.087635  1.090675    -1.0     -1.0        -1), (Timestamp('2023-04-16 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-04-10  1.091305  1.091730  1.083140  1.085920    -1.0     -1.0        -1\n",
      "2023-04-11  1.086125  1.092810  1.085925  1.091290    -1.0     -1.0        -1\n",
      "2023-04-12  1.091175  1.100055  1.091160  1.099190    -1.0     -1.0        -1\n",
      "2023-04-13  1.099115  1.106780  1.097665  1.104630    -1.0     -1.0        -1\n",
      "2023-04-14  1.104625  1.107585  1.097225  1.099355    -1.0     -1.0        -1), (Timestamp('2023-04-23 00:00:00', freq='W-SUN'),                 open      high       low    close  volume  average  barCount\n",
      "date                                                                        \n",
      "2023-04-17  1.099375  1.099980  1.090920  1.09257    -1.0     -1.0        -1\n",
      "2023-04-18  1.092475  1.098310  1.092245  1.09720    -1.0     -1.0        -1\n",
      "2023-04-19  1.096925  1.098410  1.091740  1.09544    -1.0     -1.0        -1\n",
      "2023-04-20  1.095475  1.098980  1.093355  1.09694    -1.0     -1.0        -1\n",
      "2023-04-21  1.096650  1.099385  1.093795  1.09860    -1.0     -1.0        -1), (Timestamp('2023-04-30 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-04-24  1.099050  1.105025  1.096595  1.104620    -1.0     -1.0        -1\n",
      "2023-04-25  1.104285  1.106710  1.096420  1.097265    -1.0     -1.0        -1\n",
      "2023-04-26  1.097225  1.109565  1.096840  1.103930    -1.0     -1.0        -1\n",
      "2023-04-27  1.103800  1.106355  1.099215  1.102845    -1.0     -1.0        -1\n",
      "2023-04-28  1.102750  1.104500  1.096245  1.102050    -1.0     -1.0        -1), (Timestamp('2023-05-07 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-05-01  1.102100  1.103575  1.096425  1.097545    -1.0     -1.0        -1\n",
      "2023-05-02  1.097600  1.100810  1.094220  1.099780    -1.0     -1.0        -1\n",
      "2023-05-03  1.100200  1.109205  1.099955  1.106245    -1.0     -1.0        -1\n",
      "2023-05-04  1.105925  1.109175  1.098595  1.101230    -1.0     -1.0        -1\n",
      "2023-05-05  1.101225  1.104790  1.096685  1.101975    -1.0     -1.0        -1), (Timestamp('2023-05-14 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-05-08  1.102150  1.105380  1.100020  1.100410    -1.0     -1.0        -1\n",
      "2023-05-09  1.100100  1.100675  1.094110  1.096060    -1.0     -1.0        -1\n",
      "2023-05-10  1.096525  1.100705  1.094150  1.098185    -1.0     -1.0        -1\n",
      "2023-05-11  1.098135  1.099815  1.090020  1.091540    -1.0     -1.0        -1\n",
      "2023-05-12  1.092150  1.093570  1.084795  1.084975    -1.0     -1.0        -1), (Timestamp('2023-05-21 00:00:00', freq='W-SUN'),                 open      high       low    close  volume  average  barCount\n",
      "date                                                                        \n",
      "2023-05-15  1.085400  1.089095  1.084565  1.08743    -1.0     -1.0        -1\n",
      "2023-05-16  1.087445  1.090475  1.085495  1.08628    -1.0     -1.0        -1\n",
      "2023-05-17  1.086375  1.087365  1.081030  1.08396    -1.0     -1.0        -1\n",
      "2023-05-18  1.083980  1.084810  1.076255  1.07700    -1.0     -1.0        -1\n",
      "2023-05-19  1.077030  1.082890  1.075985  1.08025    -1.0     -1.0        -1), (Timestamp('2023-05-28 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-05-22  1.080555  1.083135  1.079550  1.081265    -1.0     -1.0        -1\n",
      "2023-05-23  1.081550  1.082060  1.076025  1.076965    -1.0     -1.0        -1\n",
      "2023-05-24  1.077155  1.080135  1.074830  1.074980    -1.0     -1.0        -1\n",
      "2023-05-25  1.075290  1.075685  1.070735  1.072495    -1.0     -1.0        -1\n",
      "2023-05-26  1.072610  1.075880  1.070180  1.072140    -1.0     -1.0        -1), (Timestamp('2023-06-04 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-05-29  1.072410  1.074360  1.070545  1.070780    -1.0     -1.0        -1\n",
      "2023-05-30  1.071090  1.074665  1.067245  1.073470    -1.0     -1.0        -1\n",
      "2023-05-31  1.073185  1.073575  1.063510  1.068920    -1.0     -1.0        -1\n",
      "2023-06-01  1.068215  1.076850  1.066180  1.076175    -1.0     -1.0        -1\n",
      "2023-06-02  1.076055  1.077910  1.070515  1.070780    -1.0     -1.0        -1), (Timestamp('2023-06-11 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-06-05  1.070980  1.072255  1.067450  1.071310    -1.0     -1.0        -1\n",
      "2023-06-06  1.071215  1.073290  1.066705  1.069255    -1.0     -1.0        -1\n",
      "2023-06-07  1.069570  1.073975  1.066835  1.069860    -1.0     -1.0        -1\n",
      "2023-06-08  1.069810  1.078715  1.069675  1.078230    -1.0     -1.0        -1\n",
      "2023-06-09  1.078100  1.078525  1.074285  1.074765    -1.0     -1.0        -1), (Timestamp('2023-06-18 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-06-12  1.074970  1.079040  1.073310  1.075590    -1.0     -1.0        -1\n",
      "2023-06-13  1.075475  1.082365  1.075470  1.079340    -1.0     -1.0        -1\n",
      "2023-06-14  1.079255  1.086425  1.077385  1.082895    -1.0     -1.0        -1\n",
      "2023-06-15  1.082900  1.095280  1.080385  1.094485    -1.0     -1.0        -1\n",
      "2023-06-16  1.093900  1.097075  1.091775  1.093040    -1.0     -1.0        -1), (Timestamp('2023-06-25 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-06-19  1.093555  1.094645  1.090715  1.092150    -1.0     -1.0        -1\n",
      "2023-06-20  1.092180  1.094630  1.089215  1.091800    -1.0     -1.0        -1\n",
      "2023-06-21  1.091705  1.099090  1.090565  1.098630    -1.0     -1.0        -1\n",
      "2023-06-22  1.098630  1.101240  1.094850  1.095590    -1.0     -1.0        -1\n",
      "2023-06-23  1.095740  1.095915  1.084430  1.089175    -1.0     -1.0        -1), (Timestamp('2023-07-02 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-06-26  1.089865  1.092025  1.088725  1.090590    -1.0     -1.0        -1\n",
      "2023-06-27  1.090855  1.097670  1.090200  1.096040    -1.0     -1.0        -1\n",
      "2023-06-28  1.096035  1.096290  1.089665  1.091315    -1.0     -1.0        -1\n",
      "2023-06-29  1.091685  1.094145  1.086030  1.086430    -1.0     -1.0        -1\n",
      "2023-06-30  1.086605  1.093180  1.083525  1.091150    -1.0     -1.0        -1), (Timestamp('2023-07-09 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-07-03  1.091190  1.093415  1.087025  1.091190    -1.0     -1.0        -1\n",
      "2023-07-04  1.091185  1.091650  1.087680  1.087925    -1.0     -1.0        -1\n",
      "2023-07-05  1.088405  1.090800  1.085100  1.085440    -1.0     -1.0        -1\n",
      "2023-07-06  1.085695  1.090070  1.083350  1.088785    -1.0     -1.0        -1\n",
      "2023-07-07  1.088850  1.097330  1.086690  1.096535    -1.0     -1.0        -1), (Timestamp('2023-07-16 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-07-10  1.096545  1.100155  1.094350  1.100130    -1.0     -1.0        -1\n",
      "2023-07-11  1.100150  1.102715  1.097705  1.100890    -1.0     -1.0        -1\n",
      "2023-07-12  1.100600  1.114045  1.100600  1.112875    -1.0     -1.0        -1\n",
      "2023-07-13  1.113295  1.122800  1.112850  1.122630    -1.0     -1.0        -1\n",
      "2023-07-14  1.122140  1.124495  1.120420  1.122575    -1.0     -1.0        -1), (Timestamp('2023-07-23 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-07-17  1.123385  1.124895  1.120345  1.123535    -1.0     -1.0        -1\n",
      "2023-07-18  1.124035  1.127580  1.120890  1.122830    -1.0     -1.0        -1\n",
      "2023-07-19  1.122860  1.124015  1.117435  1.119960    -1.0     -1.0        -1\n",
      "2023-07-20  1.120105  1.122915  1.111845  1.112950    -1.0     -1.0        -1\n",
      "2023-07-21  1.113320  1.114510  1.110790  1.112345    -1.0     -1.0        -1), (Timestamp('2023-07-30 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-07-24  1.112650  1.114700  1.106030  1.106435    -1.0     -1.0        -1\n",
      "2023-07-25  1.106525  1.108695  1.102085  1.105340    -1.0     -1.0        -1\n",
      "2023-07-26  1.105460  1.110680  1.103785  1.108595    -1.0     -1.0        -1\n",
      "2023-07-27  1.108500  1.115000  1.096550  1.097650    -1.0     -1.0        -1\n",
      "2023-07-28  1.097800  1.104800  1.094350  1.101450    -1.0     -1.0        -1), (Timestamp('2023-08-06 00:00:00', freq='W-SUN'),                open     high      low    close  volume  average  barCount\n",
      "date                                                                     \n",
      "2023-07-31  1.10190  1.10460  1.09935  1.09970    -1.0     -1.0        -1\n",
      "2023-08-01  1.09955  1.10030  1.09520  1.09845    -1.0     -1.0        -1\n",
      "2023-08-02  1.09825  1.10205  1.09175  1.09380    -1.0     -1.0        -1\n",
      "2023-08-03  1.09390  1.09630  1.09120  1.09490    -1.0     -1.0        -1\n",
      "2023-08-04  1.09450  1.10425  1.09345  1.10075    -1.0     -1.0        -1), (Timestamp('2023-08-13 00:00:00', freq='W-SUN'),                open     high     low    close  volume  average  barCount\n",
      "date                                                                    \n",
      "2023-08-07  1.10145  1.10195  1.0965  1.10025    -1.0     -1.0        -1\n",
      "2023-08-08  1.10030  1.10115  1.0929  1.09565    -1.0     -1.0        -1\n",
      "2023-08-09  1.09555  1.09955  1.0952  1.09740    -1.0     -1.0        -1\n",
      "2023-08-10  1.09760  1.10655  1.0967  1.09810    -1.0     -1.0        -1\n",
      "2023-08-11  1.09825  1.10055  1.0943  1.09475    -1.0     -1.0        -1), (Timestamp('2023-08-20 00:00:00', freq='W-SUN'),                open     high      low    close  volume  average  barCount\n",
      "date                                                                     \n",
      "2023-08-14  1.09535  1.09605  1.08745  1.09055    -1.0     -1.0        -1\n",
      "2023-08-15  1.09085  1.09525  1.08965  1.09060    -1.0     -1.0        -1\n",
      "2023-08-16  1.09040  1.09350  1.08715  1.08795    -1.0     -1.0        -1\n",
      "2023-08-17  1.08795  1.09190  1.08560  1.08725    -1.0     -1.0        -1\n",
      "2023-08-18  1.08680  1.08940  1.08450  1.08730    -1.0     -1.0        -1), (Timestamp('2023-08-27 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-08-21  1.087215  1.091385  1.086965  1.089590    -1.0     -1.0        -1\n",
      "2023-08-22  1.089430  1.093035  1.083300  1.084565    -1.0     -1.0        -1\n",
      "2023-08-23  1.084350  1.087170  1.080245  1.086295    -1.0     -1.0        -1\n",
      "2023-08-24  1.086595  1.087675  1.080505  1.081045    -1.0     -1.0        -1\n",
      "2023-08-25  1.081120  1.084205  1.076585  1.079610    -1.0     -1.0        -1), (Timestamp('2023-09-03 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-08-28  1.079655  1.082235  1.079350  1.081890    -1.0     -1.0        -1\n",
      "2023-08-29  1.081715  1.089195  1.078215  1.088010    -1.0     -1.0        -1\n",
      "2023-08-30  1.087625  1.094570  1.085520  1.092320    -1.0     -1.0        -1\n",
      "2023-08-31  1.092225  1.093965  1.083520  1.084345    -1.0     -1.0        -1\n",
      "2023-09-01  1.084185  1.088220  1.077215  1.078160    -1.0     -1.0        -1), (Timestamp('2023-09-10 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-09-04  1.077985  1.080895  1.077160  1.079505    -1.0     -1.0        -1\n",
      "2023-09-05  1.079250  1.079845  1.070615  1.072220    -1.0     -1.0        -1\n",
      "2023-09-06  1.072405  1.074895  1.070275  1.072740    -1.0     -1.0        -1\n",
      "2023-09-07  1.072425  1.073190  1.068605  1.069640    -1.0     -1.0        -1\n",
      "2023-09-08  1.069725  1.074395  1.069420  1.069915    -1.0     -1.0        -1), (Timestamp('2023-09-17 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-09-11  1.070745  1.075940  1.070745  1.075025    -1.0     -1.0        -1\n",
      "2023-09-12  1.074775  1.076935  1.070555  1.075395    -1.0     -1.0        -1\n",
      "2023-09-13  1.075475  1.076500  1.071110  1.072965    -1.0     -1.0        -1\n",
      "2023-09-14  1.072995  1.075225  1.063195  1.064310    -1.0     -1.0        -1\n",
      "2023-09-15  1.064320  1.068790  1.063335  1.065625    -1.0     -1.0        -1), (Timestamp('2023-09-24 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-09-18  1.066380  1.069880  1.065465  1.069185    -1.0     -1.0        -1\n",
      "2023-09-19  1.069175  1.071805  1.067515  1.067925    -1.0     -1.0        -1\n",
      "2023-09-20  1.067835  1.073690  1.065010  1.066085    -1.0     -1.0        -1\n",
      "2023-09-21  1.066035  1.067365  1.061695  1.066165    -1.0     -1.0        -1\n",
      "2023-09-22  1.065965  1.067190  1.061505  1.065600    -1.0     -1.0        -1), (Timestamp('2023-10-01 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-09-25  1.065355  1.065565  1.057535  1.059320    -1.0     -1.0        -1\n",
      "2023-09-26  1.059395  1.060915  1.056220  1.057255    -1.0     -1.0        -1\n",
      "2023-09-27  1.057015  1.057435  1.048815  1.050240    -1.0     -1.0        -1\n",
      "2023-09-28  1.050835  1.057895  1.049110  1.056555    -1.0     -1.0        -1\n",
      "2023-09-29  1.056115  1.061710  1.055795  1.057405    -1.0     -1.0        -1), (Timestamp('2023-10-08 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-10-02  1.057350  1.059190  1.047705  1.047735    -1.0     -1.0        -1\n",
      "2023-10-03  1.047935  1.049375  1.044835  1.046650    -1.0     -1.0        -1\n",
      "2023-10-04  1.046795  1.053235  1.045135  1.050390    -1.0     -1.0        -1\n",
      "2023-10-05  1.050770  1.055190  1.050005  1.054925    -1.0     -1.0        -1\n",
      "2023-10-06  1.054735  1.060025  1.048230  1.058535    -1.0     -1.0        -1), (Timestamp('2023-10-15 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-10-09  1.055400  1.057445  1.051960  1.056680    -1.0     -1.0        -1\n",
      "2023-10-10  1.056700  1.061990  1.055440  1.060525    -1.0     -1.0        -1\n",
      "2023-10-11  1.060390  1.063480  1.058085  1.061970    -1.0     -1.0        -1\n",
      "2023-10-12  1.061995  1.063985  1.052575  1.052835    -1.0     -1.0        -1\n",
      "2023-10-13  1.053065  1.055855  1.049550  1.051105    -1.0     -1.0        -1), (Timestamp('2023-10-22 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-10-16  1.051275  1.056285  1.051035  1.056040    -1.0     -1.0        -1\n",
      "2023-10-17  1.055965  1.059495  1.053295  1.057720    -1.0     -1.0        -1\n",
      "2023-10-18  1.057705  1.059445  1.052315  1.053675    -1.0     -1.0        -1\n",
      "2023-10-19  1.053540  1.061680  1.052815  1.058250    -1.0     -1.0        -1\n",
      "2023-10-20  1.058330  1.060375  1.056495  1.059450    -1.0     -1.0        -1), (Timestamp('2023-10-29 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-10-23  1.059695  1.067805  1.057150  1.066990    -1.0     -1.0        -1\n",
      "2023-10-24  1.066635  1.069470  1.058300  1.059000    -1.0     -1.0        -1\n",
      "2023-10-25  1.059480  1.060685  1.056575  1.056645    -1.0     -1.0        -1\n",
      "2023-10-26  1.056875  1.056930  1.052185  1.056255    -1.0     -1.0        -1\n",
      "2023-10-27  1.055790  1.059725  1.053525  1.056360    -1.0     -1.0        -1), (Timestamp('2023-11-05 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-10-30  1.056580  1.062530  1.054725  1.061520    -1.0     -1.0        -1\n",
      "2023-10-31  1.061605  1.067500  1.055755  1.057440    -1.0     -1.0        -1\n",
      "2023-11-01  1.057455  1.058085  1.051675  1.057030    -1.0     -1.0        -1\n",
      "2023-11-02  1.056985  1.066765  1.056775  1.062175    -1.0     -1.0        -1\n",
      "2023-11-03  1.061900  1.074675  1.061490  1.072980    -1.0     -1.0        -1), (Timestamp('2023-11-12 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-11-06  1.072525  1.075630  1.071640  1.071730    -1.0     -1.0        -1\n",
      "2023-11-07  1.071715  1.072240  1.066415  1.070010    -1.0     -1.0        -1\n",
      "2023-11-08  1.070145  1.071615  1.065935  1.070910    -1.0     -1.0        -1\n",
      "2023-11-09  1.070745  1.072555  1.066020  1.066785    -1.0     -1.0        -1\n",
      "2023-11-10  1.066905  1.069285  1.065610  1.068355    -1.0     -1.0        -1), (Timestamp('2023-11-19 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-11-13  1.068415  1.070635  1.066505  1.069835    -1.0     -1.0        -1\n",
      "2023-11-14  1.069980  1.088760  1.069300  1.087900    -1.0     -1.0        -1\n",
      "2023-11-15  1.087910  1.088650  1.083170  1.084735    -1.0     -1.0        -1\n",
      "2023-11-16  1.084845  1.089580  1.083005  1.085225    -1.0     -1.0        -1\n",
      "2023-11-17  1.084760  1.091625  1.082485  1.090715    -1.0     -1.0        -1), (Timestamp('2023-11-26 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-11-20  1.091050  1.095195  1.089755  1.094005    -1.0     -1.0        -1\n",
      "2023-11-21  1.093990  1.096520  1.090015  1.091075    -1.0     -1.0        -1\n",
      "2023-11-22  1.091000  1.092305  1.085230  1.088835    -1.0     -1.0        -1\n",
      "2023-11-23  1.088785  1.093110  1.088315  1.090450    -1.0     -1.0        -1\n",
      "2023-11-24  1.090275  1.094865  1.089505  1.093705    -1.0     -1.0        -1), (Timestamp('2023-12-03 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-11-27  1.094400  1.095940  1.092505  1.095335    -1.0     -1.0        -1\n",
      "2023-11-28  1.095375  1.100905  1.093455  1.099270    -1.0     -1.0        -1\n",
      "2023-11-29  1.099425  1.101730  1.096015  1.096920    -1.0     -1.0        -1\n",
      "2023-11-30  1.096950  1.098395  1.087940  1.088780    -1.0     -1.0        -1\n",
      "2023-12-01  1.088585  1.091285  1.082880  1.088345    -1.0     -1.0        -1), (Timestamp('2023-12-10 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-12-04  1.088235  1.089495  1.080405  1.083620    -1.0     -1.0        -1\n",
      "2023-12-05  1.083315  1.084755  1.077810  1.079640    -1.0     -1.0        -1\n",
      "2023-12-06  1.079510  1.080485  1.075875  1.076415    -1.0     -1.0        -1\n",
      "2023-12-07  1.076445  1.081775  1.075515  1.079385    -1.0     -1.0        -1\n",
      "2023-12-08  1.079300  1.080075  1.072335  1.076500    -1.0     -1.0        -1), (Timestamp('2023-12-17 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-12-11  1.076045  1.077905  1.074165  1.076480    -1.0     -1.0        -1\n",
      "2023-12-12  1.076275  1.082870  1.076105  1.079430    -1.0     -1.0        -1\n",
      "2023-12-13  1.079480  1.089670  1.077315  1.087425    -1.0     -1.0        -1\n",
      "2023-12-14  1.087600  1.100945  1.087345  1.099345    -1.0     -1.0        -1\n",
      "2023-12-15  1.099630  1.100380  1.088845  1.089625    -1.0     -1.0        -1), (Timestamp('2023-12-24 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-12-18  1.089575  1.093125  1.089215  1.092355    -1.0     -1.0        -1\n",
      "2023-12-19  1.091900  1.098745  1.091480  1.098085    -1.0     -1.0        -1\n",
      "2023-12-20  1.099330  1.099330  1.092970  1.094150    -1.0     -1.0        -1\n",
      "2023-12-21  1.094075  1.101270  1.093530  1.101120    -1.0     -1.0        -1\n",
      "2023-12-22  1.100250  1.104035  1.099385  1.101260    -1.0     -1.0        -1), (Timestamp('2023-12-31 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2023-12-26  1.101895  1.104510  1.100870  1.104235    -1.0     -1.0        -1\n",
      "2023-12-27  1.104200  1.112280  1.102845  1.110510    -1.0     -1.0        -1\n",
      "2023-12-28  1.110215  1.113950  1.105520  1.106120    -1.0     -1.0        -1\n",
      "2023-12-29  1.106445  1.108455  1.103815  1.104095    -1.0     -1.0        -1), (Timestamp('2024-01-07 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-01-02  1.103655  1.104335  1.093830  1.094105    -1.0     -1.0        -1\n",
      "2024-01-03  1.094415  1.096550  1.089295  1.092155    -1.0     -1.0        -1\n",
      "2024-01-04  1.091865  1.097235  1.091600  1.094480    -1.0     -1.0        -1\n",
      "2024-01-05  1.094840  1.099865  1.087695  1.094040    -1.0     -1.0        -1), (Timestamp('2024-01-14 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-01-08  1.094680  1.097895  1.092260  1.095035    -1.0     -1.0        -1\n",
      "2024-01-09  1.095465  1.096645  1.091025  1.093105    -1.0     -1.0        -1\n",
      "2024-01-10  1.092830  1.097325  1.092300  1.097270    -1.0     -1.0        -1\n",
      "2024-01-11  1.096995  1.100050  1.093015  1.097225    -1.0     -1.0        -1\n",
      "2024-01-12  1.097345  1.098695  1.093590  1.095090    -1.0     -1.0        -1), (Timestamp('2024-01-21 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-01-15  1.094790  1.096765  1.093355  1.095030    -1.0     -1.0        -1\n",
      "2024-01-16  1.094955  1.095115  1.086200  1.087535    -1.0     -1.0        -1\n",
      "2024-01-17  1.087280  1.088465  1.084445  1.088285    -1.0     -1.0        -1\n",
      "2024-01-18  1.088135  1.090695  1.084665  1.087645    -1.0     -1.0        -1\n",
      "2024-01-19  1.087175  1.089875  1.086565  1.089755    -1.0     -1.0        -1), (Timestamp('2024-01-28 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-01-22  1.088910  1.090965  1.088000  1.088275    -1.0     -1.0        -1\n",
      "2024-01-23  1.088395  1.091635  1.082165  1.085435    -1.0     -1.0        -1\n",
      "2024-01-24  1.085050  1.093245  1.085045  1.088500    -1.0     -1.0        -1\n",
      "2024-01-25  1.088525  1.090205  1.082155  1.084620    -1.0     -1.0        -1\n",
      "2024-01-26  1.084725  1.088625  1.081285  1.085355    -1.0     -1.0        -1), (Timestamp('2024-02-04 00:00:00', freq='W-SUN'),                open      high       low     close  volume  average  barCount\n",
      "date                                                                        \n",
      "2024-01-29  1.08439  1.085020  1.079595  1.083215    -1.0     -1.0        -1\n",
      "2024-01-30  1.08335  1.085750  1.081195  1.084550    -1.0     -1.0        -1\n",
      "2024-01-31  1.08433  1.088760  1.079485  1.081835    -1.0     -1.0        -1\n",
      "2024-02-01  1.08190  1.087485  1.077990  1.087160    -1.0     -1.0        -1\n",
      "2024-02-02  1.08717  1.089760  1.078055  1.078805    -1.0     -1.0        -1), (Timestamp('2024-02-11 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-02-05  1.078335  1.078735  1.072325  1.074275    -1.0     -1.0        -1\n",
      "2024-02-06  1.074250  1.076245  1.072255  1.075430    -1.0     -1.0        -1\n",
      "2024-02-07  1.075550  1.078405  1.075160  1.077165    -1.0     -1.0        -1\n",
      "2024-02-08  1.077120  1.078895  1.074155  1.077750    -1.0     -1.0        -1\n",
      "2024-02-09  1.077870  1.079570  1.076220  1.078415    -1.0     -1.0        -1), (Timestamp('2024-02-18 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-02-12  1.078295  1.080565  1.075595  1.077170    -1.0     -1.0        -1\n",
      "2024-02-13  1.077315  1.079995  1.070050  1.070865    -1.0     -1.0        -1\n",
      "2024-02-14  1.071100  1.073460  1.069500  1.072725    -1.0     -1.0        -1\n",
      "2024-02-15  1.072835  1.078490  1.072475  1.077225    -1.0     -1.0        -1\n",
      "2024-02-16  1.077205  1.078755  1.073205  1.077555    -1.0     -1.0        -1), (Timestamp('2024-02-25 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-02-19  1.077700  1.078955  1.076205  1.077950    -1.0     -1.0        -1\n",
      "2024-02-20  1.077885  1.083880  1.076170  1.080780    -1.0     -1.0        -1\n",
      "2024-02-21  1.080725  1.082455  1.079000  1.081885    -1.0     -1.0        -1\n",
      "2024-02-22  1.082040  1.088860  1.080280  1.082285    -1.0     -1.0        -1\n",
      "2024-02-23  1.082650  1.083975  1.081185  1.082050    -1.0     -1.0        -1), (Timestamp('2024-03-03 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-02-26  1.081860  1.085980  1.081270  1.085105    -1.0     -1.0        -1\n",
      "2024-02-27  1.084985  1.086595  1.083300  1.084395    -1.0     -1.0        -1\n",
      "2024-02-28  1.084620  1.084810  1.079665  1.083820    -1.0     -1.0        -1\n",
      "2024-02-29  1.083475  1.085600  1.079575  1.080545    -1.0     -1.0        -1\n",
      "2024-03-01  1.080575  1.084335  1.079810  1.083555    -1.0     -1.0        -1), (Timestamp('2024-03-10 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-03-04  1.083965  1.086685  1.083780  1.085565    -1.0     -1.0        -1\n",
      "2024-03-05  1.085540  1.087625  1.084010  1.085670    -1.0     -1.0        -1\n",
      "2024-03-06  1.085510  1.091545  1.084215  1.089875    -1.0     -1.0        -1\n",
      "2024-03-07  1.089970  1.094930  1.086790  1.094785    -1.0     -1.0        -1\n",
      "2024-03-08  1.094690  1.098135  1.091850  1.093950    -1.0     -1.0        -1), (Timestamp('2024-03-17 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-03-11  1.094045  1.094815  1.091455  1.092565    -1.0     -1.0        -1\n",
      "2024-03-12  1.092505  1.094400  1.090165  1.092665    -1.0     -1.0        -1\n",
      "2024-03-13  1.092700  1.096385  1.092005  1.094770    -1.0     -1.0        -1\n",
      "2024-03-14  1.095100  1.095490  1.088065  1.088305    -1.0     -1.0        -1\n",
      "2024-03-15  1.088475  1.089975  1.087300  1.088770    -1.0     -1.0        -1), (Timestamp('2024-03-24 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-03-18  1.088495  1.090625  1.086615  1.087225    -1.0     -1.0        -1\n",
      "2024-03-19  1.087350  1.087655  1.083470  1.086580    -1.0     -1.0        -1\n",
      "2024-03-20  1.086505  1.092285  1.083645  1.092200    -1.0     -1.0        -1\n",
      "2024-03-21  1.092110  1.094265  1.085545  1.085990    -1.0     -1.0        -1\n",
      "2024-03-22  1.086035  1.086815  1.080175  1.080750    -1.0     -1.0        -1), (Timestamp('2024-03-31 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-03-25  1.080885  1.084255  1.080215  1.083730    -1.0     -1.0        -1\n",
      "2024-03-26  1.083730  1.086435  1.082435  1.083115    -1.0     -1.0        -1\n",
      "2024-03-27  1.083225  1.083915  1.081085  1.082760    -1.0     -1.0        -1\n",
      "2024-03-28  1.082660  1.082800  1.077505  1.078850    -1.0     -1.0        -1\n",
      "2024-03-29  1.078980  1.080565  1.076830  1.079270    -1.0     -1.0        -1), (Timestamp('2024-04-07 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-04-01  1.079805  1.079890  1.073100  1.074305    -1.0     -1.0        -1\n",
      "2024-04-02  1.074160  1.077905  1.072465  1.076935    -1.0     -1.0        -1\n",
      "2024-04-03  1.077065  1.083690  1.076410  1.083600    -1.0     -1.0        -1\n",
      "2024-04-04  1.083470  1.087665  1.083185  1.083700    -1.0     -1.0        -1\n",
      "2024-04-05  1.083615  1.084805  1.079135  1.083785    -1.0     -1.0        -1), (Timestamp('2024-04-14 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-04-08  1.083745  1.086225  1.082085  1.085925    -1.0     -1.0        -1\n",
      "2024-04-09  1.085830  1.088520  1.084765  1.085700    -1.0     -1.0        -1\n",
      "2024-04-10  1.085695  1.086655  1.072885  1.074250    -1.0     -1.0        -1\n",
      "2024-04-11  1.074465  1.075660  1.069920  1.072590    -1.0     -1.0        -1\n",
      "2024-04-12  1.072865  1.072945  1.062255  1.064175    -1.0     -1.0        -1), (Timestamp('2024-04-21 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-04-15  1.063870  1.066520  1.062040  1.062435    -1.0     -1.0        -1\n",
      "2024-04-16  1.062500  1.065375  1.060125  1.061875    -1.0     -1.0        -1\n",
      "2024-04-17  1.062250  1.067975  1.060605  1.067275    -1.0     -1.0        -1\n",
      "2024-04-18  1.067020  1.069015  1.064145  1.064325    -1.0     -1.0        -1\n",
      "2024-04-19  1.064405  1.067775  1.061050  1.065525    -1.0     -1.0        -1), (Timestamp('2024-04-28 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-04-22  1.066240  1.067075  1.062400  1.065455    -1.0     -1.0        -1\n",
      "2024-04-23  1.065520  1.071140  1.063865  1.070130    -1.0     -1.0        -1\n",
      "2024-04-24  1.070330  1.071445  1.067810  1.069900    -1.0     -1.0        -1\n",
      "2024-04-25  1.069715  1.074090  1.067830  1.072960    -1.0     -1.0        -1\n",
      "2024-04-26  1.072950  1.075295  1.067395  1.069360    -1.0     -1.0        -1), (Timestamp('2024-05-05 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-04-29  1.069700  1.073380  1.069020  1.072065    -1.0     -1.0        -1\n",
      "2024-04-30  1.072155  1.073545  1.066485  1.066580    -1.0     -1.0        -1\n",
      "2024-05-01  1.067380  1.073265  1.064945  1.071110    -1.0     -1.0        -1\n",
      "2024-05-02  1.071385  1.073025  1.067420  1.072515    -1.0     -1.0        -1\n",
      "2024-05-03  1.072515  1.081300  1.072410  1.076250    -1.0     -1.0        -1), (Timestamp('2024-05-12 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-05-06  1.076225  1.079080  1.075530  1.076870    -1.0     -1.0        -1\n",
      "2024-05-07  1.076815  1.078745  1.074795  1.075475    -1.0     -1.0        -1\n",
      "2024-05-08  1.075585  1.075755  1.073510  1.074850    -1.0     -1.0        -1\n",
      "2024-05-09  1.074780  1.078465  1.072395  1.078225    -1.0     -1.0        -1\n",
      "2024-05-10  1.078165  1.079025  1.076035  1.077140    -1.0     -1.0        -1), (Timestamp('2024-05-19 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-05-13  1.077165  1.080685  1.076575  1.078975    -1.0     -1.0        -1\n",
      "2024-05-14  1.078920  1.082575  1.076710  1.081900    -1.0     -1.0        -1\n",
      "2024-05-15  1.081730  1.088620  1.081310  1.088440    -1.0     -1.0        -1\n",
      "2024-05-16  1.088155  1.089505  1.085450  1.086700    -1.0     -1.0        -1\n",
      "2024-05-17  1.086720  1.087855  1.083565  1.086890    -1.0     -1.0        -1), (Timestamp('2024-05-26 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-05-20  1.086830  1.088445  1.085405  1.085675    -1.0     -1.0        -1\n",
      "2024-05-21  1.085735  1.087480  1.084270  1.085385    -1.0     -1.0        -1\n",
      "2024-05-22  1.085410  1.086355  1.081735  1.082265    -1.0     -1.0        -1\n",
      "2024-05-23  1.082365  1.086105  1.080485  1.081515    -1.0     -1.0        -1\n",
      "2024-05-24  1.081500  1.085800  1.080560  1.084700    -1.0     -1.0        -1), (Timestamp('2024-06-02 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-05-27  1.084650  1.086745  1.084070  1.085860    -1.0     -1.0        -1\n",
      "2024-05-28  1.085985  1.088910  1.085490  1.085665    -1.0     -1.0        -1\n",
      "2024-05-29  1.086200  1.086200  1.080010  1.080125    -1.0     -1.0        -1\n",
      "2024-05-30  1.080165  1.084520  1.078835  1.083180    -1.0     -1.0        -1\n",
      "2024-05-31  1.083365  1.088235  1.081125  1.084740    -1.0     -1.0        -1), (Timestamp('2024-06-09 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-06-03  1.084725  1.090485  1.082785  1.090440    -1.0     -1.0        -1\n",
      "2024-06-04  1.090255  1.091605  1.085895  1.087915    -1.0     -1.0        -1\n",
      "2024-06-05  1.088040  1.089190  1.085450  1.086845    -1.0     -1.0        -1\n",
      "2024-06-06  1.087135  1.090210  1.086195  1.088885    -1.0     -1.0        -1\n",
      "2024-06-07  1.089115  1.090290  1.079960  1.080165    -1.0     -1.0        -1), (Timestamp('2024-06-16 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-06-10  1.076965  1.078160  1.073265  1.076505    -1.0     -1.0        -1\n",
      "2024-06-11  1.076445  1.077355  1.071955  1.074050    -1.0     -1.0        -1\n",
      "2024-06-12  1.074195  1.085235  1.073465  1.080895    -1.0     -1.0        -1\n",
      "2024-06-13  1.080890  1.081650  1.073255  1.073710    -1.0     -1.0        -1\n",
      "2024-06-14  1.073945  1.074495  1.066760  1.070655    -1.0     -1.0        -1), (Timestamp('2024-06-23 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-06-17  1.070555  1.073780  1.068640  1.073440    -1.0     -1.0        -1\n",
      "2024-06-18  1.073310  1.076150  1.071005  1.073955    -1.0     -1.0        -1\n",
      "2024-06-19  1.074025  1.075345  1.072485  1.074345    -1.0     -1.0        -1\n",
      "2024-06-20  1.074665  1.074880  1.070170  1.070210    -1.0     -1.0        -1\n",
      "2024-06-21  1.070270  1.072055  1.067105  1.069230    -1.0     -1.0        -1), (Timestamp('2024-06-30 00:00:00', freq='W-SUN'),                 open      high       low    close  volume  average  barCount\n",
      "date                                                                        \n",
      "2024-06-24  1.069065  1.074645  1.068370  1.07329    -1.0     -1.0        -1\n",
      "2024-06-25  1.073395  1.074425  1.069075  1.07144    -1.0     -1.0        -1\n",
      "2024-06-26  1.071290  1.071805  1.066610  1.06806    -1.0     -1.0        -1\n",
      "2024-06-27  1.067900  1.072645  1.067705  1.07039    -1.0     -1.0        -1\n",
      "2024-06-28  1.070360  1.072485  1.068540  1.07127    -1.0     -1.0        -1), (Timestamp('2024-07-07 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-07-01  1.074315  1.077655  1.071955  1.074055    -1.0     -1.0        -1\n",
      "2024-07-02  1.073800  1.074725  1.071005  1.074520    -1.0     -1.0        -1\n",
      "2024-07-03  1.074560  1.081685  1.073625  1.078665    -1.0     -1.0        -1\n",
      "2024-07-04  1.078795  1.081405  1.078350  1.081270    -1.0     -1.0        -1\n",
      "2024-07-05  1.081180  1.084275  1.079940  1.084005    -1.0     -1.0        -1), (Timestamp('2024-07-14 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-07-08  1.081430  1.084525  1.081300  1.082395    -1.0     -1.0        -1\n",
      "2024-07-09  1.082425  1.083345  1.080540  1.081365    -1.0     -1.0        -1\n",
      "2024-07-10  1.081415  1.083085  1.081095  1.083010    -1.0     -1.0        -1\n",
      "2024-07-11  1.082720  1.090000  1.082720  1.086815    -1.0     -1.0        -1\n",
      "2024-07-12  1.086785  1.091145  1.086175  1.090570    -1.0     -1.0        -1), (Timestamp('2024-07-21 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-07-15  1.089405  1.092245  1.088335  1.089415    -1.0     -1.0        -1\n",
      "2024-07-16  1.089450  1.090550  1.087155  1.089960    -1.0     -1.0        -1\n",
      "2024-07-17  1.089955  1.094825  1.089515  1.093930    -1.0     -1.0        -1\n",
      "2024-07-18  1.093895  1.094105  1.089360  1.089665    -1.0     -1.0        -1\n",
      "2024-07-19  1.089845  1.090190  1.087575  1.088220    -1.0     -1.0        -1), (Timestamp('2024-07-28 00:00:00', freq='W-SUN'),                open      high       low     close  volume  average  barCount\n",
      "date                                                                        \n",
      "2024-07-22  1.08862  1.090295  1.087315  1.089120    -1.0     -1.0        -1\n",
      "2024-07-23  1.08897  1.089670  1.084385  1.085335    -1.0     -1.0        -1\n",
      "2024-07-24  1.08535  1.086665  1.082575  1.083985    -1.0     -1.0        -1\n",
      "2024-07-25  1.08402  1.087005  1.082835  1.084580    -1.0     -1.0        -1\n",
      "2024-07-26  1.08460  1.086825  1.084205  1.085600    -1.0     -1.0        -1), (Timestamp('2024-08-04 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-07-29  1.085925  1.087005  1.080275  1.082115    -1.0     -1.0        -1\n",
      "2024-07-30  1.082330  1.083575  1.079830  1.081505    -1.0     -1.0        -1\n",
      "2024-07-31  1.081485  1.084955  1.080190  1.082570    -1.0     -1.0        -1\n",
      "2024-08-01  1.082500  1.083545  1.077745  1.079155    -1.0     -1.0        -1\n",
      "2024-08-02  1.079185  1.092665  1.078190  1.090910    -1.0     -1.0        -1), (Timestamp('2024-08-11 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-08-05  1.092165  1.100900  1.089250  1.095205    -1.0     -1.0        -1\n",
      "2024-08-06  1.095015  1.096310  1.090375  1.093135    -1.0     -1.0        -1\n",
      "2024-08-07  1.092980  1.093665  1.090545  1.092175    -1.0     -1.0        -1\n",
      "2024-08-08  1.092175  1.094525  1.088145  1.091855    -1.0     -1.0        -1\n",
      "2024-08-09  1.091710  1.093140  1.090915  1.091685    -1.0     -1.0        -1), (Timestamp('2024-08-18 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-08-12  1.091745  1.093945  1.091000  1.093165    -1.0     -1.0        -1\n",
      "2024-08-13  1.093060  1.099970  1.091370  1.099330    -1.0     -1.0        -1\n",
      "2024-08-14  1.099365  1.104760  1.098640  1.101255    -1.0     -1.0        -1\n",
      "2024-08-15  1.101395  1.101580  1.094965  1.097275    -1.0     -1.0        -1\n",
      "2024-08-16  1.097255  1.102980  1.097100  1.102550    -1.0     -1.0        -1), (Timestamp('2024-08-25 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-08-19  1.102640  1.108645  1.102275  1.108505    -1.0     -1.0        -1\n",
      "2024-08-20  1.108540  1.113055  1.107185  1.112980    -1.0     -1.0        -1\n",
      "2024-08-21  1.112625  1.117415  1.109910  1.114970    -1.0     -1.0        -1\n",
      "2024-08-22  1.115000  1.116550  1.109810  1.111230    -1.0     -1.0        -1\n",
      "2024-08-23  1.111160  1.120095  1.110545  1.119050    -1.0     -1.0        -1), (Timestamp('2024-09-01 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-08-26  1.119075  1.120165  1.115005  1.116105    -1.0     -1.0        -1\n",
      "2024-08-27  1.116270  1.119055  1.114995  1.118415    -1.0     -1.0        -1\n",
      "2024-08-28  1.118310  1.118555  1.110505  1.111970    -1.0     -1.0        -1\n",
      "2024-08-29  1.112035  1.113995  1.105575  1.107745    -1.0     -1.0        -1\n",
      "2024-08-30  1.107750  1.109505  1.104385  1.104615    -1.0     -1.0        -1), (Timestamp('2024-09-08 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-09-02  1.104775  1.107750  1.104200  1.107180    -1.0     -1.0        -1\n",
      "2024-09-03  1.107265  1.107290  1.102635  1.104335    -1.0     -1.0        -1\n",
      "2024-09-04  1.103950  1.109505  1.103950  1.108210    -1.0     -1.0        -1\n",
      "2024-09-05  1.108300  1.111975  1.107475  1.111050    -1.0     -1.0        -1\n",
      "2024-09-06  1.111070  1.115570  1.106565  1.108460    -1.0     -1.0        -1), (Timestamp('2024-09-15 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-09-09  1.108385  1.109115  1.103385  1.103445    -1.0     -1.0        -1\n",
      "2024-09-10  1.103770  1.104975  1.101515  1.101965    -1.0     -1.0        -1\n",
      "2024-09-11  1.101945  1.105495  1.100205  1.101205    -1.0     -1.0        -1\n",
      "2024-09-12  1.101395  1.107520  1.100555  1.107445    -1.0     -1.0        -1\n",
      "2024-09-13  1.107375  1.110205  1.107045  1.107205    -1.0     -1.0        -1), (Timestamp('2024-09-22 00:00:00', freq='W-SUN'),                 open      high       low     close  volume  average  barCount\n",
      "date                                                                         \n",
      "2024-09-16  1.107770  1.113765  1.107545  1.113280    -1.0     -1.0        -1\n",
      "2024-09-17  1.113200  1.114635  1.111065  1.111365    -1.0     -1.0        -1\n",
      "2024-09-18  1.111520  1.118935  1.109675  1.111890    -1.0     -1.0        -1\n",
      "2024-09-19  1.111645  1.117895  1.106855  1.116155    -1.0     -1.0        -1\n",
      "2024-09-20  1.116280  1.118195  1.113605  1.116345    -1.0     -1.0        -1), (Timestamp('2024-09-29 00:00:00', freq='W-SUN'),                open      high       low     close  volume  average  barCount\n",
      "date                                                                        \n",
      "2024-09-23  1.11654  1.116730  1.108315  1.111125    -1.0     -1.0        -1\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2024-09-24  1.11131  1.118095  1.110345  1.117965    -1.0     -1.0        -1)]\n"
     ]
    }
   ],
   "source": [
    "print(list(temp. resample(\"W\")))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "fe1baac8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(Timestamp('2022-10-02 00:00:00', freq='W-SUN'),\n",
       "                 open      high       low     close  volume  average  barCount\n",
       " date                                                                         \n",
       " 2022-09-26  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       " 2022-09-27  0.960775  0.967095  0.956925  0.959385    -1.0     -1.0        -1\n",
       " 2022-09-28  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
       " 2022-09-29  0.973725  0.981735  0.963575  0.981575    -1.0     -1.0        -1\n",
       " 2022-09-30  0.981700  0.985405  0.973455  0.980155    -1.0     -1.0        -1)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(temp. resample(\"W\"))[0]\n",
    "# list(temp. resample(\"W\"))[0][0]\n",
    "# list(temp. resample(\"W\"))[0][1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "c17e5fea",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-10-02</th>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-09</th>\n",
       "      <td>0.979600</td>\n",
       "      <td>0.984465</td>\n",
       "      <td>0.975285</td>\n",
       "      <td>0.982575</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-16</th>\n",
       "      <td>0.973575</td>\n",
       "      <td>0.975345</td>\n",
       "      <td>0.968180</td>\n",
       "      <td>0.970190</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-23</th>\n",
       "      <td>0.971950</td>\n",
       "      <td>0.985230</td>\n",
       "      <td>0.971950</td>\n",
       "      <td>0.984235</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-30</th>\n",
       "      <td>0.987675</td>\n",
       "      <td>0.989935</td>\n",
       "      <td>0.980690</td>\n",
       "      <td>0.987450</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</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>2024-09-01</th>\n",
       "      <td>1.119075</td>\n",
       "      <td>1.120165</td>\n",
       "      <td>1.115005</td>\n",
       "      <td>1.116105</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-08</th>\n",
       "      <td>1.104775</td>\n",
       "      <td>1.107750</td>\n",
       "      <td>1.104200</td>\n",
       "      <td>1.107180</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-15</th>\n",
       "      <td>1.108385</td>\n",
       "      <td>1.109115</td>\n",
       "      <td>1.103385</td>\n",
       "      <td>1.103445</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-22</th>\n",
       "      <td>1.107770</td>\n",
       "      <td>1.113765</td>\n",
       "      <td>1.107545</td>\n",
       "      <td>1.113280</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-29</th>\n",
       "      <td>1.116540</td>\n",
       "      <td>1.116730</td>\n",
       "      <td>1.108315</td>\n",
       "      <td>1.111125</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>105 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2022-10-02  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       "2022-10-09  0.979600  0.984465  0.975285  0.982575    -1.0     -1.0        -1\n",
       "2022-10-16  0.973575  0.975345  0.968180  0.970190    -1.0     -1.0        -1\n",
       "2022-10-23  0.971950  0.985230  0.971950  0.984235    -1.0     -1.0        -1\n",
       "2022-10-30  0.987675  0.989935  0.980690  0.987450    -1.0     -1.0        -1\n",
       "...              ...       ...       ...       ...     ...      ...       ...\n",
       "2024-09-01  1.119075  1.120165  1.115005  1.116105    -1.0     -1.0        -1\n",
       "2024-09-08  1.104775  1.107750  1.104200  1.107180    -1.0     -1.0        -1\n",
       "2024-09-15  1.108385  1.109115  1.103385  1.103445    -1.0     -1.0        -1\n",
       "2024-09-22  1.107770  1.113765  1.107545  1.113280    -1.0     -1.0        -1\n",
       "2024-09-29  1.116540  1.116730  1.108315  1.111125    -1.0     -1.0        -1\n",
       "\n",
       "[105 rows x 7 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.resample(\"W\").first()\n",
    "# also available .last .min .max .mean .sum "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "bf79fde6",
   "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>volume</th>\n",
       "      <th>average</th>\n",
       "      <th>barCount</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-27</th>\n",
       "      <td>0.969150</td>\n",
       "      <td>0.970995</td>\n",
       "      <td>0.955210</td>\n",
       "      <td>0.960960</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-04</th>\n",
       "      <td>0.959100</td>\n",
       "      <td>0.975100</td>\n",
       "      <td>0.953580</td>\n",
       "      <td>0.973460</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-11</th>\n",
       "      <td>0.998750</td>\n",
       "      <td>0.999510</td>\n",
       "      <td>0.983485</td>\n",
       "      <td>0.988445</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-18</th>\n",
       "      <td>0.970550</td>\n",
       "      <td>0.973515</td>\n",
       "      <td>0.966775</td>\n",
       "      <td>0.970310</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-10-25</th>\n",
       "      <td>0.986200</td>\n",
       "      <td>0.987265</td>\n",
       "      <td>0.975745</td>\n",
       "      <td>0.977285</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</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>2024-08-27</th>\n",
       "      <td>1.112625</td>\n",
       "      <td>1.117415</td>\n",
       "      <td>1.109910</td>\n",
       "      <td>1.114970</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-03</th>\n",
       "      <td>1.118310</td>\n",
       "      <td>1.118555</td>\n",
       "      <td>1.110505</td>\n",
       "      <td>1.111970</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-10</th>\n",
       "      <td>1.103950</td>\n",
       "      <td>1.109505</td>\n",
       "      <td>1.103950</td>\n",
       "      <td>1.108210</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-17</th>\n",
       "      <td>1.101945</td>\n",
       "      <td>1.105495</td>\n",
       "      <td>1.100205</td>\n",
       "      <td>1.101205</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2024-09-24</th>\n",
       "      <td>1.111520</td>\n",
       "      <td>1.118935</td>\n",
       "      <td>1.109675</td>\n",
       "      <td>1.111890</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>105 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                open      high       low     close  volume  average  barCount\n",
       "date                                                                         \n",
       "2022-09-27  0.969150  0.970995  0.955210  0.960960    -1.0     -1.0        -1\n",
       "2022-10-04  0.959100  0.975100  0.953580  0.973460    -1.0     -1.0        -1\n",
       "2022-10-11  0.998750  0.999510  0.983485  0.988445    -1.0     -1.0        -1\n",
       "2022-10-18  0.970550  0.973515  0.966775  0.970310    -1.0     -1.0        -1\n",
       "2022-10-25  0.986200  0.987265  0.975745  0.977285    -1.0     -1.0        -1\n",
       "...              ...       ...       ...       ...     ...      ...       ...\n",
       "2024-08-27  1.112625  1.117415  1.109910  1.114970    -1.0     -1.0        -1\n",
       "2024-09-03  1.118310  1.118555  1.110505  1.111970    -1.0     -1.0        -1\n",
       "2024-09-10  1.103950  1.109505  1.103950  1.108210    -1.0     -1.0        -1\n",
       "2024-09-17  1.101945  1.105495  1.100205  1.101205    -1.0     -1.0        -1\n",
       "2024-09-24  1.111520  1.118935  1.109675  1.111890    -1.0     -1.0        -1\n",
       "\n",
       "[105 rows x 7 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temp.resample(\"W-Tue\").first() # changes the last day of the week which by default is Sunday\n",
    "# also available M, MS (first day of month used as label, values do not change), Q, Q-Feb, Y, YS\n",
    "# also possible a number before, such as 2D\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "98564ac3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "5c1424a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "ib.disconnect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "580c5b85",
   "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.10.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}