S&P500 Top 20 Companies Stocks

Individual stock prices and normalized percentage changes from 2008 to 2024

@kaggle.myrios_s_and_p500_top_20_companies_stocks

Table List

2 tables(1.37 MB)

Stocks Pct

@kaggle.myrios_s_and_p500_top_20_companies_stocks.stocks_pct

797.98 KB
5843 rows
22 columns

date Date	n__gspc ^GSPC	aapl AAPL	msft MSFT	nvda NVDA	googl GOOGL	goog GOOG	amzn AMZN	lly LLY	jpm JPM	wmt WMT	unh UNH	xom XOM	v V	ma MA	pg PG	jnj JNJ	orcl ORCL	cost COST
Mon Jun 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100	100
Tue Jun 03 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	99.42121722510396	99.60772882616668	98.23741084688614	96.61289879112168	98.66087571565065	98.6608702994581	99.85042896326696	101.44988153918185	99.3831503515585	100.99649624740846	99.88231564121196	97.6084745102973	101.73114658888412	96.06249928474426	100.07650405644256	100.37588331374268	101.01410731543878	99.58765689182836
Wed Jun 04 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	99.38873667577305	99.5110116014754	99.06475421342245	97.74193573196524	99.51652822889793	99.516527677447	101.58294726144024	103.04686017711772	98.76630975340676	100.8391599996999	99.49984708664996	97.6540284524901	99.31451569654637	92.93749928474426	101.66768103995088	100.06014270672463	101.01410731543878	100.68249070815055
Thu Jun 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	101.32643445408408	101.78935116165415	101.7985612004386	100.201607902576	101.96521585369604	101.965220464924	105.3346686121322	103.92939467511869	99.8813688020222	104.54544499658628	99.85288894001587	101.7082337338628	101.35935653897263	95.6749975681305	102.00428021169002	100.67658537631748	102.20458550825458	104.5073199010576
Fri Jun 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	98.19654106375692	99.7528154247078	98.88489397679868	97.01612420992602	98.60869644748855	98.60870272821614	100.49856616019186	101.74405970518217	95.1126896827602	102.04545124882144	97.17563150407815	98.83840488392477	97.18833719353336	92.41562485694884	100.01530314586456	98.87235005877191	99.02997699407916	101.2228076040968
Sat Jun 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	98.19654106375692	99.7528154247078	98.88489397679868	97.01612420992602	98.60869644748855	98.60870272821614	100.49856616019186	101.74405970518217	95.1126896827602	102.04545124882144	97.17563150407815	98.83840488392477	97.18833719353336	92.41562485694884	100.01530314586456	98.87235005877191	99.02997699407916	101.2228076040968
Sun Jun 08 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	98.19654106375692	99.7528154247078	98.88489397679868	97.01612420992602	98.60869644748855	98.60870272821614	100.49856616019186	101.74405970518217	95.1126896827602	102.04545124882144	97.17563150407815	98.83840488392477	97.18833719353336	92.41562485694884	100.01530314586456	98.87235005877191	99.02997699407916	101.2228076040968
Mon Jun 09 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	98.27447852508882	97.58730664805547	99.67625843504374	95.5241911217152	97.02087064684532	97.02086809395652	99.00286767961629	101.2397565679684	88.99168911892714	104.1433512480712	96.88143183010624	101.43491876923206	95.4339487404319	91.06249809265135	101.0862898987798	98.67688339415474	99.42680305835108	101.42186829797356
Tue Jun 10 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	98.0348783133442	99.7528154247078	100.32374156495626	89.8790352584544	96.37739482494064	96.37739701799136	99.23968749721404	100.73544541500084	90.84222901396188	104.51048249749286	95.91055270460228	100.0911078843856	93.30777023741892	89.39062356948853	101.9889887387056	98.66185632075988	99.20634787145616	100.18483897345864
Wed Jun 11 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	96.3786433913182	97.15743477882812	97.55396253061537	85.68548321196738	94.81739840915864	94.81739085963422	96.32307605442944	99.6637952366062	88.0901535562661	102.30768499738656	93.99823237778855	100.91106146680391	90.32182890601824	87.25312352180481	101.2851841034983	98.03036363567536	97.310402988785	97.92407358671788


CREATE TABLE stocks_pct (
  "date" TIMESTAMP,
  "n__gspc" DOUBLE,
  "aapl" DOUBLE,
  "msft" DOUBLE,
  "nvda" DOUBLE,
  "googl" DOUBLE,
  "goog" DOUBLE,
  "amzn" DOUBLE,
  "meta" DOUBLE,
  "lly" DOUBLE,
  "avgo" DOUBLE,
  "tsla" DOUBLE,
  "jpm" DOUBLE,
  "wmt" DOUBLE,
  "unh" DOUBLE,
  "xom" DOUBLE,
  "v" DOUBLE,
  "ma" DOUBLE,
  "pg" DOUBLE,
  "jnj" DOUBLE,
  "orcl" DOUBLE,
  "cost" DOUBLE
);