Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dre
@kaggle.rprkh15_sp500_stock_prices.dre

  • 391.03 KB
  • 9181 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Feb 06 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.902308344841003695
Fri Feb 07 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Mon Feb 10 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Tue Feb 11 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Wed Feb 12 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Thu Feb 13 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.902308344841003695
Fri Feb 14 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Tue Feb 18 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Wed Feb 19 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036
Thu Feb 20 1986 00:00:00 GMT+0000 (Coordinated Universal Time)1.90230834484100361.90230834484100361.90230834484100361.9023083448410036

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