Last active
March 21, 2017 08:46
-
-
Save duyet/a58ef56e17db6c1eea56407a0c4993de to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "cells": [ | |
| { | |
| "cell_type": "code", | |
| "execution_count": 1, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [ | |
| { | |
| "name": "stderr", | |
| "output_type": "stream", | |
| "text": [ | |
| "/home/duyetdev/anaconda2/lib/python2.7/site-packages/ipykernel/__main__.py:13: SettingWithCopyWarning: \n", | |
| "A value is trying to be set on a copy of a slice from a DataFrame.\n", | |
| "Try using .loc[row_indexer,col_indexer] = value instead\n", | |
| "\n", | |
| "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n", | |
| "/home/duyetdev/anaconda2/lib/python2.7/site-packages/ipykernel/__main__.py:22: SettingWithCopyWarning: \n", | |
| "A value is trying to be set on a copy of a slice from a DataFrame.\n", | |
| "Try using .loc[row_indexer,col_indexer] = value instead\n", | |
| "\n", | |
| "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n", | |
| "/home/duyetdev/anaconda2/lib/python2.7/site-packages/ipykernel/__main__.py:23: SettingWithCopyWarning: \n", | |
| "A value is trying to be set on a copy of a slice from a DataFrame.\n", | |
| "Try using .loc[row_indexer,col_indexer] = value instead\n", | |
| "\n", | |
| "See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n" | |
| ] | |
| } | |
| ], | |
| "source": [ | |
| "import re\n", | |
| "import htmldom\n", | |
| "import urllib2\n", | |
| "import datetime as dt\n", | |
| "import pandas as pd\n", | |
| "import numpy as np\n", | |
| "pd.set_option('display.max_columns', 10)\n", | |
| "\n", | |
| "data = pd.read_json('marketWatch_news.json')\n", | |
| "raw_data = data[[ 'Abstract', 'Author', 'HeadlineText', 'BodyHeadlineText', \n", | |
| " 'Breaking', 'Channel2', 'Column', 'Opinion', 'Provider',\n", | |
| " 'Resurfaced', 'SeoHeadlineFragment', 'ThirdPartyUrl', 'TimestampUtc']]\n", | |
| "raw_data['URL'] = 'http://www.marketwatch.com/story' + raw_data.SeoHeadlineFragment\n", | |
| "\n", | |
| "def parse_time(t):\n", | |
| " parse = re.findall(r'\\d+', str(t))\n", | |
| " if parse:\n", | |
| " return int(parse[0]) / 1000\n", | |
| " \n", | |
| " return None\n", | |
| " \n", | |
| "raw_data['timestamp'] = raw_data.TimestampUtc.apply(lambda t: parse_time(t))\n", | |
| "raw_data['datetime'] = raw_data.timestamp.apply(lambda t: dt.datetime.fromtimestamp(t))" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 3, | |
| "metadata": { | |
| "collapsed": false | |
| }, | |
| "outputs": [], | |
| "source": [ | |
| "raw_data.to_csv('../gopro-stock-analysis/data/stock_news.csv', index=False, encoding='utf-8')" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": 6, | |
| "metadata": { | |
| "collapsed": false, | |
| "scrolled": false | |
| }, | |
| "outputs": [ | |
| { | |
| "data": { | |
| "text/html": [ | |
| "<div>\n", | |
| "<table border=\"1\" class=\"dataframe\">\n", | |
| " <thead>\n", | |
| " <tr style=\"text-align: right;\">\n", | |
| " <th></th>\n", | |
| " <th>Unnamed: 0</th>\n", | |
| " <th>Abstract</th>\n", | |
| " <th>Author</th>\n", | |
| " <th>HeadlineText</th>\n", | |
| " <th>BodyHeadlineText</th>\n", | |
| " <th>...</th>\n", | |
| " <th>timestamp</th>\n", | |
| " <th>datetime</th>\n", | |
| " <th>stock</th>\n", | |
| " <th>stock.mean</th>\n", | |
| " <th>label</th>\n", | |
| " </tr>\n", | |
| " </thead>\n", | |
| " <tbody>\n", | |
| " <tr>\n", | |
| " <th>0</th>\n", | |
| " <td>1</td>\n", | |
| " <td>It certainly feels like Groundhog Day, meaning the movie about a TV personality who does the same thing over and over.</td>\n", | |
| " <td>Victor Reklaitis</td>\n", | |
| " <td>Dan Loeb’s playbook for investment home runs in the Trump era</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1486044871</td>\n", | |
| " <td>2017-02-02</td>\n", | |
| " <td>10.970000</td>\n", | |
| " <td>9.927273</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1</th>\n", | |
| " <td>2</td>\n", | |
| " <td>GoPro Inc. returned its Karma drone to market Wednesday, three months after the company issued a recall and pulled it from store shelves for battery issues. The $799 Karma was recalled in early November just two weeks after it was released amid complaints from customers that it would suddenly lose power during flight. It was meant to be one of GoPro's bestselling holiday items. However, its delay, along with separate manufacturing issues that affected production of the Hero5, once against raised questions about GoPro's ability to launch new products. In a statement, the company said it identified the Karma power issue as related to the latch mechanism that secured the drone's battery. It redesigned the battery latch with the updated Karma drone to solve the problem. Shares of GoPro fell 1.7% Wednesday morning, pushing them down more than 15% in the past three months. The S&P 500 , by comparison, has risen 8% in the past there months. The company is due to report fourth-quarter earnings after the market closes on Thursday.</td>\n", | |
| " <td>Jennifer Booton</td>\n", | |
| " <td>GoPro returns recalled Karma drone to market</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1485962295</td>\n", | |
| " <td>2017-02-01</td>\n", | |
| " <td>10.570000</td>\n", | |
| " <td>10.041818</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>2</th>\n", | |
| " <td>3</td>\n", | |
| " <td>GoPro Inc. jumped more than 5% in Monday trading despite a down day overall on the market, as BlackRock Inc. disclosed an increase in its holdings of the action-camera company. According to a filing with the Securities and Exchange Commission, BlackRock now owns 6% of GoPro, or more than 6.2 million shares, a million more shares than BlackRock Fund Advisers disclosed in its most recent filing, according to FactSet. GoPro stock has suffered amid holiday-season manufacturing issues for the hardware company, which included the recall of its first drone. GoPro stock has declined more than 21% in the past three months, compared with a gain of 7% for the S&P 500 index in the same time. GoPro plans to release quarterly earnings Thursday.</td>\n", | |
| " <td>Jeremy C. Owens</td>\n", | |
| " <td>GoPro gains as Blackrock increases stake</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1485807910</td>\n", | |
| " <td>2017-01-31</td>\n", | |
| " <td>10.750000</td>\n", | |
| " <td>10.159091</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>3</th>\n", | |
| " <td>4</td>\n", | |
| " <td>Cisco’s acquisition of AppDynamics just hours before its IPO sets the tone for 2017, a year in which market volatility is expected to dictate the terms of IPOs, causing some highly-valued companies to take a valuation cut and others to follow AppDynamics’ route of a sale, analysts say</td>\n", | |
| " <td>Caitlin Huston</td>\n", | |
| " <td>The lessons from Cisco’s at-the-buzzer buy of AppDynamics</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1485377335</td>\n", | |
| " <td>2017-01-26</td>\n", | |
| " <td>10.030000</td>\n", | |
| " <td>10.127273</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>4</th>\n", | |
| " <td>5</td>\n", | |
| " <td>GoPro may have benefited from savvy pivoting by retailers when the</td>\n", | |
| " <td>Jennifer Booton</td>\n", | |
| " <td>GoPro stock soars on report of ‘better-than-feared’ holiday sales</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1485291985</td>\n", | |
| " <td>2017-01-25</td>\n", | |
| " <td>10.000000</td>\n", | |
| " <td>9.968182</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>5</th>\n", | |
| " <td>6</td>\n", | |
| " <td>GoPro stock soars 8% after Pacific Crest raises estimates</td>\n", | |
| " <td>Jennifer Booton</td>\n", | |
| " <td>GoPro stock soars 8% after Pacific Crest raises estimates</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1485285903</td>\n", | |
| " <td>2017-01-25</td>\n", | |
| " <td>10.000000</td>\n", | |
| " <td>9.968182</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>6</th>\n", | |
| " <td>7</td>\n", | |
| " <td>The S&P 500 closed the books on 2016 with a 9.5% rally, its fourth positive year out of the past five. The average investor — not shocker here — couldn’t keep pace. This is especially true out west.</td>\n", | |
| " <td>Shawn Langlois</td>\n", | |
| " <td>More proof as to why the average investor should probably just stick to indexing</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1484172304</td>\n", | |
| " <td>2017-01-12</td>\n", | |
| " <td>9.150000</td>\n", | |
| " <td>9.185000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>7</th>\n", | |
| " <td>8</td>\n", | |
| " <td>Parrot, which makes t?he Bebop consumer drone, announced a plan that could reduce its drone team from 840 employees by 290 people -- about a third of its staff.</td>\n", | |
| " <td>Sally French</td>\n", | |
| " <td>Bebop-maker Parrot to cut a third of its drone staff</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1484000153</td>\n", | |
| " <td>2017-01-10</td>\n", | |
| " <td>9.020000</td>\n", | |
| " <td>9.125000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>8</th>\n", | |
| " <td>9</td>\n", | |
| " <td>GoPro shares down nearly 4% in premarket trade</td>\n", | |
| " <td>Trey Williams</td>\n", | |
| " <td>GoPro shares down nearly 4% in premarket trade</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1483709665</td>\n", | |
| " <td>2017-01-06</td>\n", | |
| " <td>9.070000</td>\n", | |
| " <td>9.054000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>9</th>\n", | |
| " <td>10</td>\n", | |
| " <td>GoPro, Inc. Chief Executive Nick Woodman spoke about the Karma drone on Thursday at the Consumer Electronics Show in Las Vegas, Nevada.</td>\n", | |
| " <td>Sally French</td>\n", | |
| " <td>GoPro CEO Nick Woodman says recalled Karma drone can be fixed with tape</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1483651300</td>\n", | |
| " <td>2017-01-06</td>\n", | |
| " <td>9.070000</td>\n", | |
| " <td>9.054000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>10</th>\n", | |
| " <td>11</td>\n", | |
| " <td>Products announced at CES by image processing company Ambarella provide insight into the direction of the drone marketplace not just this year, but in 2018 and beyond.</td>\n", | |
| " <td>Sally French</td>\n", | |
| " <td>At CES 2017, Ambarella shows what to expect from drones in 2018</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1483630279</td>\n", | |
| " <td>2017-01-05</td>\n", | |
| " <td>9.350000</td>\n", | |
| " <td>9.011000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>11</th>\n", | |
| " <td>12</td>\n", | |
| " <td>The company Wednesday said this year it will resume sales of the Karma, a key component in the company’s plan to diversify beyond action cameras.</td>\n", | |
| " <td>Georgia Wells</td>\n", | |
| " <td>GoPro’s recalled Karma drone gets new life</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1483573864</td>\n", | |
| " <td>2017-01-05</td>\n", | |
| " <td>9.350000</td>\n", | |
| " <td>9.011000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>12</th>\n", | |
| " <td>13</td>\n", | |
| " <td>GoPro Inc. said its board approved an additional $7 million in restructuring costs to pay for layoffs, according to a Securities and Exchange Commission filing late Tuesday. GoPro shares declined 0.6% to $8.85 after hours. The company said the additional funds are on top of the estimated $24 million to $33 million previously disclosed. Back in late November, the action-camera company said it was shedding 15% of its workforce. GoPro expects to account for most of the restructuring costs in the fourth quarter.</td>\n", | |
| " <td>Wallace Witkowski</td>\n", | |
| " <td>GoPro board OKs additional $7 million to pay for layoffs</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1482274977</td>\n", | |
| " <td>2016-12-21</td>\n", | |
| " <td>8.900000</td>\n", | |
| " <td>8.944000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>13</th>\n", | |
| " <td>14</td>\n", | |
| " <td>Overseas sales of Japanese animation rose 79% last year to $288 million, with about half of that increase coming from Chinese buyers. From Naruto to Detective Conan, the WSJ's Eva Tam gives us a look at what anime China likes to watch. Photo: Getty Images</td>\n", | |
| " <td>WSJ.com</td>\n", | |
| " <td>What's China's Favorite Japanese Anime?</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1482062400</td>\n", | |
| " <td>2016-12-18</td>\n", | |
| " <td>9.010000</td>\n", | |
| " <td>8.903000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>14</th>\n", | |
| " <td>15</td>\n", | |
| " <td>Apple Inc. Chief Executive Tim Cook, soon after a negative report about Apple Watch sales, emailed Reuters on Monday to say that Apple stocked the shelves better than ever.</td>\n", | |
| " <td>Jeremy C. Owens</td>\n", | |
| " <td>What Tim Cook really said about Apple Watch</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1481031756</td>\n", | |
| " <td>2016-12-06</td>\n", | |
| " <td>9.750000</td>\n", | |
| " <td>9.470000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>15</th>\n", | |
| " <td>16</td>\n", | |
| " <td>GoPro Inc.’s push to make money from broadcasting its users’ flips and fails has fallen victim to the company’s own failures.</td>\n", | |
| " <td>Caitlin Huston</td>\n", | |
| " <td>GoPro media ambitions take the fall for product fails</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480605098</td>\n", | |
| " <td>2016-12-01</td>\n", | |
| " <td>9.820000</td>\n", | |
| " <td>9.701000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>16</th>\n", | |
| " <td>17</td>\n", | |
| " <td>Google took lots of time before charging into the smartphone business, but the first Android phone engineered and built by Alphabet Inc. appears ready to become one of the prime reasons to buy the company’s stock, according to Morgan Stanley.</td>\n", | |
| " <td>Jennifer Booton</td>\n", | |
| " <td>Google’s Pixel business will be bigger than Fitbit and GoPro combined</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480542441</td>\n", | |
| " <td>2016-12-01</td>\n", | |
| " <td>9.820000</td>\n", | |
| " <td>9.701000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>17</th>\n", | |
| " <td>18</td>\n", | |
| " <td>It has been a wild ride where crude is concerned, with prices soaring to $49 a barrel after news that OPEC struck a deal to cut production.</td>\n", | |
| " <td>Barbara Kollmeyer</td>\n", | |
| " <td>Forget the OPEC deal—oil stocks look ‘dangerous’ whatever happens</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480541303</td>\n", | |
| " <td>2016-12-01</td>\n", | |
| " <td>9.820000</td>\n", | |
| " <td>9.701000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>18</th>\n", | |
| " <td>19</td>\n", | |
| " <td>GoPro Inc. said Wednesday it would reshape its business, cutting about 15% of its workforce and signaling it will pull back on attempts to diversify beyond its core action-camera offerings. The companywide reboot -- which includes the closure of GoPro's entertainment division, facilities reductions and the elimination of more than 200 full-time positions plus the cancellation of open positions -- will reduce 2017 adjusted operating expenses to about $650 million and bring the company back to earning an adjusted profit.</td>\n", | |
| " <td>MarketWatch.com</td>\n", | |
| " <td>GoPro to cut 15% of jobs in restructuring</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480517882</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>19</th>\n", | |
| " <td>20</td>\n", | |
| " <td>Shares of GoPro Inc. jumped 3.3% in premarket trade Wednesday, after the action camera maker announced a restructuring that will include the cutting of 200 jobs, or 15% of its workforce. GoPro said the restructuring, which will include the closing of its entertainment division and facilities reductions, will lower 2017 operating expenses by $735 million as the company aims to return to adjusted profitability in 2017. The company expects to record charges of $24 million to $33 million for the restructuring, including $13 million to $18 million for the job cuts. Tony Bates will depart the company at the end of the year. Separately, GoPro said Black Friday camera sales at U.S. retailers rose over 35% from a year ago. \"Consumer demand for GoPro is solid and we've sharply narrowed our focus to concentrate on our core business,\" said Chief Executive Nicholas Woodman. The stock had tumbled 45% year to date through Tuesday, while the SPDR Technology Select Sector ETF has fun up 12% and the S&P 500 has gained 7.9%.</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro's stock jumps after announcing a 15% workforce reduction as part of restructuring</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480508060</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>20</th>\n", | |
| " <td>21</td>\n", | |
| " <td>GoPro Black Friday U.S. sales for camera unit rose over 35% from a year ago</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro Black Friday U.S. sales for camera unit rose over 35% from a year ago</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507478</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>21</th>\n", | |
| " <td>22</td>\n", | |
| " <td>GoPro stock up 3.8% in premarket trade</td>\n", | |
| " <td>Ciara Linnane</td>\n", | |
| " <td>GoPro stock up 3.8% in premarket trade</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507459</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>22</th>\n", | |
| " <td>23</td>\n", | |
| " <td>GoPro to take charges of $24 mln-$33 mln for the restructuring</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro to take charges of $24 mln-$33 mln for the restructuring</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507441</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>23</th>\n", | |
| " <td>24</td>\n", | |
| " <td>GoPro aims to return to adjusted profitability in 2017</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro aims to return to adjusted profitability in 2017</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507410</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>24</th>\n", | |
| " <td>25</td>\n", | |
| " <td>GoPro restructuring aimed at operating expenses by $735 mln</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro restructuring aimed at operating expenses by $735 mln</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507391</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>25</th>\n", | |
| " <td>26</td>\n", | |
| " <td>GoPro to close entertainment division, reduce facilities and cut 200 jobs as part of restructuring</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro to close entertainment division, reduce facilities and cut 200 jobs as part of restructuring</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507369</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>26</th>\n", | |
| " <td>27</td>\n", | |
| " <td>GoPro to cut 15% of its workforce as part of restructuring</td>\n", | |
| " <td>Tomi Kilgore</td>\n", | |
| " <td>GoPro to cut 15% of its workforce as part of restructuring</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1480507340</td>\n", | |
| " <td>2016-11-30</td>\n", | |
| " <td>9.980000</td>\n", | |
| " <td>9.769000</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>27</th>\n", | |
| " <td>28</td>\n", | |
| " <td>Tech stocks suffered a selloff after Donald Trump was officially named the next president of the U.S.</td>\n", | |
| " <td>Jennifer Booton</td>\n", | |
| " <td>Tech stocks beaten down by uncertainty</td>\n", | |
| " <td>Tech stocks beaten down by uncertainty</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1478726426</td>\n", | |
| " <td>2016-11-10</td>\n", | |
| " <td>10.210000</td>\n", | |
| " <td>10.533636</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>28</th>\n", | |
| " <td>29</td>\n", | |
| " <td>A wild night for the U.S. and the world as Donald Trump swept to office, taking with him the House and the Senate. The outcome few called, but now life goes on and for investors, time to get back to work.</td>\n", | |
| " <td>Barbara Kollmeyer</td>\n", | |
| " <td>Trump’s victory is just the beginning of the shocks for stocks</td>\n", | |
| " <td>Trump’s victory is just the beginning of the shocks for stocks</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1478704173</td>\n", | |
| " <td>2016-11-09</td>\n", | |
| " <td>10.410000</td>\n", | |
| " <td>10.793636</td>\n", | |
| " <td>neg</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>29</th>\n", | |
| " <td>30</td>\n", | |
| " <td>Shares of GoPro Inc. plunge after two downgrades of the company following a recall of its drone.</td>\n", | |
| " <td>Caitlin Huston</td>\n", | |
| " <td>GoPro stock dives following two downgrades, Karma drone recall</td>\n", | |
| " <td>GoPro stock dives following two downgrades, Karma drone recall</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1478703424</td>\n", | |
| " <td>2016-11-09</td>\n", | |
| " <td>10.410000</td>\n", | |
| " <td>10.793636</td>\n", | |
| " <td>neg</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", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1359</th>\n", | |
| " <td>1360</td>\n", | |
| " <td>NEW YORK (MarketWatch) -- GoPro Inc. retreated 4.5% premarket Wednesday, putting the personal-camera maker's stock on track for its first daily loss since its trading debut last week. GoPro shares climbed 103% during four straight sessions, beginning with a jump at the start of trading last Thursday. Read more: How high will GoPro go?</td>\n", | |
| " <td>Ben Eisen</td>\n", | |
| " <td>GoPro slides 4.5% after 4 straight gains since IPO</td>\n", | |
| " <td>GoPro slides 4.5% after 4 straight gains since IPO</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404300844</td>\n", | |
| " <td>2014-07-02</td>\n", | |
| " <td>42.040001</td>\n", | |
| " <td>41.058889</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1360</th>\n", | |
| " <td>1361</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>Ben Eisen</td>\n", | |
| " <td>GoPro slides 4% after 4 straight gains since IPO</td>\n", | |
| " <td>GoPro slides 4% after 4 straight gains since IPO</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404300443</td>\n", | |
| " <td>2014-07-02</td>\n", | |
| " <td>42.040001</td>\n", | |
| " <td>41.058889</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1361</th>\n", | |
| " <td>1362</td>\n", | |
| " <td>We live-blogged all the action in the stock market on Tuesday.</td>\n", | |
| " <td>blogs.marketwatch.com</td>\n", | |
| " <td>Dow ends at record high close but still shy of 17,000: Stock market live blog recap</td>\n", | |
| " <td>Dow ends at record high close but still shy of 17,000: Stock market live blog recap</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404246180</td>\n", | |
| " <td>2014-07-02</td>\n", | |
| " <td>42.040001</td>\n", | |
| " <td>41.058889</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1362</th>\n", | |
| " <td>1363</td>\n", | |
| " <td>Twitter is among Tuesday’s notable gainers while GM snaps losing streak after reporting auto sales rose in June.</td>\n", | |
| " <td>Sue Chang</td>\n", | |
| " <td>Twitter gains on new CFO; GM sales up in June</td>\n", | |
| " <td>Twitter gains on new CFO; GM sales up in June</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404239337</td>\n", | |
| " <td>2014-07-02</td>\n", | |
| " <td>42.040001</td>\n", | |
| " <td>41.058889</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1363</th>\n", | |
| " <td>1364</td>\n", | |
| " <td>Many IPOs will see a significant run up shortly after introduction, but investors must be aware of the signals a stock will give when the initial enthusiasm is gone and price tops out, then falls.</td>\n", | |
| " <td>Tom Lloyd Sr.</td>\n", | |
| " <td>How high will GoPro go?</td>\n", | |
| " <td>How high will GoPro go?</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404234687</td>\n", | |
| " <td>2014-07-02</td>\n", | |
| " <td>42.040001</td>\n", | |
| " <td>41.058889</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1364</th>\n", | |
| " <td>1365</td>\n", | |
| " <td>Time to boycott Belgian waffles, ahead of the big showdown between Team USA and Belgium? If you're bored with the World Cup, check out the best ways to prepare for a late-stage bull market.</td>\n", | |
| " <td>Sara Sjolin</td>\n", | |
| " <td>Belgian-waffle boycott, late-stage bull plays and Muscle Milk</td>\n", | |
| " <td>Belgian-waffle boycott, late-stage bull plays and Muscle Milk</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404213180</td>\n", | |
| " <td>2014-07-01</td>\n", | |
| " <td>48.799999</td>\n", | |
| " <td>40.778750</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1365</th>\n", | |
| " <td>1366</td>\n", | |
| " <td>U.S. stocks end June and the second quarter higher, even as the market closes marginally lower on Monday.</td>\n", | |
| " <td>Anora Mahmudova</td>\n", | |
| " <td>U.S. stocks end strong quarter on sour note</td>\n", | |
| " <td>U.S. stocks end strong quarter on sour note</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404160014</td>\n", | |
| " <td>2014-07-01</td>\n", | |
| " <td>48.799999</td>\n", | |
| " <td>40.778750</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1366</th>\n", | |
| " <td>1367</td>\n", | |
| " <td>We live-blogged all the action Monday in the stock market.</td>\n", | |
| " <td>blogs.marketwatch.com</td>\n", | |
| " <td>S&P 500 posts strongest 2nd quarter since 2009: Stock market live blog recap</td>\n", | |
| " <td>S&P 500 posts strongest 2nd quarter since 2009: Stock market live blog recap</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404160260</td>\n", | |
| " <td>2014-07-01</td>\n", | |
| " <td>48.799999</td>\n", | |
| " <td>40.778750</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1367</th>\n", | |
| " <td>1368</td>\n", | |
| " <td>MannKind Corp. and GoPro Inc. rise Monday, while Yahoo Inc. moves higher on an analyst upgrade.</td>\n", | |
| " <td>Sue Chang</td>\n", | |
| " <td>MannKind, GoPro rise; Yahoo gains on upgrade</td>\n", | |
| " <td>MannKind, GoPro rise; Yahoo gains on upgrade</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404144102</td>\n", | |
| " <td>2014-06-30</td>\n", | |
| " <td>40.549999</td>\n", | |
| " <td>40.575714</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1368</th>\n", | |
| " <td>1369</td>\n", | |
| " <td>If history repeats itself, then the second half should beat the gains already seen in the first six months of the year.</td>\n", | |
| " <td>Sara Sjolin</td>\n", | |
| " <td>Six more bull months ahead, and GoPro keeps on going</td>\n", | |
| " <td>Six more bull months ahead, and GoPro keeps on going</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404132420</td>\n", | |
| " <td>2014-06-30</td>\n", | |
| " <td>40.549999</td>\n", | |
| " <td>40.575714</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1369</th>\n", | |
| " <td>1370</td>\n", | |
| " <td>A big contraction in the economy, GoPro’s IPO and the World Cup led the news, writes Phil van Doorn.</td>\n", | |
| " <td>Philip van Doorn</td>\n", | |
| " <td>10 biggest market-moving events this week</td>\n", | |
| " <td>10 biggest market-moving events this week</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403953259</td>\n", | |
| " <td>2014-06-28</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1370</th>\n", | |
| " <td>1371</td>\n", | |
| " <td>A late-afternoon rally on Wall Street led by tech and small companies sent U.S. stocks into positive territory for the day.</td>\n", | |
| " <td>Anora Mahmudova</td>\n", | |
| " <td>U.S. stocks rally into close; end week lower</td>\n", | |
| " <td>U.S. stocks rally into close; end week lower</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403901871</td>\n", | |
| " <td>2014-06-28</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1371</th>\n", | |
| " <td>1372</td>\n", | |
| " <td>DuPont falls on weaker outlook, Michaels starts trading as a public company.</td>\n", | |
| " <td>Sue Chang</td>\n", | |
| " <td>DuPont falls on outlook; Michaels debuts</td>\n", | |
| " <td>DuPont falls on outlook; Michaels debuts</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403899675</td>\n", | |
| " <td>2014-06-28</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1372</th>\n", | |
| " <td>1373</td>\n", | |
| " <td>U.S. stock futures point to a lower open on Wall Street, poised to build on the prior day’s losses as investors wait for consumer-sentiment data to gauge if the economy is back on a stronger growth track.</td>\n", | |
| " <td>Sara Sjolin</td>\n", | |
| " <td>U.S. stock futures slip; investors await consumer data</td>\n", | |
| " <td>U.S. stock futures slip; investors await consumer data</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403874372</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1373</th>\n", | |
| " <td>1374</td>\n", | |
| " <td>Is GoPro the next Facebook or Twitter? Vote in our poll.</td>\n", | |
| " <td>blogs.marketwatch.com</td>\n", | |
| " <td>Is GoPro IPO the next Facebook — or Twitter? Vote in our poll</td>\n", | |
| " <td>Is GoPro IPO the next Facebook — or Twitter? Vote in our poll</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403823960</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1374</th>\n", | |
| " <td>1375</td>\n", | |
| " <td>We all know real life is catching up to science fiction. So it’s not much of a surprise that drones — amazing technology with a creepy underbelly — are about to go mainstream. Here’s your world with drones, circa 2024.</td>\n", | |
| " <td>Therese Poletti</td>\n", | |
| " <td>Attack of the drones: Invest or run screaming?</td>\n", | |
| " <td>Attack of the drones: Invest or run screaming?</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403822648</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1375</th>\n", | |
| " <td>1376</td>\n", | |
| " <td>Successful digital marketplaces have these things in common, writes Asheesh Advani.</td>\n", | |
| " <td>Asheesh Advani</td>\n", | |
| " <td>4 things GoPro needs to do to succeed</td>\n", | |
| " <td>4 things GoPro needs to do to succeed</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403821115</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1376</th>\n", | |
| " <td>1377</td>\n", | |
| " <td>The surging share price of digital-sport camera maker GoPro garners much of the market’s attention as the company made its public debut, while the broader tech sector is broadly mixed.</td>\n", | |
| " <td>Rex Crum</td>\n", | |
| " <td>GoPro doesn’t disappoint in public debut</td>\n", | |
| " <td>GoPro doesn’t disappoint in public debut</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403814854</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1377</th>\n", | |
| " <td>1378</td>\n", | |
| " <td>The U.S. stock market stages a rebound in the afternoon session, paring most but not all of the losses by the end of the day.</td>\n", | |
| " <td>Anora Mahmudova</td>\n", | |
| " <td>U.S stocks trim losses after late-day rally</td>\n", | |
| " <td>U.S stocks trim losses after late-day rally</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403814672</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1378</th>\n", | |
| " <td>1379</td>\n", | |
| " <td>Iron Mountain and Alcoa rise while Bed Bath & Beyond continues to slide in wake of earnings.</td>\n", | |
| " <td>Sue Chang</td>\n", | |
| " <td>Iron Mountain, Alcoa gain; Bed Bath & Beyond slides</td>\n", | |
| " <td>Iron Mountain, Alcoa gain; Bed Bath & Beyond slides</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403814477</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1379</th>\n", | |
| " <td>1380</td>\n", | |
| " <td>Follow MarketWatch's live blog of the U.S. stock market.</td>\n", | |
| " <td>blogs.marketwatch.com</td>\n", | |
| " <td>S&P 500, Dow slip on Bullard rate comments; GoPro surges: Stock market live blog recap</td>\n", | |
| " <td>S&P 500, Dow slip on Bullard rate comments; GoPro surges: Stock market live blog recap</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403814600</td>\n", | |
| " <td>2014-06-27</td>\n", | |
| " <td>35.759998</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1380</th>\n", | |
| " <td>1381</td>\n", | |
| " <td>The goal of going public is to raise money for a company to invest in its future. GoPro just blew it.</td>\n", | |
| " <td>Cody Willard</td>\n", | |
| " <td>GoPro went amateur on the IPO</td>\n", | |
| " <td>GoPro went amateur on the IPO</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1404327060</td>\n", | |
| " <td>2014-07-03</td>\n", | |
| " <td>41.580002</td>\n", | |
| " <td>41.147000</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1381</th>\n", | |
| " <td>1382</td>\n", | |
| " <td>SAN FRANCISCO (MarketWatch) -- GoPro Inc. shares surged more than 28% to $30.73 as the maker of the popular sport-digital cameras made its debut as a public company Thursday. GoPro shares climbed by more than $6 from the $24-a-share price that the company set late Wednesday. GoPro sold 17.8 million shares in its IPO and raised $427 million with the offering.</td>\n", | |
| " <td>Rex Crum</td>\n", | |
| " <td>GoPro shares climb more than 27% in IPO debut</td>\n", | |
| " <td>GoPro shares climb more than 27% in IPO debut</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403794689</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1382</th>\n", | |
| " <td>1383</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>Sue Chang</td>\n", | |
| " <td>Shares of GoPro surge 22% to $29.20 on debut</td>\n", | |
| " <td>Shares of GoPro surge 22% to $29.20 on debut</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403794305</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1383</th>\n", | |
| " <td>1384</td>\n", | |
| " <td>SAN FRANCISCO (MarketWatch) -- Tech stocks were mixed in early trading Thursday, with most of the notable gainers coming from the Internet sector. Zulily Inc. rose another 5%, to $42, after RBC Capital Markets analyst Mark Mahaney raised his rating on the company to outperform from sector perform. Other gains came from Twitter Inc. and eBay Inc. . Much attention was on the public debut of digital camera maker GoPro Inc. , which was scheduled to begin trading Thursday after setting an IPO price of $24 a share. The Nasdaq Composite Index. fell 18 points to 4,361.</td>\n", | |
| " <td>Rex Crum</td>\n", | |
| " <td>Zulily among Internet gainers; market awaits GoPro debut</td>\n", | |
| " <td>Zulily among Internet gainers; market awaits GoPro debut</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403790363</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1384</th>\n", | |
| " <td>1385</td>\n", | |
| " <td>Futures for U.S. stocks were little changed after the release of economic data that were mostly in line with expectations.</td>\n", | |
| " <td>Carla Mozee</td>\n", | |
| " <td>U.S. stock futures unchanged after data</td>\n", | |
| " <td>U.S. stock futures unchanged after data</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403787370</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1385</th>\n", | |
| " <td>1386</td>\n", | |
| " <td>When the economy chokes out its worse GDP reading since 2009, and all the market can do in response is to churn out another moderate push higher, it's pretty clear this bull train isn't planning on slowing.</td>\n", | |
| " <td>Shawn Langlois</td>\n", | |
| " <td>Greed trumps a weak GDP, but just wait until Sept. 30 rolls around</td>\n", | |
| " <td>Greed trumps a weak GDP, but just wait until Sept. 30 rolls around</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403786280</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1386</th>\n", | |
| " <td>1387</td>\n", | |
| " <td>Among the companies whose shares are expected to see active trade in Thursday’s session are Bed Bath & Beyond, GoPro, and Nike.</td>\n", | |
| " <td>Sue Chang</td>\n", | |
| " <td>Bed Bath & Beyond, GoPro, Nike are stocks to watch</td>\n", | |
| " <td>Bed Bath & Beyond, GoPro, Nike are stocks to watch</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403775024</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1387</th>\n", | |
| " <td>1388</td>\n", | |
| " <td>GoPro’s initial public offering priced at the high end of expectations, people familiar with the deal said, a sign of strong demand for the video camera maker.</td>\n", | |
| " <td>Matt Jarzemsky</td>\n", | |
| " <td>GoPro’s IPO prices at high end of expectations</td>\n", | |
| " <td>GoPro’s IPO prices at high end of expectations</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403737295</td>\n", | |
| " <td>2014-06-26</td>\n", | |
| " <td>31.340000</td>\n", | |
| " <td>40.011666</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " <tr>\n", | |
| " <th>1388</th>\n", | |
| " <td>1389</td>\n", | |
| " <td>This stock market has amazed with its ability to shrug off a steady flow of unsettling global developments. But there's been a rare crack in this unrelenting confidence.</td>\n", | |
| " <td>Shawn Langlois</td>\n", | |
| " <td>Robo-advisors, Syrian strikes and the stock-market shift they signal</td>\n", | |
| " <td>Robo-advisors, Syrian strikes and the stock-market shift they signal</td>\n", | |
| " <td>...</td>\n", | |
| " <td>1403700780</td>\n", | |
| " <td>2014-06-25</td>\n", | |
| " <td>NaN</td>\n", | |
| " <td>39.697999</td>\n", | |
| " <td>pos</td>\n", | |
| " </tr>\n", | |
| " </tbody>\n", | |
| "</table>\n", | |
| "<p>1389 rows × 20 columns</p>\n", | |
| "</div>" | |
| ], | |
| "text/plain": [ | |
| " Unnamed: 0 \\\n", | |
| "0 1 \n", | |
| "1 2 \n", | |
| "2 3 \n", | |
| "3 4 \n", | |
| "4 5 \n", | |
| "5 6 \n", | |
| "6 7 \n", | |
| "7 8 \n", | |
| "8 9 \n", | |
| "9 10 \n", | |
| "10 11 \n", | |
| "11 12 \n", | |
| "12 13 \n", | |
| "13 14 \n", | |
| "14 15 \n", | |
| "15 16 \n", | |
| "16 17 \n", | |
| "17 18 \n", | |
| "18 19 \n", | |
| "19 20 \n", | |
| "20 21 \n", | |
| "21 22 \n", | |
| "22 23 \n", | |
| "23 24 \n", | |
| "24 25 \n", | |
| "25 26 \n", | |
| "26 27 \n", | |
| "27 28 \n", | |
| "28 29 \n", | |
| "29 30 \n", | |
| "... .. \n", | |
| "1359 1360 \n", | |
| "1360 1361 \n", | |
| "1361 1362 \n", | |
| "1362 1363 \n", | |
| "1363 1364 \n", | |
| "1364 1365 \n", | |
| "1365 1366 \n", | |
| "1366 1367 \n", | |
| "1367 1368 \n", | |
| "1368 1369 \n", | |
| "1369 1370 \n", | |
| "1370 1371 \n", | |
| "1371 1372 \n", | |
| "1372 1373 \n", | |
| "1373 1374 \n", | |
| "1374 1375 \n", | |
| "1375 1376 \n", | |
| "1376 1377 \n", | |
| "1377 1378 \n", | |
| "1378 1379 \n", | |
| "1379 1380 \n", | |
| "1380 1381 \n", | |
| "1381 1382 \n", | |
| "1382 1383 \n", | |
| "1383 1384 \n", | |
| "1384 1385 \n", | |
| "1385 1386 \n", | |
| "1386 1387 \n", | |
| "1387 1388 \n", | |
| "1388 1389 \n", | |
| "\n", | |
| " Abstract \\\n", | |
| "0 It certainly feels like Groundhog Day, meaning the movie about a TV personality who does the same thing over and over. \n", | |
| "1 GoPro Inc. returned its Karma drone to market Wednesday, three months after the company issued a recall and pulled it from store shelves for battery issues. The $799 Karma was recalled in early November just two weeks after it was released amid complaints from customers that it would suddenly lose power during flight. It was meant to be one of GoPro's bestselling holiday items. However, its delay, along with separate manufacturing issues that affected production of the Hero5, once against raised questions about GoPro's ability to launch new products. In a statement, the company said it identified the Karma power issue as related to the latch mechanism that secured the drone's battery. It redesigned the battery latch with the updated Karma drone to solve the problem. Shares of GoPro fell 1.7% Wednesday morning, pushing them down more than 15% in the past three months. The S&P 500 , by comparison, has risen 8% in the past there months. The company is due to report fourth-quarter earnings after the market closes on Thursday. \n", | |
| "2 GoPro Inc. jumped more than 5% in Monday trading despite a down day overall on the market, as BlackRock Inc. disclosed an increase in its holdings of the action-camera company. According to a filing with the Securities and Exchange Commission, BlackRock now owns 6% of GoPro, or more than 6.2 million shares, a million more shares than BlackRock Fund Advisers disclosed in its most recent filing, according to FactSet. GoPro stock has suffered amid holiday-season manufacturing issues for the hardware company, which included the recall of its first drone. GoPro stock has declined more than 21% in the past three months, compared with a gain of 7% for the S&P 500 index in the same time. GoPro plans to release quarterly earnings Thursday. \n", | |
| "3 Cisco’s acquisition of AppDynamics just hours before its IPO sets the tone for 2017, a year in which market volatility is expected to dictate the terms of IPOs, causing some highly-valued companies to take a valuation cut and others to follow AppDynamics’ route of a sale, analysts say \n", | |
| "4 GoPro may have benefited from savvy pivoting by retailers when the \n", | |
| "5 GoPro stock soars 8% after Pacific Crest raises estimates \n", | |
| "6 The S&P 500 closed the books on 2016 with a 9.5% rally, its fourth positive year out of the past five. The average investor — not shocker here — couldn’t keep pace. This is especially true out west. \n", | |
| "7 Parrot, which makes t?he Bebop consumer drone, announced a plan that could reduce its drone team from 840 employees by 290 people -- about a third of its staff. \n", | |
| "8 GoPro shares down nearly 4% in premarket trade \n", | |
| "9 GoPro, Inc. Chief Executive Nick Woodman spoke about the Karma drone on Thursday at the Consumer Electronics Show in Las Vegas, Nevada. \n", | |
| "10 Products announced at CES by image processing company Ambarella provide insight into the direction of the drone marketplace not just this year, but in 2018 and beyond. \n", | |
| "11 The company Wednesday said this year it will resume sales of the Karma, a key component in the company’s plan to diversify beyond action cameras. \n", | |
| "12 GoPro Inc. said its board approved an additional $7 million in restructuring costs to pay for layoffs, according to a Securities and Exchange Commission filing late Tuesday. GoPro shares declined 0.6% to $8.85 after hours. The company said the additional funds are on top of the estimated $24 million to $33 million previously disclosed. Back in late November, the action-camera company said it was shedding 15% of its workforce. GoPro expects to account for most of the restructuring costs in the fourth quarter. \n", | |
| "13 Overseas sales of Japanese animation rose 79% last year to $288 million, with about half of that increase coming from Chinese buyers. From Naruto to Detective Conan, the WSJ's Eva Tam gives us a look at what anime China likes to watch. Photo: Getty Images \n", | |
| "14 Apple Inc. Chief Executive Tim Cook, soon after a negative report about Apple Watch sales, emailed Reuters on Monday to say that Apple stocked the shelves better than ever. \n", | |
| "15 GoPro Inc.’s push to make money from broadcasting its users’ flips and fails has fallen victim to the company’s own failures. \n", | |
| "16 Google took lots of time before charging into the smartphone business, but the first Android phone engineered and built by Alphabet Inc. appears ready to become one of the prime reasons to buy the company’s stock, according to Morgan Stanley. \n", | |
| "17 It has been a wild ride where crude is concerned, with prices soaring to $49 a barrel after news that OPEC struck a deal to cut production. \n", | |
| "18 GoPro Inc. said Wednesday it would reshape its business, cutting about 15% of its workforce and signaling it will pull back on attempts to diversify beyond its core action-camera offerings. The companywide reboot -- which includes the closure of GoPro's entertainment division, facilities reductions and the elimination of more than 200 full-time positions plus the cancellation of open positions -- will reduce 2017 adjusted operating expenses to about $650 million and bring the company back to earning an adjusted profit. \n", | |
| "19 Shares of GoPro Inc. jumped 3.3% in premarket trade Wednesday, after the action camera maker announced a restructuring that will include the cutting of 200 jobs, or 15% of its workforce. GoPro said the restructuring, which will include the closing of its entertainment division and facilities reductions, will lower 2017 operating expenses by $735 million as the company aims to return to adjusted profitability in 2017. The company expects to record charges of $24 million to $33 million for the restructuring, including $13 million to $18 million for the job cuts. Tony Bates will depart the company at the end of the year. Separately, GoPro said Black Friday camera sales at U.S. retailers rose over 35% from a year ago. \"Consumer demand for GoPro is solid and we've sharply narrowed our focus to concentrate on our core business,\" said Chief Executive Nicholas Woodman. The stock had tumbled 45% year to date through Tuesday, while the SPDR Technology Select Sector ETF has fun up 12% and the S&P 500 has gained 7.9%. \n", | |
| "20 GoPro Black Friday U.S. sales for camera unit rose over 35% from a year ago \n", | |
| "21 GoPro stock up 3.8% in premarket trade \n", | |
| "22 GoPro to take charges of $24 mln-$33 mln for the restructuring \n", | |
| "23 GoPro aims to return to adjusted profitability in 2017 \n", | |
| "24 GoPro restructuring aimed at operating expenses by $735 mln \n", | |
| "25 GoPro to close entertainment division, reduce facilities and cut 200 jobs as part of restructuring \n", | |
| "26 GoPro to cut 15% of its workforce as part of restructuring \n", | |
| "27 Tech stocks suffered a selloff after Donald Trump was officially named the next president of the U.S. \n", | |
| "28 A wild night for the U.S. and the world as Donald Trump swept to office, taking with him the House and the Senate. The outcome few called, but now life goes on and for investors, time to get back to work. \n", | |
| "29 Shares of GoPro Inc. plunge after two downgrades of the company following a recall of its drone. \n", | |
| "... ... \n", | |
| "1359 NEW YORK (MarketWatch) -- GoPro Inc. retreated 4.5% premarket Wednesday, putting the personal-camera maker's stock on track for its first daily loss since its trading debut last week. GoPro shares climbed 103% during four straight sessions, beginning with a jump at the start of trading last Thursday. Read more: How high will GoPro go? \n", | |
| "1360 NaN \n", | |
| "1361 We live-blogged all the action in the stock market on Tuesday. \n", | |
| "1362 Twitter is among Tuesday’s notable gainers while GM snaps losing streak after reporting auto sales rose in June. \n", | |
| "1363 Many IPOs will see a significant run up shortly after introduction, but investors must be aware of the signals a stock will give when the initial enthusiasm is gone and price tops out, then falls. \n", | |
| "1364 Time to boycott Belgian waffles, ahead of the big showdown between Team USA and Belgium? If you're bored with the World Cup, check out the best ways to prepare for a late-stage bull market. \n", | |
| "1365 U.S. stocks end June and the second quarter higher, even as the market closes marginally lower on Monday. \n", | |
| "1366 We live-blogged all the action Monday in the stock market. \n", | |
| "1367 MannKind Corp. and GoPro Inc. rise Monday, while Yahoo Inc. moves higher on an analyst upgrade. \n", | |
| "1368 If history repeats itself, then the second half should beat the gains already seen in the first six months of the year. \n", | |
| "1369 A big contraction in the economy, GoPro’s IPO and the World Cup led the news, writes Phil van Doorn. \n", | |
| "1370 A late-afternoon rally on Wall Street led by tech and small companies sent U.S. stocks into positive territory for the day. \n", | |
| "1371 DuPont falls on weaker outlook, Michaels starts trading as a public company. \n", | |
| "1372 U.S. stock futures point to a lower open on Wall Street, poised to build on the prior day’s losses as investors wait for consumer-sentiment data to gauge if the economy is back on a stronger growth track. \n", | |
| "1373 Is GoPro the next Facebook or Twitter? Vote in our poll. \n", | |
| "1374 We all know real life is catching up to science fiction. So it’s not much of a surprise that drones — amazing technology with a creepy underbelly — are about to go mainstream. Here’s your world with drones, circa 2024. \n", | |
| "1375 Successful digital marketplaces have these things in common, writes Asheesh Advani. \n", | |
| "1376 The surging share price of digital-sport camera maker GoPro garners much of the market’s attention as the company made its public debut, while the broader tech sector is broadly mixed. \n", | |
| "1377 The U.S. stock market stages a rebound in the afternoon session, paring most but not all of the losses by the end of the day. \n", | |
| "1378 Iron Mountain and Alcoa rise while Bed Bath & Beyond continues to slide in wake of earnings. \n", | |
| "1379 Follow MarketWatch's live blog of the U.S. stock market. \n", | |
| "1380 The goal of going public is to raise money for a company to invest in its future. GoPro just blew it. \n", | |
| "1381 SAN FRANCISCO (MarketWatch) -- GoPro Inc. shares surged more than 28% to $30.73 as the maker of the popular sport-digital cameras made its debut as a public company Thursday. GoPro shares climbed by more than $6 from the $24-a-share price that the company set late Wednesday. GoPro sold 17.8 million shares in its IPO and raised $427 million with the offering. \n", | |
| "1382 NaN \n", | |
| "1383 SAN FRANCISCO (MarketWatch) -- Tech stocks were mixed in early trading Thursday, with most of the notable gainers coming from the Internet sector. Zulily Inc. rose another 5%, to $42, after RBC Capital Markets analyst Mark Mahaney raised his rating on the company to outperform from sector perform. Other gains came from Twitter Inc. and eBay Inc. . Much attention was on the public debut of digital camera maker GoPro Inc. , which was scheduled to begin trading Thursday after setting an IPO price of $24 a share. The Nasdaq Composite Index. fell 18 points to 4,361. \n", | |
| "1384 Futures for U.S. stocks were little changed after the release of economic data that were mostly in line with expectations. \n", | |
| "1385 When the economy chokes out its worse GDP reading since 2009, and all the market can do in response is to churn out another moderate push higher, it's pretty clear this bull train isn't planning on slowing. \n", | |
| "1386 Among the companies whose shares are expected to see active trade in Thursday’s session are Bed Bath & Beyond, GoPro, and Nike. \n", | |
| "1387 GoPro’s initial public offering priced at the high end of expectations, people familiar with the deal said, a sign of strong demand for the video camera maker. \n", | |
| "1388 This stock market has amazed with its ability to shrug off a steady flow of unsettling global developments. But there's been a rare crack in this unrelenting confidence. \n", | |
| "\n", | |
| " Author \\\n", | |
| "0 Victor Reklaitis \n", | |
| "1 Jennifer Booton \n", | |
| "2 Jeremy C. Owens \n", | |
| "3 Caitlin Huston \n", | |
| "4 Jennifer Booton \n", | |
| "5 Jennifer Booton \n", | |
| "6 Shawn Langlois \n", | |
| "7 Sally French \n", | |
| "8 Trey Williams \n", | |
| "9 Sally French \n", | |
| "10 Sally French \n", | |
| "11 Georgia Wells \n", | |
| "12 Wallace Witkowski \n", | |
| "13 WSJ.com \n", | |
| "14 Jeremy C. Owens \n", | |
| "15 Caitlin Huston \n", | |
| "16 Jennifer Booton \n", | |
| "17 Barbara Kollmeyer \n", | |
| "18 MarketWatch.com \n", | |
| "19 Tomi Kilgore \n", | |
| "20 Tomi Kilgore \n", | |
| "21 Ciara Linnane \n", | |
| "22 Tomi Kilgore \n", | |
| "23 Tomi Kilgore \n", | |
| "24 Tomi Kilgore \n", | |
| "25 Tomi Kilgore \n", | |
| "26 Tomi Kilgore \n", | |
| "27 Jennifer Booton \n", | |
| "28 Barbara Kollmeyer \n", | |
| "29 Caitlin Huston \n", | |
| "... ... \n", | |
| "1359 Ben Eisen \n", | |
| "1360 Ben Eisen \n", | |
| "1361 blogs.marketwatch.com \n", | |
| "1362 Sue Chang \n", | |
| "1363 Tom Lloyd Sr. \n", | |
| "1364 Sara Sjolin \n", | |
| "1365 Anora Mahmudova \n", | |
| "1366 blogs.marketwatch.com \n", | |
| "1367 Sue Chang \n", | |
| "1368 Sara Sjolin \n", | |
| "1369 Philip van Doorn \n", | |
| "1370 Anora Mahmudova \n", | |
| "1371 Sue Chang \n", | |
| "1372 Sara Sjolin \n", | |
| "1373 blogs.marketwatch.com \n", | |
| "1374 Therese Poletti \n", | |
| "1375 Asheesh Advani \n", | |
| "1376 Rex Crum \n", | |
| "1377 Anora Mahmudova \n", | |
| "1378 Sue Chang \n", | |
| "1379 blogs.marketwatch.com \n", | |
| "1380 Cody Willard \n", | |
| "1381 Rex Crum \n", | |
| "1382 Sue Chang \n", | |
| "1383 Rex Crum \n", | |
| "1384 Carla Mozee \n", | |
| "1385 Shawn Langlois \n", | |
| "1386 Sue Chang \n", | |
| "1387 Matt Jarzemsky \n", | |
| "1388 Shawn Langlois \n", | |
| "\n", | |
| " HeadlineText \\\n", | |
| "0 Dan Loeb’s playbook for investment home runs in the Trump era \n", | |
| "1 GoPro returns recalled Karma drone to market \n", | |
| "2 GoPro gains as Blackrock increases stake \n", | |
| "3 The lessons from Cisco’s at-the-buzzer buy of AppDynamics \n", | |
| "4 GoPro stock soars on report of ‘better-than-feared’ holiday sales \n", | |
| "5 GoPro stock soars 8% after Pacific Crest raises estimates \n", | |
| "6 More proof as to why the average investor should probably just stick to indexing \n", | |
| "7 Bebop-maker Parrot to cut a third of its drone staff \n", | |
| "8 GoPro shares down nearly 4% in premarket trade \n", | |
| "9 GoPro CEO Nick Woodman says recalled Karma drone can be fixed with tape \n", | |
| "10 At CES 2017, Ambarella shows what to expect from drones in 2018 \n", | |
| "11 GoPro’s recalled Karma drone gets new life \n", | |
| "12 GoPro board OKs additional $7 million to pay for layoffs \n", | |
| "13 What's China's Favorite Japanese Anime? \n", | |
| "14 What Tim Cook really said about Apple Watch \n", | |
| "15 GoPro media ambitions take the fall for product fails \n", | |
| "16 Google’s Pixel business will be bigger than Fitbit and GoPro combined \n", | |
| "17 Forget the OPEC deal—oil stocks look ‘dangerous’ whatever happens \n", | |
| "18 GoPro to cut 15% of jobs in restructuring \n", | |
| "19 GoPro's stock jumps after announcing a 15% workforce reduction as part of restructuring \n", | |
| "20 GoPro Black Friday U.S. sales for camera unit rose over 35% from a year ago \n", | |
| "21 GoPro stock up 3.8% in premarket trade \n", | |
| "22 GoPro to take charges of $24 mln-$33 mln for the restructuring \n", | |
| "23 GoPro aims to return to adjusted profitability in 2017 \n", | |
| "24 GoPro restructuring aimed at operating expenses by $735 mln \n", | |
| "25 GoPro to close entertainment division, reduce facilities and cut 200 jobs as part of restructuring \n", | |
| "26 GoPro to cut 15% of its workforce as part of restructuring \n", | |
| "27 Tech stocks beaten down by uncertainty \n", | |
| "28 Trump’s victory is just the beginning of the shocks for stocks \n", | |
| "29 GoPro stock dives following two downgrades, Karma drone recall \n", | |
| "... ... \n", | |
| "1359 GoPro slides 4.5% after 4 straight gains since IPO \n", | |
| "1360 GoPro slides 4% after 4 straight gains since IPO \n", | |
| "1361 Dow ends at record high close but still shy of 17,000: Stock market live blog recap \n", | |
| "1362 Twitter gains on new CFO; GM sales up in June \n", | |
| "1363 How high will GoPro go? \n", | |
| "1364 Belgian-waffle boycott, late-stage bull plays and Muscle Milk \n", | |
| "1365 U.S. stocks end strong quarter on sour note \n", | |
| "1366 S&P 500 posts strongest 2nd quarter since 2009: Stock market live blog recap \n", | |
| "1367 MannKind, GoPro rise; Yahoo gains on upgrade \n", | |
| "1368 Six more bull months ahead, and GoPro keeps on going \n", | |
| "1369 10 biggest market-moving events this week \n", | |
| "1370 U.S. stocks rally into close; end week lower \n", | |
| "1371 DuPont falls on outlook; Michaels debuts \n", | |
| "1372 U.S. stock futures slip; investors await consumer data \n", | |
| "1373 Is GoPro IPO the next Facebook — or Twitter? Vote in our poll \n", | |
| "1374 Attack of the drones: Invest or run screaming? \n", | |
| "1375 4 things GoPro needs to do to succeed \n", | |
| "1376 GoPro doesn’t disappoint in public debut \n", | |
| "1377 U.S stocks trim losses after late-day rally \n", | |
| "1378 Iron Mountain, Alcoa gain; Bed Bath & Beyond slides \n", | |
| "1379 S&P 500, Dow slip on Bullard rate comments; GoPro surges: Stock market live blog recap \n", | |
| "1380 GoPro went amateur on the IPO \n", | |
| "1381 GoPro shares climb more than 27% in IPO debut \n", | |
| "1382 Shares of GoPro surge 22% to $29.20 on debut \n", | |
| "1383 Zulily among Internet gainers; market awaits GoPro debut \n", | |
| "1384 U.S. stock futures unchanged after data \n", | |
| "1385 Greed trumps a weak GDP, but just wait until Sept. 30 rolls around \n", | |
| "1386 Bed Bath & Beyond, GoPro, Nike are stocks to watch \n", | |
| "1387 GoPro’s IPO prices at high end of expectations \n", | |
| "1388 Robo-advisors, Syrian strikes and the stock-market shift they signal \n", | |
| "\n", | |
| " BodyHeadlineText \\\n", | |
| "0 NaN \n", | |
| "1 NaN \n", | |
| "2 NaN \n", | |
| "3 NaN \n", | |
| "4 NaN \n", | |
| "5 NaN \n", | |
| "6 NaN \n", | |
| "7 NaN \n", | |
| "8 NaN \n", | |
| "9 NaN \n", | |
| "10 NaN \n", | |
| "11 NaN \n", | |
| "12 NaN \n", | |
| "13 NaN \n", | |
| "14 NaN \n", | |
| "15 NaN \n", | |
| "16 NaN \n", | |
| "17 NaN \n", | |
| "18 NaN \n", | |
| "19 NaN \n", | |
| "20 NaN \n", | |
| "21 NaN \n", | |
| "22 NaN \n", | |
| "23 NaN \n", | |
| "24 NaN \n", | |
| "25 NaN \n", | |
| "26 NaN \n", | |
| "27 Tech stocks beaten down by uncertainty \n", | |
| "28 Trump’s victory is just the beginning of the shocks for stocks \n", | |
| "29 GoPro stock dives following two downgrades, Karma drone recall \n", | |
| "... ... \n", | |
| "1359 GoPro slides 4.5% after 4 straight gains since IPO \n", | |
| "1360 GoPro slides 4% after 4 straight gains since IPO \n", | |
| "1361 Dow ends at record high close but still shy of 17,000: Stock market live blog recap \n", | |
| "1362 Twitter gains on new CFO; GM sales up in June \n", | |
| "1363 How high will GoPro go? \n", | |
| "1364 Belgian-waffle boycott, late-stage bull plays and Muscle Milk \n", | |
| "1365 U.S. stocks end strong quarter on sour note \n", | |
| "1366 S&P 500 posts strongest 2nd quarter since 2009: Stock market live blog recap \n", | |
| "1367 MannKind, GoPro rise; Yahoo gains on upgrade \n", | |
| "1368 Six more bull months ahead, and GoPro keeps on going \n", | |
| "1369 10 biggest market-moving events this week \n", | |
| "1370 U.S. stocks rally into close; end week lower \n", | |
| "1371 DuPont falls on outlook; Michaels debuts \n", | |
| "1372 U.S. stock futures slip; investors await consumer data \n", | |
| "1373 Is GoPro IPO the next Facebook — or Twitter? Vote in our poll \n", | |
| "1374 Attack of the drones: Invest or run screaming? \n", | |
| "1375 4 things GoPro needs to do to succeed \n", | |
| "1376 GoPro doesn’t disappoint in public debut \n", | |
| "1377 U.S stocks trim losses after late-day rally \n", | |
| "1378 Iron Mountain, Alcoa gain; Bed Bath & Beyond slides \n", | |
| "1379 S&P 500, Dow slip on Bullard rate comments; GoPro surges: Stock market live blog recap \n", | |
| "1380 GoPro went amateur on the IPO \n", | |
| "1381 GoPro shares climb more than 27% in IPO debut \n", | |
| "1382 Shares of GoPro surge 22% to $29.20 on debut \n", | |
| "1383 Zulily among Internet gainers; market awaits GoPro debut \n", | |
| "1384 U.S. stock futures unchanged after data \n", | |
| "1385 Greed trumps a weak GDP, but just wait until Sept. 30 rolls around \n", | |
| "1386 Bed Bath & Beyond, GoPro, Nike are stocks to watch \n", | |
| "1387 GoPro’s IPO prices at high end of expectations \n", | |
| "1388 Robo-advisors, Syrian strikes and the stock-market shift they signal \n", | |
| "\n", | |
| " ... timestamp datetime stock stock.mean label \n", | |
| "0 ... 1486044871 2017-02-02 10.970000 9.927273 neg \n", | |
| "1 ... 1485962295 2017-02-01 10.570000 10.041818 neg \n", | |
| "2 ... 1485807910 2017-01-31 10.750000 10.159091 neg \n", | |
| "3 ... 1485377335 2017-01-26 10.030000 10.127273 pos \n", | |
| "4 ... 1485291985 2017-01-25 10.000000 9.968182 pos \n", | |
| "5 ... 1485285903 2017-01-25 10.000000 9.968182 pos \n", | |
| "6 ... 1484172304 2017-01-12 9.150000 9.185000 pos \n", | |
| "7 ... 1484000153 2017-01-10 9.020000 9.125000 pos \n", | |
| "8 ... 1483709665 2017-01-06 9.070000 9.054000 pos \n", | |
| "9 ... 1483651300 2017-01-06 9.070000 9.054000 pos \n", | |
| "10 ... 1483630279 2017-01-05 9.350000 9.011000 pos \n", | |
| "11 ... 1483573864 2017-01-05 9.350000 9.011000 pos \n", | |
| "12 ... 1482274977 2016-12-21 8.900000 8.944000 pos \n", | |
| "13 ... 1482062400 2016-12-18 9.010000 8.903000 pos \n", | |
| "14 ... 1481031756 2016-12-06 9.750000 9.470000 neg \n", | |
| "15 ... 1480605098 2016-12-01 9.820000 9.701000 neg \n", | |
| "16 ... 1480542441 2016-12-01 9.820000 9.701000 neg \n", | |
| "17 ... 1480541303 2016-12-01 9.820000 9.701000 neg \n", | |
| "18 ... 1480517882 2016-11-30 9.980000 9.769000 neg \n", | |
| "19 ... 1480508060 2016-11-30 9.980000 9.769000 neg \n", | |
| "20 ... 1480507478 2016-11-30 9.980000 9.769000 neg \n", | |
| "21 ... 1480507459 2016-11-30 9.980000 9.769000 neg \n", | |
| "22 ... 1480507441 2016-11-30 9.980000 9.769000 neg \n", | |
| "23 ... 1480507410 2016-11-30 9.980000 9.769000 neg \n", | |
| "24 ... 1480507391 2016-11-30 9.980000 9.769000 neg \n", | |
| "25 ... 1480507369 2016-11-30 9.980000 9.769000 neg \n", | |
| "26 ... 1480507340 2016-11-30 9.980000 9.769000 neg \n", | |
| "27 ... 1478726426 2016-11-10 10.210000 10.533636 neg \n", | |
| "28 ... 1478704173 2016-11-09 10.410000 10.793636 neg \n", | |
| "29 ... 1478703424 2016-11-09 10.410000 10.793636 neg \n", | |
| "... ... ... ... ... ... ... \n", | |
| "1359 ... 1404300844 2014-07-02 42.040001 41.058889 pos \n", | |
| "1360 ... 1404300443 2014-07-02 42.040001 41.058889 pos \n", | |
| "1361 ... 1404246180 2014-07-02 42.040001 41.058889 pos \n", | |
| "1362 ... 1404239337 2014-07-02 42.040001 41.058889 pos \n", | |
| "1363 ... 1404234687 2014-07-02 42.040001 41.058889 pos \n", | |
| "1364 ... 1404213180 2014-07-01 48.799999 40.778750 pos \n", | |
| "1365 ... 1404160014 2014-07-01 48.799999 40.778750 pos \n", | |
| "1366 ... 1404160260 2014-07-01 48.799999 40.778750 pos \n", | |
| "1367 ... 1404144102 2014-06-30 40.549999 40.575714 pos \n", | |
| "1368 ... 1404132420 2014-06-30 40.549999 40.575714 pos \n", | |
| "1369 ... 1403953259 2014-06-28 35.759998 40.011666 pos \n", | |
| "1370 ... 1403901871 2014-06-28 35.759998 40.011666 pos \n", | |
| "1371 ... 1403899675 2014-06-28 35.759998 40.011666 pos \n", | |
| "1372 ... 1403874372 2014-06-27 35.759998 40.011666 pos \n", | |
| "1373 ... 1403823960 2014-06-27 35.759998 40.011666 pos \n", | |
| "1374 ... 1403822648 2014-06-27 35.759998 40.011666 pos \n", | |
| "1375 ... 1403821115 2014-06-27 35.759998 40.011666 pos \n", | |
| "1376 ... 1403814854 2014-06-27 35.759998 40.011666 pos \n", | |
| "1377 ... 1403814672 2014-06-27 35.759998 40.011666 pos \n", | |
| "1378 ... 1403814477 2014-06-27 35.759998 40.011666 pos \n", | |
| "1379 ... 1403814600 2014-06-27 35.759998 40.011666 pos \n", | |
| "1380 ... 1404327060 2014-07-03 41.580002 41.147000 pos \n", | |
| "1381 ... 1403794689 2014-06-26 31.340000 40.011666 pos \n", | |
| "1382 ... 1403794305 2014-06-26 31.340000 40.011666 pos \n", | |
| "1383 ... 1403790363 2014-06-26 31.340000 40.011666 pos \n", | |
| "1384 ... 1403787370 2014-06-26 31.340000 40.011666 pos \n", | |
| "1385 ... 1403786280 2014-06-26 31.340000 40.011666 pos \n", | |
| "1386 ... 1403775024 2014-06-26 31.340000 40.011666 pos \n", | |
| "1387 ... 1403737295 2014-06-26 31.340000 40.011666 pos \n", | |
| "1388 ... 1403700780 2014-06-25 NaN 39.697999 pos \n", | |
| "\n", | |
| "[1389 rows x 20 columns]" | |
| ] | |
| }, | |
| "execution_count": 6, | |
| "metadata": {}, | |
| "output_type": "execute_result" | |
| } | |
| ], | |
| "source": [ | |
| "pd.set_option('display.max_columns', 10)\n", | |
| "pd.set_option('display.max_colwidth', -1)\n", | |
| "d = pd.read_csv('../gopro-stock-analysis/data/stock_news_labeled.csv')\n", | |
| "d" | |
| ] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| }, | |
| { | |
| "cell_type": "code", | |
| "execution_count": null, | |
| "metadata": { | |
| "collapsed": true | |
| }, | |
| "outputs": [], | |
| "source": [] | |
| } | |
| ], | |
| "metadata": { | |
| "anaconda-cloud": {}, | |
| "kernelspec": { | |
| "display_name": "Python [conda root]", | |
| "language": "python", | |
| "name": "conda-root-py" | |
| }, | |
| "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.12" | |
| } | |
| }, | |
| "nbformat": 4, | |
| "nbformat_minor": 1 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment