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

@kaggle.myrios_s_and_p500_top_20_companies_stocks.stocks

601.64 KB
5843 rows
21 columns

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
1385.6700439453125	6.646429061889648	27.799999237060547	0.6200000047683716	14.389389038085938	14.321319580078123	4.011499881744385	47.59000015258789	42.150001525878906	19.06666755676269	33.9900016784668	87.80999755859375	21.51749992370605	32	65.36000061035156	66.51000213623047	22.68000030517578	70.33000183105469
1377.6500244140625	6.620357036590576	27.309999465942383	0.5989999771118164	14.196697235107422	14.129538536071776	4.005499839782715	48.27999877929688	41.88999938964844	19.25666618347168	33.95000076293945	85.70999908447266	21.88999938964844	30.739999771118164	65.41000366210938	66.76000213623047	22.90999984741211	70.04000091552734
1377.199951171875	6.61392879486084	27.540000915527344	0.6060000061988831	14.319820404052734	14.252079963684082	4.074999809265137	49.040000915527344	41.630001068115234	19.226667404174805	33.81999969482422	85.75	21.3700008392334	29.739999771118164	66.44999694824219	66.55000305175781	22.90999984741211	70.80999755859375
1404.050048828125	6.76535701751709	28.299999237060547	0.6212499737739563	14.672171592712402	14.602765083312988	4.225500106811523	49.459999084472656	42.09999847412109	19.933332443237305	33.939998626708984	89.30999755859375	21.809999465942383	30.61599922180176	66.66999816894531	66.95999908447266	23.18000030517578	73.5
1360.6800537109375	6.630000114440918	27.489999771118164	0.6014999747276306	14.189188957214355	14.12206745147705	4.031499862670898	48.41999816894531	40.09000015258789	19.456666946411133	33.029998779296875	86.79000091552734	20.912500381469727	29.572999954223636	65.37000274658203	65.76000213623047	22.459999084472656	71.19000244140625
1360.6800537109375	6.630000114440918	27.489999771118164	0.6014999747276306	14.189188957214355	14.12206745147705	4.031499862670898	48.41999816894531	40.09000015258789	19.456666946411133	33.029998779296875	86.79000091552734	20.912500381469727	29.572999954223636	65.37000274658203	65.76000213623047	22.459999084472656	71.19000244140625
1360.6800537109375	6.630000114440918	27.489999771118164	0.6014999747276306	14.189188957214355	14.12206745147705	4.031499862670898	48.41999816894531	40.09000015258789	19.456666946411133	33.029998779296875	86.79000091552734	20.912500381469727	29.572999954223636	65.37000274658203	65.76000213623047	22.459999084472656	71.19000244140625
1361.760009765625	6.4860711097717285	27.709999084472656	0.5922499895095825	13.960710525512695	13.894668579101562	3.971499919891357	48.18000030517578	37.5099983215332	19.856666564941406	32.93000030517578	89.06999969482422	20.53499984741211	29.13999938964844	66.06999969482422	65.62999725341797	22.549999237060547	71.33000183105469
1358.43994140625	6.630000114440918	27.88999938964844	0.5572500228881836	13.868118286132812	13.802515029907228	3.9809999465942383	47.93999862670898	38.290000915527344	19.926666259765625	32.599998474121094	87.88999938964844	20.07749938964844	28.604999542236328	66.66000366210938	65.62000274658203	22.5	70.45999908447266
1335.489990234375	6.457499980926514	27.1200008392334	0.53125	13.643644332885742	13.5791015625	3.864000082015991	47.43000030517578	37.130001068115234	19.50666618347168	31.950000762939453	88.61000061035156	19.434999465942383	27.92099952697754	66.19999694824219	65.19999694824219	22.06999969482422	68.87000274658203


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