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

Otis

@kaggle.artemburenok_sp_500_stock_prices.otis

37.8 KB
691 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Mar 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40	46	40	45.25	43.65108108520508	7000
Fri Mar 20 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45.0099983215332	46.0099983215332	45	45	43.409915924072266	3600
Mon Mar 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	42	42	39.97999954223633	40	38.58658981323242	11900
Tue Mar 24 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40	40	39	40	38.58658981323242	77800
Wed Mar 25 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	40	44.79999923706055	38	41.0099983215332	39.5609016418457	7000
Thu Mar 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45	47.5	44.25	45	43.409915924072266	29100
Fri Mar 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45	47.5	44.9900016784668	45.23500061035156	43.63660430908203	263200
Mon Mar 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	44.25	50	44.25	50	48.23323822021485	118100
Tue Mar 31 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	46.5	50	44.77999877929688	50	48.23323822021485	210300
Wed Apr 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	45.9900016784668	48.5	44	46.70000076293945	45.04985046386719	1206100


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