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

Aap

@kaggle.artemburenok_sp_500_stock_prices.aap

252.94 KB
5297 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Nov 29 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.386667251586914	14.466667175292969	13.359999656677246	13.880000114440918	12.583541870117188	371100
Fri Nov 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.880000114440918	14.266667366027832	13.880000114440918	14.266667366027832	12.934093475341797	165300
Mon Dec 03 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.233332633972168	14.233332633972168	13.783332824707031	13.783332824707031	12.495908737182615	127500
Tue Dec 04 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.783332824707031	13.783332824707031	13.233332633972168	13.233332633972168	11.997274398803713	95400
Wed Dec 05 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	13.43333339691162	14.783332824707031	13.43333339691162	14.666666984558104	13.29672908782959	598200
Thu Dec 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.733332633972168	14.733332633972168	14.56999969482422	14.57333278656006	13.212113380432127	157200
Fri Dec 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.583333015441896	14.666666984558104	14.466667175292969	14.666666984558104	13.29672908782959	215100
Mon Dec 10 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.633333206176758	14.640000343322754	14.58666706085205	14.616666793823242	13.251401901245115	119100
Tue Dec 11 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.600000381469728	14.710000038146973	14.58666706085205	14.58666706085205	13.224205017089844	378600
Wed Dec 12 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	14.583333015441896	14.583333015441896	14.036666870117188	14.100000381469728	12.78299331665039	114600


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