Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Aap
@kaggle.rprkh15_sp500_stock_prices.aap

  • 264.85 KB
  • 5189 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Nov 29 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.24429819819405613.23213489207439212.21990631796233612.695531845092772371100
Fri Nov 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.69553519916393113.04920578002929712.69553519916393113.049205780029297165300
Mon Dec 03 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.01871428655253613.01871428655253612.60711574554443412.607115745544434127500
Tue Dec 04 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.60711690746986412.60711690746986412.1040515899658212.1040515899658295400
Wed Dec 05 2001 00:00:00 GMT+0000 (Coordinated Universal Time)12.28698921628487813.52178537009183212.28698921628487813.415075302124023598200
Thu Dec 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.47605040074392413.47605040074392413.32665562532263513.329704284667969157200
Fri Dec 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.33885270348618213.41507530212402313.23214263551837513.415075302124023215100
Mon Dec 10 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.38458220196818413.3906803918969613.34189836163275613.369338035583496119100
Tue Dec 11 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.354096335318713.45470907324604313.34190082550048813.341900825500488378600
Wed Dec 12 2001 00:00:00 GMT+0000 (Coordinated Universal Time)13.33885375707389413.33885375707389412.83883776219066812.896766662597656114600

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