Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Swks
@kaggle.rprkh15_sp500_stock_prices.swks

  • 383.29 KB
  • 9538 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Sep 07 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.4110087606518785.4110087606518785.3739476203918465.37394762039184611400
Mon Sep 10 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.3739467995553455.4110079341545225.18863773345947355.1886377334594737500
Tue Sep 11 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.1886388643034345.2627628462068195.1515777216269235.22570085525512727000
Wed Sep 12 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.1515780063974095.1515780063974094.9662688896705545.0403928756713877800
Thu Sep 13 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.0403928756713875.0403928756713874.9662688896705545.04039287567138710500
Fri Sep 14 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.0774534943652825.1515774726867685.0774534943652825.15157747268676810800
Mon Sep 17 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.1145160133969925.1145160133969925.0403928756713875.0403928756713871200
Tue Sep 18 1984 00:00:00 GMT+0000 (Coordinated Universal Time)5.0033299723844615.0033299723844614.9292068481445314.92920684814453110500
Wed Sep 19 1984 00:00:00 GMT+0000 (Coordinated Universal Time)4.9292068481445315.0033299723844614.9292068481445314.92920684814453115300
Thu Sep 20 1984 00:00:00 GMT+0000 (Coordinated Universal Time)4.9292069240385024.9662680625915544.9292069240385024.96626806259155310800

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