S&P500 Stock Prices
Historical stock price data of all S&P500 companies
@kaggle.rprkh15_sp500_stock_prices
Historical stock price data of all S&P500 companies
@kaggle.rprkh15_sp500_stock_prices
dateDate | openOpen | highHigh | lowLow | closeClose | volumeVolume | dividendsDividends | stock_splitsStock Splits |
---|---|---|---|---|---|---|---|
Thu Jul 19 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.962492823600769 | 0.9674545558301128 | 0.9525705088888616 | 0.962492823600769 | 70200 | ||
Fri Jul 20 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.957531775118996 | 0.9674546658325552 | 0.952570617198944 | 0.952570617198944 | 52650 | ||
Mon Jul 23 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.947608995359324 | 0.9525701508505502 | 0.9277632236480712 | 0.9277632236480712 | 113400 | ||
Tue Jul 24 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.9327249540124716 | 0.9376861095036976 | 0.9228020681568452 | 0.9277632236480712 | 55350 | ||
Wed Jul 25 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.9128797571743926 | 0.9277632236480712 | 0.9079180268099925 | 0.9277632236480712 | 116100 | ||
Thu Jul 26 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.937686324119568 | 0.937686324119568 | 0.9327251674928416 | 0.937686324119568 | 66150 | ||
Fri Jul 27 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.937686324119568 | 0.9426474807462942 | 0.9277634359928096 | 0.937686324119568 | 144450 | ||
Mon Jul 30 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.9476091756910004 | 0.9476091756910004 | 0.9327251315116882 | 0.9327251315116882 | 135000 | ||
Tue Jul 31 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.9327254106452808 | 0.952570617198944 | 0.9277636778517736 | 0.952570617198944 | 82350 | ||
Wed Aug 01 1984 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.9525706239810012 | 1.026990228930622 | 0.9525706239810012 | 1.01210618019104 | 697950 |
CREATE TABLE ame (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" BIGINT,
"dividends" DOUBLE,
"stock_splits" DOUBLE
);
Anyone who has the link will be able to view this.