Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Uri
@kaggle.rprkh15_sp500_stock_prices.uri

  • 231.81 KB
  • 6180 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Dec 18 1997 00:00:00 GMT+0000 (Coordinated Universal Time)14.516.12514.375151905200
Fri Dec 19 1997 00:00:00 GMT+0000 (Coordinated Universal Time)1515.62514.687515.5275200
Mon Dec 22 1997 00:00:00 GMT+0000 (Coordinated Universal Time)15.515.875151588300
Tue Dec 23 1997 00:00:00 GMT+0000 (Coordinated Universal Time)1515.81251515.574500
Wed Dec 24 1997 00:00:00 GMT+0000 (Coordinated Universal Time)1616.251616.2545400
Fri Dec 26 1997 00:00:00 GMT+0000 (Coordinated Universal Time)16.31251716.251745400
Mon Dec 29 1997 00:00:00 GMT+0000 (Coordinated Universal Time)16.7517.87516.7517.8125107100
Tue Dec 30 1997 00:00:00 GMT+0000 (Coordinated Universal Time)17.812518.062517.562517.937549600
Wed Dec 31 1997 00:00:00 GMT+0000 (Coordinated Universal Time)1819.312517.812519.312550800
Fri Jan 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)20.2520.2519.062520.0625209500

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