Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Bro
@kaggle.rprkh15_sp500_stock_prices.bro

  • 397.24 KB
  • 10442 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 11 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.10971381029972820.09752351045608520.097523510456085247250
Thu Feb 12 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852
Fri Feb 13 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852
Tue Feb 17 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852
Wed Feb 18 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.10971381029972820.09752351045608520.09752351045608526750
Thu Feb 19 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852
Fri Feb 20 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.10971381029972820.09752351045608520.0975235104560852337500
Mon Feb 23 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852
Tue Feb 24 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852
Wed Feb 25 1981 00:00:00 GMT+0000 (Coordinated Universal Time)0.09752351045608520.09752351045608520.09752351045608520.0975235104560852

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