notebooks/data/eventvestor.earnings_guidance/notebook.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": true
   },
   "source": [
    "# EventVestor: Earnings Guidance\n",
    "\n",
    "In this notebook, we'll take a look at EventVestor's *Earnings Guidance* dataset, available on the [Quantopian Store](https://www.quantopian.com/store). This dataset spans January 01, 2007 through the current day, and documents forward looking earnings guidance provided by companies.\n",
    "\n",
    "### Blaze\n",
    "Before we dig into the data, we want to tell you about how  you generally access Quantopian Store data sets. These datasets are available through an API service known as [Blaze](http://blaze.pydata.org). Blaze provides the Quantopian user with a convenient interface to access very large datasets.\n",
    "\n",
    "Blaze provides an important function for accessing these datasets. Some of these sets are many millions of records. Bringing that data directly into Quantopian Research directly just is not viable. So Blaze allows us to provide a simple querying interface and shift the burden over to the server side.\n",
    "\n",
    "It is common to use Blaze to reduce your dataset in size, convert it over to Pandas and then to use Pandas for further computation, manipulation and visualization.\n",
    "\n",
    "Helpful links:\n",
    "* [Query building for Blaze](http://blaze.pydata.org/en/latest/queries.html)\n",
    "* [Pandas-to-Blaze dictionary](http://blaze.pydata.org/en/latest/rosetta-pandas.html)\n",
    "* [SQL-to-Blaze dictionary](http://blaze.pydata.org/en/latest/rosetta-sql.html).\n",
    "\n",
    "Once you've limited the size of your Blaze object, you can convert it to a Pandas DataFrames using:\n",
    "> `from odo import odo`  \n",
    "> `odo(expr, pandas.DataFrame)`\n",
    "\n",
    "### Free samples and limits\n",
    "One other key caveat: we limit the number of results returned from any given expression to 10,000 to protect against runaway memory usage. To be clear, you have access to all the data server side. We are limiting the size of the responses back from Blaze.\n",
    "\n",
    "There is a *free* version of this dataset as well as a paid one. The free one includes about three years of historical data, though not up to the current day.\n",
    "\n",
    "With preamble in place, let's get started:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# import the dataset\n",
    "from quantopian.interactive.data.eventvestor import earnings_guidance\n",
    "# or if you want to import the free dataset, use:\n",
    "# from quantopian.interactive.data.eventvestor import earnings_guidance_free\n",
    "\n",
    "# import data operations\n",
    "from odo import odo\n",
    "# import other libraries we will use\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dshape(\"\"\"var * {\n",
       "  event_id: ?float64,\n",
       "  asof_date: datetime,\n",
       "  trade_date: ?datetime,\n",
       "  symbol: ?string,\n",
       "  event_type: ?string,\n",
       "  event_headline: ?string,\n",
       "  event_phase: ?string,\n",
       "  guidance_content: ?string,\n",
       "  guidance_gaap: ?string,\n",
       "  guidance_trend: ?string,\n",
       "  guidance_quality: ?string,\n",
       "  fiscal_quarter: ?string,\n",
       "  eps_low: ?float64,\n",
       "  eps_high: ?float64,\n",
       "  revenue_low: ?float64,\n",
       "  revenue_high: ?float64,\n",
       "  netincome_low: ?float64,\n",
       "  netincome_high: ?float64,\n",
       "  fiscal_year: ?string,\n",
       "  annual_trend: ?string,\n",
       "  event_rating: ?float64,\n",
       "  timestamp: datetime,\n",
       "  sid: ?int64\n",
       "  }\"\"\")"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Let's use blaze to understand the data a bit using Blaze dshape()\n",
    "earnings_guidance.dshape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "97769"
      ],
      "text/plain": [
       "97769"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# And how many rows are there?\n",
    "# N.B. we're using a Blaze function to do this, not len()\n",
    "earnings_guidance.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_id</th>\n",
       "      <th>asof_date</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>symbol</th>\n",
       "      <th>event_type</th>\n",
       "      <th>event_headline</th>\n",
       "      <th>event_phase</th>\n",
       "      <th>guidance_content</th>\n",
       "      <th>guidance_gaap</th>\n",
       "      <th>guidance_trend</th>\n",
       "      <th>guidance_quality</th>\n",
       "      <th>fiscal_quarter</th>\n",
       "      <th>eps_low</th>\n",
       "      <th>eps_high</th>\n",
       "      <th>revenue_low</th>\n",
       "      <th>revenue_high</th>\n",
       "      <th>netincome_low</th>\n",
       "      <th>netincome_high</th>\n",
       "      <th>fiscal_year</th>\n",
       "      <th>annual_trend</th>\n",
       "      <th>event_rating</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>sid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>933903</td>\n",
       "      <td>2007-01-02</td>\n",
       "      <td>2007-01-02</td>\n",
       "      <td>INOD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Numerex Raises 4Q and FY 06 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>Open Ended</td>\n",
       "      <td>4Q 06</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>FY 06</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2007-01-03</td>\n",
       "      <td>9581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>138379</td>\n",
       "      <td>2007-01-02</td>\n",
       "      <td>2007-01-03</td>\n",
       "      <td>SLG</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>SL Green Realty Issues FY 07 FFO Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>FY 07</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2007-01-03</td>\n",
       "      <td>17448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>137809</td>\n",
       "      <td>2007-01-03</td>\n",
       "      <td>2007-01-03</td>\n",
       "      <td>AEO</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>American Eagle Raises 4Q 06 EPS Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>Range</td>\n",
       "      <td>4Q 06</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2007-01-04</td>\n",
       "      <td>11086</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "   event_id  asof_date trade_date symbol event_type  \\\n",
       "0    933903 2007-01-02 2007-01-02   INOD   Guidance   \n",
       "1    138379 2007-01-02 2007-01-03    SLG   Guidance   \n",
       "2    137809 2007-01-03 2007-01-03    AEO   Guidance   \n",
       "\n",
       "                              event_headline event_phase guidance_content  \\\n",
       "0       Numerex Raises 4Q and FY 06 Guidance         NaN  Other Financial   \n",
       "1  SL Green Realty Issues FY 07 FFO Guidance         NaN  Other Financial   \n",
       "2   American Eagle Raises 4Q 06 EPS Guidance         NaN              EPS   \n",
       "\n",
       "  guidance_gaap guidance_trend  ...   eps_high revenue_low  revenue_high  \\\n",
       "0          GAAP         Higher  ...       0.00           0             0   \n",
       "1      Non-GAAP            NaN  ...       0.00           0             0   \n",
       "2          GAAP         Higher  ...       0.65           0             0   \n",
       "\n",
       "   netincome_low  netincome_high  fiscal_year  annual_trend  event_rating  \\\n",
       "0              0               0        FY 06        Higher             1   \n",
       "1              0               0        FY 07           New             1   \n",
       "2              0               0          NaN           NaN             1   \n",
       "\n",
       "   timestamp    sid  \n",
       "0 2007-01-03   9581  \n",
       "1 2007-01-03  17448  \n",
       "2 2007-01-04  11086  \n",
       "\n",
       "[3 rows x 23 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Let's see what the data looks like. We'll grab the first three rows.\n",
    "earnings_guidance[:3]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Let's go over the columns:\n",
    "- **event_id**: the unique identifier for this event.\n",
    "- **asof_date**: EventVestor's timestamp of event capture.\n",
    "- **trade_date**: for event announcements made before trading ends, trade_date is the same as event_date. For announcements issued after market close, trade_date is next market open day.\n",
    "- **symbol**: stock ticker symbol of the affected company.\n",
    "- **event_type**: this should always be *Guidance*.\n",
    "- **event_headline**: a brief description of the event\n",
    "- **event_phase**: the inclusion of this field is likely an error on the part of the data vendor. We're currently attempting to resolve this.\n",
    "- **guidance_content**: values include *EPS, EPS & Financial, Operational, Other Financial*\n",
    "- **guidance_gaap**: values include *GAAP, Non-GAAP*\n",
    "- **guidance_trend**: values include *Higher, Lower, Narrows, New, Reiterate, Withdrawal*\n",
    "- **guidance_quality**: values include *Open Ended, Point, Range*\n",
    "- **fiscal_quarter**: fiscal quarter for which guidance is provided\n",
    "- **eps_low**: low end of the quarterly EPS guidance\n",
    "- **eps_high**: high end of the quarterly EPS guidance\n",
    "- **revenue_low**: low end of the quarterly revenue guidance\n",
    "- **revenue_high**: high end of the quarterly revenue guidance\n",
    "- **netincome_low**: low end of the quarterly net income guidance\n",
    "- **netincome_high**: high end of the quarterly net income guidance\n",
    "- **fiscal_year**: fiscal year for which the quarterly guidance is provided\n",
    "- **annual_trend**: the annual guidance trend. Values include *Higher, Lower, Narrows, New, Reiterate, Withdrawal*\n",
    "- **event_rating**: this is always 1. The meaning of this is uncertain.\n",
    "- **timestamp**: this is our timestamp on when we registered the data.\n",
    "- **sid**: the equity's unique identifier. Use this instead of the symbol."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We've done much of the data processing for you. Fields like `timestamp` and `sid` are standardized across all our Store Datasets, so the datasets are easy to combine. We have standardized the `sid` across all our equity databases.\n",
    "\n",
    "We can select columns and rows with ease. Below, we'll fetch all of Apple's entries from 2012."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_id</th>\n",
       "      <th>asof_date</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>symbol</th>\n",
       "      <th>event_type</th>\n",
       "      <th>event_headline</th>\n",
       "      <th>event_phase</th>\n",
       "      <th>guidance_content</th>\n",
       "      <th>guidance_gaap</th>\n",
       "      <th>guidance_trend</th>\n",
       "      <th>guidance_quality</th>\n",
       "      <th>fiscal_quarter</th>\n",
       "      <th>eps_low</th>\n",
       "      <th>eps_high</th>\n",
       "      <th>revenue_low</th>\n",
       "      <th>revenue_high</th>\n",
       "      <th>netincome_low</th>\n",
       "      <th>netincome_high</th>\n",
       "      <th>fiscal_year</th>\n",
       "      <th>annual_trend</th>\n",
       "      <th>event_rating</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>sid</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1385926</td>\n",
       "      <td>2012-01-24</td>\n",
       "      <td>2012-01-25</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Apple Issues 2Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>Point</td>\n",
       "      <td>2Q 12</td>\n",
       "      <td>8.50</td>\n",
       "      <td>8.50</td>\n",
       "      <td>3250</td>\n",
       "      <td>3250</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-25</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1421102</td>\n",
       "      <td>2012-04-24</td>\n",
       "      <td>2012-04-25</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Apple Issues 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>Point</td>\n",
       "      <td>3Q 12</td>\n",
       "      <td>8.68</td>\n",
       "      <td>8.68</td>\n",
       "      <td>34000</td>\n",
       "      <td>34000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-25</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1456501</td>\n",
       "      <td>2012-07-24</td>\n",
       "      <td>2012-07-25</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Apple Issues 4Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>Point</td>\n",
       "      <td>4Q 12</td>\n",
       "      <td>7.65</td>\n",
       "      <td>7.65</td>\n",
       "      <td>34000</td>\n",
       "      <td>34000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-25</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1496798</td>\n",
       "      <td>2012-10-25</td>\n",
       "      <td>2012-10-26</td>\n",
       "      <td>AAPL</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Apple Issues 1Q 13 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>Point</td>\n",
       "      <td>1Q 13</td>\n",
       "      <td>11.75</td>\n",
       "      <td>11.75</td>\n",
       "      <td>5200</td>\n",
       "      <td>5200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-26</td>\n",
       "      <td>24</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>"
      ],
      "text/plain": [
       "   event_id  asof_date trade_date symbol event_type  \\\n",
       "0   1385926 2012-01-24 2012-01-25   AAPL   Guidance   \n",
       "1   1421102 2012-04-24 2012-04-25   AAPL   Guidance   \n",
       "2   1456501 2012-07-24 2012-07-25   AAPL   Guidance   \n",
       "3   1496798 2012-10-25 2012-10-26   AAPL   Guidance   \n",
       "\n",
       "                event_headline event_phase guidance_content guidance_gaap  \\\n",
       "0  Apple Issues 2Q 12 Guidance         NaN  EPS & Financial          GAAP   \n",
       "1  Apple Issues 3Q 12 Guidance         NaN  EPS & Financial          GAAP   \n",
       "2  Apple Issues 4Q 12 Guidance         NaN  EPS & Financial          GAAP   \n",
       "3  Apple Issues 1Q 13 Guidance         NaN  EPS & Financial          GAAP   \n",
       "\n",
       "  guidance_trend ... eps_high revenue_low  revenue_high  netincome_low  \\\n",
       "0            New ...     8.50        3250          3250              0   \n",
       "1            New ...     8.68       34000         34000              0   \n",
       "2            New ...     7.65       34000         34000              0   \n",
       "3            New ...    11.75        5200          5200              0   \n",
       "\n",
       "   netincome_high  fiscal_year  annual_trend  event_rating  timestamp sid  \n",
       "0               0          NaN           NaN             1 2012-01-25  24  \n",
       "1               0          NaN           NaN             1 2012-04-25  24  \n",
       "2               0          NaN           NaN             1 2012-07-25  24  \n",
       "3               0          NaN           NaN             1 2012-10-26  24  \n",
       "\n",
       "[4 rows x 23 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get apple's sid first\n",
    "aapl_sid = symbols('AAPL').sid\n",
    "aapl_earnings = earnings_guidance[('2011-12-31' < earnings_guidance['asof_date']) & (earnings_guidance['asof_date'] <'2013-01-01') & (earnings_guidance.sid==aapl_sid)]\n",
    "# When displaying a Blaze Data Object, the printout is automatically truncated to ten rows.\n",
    "aapl_earnings.sort('asof_date')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Finally, suppose we want a DataFrame of all earnings guidances releases in 2012 in which revenue_low and revenue_high differ. Then we'll compute by how much they differ!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_id</th>\n",
       "      <th>asof_date</th>\n",
       "      <th>trade_date</th>\n",
       "      <th>symbol</th>\n",
       "      <th>event_type</th>\n",
       "      <th>event_headline</th>\n",
       "      <th>event_phase</th>\n",
       "      <th>guidance_content</th>\n",
       "      <th>guidance_gaap</th>\n",
       "      <th>guidance_trend</th>\n",
       "      <th>...</th>\n",
       "      <th>revenue_low</th>\n",
       "      <th>revenue_high</th>\n",
       "      <th>netincome_low</th>\n",
       "      <th>netincome_high</th>\n",
       "      <th>fiscal_year</th>\n",
       "      <th>annual_trend</th>\n",
       "      <th>event_rating</th>\n",
       "      <th>timestamp</th>\n",
       "      <th>sid</th>\n",
       "      <th>revenue_difference</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1930090</td>\n",
       "      <td>2012-07-26</td>\n",
       "      <td>2012-07-26</td>\n",
       "      <td>ATE</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Advantest Corp. Issues 2Q 12 &amp; Narrows FY 12 O...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>72000.00</td>\n",
       "      <td>77000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Narrows</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-27</td>\n",
       "      <td>23052</td>\n",
       "      <td>5000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1496843</td>\n",
       "      <td>2012-10-25</td>\n",
       "      <td>2012-10-26</td>\n",
       "      <td>AMZN</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Amazon.com Issues 4Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>20250.00</td>\n",
       "      <td>22750.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-26</td>\n",
       "      <td>16841</td>\n",
       "      <td>2500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1496029</td>\n",
       "      <td>2012-10-25</td>\n",
       "      <td>2012-10-25</td>\n",
       "      <td>TSM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Taiwan Semiconductor Issues 4Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>129000.00</td>\n",
       "      <td>131000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-26</td>\n",
       "      <td>17773</td>\n",
       "      <td>2000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1490534</td>\n",
       "      <td>2012-09-10</td>\n",
       "      <td>2012-09-10</td>\n",
       "      <td>TSM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Taiwan Semiconductor Raises 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>...</td>\n",
       "      <td>136000.00</td>\n",
       "      <td>138000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-09-11</td>\n",
       "      <td>17773</td>\n",
       "      <td>2000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1454839</td>\n",
       "      <td>2012-07-19</td>\n",
       "      <td>2012-07-19</td>\n",
       "      <td>TSM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Taiwan Semiconductor Issues 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>136000.00</td>\n",
       "      <td>138000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-20</td>\n",
       "      <td>17773</td>\n",
       "      <td>2000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1384154</td>\n",
       "      <td>2012-01-18</td>\n",
       "      <td>2012-01-18</td>\n",
       "      <td>TSM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Taiwan Semiconductor Issues 1Q &amp; FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>103000.00</td>\n",
       "      <td>105000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-19</td>\n",
       "      <td>17773</td>\n",
       "      <td>2000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1423149</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>TSM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Taiwan Semiconductor Issues 2Q &amp; Revises FY 12...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Operational</td>\n",
       "      <td>NaN</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>126000.00</td>\n",
       "      <td>128000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-27</td>\n",
       "      <td>17773</td>\n",
       "      <td>2000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1419797</td>\n",
       "      <td>2012-04-20</td>\n",
       "      <td>2012-04-20</td>\n",
       "      <td>INTU</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Intuit Reaffirms 3Q &amp; FY 12 Earnings Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>Reiterate</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1950.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Reiterate</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-21</td>\n",
       "      <td>8655</td>\n",
       "      <td>1950.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1388974</td>\n",
       "      <td>2012-01-31</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>AMZN</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Amazon Issues 1Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>12000.00</td>\n",
       "      <td>13400.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>16841</td>\n",
       "      <td>1400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1422959</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>2012-04-27</td>\n",
       "      <td>AMZN</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Amazon.com Issues 2Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>11900.00</td>\n",
       "      <td>13300.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-27</td>\n",
       "      <td>16841</td>\n",
       "      <td>1400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1491411</td>\n",
       "      <td>2012-10-16</td>\n",
       "      <td>2012-10-17</td>\n",
       "      <td>INTC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Intel Corp. Issues 4Q and Revises FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>13100.00</td>\n",
       "      <td>14100.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-17</td>\n",
       "      <td>3951</td>\n",
       "      <td>1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1453377</td>\n",
       "      <td>2012-07-17</td>\n",
       "      <td>2012-07-18</td>\n",
       "      <td>INTC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Intel Corp. Issues 3Q and Lowers FY 12 Revenue...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>13800.00</td>\n",
       "      <td>14800.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Lower</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-18</td>\n",
       "      <td>3951</td>\n",
       "      <td>1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1384551</td>\n",
       "      <td>2012-01-19</td>\n",
       "      <td>2012-01-20</td>\n",
       "      <td>INTC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Intel Issues 1Q &amp; FY 12 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>12300.00</td>\n",
       "      <td>13300.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-20</td>\n",
       "      <td>3951</td>\n",
       "      <td>1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1418488</td>\n",
       "      <td>2012-04-17</td>\n",
       "      <td>2012-04-18</td>\n",
       "      <td>INTC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Intel Issues 2Q and Revises FY 12 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>13100.00</td>\n",
       "      <td>14100.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-18</td>\n",
       "      <td>3951</td>\n",
       "      <td>1000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1495917</td>\n",
       "      <td>2012-10-25</td>\n",
       "      <td>2012-10-25</td>\n",
       "      <td>AVT</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Avnet Issues 2Q 13 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5950.00</td>\n",
       "      <td>6650.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-26</td>\n",
       "      <td>661</td>\n",
       "      <td>700.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1387009</td>\n",
       "      <td>2012-01-26</td>\n",
       "      <td>2012-01-26</td>\n",
       "      <td>AVT</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Avnet Issues 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5950.00</td>\n",
       "      <td>6550.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-27</td>\n",
       "      <td>661</td>\n",
       "      <td>600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1467054</td>\n",
       "      <td>2012-08-08</td>\n",
       "      <td>2012-08-08</td>\n",
       "      <td>AVT</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Avnet Issues 1Q 13 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5800.00</td>\n",
       "      <td>6400.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-08-09</td>\n",
       "      <td>661</td>\n",
       "      <td>600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1422463</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>AVT</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Avnet Issues 4Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>6300.00</td>\n",
       "      <td>6900.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-27</td>\n",
       "      <td>661</td>\n",
       "      <td>600.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1459661</td>\n",
       "      <td>2012-07-30</td>\n",
       "      <td>2012-07-30</td>\n",
       "      <td>ARW</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Arrow Electronics Issues 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>4800.00</td>\n",
       "      <td>5200.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3Q 12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-31</td>\n",
       "      <td>538</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1492709</td>\n",
       "      <td>2012-10-18</td>\n",
       "      <td>2012-10-19</td>\n",
       "      <td>FLEX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Flextronics International Issues 3Q 13 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5800.00</td>\n",
       "      <td>6200.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-19</td>\n",
       "      <td>10953</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1389393</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>ARW</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Arrow Electronics Issues 1Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>4670.00</td>\n",
       "      <td>5070.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-02</td>\n",
       "      <td>538</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1424909</td>\n",
       "      <td>2012-05-01</td>\n",
       "      <td>2012-05-01</td>\n",
       "      <td>ARW</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Arrow Electronics Issues 2Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5040.00</td>\n",
       "      <td>5440.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-05-02</td>\n",
       "      <td>538</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1418864</td>\n",
       "      <td>2012-04-18</td>\n",
       "      <td>2012-04-19</td>\n",
       "      <td>QCOM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Qualcomm Issues 3Q &amp; Raises FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>4450.00</td>\n",
       "      <td>4850.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-19</td>\n",
       "      <td>6295</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1454039</td>\n",
       "      <td>2012-07-18</td>\n",
       "      <td>2012-07-19</td>\n",
       "      <td>QCOM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Qualcomm Issues 4Q and Lowers FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>4450.00</td>\n",
       "      <td>4850.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Lower</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-19</td>\n",
       "      <td>6295</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1457395</td>\n",
       "      <td>2012-07-25</td>\n",
       "      <td>2012-07-26</td>\n",
       "      <td>FLEX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Flextronics International Issues 2Q 13 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5900.00</td>\n",
       "      <td>6300.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-26</td>\n",
       "      <td>10953</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1425487</td>\n",
       "      <td>2012-05-01</td>\n",
       "      <td>2012-05-02</td>\n",
       "      <td>FLEX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Flextronics International Issues 1Q 13 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5900.00</td>\n",
       "      <td>6300.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-05-02</td>\n",
       "      <td>10953</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1389626</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>2012-02-02</td>\n",
       "      <td>QCOM</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Qualcomm Issues 2Q and Raises FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>4600.00</td>\n",
       "      <td>5000.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-02</td>\n",
       "      <td>6295</td>\n",
       "      <td>400.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1380315</td>\n",
       "      <td>2012-01-04</td>\n",
       "      <td>2012-01-05</td>\n",
       "      <td>STX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Seagate Technology Raises 3Q 12 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>...</td>\n",
       "      <td>4200.00</td>\n",
       "      <td>4500.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-05</td>\n",
       "      <td>24518</td>\n",
       "      <td>300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1384635</td>\n",
       "      <td>2012-01-19</td>\n",
       "      <td>2012-01-20</td>\n",
       "      <td>FLEX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Flextronics Issues 4Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>6300.00</td>\n",
       "      <td>6600.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-20</td>\n",
       "      <td>10953</td>\n",
       "      <td>300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1419632</td>\n",
       "      <td>2012-04-19</td>\n",
       "      <td>2012-04-19</td>\n",
       "      <td>CVI</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>CVR Energy Issues 1Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>1800.00</td>\n",
       "      <td>2100.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-20</td>\n",
       "      <td>22766</td>\n",
       "      <td>300.00</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\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>1599</th>\n",
       "      <td>1398611</td>\n",
       "      <td>2012-02-21</td>\n",
       "      <td>2012-02-22</td>\n",
       "      <td>ZIXI</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Zix Corp. Issues 1Q and FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>10.00</td>\n",
       "      <td>10.10</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-22</td>\n",
       "      <td>20822</td>\n",
       "      <td>0.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1600</th>\n",
       "      <td>1403341</td>\n",
       "      <td>2012-02-29</td>\n",
       "      <td>2012-03-01</td>\n",
       "      <td>MTZ</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>MasTec Issues 1Q and FY 12 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>0.15</td>\n",
       "      <td>0.17</td>\n",
       "      <td>12.3</td>\n",
       "      <td>14.1</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-03-01</td>\n",
       "      <td>4667</td>\n",
       "      <td>0.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1601</th>\n",
       "      <td>1387298</td>\n",
       "      <td>2012-01-26</td>\n",
       "      <td>2012-01-27</td>\n",
       "      <td>CYS</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>CYS Investments Issues 4Q 11 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-27</td>\n",
       "      <td>38477</td>\n",
       "      <td>-0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1602</th>\n",
       "      <td>1439505</td>\n",
       "      <td>2012-02-14</td>\n",
       "      <td>2012-02-14</td>\n",
       "      <td>KORS</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Michael Kors Holdings Issues 4Q &amp; FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>350.00</td>\n",
       "      <td>335.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-15</td>\n",
       "      <td>42270</td>\n",
       "      <td>-15.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1603</th>\n",
       "      <td>1424617</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>INOD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Innodata Isogen Issues 2Q 12 Revenue Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>21.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-27</td>\n",
       "      <td>9581</td>\n",
       "      <td>-21.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1604</th>\n",
       "      <td>1382294</td>\n",
       "      <td>2012-01-11</td>\n",
       "      <td>2012-01-11</td>\n",
       "      <td>SAAS</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>inContact Issues 4Q 11 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>23.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-12</td>\n",
       "      <td>31137</td>\n",
       "      <td>-23.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1605</th>\n",
       "      <td>1441324</td>\n",
       "      <td>2012-06-06</td>\n",
       "      <td>2012-06-06</td>\n",
       "      <td>AMSC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>American Superconductor Issues 1Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-06-07</td>\n",
       "      <td>393</td>\n",
       "      <td>-26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1606</th>\n",
       "      <td>1393252</td>\n",
       "      <td>2012-02-09</td>\n",
       "      <td>2012-02-09</td>\n",
       "      <td>AMSC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>American Superconductor Updates 4Q 11 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>27.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-10</td>\n",
       "      <td>393</td>\n",
       "      <td>-27.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1607</th>\n",
       "      <td>1391621</td>\n",
       "      <td>2012-02-06</td>\n",
       "      <td>2012-02-07</td>\n",
       "      <td>BDE</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Black Diamond Issues 4Q and Raises FY 11 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 11</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-07</td>\n",
       "      <td>18803</td>\n",
       "      <td>-36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1608</th>\n",
       "      <td>1544306</td>\n",
       "      <td>2012-06-04</td>\n",
       "      <td>2012-06-04</td>\n",
       "      <td>CALL</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>magicJack VocalTec Issues 2Q and Raises FY 12 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-06-05</td>\n",
       "      <td>14457</td>\n",
       "      <td>-36.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1609</th>\n",
       "      <td>1411122</td>\n",
       "      <td>2012-03-20</td>\n",
       "      <td>2012-03-21</td>\n",
       "      <td>FSII</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>FSI International Issues 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>50.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-03-21</td>\n",
       "      <td>3029</td>\n",
       "      <td>-50.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1610</th>\n",
       "      <td>1412014</td>\n",
       "      <td>2012-03-23</td>\n",
       "      <td>2012-03-23</td>\n",
       "      <td>KITD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>KIT digital Reaffirms 1Q and FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>Reiterate</td>\n",
       "      <td>...</td>\n",
       "      <td>72.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Reiterate</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-03-24</td>\n",
       "      <td>30692</td>\n",
       "      <td>-72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1611</th>\n",
       "      <td>1401903</td>\n",
       "      <td>2012-02-27</td>\n",
       "      <td>2012-02-28</td>\n",
       "      <td>KITD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>KIT digital Issues 1Q and Lowers FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>72.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Lower</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-28</td>\n",
       "      <td>30692</td>\n",
       "      <td>-72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1612</th>\n",
       "      <td>1409726</td>\n",
       "      <td>2012-03-15</td>\n",
       "      <td>2012-03-15</td>\n",
       "      <td>KITD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>KIT digital Reaffirms 1Q and FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>Reiterate</td>\n",
       "      <td>...</td>\n",
       "      <td>72.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Reiterate</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-03-16</td>\n",
       "      <td>30692</td>\n",
       "      <td>-72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1613</th>\n",
       "      <td>1490036</td>\n",
       "      <td>2012-10-11</td>\n",
       "      <td>2012-10-12</td>\n",
       "      <td>ET</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>ExactTarget Raises 3Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>...</td>\n",
       "      <td>72.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-10-12</td>\n",
       "      <td>42700</td>\n",
       "      <td>-72.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1614</th>\n",
       "      <td>1391196</td>\n",
       "      <td>2012-02-02</td>\n",
       "      <td>2012-02-02</td>\n",
       "      <td>FTK</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Flotek Industries Issues 4Q and FY 11 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>74.50</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 11</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-03</td>\n",
       "      <td>27496</td>\n",
       "      <td>-74.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1615</th>\n",
       "      <td>1417909</td>\n",
       "      <td>2012-04-16</td>\n",
       "      <td>2012-04-16</td>\n",
       "      <td>FTK</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Flotek Industries Raises 1Q 12 Revenues Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>78.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-17</td>\n",
       "      <td>27496</td>\n",
       "      <td>-78.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1616</th>\n",
       "      <td>1437795</td>\n",
       "      <td>2012-01-24</td>\n",
       "      <td>2012-01-24</td>\n",
       "      <td>FIO</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Fusion-io Issues 3Q &amp; Raises FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>85.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-25</td>\n",
       "      <td>41554</td>\n",
       "      <td>-85.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1617</th>\n",
       "      <td>1443898</td>\n",
       "      <td>2012-05-14</td>\n",
       "      <td>2012-05-14</td>\n",
       "      <td>MPAA</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Motorcar Parts of America Issues 4Q and FY 12 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>90.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-05-15</td>\n",
       "      <td>10992</td>\n",
       "      <td>-90.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1618</th>\n",
       "      <td>1400239</td>\n",
       "      <td>2012-02-23</td>\n",
       "      <td>2012-02-24</td>\n",
       "      <td>WBMD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>WebMD Health Issues 1Q and Updates FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>105.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-24</td>\n",
       "      <td>27669</td>\n",
       "      <td>-105.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1619</th>\n",
       "      <td>1457505</td>\n",
       "      <td>2012-07-25</td>\n",
       "      <td>2012-07-26</td>\n",
       "      <td>CVD</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Covance Issues 3Q and Lowers FY 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>538.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Lower</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-07-26</td>\n",
       "      <td>25396</td>\n",
       "      <td>-538.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1620</th>\n",
       "      <td>1486588</td>\n",
       "      <td>2012-01-06</td>\n",
       "      <td>2012-01-06</td>\n",
       "      <td>VRX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Valeant Pharmaceuticals Issues 4Q and Updates ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>650.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-01-07</td>\n",
       "      <td>10908</td>\n",
       "      <td>-650.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1621</th>\n",
       "      <td>1416853</td>\n",
       "      <td>2012-04-11</td>\n",
       "      <td>2012-04-11</td>\n",
       "      <td>VMW</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>VMware Raises 1Q 12 Guidance</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>...</td>\n",
       "      <td>1040.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-12</td>\n",
       "      <td>34545</td>\n",
       "      <td>-1040.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1622</th>\n",
       "      <td>1392473</td>\n",
       "      <td>2012-02-08</td>\n",
       "      <td>2012-02-08</td>\n",
       "      <td>CTSH</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Cognizant Technology Solutions Issues 1Q and F...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>1700.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>New</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-09</td>\n",
       "      <td>18870</td>\n",
       "      <td>-1700.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1623</th>\n",
       "      <td>1428889</td>\n",
       "      <td>2012-05-07</td>\n",
       "      <td>2012-05-07</td>\n",
       "      <td>CTSH</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Cognizant Technology Solutions Issues 2Q and L...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>1790.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Lower</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-05-08</td>\n",
       "      <td>18870</td>\n",
       "      <td>-1790.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1624</th>\n",
       "      <td>1464692</td>\n",
       "      <td>2012-08-06</td>\n",
       "      <td>2012-08-06</td>\n",
       "      <td>CTSH</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Cognizant Technology Solutions Issues 3Q and R...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>1875.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-08-07</td>\n",
       "      <td>18870</td>\n",
       "      <td>-1875.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1625</th>\n",
       "      <td>1388993</td>\n",
       "      <td>2012-01-31</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>STX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Seagate Technology Raises 3Q 12 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>Higher</td>\n",
       "      <td>...</td>\n",
       "      <td>4300.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>24518</td>\n",
       "      <td>-4300.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1626</th>\n",
       "      <td>1422045</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>2012-04-26</td>\n",
       "      <td>TYC</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Tyco International Issues 3Q and Raises FY 12 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>EPS &amp; Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>4500.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>FY 12</td>\n",
       "      <td>Higher</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-27</td>\n",
       "      <td>7679</td>\n",
       "      <td>-4500.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1627</th>\n",
       "      <td>1433072</td>\n",
       "      <td>2012-04-17</td>\n",
       "      <td>2012-04-17</td>\n",
       "      <td>STX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Seagate Technology Updates 4Q 12 and Calendar ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>Non-GAAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5000.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-04-18</td>\n",
       "      <td>24518</td>\n",
       "      <td>-5000.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1628</th>\n",
       "      <td>1389165</td>\n",
       "      <td>2012-01-31</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>STX</td>\n",
       "      <td>Guidance</td>\n",
       "      <td>Seagate Technology Issues 4Q 12 Outlook</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Other Financial</td>\n",
       "      <td>GAAP</td>\n",
       "      <td>New</td>\n",
       "      <td>...</td>\n",
       "      <td>5000.00</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>2012-02-01</td>\n",
       "      <td>24518</td>\n",
       "      <td>-5000.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1629 rows × 24 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      event_id  asof_date trade_date symbol event_type  \\\n",
       "0      1930090 2012-07-26 2012-07-26    ATE   Guidance   \n",
       "1      1496843 2012-10-25 2012-10-26   AMZN   Guidance   \n",
       "2      1496029 2012-10-25 2012-10-25    TSM   Guidance   \n",
       "3      1490534 2012-09-10 2012-09-10    TSM   Guidance   \n",
       "4      1454839 2012-07-19 2012-07-19    TSM   Guidance   \n",
       "5      1384154 2012-01-18 2012-01-18    TSM   Guidance   \n",
       "6      1423149 2012-04-26 2012-04-26    TSM   Guidance   \n",
       "7      1419797 2012-04-20 2012-04-20   INTU   Guidance   \n",
       "8      1388974 2012-01-31 2012-02-01   AMZN   Guidance   \n",
       "9      1422959 2012-04-26 2012-04-27   AMZN   Guidance   \n",
       "10     1491411 2012-10-16 2012-10-17   INTC   Guidance   \n",
       "11     1453377 2012-07-17 2012-07-18   INTC   Guidance   \n",
       "12     1384551 2012-01-19 2012-01-20   INTC   Guidance   \n",
       "13     1418488 2012-04-17 2012-04-18   INTC   Guidance   \n",
       "14     1495917 2012-10-25 2012-10-25    AVT   Guidance   \n",
       "15     1387009 2012-01-26 2012-01-26    AVT   Guidance   \n",
       "16     1467054 2012-08-08 2012-08-08    AVT   Guidance   \n",
       "17     1422463 2012-04-26 2012-04-26    AVT   Guidance   \n",
       "18     1459661 2012-07-30 2012-07-30    ARW   Guidance   \n",
       "19     1492709 2012-10-18 2012-10-19   FLEX   Guidance   \n",
       "20     1389393 2012-02-01 2012-02-01    ARW   Guidance   \n",
       "21     1424909 2012-05-01 2012-05-01    ARW   Guidance   \n",
       "22     1418864 2012-04-18 2012-04-19   QCOM   Guidance   \n",
       "23     1454039 2012-07-18 2012-07-19   QCOM   Guidance   \n",
       "24     1457395 2012-07-25 2012-07-26   FLEX   Guidance   \n",
       "25     1425487 2012-05-01 2012-05-02   FLEX   Guidance   \n",
       "26     1389626 2012-02-01 2012-02-02   QCOM   Guidance   \n",
       "27     1380315 2012-01-04 2012-01-05    STX   Guidance   \n",
       "28     1384635 2012-01-19 2012-01-20   FLEX   Guidance   \n",
       "29     1419632 2012-04-19 2012-04-19    CVI   Guidance   \n",
       "...        ...        ...        ...    ...        ...   \n",
       "1599   1398611 2012-02-21 2012-02-22   ZIXI   Guidance   \n",
       "1600   1403341 2012-02-29 2012-03-01    MTZ   Guidance   \n",
       "1601   1387298 2012-01-26 2012-01-27    CYS   Guidance   \n",
       "1602   1439505 2012-02-14 2012-02-14   KORS   Guidance   \n",
       "1603   1424617 2012-04-26 2012-04-26   INOD   Guidance   \n",
       "1604   1382294 2012-01-11 2012-01-11   SAAS   Guidance   \n",
       "1605   1441324 2012-06-06 2012-06-06   AMSC   Guidance   \n",
       "1606   1393252 2012-02-09 2012-02-09   AMSC   Guidance   \n",
       "1607   1391621 2012-02-06 2012-02-07    BDE   Guidance   \n",
       "1608   1544306 2012-06-04 2012-06-04   CALL   Guidance   \n",
       "1609   1411122 2012-03-20 2012-03-21   FSII   Guidance   \n",
       "1610   1412014 2012-03-23 2012-03-23   KITD   Guidance   \n",
       "1611   1401903 2012-02-27 2012-02-28   KITD   Guidance   \n",
       "1612   1409726 2012-03-15 2012-03-15   KITD   Guidance   \n",
       "1613   1490036 2012-10-11 2012-10-12     ET   Guidance   \n",
       "1614   1391196 2012-02-02 2012-02-02    FTK   Guidance   \n",
       "1615   1417909 2012-04-16 2012-04-16    FTK   Guidance   \n",
       "1616   1437795 2012-01-24 2012-01-24    FIO   Guidance   \n",
       "1617   1443898 2012-05-14 2012-05-14   MPAA   Guidance   \n",
       "1618   1400239 2012-02-23 2012-02-24   WBMD   Guidance   \n",
       "1619   1457505 2012-07-25 2012-07-26    CVD   Guidance   \n",
       "1620   1486588 2012-01-06 2012-01-06    VRX   Guidance   \n",
       "1621   1416853 2012-04-11 2012-04-11    VMW   Guidance   \n",
       "1622   1392473 2012-02-08 2012-02-08   CTSH   Guidance   \n",
       "1623   1428889 2012-05-07 2012-05-07   CTSH   Guidance   \n",
       "1624   1464692 2012-08-06 2012-08-06   CTSH   Guidance   \n",
       "1625   1388993 2012-01-31 2012-02-01    STX   Guidance   \n",
       "1626   1422045 2012-04-26 2012-04-26    TYC   Guidance   \n",
       "1627   1433072 2012-04-17 2012-04-17    STX   Guidance   \n",
       "1628   1389165 2012-01-31 2012-02-01    STX   Guidance   \n",
       "\n",
       "                                         event_headline event_phase  \\\n",
       "0     Advantest Corp. Issues 2Q 12 & Narrows FY 12 O...         NaN   \n",
       "1                      Amazon.com Issues 4Q 12 Guidance         NaN   \n",
       "2            Taiwan Semiconductor Issues 4Q 12 Guidance         NaN   \n",
       "3            Taiwan Semiconductor Raises 3Q 12 Guidance         NaN   \n",
       "4            Taiwan Semiconductor Issues 3Q 12 Guidance         NaN   \n",
       "5       Taiwan Semiconductor Issues 1Q & FY 12 Guidance         NaN   \n",
       "6     Taiwan Semiconductor Issues 2Q & Revises FY 12...         NaN   \n",
       "7         Intuit Reaffirms 3Q & FY 12 Earnings Guidance         NaN   \n",
       "8                          Amazon Issues 1Q 12 Guidance         NaN   \n",
       "9                      Amazon.com Issues 2Q 12 Guidance         NaN   \n",
       "10     Intel Corp. Issues 4Q and Revises FY 12 Guidance         NaN   \n",
       "11    Intel Corp. Issues 3Q and Lowers FY 12 Revenue...         NaN   \n",
       "12                      Intel Issues 1Q & FY 12 Outlook         NaN   \n",
       "13            Intel Issues 2Q and Revises FY 12 Outlook         NaN   \n",
       "14                          Avnet Issues 2Q 13 Guidance         NaN   \n",
       "15                          Avnet Issues 3Q 12 Guidance         NaN   \n",
       "16                          Avnet Issues 1Q 13 Guidance         NaN   \n",
       "17                          Avnet Issues 4Q 12 Guidance         NaN   \n",
       "18              Arrow Electronics Issues 3Q 12 Guidance         NaN   \n",
       "19      Flextronics International Issues 3Q 13 Guidance         NaN   \n",
       "20              Arrow Electronics Issues 1Q 12 Guidance         NaN   \n",
       "21              Arrow Electronics Issues 2Q 12 Guidance         NaN   \n",
       "22           Qualcomm Issues 3Q & Raises FY 12 Guidance         NaN   \n",
       "23         Qualcomm Issues 4Q and Lowers FY 12 Guidance         NaN   \n",
       "24      Flextronics International Issues 2Q 13 Guidance         NaN   \n",
       "25     Flextronics International Issues 1Q 13 Guidance          NaN   \n",
       "26         Qualcomm Issues 2Q and Raises FY 12 Guidance         NaN   \n",
       "27              Seagate Technology Raises 3Q 12 Outlook         NaN   \n",
       "28                    Flextronics Issues 4Q 12 Guidance         NaN   \n",
       "29                     CVR Energy Issues 1Q 12 Guidance         NaN   \n",
       "...                                                 ...         ...   \n",
       "1599             Zix Corp. Issues 1Q and FY 12 Guidance         NaN   \n",
       "1600                 MasTec Issues 1Q and FY 12 Outlook         NaN   \n",
       "1601              CYS Investments Issues 4Q 11 Guidance         NaN   \n",
       "1602   Michael Kors Holdings Issues 4Q & FY 12 Guidance         NaN   \n",
       "1603      Innodata Isogen Issues 2Q 12 Revenue Guidance         NaN   \n",
       "1604                    inContact Issues 4Q 11 Guidance         NaN   \n",
       "1605      American Superconductor Issues 1Q 12 Guidance         NaN   \n",
       "1606      American Superconductor Updates 4Q 11 Outlook         NaN   \n",
       "1607  Black Diamond Issues 4Q and Raises FY 11 Guidance         NaN   \n",
       "1608  magicJack VocalTec Issues 2Q and Raises FY 12 ...         NaN   \n",
       "1609            FSI International Issues 3Q 12 Guidance         NaN   \n",
       "1610        KIT digital Reaffirms 1Q and FY 12 Guidance         NaN   \n",
       "1611    KIT digital Issues 1Q and Lowers FY 12 Guidance         NaN   \n",
       "1612        KIT digital Reaffirms 1Q and FY 12 Guidance         NaN   \n",
       "1613                  ExactTarget Raises 3Q 12 Guidance         NaN   \n",
       "1614     Flotek Industries Issues 4Q and FY 11 Guidance         NaN   \n",
       "1615   Flotek Industries Raises 1Q 12 Revenues Guidance         NaN   \n",
       "1616        Fusion-io Issues 3Q & Raises FY 12 Guidance         NaN   \n",
       "1617  Motorcar Parts of America Issues 4Q and FY 12 ...         NaN   \n",
       "1618  WebMD Health Issues 1Q and Updates FY 12 Guidance         NaN   \n",
       "1619        Covance Issues 3Q and Lowers FY 12 Guidance         NaN   \n",
       "1620  Valeant Pharmaceuticals Issues 4Q and Updates ...         NaN   \n",
       "1621                       VMware Raises 1Q 12 Guidance         NaN   \n",
       "1622  Cognizant Technology Solutions Issues 1Q and F...         NaN   \n",
       "1623  Cognizant Technology Solutions Issues 2Q and L...         NaN   \n",
       "1624  Cognizant Technology Solutions Issues 3Q and R...         NaN   \n",
       "1625            Seagate Technology Raises 3Q 12 Outlook         NaN   \n",
       "1626  Tyco International Issues 3Q and Raises FY 12 ...         NaN   \n",
       "1627  Seagate Technology Updates 4Q 12 and Calendar ...         NaN   \n",
       "1628            Seagate Technology Issues 4Q 12 Outlook         NaN   \n",
       "\n",
       "     guidance_content guidance_gaap guidance_trend        ...          \\\n",
       "0     Other Financial          GAAP            New        ...           \n",
       "1     Other Financial          GAAP            New        ...           \n",
       "2     Other Financial          GAAP            New        ...           \n",
       "3     Other Financial          GAAP         Higher        ...           \n",
       "4     Other Financial          GAAP            New        ...           \n",
       "5     Other Financial          GAAP            New        ...           \n",
       "6         Operational           NaN            New        ...           \n",
       "7     EPS & Financial          GAAP      Reiterate        ...           \n",
       "8     Other Financial          GAAP            New        ...           \n",
       "9     Other Financial          GAAP            New        ...           \n",
       "10    Other Financial      Non-GAAP            New        ...           \n",
       "11    Other Financial          GAAP            New        ...           \n",
       "12    Other Financial          GAAP            New        ...           \n",
       "13    Other Financial          GAAP            New        ...           \n",
       "14    EPS & Financial      Non-GAAP            New        ...           \n",
       "15    EPS & Financial      Non-GAAP            New        ...           \n",
       "16    EPS & Financial      Non-GAAP            New        ...           \n",
       "17    EPS & Financial      Non-GAAP            New        ...           \n",
       "18    EPS & Financial      Non-GAAP            New        ...           \n",
       "19    EPS & Financial          GAAP            New        ...           \n",
       "20    EPS & Financial      Non-GAAP            New        ...           \n",
       "21    EPS & Financial      Non-GAAP            New        ...           \n",
       "22    EPS & Financial          GAAP            New        ...           \n",
       "23    EPS & Financial          GAAP            New        ...           \n",
       "24    EPS & Financial          GAAP            New        ...           \n",
       "25    EPS & Financial          GAAP            New        ...           \n",
       "26    EPS & Financial          GAAP            New        ...           \n",
       "27    Other Financial      Non-GAAP         Higher        ...           \n",
       "28    EPS & Financial          GAAP            New        ...           \n",
       "29    Other Financial          GAAP            New        ...           \n",
       "...               ...           ...            ...        ...           \n",
       "1599  EPS & Financial      Non-GAAP            New        ...           \n",
       "1600  EPS & Financial          GAAP            New        ...           \n",
       "1601              EPS          GAAP            New        ...           \n",
       "1602  EPS & Financial          GAAP            New        ...           \n",
       "1603  Other Financial          GAAP            New        ...           \n",
       "1604  Other Financial          GAAP            New        ...           \n",
       "1605  EPS & Financial          GAAP            New        ...           \n",
       "1606  EPS & Financial          GAAP            NaN        ...           \n",
       "1607  EPS & Financial          GAAP            New        ...           \n",
       "1608  EPS & Financial          GAAP            New        ...           \n",
       "1609  Other Financial          GAAP            New        ...           \n",
       "1610  EPS & Financial      Non-GAAP      Reiterate        ...           \n",
       "1611  EPS & Financial      Non-GAAP            New        ...           \n",
       "1612  EPS & Financial      Non-GAAP      Reiterate        ...           \n",
       "1613  Other Financial      Non-GAAP         Higher        ...           \n",
       "1614  Other Financial          GAAP            New        ...           \n",
       "1615  Other Financial          GAAP            New        ...           \n",
       "1616  Other Financial      Non-GAAP            New        ...           \n",
       "1617  Other Financial          GAAP            New        ...           \n",
       "1618  Other Financial      Non-GAAP            New        ...           \n",
       "1619  EPS & Financial      Non-GAAP            New        ...           \n",
       "1620  EPS & Financial      Non-GAAP            New        ...           \n",
       "1621  Other Financial          GAAP         Higher        ...           \n",
       "1622  EPS & Financial          GAAP            New        ...           \n",
       "1623  EPS & Financial          GAAP            New        ...           \n",
       "1624  EPS & Financial          GAAP            New        ...           \n",
       "1625  Other Financial          GAAP         Higher        ...           \n",
       "1626  EPS & Financial      Non-GAAP            New        ...           \n",
       "1627  Other Financial      Non-GAAP            NaN        ...           \n",
       "1628  Other Financial          GAAP            New        ...           \n",
       "\n",
       "     revenue_low revenue_high  netincome_low  netincome_high  fiscal_year  \\\n",
       "0       72000.00     77000.00            0.0             0.0        FY 12   \n",
       "1       20250.00     22750.00            0.0             0.0          NaN   \n",
       "2      129000.00    131000.00            0.0             0.0          NaN   \n",
       "3      136000.00    138000.00            0.0             0.0          NaN   \n",
       "4      136000.00    138000.00            0.0             0.0          NaN   \n",
       "5      103000.00    105000.00            0.0             0.0        FY 12   \n",
       "6      126000.00    128000.00            0.0             0.0        FY 12   \n",
       "7           0.00      1950.00            0.0             0.0        FY 12   \n",
       "8       12000.00     13400.00            0.0             0.0          NaN   \n",
       "9       11900.00     13300.00            0.0             0.0          NaN   \n",
       "10      13100.00     14100.00            0.0             0.0        FY 12   \n",
       "11      13800.00     14800.00            0.0             0.0        FY 12   \n",
       "12      12300.00     13300.00            0.0             0.0        FY 12   \n",
       "13      13100.00     14100.00            0.0             0.0        FY 12   \n",
       "14       5950.00      6650.00            0.0             0.0          NaN   \n",
       "15       5950.00      6550.00            0.0             0.0          NaN   \n",
       "16       5800.00      6400.00            0.0             0.0          NaN   \n",
       "17       6300.00      6900.00            0.0             0.0          NaN   \n",
       "18       4800.00      5200.00            0.0             0.0        3Q 12   \n",
       "19       5800.00      6200.00            0.0             0.0          NaN   \n",
       "20       4670.00      5070.00            0.0             0.0          NaN   \n",
       "21       5040.00      5440.00            0.0             0.0          NaN   \n",
       "22       4450.00      4850.00            0.0             0.0        FY 12   \n",
       "23       4450.00      4850.00            0.0             0.0        FY 12   \n",
       "24       5900.00      6300.00            0.0             0.0          NaN   \n",
       "25       5900.00      6300.00            0.0             0.0          NaN   \n",
       "26       4600.00      5000.00            0.0             0.0        FY 12   \n",
       "27       4200.00      4500.00            0.0             0.0          NaN   \n",
       "28       6300.00      6600.00            0.0             0.0          NaN   \n",
       "29       1800.00      2100.00            0.0             0.0          NaN   \n",
       "...          ...          ...            ...             ...          ...   \n",
       "1599       10.00        10.10            0.0             0.0        FY 12   \n",
       "1600        0.15         0.17           12.3            14.1        FY 12   \n",
       "1601        0.55         0.00            0.0             0.0          NaN   \n",
       "1602      350.00       335.00            0.0             0.0        FY 12   \n",
       "1603       21.00         0.00            0.0             0.0          NaN   \n",
       "1604       23.50         0.00            0.0             0.0          NaN   \n",
       "1605       26.00         0.00            0.0            10.0          NaN   \n",
       "1606       27.00         0.00          -24.0             0.0          NaN   \n",
       "1607       36.00         0.00            0.0             0.0        FY 11   \n",
       "1608       36.00         0.00            0.0             0.0        FY 12   \n",
       "1609       50.00         0.00            7.0             9.0          NaN   \n",
       "1610       72.00         0.00            0.0             0.0        FY 12   \n",
       "1611       72.00         0.00            0.0             0.0        FY 12   \n",
       "1612       72.00         0.00            0.0             0.0        FY 12   \n",
       "1613       72.00         0.00           -3.0             0.0          NaN   \n",
       "1614       74.50         0.00            0.0             0.0        FY 11   \n",
       "1615       78.00         0.00            0.0             0.0          NaN   \n",
       "1616       85.00         0.00            0.0             0.0        FY 12   \n",
       "1617       90.00         0.00            0.0             0.0        FY 12   \n",
       "1618      105.00         0.00            0.0             0.0        FY 12   \n",
       "1619      538.00         0.00            0.0             0.0        FY 12   \n",
       "1620      650.00         0.00            0.0             0.0        FY 11   \n",
       "1621     1040.00         0.00            0.0             0.0          NaN   \n",
       "1622     1700.00         0.00            0.0             0.0        FY 12   \n",
       "1623     1790.00         0.00            0.0             0.0        FY 12   \n",
       "1624     1875.00         0.00            0.0             0.0        FY 12   \n",
       "1625     4300.00         0.00            0.0             0.0          NaN   \n",
       "1626     4500.00         0.00            0.0             0.0        FY 12   \n",
       "1627     5000.00         0.00            0.0             0.0          NaN   \n",
       "1628     5000.00         0.00            0.0             0.0          NaN   \n",
       "\n",
       "      annual_trend  event_rating  timestamp    sid revenue_difference  \n",
       "0          Narrows             1 2012-07-27  23052            5000.00  \n",
       "1              NaN             1 2012-10-26  16841            2500.00  \n",
       "2              NaN             1 2012-10-26  17773            2000.00  \n",
       "3              NaN             1 2012-09-11  17773            2000.00  \n",
       "4              NaN             1 2012-07-20  17773            2000.00  \n",
       "5              New             1 2012-01-19  17773            2000.00  \n",
       "6              NaN             1 2012-04-27  17773            2000.00  \n",
       "7        Reiterate             1 2012-04-21   8655            1950.00  \n",
       "8              NaN             1 2012-02-01  16841            1400.00  \n",
       "9              NaN             1 2012-04-27  16841            1400.00  \n",
       "10             NaN             1 2012-10-17   3951            1000.00  \n",
       "11           Lower             1 2012-07-18   3951            1000.00  \n",
       "12             New             1 2012-01-20   3951            1000.00  \n",
       "13             NaN             1 2012-04-18   3951            1000.00  \n",
       "14             NaN             1 2012-10-26    661             700.00  \n",
       "15             NaN             1 2012-01-27    661             600.00  \n",
       "16             NaN             1 2012-08-09    661             600.00  \n",
       "17             NaN             1 2012-04-27    661             600.00  \n",
       "18             NaN             1 2012-07-31    538             400.00  \n",
       "19             NaN             1 2012-10-19  10953             400.00  \n",
       "20             NaN             1 2012-02-02    538             400.00  \n",
       "21             NaN             1 2012-05-02    538             400.00  \n",
       "22          Higher             1 2012-04-19   6295             400.00  \n",
       "23           Lower             1 2012-07-19   6295             400.00  \n",
       "24             NaN             1 2012-07-26  10953             400.00  \n",
       "25             NaN             1 2012-05-02  10953             400.00  \n",
       "26          Higher             1 2012-02-02   6295             400.00  \n",
       "27             NaN             1 2012-01-05  24518             300.00  \n",
       "28             NaN             1 2012-01-20  10953             300.00  \n",
       "29             NaN             1 2012-04-20  22766             300.00  \n",
       "...            ...           ...        ...    ...                ...  \n",
       "1599           New             1 2012-02-22  20822               0.10  \n",
       "1600           New             1 2012-03-01   4667               0.02  \n",
       "1601           NaN             1 2012-01-27  38477              -0.55  \n",
       "1602           New             1 2012-02-15  42270             -15.00  \n",
       "1603           NaN             1 2012-04-27   9581             -21.00  \n",
       "1604           NaN             1 2012-01-12  31137             -23.50  \n",
       "1605           NaN             1 2012-06-07    393             -26.00  \n",
       "1606           NaN             1 2012-02-10    393             -27.00  \n",
       "1607        Higher             1 2012-02-07  18803             -36.00  \n",
       "1608        Higher             1 2012-06-05  14457             -36.00  \n",
       "1609           NaN             1 2012-03-21   3029             -50.00  \n",
       "1610     Reiterate             1 2012-03-24  30692             -72.00  \n",
       "1611         Lower             1 2012-02-28  30692             -72.00  \n",
       "1612     Reiterate             1 2012-03-16  30692             -72.00  \n",
       "1613           NaN             1 2012-10-12  42700             -72.00  \n",
       "1614           New             1 2012-02-03  27496             -74.50  \n",
       "1615           NaN             1 2012-04-17  27496             -78.00  \n",
       "1616        Higher             1 2012-01-25  41554             -85.00  \n",
       "1617           New             1 2012-05-15  10992             -90.00  \n",
       "1618           NaN             1 2012-02-24  27669            -105.00  \n",
       "1619         Lower             1 2012-07-26  25396            -538.00  \n",
       "1620           NaN             1 2012-01-07  10908            -650.00  \n",
       "1621           NaN             1 2012-04-12  34545           -1040.00  \n",
       "1622           New             1 2012-02-09  18870           -1700.00  \n",
       "1623         Lower             1 2012-05-08  18870           -1790.00  \n",
       "1624        Higher             1 2012-08-07  18870           -1875.00  \n",
       "1625           NaN             1 2012-02-01  24518           -4300.00  \n",
       "1626        Higher             1 2012-04-27   7679           -4500.00  \n",
       "1627           NaN             1 2012-04-18  24518           -5000.00  \n",
       "1628           NaN             1 2012-02-01  24518           -5000.00  \n",
       "\n",
       "[1629 rows x 24 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# manipulate with Blaze first:\n",
    "twentytwelve = earnings_guidance[(earnings_guidance['asof_date'] < '2012-12-31')&('2012-01-01' <= earnings_guidance['asof_date'])]\n",
    "# now that we've got a much smaller object (len: ~39000 rows), we can convert it to a pandas DataFrame\n",
    "df = odo(twentytwelve, pd.DataFrame)\n",
    "df = df[df.revenue_low != df.revenue_high]\n",
    "df['revenue_difference'] = df.revenue_high - df.revenue_low\n",
    "df.sort('revenue_difference', ascending=False, inplace=True)\n",
    "df.index = range(len(df))\n",
    "# When printed: pandas DataFrames display the head(30) and tail(30) rows, and truncate the middle.\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}