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

Chrw

@kaggle.artemburenok_sp_500_stock_prices.chrw

275.02 KB
6332 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Oct 16 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.8125	5.8125	5.5625	5.6875	3.666561126708984	7436400
Fri Oct 17 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.65625	5.75	5.40625	5.59375	3.6061251163482666	3390400
Mon Oct 20 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.5	5.625	5.46875	5.53125	3.5658304691314697	3068000
Tue Oct 21 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.5625	5.6875	5.5	5.59375	3.6061251163482666	2382400
Wed Oct 22 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.6875	5.75	5.59375	5.71875	3.686706781387329	1525200
Thu Oct 23 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.6875	5.6875	5.53125	5.59375	3.6061251163482666	1622400
Fri Oct 24 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.65625	5.71875	5.5625	5.71875	3.686706781387329	813600
Mon Oct 27 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.65625	5.75	5.375	5.421875	3.4953200817108154	1507200
Tue Oct 28 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.25	5.6875	4.9375	5.59375	3.6061251163482666	2955600
Wed Oct 29 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	5.6875	5.71875	5.59375	5.65625	3.6464157104492183	1859200


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