PREVIEW / stock_daily / 2016-09-29

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-29.parquet
  size:    218 KB
  rows:    6,516
  symbols: 3,194

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-29	AAPL	Stock	28.29	28.45	27.95	28.045	143548000.0
2016-09-29	MSFT	Stock	57.81	58.17	57.21	57.4	25463500.0
2016-09-29	NVDA	Stock	1.6668	1.6902	1.6512	1.685	336684000.0
2016-09-29	AMZN	Stock	41.413	41.875	41.2315	41.4525	98444000.0
2016-09-29	GOOGL	Stock	40.3615	40.6955	40.0428	40.132	26999480.0
2016-09-29	META	Stock	129.18	129.29	127.55	128.09	14532200.0
2016-09-29	TSLA	Stock	13.7067	13.822	13.372	13.38	40905000.0
2016-09-29	TLT	Stock	137.56	139.07	137.45	138.75	8319793.0
2016-09-29	ES	Stock	54.95	55.15	54.28	54.69	1197700.0
2016-09-29	CL	Stock	73.56	73.62	73.04	73.29	2944200.0
2016-09-29	A	Stock	47.05	47.27	46.14	46.41	1938200.0
2016-09-29	AA.B-DELISTED	Stock	32.4799	32.95	32.32	32.4	20173.0
2016-09-29	AAAP-DELISTED	Stock	38.32	38.7699	38.24	38.5	97692.0
2016-09-29	AABA-DELISTED	Stock	43.17	43.3	42.43	42.58	8263890.0
2016-09-29	AAC-DELISTED	Stock	16.59	17.05	16.51	16.99	103993.0
2016-09-29	AACG	Stock	4.19	4.43	4.05	4.23	57400.0
2016-09-29	AAIC-DELISTED	Stock	14.82	14.8589	14.56	14.65	253859.0
2016-09-29	AAL	Stock	35.65	36.6	35.6	35.82	6182700.0
2016-09-29	AAMC-DELISTED	Stock	4.9206	5.0224	4.7794	4.9412	26540.0
2016-09-29	AAME	Stock	3.42	3.42	3.06	3.26	6600.0
2016-09-29	AAMI	Stock	13.84	13.9	13.48	13.52	86400.0
2016-09-29	AAOI	Stock	21.22	21.32	20.9	20.96	187900.0
2016-09-29	AAON	Stock	18.8933	19.0133	18.8	18.8133	99150.0
2016-09-29	AAP	Stock	148.92	148.93	146.08	146.74	811900.0
2016-09-29	AAT	Stock	44.03	44.06	43.5	43.86	80700.0
2016-09-29	AAU-DELISTED	Stock	1.43	1.43	1.3684	1.4	187100.0
2016-09-29	AAUAF-DELISTED	Stock	1.43	1.43	1.3684	1.41	188418.0
2016-09-29	AAV-DELISTED	Stock	6.99	7.109	6.91	6.94	76777.0
2016-09-29	AAWW-DELISTED	Stock	41.61	42.3327	41.46	41.96	145956.0
2016-09-29	AAXJ	Stock	60.78	60.94	60.08	60.21	891733.0
2016-09-29	AAXN-DELISTED	Stock	28.71	29.0	28.54	28.925	848803.0
2016-09-29	AB	Stock	22.27	22.33	21.92	22.09	262200.0
2016-09-29	ABAC-DELISTED	Stock	2.0101	2.0125	1.9301	1.99	21344.0
2016-09-29	ABAX-DELISTED	Stock	51.0	51.0	50.13	50.5	119792.0
2016-09-29	ABB-DELISTED	Stock	22.49	22.6	22.285	22.4	2473025.0
2016-09-29	ABBNY-DELISTED	Stock	22.49	22.6	22.285	22.38	2525502.0
2016-09-29	ABBV	Stock	64.3	64.31	62.8	62.82	6431200.0
2016-09-29	ABC-DELISTED	Stock	82.92	83.28	81.25	81.25	1453727.0
2016-09-29	ABCB	Stock	34.83	34.89	34.29	34.35	142300.0
2016-09-29	ABCD-DELISTED	Stock	5.33	5.46	5.33	5.38	8049.0
2016-09-29	ABCO-DELISTED	Stock	43.82	45.02	43.34	43.73	250249.0
2016-09-29	ABDC-DELISTED	Stock	13.0	13.1	12.82	13.04	72781.0
2016-09-29	ABE-DELISTED	Stock	12.75	12.78	12.62	12.62	31593.0
2016-09-29	ABEO	Stock	153.75	153.75	147.5	147.75	12072.0
2016-09-29	ABEOW-DELISTED	Stock	3.34	3.34	3.0501	3.0501	2309.0
2016-09-29	ABEV	Stock	6.12	6.16	5.99	6.03	11328400.0
2016-09-29	ABG	Stock	54.57	55.23	54.32	54.43	177300.0
2016-09-29	ABIL-DELISTED	Stock	3.9	3.91	3.9	3.91	844.0
2016-09-29	ABM	Stock	39.64	39.72	39.27	39.33	149300.0
2016-09-29	ABMD-DELISTED	Stock	130.27	131.16	126.18	128.38	403859.0

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

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