Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Reg
@kaggle.rprkh15_sp500_stock_prices.reg

  • 338.48 KB
  • 7226 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Oct 29 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0995998382568364.1262206164273354.0995998382568364.0995998382568361381000
Mon Nov 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0995989768735824.1262197494506844.0995989768735824.126219749450684136800
Tue Nov 02 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0995989926656094.1262197653452563.9664951292673753.9931159019470215182600
Wed Nov 03 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.9398735122175414.04635658011531253.9132527452430984.019735813140869146300
Thu Nov 04 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.99311590194702154.0197366746266683.99311590194702153.993115901947021548300
Fri Nov 05 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.99311590194702154.0197366746266683.99311590194702153.993115901947021513900
Mon Nov 08 1993 00:00:00 GMT+0000 (Coordinated Universal Time)3.9931150461664264.0197358131408693.9931150461664264.01973581314086922800
Tue Nov 09 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0197366746266684.0463574473063153.99311590194702153.993115901947021510600
Wed Nov 10 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0197358131408694.04635658011531254.0197358131408694.019735813140869143900
Thu Nov 11 1993 00:00:00 GMT+0000 (Coordinated Universal Time)4.0197358131408694.0197358131408694.0197358131408694.01973581314086929800

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