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)

Amzn1424

@kaggle.princeiornongu_stocks_tech_ai_and_magnificent_seven.amzn1424

399.17 KB
2570 rows
18 columns

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)	19.940000534057617	19.968000411987305	19.701000213623047	19.898500442504883	19.898500442504883	42756000		100	100	19.898500442504883	19.898500442504883	19.898500442504883	19.898500442504883
Fri Jan 03 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.914499282836918	20.135499954223636	19.81100082397461	19.82200050354004	19.82200050354004	44204000				19.89550044489842	19.89698559222835	19.86025047302246	19.86025047302246	-0.0038519168555408	-0.0038445077399618	-0.0038519168555408	-0.0038445077399618
Mon Jan 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.792499542236328	19.850000381469727	19.42099952697754	19.68149948120117	19.68149948120117	63412000				19.887108250243628	19.89271854052484	19.80066680908203	19.80066680908203	-0.0071133755155831	-0.0070881353430384	-0.0109652923711239	-0.0109326430830002
Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.75200080871582	19.92350006103516	19.714500427246094	19.901500701904297	19.901500701904297	38320000		55.46696186990841	52.83053682829512	19.887672660112678	19.89289244471057	19.8258752822876	19.8258752822876	0.0111160591710651	0.0111780721236844	0.0001507667999411	0.0002454290406842
Wed Jan 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.92350006103516	20.149999618530277	19.802000045776367	20.09600067138672	20.09600067138672	46330000		71.67298436652021	68.6163656535278	19.89584238604499	19.89691438979327	19.87990036010742	19.87990036010742	0.0097256826516726	0.0097731308003226	0.0098764494516137	0.0100185598410068
Thu Jan 09 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.18549919128418	20.34449958801269	19.92200088500977	20.050500869750977	20.050500869750977	42060000		65.19764170619472	63.281110471015054	19.901907424621697	19.899955706228077	19.908333778381348	19.908333778381348	-0.0022666892192417	-0.0022641222191301	0.007609760232372	0.0077544376218766
Fri Jan 10 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.12649917602539	20.1879997253418	19.690000534057617	19.882999420166016	19.882999420166016	53590000	0.3615711757114955	46.97141504255522	48.37033238895585	19.901165934250887	19.89961993818724	19.904714584350582	19.904714584350582	-0.0083890683618737	-0.0083539783206942	-0.0007793081295016	-0.0005995406988176
Mon Jan 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.89900016784668	19.98900032043457	19.42250061035156	19.548999786376957	19.548999786376957	56898000	0.3908466806217116	28.46169498434652	32.11871769079822	19.88735549707936	19.892676964884068	19.86025023460388	19.86025023460388	-0.0169409428132316	-0.0167982519503726	-0.0177202509427333	-0.0173977926491902
Tue Jan 14 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.60650062561035	19.93149948120117	19.56450080871582	19.87700080871582	19.87700080871582	46802000	0.3896542540792125	50.71367423645567	49.91529409926365	19.886949430869024	19.892366545950043	19.862111409505207	19.862111409505207	0.0166392017940578	0.0167784043134238	-0.0010810491486754	-0.0006193883357664
Wed Jan 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.94700050354004	19.965499877929688	19.62649917602539	19.793500900268555	19.793500900268555	53566000	0.3824180323399389	46.42485133232652	46.56817526257413	19.883284782610183	19.890408810391992	19.855250358581543	19.855250358581543	-0.0042096786358288	-0.0042008303592084	-0.0052907277845043	-0.0048202186949749


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