Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Spgi
@kaggle.rprkh15_sp500_stock_prices.spgi

  • 535 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.33975467085838320.33975467085838320.33975467085838320.339754670858383278400
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.33645591139793390.33645591139793390.33645591139793390.3364559113979339198400
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.33975467085838320.33975467085838320.33975467085838320.339754670858383256000
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.34305319190025330.34305319190025330.34305319190025330.3430531919002533211200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.34635171294212340.34635171294212340.34635171294212340.3463517129421234110400
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.34305319190025330.34305319190025330.34305319190025330.343053191900253340000
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.33975467085838320.33975467085838320.33975467085838320.3397546708583832289600
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.33645591139793390.33645591139793390.33645591139793390.336455911397933994400
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.33645591139793390.33645591139793390.33645591139793390.3364559113979339593600
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.34305319190025330.34305319190025330.34305319190025330.3430531919002533656000

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