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

Ame

@kaggle.artemburenok_sp_500_stock_prices.ame

357.01 KB
9681 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Jul 19 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.796296000480652	1.805556058883667	1.7777780294418335	1.796296000480652	0.959334909915924	70200
Fri Jul 20 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.787037014961243	1.805556058883667	1.7777780294418335	1.7777780294418335	0.9494456052780152	52650
Mon Jul 23 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7685190439224243	1.7777780294418335	1.7314809560775757	1.7314809560775757	0.9247198700904846	113400
Tue Jul 24 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7407410144805908	1.75	1.7222219705581665	1.7314809560775757	0.9247198700904846	55350
Wed Jul 25 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.703703999519348	1.7314809560775757	1.694443941116333	1.7314809560775757	0.9247198700904846	116100
Thu Jul 26 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.75	1.75	1.7407410144805908	1.75	0.93461012840271	66150
Fri Jul 27 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.75	1.7592589855194092	1.7314809560775757	1.75	0.93461012840271	144450
Mon Jul 30 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7685190439224243	1.7685190439224243	1.7407410144805908	1.7407410144805908	0.929665207862854	135000
Tue Jul 31 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7407410144805908	1.7777780294418335	1.7314809560775757	1.7777780294418335	0.9494456052780152	82350
Wed Aug 01 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	1.7777780294418335	1.9166669845581052	1.7777780294418335	1.888888955116272	1.0087859630584717	697950


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