Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Schw
@kaggle.rprkh15_sp500_stock_prices.schw

  • 427.45 KB
  • 8771 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Sep 22 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.2575066935053550.25557088851928710.255570888519287169213994
Wed Sep 23 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.26331549658968940.25557088851928710.255570888519287123109300
Thu Sep 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.26137915253639220.24782642740805860.261379152536392213163006
Fri Sep 25 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.26331546902656550.25750666655028020.263315469026565512757500
Mon Sep 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.26331568441164610.25750687718391420.25750687718391427700063
Tue Sep 29 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.25944337571636690.2516987621784210.25169876217842117860500
Wed Sep 30 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.24782651342365270.23814609126688860.245889991521835316739663
Thu Oct 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.25363460183143610.24201837406294970.253634601831436110757306
Fri Oct 02 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.25557110250194820.24976227352182680.25363460183143611549125
Mon Oct 05 1987 00:00:00 GMT+0000 (Coordinated Universal Time)0.24976213723382420.24201824200056770.24782635271549223836363

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