Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Sna
@kaggle.rprkh15_sp500_stock_prices.sna

  • 506.86 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.4212951660156253.4212951660156253.4212951660156253.42129516601562527000
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.3896186351776123.3896186351776123.3896186351776123.389618635177612336000
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.19954752922058063.19954752922058063.19954752922058063.19954752922058164800
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.1837069988250733.1837069988250733.1837069988250733.18370699882507342600
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.1045105457305913.1045105457305913.1045105457305913.10451054573059170200
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.2470631599426273.2470631599426273.2470631599426273.247063159942627115800
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.27874135971069343.27874135971069343.27874135971069343.278741359710693496600
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.37377929687500043.37377929687500043.37377929687500043.37377929687581000
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.34210038185119633.34210038185119633.34210038185119633.3421003818511963163800
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)3.3104202747344973.3104202747344973.3104202747344973.310420274734497278400

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