Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Zion
@kaggle.rprkh15_sp500_stock_prices.zion

  • 449.49 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.87981783034713510.84156459569931030.841564595699310372000
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.87025449125764590.83200168609619140.83200168609619148400
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.83200168609619140.83200168609619140.83200168609619140.8320016860961914
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.87025449125764590.83200168609619140.83200168609619141200
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.86069115349239020.82243835926055910.822438359260559138400
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.82243903039137630.78418576717376710.784185767173767193600
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.80331179078830890.76505899429321290.76505899429321298400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.80331179078830890.76505899429321290.7650589942932129110400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.77462217226951450.73636937141418460.736369371414184662400
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.79374903712595180.75549578666687010.755495786666870133600

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