Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Well
@kaggle.rprkh15_sp500_stock_prices.well

  • 421.45 KB
  • 10669 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.48816787610943580.44275689125061030.44275689125061031200
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.48816787610943580.44275689125061030.4427568912506103300
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.48816787610943580.44275689125061030.44275689125061031050
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44275689125061030.44275689125061030.44275689125061030.4427568912506103
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.44275689125061030.44275689125061030.44275689125061030.4427568912506103
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.4768153605619410.43140435218811030.43140435218811031800
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.43140435218811030.43140435218811030.43140435218811030.4314043521881103
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.4768153605619410.43140435218811030.4314043521881103300
Mon Mar 31 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.43140435218811030.43140435218811030.43140435218811030.4314043521881103
Tue Apr 01 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.4768153605619410.43140435218811030.4314043521881103300

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