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

Zts

@kaggle.artemburenok_sp_500_stock_prices.zts

122.29 KB
2485 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Feb 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.5	31.739999771118164	30.46999931335449	31.01000022888184	28.952978134155277	66789100
Mon Feb 04 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.09000015258789	31.989999771118164	30.76000022888184	31.020000457763672	28.96230697631836	7695400
Tue Feb 05 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.25	31.979999542236328	30.850000381469727	31.040000915527344	28.98099136352539	5013200
Wed Feb 06 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	30.979999542236328	31.43000030517578	30.75	31.030000686645508	28.97164726257324	2126100
Thu Feb 07 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31	32.72999954223633	31	32	29.87730598449707	3800800
Fri Feb 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	32.310001373291016	33.47999954223633	32.29999923706055	33.04999923706055	30.857654571533203	2599300
Mon Feb 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	33.060001373291016	33.5	32.880001068115234	33.2599983215332	31.053714752197266	1487200
Tue Feb 12 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	33.400001525878906	34	33.150001525878906	33.7400016784668	31.501893997192383	1637300
Wed Feb 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	33.79999923706055	33.79999923706055	33	33.54999923706055	31.32447624206543	1269700
Thu Feb 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	33.38999938964844	33.45000076293945	32.77000045776367	33.27000045776367	31.06305313110352	2954500


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