Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tgt
@kaggle.rprkh15_sp500_stock_prices.tgt

  • 563.56 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.20990523848145990.20490732789039610.2049073278903961523200
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.20490739809614960.19491207394249260.1961614340543747360000
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19741078405490570.19366271793842310.1936627179384231206400
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19366267363744740.1899141222238540.189914122223854235200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.18866490089356370.18491683316660330.1874155402183532619200
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19241332808352170.1849167114108280.189914122223854662400
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19491207807680560.1911640119603230.1936627179384231652800
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19491215050220490.1924134435956360.1949121505022049144000
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19741086591434210.19116409122943870.1911640912294387206400
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.19241345188588770.18991424441818390.1911640912294387206400

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