Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Nwl
@kaggle.rprkh15_sp500_stock_prices.nwl

  • 474 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.21124145739218760.19950582087039940.199505820870399443200
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.20244002342224120.19657220184686330.202440023422241224000
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.20537375264850770.19657219946384430.196572199463844327200
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.19363809201771820.18777027104748430.190704360604286260800
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.19950591298795210.19070436060428620.190704360604286246400
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.19363809201771820.18777027104748430.190704360604286219200
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.18777017295360560.18777017295360560.187770172953605654400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.19363815890204520.18190251290798180.181902512907981830400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.18190245032310480.17016680836677550.176034629344940156000
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.18483661467022860.17896879167319690.181902512907981811200

CREATE TABLE nwl (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);