Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

All
@kaggle.rprkh15_sp500_stock_prices.all

  • 366.69 KB
  • 7330 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 03 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.5972345027517767.661076809497597.4057075825143377.50147104263305756603000
Fri Jun 04 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.4376311926862557.5014735205204727.3099465370178227.30994653701782212644400
Mon Jun 07 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.2141826290554477.278024953206387.1503403049045147.182261466979980510043800
Tue Jun 08 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1822617505047777.2141829138403557.054577097162477.0864982604980476974600
Wed Jun 09 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1184198349978027.2780256608946137.1184198349978027.2141833305358894043200
Thu Jun 10 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1822593254702437.2141804780278887.1184170203549527.1503381729125982605400
Fri Jun 11 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1503381729125987.2461016305855347.1503381729125987.1503381729125982641600
Mon Jun 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1822617505047777.2141829138403557.0864982604980477.0864982604980471806200
Tue Jun 15 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1503393746277687.1503393746277687.0864970587828777.1184182167053222257600
Wed Jun 16 1993 00:00:00 GMT+0000 (Coordinated Universal Time)7.1184170203549527.1503381729125987.0864958677973067.1503381729125982391600

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