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)

Msft1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.msft1424

408.43 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)	37.34999847412109	37.400001525878906	37.09999847412109	37.15999984741211	31.23305892944336	30632200		100	100	37.15999984741211	37.15999984741211	37.15999984741211	37.15999984741211
1	Fri Jan 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	37.20000076293945	37.220001220703125	36.59999847412109	36.90999984741211	31.02292823791504	31134800				37.15019592584349	37.1550493523626	37.03499984741211	37.03499984741211	-0.0067503969315431	-0.0067276641826308	-0.0067503969315431	-0.0067276641826308
2	Mon Jan 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	36.84999847412109	36.88999938964844	36.11000061035156	36.130001068115234	30.367341995239254	43603700				37.11018828436394	37.13475136653592	36.73333358764648	36.73333358764648	-0.021358938185194	-0.0211324514365058	-0.0281093351167371	-0.0278601156191367
3	Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	36.33000183105469	36.4900016784668	36.209999084472656	36.40999984741211	30.602689743041992	35802800		24.729574001699703	22.95364367234812	37.0827299142874	37.12039985130574	36.65250015258789	36.65250015258789	0.007719883273858	0.0077497584007539	-0.020389451842879	-0.0201103572183827
4	Wed Jan 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	36	36.13999938964844	35.58000183105469	35.7599983215332	30.056352615356445	59971700		14.810222965794296	14.58443781798708	37.03085808712057	37.09346120715183	36.47399978637695	36.47399978637695	-0.018013554628197	-0.0178522803790976	-0.0384030064710761	-0.0379626375974804
5	Thu Jan 09 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	35.880001068115234	35.90999984741211	35.400001525878906	35.529998779296875	29.863035202026367	36516300		12.706236489652028	12.805263815909782	36.97200085936278	37.06250155511509	36.31666628519694	36.31666628519694	-0.0064525276923556	-0.0064317548386972	-0.0448555341634317	-0.0443943924361777
6	Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	35.900001525878906	36.150001525878906	35.75	36.040000915527344	30.291704177856445	40548800	0.5771435328892299	36.166062798424605	32.47585917280999	36.93545184195747	37.04225401769751	36.277142660958425	36.277142660958425	0.0142520824672606	0.0143541276035068	-0.0306034516961711	-0.0300402648326708
7	Mon Jan 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	35.9900016784668	36.02000045776367	34.83000183105469	34.97999954223633	29.40076065063477	45901900	0.6675514688297194	21.89676196145237	21.579394632109118	36.85876743804684	37.00141729541114	36.11499977111816	36.11499977111816	-0.0298530016392104	-0.0294118020633659	-0.0604564533353815	-0.0594520668960367
8	Tue Jan 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	34.72999954223633	35.880001068115234	34.630001068115234	35.779998779296875	30.073162078857425	41623300	0.7507584018540452	42.03416605402681	38.38272228001875	36.81646278476253	36.977230790141554	36.07777743869357	36.07777743869357	0.0226125874596442	0.0228701900380128	-0.0378438658757372	-0.0365818768580239
9	Wed Jan 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	35.900001525878906	36.790000915527344	35.849998474121094	36.7599983215332	30.89686584472656	44812600	0.7877932210506771	57.64227168833323	51.96186193027653	36.81424849208688	36.9729291570998	36.14599952697754	36.14599952697754	0.0270212078636836	0.0273895912708463	-0.0108226580120536	-0.0091922855871775


CREATE TABLE msft1424 (
  "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
);