Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Trv
@kaggle.rprkh15_sp500_stock_prices.trv

  • 500.9 KB
  • 11764 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Nov 17 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.1850793361663823.1850793361663823.18507933616638253200
Tue Nov 18 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.27640700340271043.27640700340271043.27640700340271106800
Wed Nov 19 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.1279995441436773.1279995441436773.1279995441436768170400
Thu Nov 20 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.0823342800140383.0823342800140383.08233428001403861200
Fri Nov 21 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.0823342800140383.0823342800140383.08233428001403864000
Mon Nov 24 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.07091712951660163.07091712951660163.070917129516601688400
Tue Nov 25 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.05950164794921883.05950164794921883.059501647949218875200
Wed Nov 26 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.0823342800140383.0823342800140383.08233428001403889200
Fri Nov 28 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.10516452789306643.10516452789306643.105164527893066495600
Mon Dec 01 1975 00:00:00 GMT+0000 (Coordinated Universal Time)3.0138385295867923.0138385295867923.013838529586792102400

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