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 |
---|---|---|---|---|---|---|---|
Fri Dec 06 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.438661376535018 | 4.916671138381462 | 4.427280204650509 | 4.8825273513793945 | 27551000 | ||
Mon Dec 09 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.8597677159359005 | 4.8711491655117785 | 4.682221009973379 | 4.782375812530518 | 3149500 | ||
Tue Dec 10 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.785787623597251 | 4.928052418794302 | 4.740262932549965 | 4.8654561042785645 | 1723000 | ||
Wed Dec 11 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.859767941883163 | 5.1784414897579625 | 4.814243226857822 | 5.128364086151123 | 2549000 | ||
Thu Dec 12 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 5.128362894246195 | 5.128362894246195 | 4.962197668753135 | 4.99747896194458 | 1355500 | ||
Fri Dec 13 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.9974799501021865 | 5.004308711388886 | 4.9223641186458815 | 4.967888832092285 | 987500 | ||
Mon Dec 16 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.950818187182518 | 4.9792712744330645 | 4.888221829389317 | 4.9052934646606445 | 798000 | ||
Tue Dec 17 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.893911975428886 | 5.0077237682463736 | 4.871149616865389 | 4.924641132354736 | 1646000 | ||
Wed Dec 18 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.916672102366403 | 4.916672102366403 | 4.84269433493841 | 4.856351852416992 | 742000 | ||
Thu Dec 19 2002 00:00:00 GMT+0000 (Coordinated Universal Time) | 4.842697838712339 | 4.85976947656359 | 4.799449182971426 | 4.814244747161865 | 684000 |
CREATE TABLE cme (
"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.