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

Psx

@kaggle.artemburenok_sp_500_stock_prices.psx

127.18 KB
2687 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Apr 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	33.25	34.209999084472656	32	34	23.94924736022949	654700
Fri Apr 13 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	34	37.45000076293945	33.90999984741211	37	26.062414169311523	1685000
Mon Apr 16 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	37	37	35.9900016784668	36.54999923706055	25.745441436767575	550200
Tue Apr 17 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36.400001525878906	36.75	36	36	25.358022689819336	179600
Wed Apr 18 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36	36.43999862670898	34.5	36	25.358022689819336	207100
Thu Apr 19 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36	37.220001220703125	35.79999923706055	36	25.358022689819336	598100
Fri Apr 20 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36.09999847412109	37	36.09999847412109	36.31999969482422	25.58342742919922	149700
Mon Apr 23 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36.2400016784668	36.2400016784668	35.41999816894531	35.68000030517578	25.13262367248535	95700
Tue Apr 24 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	36	36	34.68000030517578	34.75	24.477542877197266	124500
Wed Apr 25 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	34.79999923706055	35.5	34.5	34.75	24.477542877197266	266200


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