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

Mtb

@kaggle.artemburenok_sp_500_stock_prices.mtb

390.03 KB
10779 rows
7 columns

date Date	high High	low Low	close Close	adj_close Adj Close	volume Volume
Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5625	0.5375000238418579	0.5375000238418579	0.2497773170471191	104000
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5562499761581421	0.53125	0.53125	0.2468730360269546	30000
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5687500238418579	0.543749988079071	0.543749988079071	0.252681702375412	100000
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5687500238418579	0.543749988079071	0.543749988079071	0.252681702375412	38000
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5687500238418579	0.543749988079071	0.543749988079071	0.252681702375412	54000
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5687500238418579	0.543749988079071	0.543749988079071	0.252681702375412	40000
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.550000011920929	0.5249999761581421	0.5249999761581421	0.2439685612916946	72000
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.550000011920929	0.5249999761581421	0.5249999761581421	0.2439685612916946	6000
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5	0.4749999940395355	0.4749999940395355	0.2207334488630294	136000
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	0.512499988079071	0.4875000119209289	0.4875000119209289	0.2265422344207763	94000


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