Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ftnt
@kaggle.rprkh15_sp500_stock_prices.ftnt

  • 132.71 KB
  • 3182 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Nov 18 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.70000004768371581.751.63300001621246341.6619999408721924136704000
Thu Nov 19 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.6569999456405641.7120000123977661.60599994659423851.689000010490417722173000
Fri Nov 20 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.6879999637603761.69599997997283941.60599994659423851.69400000572204611390000
Mon Nov 23 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.70599997043609621.71700000762939431.6599999666213991.69000005722045911858000
Tue Nov 24 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.67999994754791261.70500004291534421.67299997806549071.70099997520446784677000
Wed Nov 25 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.7150000333786011.72800004482269291.69500005245208741.72000002861022954280000
Fri Nov 27 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.67700004577636721.76800000667572021.66999995708465581.68900001049041771740000
Mon Nov 30 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.70500004291534421.73199999332427981.6809999942779541.69900000095367434338000
Tue Dec 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.70000004768371581.72399997711181641.6629999876022341.68200004100799564125000
Wed Dec 02 2009 00:00:00 GMT+0000 (Coordinated Universal Time)1.6900000572204591.6900000572204591.61500000953674321.66199994087219249602000

CREATE TABLE ftnt (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" DOUBLE
);

Share link

Anyone who has the link will be able to view this.