Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ew
@kaggle.rprkh15_sp500_stock_prices.ew

  • 227.24 KB
  • 5609 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 27 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.27083301544189431.38541698455810571.27083301544189431.37511026800
Tue Mar 28 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.3751.3751.33333301544189431.33854198455810573232800
Wed Mar 29 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.33333301544189431.343751.31770801544189431.33333301544189431311600
Thu Mar 30 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.33333301544189431.33333301544189431.281251.281255650800
Fri Mar 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.24479198455810571.24479198455810571.13020801544189431.130208015441894323794800
Mon Apr 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.16666698455810571.2343751.14583301544189431.145833015441894334460400
Tue Apr 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.17708301544189431.19270801544189431.031251.166666984558105739410400
Wed Apr 05 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.156251.18751.15104198455810571.161458015441894319048800
Thu Apr 06 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.16666698455810571.19791698455810571.156251.192708015441894321543600
Fri Apr 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)1.19791698455810571.27083301544189431.19791698455810571.20312541714400

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

Share link

Anyone who has the link will be able to view this.