Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Stx
@kaggle.rprkh15_sp500_stock_prices.stx

  • 255.25 KB
  • 4929 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Dec 11 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.9259672164916996.1836179650348165.7971418422201415.92596721649169936719700
Thu Dec 12 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.9259670453498565.9723442573770135.6786225697780745.7610707283020029195600
Fri Dec 13 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.7198478166200945.9259682550048275.64255228365340145.8847441673278817739400
Mon Dec 16 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.8332110039030445.9878015039865155.7353039656603145.98264837265014653836400
Tue Dec 17 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.9774975627722446.07025149807555.9002020433514275.9259672164916992729900
Wed Dec 18 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.8847450204116355.8898981549757515.7353075580619865.7713785171508792152800
Thu Dec 19 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.7456121239250175.7713772998813795.5188796566547235.5446448326110846450800
Fri Dec 20 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.5910208591911425.6373975763104945.4415834602161135.5704088211059572930900
Mon Dec 23 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.5188798067127165.5188798067127165.2560758893859525.359136104583743455900
Tue Dec 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)5.3591343365160535.3848995046726095.1530139741230165.2766861915588383302500

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