In [132]:
# import libs
import json
import pandas as pd
import numpy as np
import scipy as sp
import matplotlib as mpl
import matplotlib.pyplot as plt
%matplotlib inline
import urllib.request # for HTTP requests (web scraping, APIs)
from datetime import datetime, timedelta
import os
from dateutil import parser as dateparser
In [133]:
articles = pd.read_json('small_data.json')
In [134]:
articles['created_at'] = articles.apply((lambda row: dateparser.parse(row.date[0])), axis=1)
In [135]:
articles['updated_at'] = articles.apply((lambda row: dateparser.parse(row.date[1]) if len(row.date) > 1 else None), axis=1)
In [136]:
articles
Out[136]:
article
date
title
url
created_at
updated_at
0
The U.K. is setting up a 2.3 billion pound ($2...
[2016-11-23T13:47:39.184Z]
[U.K. to Set Up $2.9 Billion Fund to Boost New...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 13:47:39.184000+00:00
None
1
The frenzy is about to begin.Thanksgiving mark...
[2016-11-23T11:00:10.031Z]
[Six Things to Watch For on Black Friday]
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 11:00:10.031000+00:00
None
2
Late on Nov. 21, President-elect Donald Trump ...
[2016-11-23T10:00:04.829Z]
[Trump Would Have a Hard Time Divesting His Bu...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 10:00:04.829000+00:00
None
3
Asia’s worst-performing currency since Donald ...
[2016-11-22T21:00:00.003Z]
[Asia’s Worst Currency Slump Takes Malaysian R...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 21:00:00.003000+00:00
None
4
Xerox Corp. has agreed to pay $2.4 million to ...
[2016-11-23T11:00:26.383Z]
[Xerox Overcharged Student Debtors, State Pros...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 11:00:26.383000+00:00
None
5
Want to receive this post in your inbox every ...
[2016-11-23T11:03:55.393Z]
[Five Things You Need to Know to Start Your Day]
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:03:55.393000+00:00
None
6
Investors across the country are variously che...
[2016-11-22T12:03:02.316Z]
[Financial Planners Play Therapist to Paralyze...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 12:03:02.316000+00:00
None
7
A U.S. safety agency is investigating an accid...
[2016-11-21T20:25:02.220Z]
[Accident Involving Facebook Experimental Dron...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 20:25:02.220000+00:00
None
8
The end game may have finally arrived for Banc...
[2016-11-23T00:01:01.000Z, 2016-11-23T12:29:02...
[Italy's Third-Biggest Bank Is Running Out of ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 00:01:01+00:00
2016-11-23 12:29:02.281000+00:00
9
By Thanksgiving of 1994, Steve Jobs was stuck....
[2016-11-23T11:00:15.926Z]
[Steve Jobs Was in Trouble. His Hero? Chief Fi...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:00:15.926000+00:00
None
10
Ah, youth.As growing legions of graying Wall S...
[2016-11-23T10:00:07.000Z]
[Wall Street’s Youngest Workers Aren’t Worried...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 10:00:07+00:00
None
11
To get a sense of Europe’s political weather, ...
[2016-11-23T05:01:10.321Z]
[To Understand Europe’s Political Tremors, Tak...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 05:01:10.321000+00:00
None
12
Deep inside a sprawling glass-and-cement edifi...
[2016-11-23T05:01:21.157Z]
[Zara’s Recipe for Success: More Data, Fewer B...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 05:01:21.157000+00:00
None
13
Kanye West is missing out on about $30 million...
[2016-11-21T19:40:25.642Z]
[Kanye West Seen Surrendering $30 Million With...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 19:40:25.642000+00:00
None
14
Some 140,900 adults worldwide can be classed a...
[2016-11-22T09:01:36.816Z]
[If You Are Super Rich, You Probably Live in t...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 09:01:36.816000+00:00
None
15
After massive moves across a plethora of asset...
[2016-11-22T15:22:23.993Z]
[Investors Have Hit the Pause Button on a Numb...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 15:22:23.993000+00:00
None
16
Apple Inc. has disbanded its division that dev...
[2016-11-21T12:00:00.001Z, 2016-11-21T16:07:31...
[Apple Said to Abandon Development of Wireless...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 12:00:00.001000+00:00
2016-11-21 16:07:31.117000+00:00
17
On Sept. 2 the conservative web magazine the F...
[2016-11-22T10:00:11.330Z]
[Elon Musk vs. the Trolls]
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 10:00:11.330000+00:00
None
18
FedEx Corp. and United Parcel Service Inc. exp...
[2016-11-23T10:00:00.003Z]
[Mondays Are Black Friday for Shippers as Holi...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 10:00:00.003000+00:00
None
19
Italy’s banks are a basket case. Helping them ...
[2016-11-22T19:40:55.318Z]
[Why Italy’s Bank Problem Challenges the Rule ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 19:40:55.318000+00:00
None
20
Chancellor Angela Merkel warned Germans agains...
[2016-11-23T09:04:38.879Z, 2016-11-23T11:04:17...
[Merkel Warns Against Trade Isolation in Rebuk...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 09:04:38.879000+00:00
2016-11-23 11:04:17.133000+00:00
21
Billionaire Sumner Redstone is trying to cut a...
[2016-11-22T22:09:11.384Z, 2016-11-22T23:26:16...
[Redstone in New Spat With Ex-Girlfriend Over ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 22:09:11.384000+00:00
2016-11-22 23:26:16.642000+00:00
22
Even before the U.S. presidential election rai...
[2016-11-23T02:00:00.000Z]
[Big Western Companies Are Pumping Cash Into R...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 02:00:00+00:00
None
23
Those looking to explain what's set to be anot...
[2016-11-22T16:09:00.398Z]
[Goldman: Hedge Funds Are Poised to Get Beaten...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 16:09:00.398000+00:00
None
24
Malaysia’s attempt to cajole currency traders ...
[2016-11-20T16:01:00.000Z, 2016-11-21T08:52:05...
[Malaysia Seeks to Nix ’98 Parallel as It Herd...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-20 16:01:00+00:00
2016-11-21 08:52:05.414000+00:00
25
Subscribe to Bloomberg Benchmark on iTunes Pod...
[2016-11-23T11:00:21.739Z]
[Make France Great Again]
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:00:21.739000+00:00
None
26
Some investors are finding that companies with...
[2016-09-22T15:39:58.621Z]
[Investors Weigh Whether a Female CEO Matters ...
https://www.bloomberg.com/news/articles/2016-0...
2016-09-22 15:39:58.621000+00:00
None
27
For wealthy Americans, the outcome of the 2016...
[2016-11-14T12:00:11.199Z]
[What the Rich Are Doing Now to Reap Trump’s T...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-14 12:00:11.199000+00:00
None
28
Indonesia’s central bank kept its benchmark in...
[2016-11-17T09:25:23.577Z, 2016-11-17T10:28:38...
[Indonesia Keeps Benchmark Rate Unchanged Amid...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-17 09:25:23.577000+00:00
2016-11-17 10:28:38.233000+00:00
29
Global funds sold about $11 billion of equitie...
[2016-11-22T04:58:39.972Z, 2016-11-22T08:57:08...
[Emerging Asia Sees $11 Billion Outflow on Dol...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 04:58:39.972000+00:00
2016-11-22 08:57:08.480000+00:00
30
Donald Trump’s election has Europe’s own popul...
[2016-11-22T23:00:00.004Z]
[There Is No Visible ‘Trump Effect’ for Europe...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 23:00:00.004000+00:00
None
31
A massive drone Google Inc. was testing as par...
[2016-01-29T18:44:44.425Z, 2016-01-29T18:44:44...
[Wing Failure Blamed for Crash of Google's Sol...
https://www.bloomberg.com/news/articles/2016-0...
2016-01-29 18:44:44.425000+00:00
2016-01-29 18:44:44.438000+00:00
32
Facebook Inc.’s plan for connecting rural are...
[2015-07-30T18:45:48.000Z, 2015-07-30T18:45:47...
[Facebook Unveils Web-Connected Aircraft With ...
https://www.bloomberg.com/news/articles/2015-0...
2015-07-30 18:45:48+00:00
2015-07-30 18:45:47.999000+00:00
33
Malaysian Prime Minister Najib Razak announced...
[2016-10-21T08:00:00.028Z, 2016-10-21T12:28:45...
[Najib Unveils ‘Feel-Good’ Budget, Boosting Od...
https://www.bloomberg.com/news/articles/2016-1...
2016-10-21 08:00:00.028000+00:00
2016-10-21 12:28:45.838000+00:00
34
Here's another entry in hedge funds' long list...
[2015-11-23T13:46:34.441Z, 2015-11-23T13:46:34...
[Goldman: Hedge Funds' Favorite Stocks Have Ha...
https://www.bloomberg.com/news/articles/2015-1...
2015-11-23 13:46:34.441000+00:00
2015-11-23 13:46:34.433000+00:00
35
Mark Zuckerberg didn’t see this coming.When Fa...
[2015-12-30T03:53:13.955Z, 2015-12-30T09:14:16...
[Why India's Net Neutrality Activists Hate Fac...
https://www.bloomberg.com/news/articles/2015-1...
2015-12-30 03:53:13.955000+00:00
2015-12-30 09:14:16.189000+00:00
36
As a candidate, Donald Trump barely mentioned ...
[2016-11-10T10:00:20.682Z]
[Your Retirement Under President Trump]
http://www.bloomberg.com/news/articles/2016-11...
2016-11-10 10:00:20.682000+00:00
None
37
One of the world’s most important financial in...
[2016-09-26T17:42:27.624Z, 2016-10-11T14:28:24...
[Why Deutsche Bank’s Shares Are at a Record Lo...
https://www.bloomberg.com/news/articles/2016-0...
2016-09-26 17:42:27.624000+00:00
2016-10-11 14:28:24.320000+00:00
38
Indonesia’s rupiah plunged to a five-month low...
[2016-11-11T01:46:15.781Z, 2016-11-11T09:27:03...
[Rupiah Plunge Prompts Intervention to Stabili...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-11 01:46:15.781000+00:00
2016-11-11 09:27:03.744000+00:00
39
More than $1 trillion was wiped off the value ...
[2016-11-11T03:07:46.434Z, 2016-11-11T12:42:02...
[Bonds Plunge by $1 Trillion This Week as Trum...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-11 03:07:46.434000+00:00
2016-11-11 12:42:02.623000+00:00
40
When it comes to speculation about German gove...
[2016-10-04T23:01:00.004Z, 2016-10-05T08:19:26...
[Deutsche Bank Brings Too-Big-to-Fail Quandary...
http://www.bloomberg.com/news/articles/2016-10...
2016-10-04 23:01:00.004000+00:00
2016-10-05 08:19:26.997000+00:00
41
For wealthy Americans, a big win by Hillary Cl...
[2016-10-25T10:00:04.800Z]
[The Rich Get Ready for Higher Taxes Under a P...
http://www.bloomberg.com/news/articles/2016-10...
2016-10-25 10:00:04.800000+00:00
None
42
Following are the minutes of the Federal Rese...
[2016-08-17T18:01:21.597Z, 2016-08-17T18:01:21...
[U.S. Federal Reserve Meeting Minutes for July...
https://www.bloomberg.com/news/articles/2016-0...
2016-08-17 18:01:21.597000+00:00
2016-08-17 18:01:21.595000+00:00
43
Made in Russia and coming soon to a store shel...
[2016-11-16T21:00:01.001Z]
[Cheapest Labor Since Tsars Ruled Russia a Dra...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-16 21:00:01.001000+00:00
None
44
Italy plans to set up a fund designed to help ...
[2015-12-11T20:23:46.758Z]
[Italy Plans Fund to Help Savers of Four Rescu...
http://www.bloomberg.com/news/articles/2015-12...
2015-12-11 20:23:46.758000+00:00
None
45
A plain-speaking candidate with a business bac...
[2016-11-16T04:00:01.000Z, 2016-11-16T10:45:04...
[French Pollsters Spooked by Trump But Still D...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-16 04:00:01+00:00
2016-11-16 10:45:04.101000+00:00
46
A SpaceX rocket blew up on a launchpad in Flor...
[2016-09-01T14:28:05.948Z, 2016-09-01T23:41:45...
[SpaceX Rocket Blast Destroys Satellite for Fa...
http://www.bloomberg.com/news/articles/2016-09...
2016-09-01 14:28:05.948000+00:00
2016-09-01 23:41:45.908000+00:00
47
Banca Monte dei Paschi di Siena SpA is offerin...
[2016-11-15T00:24:33.867Z, 2016-11-15T10:50:45...
[Monte Paschi Taps Bondholders for Swap as Res...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-15 00:24:33.867000+00:00
2016-11-15 10:50:45.814000+00:00
48
After success in Britain and the U.S., populis...
[2016-11-09T23:01:00.002Z, 2016-11-10T13:04:11...
[After Brexit and Trump, Populists Target Next...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-09 23:01:00.002000+00:00
2016-11-10 13:04:11.712000+00:00
49
The election surprises of 2016 continue. In Fr...
[2016-11-21T18:37:32.070Z]
[Why France’s Surprise Primary Winner Is No Tr...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-21 18:37:32.070000+00:00
None
50
In April 2008, as the global financial crisis ...
[2016-09-26T22:00:01.004Z, 2016-09-27T12:29:23...
[Deutsche Bank Returns to Haunt Merkel in an E...
http://www.bloomberg.com/news/articles/2016-09...
2016-09-26 22:00:01.004000+00:00
2016-09-27 12:29:23.787000+00:00
In [137]:
concurancy_pair_path = "./EURUSD1.csv"
pair = pd.read_csv(concurancy_pair_path,
dtype = {'<TIME>': np.str, '<DTYYYYMMDD>': np.str}
)
pair.rename(columns={'<TICKER>': 'TICKER',
'<DTYYYYMMDD>': 'DTYYYYMMDD',
'<TIME>': 'TIME',
'<OPEN>': 'OPEN',
'<HIGH>': 'HIGH',
'<LOW>': 'LOW',
'<CLOSE>': 'CLOSE',
'<VOL>': 'VOL'
}, inplace=True)
In [138]:
convert_date = (lambda row: datetime.strptime(str(row['DTYYYYMMDD'])+str(row['TIME']), '%Y.%m.%d%H:%M'))
pair['DATETIME'] = pair.apply(convert_date, axis=1)
In [139]:
pair.tail(10)
Out[139]:
DTYYYYMMDD
TIME
OPEN
HIGH
LOW
CLOSE
VOL
DATETIME
64991
2016.11.18
23:42
1.05966
1.05969
1.05961
1.05962
49
2016-11-18 23:42:00
64992
2016.11.18
23:43
1.05961
1.05963
1.05956
1.05956
40
2016-11-18 23:43:00
64993
2016.11.18
23:44
1.05956
1.05963
1.05946
1.05946
86
2016-11-18 23:44:00
64994
2016.11.18
23:45
1.05946
1.05946
1.05880
1.05881
126
2016-11-18 23:45:00
64995
2016.11.18
23:46
1.05881
1.05891
1.05872
1.05890
79
2016-11-18 23:46:00
64996
2016.11.18
23:47
1.05889
1.05895
1.05884
1.05895
63
2016-11-18 23:47:00
64997
2016.11.18
23:48
1.05894
1.05916
1.05889
1.05897
55
2016-11-18 23:48:00
64998
2016.11.24
12:29
1.05537
1.05551
1.05523
1.05523
115
2016-11-24 12:29:00
64999
2016.11.24
12:32
1.05528
1.05534
1.05525
1.05527
24
2016-11-24 12:32:00
65000
2016.11.24
12:33
1.05532
1.05536
1.05521
1.05531
37
2016-11-24 12:33:00
In [237]:
nearest_id = lambda row: int(((pair.DATETIME - row).abs() / np.timedelta64(1, 's')).argsort()[:1])
In [238]:
articles['pair_id'] = articles.apply(lambda row: nearest_id(row.created_at.tz_convert(None)), axis=1)
In [245]:
def next_nearest_id(row):
this_date = pair.DATETIME[row.pair_id]
next_id = nearest_id(this_date + np.timedelta64(1, 'D'))
next_date = pair.DATETIME[next_id]
return next_id if ((next_date - this_date) > np.timedelta64(20, 'h')) else None
In [246]:
articles['next_pair_id'] = articles.apply(next_nearest_id, axis=1)
In [259]:
def wow(row):
if (row.next_pair_id > -1 and row.pair_id > -1):
diff = (float(pair.OPEN[row.pair_id]) - float(pair.OPEN[int(row.next_pair_id)]))
threshold = 2e-5
step = 0 if (abs(diff) < threshold) else (-1 if (diff < 0) else 1)
return step
In [260]:
articles['direction'] = articles.apply(wow, axis=1)
In [261]:
articles
Out[261]:
article
date
title
url
created_at
updated_at
pair_id
next_pair_id
direction
0
The U.K. is setting up a 2.3 billion pound ($2...
[2016-11-23T13:47:39.184Z]
[U.K. to Set Up $2.9 Billion Fund to Boost New...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 13:47:39.184000+00:00
None
64998
NaN
NaN
1
The frenzy is about to begin.Thanksgiving mark...
[2016-11-23T11:00:10.031Z]
[Six Things to Watch For on Black Friday]
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 11:00:10.031000+00:00
None
64998
NaN
NaN
2
Late on Nov. 21, President-elect Donald Trump ...
[2016-11-23T10:00:04.829Z]
[Trump Would Have a Hard Time Divesting His Bu...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 10:00:04.829000+00:00
None
64998
NaN
NaN
3
Asia’s worst-performing currency since Donald ...
[2016-11-22T21:00:00.003Z]
[Asia’s Worst Currency Slump Takes Malaysian R...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 21:00:00.003000+00:00
None
64998
NaN
NaN
4
Xerox Corp. has agreed to pay $2.4 million to ...
[2016-11-23T11:00:26.383Z]
[Xerox Overcharged Student Debtors, State Pros...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 11:00:26.383000+00:00
None
64998
NaN
NaN
5
Want to receive this post in your inbox every ...
[2016-11-23T11:03:55.393Z]
[Five Things You Need to Know to Start Your Day]
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:03:55.393000+00:00
None
64998
NaN
NaN
6
Investors across the country are variously che...
[2016-11-22T12:03:02.316Z]
[Financial Planners Play Therapist to Paralyze...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 12:03:02.316000+00:00
None
64998
NaN
NaN
7
A U.S. safety agency is investigating an accid...
[2016-11-21T20:25:02.220Z]
[Accident Involving Facebook Experimental Dron...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 20:25:02.220000+00:00
None
64998
NaN
NaN
8
The end game may have finally arrived for Banc...
[2016-11-23T00:01:01.000Z, 2016-11-23T12:29:02...
[Italy's Third-Biggest Bank Is Running Out of ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 00:01:01+00:00
2016-11-23 12:29:02.281000+00:00
64998
NaN
NaN
9
By Thanksgiving of 1994, Steve Jobs was stuck....
[2016-11-23T11:00:15.926Z]
[Steve Jobs Was in Trouble. His Hero? Chief Fi...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:00:15.926000+00:00
None
64998
NaN
NaN
10
Ah, youth.As growing legions of graying Wall S...
[2016-11-23T10:00:07.000Z]
[Wall Street’s Youngest Workers Aren’t Worried...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 10:00:07+00:00
None
64998
NaN
NaN
11
To get a sense of Europe’s political weather, ...
[2016-11-23T05:01:10.321Z]
[To Understand Europe’s Political Tremors, Tak...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 05:01:10.321000+00:00
None
64998
NaN
NaN
12
Deep inside a sprawling glass-and-cement edifi...
[2016-11-23T05:01:21.157Z]
[Zara’s Recipe for Success: More Data, Fewer B...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 05:01:21.157000+00:00
None
64998
NaN
NaN
13
Kanye West is missing out on about $30 million...
[2016-11-21T19:40:25.642Z]
[Kanye West Seen Surrendering $30 Million With...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 19:40:25.642000+00:00
None
64998
NaN
NaN
14
Some 140,900 adults worldwide can be classed a...
[2016-11-22T09:01:36.816Z]
[If You Are Super Rich, You Probably Live in t...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 09:01:36.816000+00:00
None
64998
NaN
NaN
15
After massive moves across a plethora of asset...
[2016-11-22T15:22:23.993Z]
[Investors Have Hit the Pause Button on a Numb...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 15:22:23.993000+00:00
None
64998
NaN
NaN
16
Apple Inc. has disbanded its division that dev...
[2016-11-21T12:00:00.001Z, 2016-11-21T16:07:31...
[Apple Said to Abandon Development of Wireless...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 12:00:00.001000+00:00
2016-11-21 16:07:31.117000+00:00
64997
NaN
NaN
17
On Sept. 2 the conservative web magazine the F...
[2016-11-22T10:00:11.330Z]
[Elon Musk vs. the Trolls]
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 10:00:11.330000+00:00
None
64998
NaN
NaN
18
FedEx Corp. and United Parcel Service Inc. exp...
[2016-11-23T10:00:00.003Z]
[Mondays Are Black Friday for Shippers as Holi...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 10:00:00.003000+00:00
None
64998
NaN
NaN
19
Italy’s banks are a basket case. Helping them ...
[2016-11-22T19:40:55.318Z]
[Why Italy’s Bank Problem Challenges the Rule ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 19:40:55.318000+00:00
None
64998
NaN
NaN
20
Chancellor Angela Merkel warned Germans agains...
[2016-11-23T09:04:38.879Z, 2016-11-23T11:04:17...
[Merkel Warns Against Trade Isolation in Rebuk...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 09:04:38.879000+00:00
2016-11-23 11:04:17.133000+00:00
64998
NaN
NaN
21
Billionaire Sumner Redstone is trying to cut a...
[2016-11-22T22:09:11.384Z, 2016-11-22T23:26:16...
[Redstone in New Spat With Ex-Girlfriend Over ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 22:09:11.384000+00:00
2016-11-22 23:26:16.642000+00:00
64998
NaN
NaN
22
Even before the U.S. presidential election rai...
[2016-11-23T02:00:00.000Z]
[Big Western Companies Are Pumping Cash Into R...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 02:00:00+00:00
None
64998
NaN
NaN
23
Those looking to explain what's set to be anot...
[2016-11-22T16:09:00.398Z]
[Goldman: Hedge Funds Are Poised to Get Beaten...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 16:09:00.398000+00:00
None
64998
NaN
NaN
24
Malaysia’s attempt to cajole currency traders ...
[2016-11-20T16:01:00.000Z, 2016-11-21T08:52:05...
[Malaysia Seeks to Nix ’98 Parallel as It Herd...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-20 16:01:00+00:00
2016-11-21 08:52:05.414000+00:00
64997
NaN
NaN
25
Subscribe to Bloomberg Benchmark on iTunes Pod...
[2016-11-23T11:00:21.739Z]
[Make France Great Again]
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:00:21.739000+00:00
None
64998
NaN
NaN
26
Some investors are finding that companies with...
[2016-09-22T15:39:58.621Z]
[Investors Weigh Whether a Female CEO Matters ...
https://www.bloomberg.com/news/articles/2016-0...
2016-09-22 15:39:58.621000+00:00
None
5696
7136.0
1.0
27
For wealthy Americans, the outcome of the 2016...
[2016-11-14T12:00:11.199Z]
[What the Rich Are Doing Now to Reap Trump’s T...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-14 12:00:11.199000+00:00
None
58532
59970.0
-1.0
28
Indonesia’s central bank kept its benchmark in...
[2016-11-17T09:25:23.577Z, 2016-11-17T10:28:38...
[Indonesia Keeps Benchmark Rate Unchanged Amid...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-17 09:25:23.577000+00:00
2016-11-17 10:28:38.233000+00:00
62694
64134.0
1.0
29
Global funds sold about $11 billion of equitie...
[2016-11-22T04:58:39.972Z, 2016-11-22T08:57:08...
[Emerging Asia Sees $11 Billion Outflow on Dol...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 04:58:39.972000+00:00
2016-11-22 08:57:08.480000+00:00
64998
NaN
NaN
30
Donald Trump’s election has Europe’s own popul...
[2016-11-22T23:00:00.004Z]
[There Is No Visible ‘Trump Effect’ for Europe...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 23:00:00.004000+00:00
None
64998
NaN
NaN
31
A massive drone Google Inc. was testing as par...
[2016-01-29T18:44:44.425Z, 2016-01-29T18:44:44...
[Wing Failure Blamed for Crash of Google's Sol...
https://www.bloomberg.com/news/articles/2016-0...
2016-01-29 18:44:44.425000+00:00
2016-01-29 18:44:44.438000+00:00
0
NaN
NaN
32
Facebook Inc.’s plan for connecting rural are...
[2015-07-30T18:45:48.000Z, 2015-07-30T18:45:47...
[Facebook Unveils Web-Connected Aircraft With ...
https://www.bloomberg.com/news/articles/2015-0...
2015-07-30 18:45:48+00:00
2015-07-30 18:45:47.999000+00:00
0
NaN
NaN
33
Malaysian Prime Minister Najib Razak announced...
[2016-10-21T08:00:00.028Z, 2016-10-21T12:28:45...
[Najib Unveils ‘Feel-Good’ Budget, Boosting Od...
https://www.bloomberg.com/news/articles/2016-1...
2016-10-21 08:00:00.028000+00:00
2016-10-21 12:28:45.838000+00:00
35319
NaN
NaN
34
Here's another entry in hedge funds' long list...
[2015-11-23T13:46:34.441Z, 2015-11-23T13:46:34...
[Goldman: Hedge Funds' Favorite Stocks Have Ha...
https://www.bloomberg.com/news/articles/2015-1...
2015-11-23 13:46:34.441000+00:00
2015-11-23 13:46:34.433000+00:00
0
NaN
NaN
35
Mark Zuckerberg didn’t see this coming.When Fa...
[2015-12-30T03:53:13.955Z, 2015-12-30T09:14:16...
[Why India's Net Neutrality Activists Hate Fac...
https://www.bloomberg.com/news/articles/2015-1...
2015-12-30 03:53:13.955000+00:00
2015-12-30 09:14:16.189000+00:00
0
NaN
NaN
36
As a candidate, Donald Trump barely mentioned ...
[2016-11-10T10:00:20.682Z]
[Your Retirement Under President Trump]
http://www.bloomberg.com/news/articles/2016-11...
2016-11-10 10:00:20.682000+00:00
None
55533
56973.0
1.0
37
One of the world’s most important financial in...
[2016-09-26T17:42:27.624Z, 2016-10-11T14:28:24...
[Why Deutsche Bank’s Shares Are at a Record Lo...
https://www.bloomberg.com/news/articles/2016-0...
2016-09-26 17:42:27.624000+00:00
2016-10-11 14:28:24.320000+00:00
8697
10135.0
1.0
38
Indonesia’s rupiah plunged to a five-month low...
[2016-11-11T01:46:15.781Z, 2016-11-11T09:27:03...
[Rupiah Plunge Prompts Intervention to Stabili...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-11 01:46:15.781000+00:00
2016-11-11 09:27:03.744000+00:00
56479
57811.0
1.0
39
More than $1 trillion was wiped off the value ...
[2016-11-11T03:07:46.434Z, 2016-11-11T12:42:02...
[Bonds Plunge by $1 Trillion This Week as Trum...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-11 03:07:46.434000+00:00
2016-11-11 12:42:02.623000+00:00
56561
57811.0
1.0
40
When it comes to speculation about German gove...
[2016-10-04T23:01:00.004Z, 2016-10-05T08:19:26...
[Deutsche Bank Brings Too-Big-to-Fail Quandary...
http://www.bloomberg.com/news/articles/2016-10...
2016-10-04 23:01:00.004000+00:00
2016-10-05 08:19:26.997000+00:00
17650
19089.0
-1.0
41
For wealthy Americans, a big win by Hillary Cl...
[2016-10-25T10:00:04.800Z]
[The Rich Get Ready for Higher Taxes Under a P...
http://www.bloomberg.com/news/articles/2016-10...
2016-10-25 10:00:04.800000+00:00
None
38317
39757.0
-1.0
42
Following are the minutes of the Federal Rese...
[2016-08-17T18:01:21.597Z, 2016-08-17T18:01:21...
[U.S. Federal Reserve Meeting Minutes for July...
https://www.bloomberg.com/news/articles/2016-0...
2016-08-17 18:01:21.597000+00:00
2016-08-17 18:01:21.595000+00:00
0
NaN
NaN
43
Made in Russia and coming soon to a store shel...
[2016-11-16T21:00:01.001Z]
[Cheapest Labor Since Tsars Ruled Russia a Dra...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-16 21:00:01.001000+00:00
None
61949
63389.0
1.0
44
Italy plans to set up a fund designed to help ...
[2015-12-11T20:23:46.758Z]
[Italy Plans Fund to Help Savers of Four Rescu...
http://www.bloomberg.com/news/articles/2015-12...
2015-12-11 20:23:46.758000+00:00
None
0
NaN
NaN
45
A plain-speaking candidate with a business bac...
[2016-11-16T04:00:01.000Z, 2016-11-16T10:45:04...
[French Pollsters Spooked by Trump But Still D...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-16 04:00:01+00:00
2016-11-16 10:45:04.101000+00:00
60930
62369.0
1.0
46
A SpaceX rocket blew up on a launchpad in Flor...
[2016-09-01T14:28:05.948Z, 2016-09-01T23:41:45...
[SpaceX Rocket Blast Destroys Satellite for Fa...
http://www.bloomberg.com/news/articles/2016-09...
2016-09-01 14:28:05.948000+00:00
2016-09-01 23:41:45.908000+00:00
0
NaN
NaN
47
Banca Monte dei Paschi di Siena SpA is offerin...
[2016-11-15T00:24:33.867Z, 2016-11-15T10:50:45...
[Monte Paschi Taps Bondholders for Swap as Res...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-15 00:24:33.867000+00:00
2016-11-15 10:50:45.814000+00:00
59276
60715.0
1.0
48
After success in Britain and the U.S., populis...
[2016-11-09T23:01:00.002Z, 2016-11-10T13:04:11...
[After Brexit and Trump, Populists Target Next...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-09 23:01:00.002000+00:00
2016-11-10 13:04:11.712000+00:00
54874
56314.0
1.0
49
The election surprises of 2016 continue. In Fr...
[2016-11-21T18:37:32.070Z]
[Why France’s Surprise Primary Winner Is No Tr...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-21 18:37:32.070000+00:00
None
64998
NaN
NaN
50
In April 2008, as the global financial crisis ...
[2016-09-26T22:00:01.004Z, 2016-09-27T12:29:23...
[Deutsche Bank Returns to Haunt Merkel in an E...
http://www.bloomberg.com/news/articles/2016-09...
2016-09-26 22:00:01.004000+00:00
2016-09-27 12:29:23.787000+00:00
8955
10393.0
1.0
In [165]:
pair.DATETIME[65000]
Out[165]:
Timestamp('2016-11-24 12:33:00')
In [262]:
articles.to_csv('super.json')
In [263]:
pd.read_csv('super.json')
Out[263]:
Unnamed: 0
article
date
title
url
created_at
updated_at
pair_id
next_pair_id
direction
0
0
The U.K. is setting up a 2.3 billion pound ($2...
['2016-11-23T13:47:39.184Z']
['U.K. to Set Up $2.9 Billion Fund to Boost Ne...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 13:47:39.184000+00:00
NaN
64998
NaN
NaN
1
1
The frenzy is about to begin.Thanksgiving mark...
['2016-11-23T11:00:10.031Z']
['Six Things to Watch For on Black Friday']
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 11:00:10.031000+00:00
NaN
64998
NaN
NaN
2
2
Late on Nov. 21, President-elect Donald Trump ...
['2016-11-23T10:00:04.829Z']
['Trump Would Have a Hard Time Divesting His B...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 10:00:04.829000+00:00
NaN
64998
NaN
NaN
3
3
Asia’s worst-performing currency since Donald ...
['2016-11-22T21:00:00.003Z']
['Asia’s Worst Currency Slump Takes Malaysian ...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 21:00:00.003000+00:00
NaN
64998
NaN
NaN
4
4
Xerox Corp. has agreed to pay $2.4 million to ...
['2016-11-23T11:00:26.383Z']
['Xerox Overcharged Student Debtors, State Pro...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 11:00:26.383000+00:00
NaN
64998
NaN
NaN
5
5
Want to receive this post in your inbox every ...
['2016-11-23T11:03:55.393Z']
['Five Things You Need to Know to Start Your D...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:03:55.393000+00:00
NaN
64998
NaN
NaN
6
6
Investors across the country are variously che...
['2016-11-22T12:03:02.316Z']
['Financial Planners Play Therapist to Paralyz...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 12:03:02.316000+00:00
NaN
64998
NaN
NaN
7
7
A U.S. safety agency is investigating an accid...
['2016-11-21T20:25:02.220Z']
['Accident Involving Facebook Experimental Dro...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 20:25:02.220000+00:00
NaN
64998
NaN
NaN
8
8
The end game may have finally arrived for Banc...
['2016-11-23T00:01:01.000Z', '2016-11-23T12:29...
["Italy's Third-Biggest Bank Is Running Out of...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 00:01:01+00:00
2016-11-23 12:29:02.281000+00:00
64998
NaN
NaN
9
9
By Thanksgiving of 1994, Steve Jobs was stuck....
['2016-11-23T11:00:15.926Z']
['Steve Jobs Was in Trouble. His Hero? Chief F...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:00:15.926000+00:00
NaN
64998
NaN
NaN
10
10
Ah, youth.As growing legions of graying Wall S...
['2016-11-23T10:00:07.000Z']
['Wall Street’s Youngest Workers Aren’t Worrie...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 10:00:07+00:00
NaN
64998
NaN
NaN
11
11
To get a sense of Europe’s political weather, ...
['2016-11-23T05:01:10.321Z']
['To Understand Europe’s Political Tremors, Ta...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 05:01:10.321000+00:00
NaN
64998
NaN
NaN
12
12
Deep inside a sprawling glass-and-cement edifi...
['2016-11-23T05:01:21.157Z']
['Zara’s Recipe for Success: More Data, Fewer ...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 05:01:21.157000+00:00
NaN
64998
NaN
NaN
13
13
Kanye West is missing out on about $30 million...
['2016-11-21T19:40:25.642Z']
['Kanye West Seen Surrendering $30 Million Wit...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 19:40:25.642000+00:00
NaN
64998
NaN
NaN
14
14
Some 140,900 adults worldwide can be classed a...
['2016-11-22T09:01:36.816Z']
['If You Are Super Rich, You Probably Live in ...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 09:01:36.816000+00:00
NaN
64998
NaN
NaN
15
15
After massive moves across a plethora of asset...
['2016-11-22T15:22:23.993Z']
["Investors Have Hit the Pause Button on a Num...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 15:22:23.993000+00:00
NaN
64998
NaN
NaN
16
16
Apple Inc. has disbanded its division that dev...
['2016-11-21T12:00:00.001Z', '2016-11-21T16:07...
['Apple Said to Abandon Development of Wireles...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-21 12:00:00.001000+00:00
2016-11-21 16:07:31.117000+00:00
64997
NaN
NaN
17
17
On Sept. 2 the conservative web magazine the F...
['2016-11-22T10:00:11.330Z']
['Elon Musk vs. the Trolls']
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 10:00:11.330000+00:00
NaN
64998
NaN
NaN
18
18
FedEx Corp. and United Parcel Service Inc. exp...
['2016-11-23T10:00:00.003Z']
['Mondays Are Black Friday for Shippers as Hol...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 10:00:00.003000+00:00
NaN
64998
NaN
NaN
19
19
Italy’s banks are a basket case. Helping them ...
['2016-11-22T19:40:55.318Z']
['Why Italy’s Bank Problem Challenges the Rule...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 19:40:55.318000+00:00
NaN
64998
NaN
NaN
20
20
Chancellor Angela Merkel warned Germans agains...
['2016-11-23T09:04:38.879Z', '2016-11-23T11:04...
['Merkel Warns Against Trade Isolation in Rebu...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 09:04:38.879000+00:00
2016-11-23 11:04:17.133000+00:00
64998
NaN
NaN
21
21
Billionaire Sumner Redstone is trying to cut a...
['2016-11-22T22:09:11.384Z', '2016-11-22T23:26...
['Redstone in New Spat With Ex-Girlfriend Over...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 22:09:11.384000+00:00
2016-11-22 23:26:16.642000+00:00
64998
NaN
NaN
22
22
Even before the U.S. presidential election rai...
['2016-11-23T02:00:00.000Z']
['Big Western Companies Are Pumping Cash Into ...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-23 02:00:00+00:00
NaN
64998
NaN
NaN
23
23
Those looking to explain what's set to be anot...
['2016-11-22T16:09:00.398Z']
['Goldman: Hedge Funds Are Poised to Get Beate...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 16:09:00.398000+00:00
NaN
64998
NaN
NaN
24
24
Malaysia’s attempt to cajole currency traders ...
['2016-11-20T16:01:00.000Z', '2016-11-21T08:52...
['Malaysia Seeks to Nix ’98 Parallel as It Her...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-20 16:01:00+00:00
2016-11-21 08:52:05.414000+00:00
64997
NaN
NaN
25
25
Subscribe to Bloomberg Benchmark on iTunes Pod...
['2016-11-23T11:00:21.739Z']
['Make France Great Again']
https://www.bloomberg.com/news/articles/2016-1...
2016-11-23 11:00:21.739000+00:00
NaN
64998
NaN
NaN
26
26
Some investors are finding that companies with...
['2016-09-22T15:39:58.621Z']
['Investors Weigh Whether a Female CEO Matters...
https://www.bloomberg.com/news/articles/2016-0...
2016-09-22 15:39:58.621000+00:00
NaN
5696
7136.0
1.0
27
27
For wealthy Americans, the outcome of the 2016...
['2016-11-14T12:00:11.199Z']
['What the Rich Are Doing Now to Reap Trump’s ...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-14 12:00:11.199000+00:00
NaN
58532
59970.0
-1.0
28
28
Indonesia’s central bank kept its benchmark in...
['2016-11-17T09:25:23.577Z', '2016-11-17T10:28...
['Indonesia Keeps Benchmark Rate Unchanged Ami...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-17 09:25:23.577000+00:00
2016-11-17 10:28:38.233000+00:00
62694
64134.0
1.0
29
29
Global funds sold about $11 billion of equitie...
['2016-11-22T04:58:39.972Z', '2016-11-22T08:57...
['Emerging Asia Sees $11 Billion Outflow on Do...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-22 04:58:39.972000+00:00
2016-11-22 08:57:08.480000+00:00
64998
NaN
NaN
30
30
Donald Trump’s election has Europe’s own popul...
['2016-11-22T23:00:00.004Z']
['There Is No Visible ‘Trump Effect’ for Europ...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-22 23:00:00.004000+00:00
NaN
64998
NaN
NaN
31
31
A massive drone Google Inc. was testing as par...
['2016-01-29T18:44:44.425Z', '2016-01-29T18:44...
["Wing Failure Blamed for Crash of Google's So...
https://www.bloomberg.com/news/articles/2016-0...
2016-01-29 18:44:44.425000+00:00
2016-01-29 18:44:44.438000+00:00
0
NaN
NaN
32
32
Facebook Inc.’s plan for connecting rural are...
['2015-07-30T18:45:48.000Z', '2015-07-30T18:45...
['Facebook Unveils Web-Connected Aircraft With...
https://www.bloomberg.com/news/articles/2015-0...
2015-07-30 18:45:48+00:00
2015-07-30 18:45:47.999000+00:00
0
NaN
NaN
33
33
Malaysian Prime Minister Najib Razak announced...
['2016-10-21T08:00:00.028Z', '2016-10-21T12:28...
['Najib Unveils ‘Feel-Good’ Budget, Boosting O...
https://www.bloomberg.com/news/articles/2016-1...
2016-10-21 08:00:00.028000+00:00
2016-10-21 12:28:45.838000+00:00
35319
NaN
NaN
34
34
Here's another entry in hedge funds' long list...
['2015-11-23T13:46:34.441Z', '2015-11-23T13:46...
["Goldman: Hedge Funds' Favorite Stocks Have H...
https://www.bloomberg.com/news/articles/2015-1...
2015-11-23 13:46:34.441000+00:00
2015-11-23 13:46:34.433000+00:00
0
NaN
NaN
35
35
Mark Zuckerberg didn’t see this coming.When Fa...
['2015-12-30T03:53:13.955Z', '2015-12-30T09:14...
["Why India's Net Neutrality Activists Hate Fa...
https://www.bloomberg.com/news/articles/2015-1...
2015-12-30 03:53:13.955000+00:00
2015-12-30 09:14:16.189000+00:00
0
NaN
NaN
36
36
As a candidate, Donald Trump barely mentioned ...
['2016-11-10T10:00:20.682Z']
['Your Retirement Under President Trump']
http://www.bloomberg.com/news/articles/2016-11...
2016-11-10 10:00:20.682000+00:00
NaN
55533
56973.0
1.0
37
37
One of the world’s most important financial in...
['2016-09-26T17:42:27.624Z', '2016-10-11T14:28...
['Why Deutsche Bank’s Shares Are at a Record L...
https://www.bloomberg.com/news/articles/2016-0...
2016-09-26 17:42:27.624000+00:00
2016-10-11 14:28:24.320000+00:00
8697
10135.0
1.0
38
38
Indonesia’s rupiah plunged to a five-month low...
['2016-11-11T01:46:15.781Z', '2016-11-11T09:27...
['Rupiah Plunge Prompts Intervention to Stabil...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-11 01:46:15.781000+00:00
2016-11-11 09:27:03.744000+00:00
56479
57811.0
1.0
39
39
More than $1 trillion was wiped off the value ...
['2016-11-11T03:07:46.434Z', '2016-11-11T12:42...
['Bonds Plunge by $1 Trillion This Week as Tru...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-11 03:07:46.434000+00:00
2016-11-11 12:42:02.623000+00:00
56561
57811.0
1.0
40
40
When it comes to speculation about German gove...
['2016-10-04T23:01:00.004Z', '2016-10-05T08:19...
['Deutsche Bank Brings Too-Big-to-Fail Quandar...
http://www.bloomberg.com/news/articles/2016-10...
2016-10-04 23:01:00.004000+00:00
2016-10-05 08:19:26.997000+00:00
17650
19089.0
-1.0
41
41
For wealthy Americans, a big win by Hillary Cl...
['2016-10-25T10:00:04.800Z']
['The Rich Get Ready for Higher Taxes Under a ...
http://www.bloomberg.com/news/articles/2016-10...
2016-10-25 10:00:04.800000+00:00
NaN
38317
39757.0
-1.0
42
42
Following are the minutes of the Federal Rese...
['2016-08-17T18:01:21.597Z', '2016-08-17T18:01...
['U.S. Federal Reserve Meeting Minutes for Jul...
https://www.bloomberg.com/news/articles/2016-0...
2016-08-17 18:01:21.597000+00:00
2016-08-17 18:01:21.595000+00:00
0
NaN
NaN
43
43
Made in Russia and coming soon to a store shel...
['2016-11-16T21:00:01.001Z']
['Cheapest Labor Since Tsars Ruled Russia a Dr...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-16 21:00:01.001000+00:00
NaN
61949
63389.0
1.0
44
44
Italy plans to set up a fund designed to help ...
['2015-12-11T20:23:46.758Z']
['Italy Plans Fund to Help Savers of Four Resc...
http://www.bloomberg.com/news/articles/2015-12...
2015-12-11 20:23:46.758000+00:00
NaN
0
NaN
NaN
45
45
A plain-speaking candidate with a business bac...
['2016-11-16T04:00:01.000Z', '2016-11-16T10:45...
['French Pollsters Spooked by Trump But Still ...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-16 04:00:01+00:00
2016-11-16 10:45:04.101000+00:00
60930
62369.0
1.0
46
46
A SpaceX rocket blew up on a launchpad in Flor...
['2016-09-01T14:28:05.948Z', '2016-09-01T23:41...
['SpaceX Rocket Blast Destroys Satellite for F...
http://www.bloomberg.com/news/articles/2016-09...
2016-09-01 14:28:05.948000+00:00
2016-09-01 23:41:45.908000+00:00
0
NaN
NaN
47
47
Banca Monte dei Paschi di Siena SpA is offerin...
['2016-11-15T00:24:33.867Z', '2016-11-15T10:50...
['Monte Paschi Taps Bondholders for Swap as Re...
https://www.bloomberg.com/news/articles/2016-1...
2016-11-15 00:24:33.867000+00:00
2016-11-15 10:50:45.814000+00:00
59276
60715.0
1.0
48
48
After success in Britain and the U.S., populis...
['2016-11-09T23:01:00.002Z', '2016-11-10T13:04...
['After Brexit and Trump, Populists Target Nex...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-09 23:01:00.002000+00:00
2016-11-10 13:04:11.712000+00:00
54874
56314.0
1.0
49
49
The election surprises of 2016 continue. In Fr...
['2016-11-21T18:37:32.070Z']
['Why France’s Surprise Primary Winner Is No T...
http://www.bloomberg.com/news/articles/2016-11...
2016-11-21 18:37:32.070000+00:00
NaN
64998
NaN
NaN
50
50
In April 2008, as the global financial crisis ...
['2016-09-26T22:00:01.004Z', '2016-09-27T12:29...
['Deutsche Bank Returns to Haunt Merkel in an ...
http://www.bloomberg.com/news/articles/2016-09...
2016-09-26 22:00:01.004000+00:00
2016-09-27 12:29:23.787000+00:00
8955
10393.0
1.0
In [ ]: