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

Dgx

@kaggle.artemburenok_sp_500_stock_prices.dgx

277.74 KB
6542 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Dec 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.75	3.75	3.5	3.5	2.658711671829224	1272400
Wed Dec 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.5	3.59375	3.3125	3.5625	2.706188917160034	1186800
Thu Dec 19 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.59375	3.71875	3.59375	3.65625	2.7774040699005127	528800
Fri Dec 20 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.625	3.71875	3.625	3.71875	2.8248820304870605	233200
Mon Dec 23 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.75	3.84375	3.71875	3.8125	2.8960964679718018	57200
Tue Dec 24 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.84375	3.90625	3.84375	3.90625	2.967313051223755	14000
Thu Dec 26 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.90625	3.9375	3.8125	3.8125	2.8960964679718018	22000
Fri Dec 27 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.8125	3.8125	3.8125	3.8125	2.8960964679718018	800
Mon Dec 30 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.84375	3.84375	3.78125	3.78125	2.8723573684692383	28400
Tue Dec 31 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	3.75	3.78125	3.75	3.78125	2.8723573684692383	15600


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