Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Unp
@kaggle.rprkh15_sp500_stock_prices.unp

  • 534.02 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)1.0826326153591941.09774793515842341.0826326153591941.0845220088958741165973
Thu Jan 03 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.07696495693724481.07696495693724481.059960231294271.06940746307373051453896
Fri Jan 04 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.07129678153514531.0883014202117921.07129678153514531.0883014202117921382510
Mon Jan 07 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.088300995627991.09774822304765121.08263289928436281.08263289928436281087448
Tue Jan 08 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.08263394119393361.09208074894046341.04295611381530761.04295611381530761213563
Wed Jan 09 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.04295501932011311.05429155403239161.01272446017749341.03539752960205089965497
Thu Jan 10 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.03539776698191521.03728716128282921.02784001827241.02784001827245922665
Fri Jan 11 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.02783958171979051.0335076764622021.02406079472292031.0297288894653325394408
Mon Jan 14 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.0297293811367911.05429185135601841.0297293811367911.05051314830780034000000
Tue Jan 15 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.05807015637077531.0845220088958741.05807015637077531.0845220088958741886972

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