PREVIEW / stock_daily / 2016-08-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-08-11.parquet
  size:    220 KB
  rows:    6,558
  symbols: 3,244

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-08-11	AAPL	Stock	27.13	27.2325	26.9625	26.9825	109938000.0
2016-08-11	MSFT	Stock	58.03	58.45	58.03	58.3	18162300.0
2016-08-11	NVDA	Stock	1.4705	1.4988	1.4675	1.4925	681064000.0
2016-08-11	AMZN	Stock	38.497	38.6875	38.456	38.562	40394000.0
2016-08-11	GOOGL	Stock	40.5235	40.694	40.3	40.41	25645480.0
2016-08-11	META	Stock	125.2	125.38	124.75	124.9	11729500.0
2016-08-11	TSLA	Stock	15.078	15.1713	14.894	14.994	28213500.0
2016-08-11	TLT	Stock	140.06	140.08	138.54	138.91	7624622.0
2016-08-11	ES	Stock	56.98	57.17	56.77	57.15	986400.0
2016-08-11	CL	Stock	74.95	75.26	74.79	74.89	2345100.0
2016-08-11	A	Stock	47.62	48.19	47.47	48.13	1377000.0
2016-08-11	AA.B-DELISTED	Stock	35.6299	35.731	35.42	35.67	19834.0
2016-08-11	AAAP-DELISTED	Stock	32.0	32.2	31.51	31.66	18508.0
2016-08-11	AABA-DELISTED	Stock	41.12	41.73	40.93	41.26	22064700.0
2016-08-11	AAC-DELISTED	Stock	17.55	17.811	17.26	17.44	177215.0
2016-08-11	AACG	Stock	3.74	4.28	3.74	4.16	26100.0
2016-08-11	AAIC-DELISTED	Stock	14.85	14.94	14.76	14.81	152268.0
2016-08-11	AAL	Stock	34.25	35.08	34.24	34.96	7665900.0
2016-08-11	AAMC-DELISTED	Stock	3.8695	3.9588	3.8235	3.8559	36727.0
2016-08-11	AAME	Stock	4.07	4.13	4.0	4.06	8500.0
2016-08-11	AAMI	Stock	13.62	13.76	13.5	13.65	170400.0
2016-08-11	AAOI	Stock	13.74	13.82	13.47	13.55	372000.0
2016-08-11	AAON	Stock	18.3067	18.5267	18.1333	18.38	144150.0
2016-08-11	AAP	Stock	167.8	170.42	166.66	166.71	829400.0
2016-08-11	AAT	Stock	46.04	46.04	45.25	45.34	279900.0
2016-08-11	AAU-DELISTED	Stock	1.88	1.88	1.63	1.67	758208.0
2016-08-11	AAUAF-DELISTED	Stock	1.88	1.88	1.63	1.68	774709.0
2016-08-11	AAV-DELISTED	Stock	6.68	6.865	6.68	6.76	140753.0
2016-08-11	AAWW-DELISTED	Stock	35.47	36.28	34.98	34.99	216423.0
2016-08-11	AAXJ	Stock	59.03	59.59	59.03	59.54	733157.0
2016-08-11	AAXN-DELISTED	Stock	28.63	29.44	28.63	29.13	788695.0
2016-08-11	AB	Stock	21.64	21.73	21.39	21.49	280400.0
2016-08-11	ABAC-DELISTED	Stock	0.6997	0.75	0.66	0.6701	24869.0
2016-08-11	ABAX-DELISTED	Stock	49.56	50.08	49.04	49.7	77836.0
2016-08-11	ABB-DELISTED	Stock	22.02	22.08	21.95	22.02	934727.0
2016-08-11	ABBNY-DELISTED	Stock	22.02	22.08	21.95	22.02	1074082.0
2016-08-11	ABBV	Stock	66.86	67.11	66.7	66.95	4246600.0
2016-08-11	ABC-DELISTED	Stock	87.98	89.05	87.47	88.94	1446631.0
2016-08-11	ABCB	Stock	33.26	33.5	33.08	33.4	75400.0
2016-08-11	ABCD-DELISTED	Stock	4.68	4.95	4.68	4.89	17092.0
2016-08-11	ABCO-DELISTED	Stock	41.39	41.77	41.253	41.49	95673.0
2016-08-11	ABDC-DELISTED	Stock	12.45	12.45	12.31	12.31	33354.0
2016-08-11	ABE-DELISTED	Stock	12.78	12.81	12.73	12.81	18182.0
2016-08-11	ABEO	Stock	95.25	95.25	89.5	90.25	2196.0
2016-08-11	ABEOW-DELISTED	Stock	1.75	1.7996	1.75	1.7996	1183.0
2016-08-11	ABEV	Stock	6.12	6.21	6.11	6.21	15484800.0
2016-08-11	ABG	Stock	55.7	57.33	55.27	56.65	253900.0
2016-08-11	ABIL-DELISTED	Stock	5.45	5.454	5.0	5.1499	75127.0
2016-08-11	ABM	Stock	37.66	38.01	37.64	38.01	189800.0
2016-08-11	ABMD-DELISTED	Stock	123.28	124.718	122.99	124.11	236579.0

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

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