Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Peg
@kaggle.rprkh15_sp500_stock_prices.peg

  • 493.54 KB
  • 10723 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jan 02 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44202649593353270.44780459802158840.44202649593353270.442026495933532761800
Thu Jan 03 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44202624200251230.4478043407712210.44202624200251230.444915324449539282500
Fri Jan 04 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44491507863539030.44780409336090090.44202599778457130.447804093360900941100
Mon Jan 07 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44780409336090090.44780409336090090.44202599778457130.447804093360900936600
Tue Jan 08 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.4478043407712210.45069342321824790.44202624200251230.444915324449539246200
Wed Jan 09 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.4449155800402520.44780459802158840.43913741182681330.4420264959335327288300
Thu Jan 10 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44202649593353270.4449155800402520.43913741182681330.442026495933532735100
Fri Jan 11 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44202621323472390.44491529549372450.43913713097572320.439137130975723259400
Mon Jan 14 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.43913713097572320.44491529549372450.43913713097572320.439137130975723252500
Tue Jan 15 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.43913713097572320.44202621323472390.43913713097572320.439137130975723262100

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