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

Bby

@kaggle.artemburenok_sp_500_stock_prices.bby

377.84 KB
9492 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Apr 18 1985 00:00:00 GMT+0000 (Coordinated Universal Time)		0.1697530001401901	0.1666669994592666	0.1666669994592666	0.1062601506710052	15957000
Fri Apr 19 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1682099997997284	0.1697530001401901	0.1682099997997284	0.1682099997997284	0.1072438955307006	13065300
Mon Apr 22 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1666669994592666	0.1666669994592666	0.1666669994592666	0.1666669994592666	0.1062601506710052	2891700
Tue Apr 23 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1666669994592666	0.1666669994592666	0.1635800004005432	0.1635800004005432	0.1042919978499412	5718600
Wed Apr 24 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1635800004005432	0.1651230007410049	0.1635800004005432	0.1635800004005432	0.1042919978499412	2122200
Thu Apr 25 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1574070006608963	0.1574070006608963	0.1558640003204345	0.1558640003204345	0.0993726029992103	6172200
Fri Apr 26 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1558640003204345	0.1558640003204345	0.1527779996395111	0.1527779996395111	0.0974050462245941	2381400
Mon Apr 29 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1512349992990493	0.1512349992990493	0.1481480002403259	0.1481480002403259	0.0944531634449958	2502900
Tue Apr 30 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1481480002403259	0.1527779996395111	0.1481480002403259	0.1481480002403259	0.0944531634449958	2745900
Wed May 01 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1435189992189407	0.1435189992189407	0.1404320001602172	0.1404320001602172	0.0895337089896202	5030100


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