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

Iqv

@kaggle.artemburenok_sp_500_stock_prices.iqv

120.49 KB
2418 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu May 09 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	43.7599983215332	44.33000183105469	42	42.11000061035156	42.11000061035156	19153400
Fri May 10 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	42.2599983215332	42.970001220703125	41.77999877929688	42.38999938964844	42.38999938964844	2969700
Mon May 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	42.29999923706055	43.369998931884766	42.29999923706055	43.31999969482422	43.31999969482422	1053100
Tue May 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	44.2400016784668	44.75	43.900001525878906	44.43000030517578	44.43000030517578	2049800
Wed May 15 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.20000076293945	45.7400016784668	44.84999847412109	45.5	45.5	2380500
Thu May 16 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	46.27999877929688	46.5	45.59999847412109	45.84999847412109	45.84999847412109	1244600
Fri May 17 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	46.130001068115234	46.209999084472656	45.34999847412109	45.52000045776367	45.52000045776367	920100
Mon May 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.45000076293945	45.72999954223633	45.2599983215332	45.380001068115234	45.380001068115234	535800
Tue May 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45	45.29999923706055	44.40999984741211	45.04999923706055	45.04999923706055	668900
Wed May 22 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.13999938964844	45.380001068115234	44.11000061035156	44.650001525878906	44.650001525878906	913200


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