Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Bbwi
@kaggle.rprkh15_sp500_stock_prices.bbwi

  • 487.74 KB
  • 10155 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Apr 01 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.65188024498468030.64741516113281250.6474151611328125128395
Fri Apr 02 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.6563450715571560.64741516113281250.6474151611328125161627
Mon Apr 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.6608103523356510.65188050270080570.6518805027008057196369
Tue Apr 06 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.65634533103841810.65188050270080570.6518805027008057136703
Wed Apr 07 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.65634533103841810.65188050270080570.651880502700805764198
Thu Apr 08 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.67420520794469540.66974037885665890.6697403788566589294554
Mon Apr 12 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.66527523971023430.66081041097640990.6608104109764099299085
Tue Apr 13 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.66527523971023430.66081041097640990.660810410976409999695
Wed Apr 14 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.64295043777429920.63848561048507690.6384856104850769171445
Thu Apr 15 1982 00:00:00 GMT+0000 (Coordinated Universal Time)0.65634533103841810.65188050270080570.6518805027008057219027

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