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)

Googl1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.googl1424

412.77 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)	27.91441345214844	27.97172164916992	27.73423385620117	27.85585594177246	27.85585594177246	72783144		100	100	27.85585594177246	27.85585594177246	27.85585594177246	27.85585594177246
1	Fri Jan 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	27.90290260314941	27.95120048522949	27.650901794433597	27.65265274047852	27.65265274047852	66601332				27.847887188780543	27.851832116004264	27.75425434112549	27.75425434112549	-0.0073215481317688	-0.0072948108907048	-0.0073215481317688	-0.0072948108907048
2	Mon Jan 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	27.853103637695312	27.99949836730957	27.68868827819824	27.960960388183597	27.960960388183597	70701228		63.9003657277621	62.03418943527207	27.85232143189439	27.853993071889004	27.823156356811523	27.823156356811523	0.011087602075652	0.0111492973422318	0.0037660539438832	0.0038544864515269
3	Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.153152465820312	28.520771026611328	28.057056427001957	28.5	28.5	102001896		84.32785431878773	82.4882975628521	27.87772059142794	27.86678528828724	27.992367267608643	27.992367267608643	0.0190948218514146	0.0192782938902271	0.0228608757952978	0.0231327803417541
4	Wed Jan 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.67867851257324	28.71171188354492	28.360610961914062	28.559309005737305	28.559309005737305	89610300		85.38914547099955	83.53911142249734	27.90444954885184	27.88049862922685	28.105755615234376	28.105755615234376	0.0020788554271026	0.0020810177451686	0.0249397312224005	0.0252137980869228
5	Thu Jan 09 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.614614486694336	28.63413429260254	28.16716766357422	28.284284591674805	28.284284591674805	83296620		62.49406198056924	64.27753170499408	27.919345040727247	27.88849439085948	28.135510444641117	28.135510444641117	-0.0096766070786834	-0.0096299393660838	0.0152631241437171	0.015583858720839
6	Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.50550651550293	28.50550651550293	28.084333419799805	28.28278350830078	28.28278350830078	85654260	0.3833833421979631	62.38754525229224	64.19053730203959	27.9335975296517	27.896302096155345	28.15654945373535	28.15654945373535	-0.00005307269493703562	-0.00005307128660647642	0.01521005144878	0.0155307874342325
7	Mon Jan 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.189939498901367	28.70145034790039	27.95720672607422	28.10260391235352	28.10260391235352	96659244	0.4349348107162787	50.365914775638814	54.63250091307677	27.94022523093412	27.900387280634515	28.149806261062626	28.149806261062626	-0.0063910249615541	-0.006370645799215	0.0088190264872259	0.0091601416350174
8	Tue Jan 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.47722625732422	28.803804397583008	28.2304801940918	28.76376342773437	28.76376342773437	99204696	0.4729727642181663	72.80207922339207	71.43849202195875	27.97252084649492	27.917483838002827	28.21802372402615	28.21802372402615	0.0232541426443695	0.0235266282598896	0.0320731691315954	0.032686769894907
9	Wed Jan 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.85360336303711	28.90390396118164	28.62337303161621	28.74424362182617	28.74424362182617	77929992	0.4454810735534896	71.68593939649935	70.60688098748733	28.0027844847432	27.933855318870616	28.270645713806157	28.270645713806157	-0.0006788552641379	-0.0006786248940353	0.0313943138674575	0.0320081450008716


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