Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Spg
@kaggle.rprkh15_sp500_stock_prices.spg

  • 352.96 KB
  • 7195 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Dec 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8553695678710944.8553695678710944.8014208249507564.8553695678710947717345
Wed Dec 15 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8553695678710944.8553695678710944.8014208249507564.8553695678710941833877
Thu Dec 16 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8553695678710944.8823439393312624.8283951964109254.855369567871094624688
Fri Dec 17 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8553721365853474.8553721365853474.8283977508544924.828397750854492490765
Mon Dec 20 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8283951964109254.8553695678710944.8283951964109254.855369567871094546144
Tue Dec 21 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8283977508544924.8553721365853474.8014233651236384.828397750854492311482
Wed Dec 22 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8283951964109254.8553695678710944.8283951964109254.855369567871094274958
Thu Dec 23 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8553695678710944.8553695678710944.8283951964109254.855369567871094147391
Mon Dec 27 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8553721365853474.8553721365853474.8283977508544924.828397750854492164307
Tue Dec 28 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.8283951964109254.8553695678710944.8283951964109254.855369567871094283577

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