{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "867bfa18",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style>.container { width:80% !important; }</style>"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "from IPython.core.display import display, HTML\n",
    "display(HTML(\"<style>.container { width:80% !important; }</style>\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "419ed573",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/bz/5cj1tzbj5xn319rpqrw6gpmh0000gn/T/ipykernel_9008/758582820.py:17: FutureWarning: The default value of regex will change from True to False in a future version. In addition, single character regular expressions will *not* be treated as literal strings when regex=True.\n",
      "  x_rates.columns = x_rates.columns.str.replace(\"[\",\"\").str.replace(\"]\",\"\")\n"
     ]
    },
    {
     "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: center;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>australian_dollar</th>\n",
       "      <th>bulgarian_lev</th>\n",
       "      <th>brazilian_real</th>\n",
       "      <th>canadian_dollar</th>\n",
       "      <th>swiss_franc</th>\n",
       "      <th>chinese_yuan</th>\n",
       "      <th>cypriot_pound</th>\n",
       "      <th>czech_koruna</th>\n",
       "      <th>danish_krone</th>\n",
       "      <th>estonian_kroon</th>\n",
       "      <th>uk_pound</th>\n",
       "      <th>greek_drachma</th>\n",
       "      <th>hong_kong_dollar</th>\n",
       "      <th>croatian_kuna</th>\n",
       "      <th>hungarian_forint</th>\n",
       "      <th>indonesian_rupiah</th>\n",
       "      <th>israeli_shekel</th>\n",
       "      <th>indian_rupee</th>\n",
       "      <th>iceland_krona</th>\n",
       "      <th>japanese_yen</th>\n",
       "      <th>korean_won</th>\n",
       "      <th>lithuanian_litas</th>\n",
       "      <th>latvian_lats</th>\n",
       "      <th>maltese_lira</th>\n",
       "      <th>mexican_peso</th>\n",
       "      <th>malaysian_ringgit</th>\n",
       "      <th>norwegian_krone</th>\n",
       "      <th>new_zealand_dollar</th>\n",
       "      <th>philippine_peso</th>\n",
       "      <th>polish_zloty</th>\n",
       "      <th>romanian_leu</th>\n",
       "      <th>russian_rouble</th>\n",
       "      <th>swedish_krona</th>\n",
       "      <th>singapore_dollar</th>\n",
       "      <th>slovenian_tolar</th>\n",
       "      <th>slovak_koruna</th>\n",
       "      <th>thai_baht</th>\n",
       "      <th>turkish_lira</th>\n",
       "      <th>us_dollar</th>\n",
       "      <th>south_african_rand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1999-01-04</td>\n",
       "      <td>1.9100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.8004</td>\n",
       "      <td>1.6168</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5823</td>\n",
       "      <td>35.1070</td>\n",
       "      <td>7.4501</td>\n",
       "      <td>15.6466</td>\n",
       "      <td>0.7111</td>\n",
       "      <td>327.1500</td>\n",
       "      <td>9.1332</td>\n",
       "      <td>NaN</td>\n",
       "      <td>251.4800</td>\n",
       "      <td>9,433.6100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.4800</td>\n",
       "      <td>133.7300</td>\n",
       "      <td>1,398.5900</td>\n",
       "      <td>4.7170</td>\n",
       "      <td>0.6668</td>\n",
       "      <td>0.4432</td>\n",
       "      <td>11.6446</td>\n",
       "      <td>4.4798</td>\n",
       "      <td>8.8550</td>\n",
       "      <td>2.2229</td>\n",
       "      <td>45.5100</td>\n",
       "      <td>4.0712</td>\n",
       "      <td>1.3111</td>\n",
       "      <td>25.2875</td>\n",
       "      <td>9.4696</td>\n",
       "      <td>1.9554</td>\n",
       "      <td>189.0450</td>\n",
       "      <td>42.9910</td>\n",
       "      <td>42.6799</td>\n",
       "      <td>0.3723</td>\n",
       "      <td>1.1789</td>\n",
       "      <td>6.9358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1999-01-05</td>\n",
       "      <td>1.8944</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.7965</td>\n",
       "      <td>1.6123</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.5823</td>\n",
       "      <td>34.9170</td>\n",
       "      <td>7.4495</td>\n",
       "      <td>15.6466</td>\n",
       "      <td>0.7122</td>\n",
       "      <td>324.7000</td>\n",
       "      <td>9.1341</td>\n",
       "      <td>NaN</td>\n",
       "      <td>250.8000</td>\n",
       "      <td>9,314.5100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>81.5300</td>\n",
       "      <td>130.9600</td>\n",
       "      <td>1,373.0100</td>\n",
       "      <td>4.7174</td>\n",
       "      <td>0.6657</td>\n",
       "      <td>0.4432</td>\n",
       "      <td>11.5960</td>\n",
       "      <td>4.4805</td>\n",
       "      <td>8.7745</td>\n",
       "      <td>2.2011</td>\n",
       "      <td>44.7450</td>\n",
       "      <td>4.0245</td>\n",
       "      <td>1.3168</td>\n",
       "      <td>26.5876</td>\n",
       "      <td>9.4025</td>\n",
       "      <td>1.9655</td>\n",
       "      <td>188.7750</td>\n",
       "      <td>42.8480</td>\n",
       "      <td>42.5048</td>\n",
       "      <td>0.3728</td>\n",
       "      <td>1.1790</td>\n",
       "      <td>6.7975</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     date      australian_dollar   bulgarian_lev  brazilian_real    canadian_dollar        swiss_franc      chinese_yuan     cypriot_pound        czech_koruna         danish_krone        estonian_kroon          uk_pound           greek_drachma      hong_kong_dollar    croatian_kuna   hungarian_forint     indonesian_rupiah   israeli_shekel  indian_rupee     iceland_krona        japanese_yen          korean_won        lithuanian_litas       latvian_lats         maltese_lira         mexican_peso       malaysian_ringgit     norwegian_krone    new_zealand_dollar     philippine_peso       polish_zloty         romanian_leu        russian_rouble        swedish_krona      singapore_dollar      slovenian_tolar       slovak_koruna          thai_baht          turkish_lira           us_dollar       south_african_rand \n",
       "0 1999-01-04               1.9100      NaN             NaN                     1.8004               1.6168      NaN                    0.5823              35.1070               7.4501              15.6466               0.7111             327.1500               9.1332      NaN                   251.4800           9,433.6100       NaN            NaN                   81.4800             133.7300           1,398.5900               4.7170               0.6668               0.4432              11.6446               4.4798               8.8550               2.2229              45.5100               4.0712               1.3111              25.2875               9.4696               1.9554             189.0450              42.9910              42.6799               0.3723               1.1789               6.9358\n",
       "1 1999-01-05               1.8944      NaN             NaN                     1.7965               1.6123      NaN                    0.5823              34.9170               7.4495              15.6466               0.7122             324.7000               9.1341      NaN                   250.8000           9,314.5100       NaN            NaN                   81.5300             130.9600           1,373.0100               4.7174               0.6657               0.4432              11.5960               4.4805               8.7745               2.2011              44.7450               4.0245               1.3168              26.5876               9.4025               1.9655             188.7750              42.8480              42.5048               0.3728               1.1790               6.7975"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "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: center;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>australian_dollar</th>\n",
       "      <th>bulgarian_lev</th>\n",
       "      <th>brazilian_real</th>\n",
       "      <th>canadian_dollar</th>\n",
       "      <th>swiss_franc</th>\n",
       "      <th>chinese_yuan</th>\n",
       "      <th>cypriot_pound</th>\n",
       "      <th>czech_koruna</th>\n",
       "      <th>danish_krone</th>\n",
       "      <th>estonian_kroon</th>\n",
       "      <th>uk_pound</th>\n",
       "      <th>greek_drachma</th>\n",
       "      <th>hong_kong_dollar</th>\n",
       "      <th>croatian_kuna</th>\n",
       "      <th>hungarian_forint</th>\n",
       "      <th>indonesian_rupiah</th>\n",
       "      <th>israeli_shekel</th>\n",
       "      <th>indian_rupee</th>\n",
       "      <th>iceland_krona</th>\n",
       "      <th>japanese_yen</th>\n",
       "      <th>korean_won</th>\n",
       "      <th>lithuanian_litas</th>\n",
       "      <th>latvian_lats</th>\n",
       "      <th>maltese_lira</th>\n",
       "      <th>mexican_peso</th>\n",
       "      <th>malaysian_ringgit</th>\n",
       "      <th>norwegian_krone</th>\n",
       "      <th>new_zealand_dollar</th>\n",
       "      <th>philippine_peso</th>\n",
       "      <th>polish_zloty</th>\n",
       "      <th>romanian_leu</th>\n",
       "      <th>russian_rouble</th>\n",
       "      <th>swedish_krona</th>\n",
       "      <th>singapore_dollar</th>\n",
       "      <th>slovenian_tolar</th>\n",
       "      <th>slovak_koruna</th>\n",
       "      <th>thai_baht</th>\n",
       "      <th>turkish_lira</th>\n",
       "      <th>us_dollar</th>\n",
       "      <th>south_african_rand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4998</th>\n",
       "      <td>2018-04-13</td>\n",
       "      <td>1.5801</td>\n",
       "      <td>1.9558</td>\n",
       "      <td>4.1979</td>\n",
       "      <td>1.5482</td>\n",
       "      <td>1.1854</td>\n",
       "      <td>7.7363</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.3070</td>\n",
       "      <td>7.4467</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8640</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.6687</td>\n",
       "      <td>7.4165</td>\n",
       "      <td>311.1300</td>\n",
       "      <td>16,939.5700</td>\n",
       "      <td>4.3316</td>\n",
       "      <td>80.3160</td>\n",
       "      <td>121.6000</td>\n",
       "      <td>132.6400</td>\n",
       "      <td>1,316.2600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.3162</td>\n",
       "      <td>4.7714</td>\n",
       "      <td>9.5643</td>\n",
       "      <td>1.6703</td>\n",
       "      <td>63.9690</td>\n",
       "      <td>4.1763</td>\n",
       "      <td>4.6603</td>\n",
       "      <td>76.2186</td>\n",
       "      <td>10.3798</td>\n",
       "      <td>1.6158</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.3670</td>\n",
       "      <td>5.0411</td>\n",
       "      <td>1.2317</td>\n",
       "      <td>14.8457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4999</th>\n",
       "      <td>2018-04-16</td>\n",
       "      <td>1.5928</td>\n",
       "      <td>1.9558</td>\n",
       "      <td>4.2300</td>\n",
       "      <td>1.5596</td>\n",
       "      <td>1.1878</td>\n",
       "      <td>7.7726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25.2650</td>\n",
       "      <td>7.4473</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.8647</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9.7104</td>\n",
       "      <td>7.4128</td>\n",
       "      <td>310.3000</td>\n",
       "      <td>17,039.9800</td>\n",
       "      <td>4.3327</td>\n",
       "      <td>81.0175</td>\n",
       "      <td>122.0000</td>\n",
       "      <td>132.7700</td>\n",
       "      <td>1,328.3300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22.3399</td>\n",
       "      <td>4.8057</td>\n",
       "      <td>9.5950</td>\n",
       "      <td>1.6853</td>\n",
       "      <td>64.3870</td>\n",
       "      <td>4.1627</td>\n",
       "      <td>4.6508</td>\n",
       "      <td>76.9420</td>\n",
       "      <td>10.4045</td>\n",
       "      <td>1.6221</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.6440</td>\n",
       "      <td>5.0816</td>\n",
       "      <td>1.2370</td>\n",
       "      <td>14.9467</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        date      australian_dollar      bulgarian_lev       brazilian_real       canadian_dollar        swiss_franc         chinese_yuan      cypriot_pound     czech_koruna         danish_krone      estonian_kroon       uk_pound        greek_drachma   hong_kong_dollar       croatian_kuna      hungarian_forint     indonesian_rupiah     israeli_shekel        indian_rupee         iceland_krona        japanese_yen          korean_won       lithuanian_litas  latvian_lats  maltese_lira     mexican_peso       malaysian_ringgit     norwegian_krone    new_zealand_dollar     philippine_peso       polish_zloty         romanian_leu        russian_rouble        swedish_krona      singapore_dollar    slovenian_tolar  slovak_koruna       thai_baht          turkish_lira           us_dollar       south_african_rand \n",
       "4998 2018-04-13               1.5801               1.9558               4.1979               1.5482               1.1854               7.7363      NaN                    25.3070               7.4467       NaN                     0.8640      NaN                     9.6687               7.4165             311.1300          16,939.5700               4.3316              80.3160             121.6000             132.6400           1,316.2600        NaN             NaN           NaN                   22.3162               4.7714               9.5643               1.6703              63.9690               4.1763               4.6603              76.2186              10.3798               1.6158       NaN             NaN                    38.3670               5.0411               1.2317              14.8457\n",
       "4999 2018-04-16               1.5928               1.9558               4.2300               1.5596               1.1878               7.7726      NaN                    25.2650               7.4473       NaN                     0.8647      NaN                     9.7104               7.4128             310.3000          17,039.9800               4.3327              81.0175             122.0000             132.7700           1,328.3300        NaN             NaN           NaN                   22.3399               4.8057               9.5950               1.6853              64.3870               4.1627               4.6508              76.9420              10.4045               1.6221       NaN             NaN                    38.6440               5.0816               1.2370              14.9467"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import pprint\n",
    "\n",
    "pd.options.display.float_format = '{:20,.4f}'.format\n",
    "pd.set_option('display.max_rows', None)\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.width', 1000)\n",
    "pd.set_option('display.colheader_justify', 'center')\n",
    "pd.set_option('display.precision', 3)\n",
    "\n",
    "# open file\n",
    "x_rates = pd.read_csv(\"euro-daily-hist_1999_2020.csv\")\n",
    "\n",
    "# strip brackets and trailing space from country names\n",
    "# replace remaining space with underscore\n",
    "# lower case all column names\n",
    "x_rates.columns = x_rates.columns.str.replace(\"[\",\"\").str.replace(\"]\",\"\")\n",
    "x_rates.columns = x_rates.columns.str.rstrip()\n",
    "x_rates.columns = x_rates.columns.str.replace(\" \",\"_\")\n",
    "x_rates.columns = x_rates.columns.str.lower()\n",
    "\n",
    "# rename columns\n",
    "x_rates.rename(columns={\"period\\\\unit:\":\"date\",\n",
    "                        \"chinese_yuan_renminbi\":\"chinese_yuan\",\n",
    "                        \"uk_pound_sterling\":\"uk_pound\"}, inplace=True)\n",
    "\n",
    "# convert datetime\n",
    "x_rates[\"date\"] = pd.to_datetime(x_rates[\"date\"])\n",
    "\n",
    "# resort and reindex\n",
    "x_rates.sort_values(\"date\", inplace=True)\n",
    "x_rates.reset_index(drop=True, inplace=True)\n",
    "\n",
    "# convert hyphens in currency columns to NaN\n",
    "import numpy as np\n",
    "x_rates = x_rates.replace(\"-\", np.nan)\n",
    "\n",
    "# convert exchange rate values to float\n",
    "x_rates.iloc[:,1:] = x_rates.iloc[:,1:].astype(float)\n",
    "\n",
    "mini = x_rates.iloc[:5000]\n",
    "display(mini.head(2))\n",
    "display(mini.tail(2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "200faa27",
   "metadata": {},
   "outputs": [],
   "source": [
    "# create a list of data frame names\n",
    "# not sure this is neccessary but trying df = df_list.index(currency) in the framer function doesn't seem to work\n",
    "# create a list of data frames for each currency with log rate of the exchange rate, 30 day rolling mean, and year\n",
    "col_names = []\n",
    "df_list = []\n",
    "df_dict = {}\n",
    "for column in mini.columns[1:]:\n",
    "    df_name = column\n",
    "    col_names.append(df_name)\n",
    "    df = mini[[\"date\", column]].copy()\n",
    "    df = df[df[column].notna()]\n",
    "    df[\"log_rate\"] = np.log(df.iloc[:,1]/df.iloc[:,1].shift()) # getting the log of the exchange rate # double check this is the correct way to get log\n",
    "    df[\"rolling_mean_30\"] = df[column].rolling(30).mean()\n",
    "    df[\"year\"] = df[\"date\"].dt.year\n",
    "#     df_dict[column] = df\n",
    "    df_list.append(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "56ba3657",
   "metadata": {},
   "outputs": [],
   "source": [
    "# functions to build annual volatility given string of currency name\n",
    "# function to assign dataframe to variable name\n",
    "# i could include this in volatizer, but for now keep separate because these are frames of all the original data\n",
    "def framer(currency):\n",
    "    index = col_names.index(currency)\n",
    "    df = df_list[index] # this is a dataframe containing a single currency and the columns built in cell 3\n",
    "    return df\n",
    "\n",
    "# function to create df with year and annual volatility for every row # i think i could use aggregation here but don't know how\n",
    "def volatizer(currency):\n",
    "    all_the_years = [currency[currency['year'] == y] for y in currency['year'].unique()] # list of dataframes for each year\n",
    "    c_name = currency.columns[1]\n",
    "    df_dict = {}\n",
    "    for frame in all_the_years:\n",
    "        year_name = frame.iat[0,4] # the year for each df, becomes the \"year\" cell for annual volatility df\n",
    "        annual_volatility = frame[\"log_rate\"].std()*253**.5 # volatility measured by standard deviation * 253 trading days per year raised to the 0.5 power\n",
    "        df_dict[year_name] = annual_volatility\n",
    "    df = pd.DataFrame.from_dict(df_dict, orient=\"index\", columns=[c_name+\"_annual_vol\"]) # indexing on year, not sure if this is cool\n",
    "    return df\n",
    "        \n",
    "brazilian_real = framer(\"brazilian_real\")\n",
    "br_vol = volatizer(brazilian_real)\n",
    "# now i need to run this on all 40 df's and get a new df with all of them joined\n",
    "# then build an hbar chart with the eight from above\n",
    "# maybe two hbar charts for cell phones?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "63114fb2",
   "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: center;\">\n",
       "      <th></th>\n",
       "      <th>brazilian_real_annual_vol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>0.2621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001</th>\n",
       "      <td>0.2217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2002</th>\n",
       "      <td>0.3007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2003</th>\n",
       "      <td>0.2003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2004</th>\n",
       "      <td>0.1244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2005</th>\n",
       "      <td>0.1670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>0.1669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>0.1549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>0.3049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>0.1553</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>0.1202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2011</th>\n",
       "      <td>0.1200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2012</th>\n",
       "      <td>0.1074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2013</th>\n",
       "      <td>0.1360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014</th>\n",
       "      <td>0.1450</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015</th>\n",
       "      <td>0.2342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016</th>\n",
       "      <td>0.1724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017</th>\n",
       "      <td>0.1217</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2018</th>\n",
       "      <td>0.1082</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      brazilian_real_annual_vol\n",
       "2000                  0.2621   \n",
       "2001                  0.2217   \n",
       "2002                  0.3007   \n",
       "2003                  0.2003   \n",
       "2004                  0.1244   \n",
       "2005                  0.1670   \n",
       "2006                  0.1669   \n",
       "2007                  0.1549   \n",
       "2008                  0.3049   \n",
       "2009                  0.1553   \n",
       "2010                  0.1202   \n",
       "2011                  0.1200   \n",
       "2012                  0.1074   \n",
       "2013                  0.1360   \n",
       "2014                  0.1450   \n",
       "2015                  0.2342   \n",
       "2016                  0.1724   \n",
       "2017                  0.1217   \n",
       "2018                  0.1082   "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(br_vol)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "93f27d7d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5\n"
     ]
    }
   ],
   "source": [
    "# use string of currency to get index position and assign it to variable name\n",
    "index = col_names.index(\"chinese_yuan\")\n",
    "print(index)\n",
    "chinese_yuan = df_list[5]\n",
    "\n",
    "# function to create df for each year in currency df\n",
    "def split_years(df):\n",
    "    return [df[df['year'] == y] for y in df['year'].unique()]\n",
    "\n",
    "all_the_years = split_years(chinese_yuan)\n",
    "# see if I can make split_years split and heads\n",
    "\n",
    "\n",
    "# # determine annual volatility for euro to currency\n",
    "# for frame in all_the_years:\n",
    "#     year_name = frame.iat[0,4]\n",
    "#     annual_volatility = frame[\"log_rate\"].std()*253**.5 # volatility measured by standard deviation * 253 trading days per year\n",
    "#     print(\"The Euro to Chinese yuan volatility for\", year_name, \"is\" ,annual_volatility)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "02f68967",
   "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: center;\">\n",
       "      <th></th>\n",
       "      <th>date</th>\n",
       "      <th>chinese_yuan</th>\n",
       "      <th>log_rate</th>\n",
       "      <th>rolling_mean_30</th>\n",
       "      <th>year</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>2000-01-13</td>\n",
       "      <td>8.5054</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>2000-01-14</td>\n",
       "      <td>8.4632</td>\n",
       "      <td>-0.0050</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>2000-01-17</td>\n",
       "      <td>8.3548</td>\n",
       "      <td>-0.0129</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>2000-01-18</td>\n",
       "      <td>8.3540</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>2000-01-19</td>\n",
       "      <td>8.3639</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>2000-01-20</td>\n",
       "      <td>8.3507</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>2000-01-21</td>\n",
       "      <td>8.3573</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>2000-01-24</td>\n",
       "      <td>8.2993</td>\n",
       "      <td>-0.0070</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>2000-01-25</td>\n",
       "      <td>8.2836</td>\n",
       "      <td>-0.0019</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>2000-01-26</td>\n",
       "      <td>8.2927</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>2000-01-27</td>\n",
       "      <td>8.2571</td>\n",
       "      <td>-0.0043</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>2000-01-28</td>\n",
       "      <td>8.1512</td>\n",
       "      <td>-0.0129</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>2000-01-31</td>\n",
       "      <td>8.1040</td>\n",
       "      <td>-0.0058</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>2000-02-01</td>\n",
       "      <td>8.0370</td>\n",
       "      <td>-0.0083</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>2000-02-02</td>\n",
       "      <td>8.0428</td>\n",
       "      <td>0.0007</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>2000-02-03</td>\n",
       "      <td>8.0684</td>\n",
       "      <td>0.0032</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>2000-02-04</td>\n",
       "      <td>8.1404</td>\n",
       "      <td>0.0089</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>2000-02-07</td>\n",
       "      <td>8.0841</td>\n",
       "      <td>-0.0069</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>2000-02-08</td>\n",
       "      <td>8.1967</td>\n",
       "      <td>0.0138</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>2000-02-09</td>\n",
       "      <td>8.2224</td>\n",
       "      <td>0.0031</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>2000-02-10</td>\n",
       "      <td>8.1677</td>\n",
       "      <td>-0.0067</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>2000-02-11</td>\n",
       "      <td>8.1123</td>\n",
       "      <td>-0.0068</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>2000-02-14</td>\n",
       "      <td>8.1669</td>\n",
       "      <td>0.0067</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>2000-02-15</td>\n",
       "      <td>8.0933</td>\n",
       "      <td>-0.0091</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>2000-02-16</td>\n",
       "      <td>8.1148</td>\n",
       "      <td>0.0027</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>2000-02-17</td>\n",
       "      <td>8.2100</td>\n",
       "      <td>0.0117</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>2000-02-18</td>\n",
       "      <td>8.1586</td>\n",
       "      <td>-0.0063</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>2000-02-21</td>\n",
       "      <td>8.1586</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>2000-02-22</td>\n",
       "      <td>8.2952</td>\n",
       "      <td>0.0166</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>2000-02-23</td>\n",
       "      <td>8.3333</td>\n",
       "      <td>0.0046</td>\n",
       "      <td>8.2247</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>2000-02-24</td>\n",
       "      <td>8.1926</td>\n",
       "      <td>-0.0170</td>\n",
       "      <td>8.2142</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>2000-02-25</td>\n",
       "      <td>8.1222</td>\n",
       "      <td>-0.0086</td>\n",
       "      <td>8.2029</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>2000-02-28</td>\n",
       "      <td>7.9782</td>\n",
       "      <td>-0.0179</td>\n",
       "      <td>8.1903</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>2000-02-29</td>\n",
       "      <td>8.0403</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>8.1799</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>2000-03-01</td>\n",
       "      <td>8.0014</td>\n",
       "      <td>-0.0048</td>\n",
       "      <td>8.1678</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>2000-03-02</td>\n",
       "      <td>8.0494</td>\n",
       "      <td>0.0060</td>\n",
       "      <td>8.1577</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>2000-03-03</td>\n",
       "      <td>7.9948</td>\n",
       "      <td>-0.0068</td>\n",
       "      <td>8.1456</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>2000-03-06</td>\n",
       "      <td>7.9790</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>8.1350</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>2000-03-07</td>\n",
       "      <td>7.9401</td>\n",
       "      <td>-0.0049</td>\n",
       "      <td>8.1235</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>2000-03-08</td>\n",
       "      <td>7.8987</td>\n",
       "      <td>-0.0052</td>\n",
       "      <td>8.1104</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>2000-03-09</td>\n",
       "      <td>7.9592</td>\n",
       "      <td>0.0076</td>\n",
       "      <td>8.1005</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>2000-03-10</td>\n",
       "      <td>7.9567</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>8.0940</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>2000-03-13</td>\n",
       "      <td>8.0419</td>\n",
       "      <td>0.0107</td>\n",
       "      <td>8.0919</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>2000-03-14</td>\n",
       "      <td>7.9625</td>\n",
       "      <td>-0.0099</td>\n",
       "      <td>8.0894</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>2000-03-15</td>\n",
       "      <td>7.9848</td>\n",
       "      <td>0.0028</td>\n",
       "      <td>8.0875</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>2000-03-16</td>\n",
       "      <td>7.9981</td>\n",
       "      <td>0.0017</td>\n",
       "      <td>8.0851</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>2000-03-17</td>\n",
       "      <td>8.0055</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>8.0806</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>2000-03-20</td>\n",
       "      <td>8.0411</td>\n",
       "      <td>0.0044</td>\n",
       "      <td>8.0792</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>2000-03-21</td>\n",
       "      <td>8.0295</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>8.0736</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>2000-03-22</td>\n",
       "      <td>7.9484</td>\n",
       "      <td>-0.0102</td>\n",
       "      <td>8.0645</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>2000-03-23</td>\n",
       "      <td>7.9923</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>8.0587</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>2000-03-24</td>\n",
       "      <td>8.0411</td>\n",
       "      <td>0.0061</td>\n",
       "      <td>8.0563</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>2000-03-27</td>\n",
       "      <td>8.0386</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>8.0520</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>2000-03-28</td>\n",
       "      <td>7.9848</td>\n",
       "      <td>-0.0067</td>\n",
       "      <td>8.0484</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>2000-03-29</td>\n",
       "      <td>7.9194</td>\n",
       "      <td>-0.0082</td>\n",
       "      <td>8.0419</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>2000-03-30</td>\n",
       "      <td>7.9087</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>8.0318</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>2000-03-31</td>\n",
       "      <td>7.9070</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>8.0234</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>2000-04-03</td>\n",
       "      <td>7.9161</td>\n",
       "      <td>0.0012</td>\n",
       "      <td>8.0154</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>2000-04-04</td>\n",
       "      <td>7.8946</td>\n",
       "      <td>-0.0027</td>\n",
       "      <td>8.0020</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>2000-04-05</td>\n",
       "      <td>8.0063</td>\n",
       "      <td>0.0140</td>\n",
       "      <td>7.9911</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>2000-04-06</td>\n",
       "      <td>7.9666</td>\n",
       "      <td>-0.0050</td>\n",
       "      <td>7.9836</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>2000-04-07</td>\n",
       "      <td>7.9161</td>\n",
       "      <td>-0.0064</td>\n",
       "      <td>7.9767</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>2000-04-10</td>\n",
       "      <td>7.9376</td>\n",
       "      <td>0.0027</td>\n",
       "      <td>7.9754</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>2000-04-11</td>\n",
       "      <td>7.9410</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>7.9720</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>2000-04-12</td>\n",
       "      <td>7.9261</td>\n",
       "      <td>-0.0019</td>\n",
       "      <td>7.9695</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>2000-04-13</td>\n",
       "      <td>7.8938</td>\n",
       "      <td>-0.0041</td>\n",
       "      <td>7.9643</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>2000-04-14</td>\n",
       "      <td>7.8963</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>7.9611</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>2000-04-17</td>\n",
       "      <td>7.9236</td>\n",
       "      <td>0.0035</td>\n",
       "      <td>7.9592</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>2000-04-18</td>\n",
       "      <td>7.8607</td>\n",
       "      <td>-0.0080</td>\n",
       "      <td>7.9566</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>2000-04-19</td>\n",
       "      <td>7.8309</td>\n",
       "      <td>-0.0038</td>\n",
       "      <td>7.9543</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>338</th>\n",
       "      <td>2000-04-20</td>\n",
       "      <td>7.7605</td>\n",
       "      <td>-0.0090</td>\n",
       "      <td>7.9477</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>341</th>\n",
       "      <td>2000-04-25</td>\n",
       "      <td>7.6993</td>\n",
       "      <td>-0.0079</td>\n",
       "      <td>7.9391</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>342</th>\n",
       "      <td>2000-04-26</td>\n",
       "      <td>7.6090</td>\n",
       "      <td>-0.0118</td>\n",
       "      <td>7.9247</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>343</th>\n",
       "      <td>2000-04-27</td>\n",
       "      <td>7.5842</td>\n",
       "      <td>-0.0033</td>\n",
       "      <td>7.9121</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>344</th>\n",
       "      <td>2000-04-28</td>\n",
       "      <td>7.5197</td>\n",
       "      <td>-0.0085</td>\n",
       "      <td>7.8966</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>346</th>\n",
       "      <td>2000-05-02</td>\n",
       "      <td>7.5453</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>7.8815</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>347</th>\n",
       "      <td>2000-05-03</td>\n",
       "      <td>7.3773</td>\n",
       "      <td>-0.0225</td>\n",
       "      <td>7.8605</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>2000-05-04</td>\n",
       "      <td>7.4054</td>\n",
       "      <td>0.0038</td>\n",
       "      <td>7.8393</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>2000-05-05</td>\n",
       "      <td>7.4361</td>\n",
       "      <td>0.0041</td>\n",
       "      <td>7.8196</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>2000-05-08</td>\n",
       "      <td>7.4096</td>\n",
       "      <td>-0.0036</td>\n",
       "      <td>7.8016</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>2000-05-09</td>\n",
       "      <td>7.4311</td>\n",
       "      <td>0.0029</td>\n",
       "      <td>7.7829</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>2000-05-10</td>\n",
       "      <td>7.5379</td>\n",
       "      <td>0.0143</td>\n",
       "      <td>7.7661</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>353</th>\n",
       "      <td>2000-05-11</td>\n",
       "      <td>7.5147</td>\n",
       "      <td>-0.0031</td>\n",
       "      <td>7.7487</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>2000-05-12</td>\n",
       "      <td>7.4733</td>\n",
       "      <td>-0.0055</td>\n",
       "      <td>7.7316</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>355</th>\n",
       "      <td>2000-05-15</td>\n",
       "      <td>7.5710</td>\n",
       "      <td>0.0130</td>\n",
       "      <td>7.7200</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>356</th>\n",
       "      <td>2000-05-16</td>\n",
       "      <td>7.5031</td>\n",
       "      <td>-0.0090</td>\n",
       "      <td>7.7065</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>357</th>\n",
       "      <td>2000-05-17</td>\n",
       "      <td>7.3847</td>\n",
       "      <td>-0.0159</td>\n",
       "      <td>7.6891</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>2000-05-18</td>\n",
       "      <td>7.4013</td>\n",
       "      <td>0.0022</td>\n",
       "      <td>7.6719</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>2000-05-19</td>\n",
       "      <td>7.3458</td>\n",
       "      <td>-0.0075</td>\n",
       "      <td>7.6536</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>360</th>\n",
       "      <td>2000-05-22</td>\n",
       "      <td>7.4493</td>\n",
       "      <td>0.0140</td>\n",
       "      <td>7.6350</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>361</th>\n",
       "      <td>2000-05-23</td>\n",
       "      <td>7.5412</td>\n",
       "      <td>0.0123</td>\n",
       "      <td>7.6209</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>2000-05-24</td>\n",
       "      <td>7.5304</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>7.6080</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>363</th>\n",
       "      <td>2000-05-25</td>\n",
       "      <td>7.4336</td>\n",
       "      <td>-0.0129</td>\n",
       "      <td>7.5912</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>2000-05-26</td>\n",
       "      <td>7.5677</td>\n",
       "      <td>0.0179</td>\n",
       "      <td>7.5788</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>365</th>\n",
       "      <td>2000-05-29</td>\n",
       "      <td>7.6662</td>\n",
       "      <td>0.0129</td>\n",
       "      <td>7.5701</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>366</th>\n",
       "      <td>2000-05-30</td>\n",
       "      <td>7.7464</td>\n",
       "      <td>0.0104</td>\n",
       "      <td>7.5652</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>367</th>\n",
       "      <td>2000-05-31</td>\n",
       "      <td>7.7001</td>\n",
       "      <td>-0.0060</td>\n",
       "      <td>7.5586</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>2000-06-01</td>\n",
       "      <td>7.7224</td>\n",
       "      <td>0.0029</td>\n",
       "      <td>7.5519</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>2000-06-02</td>\n",
       "      <td>7.7431</td>\n",
       "      <td>0.0027</td>\n",
       "      <td>7.5480</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>2000-06-05</td>\n",
       "      <td>7.8077</td>\n",
       "      <td>0.0083</td>\n",
       "      <td>7.5472</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>2000-06-06</td>\n",
       "      <td>7.8507</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>7.5503</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>2000-06-07</td>\n",
       "      <td>7.9078</td>\n",
       "      <td>0.0072</td>\n",
       "      <td>7.5572</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>2000-06-08</td>\n",
       "      <td>8.0022</td>\n",
       "      <td>0.0119</td>\n",
       "      <td>7.5703</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>2000-06-09</td>\n",
       "      <td>7.8549</td>\n",
       "      <td>-0.0186</td>\n",
       "      <td>7.5793</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>2000-06-12</td>\n",
       "      <td>7.8855</td>\n",
       "      <td>0.0039</td>\n",
       "      <td>7.5915</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>376</th>\n",
       "      <td>2000-06-13</td>\n",
       "      <td>7.9318</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>7.6044</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>2000-06-14</td>\n",
       "      <td>7.9757</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>7.6244</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>378</th>\n",
       "      <td>2000-06-15</td>\n",
       "      <td>7.8830</td>\n",
       "      <td>-0.0117</td>\n",
       "      <td>7.6403</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>2000-06-16</td>\n",
       "      <td>7.9170</td>\n",
       "      <td>0.0043</td>\n",
       "      <td>7.6563</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>2000-06-19</td>\n",
       "      <td>7.9790</td>\n",
       "      <td>0.0078</td>\n",
       "      <td>7.6753</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>2000-06-20</td>\n",
       "      <td>7.8946</td>\n",
       "      <td>-0.0106</td>\n",
       "      <td>7.6907</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>2000-06-21</td>\n",
       "      <td>7.8383</td>\n",
       "      <td>-0.0072</td>\n",
       "      <td>7.7008</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>2000-06-22</td>\n",
       "      <td>7.7845</td>\n",
       "      <td>-0.0069</td>\n",
       "      <td>7.7097</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>2000-06-23</td>\n",
       "      <td>7.7911</td>\n",
       "      <td>0.0008</td>\n",
       "      <td>7.7203</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>2000-06-26</td>\n",
       "      <td>7.7200</td>\n",
       "      <td>-0.0092</td>\n",
       "      <td>7.7253</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>2000-06-27</td>\n",
       "      <td>7.7812</td>\n",
       "      <td>0.0079</td>\n",
       "      <td>7.7346</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>2000-06-28</td>\n",
       "      <td>7.7928</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>7.7482</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>2000-06-29</td>\n",
       "      <td>7.8665</td>\n",
       "      <td>0.0094</td>\n",
       "      <td>7.7637</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>2000-06-30</td>\n",
       "      <td>7.9095</td>\n",
       "      <td>0.0055</td>\n",
       "      <td>7.7825</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>2000-07-03</td>\n",
       "      <td>7.8574</td>\n",
       "      <td>-0.0066</td>\n",
       "      <td>7.7961</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>2000-07-04</td>\n",
       "      <td>7.8524</td>\n",
       "      <td>-0.0006</td>\n",
       "      <td>7.8065</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>2000-07-05</td>\n",
       "      <td>7.8938</td>\n",
       "      <td>0.0053</td>\n",
       "      <td>7.8186</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>2000-07-06</td>\n",
       "      <td>7.8979</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>7.8340</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>2000-07-07</td>\n",
       "      <td>7.8491</td>\n",
       "      <td>-0.0062</td>\n",
       "      <td>7.8434</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>2000-07-10</td>\n",
       "      <td>7.8822</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>7.8506</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>2000-07-11</td>\n",
       "      <td>7.8855</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>7.8553</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>2000-07-12</td>\n",
       "      <td>7.8623</td>\n",
       "      <td>-0.0029</td>\n",
       "      <td>7.8607</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>2000-07-13</td>\n",
       "      <td>7.7382</td>\n",
       "      <td>-0.0159</td>\n",
       "      <td>7.8612</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>2000-07-14</td>\n",
       "      <td>7.7340</td>\n",
       "      <td>-0.0005</td>\n",
       "      <td>7.8609</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>2000-07-17</td>\n",
       "      <td>7.7407</td>\n",
       "      <td>0.0009</td>\n",
       "      <td>7.8587</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>2000-07-18</td>\n",
       "      <td>7.7415</td>\n",
       "      <td>0.0001</td>\n",
       "      <td>7.8550</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>2000-07-19</td>\n",
       "      <td>7.6281</td>\n",
       "      <td>-0.0148</td>\n",
       "      <td>7.8457</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>2000-07-20</td>\n",
       "      <td>7.6314</td>\n",
       "      <td>0.0004</td>\n",
       "      <td>7.8333</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>2000-07-21</td>\n",
       "      <td>7.7498</td>\n",
       "      <td>0.0154</td>\n",
       "      <td>7.8298</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>2000-07-24</td>\n",
       "      <td>7.7241</td>\n",
       "      <td>-0.0033</td>\n",
       "      <td>7.8244</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>2000-07-25</td>\n",
       "      <td>7.7887</td>\n",
       "      <td>0.0083</td>\n",
       "      <td>7.8197</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>2000-07-26</td>\n",
       "      <td>7.7721</td>\n",
       "      <td>-0.0021</td>\n",
       "      <td>7.8129</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>2000-07-27</td>\n",
       "      <td>7.7713</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>7.8092</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>2000-07-28</td>\n",
       "      <td>7.6777</td>\n",
       "      <td>-0.0121</td>\n",
       "      <td>7.8012</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>410</th>\n",
       "      <td>2000-07-31</td>\n",
       "      <td>7.6504</td>\n",
       "      <td>-0.0036</td>\n",
       "      <td>7.7902</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>2000-08-01</td>\n",
       "      <td>7.6678</td>\n",
       "      <td>0.0023</td>\n",
       "      <td>7.7827</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>2000-08-02</td>\n",
       "      <td>7.5668</td>\n",
       "      <td>-0.0133</td>\n",
       "      <td>7.7736</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>413</th>\n",
       "      <td>2000-08-03</td>\n",
       "      <td>7.4725</td>\n",
       "      <td>-0.0125</td>\n",
       "      <td>7.7632</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>2000-08-04</td>\n",
       "      <td>7.4750</td>\n",
       "      <td>0.0003</td>\n",
       "      <td>7.7527</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>2000-08-07</td>\n",
       "      <td>7.5188</td>\n",
       "      <td>0.0058</td>\n",
       "      <td>7.7460</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>416</th>\n",
       "      <td>2000-08-08</td>\n",
       "      <td>7.4882</td>\n",
       "      <td>-0.0041</td>\n",
       "      <td>7.7362</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>417</th>\n",
       "      <td>2000-08-09</td>\n",
       "      <td>7.4270</td>\n",
       "      <td>-0.0082</td>\n",
       "      <td>7.7240</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>418</th>\n",
       "      <td>2000-08-10</td>\n",
       "      <td>7.4750</td>\n",
       "      <td>0.0064</td>\n",
       "      <td>7.7110</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>419</th>\n",
       "      <td>2000-08-11</td>\n",
       "      <td>7.5586</td>\n",
       "      <td>0.0111</td>\n",
       "      <td>7.6993</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>420</th>\n",
       "      <td>2000-08-14</td>\n",
       "      <td>7.4584</td>\n",
       "      <td>-0.0133</td>\n",
       "      <td>7.6860</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>2000-08-15</td>\n",
       "      <td>7.5470</td>\n",
       "      <td>0.0118</td>\n",
       "      <td>7.6758</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>2000-08-16</td>\n",
       "      <td>7.5089</td>\n",
       "      <td>-0.0051</td>\n",
       "      <td>7.6630</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>423</th>\n",
       "      <td>2000-08-17</td>\n",
       "      <td>7.5652</td>\n",
       "      <td>0.0075</td>\n",
       "      <td>7.6519</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>424</th>\n",
       "      <td>2000-08-18</td>\n",
       "      <td>7.5544</td>\n",
       "      <td>-0.0014</td>\n",
       "      <td>7.6421</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>425</th>\n",
       "      <td>2000-08-21</td>\n",
       "      <td>7.4683</td>\n",
       "      <td>-0.0115</td>\n",
       "      <td>7.6283</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>426</th>\n",
       "      <td>2000-08-22</td>\n",
       "      <td>7.4261</td>\n",
       "      <td>-0.0057</td>\n",
       "      <td>7.6129</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>427</th>\n",
       "      <td>2000-08-23</td>\n",
       "      <td>7.3814</td>\n",
       "      <td>-0.0060</td>\n",
       "      <td>7.5969</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>428</th>\n",
       "      <td>2000-08-24</td>\n",
       "      <td>7.4592</td>\n",
       "      <td>0.0105</td>\n",
       "      <td>7.5876</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>429</th>\n",
       "      <td>2000-08-25</td>\n",
       "      <td>7.4667</td>\n",
       "      <td>0.0010</td>\n",
       "      <td>7.5787</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>430</th>\n",
       "      <td>2000-08-28</td>\n",
       "      <td>7.4551</td>\n",
       "      <td>-0.0016</td>\n",
       "      <td>7.5692</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>2000-08-29</td>\n",
       "      <td>7.4203</td>\n",
       "      <td>-0.0047</td>\n",
       "      <td>7.5585</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>432</th>\n",
       "      <td>2000-08-30</td>\n",
       "      <td>7.3740</td>\n",
       "      <td>-0.0063</td>\n",
       "      <td>7.5500</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>2000-08-31</td>\n",
       "      <td>7.3715</td>\n",
       "      <td>-0.0003</td>\n",
       "      <td>7.5413</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>2000-09-01</td>\n",
       "      <td>7.3682</td>\n",
       "      <td>-0.0004</td>\n",
       "      <td>7.5286</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>2000-09-04</td>\n",
       "      <td>7.4493</td>\n",
       "      <td>0.0109</td>\n",
       "      <td>7.5195</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>2000-09-05</td>\n",
       "      <td>7.3549</td>\n",
       "      <td>-0.0128</td>\n",
       "      <td>7.5050</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>2000-09-06</td>\n",
       "      <td>7.2987</td>\n",
       "      <td>-0.0077</td>\n",
       "      <td>7.4892</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>438</th>\n",
       "      <td>2000-09-07</td>\n",
       "      <td>7.1811</td>\n",
       "      <td>-0.0162</td>\n",
       "      <td>7.4695</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>439</th>\n",
       "      <td>2000-09-08</td>\n",
       "      <td>7.2300</td>\n",
       "      <td>0.0068</td>\n",
       "      <td>7.4546</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>440</th>\n",
       "      <td>2000-09-11</td>\n",
       "      <td>7.1257</td>\n",
       "      <td>-0.0145</td>\n",
       "      <td>7.4371</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>2000-09-12</td>\n",
       "      <td>7.1298</td>\n",
       "      <td>0.0006</td>\n",
       "      <td>7.4192</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>2000-09-13</td>\n",
       "      <td>7.1629</td>\n",
       "      <td>0.0046</td>\n",
       "      <td>7.4057</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>2000-09-14</td>\n",
       "      <td>7.1952</td>\n",
       "      <td>0.0045</td>\n",
       "      <td>7.3965</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>2000-09-15</td>\n",
       "      <td>7.1306</td>\n",
       "      <td>-0.0090</td>\n",
       "      <td>7.3850</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>2000-09-18</td>\n",
       "      <td>7.0570</td>\n",
       "      <td>-0.0104</td>\n",
       "      <td>7.3696</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>2000-09-19</td>\n",
       "      <td>7.0694</td>\n",
       "      <td>0.0018</td>\n",
       "      <td>7.3557</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>2000-09-20</td>\n",
       "      <td>7.0156</td>\n",
       "      <td>-0.0076</td>\n",
       "      <td>7.3419</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>2000-09-21</td>\n",
       "      <td>7.0553</td>\n",
       "      <td>0.0056</td>\n",
       "      <td>7.3280</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>2000-09-22</td>\n",
       "      <td>7.3583</td>\n",
       "      <td>0.0420</td>\n",
       "      <td>7.3213</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>2000-09-25</td>\n",
       "      <td>7.2589</td>\n",
       "      <td>-0.0136</td>\n",
       "      <td>7.3146</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>2000-09-26</td>\n",
       "      <td>7.2482</td>\n",
       "      <td>-0.0015</td>\n",
       "      <td>7.3047</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>2000-09-27</td>\n",
       "      <td>7.3342</td>\n",
       "      <td>0.0118</td>\n",
       "      <td>7.2989</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>2000-09-28</td>\n",
       "      <td>7.3102</td>\n",
       "      <td>-0.0033</td>\n",
       "      <td>7.2904</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>2000-09-29</td>\n",
       "      <td>7.2548</td>\n",
       "      <td>-0.0076</td>\n",
       "      <td>7.2804</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>2000-10-02</td>\n",
       "      <td>7.2854</td>\n",
       "      <td>0.0042</td>\n",
       "      <td>7.2743</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>2000-10-03</td>\n",
       "      <td>7.2531</td>\n",
       "      <td>-0.0044</td>\n",
       "      <td>7.2685</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>2000-10-04</td>\n",
       "      <td>7.2258</td>\n",
       "      <td>-0.0038</td>\n",
       "      <td>7.2633</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>2000-10-05</td>\n",
       "      <td>7.2722</td>\n",
       "      <td>0.0064</td>\n",
       "      <td>7.2571</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>2000-10-06</td>\n",
       "      <td>7.2035</td>\n",
       "      <td>-0.0095</td>\n",
       "      <td>7.2483</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>2000-10-09</td>\n",
       "      <td>7.1969</td>\n",
       "      <td>-0.0009</td>\n",
       "      <td>7.2397</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>2000-10-10</td>\n",
       "      <td>7.2184</td>\n",
       "      <td>0.0030</td>\n",
       "      <td>7.2330</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>2000-10-11</td>\n",
       "      <td>7.2175</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>7.2278</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>2000-10-12</td>\n",
       "      <td>7.1579</td>\n",
       "      <td>-0.0083</td>\n",
       "      <td>7.2206</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>2000-10-13</td>\n",
       "      <td>7.1406</td>\n",
       "      <td>-0.0024</td>\n",
       "      <td>7.2130</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>2000-10-16</td>\n",
       "      <td>7.0446</td>\n",
       "      <td>-0.0135</td>\n",
       "      <td>7.1996</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>2000-10-17</td>\n",
       "      <td>7.0321</td>\n",
       "      <td>-0.0018</td>\n",
       "      <td>7.1888</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>2000-10-18</td>\n",
       "      <td>7.0561</td>\n",
       "      <td>0.0034</td>\n",
       "      <td>7.1807</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>2000-10-19</td>\n",
       "      <td>6.9618</td>\n",
       "      <td>-0.0135</td>\n",
       "      <td>7.1734</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>2000-10-20</td>\n",
       "      <td>6.9957</td>\n",
       "      <td>0.0049</td>\n",
       "      <td>7.1656</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>2000-10-23</td>\n",
       "      <td>6.9336</td>\n",
       "      <td>-0.0089</td>\n",
       "      <td>7.1592</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>2000-10-24</td>\n",
       "      <td>6.9411</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>7.1529</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>2000-10-25</td>\n",
       "      <td>6.8757</td>\n",
       "      <td>-0.0095</td>\n",
       "      <td>7.1433</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>2000-10-26</td>\n",
       "      <td>6.8302</td>\n",
       "      <td>-0.0066</td>\n",
       "      <td>7.1312</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>2000-10-27</td>\n",
       "      <td>6.8898</td>\n",
       "      <td>0.0087</td>\n",
       "      <td>7.1231</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>2000-10-30</td>\n",
       "      <td>7.0206</td>\n",
       "      <td>0.0188</td>\n",
       "      <td>7.1219</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>2000-10-31</td>\n",
       "      <td>6.9668</td>\n",
       "      <td>-0.0077</td>\n",
       "      <td>7.1185</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>2000-11-01</td>\n",
       "      <td>7.0801</td>\n",
       "      <td>0.0161</td>\n",
       "      <td>7.1206</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>2000-11-02</td>\n",
       "      <td>7.1563</td>\n",
       "      <td>0.0107</td>\n",
       "      <td>7.1240</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>479</th>\n",
       "      <td>2000-11-03</td>\n",
       "      <td>7.2258</td>\n",
       "      <td>0.0097</td>\n",
       "      <td>7.1196</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>480</th>\n",
       "      <td>2000-11-06</td>\n",
       "      <td>7.1737</td>\n",
       "      <td>-0.0072</td>\n",
       "      <td>7.1168</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>481</th>\n",
       "      <td>2000-11-07</td>\n",
       "      <td>7.1075</td>\n",
       "      <td>-0.0093</td>\n",
       "      <td>7.1121</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>482</th>\n",
       "      <td>2000-11-08</td>\n",
       "      <td>7.0843</td>\n",
       "      <td>-0.0033</td>\n",
       "      <td>7.1037</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>483</th>\n",
       "      <td>2000-11-09</td>\n",
       "      <td>7.0611</td>\n",
       "      <td>-0.0033</td>\n",
       "      <td>7.0954</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>484</th>\n",
       "      <td>2000-11-10</td>\n",
       "      <td>7.1786</td>\n",
       "      <td>0.0165</td>\n",
       "      <td>7.0929</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>2000-11-13</td>\n",
       "      <td>7.1348</td>\n",
       "      <td>-0.0061</td>\n",
       "      <td>7.0879</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>486</th>\n",
       "      <td>2000-11-14</td>\n",
       "      <td>7.1041</td>\n",
       "      <td>-0.0043</td>\n",
       "      <td>7.0829</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>2000-11-15</td>\n",
       "      <td>7.1149</td>\n",
       "      <td>0.0015</td>\n",
       "      <td>7.0792</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>488</th>\n",
       "      <td>2000-11-16</td>\n",
       "      <td>7.0926</td>\n",
       "      <td>-0.0031</td>\n",
       "      <td>7.0732</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>2000-11-17</td>\n",
       "      <td>7.0644</td>\n",
       "      <td>-0.0040</td>\n",
       "      <td>7.0686</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>2000-11-20</td>\n",
       "      <td>7.0255</td>\n",
       "      <td>-0.0055</td>\n",
       "      <td>7.0629</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>491</th>\n",
       "      <td>2000-11-21</td>\n",
       "      <td>7.0139</td>\n",
       "      <td>-0.0017</td>\n",
       "      <td>7.0561</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>492</th>\n",
       "      <td>2000-11-22</td>\n",
       "      <td>6.9767</td>\n",
       "      <td>-0.0053</td>\n",
       "      <td>7.0480</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>493</th>\n",
       "      <td>2000-11-23</td>\n",
       "      <td>6.9750</td>\n",
       "      <td>-0.0002</td>\n",
       "      <td>7.0419</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>2000-11-24</td>\n",
       "      <td>6.9825</td>\n",
       "      <td>0.0011</td>\n",
       "      <td>7.0367</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>2000-11-27</td>\n",
       "      <td>6.9576</td>\n",
       "      <td>-0.0036</td>\n",
       "      <td>7.0338</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>2000-11-28</td>\n",
       "      <td>7.0859</td>\n",
       "      <td>0.0183</td>\n",
       "      <td>7.0356</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>2000-11-29</td>\n",
       "      <td>7.1596</td>\n",
       "      <td>0.0103</td>\n",
       "      <td>7.0390</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>2000-11-30</td>\n",
       "      <td>7.1877</td>\n",
       "      <td>0.0039</td>\n",
       "      <td>7.0465</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>2000-12-01</td>\n",
       "      <td>7.2300</td>\n",
       "      <td>0.0059</td>\n",
       "      <td>7.0543</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>2000-12-04</td>\n",
       "      <td>7.3732</td>\n",
       "      <td>0.0196</td>\n",
       "      <td>7.0690</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>501</th>\n",
       "      <td>2000-12-05</td>\n",
       "      <td>7.2920</td>\n",
       "      <td>-0.0111</td>\n",
       "      <td>7.0807</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>502</th>\n",
       "      <td>2000-12-06</td>\n",
       "      <td>7.3069</td>\n",
       "      <td>0.0020</td>\n",
       "      <td>7.0951</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>503</th>\n",
       "      <td>2000-12-07</td>\n",
       "      <td>7.4021</td>\n",
       "      <td>0.0129</td>\n",
       "      <td>7.1141</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>2000-12-08</td>\n",
       "      <td>7.3624</td>\n",
       "      <td>-0.0054</td>\n",
       "      <td>7.1299</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>2000-12-11</td>\n",
       "      <td>7.2871</td>\n",
       "      <td>-0.0103</td>\n",
       "      <td>7.1388</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>506</th>\n",
       "      <td>2000-12-12</td>\n",
       "      <td>7.2689</td>\n",
       "      <td>-0.0025</td>\n",
       "      <td>7.1488</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>507</th>\n",
       "      <td>2000-12-13</td>\n",
       "      <td>7.2407</td>\n",
       "      <td>-0.0039</td>\n",
       "      <td>7.1542</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>508</th>\n",
       "      <td>2000-12-14</td>\n",
       "      <td>7.3160</td>\n",
       "      <td>0.0103</td>\n",
       "      <td>7.1595</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>509</th>\n",
       "      <td>2000-12-15</td>\n",
       "      <td>7.4361</td>\n",
       "      <td>0.0163</td>\n",
       "      <td>7.1665</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>2000-12-18</td>\n",
       "      <td>7.4212</td>\n",
       "      <td>-0.0020</td>\n",
       "      <td>7.1748</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511</th>\n",
       "      <td>2000-12-19</td>\n",
       "      <td>7.3690</td>\n",
       "      <td>-0.0071</td>\n",
       "      <td>7.1835</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>512</th>\n",
       "      <td>2000-12-20</td>\n",
       "      <td>7.4981</td>\n",
       "      <td>0.0174</td>\n",
       "      <td>7.1973</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>513</th>\n",
       "      <td>2000-12-21</td>\n",
       "      <td>7.5701</td>\n",
       "      <td>0.0096</td>\n",
       "      <td>7.2143</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>514</th>\n",
       "      <td>2000-12-22</td>\n",
       "      <td>7.6479</td>\n",
       "      <td>0.0102</td>\n",
       "      <td>7.2299</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>2000-12-27</td>\n",
       "      <td>7.7059</td>\n",
       "      <td>0.0076</td>\n",
       "      <td>7.2489</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>518</th>\n",
       "      <td>2000-12-28</td>\n",
       "      <td>7.6852</td>\n",
       "      <td>-0.0027</td>\n",
       "      <td>7.2683</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>519</th>\n",
       "      <td>2000-12-29</td>\n",
       "      <td>7.7017</td>\n",
       "      <td>0.0021</td>\n",
       "      <td>7.2879</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       date        chinese_yuan           log_rate          rolling_mean_30    year\n",
       "268 2000-01-13               8.5054                  NaN                  NaN  2000\n",
       "269 2000-01-14               8.4632              -0.0050                  NaN  2000\n",
       "270 2000-01-17               8.3548              -0.0129                  NaN  2000\n",
       "271 2000-01-18               8.3540              -0.0001                  NaN  2000\n",
       "272 2000-01-19               8.3639               0.0012                  NaN  2000\n",
       "273 2000-01-20               8.3507              -0.0016                  NaN  2000\n",
       "274 2000-01-21               8.3573               0.0008                  NaN  2000\n",
       "275 2000-01-24               8.2993              -0.0070                  NaN  2000\n",
       "276 2000-01-25               8.2836              -0.0019                  NaN  2000\n",
       "277 2000-01-26               8.2927               0.0011                  NaN  2000\n",
       "278 2000-01-27               8.2571              -0.0043                  NaN  2000\n",
       "279 2000-01-28               8.1512              -0.0129                  NaN  2000\n",
       "280 2000-01-31               8.1040              -0.0058                  NaN  2000\n",
       "281 2000-02-01               8.0370              -0.0083                  NaN  2000\n",
       "282 2000-02-02               8.0428               0.0007                  NaN  2000\n",
       "283 2000-02-03               8.0684               0.0032                  NaN  2000\n",
       "284 2000-02-04               8.1404               0.0089                  NaN  2000\n",
       "285 2000-02-07               8.0841              -0.0069                  NaN  2000\n",
       "286 2000-02-08               8.1967               0.0138                  NaN  2000\n",
       "287 2000-02-09               8.2224               0.0031                  NaN  2000\n",
       "288 2000-02-10               8.1677              -0.0067                  NaN  2000\n",
       "289 2000-02-11               8.1123              -0.0068                  NaN  2000\n",
       "290 2000-02-14               8.1669               0.0067                  NaN  2000\n",
       "291 2000-02-15               8.0933              -0.0091                  NaN  2000\n",
       "292 2000-02-16               8.1148               0.0027                  NaN  2000\n",
       "293 2000-02-17               8.2100               0.0117                  NaN  2000\n",
       "294 2000-02-18               8.1586              -0.0063                  NaN  2000\n",
       "295 2000-02-21               8.1586               0.0000                  NaN  2000\n",
       "296 2000-02-22               8.2952               0.0166                  NaN  2000\n",
       "297 2000-02-23               8.3333               0.0046               8.2247  2000\n",
       "298 2000-02-24               8.1926              -0.0170               8.2142  2000\n",
       "299 2000-02-25               8.1222              -0.0086               8.2029  2000\n",
       "300 2000-02-28               7.9782              -0.0179               8.1903  2000\n",
       "301 2000-02-29               8.0403               0.0078               8.1799  2000\n",
       "302 2000-03-01               8.0014              -0.0048               8.1678  2000\n",
       "303 2000-03-02               8.0494               0.0060               8.1577  2000\n",
       "304 2000-03-03               7.9948              -0.0068               8.1456  2000\n",
       "305 2000-03-06               7.9790              -0.0020               8.1350  2000\n",
       "306 2000-03-07               7.9401              -0.0049               8.1235  2000\n",
       "307 2000-03-08               7.8987              -0.0052               8.1104  2000\n",
       "308 2000-03-09               7.9592               0.0076               8.1005  2000\n",
       "309 2000-03-10               7.9567              -0.0003               8.0940  2000\n",
       "310 2000-03-13               8.0419               0.0107               8.0919  2000\n",
       "311 2000-03-14               7.9625              -0.0099               8.0894  2000\n",
       "312 2000-03-15               7.9848               0.0028               8.0875  2000\n",
       "313 2000-03-16               7.9981               0.0017               8.0851  2000\n",
       "314 2000-03-17               8.0055               0.0009               8.0806  2000\n",
       "315 2000-03-20               8.0411               0.0044               8.0792  2000\n",
       "316 2000-03-21               8.0295              -0.0014               8.0736  2000\n",
       "317 2000-03-22               7.9484              -0.0102               8.0645  2000\n",
       "318 2000-03-23               7.9923               0.0055               8.0587  2000\n",
       "319 2000-03-24               8.0411               0.0061               8.0563  2000\n",
       "320 2000-03-27               8.0386              -0.0003               8.0520  2000\n",
       "321 2000-03-28               7.9848              -0.0067               8.0484  2000\n",
       "322 2000-03-29               7.9194              -0.0082               8.0419  2000\n",
       "323 2000-03-30               7.9087              -0.0014               8.0318  2000\n",
       "324 2000-03-31               7.9070              -0.0002               8.0234  2000\n",
       "325 2000-04-03               7.9161               0.0012               8.0154  2000\n",
       "326 2000-04-04               7.8946              -0.0027               8.0020  2000\n",
       "327 2000-04-05               8.0063               0.0140               7.9911  2000\n",
       "328 2000-04-06               7.9666              -0.0050               7.9836  2000\n",
       "329 2000-04-07               7.9161              -0.0064               7.9767  2000\n",
       "330 2000-04-10               7.9376               0.0027               7.9754  2000\n",
       "331 2000-04-11               7.9410               0.0004               7.9720  2000\n",
       "332 2000-04-12               7.9261              -0.0019               7.9695  2000\n",
       "333 2000-04-13               7.8938              -0.0041               7.9643  2000\n",
       "334 2000-04-14               7.8963               0.0003               7.9611  2000\n",
       "335 2000-04-17               7.9236               0.0035               7.9592  2000\n",
       "336 2000-04-18               7.8607              -0.0080               7.9566  2000\n",
       "337 2000-04-19               7.8309              -0.0038               7.9543  2000\n",
       "338 2000-04-20               7.7605              -0.0090               7.9477  2000\n",
       "341 2000-04-25               7.6993              -0.0079               7.9391  2000\n",
       "342 2000-04-26               7.6090              -0.0118               7.9247  2000\n",
       "343 2000-04-27               7.5842              -0.0033               7.9121  2000\n",
       "344 2000-04-28               7.5197              -0.0085               7.8966  2000\n",
       "346 2000-05-02               7.5453               0.0034               7.8815  2000\n",
       "347 2000-05-03               7.3773              -0.0225               7.8605  2000\n",
       "348 2000-05-04               7.4054               0.0038               7.8393  2000\n",
       "349 2000-05-05               7.4361               0.0041               7.8196  2000\n",
       "350 2000-05-08               7.4096              -0.0036               7.8016  2000\n",
       "351 2000-05-09               7.4311               0.0029               7.7829  2000\n",
       "352 2000-05-10               7.5379               0.0143               7.7661  2000\n",
       "353 2000-05-11               7.5147              -0.0031               7.7487  2000\n",
       "354 2000-05-12               7.4733              -0.0055               7.7316  2000\n",
       "355 2000-05-15               7.5710               0.0130               7.7200  2000\n",
       "356 2000-05-16               7.5031              -0.0090               7.7065  2000\n",
       "357 2000-05-17               7.3847              -0.0159               7.6891  2000\n",
       "358 2000-05-18               7.4013               0.0022               7.6719  2000\n",
       "359 2000-05-19               7.3458              -0.0075               7.6536  2000\n",
       "360 2000-05-22               7.4493               0.0140               7.6350  2000\n",
       "361 2000-05-23               7.5412               0.0123               7.6209  2000\n",
       "362 2000-05-24               7.5304              -0.0014               7.6080  2000\n",
       "363 2000-05-25               7.4336              -0.0129               7.5912  2000\n",
       "364 2000-05-26               7.5677               0.0179               7.5788  2000\n",
       "365 2000-05-29               7.6662               0.0129               7.5701  2000\n",
       "366 2000-05-30               7.7464               0.0104               7.5652  2000\n",
       "367 2000-05-31               7.7001              -0.0060               7.5586  2000\n",
       "368 2000-06-01               7.7224               0.0029               7.5519  2000\n",
       "369 2000-06-02               7.7431               0.0027               7.5480  2000\n",
       "370 2000-06-05               7.8077               0.0083               7.5472  2000\n",
       "371 2000-06-06               7.8507               0.0055               7.5503  2000\n",
       "372 2000-06-07               7.9078               0.0072               7.5572  2000\n",
       "373 2000-06-08               8.0022               0.0119               7.5703  2000\n",
       "374 2000-06-09               7.8549              -0.0186               7.5793  2000\n",
       "375 2000-06-12               7.8855               0.0039               7.5915  2000\n",
       "376 2000-06-13               7.9318               0.0059               7.6044  2000\n",
       "377 2000-06-14               7.9757               0.0055               7.6244  2000\n",
       "378 2000-06-15               7.8830              -0.0117               7.6403  2000\n",
       "379 2000-06-16               7.9170               0.0043               7.6563  2000\n",
       "380 2000-06-19               7.9790               0.0078               7.6753  2000\n",
       "381 2000-06-20               7.8946              -0.0106               7.6907  2000\n",
       "382 2000-06-21               7.8383              -0.0072               7.7008  2000\n",
       "383 2000-06-22               7.7845              -0.0069               7.7097  2000\n",
       "384 2000-06-23               7.7911               0.0008               7.7203  2000\n",
       "385 2000-06-26               7.7200              -0.0092               7.7253  2000\n",
       "386 2000-06-27               7.7812               0.0079               7.7346  2000\n",
       "387 2000-06-28               7.7928               0.0015               7.7482  2000\n",
       "388 2000-06-29               7.8665               0.0094               7.7637  2000\n",
       "389 2000-06-30               7.9095               0.0055               7.7825  2000\n",
       "390 2000-07-03               7.8574              -0.0066               7.7961  2000\n",
       "391 2000-07-04               7.8524              -0.0006               7.8065  2000\n",
       "392 2000-07-05               7.8938               0.0053               7.8186  2000\n",
       "393 2000-07-06               7.8979               0.0005               7.8340  2000\n",
       "394 2000-07-07               7.8491              -0.0062               7.8434  2000\n",
       "395 2000-07-10               7.8822               0.0042               7.8506  2000\n",
       "396 2000-07-11               7.8855               0.0004               7.8553  2000\n",
       "397 2000-07-12               7.8623              -0.0029               7.8607  2000\n",
       "398 2000-07-13               7.7382              -0.0159               7.8612  2000\n",
       "399 2000-07-14               7.7340              -0.0005               7.8609  2000\n",
       "400 2000-07-17               7.7407               0.0009               7.8587  2000\n",
       "401 2000-07-18               7.7415               0.0001               7.8550  2000\n",
       "402 2000-07-19               7.6281              -0.0148               7.8457  2000\n",
       "403 2000-07-20               7.6314               0.0004               7.8333  2000\n",
       "404 2000-07-21               7.7498               0.0154               7.8298  2000\n",
       "405 2000-07-24               7.7241              -0.0033               7.8244  2000\n",
       "406 2000-07-25               7.7887               0.0083               7.8197  2000\n",
       "407 2000-07-26               7.7721              -0.0021               7.8129  2000\n",
       "408 2000-07-27               7.7713              -0.0001               7.8092  2000\n",
       "409 2000-07-28               7.6777              -0.0121               7.8012  2000\n",
       "410 2000-07-31               7.6504              -0.0036               7.7902  2000\n",
       "411 2000-08-01               7.6678               0.0023               7.7827  2000\n",
       "412 2000-08-02               7.5668              -0.0133               7.7736  2000\n",
       "413 2000-08-03               7.4725              -0.0125               7.7632  2000\n",
       "414 2000-08-04               7.4750               0.0003               7.7527  2000\n",
       "415 2000-08-07               7.5188               0.0058               7.7460  2000\n",
       "416 2000-08-08               7.4882              -0.0041               7.7362  2000\n",
       "417 2000-08-09               7.4270              -0.0082               7.7240  2000\n",
       "418 2000-08-10               7.4750               0.0064               7.7110  2000\n",
       "419 2000-08-11               7.5586               0.0111               7.6993  2000\n",
       "420 2000-08-14               7.4584              -0.0133               7.6860  2000\n",
       "421 2000-08-15               7.5470               0.0118               7.6758  2000\n",
       "422 2000-08-16               7.5089              -0.0051               7.6630  2000\n",
       "423 2000-08-17               7.5652               0.0075               7.6519  2000\n",
       "424 2000-08-18               7.5544              -0.0014               7.6421  2000\n",
       "425 2000-08-21               7.4683              -0.0115               7.6283  2000\n",
       "426 2000-08-22               7.4261              -0.0057               7.6129  2000\n",
       "427 2000-08-23               7.3814              -0.0060               7.5969  2000\n",
       "428 2000-08-24               7.4592               0.0105               7.5876  2000\n",
       "429 2000-08-25               7.4667               0.0010               7.5787  2000\n",
       "430 2000-08-28               7.4551              -0.0016               7.5692  2000\n",
       "431 2000-08-29               7.4203              -0.0047               7.5585  2000\n",
       "432 2000-08-30               7.3740              -0.0063               7.5500  2000\n",
       "433 2000-08-31               7.3715              -0.0003               7.5413  2000\n",
       "434 2000-09-01               7.3682              -0.0004               7.5286  2000\n",
       "435 2000-09-04               7.4493               0.0109               7.5195  2000\n",
       "436 2000-09-05               7.3549              -0.0128               7.5050  2000\n",
       "437 2000-09-06               7.2987              -0.0077               7.4892  2000\n",
       "438 2000-09-07               7.1811              -0.0162               7.4695  2000\n",
       "439 2000-09-08               7.2300               0.0068               7.4546  2000\n",
       "440 2000-09-11               7.1257              -0.0145               7.4371  2000\n",
       "441 2000-09-12               7.1298               0.0006               7.4192  2000\n",
       "442 2000-09-13               7.1629               0.0046               7.4057  2000\n",
       "443 2000-09-14               7.1952               0.0045               7.3965  2000\n",
       "444 2000-09-15               7.1306              -0.0090               7.3850  2000\n",
       "445 2000-09-18               7.0570              -0.0104               7.3696  2000\n",
       "446 2000-09-19               7.0694               0.0018               7.3557  2000\n",
       "447 2000-09-20               7.0156              -0.0076               7.3419  2000\n",
       "448 2000-09-21               7.0553               0.0056               7.3280  2000\n",
       "449 2000-09-22               7.3583               0.0420               7.3213  2000\n",
       "450 2000-09-25               7.2589              -0.0136               7.3146  2000\n",
       "451 2000-09-26               7.2482              -0.0015               7.3047  2000\n",
       "452 2000-09-27               7.3342               0.0118               7.2989  2000\n",
       "453 2000-09-28               7.3102              -0.0033               7.2904  2000\n",
       "454 2000-09-29               7.2548              -0.0076               7.2804  2000\n",
       "455 2000-10-02               7.2854               0.0042               7.2743  2000\n",
       "456 2000-10-03               7.2531              -0.0044               7.2685  2000\n",
       "457 2000-10-04               7.2258              -0.0038               7.2633  2000\n",
       "458 2000-10-05               7.2722               0.0064               7.2571  2000\n",
       "459 2000-10-06               7.2035              -0.0095               7.2483  2000\n",
       "460 2000-10-09               7.1969              -0.0009               7.2397  2000\n",
       "461 2000-10-10               7.2184               0.0030               7.2330  2000\n",
       "462 2000-10-11               7.2175              -0.0001               7.2278  2000\n",
       "463 2000-10-12               7.1579              -0.0083               7.2206  2000\n",
       "464 2000-10-13               7.1406              -0.0024               7.2130  2000\n",
       "465 2000-10-16               7.0446              -0.0135               7.1996  2000\n",
       "466 2000-10-17               7.0321              -0.0018               7.1888  2000\n",
       "467 2000-10-18               7.0561               0.0034               7.1807  2000\n",
       "468 2000-10-19               6.9618              -0.0135               7.1734  2000\n",
       "469 2000-10-20               6.9957               0.0049               7.1656  2000\n",
       "470 2000-10-23               6.9336              -0.0089               7.1592  2000\n",
       "471 2000-10-24               6.9411               0.0011               7.1529  2000\n",
       "472 2000-10-25               6.8757              -0.0095               7.1433  2000\n",
       "473 2000-10-26               6.8302              -0.0066               7.1312  2000\n",
       "474 2000-10-27               6.8898               0.0087               7.1231  2000\n",
       "475 2000-10-30               7.0206               0.0188               7.1219  2000\n",
       "476 2000-10-31               6.9668              -0.0077               7.1185  2000\n",
       "477 2000-11-01               7.0801               0.0161               7.1206  2000\n",
       "478 2000-11-02               7.1563               0.0107               7.1240  2000\n",
       "479 2000-11-03               7.2258               0.0097               7.1196  2000\n",
       "480 2000-11-06               7.1737              -0.0072               7.1168  2000\n",
       "481 2000-11-07               7.1075              -0.0093               7.1121  2000\n",
       "482 2000-11-08               7.0843              -0.0033               7.1037  2000\n",
       "483 2000-11-09               7.0611              -0.0033               7.0954  2000\n",
       "484 2000-11-10               7.1786               0.0165               7.0929  2000\n",
       "485 2000-11-13               7.1348              -0.0061               7.0879  2000\n",
       "486 2000-11-14               7.1041              -0.0043               7.0829  2000\n",
       "487 2000-11-15               7.1149               0.0015               7.0792  2000\n",
       "488 2000-11-16               7.0926              -0.0031               7.0732  2000\n",
       "489 2000-11-17               7.0644              -0.0040               7.0686  2000\n",
       "490 2000-11-20               7.0255              -0.0055               7.0629  2000\n",
       "491 2000-11-21               7.0139              -0.0017               7.0561  2000\n",
       "492 2000-11-22               6.9767              -0.0053               7.0480  2000\n",
       "493 2000-11-23               6.9750              -0.0002               7.0419  2000\n",
       "494 2000-11-24               6.9825               0.0011               7.0367  2000\n",
       "495 2000-11-27               6.9576              -0.0036               7.0338  2000\n",
       "496 2000-11-28               7.0859               0.0183               7.0356  2000\n",
       "497 2000-11-29               7.1596               0.0103               7.0390  2000\n",
       "498 2000-11-30               7.1877               0.0039               7.0465  2000\n",
       "499 2000-12-01               7.2300               0.0059               7.0543  2000\n",
       "500 2000-12-04               7.3732               0.0196               7.0690  2000\n",
       "501 2000-12-05               7.2920              -0.0111               7.0807  2000\n",
       "502 2000-12-06               7.3069               0.0020               7.0951  2000\n",
       "503 2000-12-07               7.4021               0.0129               7.1141  2000\n",
       "504 2000-12-08               7.3624              -0.0054               7.1299  2000\n",
       "505 2000-12-11               7.2871              -0.0103               7.1388  2000\n",
       "506 2000-12-12               7.2689              -0.0025               7.1488  2000\n",
       "507 2000-12-13               7.2407              -0.0039               7.1542  2000\n",
       "508 2000-12-14               7.3160               0.0103               7.1595  2000\n",
       "509 2000-12-15               7.4361               0.0163               7.1665  2000\n",
       "510 2000-12-18               7.4212              -0.0020               7.1748  2000\n",
       "511 2000-12-19               7.3690              -0.0071               7.1835  2000\n",
       "512 2000-12-20               7.4981               0.0174               7.1973  2000\n",
       "513 2000-12-21               7.5701               0.0096               7.2143  2000\n",
       "514 2000-12-22               7.6479               0.0102               7.2299  2000\n",
       "517 2000-12-27               7.7059               0.0076               7.2489  2000\n",
       "518 2000-12-28               7.6852              -0.0027               7.2683  2000\n",
       "519 2000-12-29               7.7017               0.0021               7.2879  2000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(all_the_years[0])"
   ]
  }
 ],
 "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.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}