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

Lrcx

@kaggle.artemburenok_sp_500_stock_prices.lrcx

366.05 KB
9733 rows
7 columns

date Date	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri May 04 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.25	2.222222089767456	2.222222089767456	1.9490721225738523	2578950
Mon May 07 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.25	2.194443941116333	2.194443941116333	1.9247089624404907	102600
Tue May 08 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.222222089767456	2.194443941116333	2.194443941116333	1.9247089624404907	137250
Wed May 09 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.222222089767456	2.194443941116333	2.194443941116333	1.9247089624404907	741600
Thu May 10 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.194443941116333	2.138889074325561	2.138889074325561	1.875982522964477	303750
Fri May 11 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.166666984558105	2.1111109256744385	2.1111109256744385	1.8516186475753784	228150
Mon May 14 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.194443941116333	2.1111109256744385	2.1111109256744385	1.8516186475753784	49950
Tue May 15 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.222222089767456	2.166666984558105	2.166666984558105	1.9003456830978396	43650
Wed May 16 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.222222089767456	2.166666984558105	2.166666984558105	1.9003456830978396	35100
Thu May 17 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	2.194443941116333	2.166666984558105	2.166666984558105	1.9003456830978396	65250


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