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

Msci

@kaggle.artemburenok_sp_500_stock_prices.msci

176.95 KB
3796 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Nov 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	23	28.450000762939453	22.059999465942383	26.100000381469727	23.834321975708008	11770500
Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	25.979999542236328	25.979999542236328	23.600000381469727	24.959999084472656	22.79327774047852	1242900
Mon Nov 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	24.709999084472656	25.75	24.530000686645508	25.75	23.51470184326172	469500
Tue Nov 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	25.420000076293945	29.209999084472656	25.26000022888184	27.31999969482422	24.948410034179688	522200
Wed Nov 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	27	27.1299991607666	25.940000534057617	26.649999618530277	24.336572647094727	167500
Fri Nov 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	27.299999237060547	28.32999992370605	26.81999969482422	27.399999618530277	25.021469116210938	100700
Mon Nov 26 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	27.989999771118164	29.489999771118164	27.530000686645508	27.799999237060547	25.386749267578125	438300
Tue Nov 27 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	28.229999542236328	28.75	26.280000686645508	26.979999542236328	24.637922286987305	305800
Wed Nov 28 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	27.1200008392334	27.6200008392334	26.68000030517578	27.299999237060547	24.930150985717773	273600
Thu Nov 29 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	26.61000061035156	27.989999771118164	26.600000381469727	27.299999237060547	24.930150985717773	110600


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