PREVIEW / stock_daily / 2016-09-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-15.parquet
  size:    217 KB
  rows:    6,513
  symbols: 3,207

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2016-09-15	AAPL	Stock	28.465	28.9325	28.3725	28.8925	359934400.0
2016-09-15	MSFT	Stock	56.15	57.35	55.98	57.19	26847000.0
2016-09-15	NVDA	Stock	1.5125	1.569	1.509	1.5672	515212000.0
2016-09-15	AMZN	Stock	38.1	38.5435	37.879	38.4845	60680000.0
2016-09-15	GOOGL	Stock	39.5005	40.1823	39.433	40.0615	31327200.0
2016-09-15	META	Stock	127.98	129.1	127.67	128.35	15077200.0
2016-09-15	TSLA	Stock	13.0993	13.5013	13.0933	13.3613	46158000.0
2016-09-15	TLT	Stock	133.61	134.05	133.03	133.67	10234190.0
2016-09-15	ES	Stock	53.24	53.86	53.04	53.77	1265000.0
2016-09-15	CL	Stock	71.85	72.32	71.57	72.1	3032500.0
2016-09-15	A	Stock	44.86	45.68	44.81	45.44	1734000.0
2016-09-15	AA.B-DELISTED	Stock	31.16	31.54	31.11	31.48	28640.0
2016-09-15	AAAP-DELISTED	Stock	34.0	34.8	33.93	34.8	36336.0
2016-09-15	AABA-DELISTED	Stock	43.41	44.05	43.22	43.99	11906141.0
2016-09-15	AAC-DELISTED	Stock	18.04	18.288	17.81	17.89	160415.0
2016-09-15	AACG	Stock	4.87	4.87	4.65	4.87	2300.0
2016-09-15	AAIC-DELISTED	Stock	14.74	14.914	14.72	14.83	87906.0
2016-09-15	AAL	Stock	36.31	36.63	35.85	36.41	7793900.0
2016-09-15	AAMC-DELISTED	Stock	4.0912	4.2235	4.0471	4.0647	39957.0
2016-09-15	AAME	Stock	3.44	3.45	3.4	3.4	3500.0
2016-09-15	AAMI	Stock	12.69	12.87	12.67	12.81	85900.0
2016-09-15	AAOI	Stock	21.64	22.32	21.31	21.65	589000.0
2016-09-15	AAON	Stock	18.2333	18.5067	18.1733	18.3733	98700.0
2016-09-15	AAP	Stock	150.49	150.85	148.71	148.94	1049300.0
2016-09-15	AAT	Stock	42.07	42.24	41.9	42.17	69600.0
2016-09-15	AAU-DELISTED	Stock	1.34	1.41	1.32	1.3893	517571.0
2016-09-15	AAUAF-DELISTED	Stock	1.34	1.41	1.32	1.3893	525578.0
2016-09-15	AAV-DELISTED	Stock	6.58	6.85	6.58	6.74	63057.0
2016-09-15	AAWW-DELISTED	Stock	37.54	38.76	37.4175	38.62	170564.0
2016-09-15	AAXJ	Stock	58.95	59.71	58.76	59.64	2045952.0
2016-09-15	AAXN-DELISTED	Stock	25.18	25.63	25.18	25.54	523650.0
2016-09-15	AB	Stock	22.0	22.85	22.0	22.73	333200.0
2016-09-15	ABAC-DELISTED	Stock	2.24	2.31	2.11	2.15	27742.0
2016-09-15	ABAX-DELISTED	Stock	48.03	48.97	47.95	48.94	64132.0
2016-09-15	ABB-DELISTED	Stock	22.05	22.31	22.0	22.24	1945853.0
2016-09-15	ABBNY-DELISTED	Stock	22.05	22.31	22.0	22.25	1992771.0
2016-09-15	ABBV	Stock	63.17	63.82	62.92	63.35	7806800.0
2016-09-15	ABC-DELISTED	Stock	83.54	84.54	83.06	84.2	2169018.0
2016-09-15	ABCB	Stock	35.35	35.58	35.17	35.2	194600.0
2016-09-15	ABCD-DELISTED	Stock	5.2	5.29	5.2	5.27	6644.0
2016-09-15	ABCO-DELISTED	Stock	42.66	43.4	42.11	43.3	120509.0
2016-09-15	ABDC-DELISTED	Stock	12.79	12.81	12.5	12.77	29909.0
2016-09-15	ABE-DELISTED	Stock	12.26	12.5	12.26	12.5	2200.0
2016-09-15	ABEO	Stock	125.0	128.5	123.0	124.25	9520.0
2016-09-15	ABEV	Stock	5.91	5.98	5.85	5.97	12555500.0
2016-09-15	ABG	Stock	54.89	55.72	54.88	55.58	222000.0
2016-09-15	ABIL-DELISTED	Stock	3.77	3.87	3.7601	3.83	8332.0
2016-09-15	ABM	Stock	39.0	39.46	38.91	39.42	150500.0
2016-09-15	ABMD-DELISTED	Stock	118.79	123.94	118.09	123.15	333331.0
2016-09-15	ABR	Stock	7.6	7.6	7.47	7.52	41700.0

> showing 50 of 6,513 rows — these rows as CSV

> unlock the full archive -- $79 one-time