Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Apd
@kaggle.rprkh15_sp500_stock_prices.apd

  • 505.3 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)1.663704610578771.62792611939325621.64581561088562271547
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.65177760997377351.62792506840959561.6398510932922363376188
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.69351982467722341.65774143632229041.6696679592132568858746
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.66966687506329771.65774035991646931.6637033224105835144422
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.66370332241058351.64581433656847431.6637033224105835106370
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.6517777994605031.60407280921936041.6040728092193604744593
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.6100364434124681.58022092457599261.5861843824386597112424
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.6100351192061231.58021962489201131.592146039009094294263
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.5861840366636961.57425761533735061.5802205801010132133179
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)1.66966843069470721.59214787884992971.6517789363861084152205

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