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

Syy

@kaggle.artemburenok_sp_500_stock_prices.syy

381.38 KB
12512 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1597220003604889	0.1597220003604889	0.1597220003604889	0.1597220003604889	0.0774658918380737	28800
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1597220003604889	0.1597220003604889	0.1597220003604889	0.1597220003604889	0.0774658918380737	28800
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1692710071802139	0.1796880066394806	0.1692710071802139	0.1796880066394806	0.0871495008468627	172800
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1796880066394806	0.1796880066394806	0.1796880066394806	0.1796880066394806	0.0871495008468627	331200
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1796880066394806	0.1796880066394806	0.1796880066394806	0.1796880066394806	0.0871495008468627
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1796880066394806	0.1796880066394806	0.1796880066394806	0.1796880066394806	0.0871495008468627	316800
Wed May 16 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1796880066394806	0.1796880066394806	0.1692710071802139	0.1692710071802139	0.0820972174406051	57600
Thu May 17 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1692710071802139	0.1692710071802139	0.1692710071802139	0.1692710071802139	0.0820972174406051	86400
Fri May 18 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1597220003604889	0.1597220003604889	0.1597220003604889	0.1597220003604889	0.0774658918380737	201600
Mon May 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1597220003604889	0.1597220003604889	0.1493059992790222	0.1493059992790222	0.0724141225218772	100800


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