banknifty-analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "163d0336",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e336706b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           Date          Open          High           Low         Close     Adj Close       Volume\n",
      "0    2007-09-17   6898.000000   7506.350098   6843.000000   7464.500000   7464.500000          0.0\n",
      "1    2007-09-24   7514.399902   8082.850098   7490.200195   8042.200195   8042.200195          0.0\n",
      "2    2007-10-01   8008.549805   8235.799805   7789.700195   7845.250000   7845.250000          0.0\n",
      "3    2007-10-08   7853.149902   8177.750000   7516.450195   7934.000000   7934.000000          0.0\n",
      "4    2007-10-15   7962.549805   8491.650391   7279.299805   7423.799805   7423.799805          0.0\n",
      "5    2007-10-22   7374.350098   8804.900391   7289.200195   8749.900391   8749.900391          0.0\n",
      "6    2007-10-29   8918.049805   9610.700195   8832.500000   9560.700195   9560.700195          0.0\n",
      "7    2007-11-05   9549.799805   9692.500000   8671.400391   8760.750000   8760.750000          0.0\n",
      "8    2007-11-12   8596.150391   9651.849609   8429.349609   9474.150391   9474.150391          0.0\n",
      "9    2007-11-19   9541.099609   9595.450195   8650.000000   8977.900391   8977.900391          0.0\n",
      "10   2007-11-26   9136.049805   9437.950195   8938.099609   9375.750000   9375.750000          0.0\n",
      "11   2007-12-03   9391.200195   9804.549805   9341.049805   9796.099609   9796.099609          0.0\n",
      "12   2007-12-10   9800.200195  10124.750000   9723.599609   9803.150391   9803.150391          0.0\n",
      "13   2007-12-17   9790.549805   9792.150391   9125.450195   9245.450195   9245.450195          0.0\n",
      "14   2007-12-24   9316.450195   9842.650391   9316.450195   9828.349609   9828.349609          0.0\n",
      "15   2007-12-31   9861.700195  10333.299805   9790.400391  10233.200195  10233.200195          0.0\n",
      "16   2008-01-07   9983.099609  10634.200195   9948.349609  10561.549805  10561.549805          0.0\n",
      "17   2008-01-14  10614.849609  10774.150391   9648.450195   9739.900391   9739.900391          0.0\n",
      "18   2008-01-21   9671.400391   9827.299805   7958.950195   9752.250000   9752.250000          0.0\n",
      "19   2008-01-28   9748.349609  10113.349609   9002.200195   9327.049805   9327.049805          0.0\n",
      "20   2008-02-04   9444.400391   9708.599609   8624.750000   8817.000000   8817.000000          0.0\n",
      "21   2008-02-11   8841.200195   9403.700195   8216.900391   9380.049805   9380.049805          0.0\n",
      "22   2008-02-18   9411.250000   9538.700195   8642.000000   8685.099609   8685.099609          0.0\n",
      "23   2008-02-25   8715.799805   8903.450195   8248.750000   8688.349609   8688.349609          0.0\n",
      "24   2008-03-03   8460.599609   8460.599609   7064.500000   7268.149902   7268.149902          0.0\n",
      "25   2008-03-10   7163.500000   7705.649902   6840.649902   7106.000000   7106.000000          0.0\n",
      "26   2008-03-17   6956.000000   6956.000000   6335.000000   6456.549805   6456.549805          0.0\n",
      "27   2008-03-24   6461.649902   7230.799805   6456.799805   7037.850098   7037.850098          0.0\n",
      "28   2008-03-31   6970.549805   6970.549805   6446.700195   6545.149902   6545.149902          0.0\n",
      "29   2008-04-07   6485.399902   7094.850098   6485.399902   6838.450195   6838.450195          0.0\n",
      "30   2008-04-14   6773.299805   7213.799805   6687.899902   7165.049805   7165.049805          0.0\n",
      "31   2008-04-21   7174.450195   7651.399902   7117.649902   7616.299805   7616.299805          0.0\n",
      "32   2008-04-28   7643.350098   7900.850098   7567.850098   7871.899902   7871.899902          0.0\n",
      "33   2008-05-05   7879.649902   7990.450195   7267.899902   7299.000000   7299.000000          0.0\n",
      "34   2008-05-12   7274.700195   7666.899902   7140.100098   7644.600098   7644.600098          0.0\n",
      "35   2008-05-19   7616.850098   7616.850098   6994.899902   7009.049805   7009.049805          0.0\n",
      "36   2008-05-26   6899.899902   6925.399902   6502.450195   6584.350098   6584.350098          0.0\n",
      "37   2008-06-02   6577.299805   6677.149902   5974.100098   6140.049805   6140.049805          0.0\n",
      "38   2008-06-09   5960.899902   6092.299805   5702.500000   5993.149902   5993.149902          0.0\n",
      "39   2008-06-16   6030.600098   6455.200195   5731.250000   5758.600098   5758.600098          0.0\n",
      "40   2008-06-23   5686.549805   5737.049805   5183.200195   5210.899902   5210.899902          0.0\n",
      "41   2008-06-30   5214.100098   5214.100098   4633.950195   4990.899902   4990.899902          0.0\n",
      "42   2008-07-07   5009.100098   5404.649902   4843.600098   5240.700195   5240.700195          0.0\n",
      "43   2008-07-14   5179.950195   5418.399902   4676.450195   5389.149902   5389.149902          0.0\n",
      "44   2008-07-21   5448.200195   6468.399902   5406.299805   5917.250000   5917.250000          0.0\n",
      "45   2008-07-28   5900.299805   5989.450195   5394.950195   5961.899902   5961.899902          0.0\n",
      "46   2008-08-04   5932.450195   6725.700195   5888.850098   6447.500000   6447.500000          0.0\n",
      "47   2008-08-11   6574.500000   6754.450195   6010.049805   6030.049805   6030.049805          0.0\n",
      "48   2008-08-18   5999.149902   6114.149902   5649.899902   5776.049805   5776.049805          0.0\n",
      "49   2008-08-25   5897.200195   6112.250000   5686.600098   6102.049805   6102.049805          0.0\n",
      "50   2008-09-01   6070.899902   6624.000000   5941.450195   6288.600098   6288.600098          0.0\n",
      "51   2008-09-08   6608.000000   6631.950195   6168.799805   6194.149902   6194.149902          0.0\n",
      "52   2008-09-15   6006.700195   6357.200195   5551.700195   6312.049805   6312.049805          0.0\n",
      "53   2008-09-22   6396.200195   6396.200195   5797.500000   5828.600098   5828.600098          0.0\n",
      "54   2008-09-29   5863.049805   6040.149902   5296.600098   5793.350098   5793.350098          0.0\n",
      "55   2008-10-06   5702.850098   5798.899902   4662.200195   4938.000000   4938.000000          0.0\n",
      "56   2008-10-13   5034.649902   5799.000000   5034.649902   5183.549805   5183.549805          0.0\n",
      "57   2008-10-20   5237.600098   5478.399902   4229.649902   4310.049805   4310.049805          0.0\n",
      "58   2008-10-27   4280.549805   4621.649902   3799.350098   4521.700195   4521.700195          0.0\n",
      "59   2008-11-03   4791.799805   5431.899902   4779.600098   5043.549805   5043.549805          0.0\n",
      "60   2008-11-10   5097.850098   5274.850098   4668.049805   4719.399902   4719.399902          0.0\n",
      "61   2008-11-17   4736.250000   4736.250000   3972.149902   4300.700195   4300.700195          0.0\n",
      "62   2008-11-24   4274.299805   4355.600098   4005.350098   4291.149902   4291.149902          0.0\n",
      "63   2008-12-01   4317.799805   4611.450195   3919.000000   4357.000000   4357.000000          0.0\n",
      "64   2008-12-08   4502.049805   4687.500000   4407.200195   4655.299805   4655.299805          0.0\n",
      "65   2008-12-15   4714.950195   5226.850098   4677.299805   5144.149902   5144.149902          0.0\n",
      "66   2008-12-22   5119.250000   5213.299805   4770.200195   4789.450195   4789.450195          0.0\n",
      "67   2008-12-29   4774.700195   5258.649902   4684.799805   5195.100098   5195.100098          0.0\n",
      "68   2009-01-05   5273.450195   5448.799805   4840.000000   4906.700195   4906.700195          0.0\n",
      "69   2009-01-12   4862.000000   4881.500000   4442.700195   4581.250000   4581.250000          0.0\n",
      "70   2009-01-19   4585.700195   4622.000000   4049.899902   4082.149902   4082.149902          0.0\n",
      "71   2009-01-26   4082.149902   4487.850098   4082.149902   4456.549805   4456.549805          0.0\n",
      "72   2009-02-02   4403.899902   4405.350098   4191.100098   4334.149902   4334.149902          0.0\n",
      "73   2009-02-09   4365.549805   4602.149902   4365.549805   4565.850098   4565.850098          0.0\n",
      "74   2009-02-16   4538.600098   4551.750000   3912.350098   3934.399902   3934.399902          0.0\n",
      "75   2009-02-23   3934.399902   3976.050049   3758.399902   3892.399902   3892.399902          0.0\n",
      "76   2009-03-02   3831.250000   3831.250000   3338.800049   3455.350098   3455.350098          0.0\n",
      "77   2009-03-09   3424.350098   3646.649902   3314.550049   3632.750000   3632.750000          0.0\n",
      "78   2009-03-16   3651.300049   3802.100098   3615.600098   3691.699951   3691.699951          0.0\n",
      "79   2009-03-23   3763.750000   4423.649902   3743.000000   4406.799805   4406.799805          0.0\n",
      "80   2009-03-30   4368.049805   4489.850098   3871.449951   4426.049805   4426.049805          0.0\n",
      "81   2009-04-06   4501.250000   4639.500000   4259.649902   4584.799805   4584.799805          0.0\n",
      "82   2009-04-13   4661.950195   5193.299805   4661.950195   5056.899902   5056.899902          0.0\n",
      "83   2009-04-20   5107.000000   5201.899902   4725.700195   5125.350098   5125.350098          0.0\n",
      "84   2009-04-27   5042.000000   5288.700195   4909.399902   5130.950195   5130.950195          0.0\n",
      "85   2009-05-04   5291.250000   5649.399902   5291.250000   5409.750000   5409.750000          0.0\n",
      "86   2009-05-11   5463.600098   5719.450195   5313.149902   5695.049805   5695.049805          0.0\n",
      "87   2009-05-18   6304.250000   7567.899902   6304.250000   7036.299805   7036.299805          0.0\n",
      "88   2009-05-25   7033.700195   7496.750000   6813.100098   7414.350098   7414.350098          0.0\n",
      "89   2009-06-01   7559.299805   7559.299805   7111.950195   7348.399902   7348.399902          0.0\n",
      "90   2009-06-08   7322.100098   7402.000000   6909.500000   7083.100098   7083.100098          0.0\n",
      "91   2009-06-15   7013.549805   7339.250000   6967.000000   7223.549805   7223.549805          0.0\n",
      "92   2009-06-22   7261.500000   7417.500000   6989.100098   7398.450195   7398.450195          0.0\n",
      "93   2009-06-29   7446.450195   7626.950195   7270.299805   7566.049805   7566.049805          0.0\n",
      "94   2009-07-06   7566.049805   7711.399902   6469.000000   6520.600098   6520.600098          0.0\n",
      "95   2009-07-13   6456.899902   7253.299805   6393.500000   7231.049805   7231.049805          0.0\n",
      "96   2009-07-20   7273.950195   7614.750000   7239.399902   7385.549805   7385.549805          0.0\n",
      "97   2009-07-27   7441.600098   7611.700195   7092.049805   7544.500000   7544.500000          0.0\n",
      "98   2009-08-03   7564.049805   7720.350098   7226.700195   7249.500000   7249.500000          0.0\n",
      "99   2009-08-10   7363.600098   7502.950195   6988.549805   7418.950195   7418.950195          0.0\n",
      "100  2009-08-17   7311.899902   7404.700195   6998.799805   7377.100098   7377.100098          0.0\n",
      "101  2009-08-24   7472.600098   7536.100098   7366.000000   7482.399902   7482.399902          0.0\n",
      "102  2009-08-31   7382.000000   7577.399902   7292.700195   7444.149902   7444.149902          0.0\n",
      "103  2009-09-07   7503.149902   7944.649902   7495.399902   7914.950195   7914.950195          0.0\n",
      "104  2009-09-14   7879.450195   8495.950195   7877.950195   8379.250000   8379.250000          0.0\n",
      "105  2009-09-21   8377.799805   8584.200195   8341.099609   8456.250000   8456.250000          0.0\n",
      "106  2009-09-28   8490.400391   8911.750000   8465.900391   8861.049805   8861.049805          0.0\n",
      "107  2009-10-05   8765.900391   8971.500000   8555.000000   8696.799805   8696.799805          0.0\n",
      "108  2009-10-12   8720.700195   9555.900391   8698.549805   9526.700195   9526.700195          0.0\n",
      "109  2009-10-19   9548.049805   9630.349609   9057.099609   9188.400391   9188.400391          0.0\n",
      "110  2009-10-26   9193.200195   9225.200195   8370.150391   8438.599609   8438.599609          0.0\n",
      "111  2009-11-02   8372.099609   8780.000000   8207.750000   8723.750000   8723.750000          0.0\n",
      "112  2009-11-09   8750.700195   9355.400391   8750.700195   9155.650391   9155.650391          0.0\n",
      "113  2009-11-16   9201.849609   9339.099609   8890.099609   9219.049805   9219.049805          0.0\n",
      "114  2009-11-23   9256.750000   9340.750000   8591.750000   8945.049805   8945.049805          0.0\n",
      "115  2009-11-30   9121.700195   9435.900391   8989.000000   9245.049805   9245.049805          0.0\n",
      "116  2009-12-07   9257.599609   9309.750000   9054.750000   9097.200195   9097.200195          0.0\n",
      "117  2009-12-14   9072.849609   9131.549805   8577.700195   8599.950195   8599.950195          0.0\n",
      "118  2009-12-21   8601.000000   9012.450195   8560.150391   8968.099609   8968.099609          0.0\n",
      "119  2009-12-28   8990.349609   9093.650391   8937.299805   9029.500000   9029.500000          0.0\n",
      "120  2010-01-04   9031.900391   9265.549805   9031.900391   9160.700195   9160.700195          0.0\n",
      "121  2010-01-11   9209.150391   9248.000000   8836.700195   8911.099609   8911.099609          0.0\n",
      "122  2010-01-18   8887.150391   9202.500000   8659.900391   8772.650391   8772.650391          0.0\n",
      "123  2010-01-25   8724.799805   8751.200195   8294.599609   8651.549805   8651.549805          0.0\n",
      "124  2010-02-01   8597.450195   8718.650391   8150.450195   8223.250000   8223.250000          0.0\n",
      "125  2010-02-08   8279.750000   8451.950195   8160.950195   8381.400391   8381.400391          0.0\n",
      "126  2010-02-15   8441.599609   8602.000000   8282.049805   8487.099609   8487.099609          0.0\n",
      "127  2010-02-22   8565.299805   8851.349609   8453.400391   8722.750000   8722.750000          0.0\n",
      "128  2010-03-01   8826.900391   9095.299805   8826.900391   9038.450195   9038.450195          0.0\n",
      "129  2010-03-08   9102.150391   9230.000000   9073.500000   9172.900391   9172.900391          0.0\n",
      "130  2010-03-15   9118.200195   9294.099609   8986.750000   9270.799805   9270.799805          0.0\n",
      "131  2010-03-22   9171.200195   9473.200195   9066.700195   9456.200195   9456.200195          0.0\n",
      "132  2010-03-29   9452.099609   9587.650391   9440.349609   9507.750000   9507.750000          0.0\n",
      "133  2010-04-05   9593.549805   9793.200195   9492.299805   9656.500000   9656.500000          0.0\n",
      "134  2010-04-12   9661.200195   9667.400391   9266.150391   9353.750000   9353.750000          0.0\n",
      "135  2010-04-19   9273.849609   9824.950195   9206.000000   9813.299805   9813.299805          0.0\n",
      "136  2010-04-26   9890.799805   9923.150391   9603.500000   9870.349609   9870.349609          0.0\n",
      "137  2010-05-03   9809.400391   9863.450195   9239.799805   9276.099609   9276.099609          0.0\n",
      "138  2010-05-10   9419.500000   9849.049805   9402.049805   9589.049805   9589.049805          0.0\n",
      "139  2010-05-17   9485.349609   9572.049805   8969.200195   9135.700195   9135.700195          0.0\n",
      "140  2010-05-24   9524.500000   9524.500000   8806.650391   9312.599609   9312.599609          0.0\n",
      "141  2010-05-31   9305.549805   9490.950195   9083.650391   9455.950195   9455.950195          0.0\n",
      "142  2010-06-07   9221.799805   9463.049805   9143.500000   9451.750000   9451.750000          0.0\n",
      "143  2010-06-14   9496.349609   9636.799805   9422.950195   9576.250000   9576.250000          0.0\n",
      "144  2010-06-21   9626.400391   9793.150391   9429.700195   9451.099609   9451.099609          0.0\n",
      "145  2010-06-28   9456.099609   9551.900391   9301.400391   9357.150391   9357.150391          0.0\n",
      "146  2010-07-05   9335.450195   9726.500000   9312.099609   9713.700195   9713.700195          0.0\n",
      "147  2010-07-12   9745.900391  10061.950195   9737.650391  10013.450195  10013.450195          0.0\n",
      "148  2010-07-19  10001.900391  10120.599609   9914.849609  10093.900391  10093.900391          0.0\n",
      "149  2010-07-26  10108.900391  10243.900391   9951.549805  10161.000000  10161.000000          0.0\n",
      "150  2010-08-02  10258.349609  10542.900391  10255.400391  10383.650391  10383.650391          0.0\n",
      "151  2010-08-09  10407.549805  10782.200195  10308.150391  10737.349609  10737.349609          0.0\n",
      "152  2010-08-16  10732.049805  11126.950195  10645.450195  11033.750000  11033.750000          0.0\n",
      "153  2010-08-23  11024.500000  11125.799805  10681.599609  10727.450195  10727.450195          0.0\n",
      "154  2010-08-30  10834.400391  11017.150391  10653.299805  10991.200195  10991.200195          0.0\n",
      "155  2010-09-06  11033.599609  11468.750000  11033.599609  11446.700195  11446.700195          0.0\n",
      "156  2010-09-13  11489.500000  12236.849609  11489.500000  12104.099609  12104.099609          0.0\n",
      "157  2010-09-20  12109.049805  12340.000000  12067.400391  12263.549805  12263.549805          0.0\n",
      "158  2010-09-27  12323.450195  12579.950195  12163.349609  12556.750000  12556.750000          0.0\n",
      "159  2010-10-04  12605.450195  12738.500000  12414.799805  12473.400391  12473.400391          0.0\n",
      "160  2010-10-11  12514.900391  12827.349609  12324.400391  12346.450195  12346.450195          0.0\n",
      "161  2010-10-18  12451.549805  12535.849609  12139.900391  12384.799805  12384.799805          0.0\n",
      "162  2010-10-25  12423.349609  12580.500000  11955.549805  12330.750000  12330.750000          0.0\n",
      "163  2010-11-01  12485.500000  13303.599609  12485.500000  13268.700195  13268.700195          0.0\n",
      "164  2010-11-08  13288.049805  13301.450195  12428.799805  12457.299805  12457.299805          0.0\n",
      "165  2010-11-15  12467.500000  12826.900391  12013.650391  12062.950195  12062.950195          0.0\n",
      "166  2010-11-22  12120.799805  12414.549805  11362.900391  11668.849609  11668.849609          0.0\n",
      "167  2010-11-29  11731.349609  12535.849609  11707.849609  12349.200195  12349.200195          0.0\n",
      "168  2010-12-06  12427.950195  12429.450195  10977.900391  11447.000000  11447.000000          0.0\n",
      "169  2010-12-13  11527.349609  11623.700195  11147.450195  11424.150391  11424.150391          0.0\n",
      "170  2010-12-20  11401.049805  11634.650391  11237.200195  11477.049805  11477.049805          0.0\n",
      "171  2010-12-27  11491.400391  11828.400391  11392.900391  11791.450195  11791.450195          0.0\n",
      "172  2011-01-03  11882.099609  11912.150391  11007.900391  11053.349609  11053.349609          0.0\n",
      "173  2011-01-10  11024.500000  11161.150391  10387.900391  10432.900391  10432.900391          0.0\n",
      "174  2011-01-17  10459.599609  10923.700195  10373.799805  10889.400391  10889.400391          0.0\n",
      "175  2011-01-24  10923.750000  11256.950195  10481.099609  10578.250000  10578.250000          0.0\n",
      "176  2011-01-31  10444.349609  10772.450195  10385.900391  10433.849609  10433.849609          0.0\n",
      "177  2011-02-07  10457.799805  10509.799805  10017.849609  10447.750000  10447.750000          0.0\n",
      "178  2011-02-14  10477.849609  11300.450195  10477.849609  10949.700195  10949.700195          0.0\n",
      "179  2011-02-21  10935.299805  11070.349609  10169.000000  10435.849609  10435.849609          0.0\n",
      "180  2011-02-28  10512.200195  11134.099609  10364.349609  10963.400391  10963.400391          0.0\n",
      "181  2011-03-07  10886.099609  11054.000000  10658.299805  10740.950195  10740.950195          0.0\n",
      "182  2011-03-14  10730.400391  11018.299805  10591.299805  10715.900391  10715.900391          0.0\n",
      "183  2011-03-21  10795.650391  11420.400391  10661.150391  11387.299805  11387.299805          0.0\n",
      "184  2011-03-28  11348.849609  11898.400391  11348.150391  11590.950195  11590.950195          0.0\n",
      "185  2011-04-04  11614.450195  11861.150391  11614.450195  11673.250000  11673.250000          0.0\n",
      "186  2011-04-11  11591.000000  11950.700195  11490.549805  11735.650391  11735.650391          0.0\n",
      "187  2011-04-18  11754.200195  11926.049805  11482.150391  11894.750000  11894.750000          0.0\n",
      "188  2011-04-25  11860.349609  11978.049805  11406.849609  11483.750000  11483.750000          0.0\n",
      "189  2011-05-02  11509.299805  11543.349609  10677.299805  11145.099609  11145.099609          0.0\n",
      "190  2011-05-09  11194.450195  11213.500000  10838.150391  11020.950195  11020.950195          0.0\n",
      "191  2011-05-16  10975.150391  10975.150391  10524.349609  10664.099609  10664.099609          0.0\n",
      "192  2011-05-23  10612.549805  10735.200195  10339.950195  10722.650391  10722.650391          0.0\n",
      "193  2011-05-30  10742.000000  11056.400391  10715.099609  10782.000000  10782.000000          0.0\n",
      "194  2011-06-06  10734.250000  10918.250000  10627.599609  10714.250000  10714.250000          0.0\n",
      "195  2011-06-13  10675.299805  10830.400391  10502.400391  10598.250000  10598.250000          0.0\n",
      "196  2011-06-20  10592.650391  10875.250000  10340.400391  10854.500000  10854.500000          0.0\n",
      "197  2011-06-27  10808.900391  11359.950195  10774.099609  11255.000000  11255.000000          0.0\n",
      "198  2011-07-04  11379.049805  11451.250000  11232.150391  11285.150391  11285.150391          0.0\n",
      "199  2011-07-11  11275.000000  11385.349609  10941.299805  11234.549805  11234.549805          0.0\n",
      "200  2011-07-18  11234.700195  11388.500000  11021.700195  11291.950195  11291.950195          0.0\n",
      "201  2011-07-25  11286.250000  11433.099609  10758.400391  10893.650391  10893.650391          0.0\n",
      "202  2011-08-01  11014.150391  11064.900391  10150.299805  10354.500000  10354.500000          0.0\n",
      "203  2011-08-08  10121.400391  10516.900391   9920.799805  10182.700195  10182.700195          0.0\n",
      "204  2011-08-15  10182.700195  10315.099609   9280.250000   9404.849609   9404.849609          0.0\n",
      "205  2011-08-22   9422.650391   9561.900391   8917.950195   8974.549805   8974.549805          0.0\n",
      "206  2011-08-29   9099.849609   9707.450195   9099.849609   9581.349609   9581.349609          0.0\n",
      "207  2011-09-05   9509.000000   9972.000000   9364.599609   9678.700195   9678.700195          0.0\n",
      "208  2011-09-12   9550.950195   9798.750000   9260.900391   9720.250000   9720.250000          0.0\n",
      "209  2011-09-19   9664.349609   9962.950195   9284.650391   9375.700195   9375.700195          0.0\n",
      "210  2011-09-26   9373.950195   9688.650391   9165.799805   9468.299805   9468.299805          0.0\n",
      "211  2011-10-03   9332.599609   9332.599609   8626.450195   9038.250000   9038.250000          0.0\n",
      "212  2011-10-10   9051.000000   9691.849609   8982.900391   9660.400391   9660.400391          0.0\n",
      "213  2011-10-17   9717.349609   9865.849609   9492.950195   9695.349609   9695.349609          0.0\n",
      "214  2011-10-24   9819.500000   9932.400391   9323.000000   9917.049805   9917.049805          0.0\n",
      "215  2011-10-31   9932.000000  10080.049805   9648.650391   9836.349609   9836.349609          0.0\n",
      "216  2011-11-07   9836.349609   9896.150391   9270.349609   9292.549805   9292.549805          0.0\n",
      "217  2011-11-14   9416.349609   9458.349609   8706.000000   8850.250000   8850.250000          0.0\n",
      "218  2011-11-21   8806.700195   8806.700195   8240.450195   8488.599609   8488.599609          0.0\n",
      "219  2011-11-28   8598.700195   9200.650391   8490.349609   9172.750000   9172.750000          0.0\n",
      "220  2011-12-05   9154.900391   9273.099609   8689.849609   8811.099609   8811.099609          0.0\n",
      "221  2011-12-12   8900.900391   8920.250000   8127.200195   8171.899902   8171.899902          0.0\n",
      "222  2011-12-19   8122.250000   8451.950195   7766.350098   8296.450195   8296.450195          0.0\n",
      "223  2011-12-26   8348.549805   8365.750000   7925.149902   7968.649902   7968.649902          0.0\n",
      "224  2012-01-02   8072.799805   8586.650391   8072.799805   8488.250000   8488.250000          0.0\n",
      "225  2012-01-09   8450.400391   9073.000000   8329.900391   8975.049805   8975.049805          0.0\n",
      "226  2012-01-16   8913.250000   9560.150391   8813.849609   9516.849609   9516.849609          0.0\n",
      "227  2012-01-23   9503.099609   9969.250000   9456.250000   9813.650391   9813.650391          0.0\n",
      "228  2012-01-30   9741.250000  10158.950195   9509.150391  10133.650391  10133.650391          0.0\n",
      "229  2012-02-06  10219.599609  10555.000000  10183.450195  10442.650391  10442.650391          0.0\n",
      "230  2012-02-13  10451.099609  11203.349609  10335.700195  11074.900391  11074.900391          0.0\n",
      "231  2012-02-20  11042.599609  11226.750000  10435.549805  10506.799805  10506.799805          0.0\n",
      "232  2012-02-27  10527.650391  10667.299805  10073.900391  10434.299805  10434.299805          0.0\n",
      "233  2012-03-05  10406.849609  10526.549805   9939.950195  10505.650391  10505.650391          0.0\n",
      "234  2012-03-12  10765.950195  10912.049805  10348.049805  10391.349609  10391.349609          0.0\n",
      "235  2012-03-19  10440.849609  10583.750000  10125.750000  10294.549805  10294.549805          0.0\n",
      "236  2012-03-26  10260.200195  10263.099609   9845.400391  10212.750000  10212.750000          0.0\n",
      "237  2012-04-02  10186.799805  10502.700195  10180.950195  10340.099609  10340.099609          0.0\n",
      "238  2012-04-09  10256.650391  10587.950195  10060.700195  10306.250000  10306.250000          0.0\n",
      "239  2012-04-16  10274.150391  10645.849609  10248.549805  10456.500000  10456.500000          0.0\n",
      "240  2012-04-23  10432.599609  10521.450195  10029.450195  10148.700195  10148.700195          0.0\n",
      "241  2012-04-30  10210.099609  10382.349609   9757.750000   9802.349609   9802.349609          0.0\n",
      "242  2012-05-07   9664.849609   9924.150391   9296.650391   9398.099609   9398.099609          0.0\n",
      "243  2012-05-14   9412.599609   9498.799805   8995.250000   9310.250000   9310.250000          0.0\n",
      "244  2012-05-21   9510.450195   9522.299805   9157.200195   9456.299805   9456.299805          0.0\n",
      "245  2012-05-28   9483.099609   9783.450195   9252.599609   9267.599609   9267.599609          0.0\n",
      "246  2012-06-04   9174.549805  10031.200195   9110.450195   9998.849609   9998.849609          0.0\n",
      "247  2012-06-11  10070.150391  10224.549805   9813.650391  10064.799805  10064.799805          0.0\n",
      "248  2012-06-18  10178.849609  10197.799805   9619.150391  10038.349609  10038.349609          0.0\n",
      "249  2012-06-25  10068.900391  10360.000000   9892.799805  10340.650391  10340.650391          0.0\n",
      "250  2012-07-02  10366.500000  10687.900391  10303.650391  10655.349609  10655.349609          0.0\n",
      "251  2012-07-09  10594.950195  10782.549805  10524.750000  10594.450195  10594.450195          0.0\n",
      "252  2012-07-16  10614.099609  10708.599609  10463.400391  10481.599609  10481.599609          0.0\n",
      "253  2012-07-23  10401.700195  10402.250000  10056.150391  10140.549805  10140.549805          0.0\n",
      "254  2012-07-30  10222.549805  10467.950195  10209.150391  10315.599609  10315.599609          0.0\n",
      "255  2012-08-06  10426.750000  10640.750000  10272.049805  10358.950195  10358.950195          0.0\n",
      "256  2012-08-13  10339.200195  10551.049805  10284.049805  10417.900391  10417.900391          0.0\n",
      "257  2012-08-20  10417.900391  10560.849609  10318.549805  10332.849609  10332.849609          0.0\n",
      "258  2012-08-27  10338.250000  10338.250000   9948.700195   9990.500000   9990.500000          0.0\n",
      "259  2012-09-03  10030.849609  10134.750000   9814.049805  10122.000000  10122.000000          0.0\n",
      "260  2012-09-10  10153.799805  10664.549805  10006.500000  10642.900391  10642.900391          0.0\n",
      "261  2012-09-17  10797.099609  11433.099609  10797.099609  11358.500000  11358.500000          0.0\n",
      "262  2012-09-24  11359.299805  11536.849609  11321.200195  11456.799805  11456.799805          0.0\n",
      "263  2012-10-01  11462.099609  11745.200195  10043.599609  11511.400391  11511.400391          0.0\n",
      "264  2012-10-08  11530.650391  11530.650391  11244.700195  11388.450195  11388.450195          0.0\n",
      "265  2012-10-15  11397.700195  11605.650391  11288.400391  11491.200195  11491.200195          0.0\n",
      "266  2012-10-22  11422.099609  11656.799805  11419.400391  11509.150391  11509.150391          0.0\n",
      "267  2012-10-29  11506.500000  11600.049805  11125.200195  11460.450195  11460.450195          0.0\n",
      "268  2012-11-05  11449.700195  11719.099609  11401.299805  11475.599609  11475.599609          0.0\n",
      "269  2012-11-12  11488.099609  11608.799805  11306.049805  11335.500000  11335.500000          0.0\n",
      "270  2012-11-19  11342.650391  11570.849609  11256.400391  11475.799805  11475.799805          0.0\n",
      "271  2012-11-26  11534.200195  12175.299805  11411.099609  12158.900391  12158.900391          0.0\n",
      "272  2012-12-03  12126.599609  12480.599609  12053.450195  12363.700195  12363.700195          0.0\n",
      "273  2012-12-10  12380.000000  12538.900391  12238.000000  12424.700195  12424.700195          0.0\n",
      "274  2012-12-17  12403.650391  12571.599609  12197.200195  12315.049805  12315.049805          0.0\n",
      "275  2012-12-24  12363.849609  12523.500000  12265.750000  12458.150391  12458.150391          0.0\n",
      "276  2012-12-31  12442.849609  12837.799805  12427.700195  12787.349609  12787.349609          0.0\n",
      "277  2013-01-07  12837.450195  12837.450195  12582.650391  12617.849609  12617.849609          0.0\n",
      "278  2013-01-14  12622.049805  12908.200195  12583.349609  12680.000000  12680.000000          0.0\n",
      "279  2013-01-21  12678.000000  12748.950195  12509.450195  12693.250000  12693.250000          0.0\n",
      "280  2013-01-28  12705.799805  12960.650391  12580.849609  12606.250000  12606.250000          0.0\n",
      "281  2013-02-04  12656.849609  12723.299805  12245.950195  12280.150391  12280.150391          0.0\n",
      "282  2013-02-11  12298.099609  12485.950195  12256.799805  12336.549805  12336.549805          0.0\n",
      "283  2013-02-18  12353.000000  12470.700195  12024.400391  12068.950195  12068.950195          0.0\n",
      "284  2013-02-25  12119.950195  12137.849609  11401.200195  11540.049805  11540.049805          0.0\n",
      "285  2013-03-04  11515.400391  12219.450195  11453.099609  12197.250000  12197.250000          0.0\n",
      "286  2013-03-11  12221.500000  12241.299805  11555.450195  11816.549805  11816.549805          0.0\n",
      "287  2013-03-18  11679.349609  11814.750000  11173.349609  11204.049805  11204.049805          0.0\n",
      "288  2013-03-25  11204.049805  11413.250000  11048.400391  11361.849609  11361.849609          0.0\n",
      "289  2013-04-01  11361.849609  11590.599609  11021.400391  11098.950195  11098.950195          0.0\n",
      "290  2013-04-08  11098.950195  11442.900391  10888.750000  11410.099609  11410.099609          0.0\n",
      "291  2013-04-15  11410.099609  12313.000000  11334.750000  12288.250000  12288.250000          0.0\n",
      "292  2013-04-22  12288.250000  12755.799805  12288.250000  12533.150391  12533.150391          0.0\n",
      "293  2013-04-29  12533.150391  12783.299805  12364.700195  12393.599609  12393.599609          0.0\n",
      "294  2013-05-06  12393.599609  12783.049805  12188.299805  12752.299805  12752.299805          0.0\n",
      "295  2013-05-13  12780.150391  13355.099609  12516.099609  13317.099609  13317.099609          0.0\n",
      "296  2013-05-20  13317.099609  13414.299805  12582.500000  12769.349609  12769.349609          0.0\n",
      "297  2013-05-27  12769.349609  13016.450195  12453.150391  12475.650391  12475.650391          0.0\n",
      "298  2013-06-03  12475.650391  12520.549805  12184.049805  12231.500000  12231.500000          0.0\n",
      "299  2013-06-10  12231.500000  12363.799805  11656.900391  11922.849609  11922.849609          0.0\n",
      "300  2013-06-17  11922.849609  11992.950195  11210.750000  11340.150391  11340.150391          0.0\n",
      "301  2013-06-24  11340.150391  11654.700195  11033.750000  11617.250000  11617.250000          0.0\n",
      "302  2013-07-01  11617.250000  11752.900391  11273.599609  11434.299805  11434.299805          0.0\n",
      "303  2013-07-08  11434.299805  11743.250000  11176.650391  11722.799805  11722.799805          0.0\n",
      "304  2013-07-15  11722.799805  11811.900391  10829.750000  10973.900391  10973.900391          0.0\n",
      "305  2013-07-22  10973.900391  11285.799805  10352.950195  10465.250000  10465.250000          0.0\n",
      "306  2013-07-29  10465.250000  10465.250000   9863.049805   9997.799805   9997.799805          0.0\n",
      "307  2013-08-05   9997.799805  10117.650391   9660.299805   9816.400391   9816.400391          0.0\n",
      "308  2013-08-12   9816.400391  10071.250000   9420.150391   9450.849609   9450.849609          0.0\n",
      "309  2013-08-19   9425.500000   9766.099609   8860.150391   9470.099609   9470.099609     276000.0\n",
      "310  2013-08-26   9529.700195   9586.650391   8366.750000   9049.200195   9049.200195     298200.0\n",
      "311  2013-09-02   9112.799805   9989.849609   8605.650391   9961.400391   9961.400391     210700.0\n",
      "312  2013-09-09   9961.400391  10409.150391   9961.400391  10180.450195  10180.450195     222700.0\n",
      "313  2013-09-16  10418.500000  11219.450195  10175.049805  10686.799805  10686.799805     300500.0\n",
      "314  2013-09-23  10466.299805  10509.549805   9883.950195   9899.750000   9899.750000     237700.0\n",
      "315  2013-09-30   9783.900391  10328.750000   9582.750000  10197.150391  10197.150391     161000.0\n",
      "316  2013-10-07  10124.150391  10649.299805   9877.450195  10622.150391  10622.150391     187000.0\n",
      "317  2013-10-14  10588.950195  10784.000000  10274.349609  10744.900391  10744.900391     155000.0\n",
      "318  2013-10-21  10751.700195  11091.599609  10700.549805  10896.500000  10896.500000     203100.0\n",
      "319  2013-10-28  10924.450195  11694.450195  10669.000000  11628.650391  11628.650391   28430400.0\n",
      "320  2013-11-04  11539.750000  11736.200195  10841.599609  10913.150391  10913.150391     179800.0\n",
      "321  2013-11-11  10786.250000  10940.500000  10412.049805  10811.200195  10811.200195     173100.0\n",
      "322  2013-11-18  10962.250000  11207.700195  10630.549805  10677.349609  10677.349609     175700.0\n",
      "323  2013-11-25  10780.599609  11186.150391  10780.599609  11153.950195  11153.950195     195400.0\n",
      "324  2013-12-02  11180.299805  11770.650391  11107.750000  11720.200195  11720.200195     172400.0\n",
      "325  2013-12-09  12206.950195  12225.950195  11349.849609  11366.900391  11366.900391     167400.0\n",
      "326  2013-12-16  11347.200195  11572.299805  11040.150391  11292.349609  11292.349609     157300.0\n",
      "327  2013-12-23  11258.650391  11514.450195  11258.650391  11459.700195  11459.700195     102400.0\n",
      "328  2013-12-30  11532.599609  11578.900391  11052.599609  11181.650391  11181.650391     103300.0\n",
      "329  2014-01-06  11174.349609  11174.349609  10788.200195  10805.299805  10805.299805     149500.0\n",
      "330  2014-01-13  10814.650391  11192.799805  10814.650391  10911.349609  10911.349609     137000.0\n",
      "331  2014-01-20  10909.900391  11248.349609  10876.250000  10982.400391  10982.400391     108800.0\n",
      "332  2014-01-27  10802.299805  10802.299805  10101.200195  10237.750000  10237.750000     203800.0\n",
      "333  2014-02-03  10205.450195  10321.500000   9944.000000  10263.200195  10263.200195     151500.0\n",
      "334  2014-02-10  10287.349609  10395.150391  10064.750000  10203.750000  10203.750000     111400.0\n",
      "335  2014-02-17  10324.349609  10630.150391  10296.250000  10554.349609  10554.349609      86900.0\n",
      "336  2014-02-24  10508.950195  10793.599609  10471.450195  10764.700195  10764.700195      83700.0\n",
      "337  2014-03-03  10705.450195  11947.500000  10613.000000  11884.750000  11884.750000     214700.0\n",
      "338  2014-03-10  11784.549805  12308.700195  11784.549805  12055.849609  12055.849609     218000.0\n",
      "339  2014-03-17  12093.200195  12268.750000  11989.950195  12092.349609  12092.349609     127800.0\n",
      "340  2014-03-24  12134.650391  12787.500000  12134.650391  12754.700195  12754.700195     196200.0\n",
      "341  2014-03-31  12855.500000  12869.349609  12430.849609  12551.700195  12551.700195     183900.0\n",
      "342  2014-04-07  12562.349609  13055.599609  12439.549805  12840.200195  12840.200195     131100.0\n",
      "343  2014-04-14  12830.500000  12831.599609  12514.750000  12787.250000  12787.250000      90300.0\n",
      "344  2014-04-21  12845.299805  13268.599609  12838.849609  13034.500000  13034.500000     144600.0\n",
      "345  2014-04-28  13038.950195  13124.299805  12738.599609  12842.000000  12842.000000     118300.0\n",
      "346  2014-05-05  12841.400391  13814.250000  12773.049805  13750.500000  13750.500000     157500.0\n",
      "347  2014-05-12  13801.000000  15742.049805  13801.000000  14853.000000  14853.000000     321200.0\n",
      "348  2014-05-19  15032.000000  15362.549805  14857.500000  15285.500000  15285.500000     232900.0\n",
      "349  2014-05-26  15431.950195  15568.049805  14709.299805  14793.400391  14793.400391     198500.0\n",
      "350  2014-06-02  14786.450195  15576.049805  14770.000000  15543.150391  15543.150391     176800.0\n",
      "351  2014-06-09  15625.400391  15725.799805  15083.900391  15106.900391  15106.900391     172400.0\n",
      "352  2014-06-16  15055.200195  15461.549805  14858.900391  14997.650391  14997.650391     153200.0\n",
      "353  2014-06-23  15014.200195  15341.950195  14940.349609  14992.349609  14992.349609     135000.0\n",
      "354  2014-06-30  15059.099609  15582.650391  15059.099609  15556.150391  15556.150391     121400.0\n",
      "355  2014-07-07  15589.500000  15592.799805  14406.650391  14447.200195  14447.200195     171400.0\n",
      "356  2014-07-14  14508.099609  15463.150391  14338.650391  15389.349609  15389.349609     157000.0\n",
      "357  2014-07-21  15510.000000  15626.900391  15272.450195  15322.250000  15322.250000     134900.0\n",
      "358  2014-07-28  15399.500000  15499.500000  15096.099609  15127.799805  15127.799805     127400.0\n",
      "359  2014-08-04  15242.250000  15343.500000  14709.099609  14765.750000  14765.750000     120800.0\n",
      "360  2014-08-11  14858.750000  15144.750000  14807.000000  15089.650391  15089.650391      92500.0\n",
      "361  2014-08-18  15099.700195  15865.299805  15068.349609  15819.150391  15819.150391     146700.0\n",
      "362  2014-08-25  15817.549805  15973.349609  15503.400391  15740.400391  15740.400391      89100.0\n",
      "363  2014-09-01  15790.250000  16208.549805  15790.250000  15982.500000  15982.500000     123900.0\n",
      "364  2014-09-08  16084.200195  16309.700195  16049.250000  16254.150391  16254.150391     111200.0\n",
      "365  2014-09-15  16158.650391  16239.700195  15770.799805  16152.150391  16152.150391     123500.0\n",
      "366  2014-09-22  16052.549805  16272.349609  15168.400391  15607.250000  15607.250000     148000.0\n",
      "367  2014-09-29  15636.450195  15636.450195  15270.950195  15316.200195  15316.200195      69500.0\n",
      "368  2014-10-06  15214.250000  15795.650391  15130.349609  15453.799805  15453.799805      92400.0\n",
      "369  2014-10-13  15360.700195  15973.500000  15301.650391  15929.799805  15929.799805     120500.0\n",
      "370  2014-10-20  16259.700195  16572.500000  16157.049805  16470.050781  16470.050781      94400.0\n",
      "371  2014-10-27  16538.900391  17060.150391  16470.849609  17045.050781  17045.050781     122100.0\n",
      "372  2014-11-03  17087.000000  17425.199219  16934.849609  17347.050781  17347.050781      82300.0\n",
      "373  2014-11-10  17364.650391  17651.000000  17203.000000  17576.800781  17576.800781     118900.0\n",
      "374  2014-11-17  17571.699219  18139.949219  17469.250000  18056.300781  18056.300781     165300.0\n",
      "375  2014-11-24  18128.599609  18615.400391  17890.849609  18513.150391  18513.150391     241600.0\n",
      "376  2014-12-01  18586.949219  18875.449219  18301.000000  18756.750000  18756.750000     230200.0\n",
      "377  2014-12-08  18804.949219  18804.949219  18183.099609  18299.750000  18299.750000     110300.0\n",
      "378  2014-12-15  18176.699219  18563.599609  17502.449219  18478.900391  18478.900391      63600.0\n",
      "379  2014-12-22  18562.349609  18923.599609  18424.000000  18557.199219  18557.199219          0.0\n",
      "380  2014-12-29  18589.599609  19118.849609  18428.099609  19057.800781  19057.800781          0.0\n",
      "381  2015-01-05  19155.199219  19166.000000  18211.500000  18637.250000  18637.250000          0.0\n",
      "382  2015-01-12  18632.000000  19410.400391  18517.900391  19223.150391  19223.150391          0.0\n",
      "383  2015-01-19  19345.650391  20167.650391  19299.099609  20072.699219  20072.699219          0.0\n",
      "384  2015-01-26  20179.800781  20907.550781  19732.449219  19843.750000  19843.750000          0.0\n",
      "385  2015-02-02  19778.949219  19991.400391  18977.900391  19051.900391  19051.900391          0.0\n",
      "386  2015-02-09  18650.000000  19441.000000  18226.900391  19369.699219  19369.699219          0.0\n",
      "387  2015-02-16  19518.849609  19532.699219  18876.250000  19073.550781  19073.550781      61900.0\n",
      "388  2015-02-23  19199.150391  19219.750000  18489.599609  19074.550781  19074.550781          0.0\n",
      "389  2015-03-02  19954.500000  20541.650391  19398.750000  19748.000000  19748.000000      58100.0\n",
      "390  2015-03-09  19545.250000  19545.250000  18737.349609  18779.800781  18779.800781          0.0\n",
      "391  2015-03-16  18786.650391  19373.449219  18541.500000  18606.349609  18606.349609          0.0\n",
      "392  2015-03-23  18695.050781  18696.699219  17719.349609  18044.800781  18044.800781          0.0\n",
      "393  2015-03-30  18160.199219  18494.349609  18089.449219  18206.650391  18206.650391          0.0\n",
      "394  2015-04-06  18702.599609  18894.750000  18351.800781  18875.849609  18875.849609          0.0\n",
      "395  2015-04-13  18848.650391  19038.500000  18504.699219  18637.050781  18637.050781          0.0\n",
      "396  2015-04-20  18386.250000  18500.300781  17798.650391  18245.599609  18245.599609          0.0\n",
      "397  2015-04-27  18063.599609  18431.900391  17738.900391  18302.650391  18302.650391          0.0\n",
      "398  2015-05-04  18417.500000  18586.300781  17246.550781  17376.900391  17376.900391          0.0\n",
      "399  2015-05-11  17921.150391  18240.650391  17597.750000  18116.199219  18116.199219          0.0\n",
      "400  2015-05-18  18274.599609  18619.599609  18213.750000  18513.150391  18513.150391          0.0\n",
      "401  2015-05-25  18405.050781  18751.199219  18226.000000  18721.349609  18721.349609          0.0\n",
      "402  2015-06-01  18721.150391  18832.500000  17469.650391  17549.250000  17549.250000          0.0\n",
      "403  2015-06-08  17542.500000  17821.900391  17174.699219  17523.550781  17523.550781          0.0\n",
      "404  2015-06-15  17499.349609  17935.300781  17293.449219  17880.849609  17880.849609      43900.0\n",
      "405  2015-06-22  17956.550781  18539.150391  17950.599609  18371.500000  18371.500000          0.0\n",
      "406  2015-06-29  17962.500000  18642.849609  17821.900391  18585.550781  18585.550781          0.0\n",
      "407  2015-07-06  18488.349609  18980.650391  18402.849609  18719.800781  18719.800781          0.0\n",
      "408  2015-07-13  18753.800781  19229.050781  18657.599609  19094.699219  19094.699219          0.0\n",
      "409  2015-07-20  19126.099609  19149.050781  18613.550781  18635.849609  18635.849609          0.0\n",
      "410  2015-07-27  18566.550781  18828.849609  18174.199219  18729.849609  18729.849609          0.0\n",
      "411  2015-08-03  18782.650391  19103.699219  18758.900391  18893.550781  18893.550781          0.0\n",
      "412  2015-08-10  18926.099609  19071.349609  18034.750000  18723.599609  18723.599609          0.0\n",
      "413  2015-08-17  18763.050781  18896.449219  17842.099609  18057.199219  18057.199219          0.0\n",
      "414  2015-08-24  17446.349609  17569.800781  16670.550781  17211.949219  17211.949219          0.0\n",
      "415  2015-08-31  17137.250000  17353.300781  15933.150391  16129.099609  16129.099609      85700.0\n",
      "416  2015-09-07  16222.200195  16781.550781  15762.200195  16612.599609  16612.599609          0.0\n",
      "417  2015-09-14  16596.500000  17602.000000  16525.150391  17409.150391  17409.150391          0.0\n",
      "418  2015-09-21  17186.050781  17652.349609  16759.000000  17255.300781  17255.300781          0.0\n",
      "419  2015-09-28  17286.250000  17461.349609  16648.300781  17216.300781  17216.300781          0.0\n",
      "420  2015-10-05  17373.550781  17827.150391  17362.699219  17590.250000  17590.250000          0.0\n",
      "421  2015-10-12  17642.599609  17947.750000  17434.050781  17912.849609  17912.849609          0.0\n",
      "422  2015-10-19  17911.650391  17980.500000  17565.349609  17934.050781  17934.050781          0.0\n",
      "423  2015-10-26  18027.099609  18029.050781  17170.349609  17354.500000  17354.500000          0.0\n",
      "424  2015-11-02  17351.449219  17466.199219  16957.349609  16995.099609  16995.099609          0.0\n",
      "425  2015-11-09           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "426  2015-11-16           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "427  2015-11-23           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "428  2015-11-30           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "429  2015-12-07           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "430  2015-12-14  16342.349609  16425.150391  16188.049805  16398.650391  16398.650391      54700.0\n",
      "431  2015-12-21           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "432  2015-12-28           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "433  2016-01-04           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "434  2016-01-11  15612.099609  15803.200195  15453.400391  15609.799805  15609.799805      79300.0\n",
      "435  2016-01-18           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "436  2016-01-25  15667.000000  15682.650391  15495.099609  15561.150391  15561.150391   64213000.0\n",
      "437  2016-02-01           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "438  2016-02-08  15206.299805  15367.900391  14960.099609  15046.799805  15046.799805      86500.0\n",
      "439  2016-02-15  14243.450195  14395.849609  14207.349609  14344.200195  14344.200195      96300.0\n",
      "440  2016-02-22  13844.450195  13844.450195  13519.900391  13555.700195  13555.700195     104600.0\n",
      "441  2016-02-29           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "442  2016-03-07           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "443  2016-03-14           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "444  2016-03-21           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "445  2016-03-28           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "446  2016-04-04  16236.900391  16278.500000  16046.500000  16190.599609  16190.599609      70300.0\n",
      "447  2016-04-11           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "448  2016-04-18           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "449  2016-04-25           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "450  2016-05-02           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "451  2016-05-09           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "452  2016-05-16           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "453  2016-05-23  16600.650391  17025.849609  16599.050781  16997.449219  16997.449219      83900.0\n",
      "454  2016-05-30           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "455  2016-06-06  17710.449219  18051.500000  17636.900391  17828.599609  17828.599609     170300.0\n",
      "456  2016-06-13           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "457  2016-06-20           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "458  2016-06-27           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "459  2016-07-04           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "460  2016-07-11           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "461  2016-07-18           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "462  2016-07-25  19050.400391  19126.750000  18998.800781  19076.550781  19076.550781     146300.0\n",
      "463  2016-08-01           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "464  2016-08-08           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "465  2016-08-15           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "466  2016-08-22           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "467  2016-08-29           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "468  2016-09-05           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "469  2016-09-12           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "470  2016-09-19           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "471  2016-09-26           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "472  2016-10-03           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "473  2016-10-10           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "474  2016-10-17           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "475  2016-10-24           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "476  2016-10-31           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "477  2016-11-07  20200.250000  20200.250000  20200.250000  20200.250000  20200.250000          0.0\n",
      "478  2016-11-14           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "479  2016-11-21           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "480  2016-11-28           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "481  2016-12-05           NaN           NaN           NaN           NaN           NaN          NaN\n",
      "482  2016-12-12  18616.050781  18616.050781  18122.099609  18312.800781  18312.800781          0.0\n",
      "483  2016-12-19  18258.099609  18316.800781  17819.750000  17884.000000  17884.000000          0.0\n",
      "484  2016-12-26  17677.699219  18245.750000  17616.099609  18177.199219  18177.199219          0.0\n",
      "485  2017-01-02  18002.750000  18325.500000  17830.949219  18264.000000  18264.000000          0.0\n",
      "486  2017-01-09  18314.250000  18966.300781  18256.150391  18912.099609  18912.099609          0.0\n",
      "487  2017-01-16  18899.699219  19276.500000  18793.050781  18820.800781  18820.800781          0.0\n",
      "488  2017-01-23  18762.000000  19794.949219  18722.849609  19708.300781  19708.300781          0.0\n",
      "489  2017-01-30  19718.800781  20229.650391  19435.449219  20196.800781  20196.800781          0.0\n",
      "490  2017-02-06  20307.150391  20462.449219  20000.349609  20213.900391  20213.900391          0.0\n",
      "491  2017-02-13  20273.650391  21042.349609  20088.199219  20551.349609  20551.349609          0.0\n",
      "492  2017-02-20  20494.849609  21011.900391  20472.400391  20876.650391  20876.650391          0.0\n",
      "493  2017-02-27  20853.449219  20905.000000  20423.349609  20495.599609  20495.599609          0.0\n",
      "494  2017-03-06  20548.949219  20876.949219  20532.199219  20727.550781  20727.550781          0.0\n",
      "495  2017-03-13  21189.849609  21336.050781  21059.699219  21175.050781  21175.050781          0.0\n",
      "496  2017-03-20  21202.550781  21202.550781  20753.900391  21122.550781  21122.550781          0.0\n",
      "497  2017-03-27  21178.099609  21696.000000  20979.550781  21444.150391  21444.150391          0.0\n",
      "498  2017-04-03  21539.199219  21699.300781  21397.000000  21431.150391  21431.150391          0.0\n",
      "499  2017-04-10  21492.050781  21787.099609  21396.050781  21686.599609  21686.599609          0.0\n",
      "500  2017-04-17  21700.500000  21947.000000  21386.199219  21551.449219  21551.449219          0.0\n",
      "501  2017-04-24  21591.900391  22383.000000  21578.650391  22358.250000  22358.250000          0.0\n",
      "502  2017-05-01  22412.550781  22853.550781  22240.050781  22604.949219  22604.949219          0.0\n",
      "503  2017-05-08  22678.449219  22977.849609  22578.000000  22671.699219  22671.699219          0.0\n",
      "504  2017-05-15  22735.849609  22978.150391  22628.449219  22769.800781  22769.800781          0.0\n",
      "505  2017-05-22  22874.800781  23408.349609  22469.800781  23362.199219  23362.199219          0.0\n",
      "506  2017-05-29  23310.599609  23469.449219  23093.949219  23375.900391  23375.900391          0.0\n",
      "507  2017-06-05  23397.400391  23708.650391  23349.949219  23690.900391  23690.900391          0.0\n",
      "508  2017-06-12  23610.150391  23630.099609  23311.849609  23502.750000  23502.750000          0.0\n",
      "509  2017-06-19  23571.349609  23897.849609  23507.500000  23542.750000  23542.750000          0.0\n",
      "510  2017-06-26  23636.949219  23640.099609  22996.400391  23211.199219  23211.199219          0.0\n",
      "511  2017-07-03  23240.349609  23540.150391  23144.300781  23449.150391  23449.150391          0.0\n",
      "512  2017-07-10  23583.250000  23964.800781  23289.900391  23937.699219  23937.699219          0.0\n",
      "513  2017-07-17  24011.400391  24299.599609  23913.650391  24257.050781  24257.050781          0.0\n",
      "514  2017-07-24  24307.699219  25032.250000  24234.650391  24811.300781  24811.300781          0.0\n",
      "515  2017-07-31  24880.599609  25198.800781  24591.800781  24827.449219  24827.449219          0.0\n",
      "516  2017-08-07  24854.150391  24979.349609  23822.199219  23985.750000  23985.750000          0.0\n",
      "517  2017-08-14  24051.050781  24496.199219  23925.949219  24074.449219  24074.449219          0.0\n",
      "518  2017-08-21  24140.550781  24411.050781  23852.650391  24274.199219  24274.199219          0.0\n",
      "519  2017-08-28  24351.250000  24494.349609  24103.300781  24434.000000  24434.000000          0.0\n",
      "520  2017-09-04  24272.599609  24419.250000  24151.099609  24370.800781  24370.800781          0.0\n",
      "521  2017-09-11  24468.500000  24994.300781  24458.250000  24844.300781  24844.300781          0.0\n",
      "522  2017-09-18  24948.150391  25105.349609  24340.000000  24368.849609  24368.849609          0.0\n",
      "523  2017-09-25  24361.550781  24363.800781  23611.099609  24053.000000  24053.000000          0.0\n",
      "524  2017-10-02  24200.599609  24242.050781  24007.250000  24190.000000  24190.000000          0.0\n",
      "525  2017-10-09  24209.550781  24779.750000  23978.400391  24689.150391  24689.150391          0.0\n",
      "526  2017-10-16  24815.400391  24878.650391  23923.699219  24009.750000  24009.750000          0.0\n",
      "527  2017-10-23  24085.449219  25186.050781  23912.550781  24839.550781  24839.550781      94700.0\n",
      "528  2017-10-30  24873.650391  25695.500000  24808.550781  25650.699219  25650.699219          0.0\n",
      "529  2017-11-06  25569.000000  25695.750000  25119.500000  25498.949219  25498.949219          0.0\n",
      "530  2017-11-13  25570.250000  25924.900391  25166.349609  25728.400391  25728.400391          0.0\n",
      "531  2017-11-20  25733.699219  25871.099609  25620.949219  25779.650391  25779.650391      76600.0\n",
      "532  2017-11-27  25693.050781  25953.500000  25152.650391  25191.949219  25191.949219          0.0\n",
      "533  2017-12-04  25295.050781  25367.699219  24813.599609  25321.150391  25321.150391          0.0\n",
      "534  2017-12-11  25434.750000  25559.050781  24888.650391  25440.300781  25440.300781          0.0\n",
      "535  2017-12-18  25181.750000  25780.050781  24617.150391  25648.550781  25648.550781          0.0\n",
      "536  2017-12-25  25659.750000  25733.199219  25417.400391  25539.449219  25539.449219          0.0\n",
      "537  2018-01-01  25382.199219  25643.349609  25232.800781  25601.849609  25601.849609          0.0\n",
      "538  2018-01-08  25690.250000  25803.800781  25527.500000  25749.050781  25749.050781          0.0\n",
      "539  2018-01-15  25858.150391  26957.849609  25842.949219  26909.500000  26909.500000          0.0\n",
      "540  2018-01-22  26940.500000  27522.849609  26841.199219  27445.650391  27445.650391          0.0\n",
      "541  2018-01-29  27446.099609  27652.050781  26364.050781  26451.150391  26451.150391          0.0\n",
      "542  2018-02-05  25968.150391  26215.099609  25023.849609  25463.650391  25463.650391          0.0\n",
      "543  2018-02-12  25530.099609  25810.250000  25100.900391  25163.900391  25163.900391          0.0\n",
      "544  2018-02-19  25324.599609  25345.150391  24781.699219  25302.500000  25302.500000     265300.0\n",
      "545  2018-02-26  25452.000000  25723.550781  24854.400391  24902.550781  24902.550781          0.0\n",
      "546  2018-03-05  24831.349609  25040.250000  24048.550781  24296.449219  24296.449219     134500.0\n",
      "547  2018-03-12  24443.599609  25009.650391  24358.500000  24489.550781  24489.550781          0.0\n",
      "548  2018-03-19  24530.150391  24588.050781  23605.599609  23670.400391  23670.400391          0.0\n",
      "549  2018-03-26  23674.900391  24496.949219  23657.050781  24263.349609  24263.349609          0.0\n",
      "550  2018-04-02  24235.650391  24933.599609  24062.949219  24873.150391  24873.150391          0.0\n",
      "551  2018-04-09  24848.849609  25411.300781  24828.000000  25200.599609  25200.599609          0.0\n",
      "552  2018-04-16  25082.099609  25426.750000  24839.300781  24943.849609  24943.849609          0.0\n",
      "553  2018-04-23  25065.500000  25441.500000  24466.099609  25394.599609  25394.599609          0.0\n",
      "554  2018-04-30  25490.150391  25716.750000  25464.800781  25645.400391  25645.400391     306200.0\n",
      "555  2018-05-07  25676.250000  26437.250000  25675.150391  26413.150391  26413.150391          0.0\n",
      "556  2018-05-14  26404.449219  26972.050781  25839.000000  25875.599609  25875.599609          0.0\n",
      "557  2018-05-21  26017.500000  26325.550781  25622.150391  26273.550781  26273.550781          0.0\n",
      "558  2018-05-28  26291.650391  27164.550781  25980.849609  26692.800781  26692.800781          0.0\n",
      "559  2018-06-04  27023.699219  27047.550781  26069.550781  26451.349609  26451.349609          0.0\n",
      "560  2018-06-11  26473.199219  26765.449219  26344.949219  26417.400391  26417.400391          0.0\n",
      "561  2018-06-18  26444.300781  26806.550781  26224.750000  26766.849609  26766.849609          0.0\n",
      "562  2018-06-25  26718.150391  26804.900391  26161.000000  26364.199219  26364.199219          0.0\n",
      "563  2018-07-02  26364.449219  26609.849609  26060.599609  26493.849609  26493.849609          0.0\n",
      "564  2018-07-09  26642.349609  27164.800781  26611.550781  26935.949219  26935.949219          0.0\n",
      "565  2018-07-16  26914.500000  27187.150391  26643.949219  26873.199219  26873.199219          0.0\n",
      "566  2018-07-23  26701.300781  27661.050781  26671.349609  27634.400391  27634.400391          0.0\n",
      "567  2018-07-30  27767.650391  27873.699219  27327.949219  27695.500000  27695.500000          0.0\n",
      "568  2018-08-06  27769.550781  28377.900391  27766.050781  28124.250000  28124.250000          0.0\n",
      "569  2018-08-13  27760.800781  28178.150391  27739.500000  28128.550781  28128.550781     331100.0\n",
      "570  2018-08-20  28171.650391  28325.449219  27782.800781  27834.699219  27834.699219     310600.0\n",
      "571  2018-08-27  27971.250000  28388.650391  27940.949219  28061.750000  28061.750000          0.0\n",
      "572  2018-09-03  28199.449219  28203.199219  27136.050781  27481.449219  27481.449219     123200.0\n",
      "573  2018-09-10  27395.199219  27404.849609  26555.150391  27163.849609  27163.849609          0.0\n",
      "574  2018-09-17  27002.599609  27002.599609  25053.349609  25596.900391  25596.900391          0.0\n",
      "575  2018-09-24  25645.050781  25649.699219  24678.250000  25119.849609  25119.849609          0.0\n",
      "576  2018-10-01  24943.900391  25470.050781  24250.650391  24443.449219  24443.449219     253300.0\n",
      "577  2018-10-08  24470.750000  25484.199219  24240.050781  25395.849609  25395.849609          0.0\n",
      "578  2018-10-15  25444.000000  25915.349609  24922.650391  25085.800781  25085.800781          0.0\n",
      "579  2018-10-22  25484.250000  25504.750000  24353.099609  24421.050781  24421.050781          0.0\n",
      "580  2018-10-29  24647.949219  25856.250000  24404.550781  25701.650391  25701.650391          0.0\n",
      "581  2018-11-05  25731.550781  25860.750000  25534.400391  25771.000000  25771.000000          0.0\n",
      "582  2018-11-12  25816.150391  26332.750000  25384.550781  26245.550781  26245.550781          0.0\n",
      "583  2018-11-19  26364.599609  26379.099609  25947.849609  25999.449219  25999.449219          0.0\n",
      "584  2018-11-26  26096.000000  27012.699219  26025.050781  26862.949219  26862.949219          0.0\n",
      "585  2018-12-03  27032.900391  27037.099609  26149.449219  26594.300781  26594.300781          0.0\n",
      "586  2018-12-10  26073.650391  26951.449219  25598.949219  26826.000000  26826.000000          0.0\n",
      "587  2018-12-17  26915.449219  27369.099609  26823.099609  26869.650391  26869.650391          0.0\n",
      "588  2018-12-24  26877.050781  27239.949219  26408.150391  27125.250000  27125.250000          0.0\n",
      "589  2018-12-31  27267.800781  27397.550781  26923.750000  27195.000000  27195.000000          0.0\n",
      "590  2019-01-07  27378.650391  27754.449219  27161.949219  27453.900391  27453.900391     146100.0\n",
      "591  2019-01-14  27389.199219  27611.550781  27182.199219  27456.699219  27456.699219          0.0\n",
      "592  2019-01-21  27514.550781  27622.199219  27045.199219  27115.300781  27115.300781          0.0\n",
      "593  2019-01-28  27041.449219  27533.050781  26441.550781  27085.949219  27085.949219     231600.0\n",
      "594  2019-02-04  26974.000000  27589.750000  26825.550781  27294.400391  27294.400391          0.0\n",
      "595  2019-02-11  27240.500000  27305.900391  26635.250000  26794.250000  26794.250000          0.0\n",
      "596  2019-02-18  26754.599609  27100.900391  26617.699219  26867.550781  26867.550781          0.0\n",
      "597  2019-02-25  26934.199219  27197.099609  26719.400391  27043.900391  27043.900391          0.0\n",
      "598  2019-03-04  27068.150391  27815.500000  26958.099609  27761.800781  27761.800781          0.0\n",
      "599  2019-03-11  27840.099609  29520.699219  27791.250000  29381.449219  29381.449219          0.0\n",
      "600  2019-03-18  29521.599609  30008.099609  29361.650391  29582.500000  29582.500000          0.0\n",
      "601  2019-03-25  29329.400391  30499.150391  29156.250000  30426.800781  30426.800781          0.0\n",
      "602  2019-04-01  30537.599609  30648.099609  29809.900391  30084.650391  30084.650391          0.0\n",
      "603  2019-04-08  30201.500000  30232.050781  29640.250000  29938.550781  29938.550781          0.0\n",
      "604  2019-04-15  29983.500000  30669.800781  29919.099609  30223.400391  30223.400391          0.0\n",
      "605  2019-04-22  30282.500000  30289.900391  29435.050781  30013.500000  30013.500000          0.0\n",
      "606  2019-04-29  29920.400391  30121.750000  29550.050781  29954.150391  29954.150391          0.0\n",
      "607  2019-05-06  29626.500000  29835.500000  28784.650391  29040.500000  29040.500000          0.0\n",
      "608  2019-05-13  29026.650391  29559.449219  28525.449219  29450.150391  29450.150391          0.0\n",
      "609  2019-05-20  30230.400391  31705.000000  30111.199219  31212.550781  31212.550781          0.0\n",
      "610  2019-05-27  31234.900391  31783.599609  30623.050781  31375.400391  31375.400391     232000.0\n",
      "611  2019-06-03  31406.050781  31752.699219  30627.050781  31066.550781  31066.550781     274600.0\n",
      "612  2019-06-10  31259.199219  31399.349609  30508.949219  30614.349609  30614.349609          0.0\n",
      "613  2019-06-17  30652.000000  30824.550781  30220.699219  30628.349609  30628.349609          0.0\n",
      "614  2019-06-24  30680.949219  31490.599609  30451.400391  31105.199219  31105.199219          0.0\n",
      "615  2019-07-01  31271.000000  31660.750000  31105.099609  31475.800781  31475.800781  242986000.0\n",
      "616  2019-07-08  31346.849609  31346.849609  30348.849609  30601.449219  30601.449219          0.0\n",
      "617  2019-07-15  30688.849609  30799.300781  29705.900391  29770.349609  29770.349609          0.0\n",
      "618  2019-07-22  29617.050781  29635.150391  28872.300781  29325.300781  29325.300781     339800.0\n",
      "619  2019-07-29  29583.449219  29583.449219  27937.550781  28204.949219  28204.949219     310300.0\n",
      "620  2019-08-05  27841.199219  28602.199219  27389.500000  28431.900391  28431.900391          0.0\n",
      "621  2019-08-12  28431.900391  28431.900391  27683.500000  28217.000000  28217.000000          0.0\n",
      "622  2019-08-19  28331.250000  28468.900391  26560.599609  26958.650391  26958.650391          0.0\n",
      "623  2019-08-26  27663.949219  28277.699219  26859.349609  27427.849609  27427.849609          0.0\n",
      "624  2019-09-02  27239.199219  27311.050781  26641.349609  27247.900391  27247.900391          0.0\n",
      "625  2019-09-09  27240.349609  28126.849609  26993.900391  28098.750000  28098.750000          0.0\n",
      "626  2019-09-16  27868.000000  29418.949219  26643.000000  28981.550781  28981.550781          0.0\n",
      "627  2019-09-23  30039.400391  30801.300781  29470.099609  29876.650391  29876.650391          0.0\n",
      "628  2019-09-30  29674.800781  29754.400391  27653.699219  27731.849609  27731.849609    1187300.0\n",
      "629  2019-10-07  27909.900391  28857.699219  27568.349609  28042.500000  28042.500000          0.0\n",
      "630  2019-10-14  28238.500000  29249.500000  28043.250000  29120.250000  29120.250000          0.0\n",
      "631  2019-10-21  29120.250000  29693.250000  28923.800781  29395.949219  29395.949219          0.0\n",
      "632  2019-10-28  29516.300781  30415.650391  29385.449219  30330.550781  30330.550781          0.0\n",
      "633  2019-11-04  30415.900391  31108.400391  30013.650391  30749.400391  30749.400391     364800.0\n",
      "634  2019-11-11  30664.650391  31205.199219  30338.349609  31008.400391  31008.400391          0.0\n",
      "635  2019-11-18  31036.800781  31471.650391  30901.849609  31111.599609  31111.599609          0.0\n",
      "636  2019-11-25  31065.099609  32157.050781  31049.750000  31946.099609  31946.099609     498300.0\n",
      "637  2019-12-02  32008.300781  32126.949219  31250.650391  31341.550781  31341.550781    1395500.0\n",
      "638  2019-12-09  31321.400391  32105.050781  30996.400391  32014.250000  32014.250000    2735500.0\n",
      "639  2019-12-16  32159.000000  32443.349609  31897.750000  32384.949219  32384.949219    1796800.0\n",
      "640  2019-12-23  32381.000000  32502.800781  31963.250000  32412.349609  32412.349609    1394500.0\n",
      "641  2019-12-30  32486.599609  32613.099609  31960.400391  32069.250000  32069.250000     722600.0\n",
      "642  2020-01-06  31910.449219  32347.199219  30899.550781  32097.400391  32097.400391    1607800.0\n",
      "643  2020-01-13  32139.099609  32322.650391  31445.500000  31590.650391  31590.650391    1837800.0\n",
      "644  2020-01-20  31923.949219  31923.949219  30614.000000  31241.750000  31241.750000    1478700.0\n",
      "645  2020-01-27  31110.550781  31227.050781  30521.300781  30833.599609  30833.599609    1480600.0\n",
      "646  2020-02-03  29811.750000  31470.650391  29612.550781  31201.949219  31201.949219    1689700.0\n",
      "647  2020-02-10  31248.650391  31649.449219  30776.099609  30834.800781  30834.800781    1309000.0\n",
      "648  2020-02-17  30873.849609  31085.300781  30252.449219  30942.849609  30942.849609     940800.0\n",
      "649  2020-02-24  30666.349609  30702.150391  29051.500000  29147.150391  29147.150391    1506000.0\n",
      "650  2020-03-02  29701.000000  29791.150391  27162.300781  27801.449219  27801.449219    3805200.0\n",
      "651  2020-03-09  27031.449219  27091.599609  21351.699219  25166.449219  25166.449219    3326300.0\n",
      "652  2020-03-16  24061.599609  24074.150391  18675.650391  20317.599609  20317.599609    2873300.0\n",
      "653  2020-03-23  18311.300781  21462.400391  16116.250000  19969.000000  19969.000000    2116200.0\n",
      "654  2020-03-30  19254.449219  19716.250000  17143.199219  17249.300781  17249.300781    1254200.0\n",
      "655  2020-04-06  18454.550781  20324.099609  17953.750000  19913.599609  19913.599609    1333800.0\n",
      "656  2020-04-13  19854.900391  20866.550781  18703.449219  20681.449219  20681.449219    1503400.0\n",
      "657  2020-04-20  21104.699219  21122.099609  19051.949219  19586.650391  19586.650391    1731000.0\n",
      "658  2020-04-27  19870.800781  21967.000000  19847.650391  21534.500000  21534.500000    1539800.0\n",
      "659  2020-05-04  20514.750000  20530.449219  18941.000000  19352.900391  19352.900391    1405800.0\n",
      "660  2020-05-11  19610.449219  20122.250000  18287.000000  18833.949219  18833.949219    1832400.0\n",
      "661  2020-05-18  18795.099609  18795.099609  17105.000000  17278.900391  17278.900391    2008900.0\n",
      "662  2020-05-25  17537.650391  19455.550781  17311.250000  19297.250000  19297.250000    2017600.0\n",
      "663  2020-06-01  19728.900391  21619.550781  19632.900391  21034.500000  21034.500000    2848600.0\n",
      "664  2020-06-08  21636.099609  21807.400391  19526.099609  20654.550781  20654.550781    3318600.0\n",
      "665  2020-06-15  20457.150391  21467.650391  19507.050781  21338.099609  21338.099609          0.0\n",
      "666  2020-06-22  21491.550781  22479.550781  20926.449219  21592.050781  21592.050781    2838900.0\n",
      "667  2020-06-29  21291.550781  22344.849609  21026.449219  21852.400391  21852.400391    1661900.0\n",
      "668  2020-07-06  22270.949219  23080.599609  22040.349609  22398.449219  22398.449219    2232900.0\n",
      "669  2020-07-13  22613.250000  22657.400391  21027.849609  21966.800781  21966.800781    1634800.0\n",
      "670  2020-07-20  22307.300781  23211.349609  22187.800781  22662.050781  22662.050781    1823000.0\n",
      "671  2020-07-27  22664.599609  22668.050781  21375.000000  21640.050781  21640.050781    1818000.0\n",
      "672  2020-08-03  21543.800781  21936.500000  21031.449219  21754.000000  21754.000000    1535000.0\n",
      "673  2020-08-10  21824.900391  22439.949219  21459.099609  21679.400391  21679.400391    1755100.0\n",
      "674  2020-08-17  21906.949219  22419.349609  21403.150391  22299.599609  22299.599609     263400.0\n",
      "675  2020-08-24  22436.849609  24611.800781  22410.050781  24523.800781  24523.800781          0.0\n",
      "676  2020-08-31  25038.800781  25232.599609  22876.900391  23011.500000  23011.500000          0.0\n",
      "677  2020-09-07  23036.250000  23109.099609  22080.400391  22479.949219  22479.949219     245300.0\n",
      "678  2020-09-14  22683.349609  22757.300781  21784.900391  22031.050781  22031.050781          0.0\n",
      "679  2020-09-21  21983.400391  22098.849609  20404.900391  20982.349609  20982.349609          0.0\n",
      "680  2020-09-28  21152.050781  22293.750000  21055.099609  22246.000000  22246.000000          0.0\n",
      "681  2020-10-05  22352.099609  23904.099609  22247.250000  23846.800781  23846.800781          0.0\n",
      "682  2020-10-12  23955.599609  24190.349609  22970.949219  23533.250000  23533.250000          0.0\n",
      "683  2020-10-19  23902.900391  24823.599609  23754.849609  24478.300781  24478.300781          0.0\n",
      "684  2020-10-26  24525.800781  24809.650391  23612.699219  23900.900391  23900.900391          0.0\n",
      "685  2020-11-02  24367.599609  26853.449219  24120.599609  26798.949219  26798.949219          0.0\n",
      "686  2020-11-09  27088.949219  29030.900391  27068.949219  28465.699219  28465.699219          0.0\n",
      "687  2020-11-16  28792.250000  29784.750000  28580.900391  29236.000000  29236.000000          0.0\n",
      "688  2020-11-23  29432.800781  30197.849609  28852.900391  29609.050781  29609.050781     369400.0\n",
      "689  2020-11-30  29844.800781  30162.300781  29149.900391  30052.400391  30052.400391          0.0\n",
      "690  2020-12-07  30062.599609  30811.800781  29950.599609  30604.849609  30604.849609          0.0\n",
      "691  2020-12-14  30735.150391  30945.199219  30345.750000  30714.650391  30714.650391     548400.0\n",
      "692  2020-12-21  30595.800781  30607.500000  28976.750000  30402.199219  30402.199219          0.0\n",
      "693  2020-12-28  30558.849609  31510.250000  30538.150391  31264.050781  31264.050781          0.0\n",
      "694  2021-01-04  31485.150391  32298.050781  30893.650391  32084.199219  32084.199219          0.0\n",
      "695  2021-01-11  32280.300781  32718.949219  31725.849609  32246.800781  32246.800781          0.0\n",
      "696  2021-01-18  32275.150391  32842.300781  31119.900391  31167.250000  31167.250000     751600.0\n",
      "697  2021-01-25  31507.150391  31697.550781  29687.699219  30565.500000  30565.500000          0.0\n",
      "698  2021-02-01  30976.349609  36615.199219  30906.449219  35654.500000  35654.500000    1277400.0\n",
      "699  2021-02-08  36073.851563  36477.148438  35428.148438  36108.898438  36108.898438          0.0\n",
      "700  2021-02-15  36501.398438  37708.750000  35584.601563  35841.601563  35841.601563          0.0\n",
      "701  2021-02-22  35874.300781  37232.199219  34658.699219  34803.601563  34803.601563     728800.0\n",
      "702  2021-03-01  35374.250000  36455.148438  34893.250000  35228.148438  35228.148438          0.0\n",
      "703  2021-03-08  35462.449219  36497.351563  35090.750000  35496.648438  35496.648438          0.0\n",
      "704  2021-03-15  35544.250000  35544.250000  33361.000000  34161.601563  34161.601563          0.0\n",
      "705  2021-03-22  34088.398438  34360.050781  32415.250000  33318.199219  33318.199219          0.0\n",
      "706  2021-03-29  33615.898438  33990.800781  33151.800781  33858.000000  33858.000000     374200.0\n",
      "707  2021-04-05  33649.148438  33697.750000  32141.550781  32448.050781  32448.050781          0.0\n",
      "708  2021-04-12  31637.900391  32325.150391  30520.300781  31977.449219  31977.449219          0.0\n",
      "709  2021-04-19  30993.449219  32148.400391  30405.650391  31722.300781  31722.300781     368400.0\n",
      "710  2021-04-26  32316.650391  34287.000000  32144.800781  32781.800781  32781.800781          0.0\n",
      "711  2021-05-03  32368.550781  33259.148438  31906.550781  32904.500000  32904.500000    1137800.0\n",
      "712  2021-05-10  33175.300781  33297.601563  32115.500000  32169.550781  32169.550781          0.0\n",
      "713  2021-05-17  32437.849609  34694.449219  32318.699219  34606.898438  34606.898438          0.0\n",
      "714  2021-05-24  34869.300781  35436.648438  34410.398438  35141.449219  35141.449219          0.0\n",
      "715  2021-05-31  35097.449219  35810.898438  34930.101563  35291.648438  35291.648438          0.0\n",
      "716  2021-06-07  35460.800781  35545.851563  34641.199219  35047.398438  35047.398438          0.0\n",
      "717  2021-06-14  34936.550781  35380.000000  33908.949219  34558.000000  34558.000000          0.0\n",
      "718  2021-06-21  34109.449219  35491.949219  33937.500000  35364.648438  35364.648438          0.0\n",
      "719  2021-06-28  35488.199219  35576.949219  34632.601563  34809.898438  34809.898438     329600.0\n",
      "720  2021-07-05  35010.949219  35811.000000  34859.898438  35071.949219  35071.949219          0.0\n",
      "721  2021-07-12  35285.050781  35985.250000  35060.351563  35751.800781  35751.800781          0.0\n",
      "722  2021-07-19  35070.500000  35347.050781  34357.351563  35034.398438  35034.398438          0.0\n",
      "723  2021-07-26  34947.851563  35186.101563  34115.199219  34584.351563  34584.351563          0.0\n",
      "724  2021-08-02  34760.898438  36219.800781  34588.250000  35809.250000  35809.250000          0.0\n",
      "725  2021-08-09  35824.199219  36317.000000  35531.351563  36169.351563  36169.351563     649500.0\n",
      "726  2021-08-16  36100.648438  36261.550781  34926.500000  35033.851563  35033.851563     527300.0\n",
      "727  2021-08-23  35424.199219  35910.300781  34817.500000  35627.800781  35627.800781     749400.0\n",
      "728  2021-08-30  35781.050781  37140.000000  35721.898438  36761.148438  36761.148438     816700.0\n",
      "729  2021-09-06  36878.250000  36923.648438  36151.949219  36683.199219  36683.199219     472500.0\n",
      "730  2021-09-13  36608.449219  38112.750000  36327.050781  37811.949219  37811.949219    1127600.0\n",
      "731  2021-09-20  37388.199219  38112.601563  36525.949219  37830.300781  37830.300781     689900.0\n",
      "732  2021-09-27  38054.750000  38377.250000  36876.351563  37225.898438  37225.898438     998800.0\n",
      "733  2021-10-04  37392.148438  38106.851563  37355.601563  37775.250000  37775.250000     808300.0\n",
      "734  2021-10-11  37782.750000  39375.050781  37744.648438  39340.898438  39340.898438     792900.0\n",
      "735  2021-10-18  39794.250000  40587.351563  39292.800781  40323.648438  40323.648438    1733600.0\n",
      "736  2021-10-25  40961.250000  41829.601563  38426.648438  39115.601563  39115.601563    2090700.0\n",
      "737  2021-11-01  39432.148438  40160.199219  39120.648438  39573.699219  39573.699219     774500.0\n",
      "738  2021-11-08  39674.050781  39674.050781  38346.050781  38733.351563  38733.351563     866300.0\n",
      "739  2021-11-15  38849.449219  39117.148438  37748.449219  37976.250000  37976.250000     619400.0\n",
      "740  2021-11-22  38232.148438  38241.000000  35904.101563  36025.500000  36025.500000     908000.0\n",
      "741  2021-11-29  36224.449219  36844.000000  35327.898438  36197.148438  36197.148438     859000.0\n",
      "742  2021-12-06  36252.750000  37397.550781  35696.750000  37105.648438  37105.648438     741800.0\n",
      "743  2021-12-13  37358.199219  37581.050781  35535.050781  35618.648438  35618.648438     660100.0\n",
      "744  2021-12-20  35124.351563  35477.300781  34018.449219  34857.050781  34857.050781     735000.0\n",
      "745  2021-12-27  34573.648438  35596.949219  34233.000000  35481.699219  35481.699219    1177500.0\n",
      "746  2022-01-03  35585.199219  38134.851563  35526.601563  37739.601563  37739.601563    1029200.0\n",
      "747  2022-01-10  37930.550781  38851.449219  37929.351563  38370.398438  38370.398438     829900.0\n",
      "748  2022-01-17  38212.550781  38855.550781  37224.250000  37574.300781  37574.300781     781800.0\n",
      "749  2022-01-24  37601.949219  38421.699219  36375.351563  37689.398438  37689.398438    1139100.0\n",
      "750  2022-01-31  38091.800781  39424.851563  37647.851563  38789.351563  38789.351563    1061400.0\n",
      "751  2022-02-07  38592.050781  39197.199219  37319.050781  38517.250000  38517.250000     869800.0\n",
      "752  2022-02-14  37664.000000  38461.699219  36651.851563  37599.148438  37599.148438     826700.0\n",
      "753  2022-02-21  37400.000000  38054.398438  36818.101563  37392.050781  37392.050781     440000.0\n"
     ]
    }
   ],
   "source": [
    "df=pd.read_csv('banknifty15years.csv')\n",
    "print(df.to_string())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a447dbb2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "           Date          Open          High           Low         Close     Adj Close       Volume\n",
      "0    2007-09-17   6898.000000   7506.350098   6843.000000   7464.500000   7464.500000          0.0\n",
      "1    2007-09-24   7514.399902   8082.850098   7490.200195   8042.200195   8042.200195          0.0\n",
      "2    2007-10-01   8008.549805   8235.799805   7789.700195   7845.250000   7845.250000          0.0\n",
      "3    2007-10-08   7853.149902   8177.750000   7516.450195   7934.000000   7934.000000          0.0\n",
      "4    2007-10-15   7962.549805   8491.650391   7279.299805   7423.799805   7423.799805          0.0\n",
      "5    2007-10-22   7374.350098   8804.900391   7289.200195   8749.900391   8749.900391          0.0\n",
      "6    2007-10-29   8918.049805   9610.700195   8832.500000   9560.700195   9560.700195          0.0\n",
      "7    2007-11-05   9549.799805   9692.500000   8671.400391   8760.750000   8760.750000          0.0\n",
      "8    2007-11-12   8596.150391   9651.849609   8429.349609   9474.150391   9474.150391          0.0\n",
      "9    2007-11-19   9541.099609   9595.450195   8650.000000   8977.900391   8977.900391          0.0\n",
      "10   2007-11-26   9136.049805   9437.950195   8938.099609   9375.750000   9375.750000          0.0\n",
      "11   2007-12-03   9391.200195   9804.549805   9341.049805   9796.099609   9796.099609          0.0\n",
      "12   2007-12-10   9800.200195  10124.750000   9723.599609   9803.150391   9803.150391          0.0\n",
      "13   2007-12-17   9790.549805   9792.150391   9125.450195   9245.450195   9245.450195          0.0\n",
      "14   2007-12-24   9316.450195   9842.650391   9316.450195   9828.349609   9828.349609          0.0\n",
      "15   2007-12-31   9861.700195  10333.299805   9790.400391  10233.200195  10233.200195          0.0\n",
      "16   2008-01-07   9983.099609  10634.200195   9948.349609  10561.549805  10561.549805          0.0\n",
      "17   2008-01-14  10614.849609  10774.150391   9648.450195   9739.900391   9739.900391          0.0\n",
      "18   2008-01-21   9671.400391   9827.299805   7958.950195   9752.250000   9752.250000          0.0\n",
      "19   2008-01-28   9748.349609  10113.349609   9002.200195   9327.049805   9327.049805          0.0\n",
      "20   2008-02-04   9444.400391   9708.599609   8624.750000   8817.000000   8817.000000          0.0\n",
      "21   2008-02-11   8841.200195   9403.700195   8216.900391   9380.049805   9380.049805          0.0\n",
      "22   2008-02-18   9411.250000   9538.700195   8642.000000   8685.099609   8685.099609          0.0\n",
      "23   2008-02-25   8715.799805   8903.450195   8248.750000   8688.349609   8688.349609          0.0\n",
      "24   2008-03-03   8460.599609   8460.599609   7064.500000   7268.149902   7268.149902          0.0\n",
      "25   2008-03-10   7163.500000   7705.649902   6840.649902   7106.000000   7106.000000          0.0\n",
      "26   2008-03-17   6956.000000   6956.000000   6335.000000   6456.549805   6456.549805          0.0\n",
      "27   2008-03-24   6461.649902   7230.799805   6456.799805   7037.850098   7037.850098          0.0\n",
      "28   2008-03-31   6970.549805   6970.549805   6446.700195   6545.149902   6545.149902          0.0\n",
      "29   2008-04-07   6485.399902   7094.850098   6485.399902   6838.450195   6838.450195          0.0\n",
      "30   2008-04-14   6773.299805   7213.799805   6687.899902   7165.049805   7165.049805          0.0\n",
      "31   2008-04-21   7174.450195   7651.399902   7117.649902   7616.299805   7616.299805          0.0\n",
      "32   2008-04-28   7643.350098   7900.850098   7567.850098   7871.899902   7871.899902          0.0\n",
      "33   2008-05-05   7879.649902   7990.450195   7267.899902   7299.000000   7299.000000          0.0\n",
      "34   2008-05-12   7274.700195   7666.899902   7140.100098   7644.600098   7644.600098          0.0\n",
      "35   2008-05-19   7616.850098   7616.850098   6994.899902   7009.049805   7009.049805          0.0\n",
      "36   2008-05-26   6899.899902   6925.399902   6502.450195   6584.350098   6584.350098          0.0\n",
      "37   2008-06-02   6577.299805   6677.149902   5974.100098   6140.049805   6140.049805          0.0\n",
      "38   2008-06-09   5960.899902   6092.299805   5702.500000   5993.149902   5993.149902          0.0\n",
      "39   2008-06-16   6030.600098   6455.200195   5731.250000   5758.600098   5758.600098          0.0\n",
      "40   2008-06-23   5686.549805   5737.049805   5183.200195   5210.899902   5210.899902          0.0\n",
      "41   2008-06-30   5214.100098   5214.100098   4633.950195   4990.899902   4990.899902          0.0\n",
      "42   2008-07-07   5009.100098   5404.649902   4843.600098   5240.700195   5240.700195          0.0\n",
      "43   2008-07-14   5179.950195   5418.399902   4676.450195   5389.149902   5389.149902          0.0\n",
      "44   2008-07-21   5448.200195   6468.399902   5406.299805   5917.250000   5917.250000          0.0\n",
      "45   2008-07-28   5900.299805   5989.450195   5394.950195   5961.899902   5961.899902          0.0\n",
      "46   2008-08-04   5932.450195   6725.700195   5888.850098   6447.500000   6447.500000          0.0\n",
      "47   2008-08-11   6574.500000   6754.450195   6010.049805   6030.049805   6030.049805          0.0\n",
      "48   2008-08-18   5999.149902   6114.149902   5649.899902   5776.049805   5776.049805          0.0\n",
      "49   2008-08-25   5897.200195   6112.250000   5686.600098   6102.049805   6102.049805          0.0\n",
      "50   2008-09-01   6070.899902   6624.000000   5941.450195   6288.600098   6288.600098          0.0\n",
      "51   2008-09-08   6608.000000   6631.950195   6168.799805   6194.149902   6194.149902          0.0\n",
      "52   2008-09-15   6006.700195   6357.200195   5551.700195   6312.049805   6312.049805          0.0\n",
      "53   2008-09-22   6396.200195   6396.200195   5797.500000   5828.600098   5828.600098          0.0\n",
      "54   2008-09-29   5863.049805   6040.149902   5296.600098   5793.350098   5793.350098          0.0\n",
      "55   2008-10-06   5702.850098   5798.899902   4662.200195   4938.000000   4938.000000          0.0\n",
      "56   2008-10-13   5034.649902   5799.000000   5034.649902   5183.549805   5183.549805          0.0\n",
      "57   2008-10-20   5237.600098   5478.399902   4229.649902   4310.049805   4310.049805          0.0\n",
      "58   2008-10-27   4280.549805   4621.649902   3799.350098   4521.700195   4521.700195          0.0\n",
      "59   2008-11-03   4791.799805   5431.899902   4779.600098   5043.549805   5043.549805          0.0\n",
      "60   2008-11-10   5097.850098   5274.850098   4668.049805   4719.399902   4719.399902          0.0\n",
      "61   2008-11-17   4736.250000   4736.250000   3972.149902   4300.700195   4300.700195          0.0\n",
      "62   2008-11-24   4274.299805   4355.600098   4005.350098   4291.149902   4291.149902          0.0\n",
      "63   2008-12-01   4317.799805   4611.450195   3919.000000   4357.000000   4357.000000          0.0\n",
      "64   2008-12-08   4502.049805   4687.500000   4407.200195   4655.299805   4655.299805          0.0\n",
      "65   2008-12-15   4714.950195   5226.850098   4677.299805   5144.149902   5144.149902          0.0\n",
      "66   2008-12-22   5119.250000   5213.299805   4770.200195   4789.450195   4789.450195          0.0\n",
      "67   2008-12-29   4774.700195   5258.649902   4684.799805   5195.100098   5195.100098          0.0\n",
      "68   2009-01-05   5273.450195   5448.799805   4840.000000   4906.700195   4906.700195          0.0\n",
      "69   2009-01-12   4862.000000   4881.500000   4442.700195   4581.250000   4581.250000          0.0\n",
      "70   2009-01-19   4585.700195   4622.000000   4049.899902   4082.149902   4082.149902          0.0\n",
      "71   2009-01-26   4082.149902   4487.850098   4082.149902   4456.549805   4456.549805          0.0\n",
      "72   2009-02-02   4403.899902   4405.350098   4191.100098   4334.149902   4334.149902          0.0\n",
      "73   2009-02-09   4365.549805   4602.149902   4365.549805   4565.850098   4565.850098          0.0\n",
      "74   2009-02-16   4538.600098   4551.750000   3912.350098   3934.399902   3934.399902          0.0\n",
      "75   2009-02-23   3934.399902   3976.050049   3758.399902   3892.399902   3892.399902          0.0\n",
      "76   2009-03-02   3831.250000   3831.250000   3338.800049   3455.350098   3455.350098          0.0\n",
      "77   2009-03-09   3424.350098   3646.649902   3314.550049   3632.750000   3632.750000          0.0\n",
      "78   2009-03-16   3651.300049   3802.100098   3615.600098   3691.699951   3691.699951          0.0\n",
      "79   2009-03-23   3763.750000   4423.649902   3743.000000   4406.799805   4406.799805          0.0\n",
      "80   2009-03-30   4368.049805   4489.850098   3871.449951   4426.049805   4426.049805          0.0\n",
      "81   2009-04-06   4501.250000   4639.500000   4259.649902   4584.799805   4584.799805          0.0\n",
      "82   2009-04-13   4661.950195   5193.299805   4661.950195   5056.899902   5056.899902          0.0\n",
      "83   2009-04-20   5107.000000   5201.899902   4725.700195   5125.350098   5125.350098          0.0\n",
      "84   2009-04-27   5042.000000   5288.700195   4909.399902   5130.950195   5130.950195          0.0\n",
      "85   2009-05-04   5291.250000   5649.399902   5291.250000   5409.750000   5409.750000          0.0\n",
      "86   2009-05-11   5463.600098   5719.450195   5313.149902   5695.049805   5695.049805          0.0\n",
      "87   2009-05-18   6304.250000   7567.899902   6304.250000   7036.299805   7036.299805          0.0\n",
      "88   2009-05-25   7033.700195   7496.750000   6813.100098   7414.350098   7414.350098          0.0\n",
      "89   2009-06-01   7559.299805   7559.299805   7111.950195   7348.399902   7348.399902          0.0\n",
      "90   2009-06-08   7322.100098   7402.000000   6909.500000   7083.100098   7083.100098          0.0\n",
      "91   2009-06-15   7013.549805   7339.250000   6967.000000   7223.549805   7223.549805          0.0\n",
      "92   2009-06-22   7261.500000   7417.500000   6989.100098   7398.450195   7398.450195          0.0\n",
      "93   2009-06-29   7446.450195   7626.950195   7270.299805   7566.049805   7566.049805          0.0\n",
      "94   2009-07-06   7566.049805   7711.399902   6469.000000   6520.600098   6520.600098          0.0\n",
      "95   2009-07-13   6456.899902   7253.299805   6393.500000   7231.049805   7231.049805          0.0\n",
      "96   2009-07-20   7273.950195   7614.750000   7239.399902   7385.549805   7385.549805          0.0\n",
      "97   2009-07-27   7441.600098   7611.700195   7092.049805   7544.500000   7544.500000          0.0\n",
      "98   2009-08-03   7564.049805   7720.350098   7226.700195   7249.500000   7249.500000          0.0\n",
      "99   2009-08-10   7363.600098   7502.950195   6988.549805   7418.950195   7418.950195          0.0\n",
      "100  2009-08-17   7311.899902   7404.700195   6998.799805   7377.100098   7377.100098          0.0\n",
      "101  2009-08-24   7472.600098   7536.100098   7366.000000   7482.399902   7482.399902          0.0\n",
      "102  2009-08-31   7382.000000   7577.399902   7292.700195   7444.149902   7444.149902          0.0\n",
      "103  2009-09-07   7503.149902   7944.649902   7495.399902   7914.950195   7914.950195          0.0\n",
      "104  2009-09-14   7879.450195   8495.950195   7877.950195   8379.250000   8379.250000          0.0\n",
      "105  2009-09-21   8377.799805   8584.200195   8341.099609   8456.250000   8456.250000          0.0\n",
      "106  2009-09-28   8490.400391   8911.750000   8465.900391   8861.049805   8861.049805          0.0\n",
      "107  2009-10-05   8765.900391   8971.500000   8555.000000   8696.799805   8696.799805          0.0\n",
      "108  2009-10-12   8720.700195   9555.900391   8698.549805   9526.700195   9526.700195          0.0\n",
      "109  2009-10-19   9548.049805   9630.349609   9057.099609   9188.400391   9188.400391          0.0\n",
      "110  2009-10-26   9193.200195   9225.200195   8370.150391   8438.599609   8438.599609          0.0\n",
      "111  2009-11-02   8372.099609   8780.000000   8207.750000   8723.750000   8723.750000          0.0\n",
      "112  2009-11-09   8750.700195   9355.400391   8750.700195   9155.650391   9155.650391          0.0\n",
      "113  2009-11-16   9201.849609   9339.099609   8890.099609   9219.049805   9219.049805          0.0\n",
      "114  2009-11-23   9256.750000   9340.750000   8591.750000   8945.049805   8945.049805          0.0\n",
      "115  2009-11-30   9121.700195   9435.900391   8989.000000   9245.049805   9245.049805          0.0\n",
      "116  2009-12-07   9257.599609   9309.750000   9054.750000   9097.200195   9097.200195          0.0\n",
      "117  2009-12-14   9072.849609   9131.549805   8577.700195   8599.950195   8599.950195          0.0\n",
      "118  2009-12-21   8601.000000   9012.450195   8560.150391   8968.099609   8968.099609          0.0\n",
      "119  2009-12-28   8990.349609   9093.650391   8937.299805   9029.500000   9029.500000          0.0\n",
      "120  2010-01-04   9031.900391   9265.549805   9031.900391   9160.700195   9160.700195          0.0\n",
      "121  2010-01-11   9209.150391   9248.000000   8836.700195   8911.099609   8911.099609          0.0\n",
      "122  2010-01-18   8887.150391   9202.500000   8659.900391   8772.650391   8772.650391          0.0\n",
      "123  2010-01-25   8724.799805   8751.200195   8294.599609   8651.549805   8651.549805          0.0\n",
      "124  2010-02-01   8597.450195   8718.650391   8150.450195   8223.250000   8223.250000          0.0\n",
      "125  2010-02-08   8279.750000   8451.950195   8160.950195   8381.400391   8381.400391          0.0\n",
      "126  2010-02-15   8441.599609   8602.000000   8282.049805   8487.099609   8487.099609          0.0\n",
      "127  2010-02-22   8565.299805   8851.349609   8453.400391   8722.750000   8722.750000          0.0\n",
      "128  2010-03-01   8826.900391   9095.299805   8826.900391   9038.450195   9038.450195          0.0\n",
      "129  2010-03-08   9102.150391   9230.000000   9073.500000   9172.900391   9172.900391          0.0\n",
      "130  2010-03-15   9118.200195   9294.099609   8986.750000   9270.799805   9270.799805          0.0\n",
      "131  2010-03-22   9171.200195   9473.200195   9066.700195   9456.200195   9456.200195          0.0\n",
      "132  2010-03-29   9452.099609   9587.650391   9440.349609   9507.750000   9507.750000          0.0\n",
      "133  2010-04-05   9593.549805   9793.200195   9492.299805   9656.500000   9656.500000          0.0\n",
      "134  2010-04-12   9661.200195   9667.400391   9266.150391   9353.750000   9353.750000          0.0\n",
      "135  2010-04-19   9273.849609   9824.950195   9206.000000   9813.299805   9813.299805          0.0\n",
      "136  2010-04-26   9890.799805   9923.150391   9603.500000   9870.349609   9870.349609          0.0\n",
      "137  2010-05-03   9809.400391   9863.450195   9239.799805   9276.099609   9276.099609          0.0\n",
      "138  2010-05-10   9419.500000   9849.049805   9402.049805   9589.049805   9589.049805          0.0\n",
      "139  2010-05-17   9485.349609   9572.049805   8969.200195   9135.700195   9135.700195          0.0\n",
      "140  2010-05-24   9524.500000   9524.500000   8806.650391   9312.599609   9312.599609          0.0\n",
      "141  2010-05-31   9305.549805   9490.950195   9083.650391   9455.950195   9455.950195          0.0\n",
      "142  2010-06-07   9221.799805   9463.049805   9143.500000   9451.750000   9451.750000          0.0\n",
      "143  2010-06-14   9496.349609   9636.799805   9422.950195   9576.250000   9576.250000          0.0\n",
      "144  2010-06-21   9626.400391   9793.150391   9429.700195   9451.099609   9451.099609          0.0\n",
      "145  2010-06-28   9456.099609   9551.900391   9301.400391   9357.150391   9357.150391          0.0\n",
      "146  2010-07-05   9335.450195   9726.500000   9312.099609   9713.700195   9713.700195          0.0\n",
      "147  2010-07-12   9745.900391  10061.950195   9737.650391  10013.450195  10013.450195          0.0\n",
      "148  2010-07-19  10001.900391  10120.599609   9914.849609  10093.900391  10093.900391          0.0\n",
      "149  2010-07-26  10108.900391  10243.900391   9951.549805  10161.000000  10161.000000          0.0\n",
      "150  2010-08-02  10258.349609  10542.900391  10255.400391  10383.650391  10383.650391          0.0\n",
      "151  2010-08-09  10407.549805  10782.200195  10308.150391  10737.349609  10737.349609          0.0\n",
      "152  2010-08-16  10732.049805  11126.950195  10645.450195  11033.750000  11033.750000          0.0\n",
      "153  2010-08-23  11024.500000  11125.799805  10681.599609  10727.450195  10727.450195          0.0\n",
      "154  2010-08-30  10834.400391  11017.150391  10653.299805  10991.200195  10991.200195          0.0\n",
      "155  2010-09-06  11033.599609  11468.750000  11033.599609  11446.700195  11446.700195          0.0\n",
      "156  2010-09-13  11489.500000  12236.849609  11489.500000  12104.099609  12104.099609          0.0\n",
      "157  2010-09-20  12109.049805  12340.000000  12067.400391  12263.549805  12263.549805          0.0\n",
      "158  2010-09-27  12323.450195  12579.950195  12163.349609  12556.750000  12556.750000          0.0\n",
      "159  2010-10-04  12605.450195  12738.500000  12414.799805  12473.400391  12473.400391          0.0\n",
      "160  2010-10-11  12514.900391  12827.349609  12324.400391  12346.450195  12346.450195          0.0\n",
      "161  2010-10-18  12451.549805  12535.849609  12139.900391  12384.799805  12384.799805          0.0\n",
      "162  2010-10-25  12423.349609  12580.500000  11955.549805  12330.750000  12330.750000          0.0\n",
      "163  2010-11-01  12485.500000  13303.599609  12485.500000  13268.700195  13268.700195          0.0\n",
      "164  2010-11-08  13288.049805  13301.450195  12428.799805  12457.299805  12457.299805          0.0\n",
      "165  2010-11-15  12467.500000  12826.900391  12013.650391  12062.950195  12062.950195          0.0\n",
      "166  2010-11-22  12120.799805  12414.549805  11362.900391  11668.849609  11668.849609          0.0\n",
      "167  2010-11-29  11731.349609  12535.849609  11707.849609  12349.200195  12349.200195          0.0\n",
      "168  2010-12-06  12427.950195  12429.450195  10977.900391  11447.000000  11447.000000          0.0\n",
      "169  2010-12-13  11527.349609  11623.700195  11147.450195  11424.150391  11424.150391          0.0\n",
      "170  2010-12-20  11401.049805  11634.650391  11237.200195  11477.049805  11477.049805          0.0\n",
      "171  2010-12-27  11491.400391  11828.400391  11392.900391  11791.450195  11791.450195          0.0\n",
      "172  2011-01-03  11882.099609  11912.150391  11007.900391  11053.349609  11053.349609          0.0\n",
      "173  2011-01-10  11024.500000  11161.150391  10387.900391  10432.900391  10432.900391          0.0\n",
      "174  2011-01-17  10459.599609  10923.700195  10373.799805  10889.400391  10889.400391          0.0\n",
      "175  2011-01-24  10923.750000  11256.950195  10481.099609  10578.250000  10578.250000          0.0\n",
      "176  2011-01-31  10444.349609  10772.450195  10385.900391  10433.849609  10433.849609          0.0\n",
      "177  2011-02-07  10457.799805  10509.799805  10017.849609  10447.750000  10447.750000          0.0\n",
      "178  2011-02-14  10477.849609  11300.450195  10477.849609  10949.700195  10949.700195          0.0\n",
      "179  2011-02-21  10935.299805  11070.349609  10169.000000  10435.849609  10435.849609          0.0\n",
      "180  2011-02-28  10512.200195  11134.099609  10364.349609  10963.400391  10963.400391          0.0\n",
      "181  2011-03-07  10886.099609  11054.000000  10658.299805  10740.950195  10740.950195          0.0\n",
      "182  2011-03-14  10730.400391  11018.299805  10591.299805  10715.900391  10715.900391          0.0\n",
      "183  2011-03-21  10795.650391  11420.400391  10661.150391  11387.299805  11387.299805          0.0\n",
      "184  2011-03-28  11348.849609  11898.400391  11348.150391  11590.950195  11590.950195          0.0\n",
      "185  2011-04-04  11614.450195  11861.150391  11614.450195  11673.250000  11673.250000          0.0\n",
      "186  2011-04-11  11591.000000  11950.700195  11490.549805  11735.650391  11735.650391          0.0\n",
      "187  2011-04-18  11754.200195  11926.049805  11482.150391  11894.750000  11894.750000          0.0\n",
      "188  2011-04-25  11860.349609  11978.049805  11406.849609  11483.750000  11483.750000          0.0\n",
      "189  2011-05-02  11509.299805  11543.349609  10677.299805  11145.099609  11145.099609          0.0\n",
      "190  2011-05-09  11194.450195  11213.500000  10838.150391  11020.950195  11020.950195          0.0\n",
      "191  2011-05-16  10975.150391  10975.150391  10524.349609  10664.099609  10664.099609          0.0\n",
      "192  2011-05-23  10612.549805  10735.200195  10339.950195  10722.650391  10722.650391          0.0\n",
      "193  2011-05-30  10742.000000  11056.400391  10715.099609  10782.000000  10782.000000          0.0\n",
      "194  2011-06-06  10734.250000  10918.250000  10627.599609  10714.250000  10714.250000          0.0\n",
      "195  2011-06-13  10675.299805  10830.400391  10502.400391  10598.250000  10598.250000          0.0\n",
      "196  2011-06-20  10592.650391  10875.250000  10340.400391  10854.500000  10854.500000          0.0\n",
      "197  2011-06-27  10808.900391  11359.950195  10774.099609  11255.000000  11255.000000          0.0\n",
      "198  2011-07-04  11379.049805  11451.250000  11232.150391  11285.150391  11285.150391          0.0\n",
      "199  2011-07-11  11275.000000  11385.349609  10941.299805  11234.549805  11234.549805          0.0\n",
      "200  2011-07-18  11234.700195  11388.500000  11021.700195  11291.950195  11291.950195          0.0\n",
      "201  2011-07-25  11286.250000  11433.099609  10758.400391  10893.650391  10893.650391          0.0\n",
      "202  2011-08-01  11014.150391  11064.900391  10150.299805  10354.500000  10354.500000          0.0\n",
      "203  2011-08-08  10121.400391  10516.900391   9920.799805  10182.700195  10182.700195          0.0\n",
      "204  2011-08-15  10182.700195  10315.099609   9280.250000   9404.849609   9404.849609          0.0\n",
      "205  2011-08-22   9422.650391   9561.900391   8917.950195   8974.549805   8974.549805          0.0\n",
      "206  2011-08-29   9099.849609   9707.450195   9099.849609   9581.349609   9581.349609          0.0\n",
      "207  2011-09-05   9509.000000   9972.000000   9364.599609   9678.700195   9678.700195          0.0\n",
      "208  2011-09-12   9550.950195   9798.750000   9260.900391   9720.250000   9720.250000          0.0\n",
      "209  2011-09-19   9664.349609   9962.950195   9284.650391   9375.700195   9375.700195          0.0\n",
      "210  2011-09-26   9373.950195   9688.650391   9165.799805   9468.299805   9468.299805          0.0\n",
      "211  2011-10-03   9332.599609   9332.599609   8626.450195   9038.250000   9038.250000          0.0\n",
      "212  2011-10-10   9051.000000   9691.849609   8982.900391   9660.400391   9660.400391          0.0\n",
      "213  2011-10-17   9717.349609   9865.849609   9492.950195   9695.349609   9695.349609          0.0\n",
      "214  2011-10-24   9819.500000   9932.400391   9323.000000   9917.049805   9917.049805          0.0\n",
      "215  2011-10-31   9932.000000  10080.049805   9648.650391   9836.349609   9836.349609          0.0\n",
      "216  2011-11-07   9836.349609   9896.150391   9270.349609   9292.549805   9292.549805          0.0\n",
      "217  2011-11-14   9416.349609   9458.349609   8706.000000   8850.250000   8850.250000          0.0\n",
      "218  2011-11-21   8806.700195   8806.700195   8240.450195   8488.599609   8488.599609          0.0\n",
      "219  2011-11-28   8598.700195   9200.650391   8490.349609   9172.750000   9172.750000          0.0\n",
      "220  2011-12-05   9154.900391   9273.099609   8689.849609   8811.099609   8811.099609          0.0\n",
      "221  2011-12-12   8900.900391   8920.250000   8127.200195   8171.899902   8171.899902          0.0\n",
      "222  2011-12-19   8122.250000   8451.950195   7766.350098   8296.450195   8296.450195          0.0\n",
      "223  2011-12-26   8348.549805   8365.750000   7925.149902   7968.649902   7968.649902          0.0\n",
      "224  2012-01-02   8072.799805   8586.650391   8072.799805   8488.250000   8488.250000          0.0\n",
      "225  2012-01-09   8450.400391   9073.000000   8329.900391   8975.049805   8975.049805          0.0\n",
      "226  2012-01-16   8913.250000   9560.150391   8813.849609   9516.849609   9516.849609          0.0\n",
      "227  2012-01-23   9503.099609   9969.250000   9456.250000   9813.650391   9813.650391          0.0\n",
      "228  2012-01-30   9741.250000  10158.950195   9509.150391  10133.650391  10133.650391          0.0\n",
      "229  2012-02-06  10219.599609  10555.000000  10183.450195  10442.650391  10442.650391          0.0\n",
      "230  2012-02-13  10451.099609  11203.349609  10335.700195  11074.900391  11074.900391          0.0\n",
      "231  2012-02-20  11042.599609  11226.750000  10435.549805  10506.799805  10506.799805          0.0\n",
      "232  2012-02-27  10527.650391  10667.299805  10073.900391  10434.299805  10434.299805          0.0\n",
      "233  2012-03-05  10406.849609  10526.549805   9939.950195  10505.650391  10505.650391          0.0\n",
      "234  2012-03-12  10765.950195  10912.049805  10348.049805  10391.349609  10391.349609          0.0\n",
      "235  2012-03-19  10440.849609  10583.750000  10125.750000  10294.549805  10294.549805          0.0\n",
      "236  2012-03-26  10260.200195  10263.099609   9845.400391  10212.750000  10212.750000          0.0\n",
      "237  2012-04-02  10186.799805  10502.700195  10180.950195  10340.099609  10340.099609          0.0\n",
      "238  2012-04-09  10256.650391  10587.950195  10060.700195  10306.250000  10306.250000          0.0\n",
      "239  2012-04-16  10274.150391  10645.849609  10248.549805  10456.500000  10456.500000          0.0\n",
      "240  2012-04-23  10432.599609  10521.450195  10029.450195  10148.700195  10148.700195          0.0\n",
      "241  2012-04-30  10210.099609  10382.349609   9757.750000   9802.349609   9802.349609          0.0\n",
      "242  2012-05-07   9664.849609   9924.150391   9296.650391   9398.099609   9398.099609          0.0\n",
      "243  2012-05-14   9412.599609   9498.799805   8995.250000   9310.250000   9310.250000          0.0\n",
      "244  2012-05-21   9510.450195   9522.299805   9157.200195   9456.299805   9456.299805          0.0\n",
      "245  2012-05-28   9483.099609   9783.450195   9252.599609   9267.599609   9267.599609          0.0\n",
      "246  2012-06-04   9174.549805  10031.200195   9110.450195   9998.849609   9998.849609          0.0\n",
      "247  2012-06-11  10070.150391  10224.549805   9813.650391  10064.799805  10064.799805          0.0\n",
      "248  2012-06-18  10178.849609  10197.799805   9619.150391  10038.349609  10038.349609          0.0\n",
      "249  2012-06-25  10068.900391  10360.000000   9892.799805  10340.650391  10340.650391          0.0\n",
      "250  2012-07-02  10366.500000  10687.900391  10303.650391  10655.349609  10655.349609          0.0\n",
      "251  2012-07-09  10594.950195  10782.549805  10524.750000  10594.450195  10594.450195          0.0\n",
      "252  2012-07-16  10614.099609  10708.599609  10463.400391  10481.599609  10481.599609          0.0\n",
      "253  2012-07-23  10401.700195  10402.250000  10056.150391  10140.549805  10140.549805          0.0\n",
      "254  2012-07-30  10222.549805  10467.950195  10209.150391  10315.599609  10315.599609          0.0\n",
      "255  2012-08-06  10426.750000  10640.750000  10272.049805  10358.950195  10358.950195          0.0\n",
      "256  2012-08-13  10339.200195  10551.049805  10284.049805  10417.900391  10417.900391          0.0\n",
      "257  2012-08-20  10417.900391  10560.849609  10318.549805  10332.849609  10332.849609          0.0\n",
      "258  2012-08-27  10338.250000  10338.250000   9948.700195   9990.500000   9990.500000          0.0\n",
      "259  2012-09-03  10030.849609  10134.750000   9814.049805  10122.000000  10122.000000          0.0\n",
      "260  2012-09-10  10153.799805  10664.549805  10006.500000  10642.900391  10642.900391          0.0\n",
      "261  2012-09-17  10797.099609  11433.099609  10797.099609  11358.500000  11358.500000          0.0\n",
      "262  2012-09-24  11359.299805  11536.849609  11321.200195  11456.799805  11456.799805          0.0\n",
      "263  2012-10-01  11462.099609  11745.200195  10043.599609  11511.400391  11511.400391          0.0\n",
      "264  2012-10-08  11530.650391  11530.650391  11244.700195  11388.450195  11388.450195          0.0\n",
      "265  2012-10-15  11397.700195  11605.650391  11288.400391  11491.200195  11491.200195          0.0\n",
      "266  2012-10-22  11422.099609  11656.799805  11419.400391  11509.150391  11509.150391          0.0\n",
      "267  2012-10-29  11506.500000  11600.049805  11125.200195  11460.450195  11460.450195          0.0\n",
      "268  2012-11-05  11449.700195  11719.099609  11401.299805  11475.599609  11475.599609          0.0\n",
      "269  2012-11-12  11488.099609  11608.799805  11306.049805  11335.500000  11335.500000          0.0\n",
      "270  2012-11-19  11342.650391  11570.849609  11256.400391  11475.799805  11475.799805          0.0\n",
      "271  2012-11-26  11534.200195  12175.299805  11411.099609  12158.900391  12158.900391          0.0\n",
      "272  2012-12-03  12126.599609  12480.599609  12053.450195  12363.700195  12363.700195          0.0\n",
      "273  2012-12-10  12380.000000  12538.900391  12238.000000  12424.700195  12424.700195          0.0\n",
      "274  2012-12-17  12403.650391  12571.599609  12197.200195  12315.049805  12315.049805          0.0\n",
      "275  2012-12-24  12363.849609  12523.500000  12265.750000  12458.150391  12458.150391          0.0\n",
      "276  2012-12-31  12442.849609  12837.799805  12427.700195  12787.349609  12787.349609          0.0\n",
      "277  2013-01-07  12837.450195  12837.450195  12582.650391  12617.849609  12617.849609          0.0\n",
      "278  2013-01-14  12622.049805  12908.200195  12583.349609  12680.000000  12680.000000          0.0\n",
      "279  2013-01-21  12678.000000  12748.950195  12509.450195  12693.250000  12693.250000          0.0\n",
      "280  2013-01-28  12705.799805  12960.650391  12580.849609  12606.250000  12606.250000          0.0\n",
      "281  2013-02-04  12656.849609  12723.299805  12245.950195  12280.150391  12280.150391          0.0\n",
      "282  2013-02-11  12298.099609  12485.950195  12256.799805  12336.549805  12336.549805          0.0\n",
      "283  2013-02-18  12353.000000  12470.700195  12024.400391  12068.950195  12068.950195          0.0\n",
      "284  2013-02-25  12119.950195  12137.849609  11401.200195  11540.049805  11540.049805          0.0\n",
      "285  2013-03-04  11515.400391  12219.450195  11453.099609  12197.250000  12197.250000          0.0\n",
      "286  2013-03-11  12221.500000  12241.299805  11555.450195  11816.549805  11816.549805          0.0\n",
      "287  2013-03-18  11679.349609  11814.750000  11173.349609  11204.049805  11204.049805          0.0\n",
      "288  2013-03-25  11204.049805  11413.250000  11048.400391  11361.849609  11361.849609          0.0\n",
      "289  2013-04-01  11361.849609  11590.599609  11021.400391  11098.950195  11098.950195          0.0\n",
      "290  2013-04-08  11098.950195  11442.900391  10888.750000  11410.099609  11410.099609          0.0\n",
      "291  2013-04-15  11410.099609  12313.000000  11334.750000  12288.250000  12288.250000          0.0\n",
      "292  2013-04-22  12288.250000  12755.799805  12288.250000  12533.150391  12533.150391          0.0\n",
      "293  2013-04-29  12533.150391  12783.299805  12364.700195  12393.599609  12393.599609          0.0\n",
      "294  2013-05-06  12393.599609  12783.049805  12188.299805  12752.299805  12752.299805          0.0\n",
      "295  2013-05-13  12780.150391  13355.099609  12516.099609  13317.099609  13317.099609          0.0\n",
      "296  2013-05-20  13317.099609  13414.299805  12582.500000  12769.349609  12769.349609          0.0\n",
      "297  2013-05-27  12769.349609  13016.450195  12453.150391  12475.650391  12475.650391          0.0\n",
      "298  2013-06-03  12475.650391  12520.549805  12184.049805  12231.500000  12231.500000          0.0\n",
      "299  2013-06-10  12231.500000  12363.799805  11656.900391  11922.849609  11922.849609          0.0\n",
      "300  2013-06-17  11922.849609  11992.950195  11210.750000  11340.150391  11340.150391          0.0\n",
      "301  2013-06-24  11340.150391  11654.700195  11033.750000  11617.250000  11617.250000          0.0\n",
      "302  2013-07-01  11617.250000  11752.900391  11273.599609  11434.299805  11434.299805          0.0\n",
      "303  2013-07-08  11434.299805  11743.250000  11176.650391  11722.799805  11722.799805          0.0\n",
      "304  2013-07-15  11722.799805  11811.900391  10829.750000  10973.900391  10973.900391          0.0\n",
      "305  2013-07-22  10973.900391  11285.799805  10352.950195  10465.250000  10465.250000          0.0\n",
      "306  2013-07-29  10465.250000  10465.250000   9863.049805   9997.799805   9997.799805          0.0\n",
      "307  2013-08-05   9997.799805  10117.650391   9660.299805   9816.400391   9816.400391          0.0\n",
      "308  2013-08-12   9816.400391  10071.250000   9420.150391   9450.849609   9450.849609          0.0\n",
      "309  2013-08-19   9425.500000   9766.099609   8860.150391   9470.099609   9470.099609     276000.0\n",
      "310  2013-08-26   9529.700195   9586.650391   8366.750000   9049.200195   9049.200195     298200.0\n",
      "311  2013-09-02   9112.799805   9989.849609   8605.650391   9961.400391   9961.400391     210700.0\n",
      "312  2013-09-09   9961.400391  10409.150391   9961.400391  10180.450195  10180.450195     222700.0\n",
      "313  2013-09-16  10418.500000  11219.450195  10175.049805  10686.799805  10686.799805     300500.0\n",
      "314  2013-09-23  10466.299805  10509.549805   9883.950195   9899.750000   9899.750000     237700.0\n",
      "315  2013-09-30   9783.900391  10328.750000   9582.750000  10197.150391  10197.150391     161000.0\n",
      "316  2013-10-07  10124.150391  10649.299805   9877.450195  10622.150391  10622.150391     187000.0\n",
      "317  2013-10-14  10588.950195  10784.000000  10274.349609  10744.900391  10744.900391     155000.0\n",
      "318  2013-10-21  10751.700195  11091.599609  10700.549805  10896.500000  10896.500000     203100.0\n",
      "319  2013-10-28  10924.450195  11694.450195  10669.000000  11628.650391  11628.650391   28430400.0\n",
      "320  2013-11-04  11539.750000  11736.200195  10841.599609  10913.150391  10913.150391     179800.0\n",
      "321  2013-11-11  10786.250000  10940.500000  10412.049805  10811.200195  10811.200195     173100.0\n",
      "322  2013-11-18  10962.250000  11207.700195  10630.549805  10677.349609  10677.349609     175700.0\n",
      "323  2013-11-25  10780.599609  11186.150391  10780.599609  11153.950195  11153.950195     195400.0\n",
      "324  2013-12-02  11180.299805  11770.650391  11107.750000  11720.200195  11720.200195     172400.0\n",
      "325  2013-12-09  12206.950195  12225.950195  11349.849609  11366.900391  11366.900391     167400.0\n",
      "326  2013-12-16  11347.200195  11572.299805  11040.150391  11292.349609  11292.349609     157300.0\n",
      "327  2013-12-23  11258.650391  11514.450195  11258.650391  11459.700195  11459.700195     102400.0\n",
      "328  2013-12-30  11532.599609  11578.900391  11052.599609  11181.650391  11181.650391     103300.0\n",
      "329  2014-01-06  11174.349609  11174.349609  10788.200195  10805.299805  10805.299805     149500.0\n",
      "330  2014-01-13  10814.650391  11192.799805  10814.650391  10911.349609  10911.349609     137000.0\n",
      "331  2014-01-20  10909.900391  11248.349609  10876.250000  10982.400391  10982.400391     108800.0\n",
      "332  2014-01-27  10802.299805  10802.299805  10101.200195  10237.750000  10237.750000     203800.0\n",
      "333  2014-02-03  10205.450195  10321.500000   9944.000000  10263.200195  10263.200195     151500.0\n",
      "334  2014-02-10  10287.349609  10395.150391  10064.750000  10203.750000  10203.750000     111400.0\n",
      "335  2014-02-17  10324.349609  10630.150391  10296.250000  10554.349609  10554.349609      86900.0\n",
      "336  2014-02-24  10508.950195  10793.599609  10471.450195  10764.700195  10764.700195      83700.0\n",
      "337  2014-03-03  10705.450195  11947.500000  10613.000000  11884.750000  11884.750000     214700.0\n",
      "338  2014-03-10  11784.549805  12308.700195  11784.549805  12055.849609  12055.849609     218000.0\n",
      "339  2014-03-17  12093.200195  12268.750000  11989.950195  12092.349609  12092.349609     127800.0\n",
      "340  2014-03-24  12134.650391  12787.500000  12134.650391  12754.700195  12754.700195     196200.0\n",
      "341  2014-03-31  12855.500000  12869.349609  12430.849609  12551.700195  12551.700195     183900.0\n",
      "342  2014-04-07  12562.349609  13055.599609  12439.549805  12840.200195  12840.200195     131100.0\n",
      "343  2014-04-14  12830.500000  12831.599609  12514.750000  12787.250000  12787.250000      90300.0\n",
      "344  2014-04-21  12845.299805  13268.599609  12838.849609  13034.500000  13034.500000     144600.0\n",
      "345  2014-04-28  13038.950195  13124.299805  12738.599609  12842.000000  12842.000000     118300.0\n",
      "346  2014-05-05  12841.400391  13814.250000  12773.049805  13750.500000  13750.500000     157500.0\n",
      "347  2014-05-12  13801.000000  15742.049805  13801.000000  14853.000000  14853.000000     321200.0\n",
      "348  2014-05-19  15032.000000  15362.549805  14857.500000  15285.500000  15285.500000     232900.0\n",
      "349  2014-05-26  15431.950195  15568.049805  14709.299805  14793.400391  14793.400391     198500.0\n",
      "350  2014-06-02  14786.450195  15576.049805  14770.000000  15543.150391  15543.150391     176800.0\n",
      "351  2014-06-09  15625.400391  15725.799805  15083.900391  15106.900391  15106.900391     172400.0\n",
      "352  2014-06-16  15055.200195  15461.549805  14858.900391  14997.650391  14997.650391     153200.0\n",
      "353  2014-06-23  15014.200195  15341.950195  14940.349609  14992.349609  14992.349609     135000.0\n",
      "354  2014-06-30  15059.099609  15582.650391  15059.099609  15556.150391  15556.150391     121400.0\n",
      "355  2014-07-07  15589.500000  15592.799805  14406.650391  14447.200195  14447.200195     171400.0\n",
      "356  2014-07-14  14508.099609  15463.150391  14338.650391  15389.349609  15389.349609     157000.0\n",
      "357  2014-07-21  15510.000000  15626.900391  15272.450195  15322.250000  15322.250000     134900.0\n",
      "358  2014-07-28  15399.500000  15499.500000  15096.099609  15127.799805  15127.799805     127400.0\n",
      "359  2014-08-04  15242.250000  15343.500000  14709.099609  14765.750000  14765.750000     120800.0\n",
      "360  2014-08-11  14858.750000  15144.750000  14807.000000  15089.650391  15089.650391      92500.0\n",
      "361  2014-08-18  15099.700195  15865.299805  15068.349609  15819.150391  15819.150391     146700.0\n",
      "362  2014-08-25  15817.549805  15973.349609  15503.400391  15740.400391  15740.400391      89100.0\n",
      "363  2014-09-01  15790.250000  16208.549805  15790.250000  15982.500000  15982.500000     123900.0\n",
      "364  2014-09-08  16084.200195  16309.700195  16049.250000  16254.150391  16254.150391     111200.0\n",
      "365  2014-09-15  16158.650391  16239.700195  15770.799805  16152.150391  16152.150391     123500.0\n",
      "366  2014-09-22  16052.549805  16272.349609  15168.400391  15607.250000  15607.250000     148000.0\n",
      "367  2014-09-29  15636.450195  15636.450195  15270.950195  15316.200195  15316.200195      69500.0\n",
      "368  2014-10-06  15214.250000  15795.650391  15130.349609  15453.799805  15453.799805      92400.0\n",
      "369  2014-10-13  15360.700195  15973.500000  15301.650391  15929.799805  15929.799805     120500.0\n",
      "370  2014-10-20  16259.700195  16572.500000  16157.049805  16470.050781  16470.050781      94400.0\n",
      "371  2014-10-27  16538.900391  17060.150391  16470.849609  17045.050781  17045.050781     122100.0\n",
      "372  2014-11-03  17087.000000  17425.199219  16934.849609  17347.050781  17347.050781      82300.0\n",
      "373  2014-11-10  17364.650391  17651.000000  17203.000000  17576.800781  17576.800781     118900.0\n",
      "374  2014-11-17  17571.699219  18139.949219  17469.250000  18056.300781  18056.300781     165300.0\n",
      "375  2014-11-24  18128.599609  18615.400391  17890.849609  18513.150391  18513.150391     241600.0\n",
      "376  2014-12-01  18586.949219  18875.449219  18301.000000  18756.750000  18756.750000     230200.0\n",
      "377  2014-12-08  18804.949219  18804.949219  18183.099609  18299.750000  18299.750000     110300.0\n",
      "378  2014-12-15  18176.699219  18563.599609  17502.449219  18478.900391  18478.900391      63600.0\n",
      "379  2014-12-22  18562.349609  18923.599609  18424.000000  18557.199219  18557.199219          0.0\n",
      "380  2014-12-29  18589.599609  19118.849609  18428.099609  19057.800781  19057.800781          0.0\n",
      "381  2015-01-05  19155.199219  19166.000000  18211.500000  18637.250000  18637.250000          0.0\n",
      "382  2015-01-12  18632.000000  19410.400391  18517.900391  19223.150391  19223.150391          0.0\n",
      "383  2015-01-19  19345.650391  20167.650391  19299.099609  20072.699219  20072.699219          0.0\n",
      "384  2015-01-26  20179.800781  20907.550781  19732.449219  19843.750000  19843.750000          0.0\n",
      "385  2015-02-02  19778.949219  19991.400391  18977.900391  19051.900391  19051.900391          0.0\n",
      "386  2015-02-09  18650.000000  19441.000000  18226.900391  19369.699219  19369.699219          0.0\n",
      "387  2015-02-16  19518.849609  19532.699219  18876.250000  19073.550781  19073.550781      61900.0\n",
      "388  2015-02-23  19199.150391  19219.750000  18489.599609  19074.550781  19074.550781          0.0\n",
      "389  2015-03-02  19954.500000  20541.650391  19398.750000  19748.000000  19748.000000      58100.0\n",
      "390  2015-03-09  19545.250000  19545.250000  18737.349609  18779.800781  18779.800781          0.0\n",
      "391  2015-03-16  18786.650391  19373.449219  18541.500000  18606.349609  18606.349609          0.0\n",
      "392  2015-03-23  18695.050781  18696.699219  17719.349609  18044.800781  18044.800781          0.0\n",
      "393  2015-03-30  18160.199219  18494.349609  18089.449219  18206.650391  18206.650391          0.0\n",
      "394  2015-04-06  18702.599609  18894.750000  18351.800781  18875.849609  18875.849609          0.0\n",
      "395  2015-04-13  18848.650391  19038.500000  18504.699219  18637.050781  18637.050781          0.0\n",
      "396  2015-04-20  18386.250000  18500.300781  17798.650391  18245.599609  18245.599609          0.0\n",
      "397  2015-04-27  18063.599609  18431.900391  17738.900391  18302.650391  18302.650391          0.0\n",
      "398  2015-05-04  18417.500000  18586.300781  17246.550781  17376.900391  17376.900391          0.0\n",
      "399  2015-05-11  17921.150391  18240.650391  17597.750000  18116.199219  18116.199219          0.0\n",
      "400  2015-05-18  18274.599609  18619.599609  18213.750000  18513.150391  18513.150391          0.0\n",
      "401  2015-05-25  18405.050781  18751.199219  18226.000000  18721.349609  18721.349609          0.0\n",
      "402  2015-06-01  18721.150391  18832.500000  17469.650391  17549.250000  17549.250000          0.0\n",
      "403  2015-06-08  17542.500000  17821.900391  17174.699219  17523.550781  17523.550781          0.0\n",
      "404  2015-06-15  17499.349609  17935.300781  17293.449219  17880.849609  17880.849609      43900.0\n",
      "405  2015-06-22  17956.550781  18539.150391  17950.599609  18371.500000  18371.500000          0.0\n",
      "406  2015-06-29  17962.500000  18642.849609  17821.900391  18585.550781  18585.550781          0.0\n",
      "407  2015-07-06  18488.349609  18980.650391  18402.849609  18719.800781  18719.800781          0.0\n",
      "408  2015-07-13  18753.800781  19229.050781  18657.599609  19094.699219  19094.699219          0.0\n",
      "409  2015-07-20  19126.099609  19149.050781  18613.550781  18635.849609  18635.849609          0.0\n",
      "410  2015-07-27  18566.550781  18828.849609  18174.199219  18729.849609  18729.849609          0.0\n",
      "411  2015-08-03  18782.650391  19103.699219  18758.900391  18893.550781  18893.550781          0.0\n",
      "412  2015-08-10  18926.099609  19071.349609  18034.750000  18723.599609  18723.599609          0.0\n",
      "413  2015-08-17  18763.050781  18896.449219  17842.099609  18057.199219  18057.199219          0.0\n",
      "414  2015-08-24  17446.349609  17569.800781  16670.550781  17211.949219  17211.949219          0.0\n",
      "415  2015-08-31  17137.250000  17353.300781  15933.150391  16129.099609  16129.099609      85700.0\n",
      "416  2015-09-07  16222.200195  16781.550781  15762.200195  16612.599609  16612.599609          0.0\n",
      "417  2015-09-14  16596.500000  17602.000000  16525.150391  17409.150391  17409.150391          0.0\n",
      "418  2015-09-21  17186.050781  17652.349609  16759.000000  17255.300781  17255.300781          0.0\n",
      "419  2015-09-28  17286.250000  17461.349609  16648.300781  17216.300781  17216.300781          0.0\n",
      "420  2015-10-05  17373.550781  17827.150391  17362.699219  17590.250000  17590.250000          0.0\n",
      "421  2015-10-12  17642.599609  17947.750000  17434.050781  17912.849609  17912.849609          0.0\n",
      "422  2015-10-19  17911.650391  17980.500000  17565.349609  17934.050781  17934.050781          0.0\n",
      "423  2015-10-26  18027.099609  18029.050781  17170.349609  17354.500000  17354.500000          0.0\n",
      "424  2015-11-02  17351.449219  17466.199219  16957.349609  16995.099609  16995.099609          0.0\n",
      "430  2015-12-14  16342.349609  16425.150391  16188.049805  16398.650391  16398.650391      54700.0\n",
      "434  2016-01-11  15612.099609  15803.200195  15453.400391  15609.799805  15609.799805      79300.0\n",
      "436  2016-01-25  15667.000000  15682.650391  15495.099609  15561.150391  15561.150391   64213000.0\n",
      "438  2016-02-08  15206.299805  15367.900391  14960.099609  15046.799805  15046.799805      86500.0\n",
      "439  2016-02-15  14243.450195  14395.849609  14207.349609  14344.200195  14344.200195      96300.0\n",
      "440  2016-02-22  13844.450195  13844.450195  13519.900391  13555.700195  13555.700195     104600.0\n",
      "446  2016-04-04  16236.900391  16278.500000  16046.500000  16190.599609  16190.599609      70300.0\n",
      "453  2016-05-23  16600.650391  17025.849609  16599.050781  16997.449219  16997.449219      83900.0\n",
      "455  2016-06-06  17710.449219  18051.500000  17636.900391  17828.599609  17828.599609     170300.0\n",
      "462  2016-07-25  19050.400391  19126.750000  18998.800781  19076.550781  19076.550781     146300.0\n",
      "477  2016-11-07  20200.250000  20200.250000  20200.250000  20200.250000  20200.250000          0.0\n",
      "482  2016-12-12  18616.050781  18616.050781  18122.099609  18312.800781  18312.800781          0.0\n",
      "483  2016-12-19  18258.099609  18316.800781  17819.750000  17884.000000  17884.000000          0.0\n",
      "484  2016-12-26  17677.699219  18245.750000  17616.099609  18177.199219  18177.199219          0.0\n",
      "485  2017-01-02  18002.750000  18325.500000  17830.949219  18264.000000  18264.000000          0.0\n",
      "486  2017-01-09  18314.250000  18966.300781  18256.150391  18912.099609  18912.099609          0.0\n",
      "487  2017-01-16  18899.699219  19276.500000  18793.050781  18820.800781  18820.800781          0.0\n",
      "488  2017-01-23  18762.000000  19794.949219  18722.849609  19708.300781  19708.300781          0.0\n",
      "489  2017-01-30  19718.800781  20229.650391  19435.449219  20196.800781  20196.800781          0.0\n",
      "490  2017-02-06  20307.150391  20462.449219  20000.349609  20213.900391  20213.900391          0.0\n",
      "491  2017-02-13  20273.650391  21042.349609  20088.199219  20551.349609  20551.349609          0.0\n",
      "492  2017-02-20  20494.849609  21011.900391  20472.400391  20876.650391  20876.650391          0.0\n",
      "493  2017-02-27  20853.449219  20905.000000  20423.349609  20495.599609  20495.599609          0.0\n",
      "494  2017-03-06  20548.949219  20876.949219  20532.199219  20727.550781  20727.550781          0.0\n",
      "495  2017-03-13  21189.849609  21336.050781  21059.699219  21175.050781  21175.050781          0.0\n",
      "496  2017-03-20  21202.550781  21202.550781  20753.900391  21122.550781  21122.550781          0.0\n",
      "497  2017-03-27  21178.099609  21696.000000  20979.550781  21444.150391  21444.150391          0.0\n",
      "498  2017-04-03  21539.199219  21699.300781  21397.000000  21431.150391  21431.150391          0.0\n",
      "499  2017-04-10  21492.050781  21787.099609  21396.050781  21686.599609  21686.599609          0.0\n",
      "500  2017-04-17  21700.500000  21947.000000  21386.199219  21551.449219  21551.449219          0.0\n",
      "501  2017-04-24  21591.900391  22383.000000  21578.650391  22358.250000  22358.250000          0.0\n",
      "502  2017-05-01  22412.550781  22853.550781  22240.050781  22604.949219  22604.949219          0.0\n",
      "503  2017-05-08  22678.449219  22977.849609  22578.000000  22671.699219  22671.699219          0.0\n",
      "504  2017-05-15  22735.849609  22978.150391  22628.449219  22769.800781  22769.800781          0.0\n",
      "505  2017-05-22  22874.800781  23408.349609  22469.800781  23362.199219  23362.199219          0.0\n",
      "506  2017-05-29  23310.599609  23469.449219  23093.949219  23375.900391  23375.900391          0.0\n",
      "507  2017-06-05  23397.400391  23708.650391  23349.949219  23690.900391  23690.900391          0.0\n",
      "508  2017-06-12  23610.150391  23630.099609  23311.849609  23502.750000  23502.750000          0.0\n",
      "509  2017-06-19  23571.349609  23897.849609  23507.500000  23542.750000  23542.750000          0.0\n",
      "510  2017-06-26  23636.949219  23640.099609  22996.400391  23211.199219  23211.199219          0.0\n",
      "511  2017-07-03  23240.349609  23540.150391  23144.300781  23449.150391  23449.150391          0.0\n",
      "512  2017-07-10  23583.250000  23964.800781  23289.900391  23937.699219  23937.699219          0.0\n",
      "513  2017-07-17  24011.400391  24299.599609  23913.650391  24257.050781  24257.050781          0.0\n",
      "514  2017-07-24  24307.699219  25032.250000  24234.650391  24811.300781  24811.300781          0.0\n",
      "515  2017-07-31  24880.599609  25198.800781  24591.800781  24827.449219  24827.449219          0.0\n",
      "516  2017-08-07  24854.150391  24979.349609  23822.199219  23985.750000  23985.750000          0.0\n",
      "517  2017-08-14  24051.050781  24496.199219  23925.949219  24074.449219  24074.449219          0.0\n",
      "518  2017-08-21  24140.550781  24411.050781  23852.650391  24274.199219  24274.199219          0.0\n",
      "519  2017-08-28  24351.250000  24494.349609  24103.300781  24434.000000  24434.000000          0.0\n",
      "520  2017-09-04  24272.599609  24419.250000  24151.099609  24370.800781  24370.800781          0.0\n",
      "521  2017-09-11  24468.500000  24994.300781  24458.250000  24844.300781  24844.300781          0.0\n",
      "522  2017-09-18  24948.150391  25105.349609  24340.000000  24368.849609  24368.849609          0.0\n",
      "523  2017-09-25  24361.550781  24363.800781  23611.099609  24053.000000  24053.000000          0.0\n",
      "524  2017-10-02  24200.599609  24242.050781  24007.250000  24190.000000  24190.000000          0.0\n",
      "525  2017-10-09  24209.550781  24779.750000  23978.400391  24689.150391  24689.150391          0.0\n",
      "526  2017-10-16  24815.400391  24878.650391  23923.699219  24009.750000  24009.750000          0.0\n",
      "527  2017-10-23  24085.449219  25186.050781  23912.550781  24839.550781  24839.550781      94700.0\n",
      "528  2017-10-30  24873.650391  25695.500000  24808.550781  25650.699219  25650.699219          0.0\n",
      "529  2017-11-06  25569.000000  25695.750000  25119.500000  25498.949219  25498.949219          0.0\n",
      "530  2017-11-13  25570.250000  25924.900391  25166.349609  25728.400391  25728.400391          0.0\n",
      "531  2017-11-20  25733.699219  25871.099609  25620.949219  25779.650391  25779.650391      76600.0\n",
      "532  2017-11-27  25693.050781  25953.500000  25152.650391  25191.949219  25191.949219          0.0\n",
      "533  2017-12-04  25295.050781  25367.699219  24813.599609  25321.150391  25321.150391          0.0\n",
      "534  2017-12-11  25434.750000  25559.050781  24888.650391  25440.300781  25440.300781          0.0\n",
      "535  2017-12-18  25181.750000  25780.050781  24617.150391  25648.550781  25648.550781          0.0\n",
      "536  2017-12-25  25659.750000  25733.199219  25417.400391  25539.449219  25539.449219          0.0\n",
      "537  2018-01-01  25382.199219  25643.349609  25232.800781  25601.849609  25601.849609          0.0\n",
      "538  2018-01-08  25690.250000  25803.800781  25527.500000  25749.050781  25749.050781          0.0\n",
      "539  2018-01-15  25858.150391  26957.849609  25842.949219  26909.500000  26909.500000          0.0\n",
      "540  2018-01-22  26940.500000  27522.849609  26841.199219  27445.650391  27445.650391          0.0\n",
      "541  2018-01-29  27446.099609  27652.050781  26364.050781  26451.150391  26451.150391          0.0\n",
      "542  2018-02-05  25968.150391  26215.099609  25023.849609  25463.650391  25463.650391          0.0\n",
      "543  2018-02-12  25530.099609  25810.250000  25100.900391  25163.900391  25163.900391          0.0\n",
      "544  2018-02-19  25324.599609  25345.150391  24781.699219  25302.500000  25302.500000     265300.0\n",
      "545  2018-02-26  25452.000000  25723.550781  24854.400391  24902.550781  24902.550781          0.0\n",
      "546  2018-03-05  24831.349609  25040.250000  24048.550781  24296.449219  24296.449219     134500.0\n",
      "547  2018-03-12  24443.599609  25009.650391  24358.500000  24489.550781  24489.550781          0.0\n",
      "548  2018-03-19  24530.150391  24588.050781  23605.599609  23670.400391  23670.400391          0.0\n",
      "549  2018-03-26  23674.900391  24496.949219  23657.050781  24263.349609  24263.349609          0.0\n",
      "550  2018-04-02  24235.650391  24933.599609  24062.949219  24873.150391  24873.150391          0.0\n",
      "551  2018-04-09  24848.849609  25411.300781  24828.000000  25200.599609  25200.599609          0.0\n",
      "552  2018-04-16  25082.099609  25426.750000  24839.300781  24943.849609  24943.849609          0.0\n",
      "553  2018-04-23  25065.500000  25441.500000  24466.099609  25394.599609  25394.599609          0.0\n",
      "554  2018-04-30  25490.150391  25716.750000  25464.800781  25645.400391  25645.400391     306200.0\n",
      "555  2018-05-07  25676.250000  26437.250000  25675.150391  26413.150391  26413.150391          0.0\n",
      "556  2018-05-14  26404.449219  26972.050781  25839.000000  25875.599609  25875.599609          0.0\n",
      "557  2018-05-21  26017.500000  26325.550781  25622.150391  26273.550781  26273.550781          0.0\n",
      "558  2018-05-28  26291.650391  27164.550781  25980.849609  26692.800781  26692.800781          0.0\n",
      "559  2018-06-04  27023.699219  27047.550781  26069.550781  26451.349609  26451.349609          0.0\n",
      "560  2018-06-11  26473.199219  26765.449219  26344.949219  26417.400391  26417.400391          0.0\n",
      "561  2018-06-18  26444.300781  26806.550781  26224.750000  26766.849609  26766.849609          0.0\n",
      "562  2018-06-25  26718.150391  26804.900391  26161.000000  26364.199219  26364.199219          0.0\n",
      "563  2018-07-02  26364.449219  26609.849609  26060.599609  26493.849609  26493.849609          0.0\n",
      "564  2018-07-09  26642.349609  27164.800781  26611.550781  26935.949219  26935.949219          0.0\n",
      "565  2018-07-16  26914.500000  27187.150391  26643.949219  26873.199219  26873.199219          0.0\n",
      "566  2018-07-23  26701.300781  27661.050781  26671.349609  27634.400391  27634.400391          0.0\n",
      "567  2018-07-30  27767.650391  27873.699219  27327.949219  27695.500000  27695.500000          0.0\n",
      "568  2018-08-06  27769.550781  28377.900391  27766.050781  28124.250000  28124.250000          0.0\n",
      "569  2018-08-13  27760.800781  28178.150391  27739.500000  28128.550781  28128.550781     331100.0\n",
      "570  2018-08-20  28171.650391  28325.449219  27782.800781  27834.699219  27834.699219     310600.0\n",
      "571  2018-08-27  27971.250000  28388.650391  27940.949219  28061.750000  28061.750000          0.0\n",
      "572  2018-09-03  28199.449219  28203.199219  27136.050781  27481.449219  27481.449219     123200.0\n",
      "573  2018-09-10  27395.199219  27404.849609  26555.150391  27163.849609  27163.849609          0.0\n",
      "574  2018-09-17  27002.599609  27002.599609  25053.349609  25596.900391  25596.900391          0.0\n",
      "575  2018-09-24  25645.050781  25649.699219  24678.250000  25119.849609  25119.849609          0.0\n",
      "576  2018-10-01  24943.900391  25470.050781  24250.650391  24443.449219  24443.449219     253300.0\n",
      "577  2018-10-08  24470.750000  25484.199219  24240.050781  25395.849609  25395.849609          0.0\n",
      "578  2018-10-15  25444.000000  25915.349609  24922.650391  25085.800781  25085.800781          0.0\n",
      "579  2018-10-22  25484.250000  25504.750000  24353.099609  24421.050781  24421.050781          0.0\n",
      "580  2018-10-29  24647.949219  25856.250000  24404.550781  25701.650391  25701.650391          0.0\n",
      "581  2018-11-05  25731.550781  25860.750000  25534.400391  25771.000000  25771.000000          0.0\n",
      "582  2018-11-12  25816.150391  26332.750000  25384.550781  26245.550781  26245.550781          0.0\n",
      "583  2018-11-19  26364.599609  26379.099609  25947.849609  25999.449219  25999.449219          0.0\n",
      "584  2018-11-26  26096.000000  27012.699219  26025.050781  26862.949219  26862.949219          0.0\n",
      "585  2018-12-03  27032.900391  27037.099609  26149.449219  26594.300781  26594.300781          0.0\n",
      "586  2018-12-10  26073.650391  26951.449219  25598.949219  26826.000000  26826.000000          0.0\n",
      "587  2018-12-17  26915.449219  27369.099609  26823.099609  26869.650391  26869.650391          0.0\n",
      "588  2018-12-24  26877.050781  27239.949219  26408.150391  27125.250000  27125.250000          0.0\n",
      "589  2018-12-31  27267.800781  27397.550781  26923.750000  27195.000000  27195.000000          0.0\n",
      "590  2019-01-07  27378.650391  27754.449219  27161.949219  27453.900391  27453.900391     146100.0\n",
      "591  2019-01-14  27389.199219  27611.550781  27182.199219  27456.699219  27456.699219          0.0\n",
      "592  2019-01-21  27514.550781  27622.199219  27045.199219  27115.300781  27115.300781          0.0\n",
      "593  2019-01-28  27041.449219  27533.050781  26441.550781  27085.949219  27085.949219     231600.0\n",
      "594  2019-02-04  26974.000000  27589.750000  26825.550781  27294.400391  27294.400391          0.0\n",
      "595  2019-02-11  27240.500000  27305.900391  26635.250000  26794.250000  26794.250000          0.0\n",
      "596  2019-02-18  26754.599609  27100.900391  26617.699219  26867.550781  26867.550781          0.0\n",
      "597  2019-02-25  26934.199219  27197.099609  26719.400391  27043.900391  27043.900391          0.0\n",
      "598  2019-03-04  27068.150391  27815.500000  26958.099609  27761.800781  27761.800781          0.0\n",
      "599  2019-03-11  27840.099609  29520.699219  27791.250000  29381.449219  29381.449219          0.0\n",
      "600  2019-03-18  29521.599609  30008.099609  29361.650391  29582.500000  29582.500000          0.0\n",
      "601  2019-03-25  29329.400391  30499.150391  29156.250000  30426.800781  30426.800781          0.0\n",
      "602  2019-04-01  30537.599609  30648.099609  29809.900391  30084.650391  30084.650391          0.0\n",
      "603  2019-04-08  30201.500000  30232.050781  29640.250000  29938.550781  29938.550781          0.0\n",
      "604  2019-04-15  29983.500000  30669.800781  29919.099609  30223.400391  30223.400391          0.0\n",
      "605  2019-04-22  30282.500000  30289.900391  29435.050781  30013.500000  30013.500000          0.0\n",
      "606  2019-04-29  29920.400391  30121.750000  29550.050781  29954.150391  29954.150391          0.0\n",
      "607  2019-05-06  29626.500000  29835.500000  28784.650391  29040.500000  29040.500000          0.0\n",
      "608  2019-05-13  29026.650391  29559.449219  28525.449219  29450.150391  29450.150391          0.0\n",
      "609  2019-05-20  30230.400391  31705.000000  30111.199219  31212.550781  31212.550781          0.0\n",
      "610  2019-05-27  31234.900391  31783.599609  30623.050781  31375.400391  31375.400391     232000.0\n",
      "611  2019-06-03  31406.050781  31752.699219  30627.050781  31066.550781  31066.550781     274600.0\n",
      "612  2019-06-10  31259.199219  31399.349609  30508.949219  30614.349609  30614.349609          0.0\n",
      "613  2019-06-17  30652.000000  30824.550781  30220.699219  30628.349609  30628.349609          0.0\n",
      "614  2019-06-24  30680.949219  31490.599609  30451.400391  31105.199219  31105.199219          0.0\n",
      "615  2019-07-01  31271.000000  31660.750000  31105.099609  31475.800781  31475.800781  242986000.0\n",
      "616  2019-07-08  31346.849609  31346.849609  30348.849609  30601.449219  30601.449219          0.0\n",
      "617  2019-07-15  30688.849609  30799.300781  29705.900391  29770.349609  29770.349609          0.0\n",
      "618  2019-07-22  29617.050781  29635.150391  28872.300781  29325.300781  29325.300781     339800.0\n",
      "619  2019-07-29  29583.449219  29583.449219  27937.550781  28204.949219  28204.949219     310300.0\n",
      "620  2019-08-05  27841.199219  28602.199219  27389.500000  28431.900391  28431.900391          0.0\n",
      "621  2019-08-12  28431.900391  28431.900391  27683.500000  28217.000000  28217.000000          0.0\n",
      "622  2019-08-19  28331.250000  28468.900391  26560.599609  26958.650391  26958.650391          0.0\n",
      "623  2019-08-26  27663.949219  28277.699219  26859.349609  27427.849609  27427.849609          0.0\n",
      "624  2019-09-02  27239.199219  27311.050781  26641.349609  27247.900391  27247.900391          0.0\n",
      "625  2019-09-09  27240.349609  28126.849609  26993.900391  28098.750000  28098.750000          0.0\n",
      "626  2019-09-16  27868.000000  29418.949219  26643.000000  28981.550781  28981.550781          0.0\n",
      "627  2019-09-23  30039.400391  30801.300781  29470.099609  29876.650391  29876.650391          0.0\n",
      "628  2019-09-30  29674.800781  29754.400391  27653.699219  27731.849609  27731.849609    1187300.0\n",
      "629  2019-10-07  27909.900391  28857.699219  27568.349609  28042.500000  28042.500000          0.0\n",
      "630  2019-10-14  28238.500000  29249.500000  28043.250000  29120.250000  29120.250000          0.0\n",
      "631  2019-10-21  29120.250000  29693.250000  28923.800781  29395.949219  29395.949219          0.0\n",
      "632  2019-10-28  29516.300781  30415.650391  29385.449219  30330.550781  30330.550781          0.0\n",
      "633  2019-11-04  30415.900391  31108.400391  30013.650391  30749.400391  30749.400391     364800.0\n",
      "634  2019-11-11  30664.650391  31205.199219  30338.349609  31008.400391  31008.400391          0.0\n",
      "635  2019-11-18  31036.800781  31471.650391  30901.849609  31111.599609  31111.599609          0.0\n",
      "636  2019-11-25  31065.099609  32157.050781  31049.750000  31946.099609  31946.099609     498300.0\n",
      "637  2019-12-02  32008.300781  32126.949219  31250.650391  31341.550781  31341.550781    1395500.0\n",
      "638  2019-12-09  31321.400391  32105.050781  30996.400391  32014.250000  32014.250000    2735500.0\n",
      "639  2019-12-16  32159.000000  32443.349609  31897.750000  32384.949219  32384.949219    1796800.0\n",
      "640  2019-12-23  32381.000000  32502.800781  31963.250000  32412.349609  32412.349609    1394500.0\n",
      "641  2019-12-30  32486.599609  32613.099609  31960.400391  32069.250000  32069.250000     722600.0\n",
      "642  2020-01-06  31910.449219  32347.199219  30899.550781  32097.400391  32097.400391    1607800.0\n",
      "643  2020-01-13  32139.099609  32322.650391  31445.500000  31590.650391  31590.650391    1837800.0\n",
      "644  2020-01-20  31923.949219  31923.949219  30614.000000  31241.750000  31241.750000    1478700.0\n",
      "645  2020-01-27  31110.550781  31227.050781  30521.300781  30833.599609  30833.599609    1480600.0\n",
      "646  2020-02-03  29811.750000  31470.650391  29612.550781  31201.949219  31201.949219    1689700.0\n",
      "647  2020-02-10  31248.650391  31649.449219  30776.099609  30834.800781  30834.800781    1309000.0\n",
      "648  2020-02-17  30873.849609  31085.300781  30252.449219  30942.849609  30942.849609     940800.0\n",
      "649  2020-02-24  30666.349609  30702.150391  29051.500000  29147.150391  29147.150391    1506000.0\n",
      "650  2020-03-02  29701.000000  29791.150391  27162.300781  27801.449219  27801.449219    3805200.0\n",
      "651  2020-03-09  27031.449219  27091.599609  21351.699219  25166.449219  25166.449219    3326300.0\n",
      "652  2020-03-16  24061.599609  24074.150391  18675.650391  20317.599609  20317.599609    2873300.0\n",
      "653  2020-03-23  18311.300781  21462.400391  16116.250000  19969.000000  19969.000000    2116200.0\n",
      "654  2020-03-30  19254.449219  19716.250000  17143.199219  17249.300781  17249.300781    1254200.0\n",
      "655  2020-04-06  18454.550781  20324.099609  17953.750000  19913.599609  19913.599609    1333800.0\n",
      "656  2020-04-13  19854.900391  20866.550781  18703.449219  20681.449219  20681.449219    1503400.0\n",
      "657  2020-04-20  21104.699219  21122.099609  19051.949219  19586.650391  19586.650391    1731000.0\n",
      "658  2020-04-27  19870.800781  21967.000000  19847.650391  21534.500000  21534.500000    1539800.0\n",
      "659  2020-05-04  20514.750000  20530.449219  18941.000000  19352.900391  19352.900391    1405800.0\n",
      "660  2020-05-11  19610.449219  20122.250000  18287.000000  18833.949219  18833.949219    1832400.0\n",
      "661  2020-05-18  18795.099609  18795.099609  17105.000000  17278.900391  17278.900391    2008900.0\n",
      "662  2020-05-25  17537.650391  19455.550781  17311.250000  19297.250000  19297.250000    2017600.0\n",
      "663  2020-06-01  19728.900391  21619.550781  19632.900391  21034.500000  21034.500000    2848600.0\n",
      "664  2020-06-08  21636.099609  21807.400391  19526.099609  20654.550781  20654.550781    3318600.0\n",
      "665  2020-06-15  20457.150391  21467.650391  19507.050781  21338.099609  21338.099609          0.0\n",
      "666  2020-06-22  21491.550781  22479.550781  20926.449219  21592.050781  21592.050781    2838900.0\n",
      "667  2020-06-29  21291.550781  22344.849609  21026.449219  21852.400391  21852.400391    1661900.0\n",
      "668  2020-07-06  22270.949219  23080.599609  22040.349609  22398.449219  22398.449219    2232900.0\n",
      "669  2020-07-13  22613.250000  22657.400391  21027.849609  21966.800781  21966.800781    1634800.0\n",
      "670  2020-07-20  22307.300781  23211.349609  22187.800781  22662.050781  22662.050781    1823000.0\n",
      "671  2020-07-27  22664.599609  22668.050781  21375.000000  21640.050781  21640.050781    1818000.0\n",
      "672  2020-08-03  21543.800781  21936.500000  21031.449219  21754.000000  21754.000000    1535000.0\n",
      "673  2020-08-10  21824.900391  22439.949219  21459.099609  21679.400391  21679.400391    1755100.0\n",
      "674  2020-08-17  21906.949219  22419.349609  21403.150391  22299.599609  22299.599609     263400.0\n",
      "675  2020-08-24  22436.849609  24611.800781  22410.050781  24523.800781  24523.800781          0.0\n",
      "676  2020-08-31  25038.800781  25232.599609  22876.900391  23011.500000  23011.500000          0.0\n",
      "677  2020-09-07  23036.250000  23109.099609  22080.400391  22479.949219  22479.949219     245300.0\n",
      "678  2020-09-14  22683.349609  22757.300781  21784.900391  22031.050781  22031.050781          0.0\n",
      "679  2020-09-21  21983.400391  22098.849609  20404.900391  20982.349609  20982.349609          0.0\n",
      "680  2020-09-28  21152.050781  22293.750000  21055.099609  22246.000000  22246.000000          0.0\n",
      "681  2020-10-05  22352.099609  23904.099609  22247.250000  23846.800781  23846.800781          0.0\n",
      "682  2020-10-12  23955.599609  24190.349609  22970.949219  23533.250000  23533.250000          0.0\n",
      "683  2020-10-19  23902.900391  24823.599609  23754.849609  24478.300781  24478.300781          0.0\n",
      "684  2020-10-26  24525.800781  24809.650391  23612.699219  23900.900391  23900.900391          0.0\n",
      "685  2020-11-02  24367.599609  26853.449219  24120.599609  26798.949219  26798.949219          0.0\n",
      "686  2020-11-09  27088.949219  29030.900391  27068.949219  28465.699219  28465.699219          0.0\n",
      "687  2020-11-16  28792.250000  29784.750000  28580.900391  29236.000000  29236.000000          0.0\n",
      "688  2020-11-23  29432.800781  30197.849609  28852.900391  29609.050781  29609.050781     369400.0\n",
      "689  2020-11-30  29844.800781  30162.300781  29149.900391  30052.400391  30052.400391          0.0\n",
      "690  2020-12-07  30062.599609  30811.800781  29950.599609  30604.849609  30604.849609          0.0\n",
      "691  2020-12-14  30735.150391  30945.199219  30345.750000  30714.650391  30714.650391     548400.0\n",
      "692  2020-12-21  30595.800781  30607.500000  28976.750000  30402.199219  30402.199219          0.0\n",
      "693  2020-12-28  30558.849609  31510.250000  30538.150391  31264.050781  31264.050781          0.0\n",
      "694  2021-01-04  31485.150391  32298.050781  30893.650391  32084.199219  32084.199219          0.0\n",
      "695  2021-01-11  32280.300781  32718.949219  31725.849609  32246.800781  32246.800781          0.0\n",
      "696  2021-01-18  32275.150391  32842.300781  31119.900391  31167.250000  31167.250000     751600.0\n",
      "697  2021-01-25  31507.150391  31697.550781  29687.699219  30565.500000  30565.500000          0.0\n",
      "698  2021-02-01  30976.349609  36615.199219  30906.449219  35654.500000  35654.500000    1277400.0\n",
      "699  2021-02-08  36073.851563  36477.148438  35428.148438  36108.898438  36108.898438          0.0\n",
      "700  2021-02-15  36501.398438  37708.750000  35584.601563  35841.601563  35841.601563          0.0\n",
      "701  2021-02-22  35874.300781  37232.199219  34658.699219  34803.601563  34803.601563     728800.0\n",
      "702  2021-03-01  35374.250000  36455.148438  34893.250000  35228.148438  35228.148438          0.0\n",
      "703  2021-03-08  35462.449219  36497.351563  35090.750000  35496.648438  35496.648438          0.0\n",
      "704  2021-03-15  35544.250000  35544.250000  33361.000000  34161.601563  34161.601563          0.0\n",
      "705  2021-03-22  34088.398438  34360.050781  32415.250000  33318.199219  33318.199219          0.0\n",
      "706  2021-03-29  33615.898438  33990.800781  33151.800781  33858.000000  33858.000000     374200.0\n",
      "707  2021-04-05  33649.148438  33697.750000  32141.550781  32448.050781  32448.050781          0.0\n",
      "708  2021-04-12  31637.900391  32325.150391  30520.300781  31977.449219  31977.449219          0.0\n",
      "709  2021-04-19  30993.449219  32148.400391  30405.650391  31722.300781  31722.300781     368400.0\n",
      "710  2021-04-26  32316.650391  34287.000000  32144.800781  32781.800781  32781.800781          0.0\n",
      "711  2021-05-03  32368.550781  33259.148438  31906.550781  32904.500000  32904.500000    1137800.0\n",
      "712  2021-05-10  33175.300781  33297.601563  32115.500000  32169.550781  32169.550781          0.0\n",
      "713  2021-05-17  32437.849609  34694.449219  32318.699219  34606.898438  34606.898438          0.0\n",
      "714  2021-05-24  34869.300781  35436.648438  34410.398438  35141.449219  35141.449219          0.0\n",
      "715  2021-05-31  35097.449219  35810.898438  34930.101563  35291.648438  35291.648438          0.0\n",
      "716  2021-06-07  35460.800781  35545.851563  34641.199219  35047.398438  35047.398438          0.0\n",
      "717  2021-06-14  34936.550781  35380.000000  33908.949219  34558.000000  34558.000000          0.0\n",
      "718  2021-06-21  34109.449219  35491.949219  33937.500000  35364.648438  35364.648438          0.0\n",
      "719  2021-06-28  35488.199219  35576.949219  34632.601563  34809.898438  34809.898438     329600.0\n",
      "720  2021-07-05  35010.949219  35811.000000  34859.898438  35071.949219  35071.949219          0.0\n",
      "721  2021-07-12  35285.050781  35985.250000  35060.351563  35751.800781  35751.800781          0.0\n",
      "722  2021-07-19  35070.500000  35347.050781  34357.351563  35034.398438  35034.398438          0.0\n",
      "723  2021-07-26  34947.851563  35186.101563  34115.199219  34584.351563  34584.351563          0.0\n",
      "724  2021-08-02  34760.898438  36219.800781  34588.250000  35809.250000  35809.250000          0.0\n",
      "725  2021-08-09  35824.199219  36317.000000  35531.351563  36169.351563  36169.351563     649500.0\n",
      "726  2021-08-16  36100.648438  36261.550781  34926.500000  35033.851563  35033.851563     527300.0\n",
      "727  2021-08-23  35424.199219  35910.300781  34817.500000  35627.800781  35627.800781     749400.0\n",
      "728  2021-08-30  35781.050781  37140.000000  35721.898438  36761.148438  36761.148438     816700.0\n",
      "729  2021-09-06  36878.250000  36923.648438  36151.949219  36683.199219  36683.199219     472500.0\n",
      "730  2021-09-13  36608.449219  38112.750000  36327.050781  37811.949219  37811.949219    1127600.0\n",
      "731  2021-09-20  37388.199219  38112.601563  36525.949219  37830.300781  37830.300781     689900.0\n",
      "732  2021-09-27  38054.750000  38377.250000  36876.351563  37225.898438  37225.898438     998800.0\n",
      "733  2021-10-04  37392.148438  38106.851563  37355.601563  37775.250000  37775.250000     808300.0\n",
      "734  2021-10-11  37782.750000  39375.050781  37744.648438  39340.898438  39340.898438     792900.0\n",
      "735  2021-10-18  39794.250000  40587.351563  39292.800781  40323.648438  40323.648438    1733600.0\n",
      "736  2021-10-25  40961.250000  41829.601563  38426.648438  39115.601563  39115.601563    2090700.0\n",
      "737  2021-11-01  39432.148438  40160.199219  39120.648438  39573.699219  39573.699219     774500.0\n",
      "738  2021-11-08  39674.050781  39674.050781  38346.050781  38733.351563  38733.351563     866300.0\n",
      "739  2021-11-15  38849.449219  39117.148438  37748.449219  37976.250000  37976.250000     619400.0\n",
      "740  2021-11-22  38232.148438  38241.000000  35904.101563  36025.500000  36025.500000     908000.0\n",
      "741  2021-11-29  36224.449219  36844.000000  35327.898438  36197.148438  36197.148438     859000.0\n",
      "742  2021-12-06  36252.750000  37397.550781  35696.750000  37105.648438  37105.648438     741800.0\n",
      "743  2021-12-13  37358.199219  37581.050781  35535.050781  35618.648438  35618.648438     660100.0\n",
      "744  2021-12-20  35124.351563  35477.300781  34018.449219  34857.050781  34857.050781     735000.0\n",
      "745  2021-12-27  34573.648438  35596.949219  34233.000000  35481.699219  35481.699219    1177500.0\n",
      "746  2022-01-03  35585.199219  38134.851563  35526.601563  37739.601563  37739.601563    1029200.0\n",
      "747  2022-01-10  37930.550781  38851.449219  37929.351563  38370.398438  38370.398438     829900.0\n",
      "748  2022-01-17  38212.550781  38855.550781  37224.250000  37574.300781  37574.300781     781800.0\n",
      "749  2022-01-24  37601.949219  38421.699219  36375.351563  37689.398438  37689.398438    1139100.0\n",
      "750  2022-01-31  38091.800781  39424.851563  37647.851563  38789.351563  38789.351563    1061400.0\n",
      "751  2022-02-07  38592.050781  39197.199219  37319.050781  38517.250000  38517.250000     869800.0\n",
      "752  2022-02-14  37664.000000  38461.699219  36651.851563  37599.148438  37599.148438     826700.0\n",
      "753  2022-02-21  37400.000000  38054.398438  36818.101563  37392.050781  37392.050781     440000.0\n"
     ]
    }
   ],
   "source": [
    "# data cleaning where there is empty cells\n",
    "new_df = df.dropna()\n",
    "\n",
    "print(new_df.to_string())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "9d8cfd7d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2007-09-17</td>\n",
       "      <td>6898.000000</td>\n",
       "      <td>7506.350098</td>\n",
       "      <td>6843.000000</td>\n",
       "      <td>7464.500000</td>\n",
       "      <td>7464.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2007-09-24</td>\n",
       "      <td>7514.399902</td>\n",
       "      <td>8082.850098</td>\n",
       "      <td>7490.200195</td>\n",
       "      <td>8042.200195</td>\n",
       "      <td>8042.200195</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2007-10-01</td>\n",
       "      <td>8008.549805</td>\n",
       "      <td>8235.799805</td>\n",
       "      <td>7789.700195</td>\n",
       "      <td>7845.250000</td>\n",
       "      <td>7845.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2007-10-08</td>\n",
       "      <td>7853.149902</td>\n",
       "      <td>8177.750000</td>\n",
       "      <td>7516.450195</td>\n",
       "      <td>7934.000000</td>\n",
       "      <td>7934.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2007-10-15</td>\n",
       "      <td>7962.549805</td>\n",
       "      <td>8491.650391</td>\n",
       "      <td>7279.299805</td>\n",
       "      <td>7423.799805</td>\n",
       "      <td>7423.799805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>2022-01-24</td>\n",
       "      <td>37601.949219</td>\n",
       "      <td>38421.699219</td>\n",
       "      <td>36375.351563</td>\n",
       "      <td>37689.398438</td>\n",
       "      <td>37689.398438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>2022-01-31</td>\n",
       "      <td>38091.800781</td>\n",
       "      <td>39424.851563</td>\n",
       "      <td>37647.851563</td>\n",
       "      <td>38789.351563</td>\n",
       "      <td>38789.351563</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>2022-02-07</td>\n",
       "      <td>38592.050781</td>\n",
       "      <td>39197.199219</td>\n",
       "      <td>37319.050781</td>\n",
       "      <td>38517.250000</td>\n",
       "      <td>38517.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>2022-02-14</td>\n",
       "      <td>37664.000000</td>\n",
       "      <td>38461.699219</td>\n",
       "      <td>36651.851563</td>\n",
       "      <td>37599.148438</td>\n",
       "      <td>37599.148438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>2022-02-21</td>\n",
       "      <td>37400.000000</td>\n",
       "      <td>38054.398438</td>\n",
       "      <td>36818.101563</td>\n",
       "      <td>37392.050781</td>\n",
       "      <td>37392.050781</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>708 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date          Open          High           Low         Close  \\\n",
       "0    2007-09-17   6898.000000   7506.350098   6843.000000   7464.500000   \n",
       "1    2007-09-24   7514.399902   8082.850098   7490.200195   8042.200195   \n",
       "2    2007-10-01   8008.549805   8235.799805   7789.700195   7845.250000   \n",
       "3    2007-10-08   7853.149902   8177.750000   7516.450195   7934.000000   \n",
       "4    2007-10-15   7962.549805   8491.650391   7279.299805   7423.799805   \n",
       "..          ...           ...           ...           ...           ...   \n",
       "749  2022-01-24  37601.949219  38421.699219  36375.351563  37689.398438   \n",
       "750  2022-01-31  38091.800781  39424.851563  37647.851563  38789.351563   \n",
       "751  2022-02-07  38592.050781  39197.199219  37319.050781  38517.250000   \n",
       "752  2022-02-14  37664.000000  38461.699219  36651.851563  37599.148438   \n",
       "753  2022-02-21  37400.000000  38054.398438  36818.101563  37392.050781   \n",
       "\n",
       "        Adj Close  \n",
       "0     7464.500000  \n",
       "1     8042.200195  \n",
       "2     7845.250000  \n",
       "3     7934.000000  \n",
       "4     7423.799805  \n",
       "..            ...  \n",
       "749  37689.398438  \n",
       "750  38789.351563  \n",
       "751  38517.250000  \n",
       "752  37599.148438  \n",
       "753  37392.050781  \n",
       "\n",
       "[708 rows x 6 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# removing Volume as they are of no use\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "556f6804",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/ry/ykvz3lv17l597c7k3kphsk0m0000gn/T/ipykernel_937/441724143.py:2: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  new_df['Change']=new_df['Close'] - new_df['Open']\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: right;\">\n",
       "      <th></th>\n",
       "      <th>Date</th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2007-09-17</td>\n",
       "      <td>6898.000000</td>\n",
       "      <td>7506.350098</td>\n",
       "      <td>6843.000000</td>\n",
       "      <td>7464.500000</td>\n",
       "      <td>7464.500000</td>\n",
       "      <td>566.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2007-09-24</td>\n",
       "      <td>7514.399902</td>\n",
       "      <td>8082.850098</td>\n",
       "      <td>7490.200195</td>\n",
       "      <td>8042.200195</td>\n",
       "      <td>8042.200195</td>\n",
       "      <td>527.800293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2007-10-01</td>\n",
       "      <td>8008.549805</td>\n",
       "      <td>8235.799805</td>\n",
       "      <td>7789.700195</td>\n",
       "      <td>7845.250000</td>\n",
       "      <td>7845.250000</td>\n",
       "      <td>-163.299805</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2007-10-08</td>\n",
       "      <td>7853.149902</td>\n",
       "      <td>8177.750000</td>\n",
       "      <td>7516.450195</td>\n",
       "      <td>7934.000000</td>\n",
       "      <td>7934.000000</td>\n",
       "      <td>80.850098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2007-10-15</td>\n",
       "      <td>7962.549805</td>\n",
       "      <td>8491.650391</td>\n",
       "      <td>7279.299805</td>\n",
       "      <td>7423.799805</td>\n",
       "      <td>7423.799805</td>\n",
       "      <td>-538.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>749</th>\n",
       "      <td>2022-01-24</td>\n",
       "      <td>37601.949219</td>\n",
       "      <td>38421.699219</td>\n",
       "      <td>36375.351563</td>\n",
       "      <td>37689.398438</td>\n",
       "      <td>37689.398438</td>\n",
       "      <td>87.449219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>750</th>\n",
       "      <td>2022-01-31</td>\n",
       "      <td>38091.800781</td>\n",
       "      <td>39424.851563</td>\n",
       "      <td>37647.851563</td>\n",
       "      <td>38789.351563</td>\n",
       "      <td>38789.351563</td>\n",
       "      <td>697.550782</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>2022-02-07</td>\n",
       "      <td>38592.050781</td>\n",
       "      <td>39197.199219</td>\n",
       "      <td>37319.050781</td>\n",
       "      <td>38517.250000</td>\n",
       "      <td>38517.250000</td>\n",
       "      <td>-74.800781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>752</th>\n",
       "      <td>2022-02-14</td>\n",
       "      <td>37664.000000</td>\n",
       "      <td>38461.699219</td>\n",
       "      <td>36651.851563</td>\n",
       "      <td>37599.148438</td>\n",
       "      <td>37599.148438</td>\n",
       "      <td>-64.851562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>753</th>\n",
       "      <td>2022-02-21</td>\n",
       "      <td>37400.000000</td>\n",
       "      <td>38054.398438</td>\n",
       "      <td>36818.101563</td>\n",
       "      <td>37392.050781</td>\n",
       "      <td>37392.050781</td>\n",
       "      <td>-7.949219</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>708 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           Date          Open          High           Low         Close  \\\n",
       "0    2007-09-17   6898.000000   7506.350098   6843.000000   7464.500000   \n",
       "1    2007-09-24   7514.399902   8082.850098   7490.200195   8042.200195   \n",
       "2    2007-10-01   8008.549805   8235.799805   7789.700195   7845.250000   \n",
       "3    2007-10-08   7853.149902   8177.750000   7516.450195   7934.000000   \n",
       "4    2007-10-15   7962.549805   8491.650391   7279.299805   7423.799805   \n",
       "..          ...           ...           ...           ...           ...   \n",
       "749  2022-01-24  37601.949219  38421.699219  36375.351563  37689.398438   \n",
       "750  2022-01-31  38091.800781  39424.851563  37647.851563  38789.351563   \n",
       "751  2022-02-07  38592.050781  39197.199219  37319.050781  38517.250000   \n",
       "752  2022-02-14  37664.000000  38461.699219  36651.851563  37599.148438   \n",
       "753  2022-02-21  37400.000000  38054.398438  36818.101563  37392.050781   \n",
       "\n",
       "        Adj Close      Change  \n",
       "0     7464.500000  566.500000  \n",
       "1     8042.200195  527.800293  \n",
       "2     7845.250000 -163.299805  \n",
       "3     7934.000000   80.850098  \n",
       "4     7423.799805 -538.750000  \n",
       "..            ...         ...  \n",
       "749  37689.398438   87.449219  \n",
       "750  38789.351563  697.550782  \n",
       "751  38517.250000  -74.800781  \n",
       "752  37599.148438  -64.851562  \n",
       "753  37392.050781   -7.949219  \n",
       "\n",
       "[708 rows x 7 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Adding a new column of change in price\n",
    "new_df['Change']=new_df['Close'] - new_df['Open']\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "a8128cac",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/ry/ykvz3lv17l597c7k3kphsk0m0000gn/T/ipykernel_937/4142923928.py:2: FutureWarning: Dropping of nuisance columns in DataFrame reductions (with 'numeric_only=None') is deprecated; in a future version this will raise TypeError.  Select only valid columns before calling the reduction.\n",
      "  new_df.std()\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "Open         9353.045632\n",
       "High         9487.082060\n",
       "Low          9211.153893\n",
       "Close        9361.795689\n",
       "Adj Close    9361.795689\n",
       "Change        613.264993\n",
       "dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculating Weekly standard deviation \n",
    "new_df.std()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "ee4880c5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Adj Close</th>\n",
       "      <th>Change</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Open</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998978</td>\n",
       "      <td>0.998644</td>\n",
       "      <td>0.997853</td>\n",
       "      <td>0.997853</td>\n",
       "      <td>-0.018510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>High</th>\n",
       "      <td>0.998978</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998364</td>\n",
       "      <td>0.999132</td>\n",
       "      <td>0.999132</td>\n",
       "      <td>0.016606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Low</th>\n",
       "      <td>0.998644</td>\n",
       "      <td>0.998364</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.998900</td>\n",
       "      <td>0.998900</td>\n",
       "      <td>0.018155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Close</th>\n",
       "      <td>0.997853</td>\n",
       "      <td>0.999132</td>\n",
       "      <td>0.998900</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.047015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Adj Close</th>\n",
       "      <td>0.997853</td>\n",
       "      <td>0.999132</td>\n",
       "      <td>0.998900</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.047015</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Change</th>\n",
       "      <td>-0.018510</td>\n",
       "      <td>0.016606</td>\n",
       "      <td>0.018155</td>\n",
       "      <td>0.047015</td>\n",
       "      <td>0.047015</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Open      High       Low     Close  Adj Close    Change\n",
       "Open       1.000000  0.998978  0.998644  0.997853   0.997853 -0.018510\n",
       "High       0.998978  1.000000  0.998364  0.999132   0.999132  0.016606\n",
       "Low        0.998644  0.998364  1.000000  0.998900   0.998900  0.018155\n",
       "Close      0.997853  0.999132  0.998900  1.000000   1.000000  0.047015\n",
       "Adj Close  0.997853  0.999132  0.998900  1.000000   1.000000  0.047015\n",
       "Change    -0.018510  0.016606  0.018155  0.047015   0.047015  1.000000"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lets find some correlation\n",
    "new_df.corr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9c3b2d3a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Main trading strategy\n",
    "# Finally adopting 68-95-99 rule to increase odds \n",
    "# We will sell option in 2 std deviation away(approx 1300 points away from current strike price)\n",
    "# and buy next strike price for hedge \n",
    "# Safe playing traders can choose to 3 std away "
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}