Baselight

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Cday
@kaggle.artemburenok_sp_500_stock_prices.cday

  • 61.01 KB
  • 1168 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Thu Apr 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)28.89999961853027731.7528.64999961853027731.20999908447265631.20999908447265613590200
Fri Apr 27 2018 00:00:00 GMT+0000 (Coordinated Universal Time)30.95000076293945331.529.6800003051757830.52000045776367230.5200004577636721744900
Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)30.760000228881843230.20999908447265631.5799999237060531.57999992370605638900
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)31.42000007629394532.40000152587890631.2600002288818431.47999954223632831.479999542236328858600
Wed May 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)31.47999954223632833.65000152587890631.47999954223632832.7532.75845500
Thu May 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)32.63000106811523434.4300003051757832.52999877929687533.79000091552734433.7900009155273441807900
Fri May 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)33.88000106811523434.8899993896484433.7999992370605534.0900001525878934.09000015258789679600
Mon May 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)34.0900001525878934.7000007629394533.90000152587890633.990001678466833.9900016784668325600
Tue May 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)34.4799995422363334.7700004577636732.45999908447265632.9500007629394532.95000076293945413900
Wed May 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)33.13000106811523434.2533.0449981689453133.47000122070312533.470001220703125466700

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

Share link

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