Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Bby
@kaggle.rprkh15_sp500_stock_prices.bby

  • 433.69 KB
  • 9384 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Apr 18 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.11074626463899450.10873296856880180.108732968568801815957000
Fri Apr 19 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.1097395643591880.11074621191504060.1097395643591880.10973956435918813065300
Mon Apr 22 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.10873296856880180.10873296856880180.10873296856880180.10873296856880182891700
Tue Apr 23 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.10873297954159110.10873297954159110.10671903192996970.10671903192996975718600
Wed Apr 24 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.10671903192996970.1077256800666520.10671903192996970.10671903192996972122200
Thu Apr 25 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.10269176208711070.10269176208711070.10168511420488350.10168511420488356172200
Fri Apr 26 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.10168515208330710.10168515208330710.09967185556888580.09967185556888582381400
Mon Apr 29 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.09866521147271370.09866521147271370.09665126353502270.09665126353502272502900
Tue Apr 30 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.09665126353502270.0996718597723780.09665126353502270.09665126353502272745900
Wed May 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)0.09363127797180560.09363127797180560.09161733090877530.09161733090877535030100

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