PREVIEW / stock_daily / 2016-05-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-05-16.parquet
  size:    219 KB
  rows:    6,558
  symbols: 3,286

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-05-16	AAPL	Stock	23.0975	23.5975	22.9125	23.47	245039200.0
2016-05-16	MSFT	Stock	50.8	51.96	50.75	51.83	20032000.0
2016-05-16	NVDA	Stock	1.0168	1.07	1.0135	1.0548	973032000.0
2016-05-16	AMZN	Stock	35.5065	35.6625	35.014	35.533	108658000.0
2016-05-16	GOOGL	Stock	36.216	36.634	36.0	36.515	22537240.0
2016-05-16	META	Stock	119.38	119.61	117.35	118.67	31247800.0
2016-05-16	TSLA	Stock	13.8767	14.21	13.8613	13.886	44241000.0
2016-05-16	TLT	Stock	131.64	131.66	130.98	131.14	5137039.0
2016-05-16	ES	Stock	57.28	57.45	56.95	57.38	1361600.0
2016-05-16	CL	Stock	71.59	72.22	71.47	72.02	2143400.0
2016-05-16	A	Stock	42.61	43.07	42.5	42.94	3979300.0
2016-05-16	AA.B-DELISTED	Stock	32.65	33.27	32.65	32.89	40603.0
2016-05-16	AAAP-DELISTED	Stock	28.04	28.98	27.6	28.37	77027.0
2016-05-16	AABA-DELISTED	Stock	37.03	37.79	36.88	37.48	16229312.0
2016-05-16	AAC-DELISTED	Stock	20.49	20.67	20.165	20.56	119889.0
2016-05-16	AACG	Stock	5.41	5.41	4.96	4.96	13400.0
2016-05-16	AAIC-DELISTED	Stock	12.41	12.6399	12.33	12.54	193547.0
2016-05-16	AAL	Stock	31.81	32.3	30.99	32.12	12397800.0
2016-05-16	AAMC-DELISTED	Stock	3.8235	4.2618	3.7706	3.8529	117548.0
2016-05-16	AAME	Stock	3.96	3.96	3.53	3.53	12000.0
2016-05-16	AAMI	Stock	13.79	13.97	13.74	13.84	114200.0
2016-05-16	AAOI	Stock	9.15	9.6	9.15	9.32	498500.0
2016-05-16	AAON	Stock	18.4667	19.0467	18.4267	18.8467	305250.0
2016-05-16	AAP	Stock	145.55	148.61	145.45	148.14	965300.0
2016-05-16	AAT	Stock	40.93	41.3	40.62	41.2	111300.0
2016-05-16	AAU-DELISTED	Stock	1.16	1.23	1.12	1.2	402162.0
2016-05-16	AAUAF-DELISTED	Stock	1.16	1.23	1.12	1.2	414278.0
2016-05-16	AAV-DELISTED	Stock	5.75	5.91	5.75	5.89	130328.0
2016-05-16	AAWW-DELISTED	Stock	44.25	44.615	43.17	43.5	328690.0
2016-05-16	AAXJ	Stock	51.69	52.06	51.69	51.91	380245.0
2016-05-16	AAXN-DELISTED	Stock	19.39	19.96	19.34	19.37	1096493.0
2016-05-16	AB	Stock	22.32	22.79	22.28	22.28	253400.0
2016-05-16	ABAC-DELISTED	Stock	0.5904	0.62	0.5904	0.62	1200.0
2016-05-16	ABAX-DELISTED	Stock	43.4	44.7	42.94	44.24	145277.0
2016-05-16	ABB-DELISTED	Stock	20.28	20.4399	20.25	20.34	1554083.0
2016-05-16	ABBNY-DELISTED	Stock	20.27	20.4399	20.25	20.34	2002571.0
2016-05-16	ABBV	Stock	61.91	62.62	61.5	62.45	6707400.0
2016-05-16	ABC-DELISTED	Stock	73.76	74.67	73.73	74.59	2688721.0
2016-05-16	ABCB	Stock	30.74	31.53	30.74	31.15	240500.0
2016-05-16	ABCD-DELISTED	Stock	4.23	4.3	4.2	4.25	10026.0
2016-05-16	ABCO-DELISTED	Stock	33.71	33.86	33.22	33.42	256320.0
2016-05-16	ABDC-DELISTED	Stock	11.65	12.085	11.65	11.96	37548.0
2016-05-16	ABE-DELISTED	Stock	11.8	11.95	11.8	11.88	1370.0
2016-05-16	ABEO	Stock	57.5	60.25	57.5	60.25	1856.0
2016-05-16	ABEOW-DELISTED	Stock	0.7	0.7	0.7	0.7	577.0
2016-05-16	ABEV	Stock	5.27	5.34	5.27	5.32	6935500.0
2016-05-16	ABG	Stock	54.62	55.29	53.18	53.4	284000.0
2016-05-16	ABIL-DELISTED	Stock	3.2	3.25	3.12	3.17	61793.0
2016-05-16	ABM	Stock	33.0	33.15	32.87	33.06	171200.0
2016-05-16	ABMD-DELISTED	Stock	94.44	97.22	93.28	96.42	408953.0

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

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