Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Cci
@kaggle.rprkh15_sp500_stock_prices.cci

  • 299.58 KB
  • 6014 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Aug 18 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.5784653425216679.764454960823069.5784653425216679.6714601516723635783000
Wed Aug 19 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.6714601516723639.8574497699737579.6714601516723639.671460151672363388700
Thu Aug 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.764454960823069.8574497699737579.6714601516723639.671460151672363348500
Fri Aug 21 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.6714601516723639.6714601516723639.6714601516723639.671460151672363804000
Mon Aug 24 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.6714601516723639.6714601516723639.6714601516723639.671460151672363119700
Tue Aug 25 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.6714601516723639.6714601516723639.5784653425216679.671460151672363294100
Wed Aug 26 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.6714619227818079.6714619227818079.0204981395176479.113492965698242383800
Thu Aug 27 1998 00:00:00 GMT+0000 (Coordinated Universal Time)9.113492215617329.2064870341440277.9975543932968328.276538848876953435300
Fri Aug 28 1998 00:00:00 GMT+0000 (Coordinated Universal Time)8.4625260055065178.4625260055065177.439583301544197.439583301544189192400
Mon Aug 31 1998 00:00:00 GMT+0000 (Coordinated Universal Time)7.4395857590895437.5325805810781635.6726841413057776.044663429260254150800

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