Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ball
@kaggle.rprkh15_sp500_stock_prices.ball

  • 515.46 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.1341400593519210.1341400593519210.1341400593519210.13414005935192157600
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.13226409256458280.13226409256458280.13226409256458280.1322640925645828140800
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.12663574516773220.12663574516773220.12663574516773220.1266357451677322288000
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.11913144588470450.11913144588470450.11913144588470450.1191314458847045345600
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.11913144588470450.11913144588470450.11913144588470450.1191314458847045243200
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.12194536626338950.12194536626338950.12194536626338950.1219453662633895179200
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.12006935477256770.12006935477256770.12006935477256770.120069354772567776800
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.12100737541913980.12100737541913980.12100737541913980.1210073754191398313600
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.12288329750299450.12288329750299450.12288329750299450.1228832975029945569600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.12757369875907890.12757369875907890.12757369875907890.1275736987590789147200

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