Baselight
Sign In

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Nwsa
@kaggle.artemburenok_sp_500_stock_prices.nwsa

  • 88.9 KB
  • 2390 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Wed Jun 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.27999973297119116.2515.19999980926513715.80000019073486314.23941898345947331981500
Thu Jun 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)16.370000839233416.370000839233415.2515.30000019073486313.788805007934579274200
Fri Jun 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.69999980926513715.80000019073486315.39999961853027215.61999988555908214.077198982238778323500
Mon Jun 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.64000034332275415.8400001525878915.19999980926513715.52999973297119113.9960861206054694279700
Tue Jun 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.55000019073486315.73999977111816415.35000038146972815.72000026702880914.167321205139163577300
Wed Jun 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.689999580383315.689999580383315.1800003051757815.39999961853027213.8789272308349614755100
Thu Jun 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.3400001525878915.86999988555908214.85000038146972815.513.96905040740966812121700
Fri Jun 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)15.515.77000045776367215.2515.2513.7437429428100616988100
Mon Jul 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)14.78999996185302715.5900001525878914.7514.78999996185302713.32917690277099625839400
Tue Jul 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)14.689999580383315.11999988555908214.68999958038331513.5184354782104530520100

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