Stocks: Tech, AI & Magnificent Seven

Tech & AI. Can we predict the future stock prices?

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven

Table List

7 tables(2.8 MB)

Meta1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.meta1424

410.52 KB
2570 rows
19 columns

unnamed_0 Unnamed: 0	date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume	atr_7_days ATR (7 Days)	rsi_7_days RSI (7 Days)	rsi_14_days RSI (14 Days)	ema_50_days EMA (50 Days)	ema_100_days EMA (100 Days)	sma_50_days SMA (50 Days)	sma_100_days SMA (100 Days)	log_return Log Return	percent_return Percent Return	cumulative_log_return Cumulative Log Return	cumulative_percent_return Cumulative Percent Return
	Thu Jan 02 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	54.83000183105469	55.220001220703125	54.18999862670898	54.709999084472656	54.65201187133789	43195500		100	100	54.709999084472656	54.709999084472656	54.709999084472656	54.709999084472656
1	Fri Jan 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	55.02000045776367	55.650001525878906	54.52999877929688	54.560001373291016	54.502174377441406	38246200				54.70411682128906	54.707028832766085	54.63500022888184	54.63500022888184	-0.0027454526360516	-0.0027416873275768	-0.0027454526360516	-0.0027416873275768
2	Mon Jan 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	54.41999816894531	57.2599983215332	54.04999923706055	57.20000076293945	57.13937377929688	68852600		95.35610369844888	94.98850638719776	54.80199462292241	54.7563946135616	55.49000040690104	55.49000040690104	0.0472528730183582	0.0483870843694811	0.0445074203823065	0.0456453970419042
3	Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	57.70000076293945	58.54999923706055	57.220001220703125	57.91999816894531	57.85860824584961	77207400		96.4371034704008	96.0816674208904	54.92426927178605	54.81904022851968	56.09749984741211	56.09749984741211	0.0125088047400926	0.0125873670699729	0.0570162251223992	0.0582327641118772
4	Wed Jan 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	57.59999847412109	58.40999984741211	57.22999954223633	58.22999954223633	58.16828155517578	56682400		96.81009603386909	96.44157586941562	55.053905752980185	54.88658397730615	56.52399978637696	56.52399978637696	0.0053379615237783	0.0053522338240892	0.0623541866461776	0.0635849979359665
5	Thu Jan 09 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	58.650001525878906	58.959999084472656	56.650001525878906	57.220001220703125	57.15935516357422	92253300		69.2527308878987	72.93585631909963	55.138850673283045	54.93279025935362	56.64000002543131	56.64000002543131	-0.0174971690322571	-0.0173449824742075	0.0448570176139204	0.0462400154617589
6	Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	57.130001068115234	58.29999923706055	57.060001373291016	57.93999862670898	57.87858963012695	42449500	1.6342855181012834	75.13848044676917	77.20171441656012	55.24869961263308	54.992338939895305	56.825714111328125	56.825714111328125	0.0125044596837849	0.0125829673304052	0.0573614772977054	0.0588229827921641
7	Mon Jan 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	57.90999984741211	58.25	55.380001068115234	55.90999984741211	55.85074234008789	63010900	1.810816005784638	46.10681349853884	52.21314102406859	55.27463295517344	55.01051044301445	56.71124982833862	56.71124982833862	-0.0356647163298694	-0.0350362241527754	0.0216967609678359	0.0237867586393887
8	Tue Jan 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	56.459999084472656	57.77999877929688	56.09999847412109	57.7400016784668	57.678802490234375	37503600	1.819270709513228	61.678983157510885	63.63903819708072	55.371314081577104	55.064559774409545	56.82555558946397	56.82555558946397	0.0322069509947983	0.0327312079422119	0.0539037119626342	0.0565179665816006
9	Wed Jan 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	57.97999954223633	58.56999969482422	57.27000045776367	57.59999847412109	57.53894805908203	33663400	1.7450890705914162	60.12828482128539	62.40960650193306	55.458713469520006	55.11476648133453	56.90299987792969	56.90299987792969	-0.0024276620932904	-0.0024247177048128	0.0514760498693437	0.0540932488767877


CREATE TABLE meta1424 (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT,
  "atr_7_days" DOUBLE,
  "rsi_7_days" DOUBLE,
  "rsi_14_days" DOUBLE,
  "ema_50_days" DOUBLE,
  "ema_100_days" DOUBLE,
  "sma_50_days" DOUBLE,
  "sma_100_days" DOUBLE,
  "log_return" DOUBLE,
  "percent_return" DOUBLE,
  "cumulative_log_return" DOUBLE,
  "cumulative_percent_return" DOUBLE
);