Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Has
@kaggle.rprkh15_sp500_stock_prices.has

  • 486.54 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05581219121813770.05581219121813770.055812191218137711391
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05348648215043020.05232361704111090.052323617041110928477
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05813738331198690.05348645785409250.058137383311986996820
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05697507783770560.05697507783770560.056975077837705617086
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05581219121813770.05581219121813770.05581219121813775695
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05464931594969780.05348645150661460.053486451506614645563
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.05232359548617210.04999839514493940.049998395144939468344
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.04883553832769390.04883553832769390.04883553832769395695
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.04767268557390030.04185889288783070.041858892887830774039
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.04534745961427680.04418459523726050.0453474596142768130992

CREATE TABLE has (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Share link

Anyone who has the link will be able to view this.