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

Gild

@kaggle.artemburenok_sp_500_stock_prices.gild

326.09 KB
7783 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Jan 22 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.5390629768371582	0.6796879768371582	0.5390629768371582	0.6328129768371582	0.4926298558712005	168022400
Thu Jan 23 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.65625	0.7109379768371582	0.6328129768371582	0.6875	0.5352022647857666	38368000
Fri Jan 24 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.6953129768371582	0.7265629768371582	0.671875	0.6953129768371582	0.5412846207618713	12044800
Mon Jan 27 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.7265629768371582	0.75	0.6953129768371582	0.75	0.5838570594787598	10716800
Tue Jan 28 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.7421879768371582	0.7578129768371582	0.7109379768371582	0.734375	0.571693480014801	19913600
Wed Jan 29 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.7109379768371582	0.734375	0.6796879768371582	0.6796879768371582	0.5291208624839783	13238400
Thu Jan 30 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.6875	0.6953129768371582	0.609375	0.609375	0.4743839502334595	10848000
Fri Jan 31 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.625	0.6484379768371582	0.609375	0.6484379768371582	0.5047935843467712	2496000
Mon Feb 03 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.65625	0.65625	0.6328129768371582	0.640625	0.498711347579956	2320000
Tue Feb 04 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	0.6484379768371582	0.6796879768371582	0.6484379768371582	0.6796879768371582	0.5291208624839783	2499200


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