SP500 Csv

S&P 500 5 year monthly prices and returns 20211204

@kaggle.wmcginn_sp500_csv

Table List

3 tables(1.02 MB)

Prices

Returns

Tickerlist

Prices

@kaggle.wmcginn_sp500_csv.prices

493.66 KB
62 rows
480 columns
Only the first 100 columns are shown

a A	aal AAL	aap AAP	aapl AAPL	abbv ABBV	abc ABC	abmd ABMD	abt ABT	acn ACN	adbe ADBE	adi ADI	adm ADM	adp ADP	adsk ADSK	aee AEE	aep AEP	aes AES	afl AFL	aig AIG	aiz AIZ	ajg AJG	akam AKAM	alb ALB	algn ALGN	alk ALK	all ALL	alle ALLE	amat AMAT	amcr AMCR	amd AMD	ame AME	amgn AMGN	amp AMP	amt AMT	amzn AMZN	anet ANET	anss ANSS	antm ANTM	aon AON	aos AOS	apa APA	apd APD	aph APH	aptv APTV	ato ATO	atvi ATVI	avb AVB	avgo AVGO	avy AVY	awk AWK	axp AXP	azo AZO	ba BA	bac BAC	bax BAX	bbwi BBWI	bby BBY	bdx BDX	ben BEN	bf_b BF-B	biib BIIB	bio BIO	bk BK	bkng BKNG	bkr BKR	blk BLK	bll BLL	bmy BMY	br BR	brk_b BRK-B	bsx BSX	bwa BWA	bxp BXP	c C	cag CAG	cah CAH	cat CAT	cb CB	cboe CBOE	cbre CBRE	cci CCI	ccl CCL	cdns CDNS	cdw CDW	ce CE	cern CERN	cf CF	cfg CFG	chd CHD	chrw CHRW	chtr CHTR	ci CI	cinf CINF	cl CL	clx CLX	cma CMA	cmcsa CMCSA	cme CME	cmg CMG	cmi CMI
43.69709014892578	45.11809158325195	164.7028350830078	27.33548355102539	49.04058456420898	71.69768524169922	112.68000030517578	35.15583801269531	108.27713775634766	102.9499969482422	66.2918930053711	39.223411560058594	92.72232818603516	74.01000213623047	45.55522155761719	53.102760314941406	9.65373992919922	30.91989517211914	56.8973274230957	83.55642700195312	46.71492767333984	66.68000030517578	80.10882568359375	96.12999725341795	83.10640716552734	66.80500030517578	60.840850830078125	30.29657745361328	8.555818557739258	11.34000015258789	46.98946380615234	128.616455078125	98.41565704345705	95.7986068725586	749.8699951171875	24.1924991607666	92.48999786376952	134.39605712890625	105.96538543701172	43.697547912597656	57.35457611083984	126.95938873291016	31.900787353515625	54.2923583984375	66.14938354492188	35.02063751220703	149.8253631591797	149.2967987060547	63.79688262939453	66.20658111572266	68.77730560302734	789.7899780273438	144.33763122558594	19.958467483520508	41.90346145629883	53.225547790527344	37.475730895996094	154.67401123046875	30.94621467590332	33.05101013183594	283.5799865722656	182.27999877929688	41.99392318725586	1466.06005859375	39.173526763916016	335.95526123046875	35.966041564941406	50.36399841308594	60.91953659057617	162.97999572753906	21.6299991607666	36.40109252929688	107.22967529296876	51.97578048706055	34.45301055908203	59.6855354309082	81.42654418945312	118.8337173461914	69.2025375366211	31.489999771118164	72.76261901855469	46.718204498291016	25.21999931335449	49.46895980834961	70.98397064208984	46.23110961914063	27.008941650390625	29.959171295166016	41.2698860168457	65.63570404052734	287.9200134277344	131.56503295898438	66.2300033569336	58.18940734863281	105.80276489257812	57.36883163452149	31.45394325256348	97.3070068359375	377.3200073242188	119.05472564697266
47.10365676879883	42.7602424621582	160.0050048828125	28.640661239624023	47.85803985595703	80.03290557861328	106.37000274658205	38.23116683959961	105.2635498046875	113.37999725341795	68.40973663330078	38.02910614013672	91.65164947509766	81.33999633789062	46.12891387939453	54.03053665161133	9.504195213317873	31.093151092529297	56.26294708251953	87.39862823486328	48.39616775512695	68.58999633789062	86.50270080566406	91.69000244140624	87.87381744384766	67.78741455078125	62.543678283691406	32.15549087524414	8.555818557739258	10.369999885559082	49.49941635131836	137.82656860351562	99.59549713134766	94.33572387695312	823.47998046875	23.5	93.26000213623048	144.75003051757812	107.07699584960938	44.98956298828125	54.05626678466797	124.11085510253906	32.11310577392578	56.476959228515625	67.9603500366211	38.99694442749024	147.7118682861328	169.4573974609375	66.72220611572266	67.19474029541016	70.91265106201172	724.97998046875	151.5137481689453	20.44613647460937	45.27729034423828	48.67421340942383	39.33577346801758	166.37997436523438	31.226238250732425	33.55133438110352	277.239990234375	190.0800018310547	39.64516830444336	1575.1300048828125	38.03395462036133	332.1666564941406	36.53617477416992	42.36643600463867	61.43916702270508	164.13999938964844	24.059999465942383	37.68399429321289	112.27225494384766	48.82732391357422	34.05229568481445	62.942848205566406	83.99034118652344	118.88533020019533	74.56903076171875	30.36000061035156	74.4556655883789	49.697532653808594	26.030000686645508	48.91813659667969	76.08646392822266	52.41868591308594	30.277809143066406	30.413227081298828	42.23183059692383	68.54685974121094	323.95001220703125	144.2195281982422	62.103782653808594	57.42469787597656	105.7851333618164	57.07096099853516	34.4909553527832	105.49880981445312	421.4400024414063	128.06199645996094
49.34485626220703	44.79921340942383	152.57171630859375	32.331974029541016	48.91838836669922	83.91168212890625	117.97000122070312	41.52727127075195	113.24129486083984	118.33999633789062	74.79061889648438	40.35758972167969	93.13093566894533	86.30000305175781	47.91625213623047	56.48493957519531	9.672475814819336	32.141597747802734	55.96525573730469	89.08128356933594	51.20121383666992	62.59999847412109	94.78507995605467	102.76000213623048	91.62030029296876	74.051513671875	69.13421630859375	34.0050163269043	8.555818557739258	14.460000038146973	52.27951431274414	155.2880096435547	116.65454864501952	104.62606811523438	845.0399780273438	29.747499465942383	106.76000213623048	154.77944946289062	110.20055389404295	46.60904693603516	47.71192169189453	124.74134826660156	32.93151092529297	61.3701171875	69.84269714355469	43.76852416992188	156.63543701171875	179.16610717773438	73.74893951416016	71.36695098876953	74.64625549316406	736.5499877929688	167.0989990234375	22.288454055786133	48.121883392333984	42.53839874267578	38.99119567871094	171.7855224609375	33.81925582885742	35.87638092041016	288.6000061035156	194.63999938964844	41.95848846435547	1724.1300048828125	36.345699310302734	344.1395263671875	35.22823715209961	49.19580459594727	64.02491760253906	171.4199981689453	24.549999237060547	38.93919372558594	119.24532318115234	52.30810928344727	36.08308410644531	68.32522583007812	85.5725326538086	124.92501068115234	73.09862518310547	35.619998931884766	79.28768157958984	50.20904922485352	30.899999618530277	55.93629837036133	80.3865966796875	53.716705322265625	26.957462310791016	31.54312515258789	46.54653930664063	72.43113708496094	323.0599975585937	146.8628692626953	64.19796752929688	65.26911163330078	121.4037628173828	60.24016571044922	34.225711822509766	105.82990264892578	418.739990234375	129.35125732421875
50.85502624511719	40.9668083190918	144.43702697753906	34.05320358276367	51.54465866088867	81.47777557373047	125.1999969482422	40.91007232666016	110.81932067871094	130.1300048828125	75.21758270263672	39.84523391723633	92.92219543457033	86.47000122070312	47.8286361694336	57.14728927612305	9.387001037597656	32.37160110473633	54.66067886352539	86.5511245727539	50.83259582519531	59.70000076293945	98.64144897460938	114.70999908447266	86.9129638671875	73.78657531738281	72.0961685180664	36.72820663452149	9.472749710083008	14.550000190734863	52.386077880859375	145.32273864746094	115.75408935546876	110.77840423583984	886.5399780273438	33.067501068115234	106.87000274658205	155.30531311035156	113.09729766845705	47.34946060180664	46.62321853637695	120.141357421875	33.86411666870117	65.20252990722656	70.88005065917969	48.3558235168457	156.4820556640625	185.9869079589844	74.02664184570312	71.52397155761719	73.760498046875	723.0499877929688	165.3850555419922	21.304079055786133	49.01021957397461	38.07598876953125	43.4266242980957	172.15151977539062	33.112064361572266	33.97808074951172	273.4200134277344	199.33999633789065	42.03859329223633	1779.969970703125	36.16658401489258	340.6311340332031	35.641380310058594	47.17452621459961	62.750526428222656	166.67999267578125	24.8700008392334	38.700477600097656	113.5673828125	52.46662521362305	35.32131576538086	68.47637176513672	82.11988830566406	123.18907165527344	75.92704010009766	34.790000915527344	80.0676040649414	53.1984748840332	31.399999618530277	54.95359802246094	81.32844543457031	57.43510437011719	25.391189575195312	29.162824630737305	46.75664138793945	69.65535736083984	327.32000732421875	144.48585510253906	63.5908203125	65.45692443847656	119.64676666259766	57.95833587646485	34.381202697753906	103.51222229003906	445.5199890136719	132.59156799316406
53.083343505859375	41.27672958374024	138.52980041503906	34.05083084106445	52.16166687011719	75.53958129882812	130.32000732421875	40.20075988769531	112.13198852539062	133.74000549316406	69.93994903564453	39.59424209594727	95.34925079345705	90.06999969482422	48.30900955200195	57.743202209472656	9.496153831481934	33.47121047973633	53.60176086425781	87.0667953491211	50.52226257324219	60.93999862670898	102.01158142089844	134.6199951171875	80.19327545166016	73.6054916381836	75.05747985839844	38.34274673461914	9.51375675201416	13.300000190734863	55.50171661376953	144.65846252441406	114.12059020996094	114.78880310058594	924.989990234375	34.90999984741211	110.16000366210938	167.70985412597656	114.19309997558594	49.86688232421875	44.1283073425293	125.64061737060548	34.483333587646484	65.12962341308594	72.70162963867188	50.98397445678711	163.05148315429688	188.408935546875	76.42378234863281	73.3541488647461	73.89100646972656	692.1900024414062	172.8379364013672	21.14255714416504	52.755001068115234	42.69199752807617	46.11969375610352	176.1634063720703	34.036651611328125	34.94757080078125	271.2099914550781	218.25999450683597	41.88727569580078	1846.8199462890625	35.894527435302734	343.7327880859375	36.90365982055664	48.62325286865234	64.9003677368164	165.2100067138672	26.3799991607666	39.15425109863281	109.20789337158205	51.85268020629883	33.955406188964844	61.28815841674805	90.53018951416016	124.7167739868164	77.43004608154297	35.810001373291016	81.05365753173828	55.78118515014648	32.56999969482422	56.26769256591797	78.78495025634766	63.19325256347656	23.133230209350582	30.986032485961918	46.4378662109375	65.88768768310547	345.1600036621094	154.2713165283203	63.85713195800781	64.42843627929688	118.6351089477539	59.9410285949707	35.8446159362793	101.78175354003906	474.4700012207031	132.36355590820312
58.184364318847656	46.88424682617188	130.2359161376953	36.21027374267578	52.7445182800293	84.4883041381836	137.42999267578125	42.3188362121582	116.25611114501952	141.86000061035156	78.71456146240234	35.98533248901367	93.41471862792967	111.7699966430664	50.12864685058594	61.10581207275391	9.91068172454834	33.69471740722656	55.99541091918945	88.64095306396484	51.3551139831543	47.150001525878906	106.40452575683594	145.1999969482422	82.04048156738281	78.17808532714844	75.04792785644531	43.31851196289063	9.02166748046875	11.1899995803833	59.20829391479492	137.50169372558594	107.8187484741211	120.18411254882812	994.6199951171876	36.845001220703125	126.33000183105467	171.91468811035156	125.11663055419922	50.91824722290039	42.63396453857422	128.82412719726562	35.57539367675781	71.2618408203125	74.75651550292969	57.16059875488281	164.2539520263672	204.33932495117188	77.38815307617188	71.90103149414062	72.03175354003906	605.9199829101562	175.45628356933594	20.300111770629883	56.19430541992188	41.71382522583008	52.8671760559082	178.2928009033203	32.994468688964844	38.36699676513672	247.7700042724609	223.47999572753903	42.1101188659668	1877.0899658203125	33.34315490722656	365.7829895019531	39.26022720336914	47.141090393066406	70.4216079711914	165.27999877929688	27.030000686645508	39.36724472045898	104.65324401855467	53.23986053466797	33.91773986816406	62.72348785400391	94.1118392944336	130.11431884765625	81.1507568359375	34.880001068115234	87.0941390991211	57.85819625854492	35.13999938964844	57.30562973022461	78.75032806396484	63.77882766723633	23.271652221679688	28.782997131347656	48.43489456176758	60.73085784912109	345.54998779296875	159.06607055664062	62.076698303222656	68.66127014160156	121.1695556640625	58.12669372558594	38.29216003417969	102.74536895751952	477.3500061035156	138.29159545898438
57.191165924072266	48.8389778137207	113.62873077392578	34.279441833496094	57.92950820922852	87.3990478515625	143.3000030517578	45.0529670715332	115.51824951171876	141.44000244140625	71.40852355957031	36.086273193359375	93.496826171875	100.81999969482422	48.29133224487305	59.65380859375	9.427026748657228	34.92612075805664	55.01858901977539	94.3095474243164	52.183067321777344	49.810001373291016	98.85505676269533	150.1199951171875	84.90125274658203	80.07958221435547	77.42450714111328	39.09104919433594	10.194483757019045	12.479999542236328	58.77165222167969	153.65321350097656	114.35638427734376	121.21932220458984	968	37.4474983215332	121.68000030517578	177.3638916015625	127.06631469726562	52.27309799194336	43.700721740722656	127.92990112304688	35.20342254638672	71.28384399414062	74.85163116455078	56.17506408691406	165.05267333984375	198.85284423828125	81.16295623779297	72.06758117675781	78.86608123779297	570.4600219726562	186.33529663085935	22.04811286926269	57.51475143432617	43.56507873535156	51.03343200683594	183.83290100097656	35.36306381225586	35.89290237426758	271.3599853515625	226.30999755859372	45.59546661376953	1870.52001953125	33.051361083984375	377.5545349121094	40.61752700805664	48.68769836425781	70.11540222167969	169.3699951171875	27.71999931335449	39.362789154052734	106.11972045898438	58.81536102294922	31.471153259277344	65.78832244873047	95.92391204833984	132.10435485839844	86.12528228759766	36.400001525878906	85.83464050292969	59.59777069091797	33.4900016784668	59.70967864990234	86.38423156738281	64.87191009521484	24.45429229736328	30.23193359375	48.8242301940918	62.66356658935547	336.8500061035156	165.1433868408203	64.17601013183594	66.65608978271484	118.94666290283205	62.094505310058594	35.7479248046875	109.70948791503906	416.1000061035156	143.18763732910156
57.78242111206055	48.955448150634766	109.21809387207033	35.400516510009766	55.85231018066406	86.74261474609375	148.08999633789062	45.58126068115234	120.31907653808594	146.49000549316406	72.9288101196289	36.783935546875	109.12242889404295	110.79000091552734	49.94489669799805	60.57259750366211	9.486422538757324	35.85681915283203	57.88565826416016	95.7466049194336	53.95296478271485	47.13999938964844	108.77822875976562	167.22999572753906	80.61647033691406	82.75220489501953	77.69750213623047	41.92991256713867	10.087862014770508	13.609999656677246	59.83846282958984	155.68727111816406	130.15914916992188	125.5084457397461	987.780029296875	37.3224983215332	129.5500030517578	176.16395568847656	132.05531311035156	49.69331741333008	45.113956451416016	127.9553680419922	36.6158447265625	73.53662872314453	78.2896728515625	60.28305816650391	166.43304443359375	211.3620147705078	85.80667877197266	74.97986602783203	79.79292297363281	539.8200073242188	228.4645233154297	21.92088508605957	57.45774459838867	37.50202178955078	52.24347305297852	190.4839782714844	35.51492691040039	36.61234664916992	289.5899963378906	235.6300048828125	47.39176177978516	2028.5	22.36772727966309	383.5803527832031	40.3192253112793	49.71876907348633	70.70700073242188	174.97000122070312	26.6200008392334	43.432865142822266	104.935546875	60.19605255126953	30.133455276489254	65.61441802978516	101.71722412109376	133.74159240722656	89.07466125488281	37.9900016784668	86.98648071289062	60.69755554199219	36.900001525878906	60.56908798217773	87.50338745117188	62.822391510009766	25.670005798339844	29.723552703857425	50.20764923095703	59.86249923706055	391.9700012207031	171.23057556152344	67.94065856933594	64.92069244384766	119.16984558105467	61.52577209472656	37.30487060546875	108.02262115478516	343.7699890136719	148.2012481689453
62.546875	43.42321014404297	95.45978546142578	39.03505706787109	60.69923782348633	74.1962661743164	150.8000030517578	47.47373962402344	122.13102722167967	155.16000366210938	77.23015594482422	36.03395462036133	97.70636749267578	114.45999908447266	53.4080924987793	63.22599792480469	9.367629051208496	37.1157455444336	53.49005508422852	86.1237564086914	53.13619995117188	47.150001525878906	109.2103500366211	176.74000549316406	70.61862182617188	82.29752349853516	75.27781677246094	42.69639205932617	10.473334312438965	13	61.46122741699219	158.59568786621094	124.43638610839844	136.29815673828125	980.5999755859376	44.03749847412109	128.82000732421875	185.46365356445312	133.35475158691406	51.81305313110352	35.59927749633789	130.8538055419922	38.68031692504883	78.40001678466797	79.4447021484375	63.97146224975586	162.4355010986328	215.9978485107422	87.03474426269531	74.79497528076172	80.91166687011719	528.4400024414062	225.8261260986328	21.71184730529785	58.93979263305664	29.280517578125	48.58983612060547	188.63023376464844	34.285621643066406	39.31009292602539	316.5599975585937	217.82000732421875	46.93459701538086	1852.0799560546875	29.507219314575195	376.8175964355469	38.48128509521485	53.21578979492188	72.8227767944336	181.16000366210935	27.549999237060547	43.12621307373047	104.66651153564452	59.82667922973633	28.74793815612793	57.29158782958984	105.63421630859376	129.13931274414062	95.06761932373048	36.08000183105469	93.78418731689452	63.1516227722168	39.290000915527344	60.55953598022461	88.70072937011719	66.15040588378906	25.355144500732425	28.21665954589844	47.2149543762207	64.44274139404297	398.5400085449219	179.6165008544922	68.52928924560547	64.77588653564453	124.46178436279295	58.07126998901367	37.452423095703125	110.82404327392578	316.7099914550781	140.6808624267578
62.04434585571289	46.18577194213867	96.7273941040039	36.82748794555664	71.62992858886719	76.85820770263672	168.60000610351562	49.72907638549805	126.15662384033205	149.17999267578125	79.53771209716797	37.35667419433594	100.32177734375	112.26000213623048	51.49398040771485	60.81762313842773	9.452112197875977	36.79233551025391	54.29487991333008	87.34129333496094	56.86801528930664	48.720001220703125	128.0445556640625	186.2700042724609	72.4129409790039	83.9222640991211	82.69944763183594	49.40608215332031	9.882824897766112	12.75	64.17232513427734	167.46124267578125	134.18563842773438	125.83063507080078	961.3499755859376	47.40250015258789	122.7300033569336	179.635986328125	140.00527954101562	55.29267883300781	41.978546142578125	136.1196746826172	40.448516845703125	80.32479095458984	76.04183959960938	62.9469108581543	154.3799591064453	207.8316192626953	90.8019790649414	75.18904876708984	85.0089340209961	595.1099853515625	240.96495056152344	23.147445678710938	59.7700309753418	33.63783264160156	51.0076789855957	185.3293609619141	35.30078887939453	40.24393844604492	313.1199951171875	222.22000122070312	47.59893798828125	1830.8199462890625	32.030601501464844	404.499755859375	39.84386444091797	56.084232330322266	75.33006286621094	183.32000732421875	29.170000076293945	47.755855560302734	106.64527130126952	64.26497650146484	29.881561279296875	56.832984924316406	112.12564849853516	130.17111206054688	101.69227600097656	37.880001068115234	86.46757507324219	59.03463363647461	39.470001220703125	63.189491271972656	95.32904815673828	69.60529327392578	31.05440139770508	32.25369644165039	45.77165985107422	69.87288665771484	363.4200134277344	184.43101501464844	68.28848266601562	65.86994171142578	118.51410675048828	64.88668060302734	35.488033294677734	119.5278778076172	307.8299865722656	149.35267639160156


CREATE TABLE prices (
  "a" DOUBLE,
  "aal" DOUBLE,
  "aap" DOUBLE,
  "aapl" DOUBLE,
  "abbv" DOUBLE,
  "abc" DOUBLE,
  "abmd" DOUBLE,
  "abt" DOUBLE,
  "acn" DOUBLE,
  "adbe" DOUBLE,
  "adi" DOUBLE,
  "adm" DOUBLE,
  "adp" DOUBLE,
  "adsk" DOUBLE,
  "aee" DOUBLE,
  "aep" DOUBLE,
  "aes" DOUBLE,
  "afl" DOUBLE,
  "aig" DOUBLE,
  "aiz" DOUBLE,
  "ajg" DOUBLE,
  "akam" DOUBLE,
  "alb" DOUBLE,
  "algn" DOUBLE,
  "alk" DOUBLE,
  "all" DOUBLE,
  "alle" DOUBLE,
  "amat" DOUBLE,
  "amcr" DOUBLE,
  "amd" DOUBLE,
  "ame" DOUBLE,
  "amgn" DOUBLE,
  "amp" DOUBLE,
  "amt" DOUBLE,
  "amzn" DOUBLE,
  "anet" DOUBLE,
  "anss" DOUBLE,
  "antm" DOUBLE,
  "aon" DOUBLE,
  "aos" DOUBLE,
  "apa" DOUBLE,
  "apd" DOUBLE,
  "aph" DOUBLE,
  "aptv" DOUBLE,
  "ato" DOUBLE,
  "atvi" DOUBLE,
  "avb" DOUBLE,
  "avgo" DOUBLE,
  "avy" DOUBLE,
  "awk" DOUBLE,
  "axp" DOUBLE,
  "azo" DOUBLE,
  "ba" DOUBLE,
  "bac" DOUBLE,
  "bax" DOUBLE,
  "bbwi" DOUBLE,
  "bby" DOUBLE,
  "bdx" DOUBLE,
  "ben" DOUBLE,
  "bf_b" DOUBLE,
  "biib" DOUBLE,
  "bio" DOUBLE,
  "bk" DOUBLE,
  "bkng" DOUBLE,
  "bkr" DOUBLE,
  "blk" DOUBLE,
  "bll" DOUBLE,
  "bmy" DOUBLE,
  "br" DOUBLE,
  "brk_b" DOUBLE,
  "bsx" DOUBLE,
  "bwa" DOUBLE,
  "bxp" DOUBLE,
  "c" DOUBLE,
  "cag" DOUBLE,
  "cah" DOUBLE,
  "cat" DOUBLE,
  "cb" DOUBLE,
  "cboe" DOUBLE,
  "cbre" DOUBLE,
  "cci" DOUBLE,
  "ccl" DOUBLE,
  "cdns" DOUBLE,
  "cdw" DOUBLE,
  "ce" DOUBLE,
  "cern" DOUBLE,
  "cf" DOUBLE,
  "cfg" DOUBLE,
  "chd" DOUBLE,
  "chrw" DOUBLE,
  "chtr" DOUBLE,
  "ci" DOUBLE,
  "cinf" DOUBLE,
  "cl" DOUBLE,
  "clx" DOUBLE,
  "cma" DOUBLE,
  "cmcsa" DOUBLE,
  "cme" DOUBLE,
  "cmg" DOUBLE,
  "cmi" DOUBLE
);