Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Pld
@kaggle.rprkh15_sp500_stock_prices.pld

  • 308.37 KB
  • 6198 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Nov 21 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.589018925376568.589018925376568.3149013000985858.406273841857913821400
Mon Nov 24 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.4062748584118528.4062748584118528.1321571999853798.314902305603027541600
Tue Nov 25 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.3605875709782488.406273841857918.2920581646587538.40627384185791425000
Wed Nov 26 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.4062748584118528.4062748584118528.3149023056030278.314902305603027165200
Fri Nov 28 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.3149013000985858.406273841857918.3149013000985858.4062738418579160500
Mon Dec 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.4291152954101568.4519584262920278.4062721645282868.429115295410156120300
Tue Dec 02 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.4519601127375748.4519601127375748.3605875709782488.40627384185791164200
Wed Dec 03 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.4291169772977428.4291169772977428.3834307064180788.40627384185791540000
Thu Dec 04 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.406273841857918.4291169772977428.406273841857918.4062738418579143800
Fri Dec 05 1997 00:00:00 GMT+0000 (Coordinated Universal Time)8.3605859027645468.5433309498195088.3605859027645468.429115295410156147500

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

Share link

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