Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Lmt
@kaggle.rprkh15_sp500_stock_prices.lmt

  • 552.01 KB
  • 11480 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Jan 03 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.33720379677417970.34176054596900940.33720379677417970.3417605459690094165282
Tue Jan 04 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.34176054596900940.34631727391331820.32353323043187720.3417605459690094179952
Wed Jan 05 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.34176055906223590.35087403655052180.34176055906223590.3508740365505218189732
Thu Jan 06 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.35087395279922950.36910128593444820.35087395279922950.3691012859344482384354
Fri Jan 07 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.36910150159600410.37365821003913880.36454475065181130.3736582100391388345234
Mon Jan 10 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.37365821003913880.37821496098333150.36910150159600410.3736582100391388311004
Tue Jan 11 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.37365802532827570.37365802532827570.36454457044601440.3645445704460144155502
Wed Jan 12 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.35998779845895390.35998779845895390.35087396165713050.3554310500621795198534
Thu Jan 13 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.3554311259282730.3554311259282730.3463172871811180.3508740365505218155502
Fri Jan 14 1977 00:00:00 GMT+0000 (Coordinated Universal Time)0.35087403655052180.3554311259282730.35087403655052180.3508740365505218116382

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