Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tdy
@kaggle.rprkh15_sp500_stock_prices.tdy

  • 211.37 KB
  • 5694 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Nov 23 1999 00:00:00 GMT+0000 (Coordinated Universal Time)8.43758.43758.43758.437560000
Wed Nov 24 1999 00:00:00 GMT+0000 (Coordinated Universal Time)8.437510.68758.437510.5917700
Fri Nov 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)10.510.510.510.532700
Mon Nov 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)10.62510.6259.259.25511000
Tue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.3759.3758.58.81252424000
Wed Dec 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)910.599.625462000
Thu Dec 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)10109.259.375799500
Fri Dec 03 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.59.6259.31259.4375292300
Mon Dec 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.3759.68759.18759.25239100
Tue Dec 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)9.18759.258.8758.9375753300

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

Share link

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