French News - Stocks Prediction

French financial news with translation and sentiment analyses

@kaggle.arcticgiant_french_financial_news

Table List

2 tables(65.55 MB)

Frenchnewsdayconcat

@kaggle.arcticgiant_french_financial_news.frenchnewsdayconcat

106.82 KB
871 rows
15 columns

nbr_day Nbr Day	date Date	nbrnewsjour NbrNewsJour	day_sent_vader_title Day Sent Vader Title	day_sent_vader_text Day Sent Vader Text	day_sent_vader_text_url Day Sent Vader Text URL	high High	low Low	open Open	close Close	volume Volume	adj_close Adj Close	mean_sent_title Mean Sent Title	mean_sent_text Mean Sent Text	mean_sent_text_url Mean Sent Text URL
	Thu Oct 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	17	-0.1115764705882352	-0.1797294117647058	-0.0172764705882353	5377.81005859375	5343	5371	5368.2900390625	86686600	5368.2900390625	-0.0892468700694984	0.0115940864798738	0.0455618017187615
1	Fri Oct 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	15	0.0296133333333333	0.1616066666666666	0.28876	5392.08984375	5368.2099609375	5389.47998046875	5372.3798828125	92307000	5372.3798828125	-0.0795138212753015	0.0403279574059458	0.0884349712594801
2	Mon Oct 23 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	29	-0.1738482758620689	-0.1072137931034482	0.0631551724137931	5408.740234375	5367.64990234375	5377.4501953125	5386.81005859375	63702000	5386.81005859375	-0.0843730861690264	0.0288777109554503	0.0803174736545234
3	Tue Oct 24 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	30	0.0104466666666666	0.1184466666666666	-0.0081399999999999	5413.02978515625	5377.85986328125	5377.85986328125	5394.7998046875	74560600	5394.7998046875	-0.0711588103098705	0.018522694728108	0.0811911295272524
4	Wed Oct 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	13	-0.0985692307692307	0.0735538461538461	0.1339923076923077	5416.5400390625	5364.16015625	5399.60986328125	5374.89013671875	80466800	5374.89013671875	-0.0740378748795736	0.017724747145488	0.0743450284385711
5	Thu Oct 26 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	8	-0.1553625	0.1830875	0.0285249999999999	5459.60986328125	5375.259765625	5383.43994140625	5455.39990234375	90950700	5455.39990234375	-0.0713220165542687	0.0206615183884204	0.079898693209333
6	Fri Oct 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	11	-0.2108818181818182	-0.1307727272727273	-0.1687272727272727	5513.52978515625	5470.240234375	5470.33984375	5494.1298828125	95585200	5494.1298828125	-0.0719485741930963	0.012914816346287	0.0700938003939538
7	Mon Oct 30 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	39	-0.0157205128205128	0.0302717948717948	0.2293615384615384	5507.56005859375	5487.2900390625	5488.330078125	5493.6298828125	67428800	5493.6298828125	-0.0667549240487454	0.0183870905765565	0.0755680781201406
8	Tue Oct 31 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	31	-0.0326032258064516	0.1846903225806451	0.1289677419354838	5511.25	5489.41015625	5492.6298828125	5503.2900390625	75164700	5503.2900390625	-0.0698574282682595	0.0196884613615191	0.0833754071134662
9	Wed Nov 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	3	-0.1339666666666666	-0.2179999999999999	-0.223	5536.39990234375	5514.2900390625	5524.3798828125	5514.2900390625	75303700	5514.2900390625	-0.0661561601137897	0.0156767879565269	0.0845670523531083


CREATE TABLE frenchnewsdayconcat (
  "nbr_day" BIGINT,
  "date" TIMESTAMP,
  "nbrnewsjour" BIGINT,
  "day_sent_vader_title" DOUBLE,
  "day_sent_vader_text" DOUBLE,
  "day_sent_vader_text_url" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "open" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "adj_close" DOUBLE,
  "mean_sent_title" DOUBLE,
  "mean_sent_text" DOUBLE,
  "mean_sent_text_url" DOUBLE
);