StockParseVolume_DEBUG.ipynb

{
 "metadata": {
  "name": "StockParseVolume_DEBUG"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "def only_alphanum(s):\n",
      "    #s = unicode(s, \"utf-8\")\n",
      "    return ' '.join(c for c in s.split() if c.isalnum())\n",
      "def only_alpha(s):\n",
      "    return ' '.join(c for c in s.split() if c.isalpha())\n",
      "def removeNonAscii(s): return \"\".join(i for i in s if ord(i)<128)\n",
      "\n",
      "\n",
      "import pandas as pd\n",
      "from datetime import datetime\n",
      "from pandas.io.data import DataReader\n",
      "ticker = 'DV'\n",
      "sp500 = DataReader(\"SPY\", \"yahoo\", datetime(2010, 1, 1))\n",
      "aapl = DataReader(ticker, \"yahoo\", datetime(2010, 1, 1))\n",
      "sp500['UP'] = 0\n",
      "sp500['DOWN'] = 0\n",
      "sp500['NONE'] = 0\n",
      "\n",
      "# returns = aapl.pct_change()\n",
      "\n",
      "#  def f(x):\n",
      "#      if x \n",
      "#  def f(x):\n",
      "#      if x > 0.05:\n",
      "#          return 1\n",
      "#      elif x < -0.05:\n",
      "#          return -1\n",
      "#      else:\n",
      "#          return 0\n",
      "\n",
      "\n",
      "# frame = returns.applymap(f)\n",
      "frame=aapl\n",
      "frame['MA20_Volume']= pd.rolling_mean(frame['Volume'], 20)\n",
      "# frame['UP'] = frame['Volume'] == 1\n",
      "# frame['DOWN'] = frame['Volume'] == -1\n",
      "# frame['NONE'] = frame['Volume'] == 0\n",
      "\n",
      "#frame['UP'] = frame['Volume'] > (1.05 * frame['MA20_Volume'])\n",
      "#frame['DOWN'] = frame['Volume'] < (.95 * frame['MA20_Volume'])\n",
      "#frame['NONE'] = (frame['Volume'] > (.95 * frame['MA20_Volume']) and frame['Volume'] < (1.05*frame['MA20_Volume']))\n",
      "#frame['NONE'] = frame['UP']== False & frame['DOWN']==False\n",
      "#frame['UP'] = frame['MA20_Volume'] == 1\n",
      "#frame['DOWN'] = fram['MA20_Volume'] == -1\n",
      "#frame['NONE'] = frame['MA20_Volume'] == 0\n",
      "\n",
      "frame['UP'] = frame['Volume'] > (frame['MA20_Volume'] *1.10)\n",
      "frame['DOWN'] = frame['Volume'] < (frame['MA20_Volume'] * 0.90)\n",
      "frame['NONE'] = (frame.UP==False) & (frame.DOWN==False)\n",
      "sp500['UP'] += frame['UP'].dropna()==True\n",
      "sp500['DOWN'] += frame['DOWN'].dropna()==True\n",
      "sp500['NONE'] += frame['NONE'].dropna()==True\n",
      "\n",
      "from lxml import etree\n",
      "import datetime\n",
      "from dateutil.parser import parse\n",
      "path = \"http://www.google.com/finance/company_news?q=%s&output=rss&num=500\"% ticker\n",
      "root = etree.parse(path)\n",
      "myRoot = root.getroot()\n",
      "news={}\n",
      "for element in myRoot.iter(\"item\"):\n",
      "    for item in element.iter(\"pubDate\"):\n",
      "        pubDate = parse(item.text)\n",
      "    for item in element.iter(\"title\"):\n",
      "        title = item.text\n",
      "    news[pubDate.date()]=only_alphanum(removeNonAscii(title))\n",
      "\n",
      "newsframe = pd.Series(news)\n",
      "frameWithNews = frame.join(pd.DataFrame(newsframe))\n",
      "#newsUP = frameWithNews['UP'==True]\n",
      "#newsDOWN = frameWithNews['DOWN'==True]\n",
      "#newsNONE = frameWithNews['NONE' == True]\n",
      "newsUP_frame = frameWithNews[frameWithNews['UP']==True]\n",
      "newsDOWN_frame = frameWithNews[frameWithNews['DOWN']==True]\n",
      "newsNONE_frame = frameWithNews[frameWithNews['NONE']==True]\n",
      "\n",
      "newsUP = newsUP_frame[0]\n",
      "newsDOWN = newsDOWN_frame[0]\n",
      "newsNONE = newsNONE_frame[0]\n",
      "\n",
      "import pandas.io as io\n",
      "\n",
      "if newsUP.dropna().count() > 1:\n",
      "    newsUP.dropna().to_csv('%s_news_UP.csv'% ticker)\n",
      "if newsDOWN.dropna().count() > 1:\n",
      "    newsDOWN.dropna().to_csv('%s_news_DOWN.csv'% ticker)\n",
      "if newsNONE.dropna().count() >1:\n",
      "    newsNONE.dropna().to_csv('%s_news_NONE.csv' % ticker)\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 30
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "pd.set_printoptions(max_rows=2000)\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 17
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "print frame"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "output_type": "stream",
       "stream": "stdout",
       "text": [
        "             Open   High    Low  Close    Volume  Adj Close  MA20_Volume     UP   DOWN   NONE\n",
        "Date                                                                                         \n",
        "2010-01-04  56.86  57.03  56.03  56.21    491900      55.29          NaN  False  False   True\n",
        "2010-01-05  56.20  56.45  54.52  55.63   1077700      54.72          NaN  False  False   True\n",
        "2010-01-06  55.52  56.88  55.36  56.44    624300      55.51          NaN  False  False   True\n",
        "2010-01-07  56.64  57.60  56.20  57.23    649200      56.29          NaN  False  False   True\n",
        "2010-01-08  56.61  56.61  55.70  56.27    806400      55.35          NaN  False  False   True\n",
        "2010-01-11  56.54  57.13  55.62  56.40    539500      55.48          NaN  False  False   True\n",
        "2010-01-12  56.42  56.42  55.77  56.11    256400      55.19          NaN  False  False   True\n",
        "2010-01-13  56.26  56.75  55.82  56.64    391600      55.71          NaN  False  False   True\n",
        "2010-01-14  56.64  57.41  56.27  57.28    532200      56.34          NaN  False  False   True\n",
        "2010-01-15  57.33  57.58  56.77  56.81    651500      55.88          NaN  False  False   True\n",
        "2010-01-19  56.29  56.75  56.18  56.42    496300      55.50          NaN  False  False   True\n",
        "2010-01-20  56.15  56.38  55.68  56.19    499200      55.27          NaN  False  False   True\n",
        "2010-01-21  57.24  57.82  55.84  56.46    950300      55.53          NaN  False  False   True\n",
        "2010-01-22  56.28  57.06  56.13  56.88    883300      55.95          NaN  False  False   True\n",
        "2010-01-25  56.94  57.00  56.00  56.33    658500      55.41          NaN  False  False   True\n",
        "2010-01-26  56.10  56.45  55.75  56.17    792000      55.25          NaN  False  False   True\n",
        "2010-01-27  60.00  63.67  58.21  63.32   4710300      62.28          NaN  False  False   True\n",
        "2010-01-28  62.94  62.94  61.70  62.20   1462600      61.18          NaN  False  False   True\n",
        "2010-01-29  62.20  62.34  60.03  61.06   2259600      60.06          NaN  False  False   True\n",
        "2010-02-01  61.05  61.05  59.92  60.77    907100      59.77       981995  False  False   True\n",
        "2010-02-02  60.94  62.56  60.10  62.43    994400      61.41      1007120  False  False   True\n",
        "2010-02-03  62.11  63.80  62.11  62.62    958300      61.59      1001150  False  False   True\n",
        "2010-02-04  62.42  62.52  61.10  61.88    996800      60.87      1019775  False  False   True\n",
        "2010-02-05  61.80  62.57  61.58  62.19   1510900      61.17      1062860   True  False  False\n",
        "2010-02-08  62.30  62.46  59.87  59.96   1369600      58.98      1091020   True  False  False\n",
        "2010-02-09  60.11  60.35  57.86  58.88   2272200      57.91      1177655   True  False  False\n",
        "2010-02-10  59.07  59.97  58.98  59.85   1032400      58.87      1216455  False   True  False\n",
        "2010-02-11  59.73  60.79  58.95  60.32    914100      59.33      1242580  False   True  False\n",
        "2010-02-12  60.18  60.47  59.79  59.94   1059400      58.96      1268940  False   True  False\n",
        "2010-02-16  60.22  60.46  59.75  60.44   1084700      59.45      1290600  False   True  False\n",
        "2010-02-17  60.63  61.19  60.43  61.07    668700      60.07      1299220  False   True  False\n",
        "2010-02-18  61.15  61.99  60.76  61.25    994600      60.25      1323990  False   True  False\n",
        "2010-02-19  60.33  61.37  59.73  60.78   1055400      59.78      1329245  False   True  False\n",
        "2010-02-22  60.91  61.32  60.67  60.97    387600      59.97      1304460  False   True  False\n",
        "2010-02-23  61.04  61.63  60.93  61.27    547000      60.27      1298885  False   True  False\n",
        "2010-02-24  61.45  62.64  61.30  62.57    872900      61.54      1302930  False   True  False\n",
        "2010-02-25  62.07  63.81  61.97  63.40   1288900      62.36      1131860   True  False  False\n",
        "2010-02-26  63.28  63.54  62.96  63.15    757900      62.11      1096625  False   True  False\n",
        "2010-03-01  63.08  63.51  62.63  63.17    797900      62.13      1023540  False   True  False\n",
        "2010-03-02  63.20  63.51  62.68  63.45    692500      62.41      1012810  False   True  False\n",
        "2010-03-03  63.53  64.74  63.33  64.25   1178700      63.20      1022025   True  False  False\n",
        "2010-03-04  64.56  65.37  64.40  65.26    696400      64.19      1008930  False   True  False\n",
        "2010-03-05  65.27  66.88  65.22  66.79    811700      65.70       999675  False   True  False\n",
        "2010-03-08  66.09  66.76  65.26  65.93    634600      64.85       955860  False   True  False\n",
        "2010-03-09  65.79  66.34  65.48  65.78    508300      64.70       912795  False   True  False\n",
        "2010-03-10  65.91  65.91  65.20  65.80    512600      64.72       824815  False   True  False\n",
        "2010-03-11  65.81  66.83  65.64  66.76    609300      65.67       803660  False   True  False\n",
        "2010-03-12  66.69  66.69  65.71  66.43    545200      65.34       785215  False   True  False\n",
        "2010-03-15  66.52  66.52  65.51  66.09    711400      65.01       767815  False  False   True\n",
        "2010-03-16  66.31  67.28  65.69  67.03    618900      65.93       744525  False   True  False\n",
        "2010-03-17  67.30  67.46  66.58  67.00    414300      65.90       731805  False   True  False\n",
        "2010-03-18  67.12  67.58  67.09  67.26    323100      66.16       698230  False   True  False\n",
        "2010-03-19  67.72  68.42  66.78  67.28    592000      66.18       675060  False   True  False\n",
        "2010-03-22  67.01  67.51  66.61  67.26    381400      66.16       674750  False   True  False\n",
        "2010-03-23  67.17  67.63  66.97  67.59    313800      66.48       663090  False   True  False\n",
        "2010-03-24  67.56  67.56  65.84  66.16    841600      65.08       661525   True  False  False\n",
        "2010-03-25  66.21  66.68  65.93  66.43    508300      65.34       622495  False   True  False\n",
        "2010-03-26  66.63  66.82  65.81  66.26    495300      65.17       609365  False   True  False\n",
        "2010-03-29  66.66  66.91  65.36  66.12    598800      65.04       599410  False  False   True\n",
        "2010-03-30  65.92  66.18  65.10  66.05    765600      64.97       603065   True  False  False\n",
        "2010-03-31  65.78  65.94  64.65  65.20    737100      64.13       580985   True  False  False\n",
        "2010-04-01  65.26  65.55  64.40  64.79    484900      63.73       570410  False   True  False\n",
        "2010-04-05  64.93  65.19  64.61  64.80    597000      63.74       559675  False  False   True\n",
        "2010-04-06  64.74  65.55  64.42  65.12    501800      64.05       553035  False  False   True\n",
        "2010-04-07  64.75  65.53  64.60  65.07    575000      64.00       556370  False  False   True\n",
        "2010-04-08  64.91  65.16  64.50  64.58    579800      63.52       559730  False  False   True\n",
        "2010-04-09  64.74  65.24  64.11  64.86    495600      63.80       554045  False   True  False\n",
        "2010-04-12  64.91  65.25  64.90  65.06    709500      63.99       562260   True  False  False\n",
        "2010-04-13  67.91  72.26  67.55  71.73   3208300      70.55       687105   True  False  False\n",
        "2010-04-14  71.69  71.69  70.00  70.44   1378900      69.29       725105   True  False  False\n",
        "2010-04-15  70.39  70.91  70.09  70.65    659500      69.49       737365  False   True  False\n",
        "2010-04-16  70.70  71.20  70.18  70.86   1424700      69.70       792445   True  False  False\n",
        "2010-04-19  71.03  72.37  70.55  72.10   1266200      70.92       826155   True  False  False\n",
        "2010-04-20  72.32  72.72  71.05  71.87    975600      70.69       855865   True  False  False\n",
        "2010-04-21  72.11  73.23  71.46  72.83   1309700      71.64       905660   True  False  False\n",
        "2010-04-22  72.94  74.36  72.34  74.25   1601000      73.03       943630   True  False  False\n",
        "2010-04-23  70.01  72.46  68.20  69.46   3035300      68.32      1069980   True  False  False\n",
        "2010-04-26  67.70  67.70  64.00  65.45   3760300      64.38      1233230   True  False  False\n",
        "2010-04-27  65.45  67.50  65.06  66.68   1620600      65.59      1284320   True  False  False\n",
        "2010-04-28  66.82  67.17  65.82  66.70   1150400      65.61      1303560  False   True  False\n",
        "2010-04-29  66.38  66.38  61.53  63.51   3169200      62.47      1425165   True  False  False\n",
        "2010-04-30  63.61  64.60  62.36  62.39   1299900      61.37      1465915  False   True  False\n",
        "2010-05-03  62.60  62.89  61.38  62.85   1088300      61.82      1490480  False   True  False\n",
        "2010-05-04  62.04  62.11  60.41  61.35    855300      60.34      1508155  False   True  False\n",
        "2010-05-05  61.28  62.82  61.18  61.65   1319300      60.64      1545370  False   True  False\n",
        "2010-05-06  61.66  62.35  58.33  60.03   1525000      59.05      1592630  False  False   True\n",
        "2010-05-07  59.77  60.85  58.88  59.57   2065700      58.59      1671135   True  False  False\n",
        "2010-05-10  61.70  61.70  60.41  61.49   1007100      60.48      1686015  False   True  False\n",
        "2010-05-11  61.34  61.60  60.46  60.61   1587600      59.62      1604980  False  False   True\n",
        "2010-05-12  60.76  61.34  60.10  60.90   2740400      59.90      1673055   True  False  False\n",
        "2010-05-13  60.75  61.56  60.28  60.31    789200      59.32      1679540  False   True  False\n",
        "2010-05-14  60.32  60.32  58.67  59.16    645900      58.19      1640600  False   True  False\n",
        "2010-05-17  59.17  62.96  57.84  62.03   2256000      61.01      1690090   True  False  False\n",
        "2010-05-18  63.13  63.96  61.39  61.92   3504700      60.91      1816545   True  False  False\n",
        "2010-05-19  61.96  62.95  61.55  62.46   1538600      61.44      1827990  False   True  False\n",
        "2010-05-20  61.82  64.65  61.17  61.54   1495900      60.53      1822735  False   True  False\n",
        "2010-05-21  61.02  62.19  59.85  62.03   1896300      61.01      1765785  False  False   True\n",
        "2010-05-24  62.13  62.13  61.42  61.42    779100      60.41      1616725  False   True  False\n",
        "2010-05-25  60.88  60.88  59.78  60.50   1273400      59.51      1599365  False   True  False\n",
        "2010-05-26  60.67  61.31  59.39  59.56   1244900      58.58      1604090  False   True  False\n",
        "2010-05-27  60.28  60.28  56.77  58.06   2107800      57.11      1551020   True  False  False\n",
        "2010-05-28  57.91  58.63  57.49  57.49   1427400      56.55      1557395  False  False   True\n",
        "2010-06-01  57.46  57.64  56.51  56.60    849400      55.67      1545450  False   True  False\n",
        "2010-06-02  57.21  57.42  56.04  57.42    902300      56.48      1547800  False   True  False\n",
        "2010-06-03  57.90  58.09  57.18  57.70    744500      56.75      1519060  False   True  False\n",
        "2010-06-04  56.96  57.26  56.21  56.39    776300      55.47      1481625  False   True  False\n",
        "2010-06-07  56.75  56.75  54.69  54.79    858400      53.89      1421260  False   True  False\n",
        "2010-06-08  54.85  56.19  54.52  56.02   1435700      55.10      1442690  False  False   True\n",
        "2010-06-09  56.40  56.61  55.34  55.51    990800      54.60      1412850  False   True  False\n",
        "2010-06-10  55.82  56.50  54.99  55.57    741600      54.66      1312910  False   True  False\n",
        "2010-06-11  55.10  58.31  55.10  57.10   1286800      56.27      1337790  False  False   True\n",
        "2010-06-14  57.01  57.35  54.96  55.19   1108000      54.38      1360895  False   True  False\n",
        "2010-06-15  55.42  56.41  55.11  56.34   1474200      55.52      1321805   True  False  False\n",
        "2010-06-16  57.37  58.46  56.78  57.05   1955400      56.22      1244340   True  False  False\n",
        "2010-06-17  57.11  57.29  56.33  56.84    983000      56.01      1216560  False   True  False\n",
        "2010-06-18  57.52  57.85  56.95  57.23    839300      56.39      1183730  False   True  False\n",
        "2010-06-21  58.01  58.01  56.37  56.58    785800      55.75      1128205  False   True  False\n",
        "2010-06-22  56.45  56.82  55.15  55.47   1371000      54.66      1157800   True  False  False\n",
        "2010-06-23  55.54  56.21  55.07  55.85   1251300      55.03      1156695  False  False   True\n",
        "2010-06-24  55.78  58.02  55.37  56.59   1823800      55.76      1185640   True  False  False\n",
        "2010-06-25  56.66  56.75  54.86  55.33   1044000      54.52      1132450  False  False   True\n",
        "2010-06-28  55.04  55.79  54.71  54.79    666800      53.99      1094420  False   True  False\n",
        "2010-06-29  54.46  54.46  52.71  52.85   1257900      52.08      1114845   True  False  False\n",
        "2010-06-30  52.65  53.90  52.22  52.49   1064400      51.72      1122950  False  False   True\n",
        "2010-07-01  52.37  52.93  50.20  50.41   2253000      49.67      1198375   True  False  False\n",
        "2010-07-02  50.43  50.75  49.22  49.24   1374500      48.52      1228285   True  False  False\n",
        "2010-07-06  49.98  50.50  49.02  49.53   1227700      48.81      1246750  False  False   True\n",
        "2010-07-07  49.32  50.31  49.05  50.28    774000      49.55      1213665  False   True  False\n",
        "2010-07-08  50.72  51.31  50.46  51.04    624700      50.29      1195360  False   True  False\n",
        "2010-07-09  51.10  51.58  50.69  51.51    422100      50.76      1179385  False   True  False\n",
        "2010-07-12  51.34  51.85  50.52  51.00    446700      50.25      1137380  False   True  False\n",
        "2010-07-13  51.20  51.97  50.94  51.87    700800      51.11      1117020  False   True  False\n",
        "2010-07-14  51.73  52.35  51.73  52.33    702600      51.57      1078440  False   True  False\n",
        "2010-07-15  52.25  52.88  51.75  52.70   1088600      51.93      1035100  False  False   True\n",
        "2010-07-16  52.58  53.40  52.25  52.85   1293700      52.08      1050635   True  False  False\n",
        "2010-07-19  52.98  56.65  52.90  53.50   1930600      52.72      1105200   True  False  False\n",
        "2010-07-20  53.09  53.85  52.35  53.61    760500      52.83      1103935  False   True  False\n",
        "2010-07-21  53.58  53.71  50.81  51.26   1511500      50.51      1110960   True  False  False\n",
        "2010-07-22  50.96  51.54  50.37  51.51   1545100      50.76      1125650   True  False  False\n",
        "2010-07-23  54.52  59.30  54.00  59.29   5719900      58.42      1320455   True  False  False\n",
        "2010-07-26  59.16  59.53  55.19  55.49   3411100      54.68      1438810   True  False  False\n",
        "2010-07-27  55.87  57.04  55.28  55.48   1150200      54.67      1462980  False   True  False\n",
        "2010-07-28  55.34  55.69  54.37  54.60    994500      53.80      1449810  False   True  False\n",
        "2010-07-29  54.70  55.18  53.65  54.17   1034900      53.38      1448335  False   True  False\n",
        "2010-07-30  53.91  54.15  52.93  53.80    997000      53.01      1385535  False   True  False\n",
        "2010-08-02  54.35  54.89  54.13  54.50    806800      53.70      1357150  False   True  False\n",
        "2010-08-03  54.06  54.06  52.14  52.24   1682200      51.48      1379875   True  False  False\n",
        "2010-08-04  52.07  52.96  51.16  52.44   1057100      51.67      1394030  False   True  False\n",
        "2010-08-05  52.45  52.45  50.84  50.96   1367800      50.22      1431185  False  False   True\n",
        "2010-08-06  50.09  50.09  47.56  47.83   2856000      47.13      1552880   True  False  False\n",
        "2010-08-09  48.10  48.88  47.99  48.33   1141700      47.62      1587630  False   True  False\n",
        "2010-08-10  47.81  47.90  46.83  46.91   1378100      46.22      1621495  False   True  False\n",
        "2010-08-11  45.91  47.25  45.67  45.79   1949000      45.12      1683815   True  False  False\n",
        "2010-08-12  45.05  45.89  44.91  45.31   1229500      44.65      1690860  False   True  False\n",
        "2010-08-13  46.87  47.57  42.01  42.71   4117900      42.09      1832070   True  False  False\n",
        "2010-08-16  39.05  40.89  38.22  38.97   4209800      38.40      1946030   True  False  False\n",
        "2010-08-17  39.05  39.44  37.91  38.41   2629200      37.85      2039465   True  False  False\n",
        "2010-08-18  38.61  39.82  38.52  38.68   1981400      38.11      2062960  False  False   True\n",
        "2010-08-19  38.69  39.10  37.63  38.82   1832900      38.25      2077350  False   True  False\n",
        "2010-08-20  38.49  38.72  36.34  37.98   2625000      37.42      1922605   True  False  False\n",
        "2010-08-23  38.07  38.35  37.63  38.02   1265400      37.46      1815320  False   True  False\n",
        "2010-08-24  37.63  39.27  37.43  37.50   1526200      36.95      1834120  False   True  False\n",
        "2010-08-25  37.32  38.63  36.82  38.44   1688800      37.88      1868835  False  False   True\n",
        "2010-08-26  38.32  38.77  37.90  38.31    899300      37.75      1862055  False   True  False\n",
        "2010-08-27  38.52  38.74  37.42  38.71   1046600      38.14      1864535  False   True  False\n",
        "2010-08-30  38.67  39.57  38.66  39.03   1234500      38.46      1885920  False   True  False\n",
        "2010-08-31  38.93  39.14  37.75  38.11   1742000      37.55      1888910  False  False   True\n",
        "2010-09-01  38.74  39.82  38.31  39.54   1205100      38.96      1896310  False   True  False\n",
        "2010-09-02  39.64  40.33  39.22  40.14   1339900      39.55      1894915  False   True  False\n",
        "2010-09-03  40.34  41.30  40.33  41.30    839100      40.70      1794070  False   True  False\n",
        "2010-09-07  40.44  40.72  40.01  40.06   1109500      39.47      1792460  False   True  False\n",
        "2010-09-08  40.05  41.20  40.05  41.09    843400      40.49      1765725  False   True  False\n",
        "2010-09-09  41.36  41.98  40.82  41.90   1064200      41.29      1721485  False   True  False\n",
        "2010-09-10  41.71  42.95  41.71  42.64   1156400      42.02      1717830  False   True  False\n",
        "2010-09-13  43.44  44.16  42.35  44.02   1097100      43.38      1566790  False   True  False\n",
        "2010-09-14  43.83  43.90  42.20  42.48   1125900      41.86      1412595  False   True  False\n",
        "2010-09-15  42.29  43.01  41.25  42.67   1092300      42.05      1335750  False   True  False\n",
        "2010-09-16  42.54  43.73  42.19  43.30   1097200      42.67      1291540  False   True  False\n",
        "2010-09-17  43.39  46.18  43.37  44.77   2246200      44.12      1312205   True  False  False\n",
        "2010-09-20  44.74  45.99  44.43  45.89   1134200      45.22      1237665  False  False   True\n",
        "2010-09-21  45.90  45.95  44.57  44.79    778700      44.14      1213330  False   True  False\n",
        "2010-09-22  44.67  45.28  42.90  44.32   1590100      43.67      1216525   True  False  False\n",
        "2010-09-23  44.03  46.74  43.78  44.74   1616200      44.09      1212895   True  False  False\n",
        "2010-09-24  45.22  49.09  45.07  47.13   4359500      46.44      1385905   True  False  False\n",
        "2010-09-27  47.23  47.33  44.87  45.63   1561600      44.96      1411655   True  False  False\n",
        "2010-09-28  45.42  46.38  45.27  46.32    860500      45.64      1392955  False   True  False\n",
        "2010-09-29  46.32  47.09  46.32  46.89   1078400      46.20      1359775  False   True  False\n",
        "2010-09-30  47.20  50.00  46.70  49.21   2099500      48.49      1404495   True  False  False\n",
        "2010-10-01  49.43  51.06  48.75  49.43   1154400      48.71      1395220  False   True  False\n",
        "2010-10-04  49.21  49.21  47.47  48.10    796000      47.40      1393065  False   True  False\n",
        "2010-10-05  48.75  50.59  48.74  49.75    985500      49.02      1386865  False   True  False\n",
        "2010-10-06  49.75  50.37  49.49  50.34    789500      49.60      1384170  False   True  False\n",
        "2010-10-07  50.34  50.95  49.36  49.37    957800      48.65      1378850  False   True  False\n",
        "2010-10-08  49.60  51.18  49.50  50.90    627200      50.16      1352390  False   True  False\n",
        "2010-10-11  50.88  50.88  49.95  50.31    533700      49.57      1324220  False   True  False\n",
        "2010-10-12  50.31  51.15  49.94  50.96    666600      50.22      1301255  False   True  False\n",
        "2010-10-13  51.00  51.20  50.47  50.57   1530200      49.83      1323150   True  False  False\n",
        "2010-10-14  44.26  44.67  41.31  42.06   5315000      41.45      1534040   True  False  False\n",
        "2010-10-15  42.40  42.40  40.58  41.72   2244600      41.11      1533960   True  False  False\n",
        "2010-10-18  41.82  44.89  41.77  43.76   1928500      43.12      1573675   True  False  False\n",
        "2010-10-19  43.50  44.43  43.07  44.16   1366100      43.51      1603045  False   True  False\n",
        "2010-10-20  44.10  45.46  44.06  44.89   1225700      44.23      1584825  False   True  False\n",
        "2010-10-21  44.87  45.20  43.76  44.64   1263100      43.99      1567170  False   True  False\n",
        "2010-10-22  44.79  45.45  44.07  45.15   1122300      44.49      1405310  False   True  False\n",
        "2010-10-25  45.39  45.96  44.58  44.75   1638400      44.10      1409150   True  False  False\n",
        "2010-10-26  43.19  44.11  41.07  42.74   2315600      42.12      1481905   True  False  False\n",
        "2010-10-27  43.58  46.26  43.58  45.75   1833500      45.08      1519660   True  False  False\n",
        "2010-10-28  45.86  47.18  45.02  46.51   1697000      45.83      1499535   True  False  False\n",
        "2010-10-29  46.31  48.17  46.00  47.86   1239300      47.16      1503780  False   True  False\n",
        "2010-11-01  48.16  48.87  47.96  48.18    870200      47.48      1507490  False   True  False\n",
        "2010-11-02  48.68  48.98  47.34  48.51    818300      47.80      1499130  False   True  False\n",
        "2010-11-03  48.52  48.78  47.04  47.89   1195200      47.19      1519415  False   True  False\n",
        "2010-11-04  48.45  48.50  45.99  46.58   1418100      45.90      1542430  False  False   True\n",
        "2010-11-05  46.72  48.27  46.72  47.37    612200      46.68      1541680  False   True  False\n",
        "2010-11-08  47.29  47.98  47.11  47.46    742400      46.77      1552115  False   True  False\n",
        "2010-11-09  47.65  48.11  46.65  46.90    839200      46.21      1560745  False   True  False\n",
        "2010-11-10  47.00  47.16  46.01  46.79    792700      46.11      1523870  False   True  False\n",
        "2010-11-11  46.71  46.81  46.09  46.65    974300      45.97      1306835  False   True  False\n",
        "2010-11-12  46.47  46.84  45.68  45.93    952700      45.26      1242240  False   True  False\n",
        "2010-11-15  46.36  47.14  45.76  45.79    939000      45.12      1192765  False   True  False\n",
        "2010-11-16  45.67  46.29  45.60  45.79    870500      45.12      1167985  False   True  False\n",
        "2010-11-17  45.89  46.53  45.02  45.52    591200      44.85      1136260  False   True  False\n",
        "2010-11-18  46.25  46.38  45.11  45.22    792800      44.56      1112745  False   True  False\n",
        "2010-11-19  45.07  45.49  44.48  44.53    985300      43.88      1105895  False   True  False\n",
        "2010-11-22  44.49  44.86  43.97  44.78   1018300      44.13      1074890  False  False   True\n",
        "2010-11-23  44.26  44.49  43.67  44.07    569900      43.43       987605  False   True  False\n",
        "2010-11-24  44.03  44.55  43.71  43.99    461700      43.35       919015  False   True  False\n",
        "2010-11-26  43.82  44.11  43.64  43.70    200400      43.06       844185  False   True  False\n",
        "2010-11-29  43.41  43.78  42.63  43.59    598100      42.95       812125  False   True  False\n",
        "2010-11-30  43.29  43.55  42.91  42.94    776000      42.31       807415  False  False   True\n",
        "2010-12-01  43.51  43.86  42.58  42.75    970700      42.13       815035   True  False  False\n",
        "2010-12-02  42.80  44.85  42.73  43.68   2034800      43.04       857015   True  False  False\n",
        "2010-12-03  43.52  44.68  43.35  43.76   1390100      43.12       855615   True  False  False\n",
        "2010-12-06  43.81  44.45  43.70  43.88   1146500      43.24       882330   True  False  False\n",
        "2010-12-07  44.23  44.39  43.57  43.98   1266400      43.34       908530   True  False  False\n",
        "2010-12-08  44.00  44.76  44.00  44.36   1208800      43.83       927010   True  False  False\n",
        "2010-12-09  44.41  44.55  43.73  44.06    785800      43.53       926665  False   True  False\n",
        "2010-12-10  44.30  45.88  44.03  44.85   1329600      44.32       944430   True  False  False\n",
        "2010-12-13  44.92  45.48  44.86  45.18   1188900      44.64       956240   True  False  False\n",
        "2010-12-14  45.01  45.66  44.42  44.60    900100      44.07       954295  False  False   True\n",
        "2010-12-15  44.60  44.82  44.07  44.24    672300      43.71       944385  False   True  False\n",
        "2010-12-16  44.52  45.08  44.19  44.97    664700      44.43       948060  False   True  False\n",
        "2010-12-17  45.05  46.11  44.81  46.04    993900      45.49       958115  False  False   True\n",
        "2010-12-20  46.10  47.39  46.10  47.32    942000      46.76       955950  False  False   True\n",
        "2010-12-21  47.45  47.78  46.98  47.40    824800      46.83       946275  False   True  False\n",
        "2010-12-22  47.45  48.15  47.42  48.10    676700      47.53       951615  False   True  False\n",
        "2010-12-23  48.10  48.61  47.75  48.05    352800      47.48       946170  False   True  False\n",
        "2010-12-27  47.86  47.94  47.42  47.79    239000      47.22       948100  False   True  False\n",
        "2010-12-28  47.76  47.83  47.08  47.61    347600      47.04       935575  False   True  False\n",
        "2010-12-29  47.79  48.61  47.52  48.00    577600      47.43       925655  False   True  False\n",
        "2010-12-30  48.00  48.27  47.78  48.05    394000      47.48       896820  False   True  False\n",
        "2010-12-31  48.05  48.33  47.22  47.98    495100      47.41       819835  False   True  False\n",
        "2011-01-03  48.23  48.68  47.87  48.50    682500      47.92       784455  False   True  False\n",
        "2011-01-04  48.45  48.55  47.20  47.63    627000      47.06       758480  False   True  False\n",
        "2011-01-05  47.63  48.54  47.35  48.31    535400      47.73       721930  False   True  False\n",
        "2011-01-06  49.13  49.85  47.50  47.91   1011400      47.34       712060   True  False  False\n",
        "2011-01-07  48.04  48.30  46.77  47.55    644100      46.98       704975  False  False   True\n",
        "2011-01-10  43.05  43.24  40.25  42.81   3945900      42.30       835790   True  False  False\n",
        "2011-01-11  44.20  44.94  43.18  44.80   1713000      44.27       861995   True  False  False\n",
        "2011-01-12  44.90  45.92  43.98  45.46   1026700      44.92       868325   True  False  False\n",
        "2011-01-13  45.49  46.26  45.08  46.22    913000      45.67       880360  False  False   True\n",
        "2011-01-14  46.38  46.67  46.09  46.39    812400      45.84       887745  False  False   True\n",
        "2011-01-18  46.31  46.46  45.25  46.39    666300      45.84       871365  False   True  False\n",
        "2011-01-19  46.45  46.59  45.84  46.01    391600      45.46       843845  False   True  False\n",
        "2011-01-20  45.96  47.00  45.77  46.72    913100      46.16       848260  False  False   True\n",
        "2011-01-21  47.00  47.46  46.76  47.08    482800      46.52       838565  False   True  False\n",
        "2011-01-24  47.09  48.24  46.85  48.21    837000      47.64       862775  False  False   True\n",
        "2011-01-25  48.04  48.44  46.79  47.38   1433200      46.82       922485   True  False  False\n",
        "2011-01-26  50.93  53.90  49.69  53.36   3942200      52.72      1102215   True  False  False\n",
        "2011-01-27  53.46  53.46  51.78  53.01   1206200      52.38      1133645  False  False   True\n",
        "2011-01-28  53.14  53.14  51.55  51.69    766100      51.07      1152250  False   True  False\n",
        "2011-01-31  51.67  52.53  51.52  52.11    821800      51.49      1168585  False   True  False\n",
        "2011-02-01  52.94  54.04  51.98  53.65    632600      53.01      1166090  False   True  False\n",
        "2011-02-02  53.29  53.72  52.86  53.21    612800      52.58      1165380  False   True  False\n",
        "2011-02-03  53.10  53.66  52.90  53.47    639800      52.83      1170600  False   True  False\n",
        "2011-02-04  53.41  53.43  52.33  52.99    650000      52.36      1152530  False   True  False\n",
        "2011-02-07  53.13  53.86  52.57  53.49    460100      52.85      1143330  False   True  False\n",
        "2011-02-08  53.41  53.75  52.60  53.18    584300      52.55       975250  False   True  False\n",
        "2011-02-09  53.08  53.33  52.46  52.84    542900      52.21       916745  False   True  False\n",
        "2011-02-10  52.69  53.58  52.47  53.53    610000      52.89       895910  False   True  False\n",
        "2011-02-11  53.28  53.41  52.72  53.28    412300      52.64       870875  False   True  False\n",
        "2011-02-14  53.12  53.44  52.67  52.96    417800      52.33       851145  False   True  False\n",
        "2011-02-15  52.59  52.80  52.19  52.45    548900      51.82       845275  False   True  False\n",
        "2011-02-16  52.64  54.23  52.47  53.04    766100      52.41       864000  False   True  False\n",
        "2011-02-17  52.97  53.97  52.87  53.75    453600      53.11       841025  False   True  False\n",
        "2011-02-18  53.78  55.58  53.78  55.18    894500      54.52       861610  False  False   True\n",
        "2011-02-22  54.78  55.21  54.09  54.50    789400      53.85       859230  False  False   True\n",
        "2011-02-23  54.37  54.48  52.97  53.33    693800      52.69       822260  False   True  False\n",
        "2011-02-24  53.00  53.82  52.50  53.65    618500      53.01       656075  False  False   True\n",
        "2011-02-25  53.74  54.85  53.63  54.72    449600      54.07       618245  False   True  False\n",
        "2011-02-28  54.31  54.87  53.12  54.25    589600      53.60       609420  False  False   True\n",
        "2011-03-01  54.67  54.67  52.88  53.07    408300      52.44       588745  False   True  False\n",
        "2011-03-02  53.07  54.14  52.88  53.40    422800      52.76       578255  False   True  False\n",
        "2011-03-03  53.96  54.39  53.79  54.27    462900      53.62       570760  False   True  False\n",
        "2011-03-04  54.35  54.69  53.49  53.97    385400      53.33       558040  False   True  False\n",
        "2011-03-07  54.19  55.05  53.20  53.35    474700      52.71       549275  False   True  False\n",
        "2011-03-08  53.83  54.32  53.17  53.53    490500      52.89       550795  False   True  False\n",
        "2011-03-09  53.53  53.55  52.80  52.99    289400      52.36       536050  False   True  False\n",
        "2011-03-10  52.81  53.00  51.83  52.13    433300      51.51       530570  False   True  False\n",
        "2011-03-11  52.47  52.74  51.84  52.43    338700      51.80       517005  False   True  False\n",
        "2011-03-14  52.20  52.95  51.60  51.83    359500      51.21       514365  False   True  False\n",
        "2011-03-15  50.74  51.80  50.47  51.51    379400      50.90       512445  False   True  False\n",
        "2011-03-16  51.34  51.50  50.08  50.33    350600      49.73       502530  False   True  False\n",
        "2011-03-17  50.97  51.05  49.75  50.43    536300      49.83       491040  False  False   True\n",
        "2011-03-18  51.17  51.96  50.34  51.20    796800      50.59       508200   True  False  False\n",
        "2011-03-21  51.72  52.75  51.69  52.54    454100      51.91       486180  False  False   True\n",
        "2011-03-22  52.68  53.42  52.57  53.00    499900      52.37       471705  False  False   True\n",
        "2011-03-23  52.79  53.60  52.45  53.48    392000      52.84       456615  False   True  False\n",
        "2011-03-24  53.67  54.54  53.56  54.11    433200      53.46       447350  False  False   True\n",
        "2011-03-25  54.13  55.50  54.13  54.61    530300      53.96       451385   True  False  False\n",
        "2011-03-28  54.83  56.25  54.76  54.93    785600      54.28       461185   True  False  False\n",
        "2011-03-29  53.60  54.45  52.21  54.41    875600      53.76       484550   True  False  False\n",
        "2011-03-30  54.62  55.69  54.48  54.79    544200      54.14       490620   True  False  False\n",
        "2011-03-31  54.56  55.18  54.07  55.07    398600      54.41       487405  False   True  False\n",
        "2011-04-01  55.20  56.26  55.20  55.94    564500      55.27       496360   True  False  False\n",
        "2011-04-04  56.00  56.46  55.08  55.63    492400      54.97       497245  False  False   True\n",
        "2011-04-05  55.60  56.09  55.45  55.99    475500      55.32       496495  False  False   True\n",
        "2011-04-06  56.12  56.49  55.97  55.98    534600      55.31       508755  False  False   True\n",
        "2011-04-07  55.85  56.09  55.33  56.05    638800      55.38       519030   True  False  False\n",
        "2011-04-08  54.69  55.63  54.16  54.76    830400      54.11       543615   True  False  False\n",
        "2011-04-11  56.39  56.43  53.88  54.01    685000      53.37       559890   True  False  False\n",
        "2011-04-12  53.74  54.00  53.01  53.22    453100      52.59       563575  False   True  False\n",
        "2011-04-13  53.39  53.61  52.31  52.45    402600      51.82       566175  False   True  False\n",
        "2011-04-14  52.16  52.90  52.16  52.75    425400      52.12       560630  False   True  False\n",
        "2011-04-15  52.57  52.84  51.77  51.93    624000      51.31       551990   True  False  False\n",
        "2011-04-18  51.43  51.85  51.15  51.68    554100      51.06       556990  False  False   True\n",
        "2011-04-19  51.76  51.79  49.45  49.55   1057600      48.96       584875   True  False  False\n",
        "2011-04-20  50.05  50.16  48.03  48.28   1728800      47.70       651715   True  False  False\n",
        "2011-04-21  48.96  49.66  47.77  49.29   1014500      48.70       680780   True  False  False\n",
        "2011-04-25  48.93  49.70  48.49  49.03   1184600      48.45       713495   True  False  False\n",
        "2011-04-26  49.18  50.25  49.17  50.09   1106000      49.49       729515   True  False  False\n",
        "2011-04-27  50.20  55.52  50.18  53.70   2421800      53.06       806825   True  False  False\n",
        "2011-04-28  53.41  54.33  52.10  52.37    779800      51.75       818605  False  False   True\n",
        "2011-04-29  52.37  53.11  52.07  52.90    579000      52.27       827625  False   True  False\n",
        "2011-05-02  52.99  53.40  52.64  53.03    442600      52.40       821530  False   True  False\n",
        "2011-05-03  53.01  53.58  51.98  53.15   1047000      52.52       849260   True  False  False\n",
        "2011-05-04  53.11  53.33  52.06  52.71    512500      52.08       851110  False   True  False\n",
        "2011-05-05  52.51  53.35  52.22  52.56    367300      51.93       842745  False   True  False\n",
        "2011-05-06  53.01  53.10  51.79  51.99    400300      51.37       830820  False   True  False\n",
        "2011-05-09  52.00  52.74  51.91  52.62    430500      51.99       810825  False   True  False\n",
        "2011-05-10  52.73  53.66  52.60  53.21    371400      52.58       795145  False   True  False\n",
        "2011-05-11  53.04  53.69  52.23  52.85    502500      52.22       797615  False   True  False\n",
        "2011-05-12  52.73  53.92  52.65  53.70    520000      53.06       803485  False   True  False\n",
        "2011-05-13  53.84  53.98  53.16  53.29    405700      52.65       802500  False   True  False\n",
        "2011-05-16  53.10  53.53  52.72  52.97    447900      52.34       793695  False   True  False\n",
        "2011-05-17  52.80  52.96  52.18  52.37    512100      51.75       791595  False   True  False\n",
        "2011-05-18  52.35  52.73  52.24  52.68    451400      52.05       761285  False   True  False\n",
        "2011-05-19  52.94  53.13  51.88  52.05    311000      51.43       690395  False   True  False\n",
        "2011-05-20  52.19  52.29  51.70  51.90    551300      51.28       667235  False   True  False\n",
        "2011-05-23  51.48  51.87  51.34  51.65   1003400      51.03       658175   True  False  False\n",
        "2011-05-24  52.42  54.64  52.15  53.96   1606400      53.32       683195   True  False  False\n",
        "2011-05-25  53.68  54.09  53.28  53.46    732800      52.82       598745   True  False  False\n",
        "2011-05-26  53.44  53.98  53.20  53.57    653800      52.93       592445   True  False  False\n",
        "2011-05-27  53.56  54.59  53.44  54.08    386300      53.44       582810  False   True  False\n",
        "2011-05-31  54.47  54.61  53.44  53.85    995800      53.21       610470   True  False  False\n",
        "2011-06-01  53.59  54.74  53.04  53.99   1047700      53.35       610505   True  False  False\n",
        "2011-06-02  62.09  62.31  58.89  61.86   4455800      61.12       807670   True  False  False\n",
        "2011-06-03  61.15  61.89  60.18  60.36   1051400      59.64       841875   True  False  False\n",
        "2011-06-06  60.23  60.23  58.74  58.92    826200      58.22       863170  False  False   True\n",
        "2011-06-07  59.37  60.62  59.15  59.19    754100      58.48       879350  False   True  False\n",
        "2011-06-08  59.16  59.66  58.51  58.77    627800      58.07       892170  False   True  False\n",
        "2011-06-09  59.07  59.41  58.23  58.36    641700      57.66       899130  False   True  False\n",
        "2011-06-10  58.23  58.51  56.46  56.86    910200      56.18       918640  False  False   True\n",
        "2011-06-13  56.96  57.68  56.61  56.96    547700      56.28       925740  False   True  False\n",
        "2011-06-14  57.20  57.90  56.97  57.75    481500      57.06       927420  False   True  False\n",
        "2011-06-15  57.39  58.19  56.19  56.47    618400      55.80       932735  False   True  False\n",
        "2011-06-16  56.40  57.55  56.16  56.54    667500      55.98       943540  False   True  False\n",
        "2011-06-17  57.10  57.59  55.80  55.86    587300      55.31       957355  False   True  False\n",
        "2011-06-20  55.82  56.53  55.48  56.01    314100      55.46       945495  False   True  False\n",
        "2011-06-21  56.37  58.26  56.36  58.16    580100      57.59       924330  False   True  False\n",
        "2011-06-22  57.83  58.61  57.16  57.23    574400      56.67       872730  False   True  False\n",
        "2011-06-23  56.62  58.01  56.36  57.94    470200      57.37       859600  False   True  False\n",
        "2011-06-24  58.03  58.11  57.32  57.57    607700      57.00       857295  False   True  False\n",
        "2011-06-27  57.46  57.52  56.24  56.58    496700      56.02       862815  False   True  False\n",
        "2011-06-28  56.89  58.61  56.71  58.07    429100      57.50       834480  False   True  False\n",
        "2011-06-29  58.08  58.55  57.76  58.25    430300      57.68       803610  False   True  False\n",
        "2011-06-30  58.38  59.41  58.38  59.13    576500      58.55       609645  False  False   True\n",
        "2011-07-01  59.45  61.17  59.26  60.63    818200      60.03       597985   True  False  False\n",
        "2011-07-05  60.40  60.85  59.70  60.60    620100      60.01       587680  False  False   True\n",
        "2011-07-06  60.57  60.88  59.96  60.75    652500      60.15       582600   True  False  False\n",
        "2011-07-07  61.03  63.58  60.88  62.46    938800      61.85       598150   True  False  False\n",
        "2011-07-08  61.76  62.70  61.17  62.59    466400      61.98       589385  False   True  False\n",
        "2011-07-11  61.73  61.92  60.41  60.85    407400      60.25       564245  False   True  False\n",
        "2011-07-12  60.64  62.14  60.57  61.57    392700      60.97       556495  False   True  False\n",
        "2011-07-13  61.87  62.97  61.87  62.39    570200      61.78       560930  False  False   True\n",
        "2011-07-14  62.47  62.65  61.10  61.38    450000      60.78       552510  False   True  False\n",
        "2011-07-15  62.80  63.14  61.98  62.99    595700      62.37       548920  False  False   True\n",
        "2011-07-18  62.96  63.87  62.72  63.10    611800      62.48       550145   True  False  False\n",
        "2011-07-19  63.32  66.17  63.32  65.91   1081300      65.26       588505   True  False  False\n",
        "2011-07-20  65.80  66.69  64.94  66.55   1580000      65.90       638500   True  False  False\n",
        "2011-07-21  65.83  66.85  63.96  65.45   1122800      64.81       665920   True  False  False\n",
        "2011-07-22  65.42  66.24  65.18  65.99    580600      65.34       671440  False   True  False\n",
        "2011-07-25  65.15  66.35  64.74  65.84    495200      65.19       665815  False   True  False\n",
        "2011-07-26  65.63  66.08  64.68  65.45    735800      64.81       677770  False  False   True\n",
        "2011-07-27  65.16  65.21  64.00  64.20    568000      63.57       684715  False   True  False\n",
        "2011-07-28  64.20  64.23  61.75  61.86   1063200      61.25       716360   True  False  False\n",
        "2011-07-29  61.14  62.29  60.36  62.14    624300      61.53       718750  False   True  False\n",
        "2011-08-01  62.54  62.79  60.11  60.75    777300      60.15       716705  False  False   True\n",
        "2011-08-02  60.36  61.31  59.79  59.80    790300      59.21       725215  False  False   True\n",
        "2011-08-03  59.73  59.95  57.95  59.78    858800      59.19       735530   True  False  False\n",
        "2011-08-04  58.88  61.00  58.83  59.65   1487300      59.06       762955   True  False  False\n",
        "2011-08-05  59.94  60.60  56.89  57.82   1581700      57.25       818720   True  False  False\n",
        "2011-08-08  56.46  56.83  52.56  52.64   1082700      52.12       852485   True  False  False\n",
        "2011-08-09  53.46  54.35  50.87  53.82   2587500      53.29       962225   True  False  False\n",
        "2011-08-10  52.96  53.51  51.65  51.72   1142800      51.21       990855   True  False  False\n",
        "2011-08-11  52.42  54.20  51.70  53.39   1265500      52.87      1031630   True  False  False\n",
        "2011-08-12  48.47  48.64  43.13  44.49   4476900      44.05      1225690   True  False  False\n",
        "2011-08-15  44.42  44.93  43.83  44.27   1936600      43.84      1291930   True  False  False\n",
        "2011-08-16  43.99  45.38  43.99  44.81   1678700      44.37      1321800   True  False  False\n",
        "2011-08-17  45.00  45.08  42.84  43.58   1030100      43.15      1294305  False   True  False\n",
        "2011-08-18  41.99  42.37  40.84  41.12   1654500      40.72      1320890   True  False  False\n",
        "2011-08-19  40.67  41.23  39.32  39.46   1269500      39.07      1355335  False  False   True\n",
        "2011-08-22  40.17  40.61  39.71  39.85   1192100      39.46      1390180  False   True  False\n",
        "2011-08-23  40.12  41.37  39.38  41.35    879200      40.94      1397350  False   True  False\n",
        "2011-08-24  41.21  42.10  41.03  41.87   1047100      41.46      1421305  False   True  False\n",
        "2011-08-25  42.52  42.57  41.03  41.14    739400      40.74      1405115  False   True  False\n",
        "2011-08-26  41.10  42.79  40.41  42.59    809200      42.17      1414360  False   True  False\n",
        "2011-08-29  43.12  43.48  42.62  43.09    743700      42.67      1412680  False   True  False\n",
        "2011-08-30  42.99  44.19  42.88  43.88    710200      43.45      1408675  False   True  False\n",
        "2011-08-31  44.17  44.87  43.67  44.18    756500      43.75      1403560  False   True  False\n",
        "2011-09-01  44.30  44.50  42.29  42.52    913500      42.10      1374870  False   True  False\n",
        "2011-09-02  41.76  41.98  40.33  40.74    987000      40.34      1345135  False   True  False\n",
        "2011-09-06  40.09  41.66  40.06  41.45   1309800      41.04      1356490  False  False   True\n",
        "2011-09-07  41.89  42.98  41.64  42.82    759900      42.40      1265110  False   True  False\n",
        "2011-09-08  42.35  42.75  40.56  40.98    979200      40.58      1256930  False   True  False\n",
        "2011-09-09  40.56  41.67  40.23  40.62    884300      40.22      1237870  False   True  False\n",
        "2011-09-12  40.20  41.23  39.78  41.18    971100      40.78      1062580  False  False   True\n",
        "2011-09-13  41.24  41.95  39.63  39.87   1406200      39.48      1036060   True  False  False\n",
        "2011-09-14  40.07  41.12  40.07  40.22   1680000      39.83      1036125   True  False  False\n",
        "2011-09-15  40.71  41.75  40.65  41.38   1001400      40.97      1034690  False  False   True\n",
        "2011-09-16  41.60  42.49  41.51  41.74   1051500      41.33      1004540  False  False   True\n",
        "2011-09-19  41.10  41.14  39.48  40.54    967300      40.14       989430  False  False   True\n",
        "2011-09-20  40.83  41.21  39.97  40.04    972900      39.65       978470  False  False   True\n",
        "2011-09-21  39.94  40.30  38.52  38.60   1024000      38.22       985710  False  False   True\n",
        "2011-09-22  37.46  37.72  35.43  35.59   1221600      35.24       994435   True  False  False\n",
        "2011-09-23  35.32  38.13  35.03  37.44   1119600      37.07      1013445   True  False  False\n",
        "2011-09-26  37.61  39.36  37.31  39.20   1106000      38.82      1028285  False  False   True\n",
        "2011-09-27  39.85  40.99  39.42  39.80   1142700      39.41      1048235  False  False   True\n",
        "2011-09-28  39.76  40.00  38.59  38.71    742900      38.33      1049870  False   True  False\n",
        "2011-09-29  39.38  39.72  37.34  38.27    595700      37.89      1041830  False   True  False\n",
        "2011-09-30  37.46  38.07  36.77  36.96    748200      36.60      1033565  False   True  False\n",
        "2011-10-03  36.69  37.06  35.19  35.21   1004900      34.86      1034460  False  False   True\n",
        "2011-10-04  34.95  36.99  34.24  36.88    826800      36.52      1010310  False   True  False\n",
        "2011-10-05  37.00  39.94  37.00  39.38    967100      38.99      1020670  False  False   True\n",
        "2011-10-06  39.08  40.10  38.33  39.89    799500      39.50      1011685  False   True  False\n",
        "2011-10-07  40.18  41.25  39.72  40.19    701100      39.80      1002525  False   True  False\n",
        "2011-10-10  40.79  42.09  40.70  41.37    616600      40.96       984800  False   True  False\n",
        "2011-10-11  41.20  42.34  40.87  41.86    354800      41.45       932230  False   True  False\n",
        "2011-10-12  42.32  44.08  41.96  43.46    874800      43.03       891970  False  False   True\n",
        "2011-10-13  43.01  43.01  41.71  42.75    466300      42.33       865215  False   True  False\n",
        "2011-10-14  43.27  44.19  42.99  43.90    533100      43.47       839295  False   True  False\n",
        "2011-10-17  43.66  44.39  41.55  41.79   1155500      41.38       848705   True  False  False\n",
        "2011-10-18  41.78  43.06  40.50  42.66    727400      42.24       836430  False   True  False\n",
        "2011-10-19  44.26  46.37  43.64  44.18   1019300      43.75       836195   True  False  False\n",
        "2011-10-20  44.15  44.96  43.07  43.90    651200      43.47       807675  False   True  False\n",
        "2011-10-21  44.22  45.39  43.86  45.35    687700      44.90       786080  False   True  False\n",
        "2011-10-24  45.65  46.92  45.62  46.44   1159300      45.98       788745   True  False  False\n",
        "2011-10-25  45.95  46.30  44.11  46.08   1306200      45.63       796920   True  False  False\n",
        "2011-10-26  41.91  41.91  37.68  38.36   3468900      37.98       933220   True  False  False\n",
        "2011-10-27  39.63  39.71  38.37  38.51   1559800      38.13       981425   True  False  False\n",
        "2011-10-28  38.79  39.49  37.74  38.86   1652100      38.48      1026620   True  False  False\n",
        "2011-10-31  38.32  38.67  37.41  37.68   1156600      37.31      1034205   True  False  False\n",
        "2011-11-01  36.60  38.55  36.57  37.92   1556100      37.55      1070670   True  False  False\n",
        "2011-11-02  36.59  37.46  36.05  36.89   1304700      36.53      1087550   True  False  False\n",
        "2011-11-03  37.48  38.65  37.27  38.26   1360700      37.88      1115610   True  False  False\n",
        "2011-11-04  37.75  38.36  37.51  37.93    857000      37.56      1123405  False   True  False\n",
        "2011-11-07  38.74  38.74  37.48  37.95    855800      37.58      1135365  False   True  False\n",
        "2011-11-08  38.16  38.42  36.84  38.05    812800      37.68      1158265  False   True  False\n",
        "2011-11-09  37.32  37.44  36.15  36.54    800400      36.18      1154545  False   True  False\n",
        "2011-11-10  37.25  37.42  36.09  36.28    753600      35.92      1168910  False   True  False\n",
        "2011-11-11  36.77  36.91  36.21  36.46    846300      36.10      1184570  False   True  False\n",
        "2011-11-14  36.39  36.77  35.84  36.28    715800      35.92      1162585  False   True  False\n",
        "2011-11-15  36.17  37.04  35.58  36.87    835300      36.51      1167980  False   True  False\n",
        "2011-11-16  36.32  38.00  36.20  37.27   1065700      36.90      1170300  False  False   True\n",
        "2011-11-17  37.00  37.15  35.84  36.03   1366200      35.68      1206050   True  False  False\n",
        "2011-11-18  36.15  36.47  34.96  34.99    855600      34.65      1214445  False   True  False\n",
        "2011-11-21  34.36  34.50  33.65  33.71   1227500      33.38      1217855  False  False   True\n",
        "2011-11-22  33.66  33.97  33.10  33.72   1058900      33.39      1205490  False   True  False\n",
        "2011-11-23  33.36  33.80  32.99  33.14   1059300      32.81      1085010  False  False   True\n",
        "2011-11-25  33.03  33.61  32.97  33.01    368500      32.69      1025445  False   True  False\n",
        "2011-11-28  34.00  34.21  33.27  33.61    898100      33.28       987745  False  False   True\n",
        "2011-11-29  33.44  33.87  33.08  33.30    734900      32.97       966660  False   True  False\n",
        "2011-11-30  34.27  34.60  33.59  34.51   1471900      34.17       962450   True  False  False\n",
        "2011-12-01  34.40  35.03  33.97  34.71    769000      34.37       935665  False   True  False\n",
        "2011-12-02  35.00  35.82  35.00  35.24   1072100      34.89       921235   True  False  False\n",
        "2011-12-05  35.73  36.12  35.40  35.70    787300      35.35       917750  False   True  False\n",
        "2011-12-06  35.48  35.88  34.99  35.36    660400      35.16       907980  False   True  False\n",
        "2011-12-07  35.06  35.30  34.76  35.11    613500      34.91       898015  False   True  False\n",
        "2011-12-08  34.95  35.03  34.01  34.24    684700      34.05       892230  False   True  False\n",
        "2011-12-09  34.35  35.04  34.29  34.79    449800      34.59       877040  False   True  False\n",
        "2011-12-12  34.33  34.70  33.93  34.35    785700      34.16       874010  False   True  False\n",
        "2011-12-13  34.50  34.82  33.03  33.19    844100      33.00       880425  False  False   True\n",
        "2011-12-14  33.04  33.37  32.73  32.99    616400      32.80       869480  False   True  False\n",
        "2011-12-15  33.38  34.02  33.06  33.78    902700      33.59       861330  False  False   True\n",
        "2011-12-16  34.06  34.20  33.36  34.10    901500      33.91       838095  False  False   True\n",
        "2011-12-19  34.21  35.07  33.81  33.89    590800      33.70       824855  False   True  False\n",
        "2011-12-20  34.57  35.53  34.54  35.33    566000      35.13       791780  False   True  False\n",
        "2011-12-21  35.16  36.66  35.16  36.52    670200      36.31       772345  False   True  False\n",
        "2011-12-22  36.55  37.86  36.55  37.79    717700      37.58       755265  False  False   True\n",
        "2011-12-23  37.85  38.64  37.85  38.50    347100      38.28       754195  False   True  False\n",
        "2011-12-27  38.47  38.87  38.05  38.75    391200      38.53       728850  False   True  False\n",
        "2011-12-28  38.62  39.33  37.81  38.09    492000      37.88       716705  False   True  False\n",
        "2011-12-29  38.09  38.51  37.93  38.41    392700      38.19       662745  False   True  False\n",
        "2011-12-30  38.43  38.65  38.19  38.46    475500      38.24       648070  False   True  False\n",
        "2012-01-03  39.18  39.66  38.70  38.77    672100      38.55       628070  False  False   True\n",
        "2012-01-04  38.63  38.92  37.94  38.87    497900      38.65       613600  False   True  False\n",
        "2012-01-05  38.74  39.47  38.46  39.05    680800      38.83       614620   True  False  False\n",
        "2012-01-06  39.40  41.83  39.29  41.40   1316400      41.17       649765   True  False  False\n",
        "2012-01-09  41.49  41.51  40.72  41.30    666300      41.07       648845  False  False   True\n",
        "2012-01-10  41.95  42.33  41.41  41.87    561800      41.63       654445  False   True  False\n",
        "2012-01-11  41.66  42.17  41.30  42.09    725900      41.85       651455   True  False  False\n",
        "2012-01-12  42.14  42.34  41.68  42.00    418700      41.76       630185  False   True  False\n",
        "2012-01-13  41.75  41.90  41.28  41.67    542300      41.44       626480  False   True  False\n",
        "2012-01-17  42.26  42.37  41.56  41.64    822500      41.41       622470   True  False  False\n",
        "2012-01-18  41.57  41.61  38.60  40.31   2146100      40.08       684700   True  False  False\n",
        "2012-01-19  40.46  41.87  40.44  40.94   1756500      40.71       742985   True  False  False\n",
        "2012-01-20  40.93  40.98  40.24  40.50   1166800      40.27       773025   True  False  False\n",
        "2012-01-23  40.49  40.77  39.74  40.23    791800      40.00       779105  False  False   True\n",
        "2012-01-24  40.13  40.77  39.87  40.51    713500      40.28       778895  False  False   True\n",
        "2012-01-25  40.49  41.10  39.90  41.07    963800      40.84       809730   True  False  False\n",
        "2012-01-26  39.24  41.07  38.93  39.70   1329500      39.48       856645   True  False  False\n",
        "2012-01-27  36.85  38.06  35.46  37.57   2376000      37.36       950845   True  False  False\n",
        "2012-01-30  36.52  37.45  36.43  37.28   1107400      37.07       986580   True  False  False\n",
        "2012-01-31  37.47  38.45  37.32  37.76   1367900      37.55      1031200   True  False  False\n",
        "2012-02-01  38.05  39.06  37.96  38.63    962400      38.41      1045715  False  False   True\n",
        "2012-02-02  38.75  38.97  38.55  38.65   1037800      38.43      1072710  False  False   True\n",
        "2012-02-03  39.14  40.00  38.99  39.12    925100      38.90      1084925  False   True  False\n",
        "2012-02-06  39.00  39.05  37.60  38.43    704500      38.21      1054330  False   True  False\n",
        "2012-02-07  38.28  38.87  38.06  38.52    763900      38.30      1059210  False   True  False\n",
        "2012-02-08  38.68  39.00  37.77  38.92    712200      38.70      1066730  False   True  False\n",
        "2012-02-09  38.91  38.91  38.43  38.84    535600      38.62      1057215  False   True  False\n",
        "2012-02-10  38.61  38.69  38.23  38.56    566900      38.34      1064625  False   True  False\n",
        "2012-02-13  38.71  38.94  38.29  38.61    481700      38.39      1061595  False   True  False\n",
        "2012-02-14  38.49  38.56  37.93  38.08    618800      37.87      1051410  False   True  False\n",
        "2012-02-15  38.25  38.35  37.44  37.51    743600      37.30       981285  False   True  False\n",
        "2012-02-16  37.48  37.53  36.57  36.98   1319900      36.77       959455   True  False  False\n",
        "2012-02-17  37.22  37.83  37.00  37.67    830000      37.46       942615  False   True  False\n",
        "2012-02-21  37.69  37.69  36.44  36.54   1246000      36.33       965325   True  False  False\n",
        "2012-02-22  36.31  37.24  36.27  36.57    976600      36.36       978480  False  False   True\n",
        "2012-02-23  36.50  37.08  36.50  36.72    648000      36.51       962690  False   True  False\n",
        "2012-02-24  36.78  37.20  36.73  36.99    641200      36.78       928275  False   True  False\n",
        "2012-02-27  36.79  36.98  36.48  36.80    882000      36.59       853575  False  False   True\n",
        "2012-02-28  35.29  36.28  35.27  35.41   1612600      35.21       878835   True  False  False\n",
        "2012-02-29  35.40  36.09  35.08  35.53   2877600      35.33       954320   True  False  False\n",
        "2012-03-01  35.53  35.80  35.14  35.59    938000      35.39       953100  False  False   True\n",
        "2012-03-02  35.51  35.75  34.79  34.81    819800      34.61       942200  False   True  False\n",
        "2012-03-05  34.70  34.92  34.54  34.63    846900      34.43       938290  False  False   True\n",
        "2012-03-06  34.37  34.37  33.96  34.09    796000      33.90       942865  False   True  False\n",
        "2012-03-07  34.17  34.76  34.10  34.34    610000      34.15       935170  False   True  False\n",
        "2012-03-08  34.55  34.69  34.41  34.62    705100      34.42       934815  False   True  False\n",
        "2012-03-09  34.62  35.66  34.62  35.28    803000      35.08       948185  False   True  False\n",
        "2012-03-12  35.42  35.48  34.65  34.79    846900      34.59       962185  False   True  False\n",
        "2012-03-13  35.00  35.06  34.71  35.02    553100      34.82       965755  False   True  False\n",
        "2012-03-14  35.03  35.23  34.41  34.61    446000      34.41       957115  False   True  False\n",
        "2012-03-15  34.62  35.76  34.55  35.61    701500      35.41       955010  False   True  False\n",
        "2012-03-16  35.62  36.20  35.62  36.16    880800      35.96       933055  False  False   True\n",
        "2012-03-19  36.20  36.47  35.93  36.26    777400      36.06       930425  False   True  False\n",
        "2012-03-20  36.08  36.21  35.91  36.04    413400      35.84       888795  False   True  False\n",
        "2012-03-21  35.96  36.05  35.70  35.72    425900      35.52       861260  False   True  False\n",
        "2012-03-22  35.57  35.75  35.01  35.15    407900      34.95       849255  False   True  False\n",
        "2012-03-23  35.08  35.17  34.78  35.14    346400      34.94       834515  False   True  False\n",
        "2012-03-26  35.39  35.85  35.35  35.76    440300      35.56       812430  False   True  False\n",
        "2012-03-27  34.96  35.75  34.51  35.69    957500      35.49       779675   True  False  False\n",
        "2012-03-28  35.60  35.60  34.39  34.57    678600      34.38       669725  False  False   True\n",
        "2012-03-29  34.40  34.50  33.90  34.33    707100      34.14       658180  False  False   True\n",
        "2012-03-30  34.50  34.50  33.85  33.87    766700      33.68       655525   True  False  False\n",
        "2012-04-02  33.60  34.61  33.56  34.48    615800      34.29       643970  False  False   True\n",
        "2012-04-03  34.48  34.68  33.85  33.91    660100      33.72       637175  False  False   True\n",
        "2012-04-04  33.73  33.79  33.00  33.09   1068200      32.90       660085   True  False  False\n",
        "2012-04-05  33.05  33.09  32.70  32.85   1044100      32.66       677035   True  False  False\n",
        "2012-04-09  32.54  32.77  31.67  32.09   1045700      31.91       689170   True  False  False\n",
        "2012-04-10  32.06  32.22  31.37  31.43   1065800      31.25       700115   True  False  False\n",
        "2012-04-11  31.76  32.10  31.66  31.71    918800      31.53       718400   True  False  False\n",
        "2012-04-12  31.80  32.56  31.67  32.53   1090300      32.35       750615   True  False  False\n",
        "2012-04-13  32.44  32.55  31.77  31.82    702800      31.64       750680  False  False   True\n",
        "2012-04-16  31.96  31.99  31.50  31.59    961400      31.41       754710   True  False  False\n",
        "2012-04-17  31.78  32.55  31.75  32.26    834800      32.08       757580   True  False  False\n",
        "2012-04-18  32.08  32.24  31.86  32.00    999600      31.82       786890   True  False  False\n",
        "2012-04-19  31.97  32.46  31.90  32.33    721300      32.15       801660  False   True  False\n",
        "2012-04-20  32.52  32.67  32.15  32.26    727700      32.08       817650  False   True  False\n",
        "2012-04-23  32.05  32.10  30.80  31.08   1868700      30.90       893765   True  False  False\n",
        "2012-04-24  31.09  31.09  30.09  30.91   1333400      30.74       938420   True  False  False\n",
        "2012-04-25  30.74  31.03  30.02  30.95   1837500      30.78       982420   True  False  False\n",
        "2012-04-26  30.94  32.56  30.86  32.38   1510300      32.20      1024005   True  False  False\n",
        "2012-04-27  32.50  32.69  31.91  32.11    857300      31.93      1031515  False   True  False\n",
        "2012-04-30  32.06  32.16  31.82  32.15    667100      31.97      1026535  False   True  False\n",
        "2012-05-01  32.15  32.30  31.82  32.04   1037400      31.86      1047615  False  False   True\n",
        "2012-05-02  31.84  32.12  31.71  31.87   1092400      31.69      1069230  False  False   True\n",
        "2012-05-03  31.85  32.24  31.17  31.46    821900      31.28      1056915  False   True  False\n",
        "2012-05-04  31.37  31.81  31.36  31.73    912500      31.55      1050335  False   True  False\n",
        "2012-05-07  31.71  32.09  31.40  31.71   1154900      31.53      1055795  False  False   True\n",
        "2012-05-08  31.60  31.65  30.76  31.01    764200      30.84      1040715  False   True  False\n",
        "2012-05-09  30.60  31.04  30.39  30.85    472300      30.68      1018390  False   True  False\n",
        "2012-05-10  31.01  31.05  30.46  30.67    707900      30.50       999270  False   True  False\n",
        "2012-05-11  30.42  30.60  29.91  29.95    967400      29.78      1012500  False  False   True\n",
        "2012-05-14  29.62  29.96  29.46  29.55    726800      29.38      1000770  False   True  False\n",
        "2012-05-15  29.56  29.70  29.32  29.38    787700      29.21       998415  False   True  False\n",
        "2012-05-16  29.51  29.87  29.45  29.45    691800      29.28       983025  False   True  False\n",
        "2012-05-17  29.44  29.67  29.04  29.05    575500      28.89       975735  False   True  False\n",
        "2012-05-18  29.17  29.40  28.56  28.64    558900      28.48       967295  False   True  False\n",
        "2012-05-21  28.69  28.86  28.16  28.84    589100      28.68       903315  False   True  False\n",
        "2012-05-22  28.92  28.94  27.81  27.94    775900      27.78       875440  False   True  False\n",
        "2012-05-23  27.85  28.32  27.61  28.23    619000      28.07       814515  False   True  False\n",
        "2012-05-24  28.33  28.33  27.69  27.90    685100      27.74       773255  False   True  False\n",
        "2012-05-25  27.91  28.46  27.91  28.22    567800      28.06       758780  False   True  False\n",
        "2012-05-29  28.48  28.97  28.38  28.59    445200      28.43       747685  False   True  False\n",
        "2012-05-30  28.31  28.34  27.27  27.51    730300      27.35       732330  False  False   True\n",
        "2012-05-31  27.48  27.56  26.50  27.33   1264100      27.18       740915   True  False  False\n",
        "2012-06-01  26.49  27.39  26.13  27.01    890200      26.86       744330   True  False  False\n",
        "2012-06-04  27.03  27.66  26.99  27.50   1175700      27.34       757490   True  False  False\n",
        "2012-06-05  27.37  28.19  27.32  28.02   1168500      27.86       758170   True  False  False\n",
        "2012-06-06  28.27  29.46  28.22  28.90    760700      28.74       757995  False  False   True\n",
        "2012-06-07  29.29  29.33  28.62  28.69    491900      28.53       758975  False   True  False\n",
        "2012-06-08  28.69  29.22  28.28  29.06    398700      28.90       743515  False   True  False\n",
        "2012-06-11  29.25  29.40  28.27  28.30    671000      28.14       728695  False  False   True\n",
        "2012-06-12  28.44  28.46  27.22  27.55    961000      27.39       740405   True  False  False\n",
        "2012-06-13  27.47  27.58  26.48  26.58   1042500      26.43       753145   True  False  False\n",
        "2012-06-14  26.54  27.00  26.25  26.66    781300      26.51       757620  False  False   True\n",
        "2012-06-15  26.74  27.08  26.47  26.84    949800      26.69       776335   True  False  False\n",
        "2012-06-18  26.65  26.76  26.35  26.60    951300      26.45       795955   True  False  False\n",
        "2012-06-19  26.67  26.93  26.50  26.85    929800      26.85       812990   True  False  False\n",
        "2012-06-20  27.00  27.88  26.99  27.44   1111100      27.44       829750   True  False  False\n",
        "2012-06-21  27.53  27.61  26.78  26.85    812900      26.85       839445  False  False   True\n",
        "2012-06-22  26.95  27.54  26.70  27.37   1701000      27.37       890240   True  False  False\n",
        "2012-06-25  27.06  27.70  26.92  27.69   1269400      27.69       925320   True  False  False\n",
        "2012-06-26  28.52  29.47  28.22  29.32   1516300      29.32       978875   True  False  False\n",
        "2012-06-27  29.32  29.73  29.25  29.65    917900      29.65       988255  False  False   True\n",
        "2012-06-28  29.44  30.34  29.41  30.30    737700      30.30       961935  False   True  False\n",
        "2012-06-29  30.62  31.00  30.62  30.97    893200      30.97       962085  False  False   True\n",
        "2012-07-02  31.41  31.80  30.47  31.17    992400      31.17       952920  False  False   True\n",
        "2012-07-03  31.11  31.65  31.09  31.58    310400      31.58       910015  False   True  False\n",
        "2012-07-05  31.49  31.65  31.14  31.51    531600      31.51       898560  False   True  False\n",
        "2012-07-06  31.17  31.67  31.17  31.51    350600      31.51       891495  False   True  False\n",
        "2012-07-09  31.26  31.52  30.45  30.81    681900      30.81       905655  False   True  False\n",
        "2012-07-10  31.02  31.21  29.68  29.90    466100      29.90       895410  False   True  False\n",
        "2012-07-11  29.98  30.21  29.67  29.91    693600      29.91       882040  False   True  False\n",
        "2012-07-12  29.68  29.83  29.22  29.59    346000      29.59       847215  False   True  False\n",
        "2012-07-13  29.55  30.04  29.03  29.15    639900      29.15       840145  False   True  False\n",
        "2012-07-16  29.09  29.25  28.91  29.06    599000      29.06       822605  False   True  False\n",
        "2012-07-17  28.80  29.15  28.45  28.59   1024200      28.59       826250   True  False  False\n",
        "2012-07-18  28.54  28.90  28.02  28.32    631100      28.32       811315  False   True  False\n",
        "2012-07-19  28.41  28.78  28.00  28.19    565800      28.19       784050  False   True  False\n",
        "2012-07-20  28.08  28.23  27.71  27.88    609700      27.88       773890  False   True  False\n",
        "2012-07-23  27.54  27.61  27.34  27.56    848600      27.56       731270   True  False  False\n",
        "2012-07-24  19.64  21.06  19.31  20.80  11058200      20.80      1220710   True  False  False\n",
        "2012-07-25  20.80  20.93  20.02  20.64   2341000      20.64      1261945   True  False  False\n",
        "2012-07-26  19.80  20.37  18.15  19.94   3362000      19.94      1384150   True  False  False\n",
        "2012-07-27  20.07  20.42  19.68  19.79   1363600      19.79      1415445  False  False   True\n",
        "2012-07-30  19.75  20.09  18.93  19.04   1629400      19.04      1452255   True  False  False\n",
        "2012-07-31  19.01  19.70  19.00  19.63   1218300      19.63      1463550  False   True  False\n",
        "2012-08-01  19.72  19.79  19.29  19.31   1296600      19.31      1512860  False   True  False\n",
        "2012-08-02  19.09  19.33  18.54  18.66   1644600      18.66      1568510  False  False   True\n",
        "2012-08-03  18.87  18.98  18.34  18.35   1516700      18.35      1626815  False  False   True\n",
        "2012-08-06  18.41  19.71  18.32  19.51   1335500      19.51      1659495  False   True  False\n",
        "2012-08-07  19.61  20.18  19.54  19.64   1558300      19.64      1714105  False  False   True\n",
        "2012-08-08  19.56  20.09  19.19  19.68   1656400      19.68      1762245  False  False   True\n",
        "2012-08-09  19.69  20.02  19.51  19.87   1449800      19.87      1817435  False   True  False\n",
        "2012-08-10  19.13  19.57  18.77  19.23   2739600      19.23      1922420   True  False  False\n",
        "2012-08-13  19.17  19.85  19.14  19.63   1259500      19.63      1955445  False   True  False\n",
        "2012-08-14  19.70  19.87  19.41  19.57   1253200      19.57      1966895  False   True  False\n",
        "2012-08-15  19.55  19.91  19.34  19.86   1019700      19.86      1986325  False   True  False\n",
        "2012-08-16  19.91  20.25  19.73  20.02   1183600      20.02      2017215  False   True  False\n",
        "2012-08-17  19.80  19.98  19.65  19.90   1371000      19.90      2055280  False   True  False\n",
        "2012-08-20  19.81  19.97  19.52  19.93   1397000      19.93      2082700  False   True  False\n",
        "2012-08-21  19.93  20.36  19.93  20.22   1343000      20.22      1596940  False   True  False\n",
        "2012-08-22  20.23  20.29  19.94  20.01   1028200      20.01      1531300  False   True  False\n",
        "2012-08-23  19.99  20.06  19.38  19.43    756100      19.43      1401005  False   True  False\n",
        "2012-08-24  19.43  19.46  18.94  19.02   1201500      19.02      1392900  False   True  False\n",
        "2012-08-27  19.01  19.15  18.79  19.02    776900      19.02      1350275  False   True  False\n",
        "2012-08-28  18.98  19.22  18.93  19.12    621600      19.12      1320440  False   True  False\n",
        "2012-08-29  19.10  19.21  18.52  18.60   1480500      18.60      1329635   True  False  False\n",
        "2012-08-30  18.55  19.14  18.55  18.98   1288400      18.98      1311825  False  False   True\n",
        "2012-08-31  19.09  19.55  19.00  19.31   1391700      19.31      1305575  False  False   True\n",
        "2012-09-04  19.34  19.48  18.61  19.20   1235200      19.20      1300560  False  False   True\n",
        "2012-09-05  19.35  20.32  19.27  20.20   1392100      20.20      1292250  False  False   True\n",
        "2012-09-06  20.23  20.98  20.23  20.50   1874000      20.50      1303130   True  False  False\n",
        "2012-09-07  20.42  21.35  20.26  21.31   1110600      21.31      1286170  False   True  False\n",
        "2012-09-10  21.33  21.55  20.57  20.59   1212300      20.59      1209805  False  False   True\n",
        "2012-09-11  20.64  21.79  20.50  21.65   1205900      21.65      1207125  False  False   True\n",
        "2012-09-12  21.80  22.17  21.58  21.69   1247500      21.69      1206840  False  False   True\n",
        "2012-09-13  21.74  22.49  21.33  22.09   1240800      22.09      1217895  False  False   True\n",
        "2012-09-14  22.53  23.26  22.30  23.02   1283800      23.02      1222905  False  False   True\n",
        "2012-09-17  22.94  23.01  22.54  22.89   1459600      22.89      1227335   True  False  False\n",
        "2012-09-18  22.85  23.33  22.85  23.26   1169100      23.26      1215940  False  False   True\n",
        "2012-09-19  23.15  23.54  23.06  23.32   1065700      23.32      1202075  False   True  False\n",
        "2012-09-20  23.20  23.29  22.87  23.20   1259900      23.20      1213660  False  False   True\n",
        "2012-09-21  23.23  23.36  22.69  23.05   2216700      23.05      1286690   True  False  False\n",
        "2012-09-24  23.03  23.37  22.92  23.18   1580400      23.18      1305635   True  False  False\n",
        "2012-09-25  22.49  23.27  22.19  22.34   2489300      22.34      1391255   True  False  False\n",
        "2012-09-26  22.38  23.04  22.38  22.64   1379300      22.64      1429140  False  False   True\n",
        "2012-09-27  22.78  23.10  22.57  22.88   1168200      22.88      1413525  False   True  False\n",
        "2012-09-28  22.84  23.20  22.35  22.76  18701200      22.76      2284165   True  False  False\n",
        "2012-10-01  22.90  25.02  22.81  24.05   4889200      24.05      2459040   True  False  False\n",
        "2012-10-02  24.15  24.25  23.72  23.97   1716000      23.97      2483080  False   True  False\n",
        "2012-10-03  24.06  24.31  23.27  23.46   1746600      23.46      2500805  False   True  False\n",
        "2012-10-04  23.56  24.09  23.40  23.80   1249200      23.80      2469565  False   True  False\n",
        "2012-10-05  23.88  24.10  23.74  23.88    931900      23.88      2460630  False   True  False\n",
        "2012-10-08  23.75  24.57  23.72  23.95   1314600      23.95      2465745  False   True  False\n",
        "2012-10-09  24.02  24.38  23.85  24.00   1515100      24.00      2481205  False   True  False\n",
        "2012-10-10  23.96  24.31  23.46  23.56   1258700      23.56      2481765  False   True  False\n",
        "2012-10-11  23.77  24.65  23.38  24.28   1080100      24.28      2473730  False   True  False\n",
        "2012-10-12  24.35  24.40  23.30  23.72   1039300      23.72      2461505  False   True  False\n",
        "2012-10-15  23.92  24.23  23.31  23.42   1253300      23.42      2451190  False   True  False\n",
        "2012-10-16  23.54  23.68  22.85  23.21   1988400      23.21      2492155  False   True  False\n",
        "2012-10-17  22.00  22.64  21.79  22.18   4559200      22.18      2666830   True  False  False\n",
        "2012-10-18  22.12  22.54  21.45  21.86   3044500      21.86      2756060   True  False  False\n",
        "2012-10-19  21.80  22.10  21.32  21.55   1512600      21.55      2720855  False   True  False\n",
        "2012-10-22  21.38  22.41  21.38  21.76   1758500      21.76      2729760  False   True  False\n",
        "2012-10-23  21.54  22.14  21.31  21.85   1147400      21.85      2662665  False   True  False\n",
        "2012-10-24  21.85  21.91  21.11  21.18   1524800      21.18      2669940  False   True  False\n",
        "2012-10-25  21.27  21.95  20.37  20.82   2620100      20.82      2742535  False  False   True\n",
        "2012-10-26  23.69  26.68  23.53  26.01   8416400      26.01      2228295   True  False  False\n",
        "2012-10-31  25.96  27.07  25.61  26.26   2670000      26.26      2117335   True  False  False\n",
        "2012-11-01  26.27  26.99  26.15  26.73   1444300      26.73      2103750  False   True  False\n",
        "2012-11-02  26.86  27.06  26.58  26.69   1174000      26.69      2075120  False   True  False\n",
        "2012-11-05  26.91  26.91  26.19  26.30   1404600      26.30      2082890  False   True  False\n",
        "2012-11-06  26.45  27.26  26.23  26.80   1277100      26.80      2100150  False   True  False\n"
       ]
      }
     ],
     "prompt_number": 29
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}