Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ttwo
@kaggle.rprkh15_sp500_stock_prices.ttwo

  • 274.47 KB
  • 6353 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Apr 15 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.6664406593797213.9164252281188973.4164560906405463.9164252281188971785600
Wed Apr 16 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.9164252441517164.1664098139142623.5831118487246843.708104133605957443700
Thu Apr 17 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.7497683970632474.0830808255970633.7497683970632473.833096265792847252150
Fri Apr 18 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.8330963055489073.99975299835205123.8330963055489073.999752998352051165900
Mon Apr 21 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.9164251287581923.99975299835205123.9164251287581923.99975299835205177400
Tue Apr 22 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.99975309982680473.99975309982680473.9164252281188973.91642522811889781600
Wed Apr 23 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.9997528923882384.4997220039367683.916425025001954.499722003936768180600
Thu Apr 24 1997 00:00:00 GMT+0000 (Coordinated Universal Time)4.4997220861317934.9996912068131034.416394217223384.833034515380859281550
Fri Apr 25 1997 00:00:00 GMT+0000 (Coordinated Universal Time)4.916363248099014.916363248099014.416394136550484.499722003936768114150
Mon Apr 28 1997 00:00:00 GMT+0000 (Coordinated Universal Time)4.4997222056551864.7080423602674094.3330655097961434.33306550979614376650

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