Stock-NewsEventsSentiment (SNES) 1.0

A time-series dataset for joint news and market data analysis of stocks

@kaggle.parsabg_stocknewseventssentiment_snes_10

Table List

2 tables(6.94 MB)

Sp500wiki

@kaggle.parsabg_stocknewseventssentiment_snes_10.sp500wiki

38.76 KB
524 rows
11 columns

unnamed_0 Unnamed: 0	symbol Symbol	security Security	sec_filings SEC Filings	gics_sector GICS Sector	gics_sub_industry GICS Sub-Industry	headquarters_location Headquarters Location	date_first_added Date First Added	cik CIK	founded Founded	wikidata_id Wikidata ID
	MMM	3M	reports	Industrials	Industrial Conglomerates	Saint Paul, Minnesota	1976-08-09	66740	1902	Q159433
1	AOS	A. O. Smith	reports	Industrials	Building Products	Milwaukee, Wisconsin	2017-07-26	91142	1916	Q4648219
2	ABT	Abbott	reports	Health Care	Health Care Equipment	North Chicago, Illinois	1964-03-31	1800	1888	Q306764
3	ABBV	AbbVie	reports	Health Care	Pharmaceuticals	North Chicago, Illinois	2012-12-31	1551152	2013 (1888)	Q14662364
4	ABMD	Abiomed	reports	Health Care	Health Care Equipment	Danvers, Massachusetts	2018-05-31	815094	1981	Q4667884
5	ACN	Accenture	reports	Information Technology	IT Consulting & Other Services	Dublin, Ireland	2011-07-06	1467373	1989	Q338825
6	ATVI	Activision Blizzard	reports	Communication Services	Interactive Home Entertainment	Santa Monica, California	2015-08-31	718877	2008	Q344341
7	ADM	ADM	reports	Consumer Staples	Agricultural Products	Chicago, Illinois	1981-07-29	7084	1902	Q632694
8	ADBE	Adobe Inc.	reports	Information Technology	Application Software	San Jose, California	1997-05-05	796343	1982	Q11463
9	ADP	ADP	reports	Information Technology	Data Processing & Outsourced Services	Roseland, New Jersey	1981-03-31	8670	1949	Q489080


CREATE TABLE sp500wiki (
  "unnamed_0" BIGINT,
  "symbol" VARCHAR,
  "security" VARCHAR,
  "sec_filings" VARCHAR,
  "gics_sector" VARCHAR,
  "gics_sub_industry" VARCHAR,
  "headquarters_location" VARCHAR,
  "date_first_added" VARCHAR,
  "cik" BIGINT,
  "founded" VARCHAR,
  "wikidata_id" VARCHAR
);