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

Lly

@kaggle.artemburenok_sp_500_stock_prices.lly

460.61 KB
12745 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)		4.070312976837158	4.023437976837158	4.046875	0.9168506264686584	456000
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.054687976837158	4.09375	4.054687976837158	4.09375	0.9274707436561584	640000
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.085937976837158	4.085937976837158	4.023437976837158	4.039062976837158	0.915080726146698	464000
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.039062976837158	4.039062976837158	4	4	0.9062305688858032	796800
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4	4.054687976837158	3.992187976837158	4.046875	0.9168506264686584	584000
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.046875	4.0625	3.992187976837158	4	0.9062305688858032	726400
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.007812976837158	4.054687976837158	4.007812976837158	4.046875	0.9168506264686584	296000
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.046875	4.078125	4.015625	4.039062976837158	0.915080726146698	473600
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.046875	4.09375	4.046875	4.078125	0.9239308834075928	478400
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)	4.09375	4.179687976837158	4.09375	4.164062976837158	0.9434008598327636	795200


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