Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ph
@kaggle.rprkh15_sp500_stock_prices.ph

  • 486.96 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)2.56699749876947842.4963462352752692.49634623527526944550
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.5434480570278492.508122522220292.53167295455932634425
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.51989841461181642.4963479770155782.51989841461181649113
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.4963462352752692.4963462352752692.4963462352752697088
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.50812292098999022.4727971531639512.508122920989990224300
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.5081223757264482.4610215137994322.48457217216491743538
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.49634669584059272.42569541931152342.425695419311523461763
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.47279628512846642.4256956568977132.461021184921264681000
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.42569589369379822.35504460334777832.355044603347778374419
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)2.37859520027783772.35504499366137182.366820096969604531388

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