Baselight
Sign In

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Mktx
@kaggle.artemburenok_sp_500_stock_prices.mktx

  • 204.49 KB
  • 4558 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Fri Nov 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)12.7517.61000061035156212.7517.48999977111816415.2932806015014658150300
Mon Nov 08 2004 00:00:00 GMT+0000 (Coordinated Universal Time)17.129999160766618.879999160766616.518.70000076293945316.3513031005859381113400
Tue Nov 09 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.73999977111816419.60000038146972717.3199996948242218.5699996948242216.237634658813477521600
Wed Nov 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)18.35000038146972721.23999977111816418.02000045776367220.14999961853027717.619186401367188709500
Thu Nov 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)20.70000076293945324.4099998474121120.37000083923342118.36243247985841757100
Fri Nov 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)22.14999961853027722.52121.39999961853027718.712188720703125580900
Mon Nov 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)21.64999961853027723.10000038146972720.5900001525878921.6100006103515618.89582061767578638900
Tue Nov 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)22.19000053405761722.4699993133544920.95000076293945322.20000076293945319.41171264648437457500
Wed Nov 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)21.79999923706054723.2521.7999992370605472219.23682975769043442500
Thu Nov 18 2004 00:00:00 GMT+0000 (Coordinated Universal Time)21.80999946594238321.98999977111816420.5100002288818420.8400001525878918.2225284576416273900

CREATE TABLE mktx (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);