Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pki
@kaggle.rprkh15_sp500_stock_prices.pki

  • 522.77 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.50711280107498170.50711280107498170.50711280107498170.507112801074981759200
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.51141035556793210.51141035556793210.51141035556793210.511410355567932149600
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.48992231488227840.48992231488227840.48992231488227840.489922314882278492800
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.50711280107498170.50711280107498170.50711280107498170.507112801074981773600
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.48132756352424620.48132756352424620.48132756352424620.4813275635242462131200
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.50281506776809690.50281506776809690.50281506776809690.502815067768096957600
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.48132756352424620.48132756352424620.48132756352424620.481327563524246268800
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.48562479019165040.48562479019165040.48562479019165040.4856247901916504182400
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.48132756352424620.48132756352424620.48132756352424620.481327563524246244800
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.48992231488227840.48992231488227840.48992231488227840.489922314882278441600

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