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

Lvs

@kaggle.artemburenok_sp_500_stock_prices.lvs

205.49 KB
4531 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Dec 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	41.900001525878906	49.45000076293945	41.650001525878906	46.560001373291016	31.05179214477539	26246300
Thu Dec 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	48.09999847412109	50.59999847412109	47.900001525878906	49.11000061035156	32.75243377685547	7778200
Fri Dec 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	49.11000061035156	53.25	48.11000061035156	53	35.34675216674805	4755800
Mon Dec 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	52.70000076293945	53.97999954223633	48.33000183105469	48.59999847412109	32.41231155395508	6098000
Tue Dec 21 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	48.59999847412109	49.18000030517578	45.59999847412109	47.380001068115234	31.598657608032227	3209500
Wed Dec 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	47.20000076293945	49.54999923706055	46.900001525878906	48.5099983215332	32.35227584838867	1837400
Thu Dec 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	48.61000061035156	49.34999847412109	48.29999923706055	48.5	32.34560775756836	633500
Mon Dec 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	48.5099983215332	49.0099983215332	46.90999984741211	47.650001525878906	31.778722763061523	800700
Tue Dec 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	47.45000076293945	48.29999923706055	46.5	48.09999847412109	32.07884979248047	1169600
Wed Dec 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	48.09999847412109	48.20000076293945	47.54999923706055	47.88999938964844	31.938796997070312	566500


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