Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mmc
@kaggle.rprkh15_sp500_stock_prices.mmc

  • 536 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.95411837100982680.95411837100982680.95411837100982680.9541183710098268164400
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.96088451147079480.96088451147079480.96088451147079480.9608845114707948188400
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.96088451147079480.96088451147079480.96088451147079480.9608845114707948222000
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.94058442115783680.94058442115783680.94058442115783680.940584421157836861200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.90675079822540280.90675079822540280.90675079822540280.9067507982254028368400
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.89998435974121090.89998435974121090.89998435974121090.8999843597412109414000
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.85261648893356320.85261648893356320.85261648893356320.8526164889335632444000
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.86615031957626340.86615031957626340.86615031957626340.8661503195762634109200
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.9101344347000120.9101344347000120.9101344347000120.9101344347000122135600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.94058442115783680.94058442115783680.94058442115783680.9405844211578368202800

CREATE TABLE mmc (
  "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.