Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tjx
@kaggle.rprkh15_sp500_stock_prices.tjx

  • 432.45 KB
  • 8831 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 26 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.39618468680311540.37967699151965230.392058014869689946172800
Mon Jun 29 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.39412135083640270.38999417512809670.39205801486968996297600
Tue Jun 30 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.41888303618207460.39824815817443490.408565849065780615328000
Wed Jul 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.41475585368360950.40443866670131680.412692517042165788800
Thu Jul 02 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.41681936197682340.41269218820742730.41475552320480342870400
Mon Jul 06 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.44158110536170.41681956217622770.43332725763320929600000
Tue Jul 07 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.44158110982111750.42300957441329950.42300957441329957187200
Wed Jul 08 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.42713675225743770.41681956838682010.42094624042510981392000
Thu Jul 09 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.45396177297615810.42094637130516470.44158124923706057923200
Fri Jul 10 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.46221539977194780.43745386049845060.44777104258537294115200

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