Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Shw
@kaggle.rprkh15_sp500_stock_prices.shw

  • 482.21 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.1603116012028740.15194751322269440.15194751322269441401600
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14776577130127360.14567433408536560.1463718414306641459200
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.15055350959300990.14776566775852960.15055350959300991296000
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14915969950660070.14776578545570370.1477657854557037422400
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14776578545570370.14567434803945770.1477657854557037220800
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14567437779270440.14218956802385230.1442804634571075518400
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14567432615070220.14079558782254130.1421895176172256422400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.14079552791432790.13940161466598510.1394016146659851518400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13731017573509610.12964359718471610.1310375183820724892800
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.13661323487758630.1331284272905840.13661323487758631152000

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