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)

Data

@kaggle.parsabg_stocknewseventssentiment_snes_10.data

6.91 MB
217811 rows
27 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume	symbol Symbol	security Security	gics_sector GICS Sector	gics_sub_industry GICS Sub-Industry	news_all_news_volume News - All News Volume	news_volume News - Volume	news_positive_sentiment News - Positive Sentiment	news_negative_sentiment News - Negative Sentiment	news_analyst_comments News - Analyst Comments	news_stocks News - Stocks	news_dividends News - Dividends	news_corporate_earnings News - Corporate Earnings	news_mergers_acquisitions News - Mergers \u0026 Acquisitions	news_adverse_events News - Adverse Events	news_personnel_changes News - Personnel Changes
Wed Sep 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	160.92999267578125	163.10000610351562	158.61000061035156	160.17999267578125	150.92169189453125	3056900	MMM	3M	Industrials	Industrial Conglomerates
Thu Oct 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	160.6699981689453	161.89999389648438	157.72000122070312	158.7899932861328	149.61204528808594	1989100	MMM	3M	Industrials	Industrial Conglomerates	589369	47			4	4
Fri Oct 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	156.47000122070312	161.94000244140625	156.25	160.36000061035156	151.09130859375	1768600	MMM	3M	Industrials	Industrial Conglomerates	506082	43	3		2	2		2	1	1
Mon Oct 05 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	162.25	163.5	161.75999450683594	162.75	153.34317016601562	1457000	MMM	3M	Industrials	Industrial Conglomerates	489872	50	2	3	2	2			2		1
Tue Oct 06 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	163.44000244140625	165.6999969482422	161.8300018310547	162.22999572753906	152.8531951904297	2021900	MMM	3M	Industrials	Industrial Conglomerates	550713	50			3	3			3	3
Wed Oct 07 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	165.10000610351562	167.75	164.41000366210938	166.49000549316406	156.8669891357422	2155400	MMM	3M	Industrials	Industrial Conglomerates	573739	32			17	17			1
Thu Oct 08 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	167.3000030517578	168.14999389648438	166.1300048828125	167.7100067138672	158.0164794921875	1902600	MMM	3M	Industrials	Industrial Conglomerates	565295	36			8	8			3
Fri Oct 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	168.8800048828125	170.47999572753906	167.9499969482422	169.3000030517578	159.51455688476562	2015500	MMM	3M	Industrials	Industrial Conglomerates	527671	36		2	9	9	1	1
Mon Oct 12 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	169.47000122070312	170.61000061035156	168.1199951171875	168.64999389648438	158.90213012695312	1533600	MMM	3M	Industrials	Industrial Conglomerates	452574	11			3	3					1
Tue Oct 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	168.3000030517578	169.4499969482422	166	166.6300048828125	156.99888610839844	1575300	MMM	3M	Industrials	Industrial Conglomerates	544121	25			3	5		1


CREATE TABLE data (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE,
  "symbol" VARCHAR,
  "security" VARCHAR,
  "gics_sector" VARCHAR,
  "gics_sub_industry" VARCHAR,
  "news_all_news_volume" DOUBLE,
  "news_volume" DOUBLE,
  "news_positive_sentiment" DOUBLE,
  "news_negative_sentiment" DOUBLE,
  "news_new_products" DOUBLE,
  "news_layoffs" DOUBLE,
  "news_analyst_comments" DOUBLE,
  "news_stocks" DOUBLE,
  "news_dividends" DOUBLE,
  "news_corporate_earnings" DOUBLE,
  "news_mergers_acquisitions" DOUBLE,
  "news_store_openings" DOUBLE,
  "news_product_recalls" DOUBLE,
  "news_adverse_events" DOUBLE,
  "news_personnel_changes" DOUBLE,
  "news_stock_rumors" DOUBLE
);