Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Gpn
@kaggle.rprkh15_sp500_stock_prices.gpn

  • 274.88 KB
  • 5406 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Jan 16 2001 00:00:00 GMT+0000 (Coordinated Universal Time)3.5568473339080813.5568473339080813.5568473339080813.5568473339080813200
Wed Jan 17 2001 00:00:00 GMT+0000 (Coordinated Universal Time)3.5568473339080813.5568473339080813.5568473339080813.556847333908081122800
Thu Jan 18 2001 00:00:00 GMT+0000 (Coordinated Universal Time)3.6754066944122313.9125297069549563.6754066944122313.912529706954956167200
Fri Jan 19 2001 00:00:00 GMT+0000 (Coordinated Universal Time)3.9718107515878054.0607318878173833.9718107515878054.06073188781738359600
Mon Jan 22 2001 00:00:00 GMT+0000 (Coordinated Universal Time)4.0310935451559824.3867782697285694.0310935451559824.327497482299805146800
Tue Jan 23 2001 00:00:00 GMT+0000 (Coordinated Universal Time)4.2682164001464854.5349799251556394.2682164001464854.44605875015258876000
Wed Jan 24 2001 00:00:00 GMT+0000 (Coordinated Universal Time)4.3867782697285694.3867782697285694.3274974822998054.327497482299805560000
Thu Jan 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)4.4164183584849044.4460587501525884.386777966817224.446058750152588143200
Fri Jan 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)4.3867759704589844.4015961595483734.3867759704589844.38677597045898482000
Mon Jan 29 2001 00:00:00 GMT+0000 (Coordinated Universal Time)4.3915194911855424.44605769030697754.3630645229659724.434201717376709262000

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