S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Table List

500 tables(151.9 MB)

results for

Ftv

Qcom

Incy

Ceg

Nws

@kaggle.artemburenok_sp_500_stock_prices.nws

85.43 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.210000038146973	16.030000686645508	14.960000038146973	15.529999732971191	14.026021003723145	7717000
Thu Jun 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	16.25	16.299999237060547	15.359999656677246	15.4399995803833	13.94473648071289	1874600
Fri Jun 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.979999542236328	15.979999542236328	15.460000038146973	15.800000190734863	14.26987361907959	635300
Mon Jun 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.789999961853027	15.789999961853027	15.1899995803833	15.520000457763672	14.016990661621094	758300
Tue Jun 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.5	15.670000076293944	15.350000381469728	15.65999984741211	14.1434326171875	564400
Wed Jun 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.539999961853027	15.550000190734863	15.3100004196167	15.470000267028809	13.971831321716309	901000
Thu Jun 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.779999732971191	15.739999771118164	14.65999984741211	15.369999885559082	13.881516456604004	3258000
Fri Jun 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.289999961853027	15.68000030517578	15.25	15.380000114440918	13.890547752380373	1793700
Mon Jul 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.479999542236328	15.5	14.84000015258789	14.869999885559082	13.429938316345217	4343500
Tue Jul 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.68000030517578	15.1899995803833	14.670000076293944	14.989999771118164	13.538315773010254	8682500


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