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

Abc

@kaggle.artemburenok_sp_500_stock_prices.abc

301.45 KB
6974 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Apr 04 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.9375	2.96875	2.8125	2.953125	2.2756733894348145	40387200
Wed Apr 05 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.90625	2.96875	2.84375	2.84375	2.1913881301879883	12236800
Thu Apr 06 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.84375	2.9375	2.84375	2.890625	2.227510929107666	3776000
Fri Apr 07 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.90625	2.90625	2.84375	2.84375	2.1913881301879883	1920800
Mon Apr 10 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.84375	2.90625	2.84375	2.875	2.215470552444458	2047200
Tue Apr 11 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.84375	2.90625	2.84375	2.859375	2.20343017578125	4096800
Wed Apr 12 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.84375	2.875	2.84375	2.859375	2.20343017578125	2457600
Thu Apr 13 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.84375	2.875	2.84375	2.875	2.215470552444458	2297600
Mon Apr 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.84375	2.953125	2.84375	2.953125	2.2756733894348145	2233600
Tue Apr 18 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	2.890625	2.953125	2.875	2.9375	2.263632774353028	2441600


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