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

Mpwr

@kaggle.artemburenok_sp_500_stock_prices.mpwr

201.26 KB
4548 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Nov 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.0600004196167	9.93000030517578	8.5	9.84000015258789	8.638368606567383	3906200
Mon Nov 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.899999618530272	11	9.510000228881836	9.619999885559082	8.445236206054688	728000
Tue Nov 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.5	9.75	8.760000228881836	9.380000114440918	8.234542846679688	505800
Wed Nov 24 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.5	10	9.5	9.779999732971191	8.58569622039795	319500
Fri Nov 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.300000190734863	9.949999809265137	9.25	9.800000190734863	8.603255271911621	65600
Mon Nov 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	10	10.100000381469728	9.460000038146973	9.800000190734863	8.603255271911621	130700
Tue Nov 30 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.800000190734863	9.989999771118164	9.3100004196167	9.880000114440918	8.67348575592041	194900
Wed Dec 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	9.5	10.220000267028809	9.5	9.989999771118164	8.770052909851074	209800
Thu Dec 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	10.029999732971191	11	9.970000267028809	10.850000381469728	9.525032997131348	337400
Fri Dec 03 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	10.989999771118164	11.350000381469728	10.579999923706056	11.140000343322754	9.779618263244627	288100


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