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

Tsco

@kaggle.artemburenok_sp_500_stock_prices.tsco

300.49 KB
7257 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Feb 17 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	0.4375	0.4375	0.4375	0.4375	0.3771482408046722	48000
Fri Feb 18 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.421875	1.4375	1.3125	1.421875	1.2257318496704102	39870400
Tue Feb 22 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.40625	1.4375	1.359375	1.421875	1.2257318496704102	9164800
Wed Feb 23 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.390625	1.421875	1.359375	1.375	1.1853233575820925	5124800
Thu Feb 24 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.375	1.375	1.3125	1.3125	1.131445050239563	2246400
Fri Feb 25 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.359375	1.375	1.3125	1.359375	1.1718536615371704	2414400
Mon Feb 28 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.34375	1.375	1.34375	1.34375	1.1583842039108276	1006400
Tue Mar 01 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.375	1.375	1.34375	1.359375	1.1718536615371704	952000
Wed Mar 02 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.359375	1.359375	1.3125	1.34375	1.1583842039108276	2105600
Thu Mar 03 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	1.359375	1.359375	1.328125	1.359375	1.1718536615371704	680000


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