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

Jci

@kaggle.artemburenok_sp_500_stock_prices.jci

371.69 KB
8875 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Mon Sep 28 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.994534969329834	7.027068138122559	6.896936893463135	6.929470062255859	3.2966833114624023	353106
Tue Sep 29 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.929470062255859	6.994534969329834	6.896936893463135	6.994534969329834	3.3276379108428955	289708
Wed Sep 30 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.994534969329834	6.994534969329834	6.896936893463135	6.929470062255859	3.2966833114624023	191346
Thu Oct 01 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.929470062255859	7.027068138122559	6.896936893463135	7.027068138122559	3.3431155681610107	680853
Fri Oct 02 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	7.027068138122559	7.09213399887085	7.027068138122559	7.09213399887085	3.3740694522857666	111042
Mon Oct 05 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	7.09213399887085	7.189732074737549	7.027068138122559	7.124666213989258	3.389547824859619	760388
Tue Oct 06 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	7.124666213989258	7.124666213989258	6.83187198638916	6.896936893463135	3.2812063694000244	240143
Wed Oct 07 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.896936893463135	6.896936893463135	6.604143142700195	6.636674880981445	3.157386302947998	828781
Thu Oct 08 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.636674880981445	6.83187198638916	6.539076805114746	6.83187198638916	3.2502503395080566	280487
Fri Oct 09 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	6.83187198638916	7.09213399887085	6.83187198638916	6.994534969329834	3.3276379108428955	249364


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