PREVIEW / stock_daily / 2016-09-21

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-21.parquet
  size:    218 KB
  rows:    6,505
  symbols: 3,199

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-21	AAPL	Stock	28.4625	28.4975	28.11	28.3875	144012800.0
2016-09-21	MSFT	Stock	57.51	57.85	57.08	57.76	33707300.0
2016-09-21	NVDA	Stock	1.582	1.6245	1.5818	1.6215	336212000.0
2016-09-21	AMZN	Stock	39.1625	39.5345	38.9505	39.487	54372000.0
2016-09-21	GOOGL	Stock	40.063	40.2955	39.8015	40.2515	26969520.0
2016-09-21	META	Stock	129.13	130.01	128.39	129.94	14068300.0
2016-09-21	TSLA	Stock	13.758	13.8	13.4373	13.6813	39502500.0
2016-09-21	TLT	Stock	134.6	135.89	134.18	135.87	10698125.0
2016-09-21	ES	Stock	54.38	55.49	54.32	55.45	1979600.0
2016-09-21	CL	Stock	72.48	73.09	72.15	73.0	3268300.0
2016-09-21	A	Stock	45.98	46.25	45.41	46.04	1612600.0
2016-09-21	AA.B-DELISTED	Stock	31.75	32.1	31.38	32.04	34999.0
2016-09-21	AAAP-DELISTED	Stock	38.37	38.82	37.43	38.4099	50132.0
2016-09-21	AABA-DELISTED	Stock	42.89	44.22	42.89	44.14	11492794.0
2016-09-21	AAC-DELISTED	Stock	17.23	17.39	16.7	17.07	101813.0
2016-09-21	AACG	Stock	4.88	4.88	4.55	4.55	3900.0
2016-09-21	AAIC-DELISTED	Stock	15.1	15.3	14.91	15.25	242720.0
2016-09-21	AAL	Stock	35.0	35.15	33.9	34.67	10408200.0
2016-09-21	AAMC-DELISTED	Stock	4.3206	4.8911	4.3206	4.8235	83256.0
2016-09-21	AAME	Stock	3.37	3.42	3.31	3.31	1800.0
2016-09-21	AAMI	Stock	13.5	14.09	13.43	13.89	681800.0
2016-09-21	AAOI	Stock	21.32	21.81	21.2	21.76	507600.0
2016-09-21	AAON	Stock	18.9733	19.2067	18.8333	19.0333	157050.0
2016-09-21	AAP	Stock	145.58	146.57	145.15	146.33	1117000.0
2016-09-21	AAT	Stock	42.85	43.53	42.16	43.17	162300.0
2016-09-21	AAU-DELISTED	Stock	1.41	1.52	1.37	1.52	365252.0
2016-09-21	AAUAF-DELISTED	Stock	1.41	1.52	1.37	1.52	369137.0
2016-09-21	AAV-DELISTED	Stock	6.8	7.0	6.76	6.97	110902.0
2016-09-21	AAWW-DELISTED	Stock	38.54	39.3701	38.54	39.25	152058.0
2016-09-21	AAXJ	Stock	60.26	61.245	60.14	61.21	2175098.0
2016-09-21	AAXN-DELISTED	Stock	26.66	27.6	26.54	27.57	959746.0
2016-09-21	AB	Stock	22.76	23.0	22.61	22.95	163300.0
2016-09-21	ABAC-DELISTED	Stock	2.2499	2.3276	2.2101	2.29	14251.0
2016-09-21	ABAX-DELISTED	Stock	51.31	52.21	51.08	51.86	117135.0
2016-09-21	ABB-DELISTED	Stock	22.39	22.52	22.2316	22.5	1400455.0
2016-09-21	ABBNY-DELISTED	Stock	22.39	22.52	22.2316	22.51	1450297.0
2016-09-21	ABBV	Stock	63.49	64.25	63.2	64.1	7587400.0
2016-09-21	ABC-DELISTED	Stock	82.2	83.15	81.79	83.02	2557374.0
2016-09-21	ABCB	Stock	35.24	35.47	34.88	35.36	146800.0
2016-09-21	ABCD-DELISTED	Stock	5.35	5.44	5.295	5.39	9611.0
2016-09-21	ABCO-DELISTED	Stock	42.97	44.52	42.9025	44.3	274836.0
2016-09-21	ABDC-DELISTED	Stock	13.18	13.25	12.9902	13.21	44862.0
2016-09-21	ABE-DELISTED	Stock	12.58	12.73	12.58	12.67	7309.0
2016-09-21	ABEO	Stock	150.25	168.5	142.25	164.25	54468.0
2016-09-21	ABEOW-DELISTED	Stock	2.75	3.45	2.75	3.4292	8078.0
2016-09-21	ABEV	Stock	5.99	6.07	5.92	6.04	14562200.0
2016-09-21	ABG	Stock	52.44	53.41	52.34	53.24	169900.0
2016-09-21	ABIL-DELISTED	Stock	3.88	3.9	3.82	3.9	14658.0
2016-09-21	ABM	Stock	38.9	39.4	38.75	39.36	259100.0
2016-09-21	ABMD-DELISTED	Stock	125.63	127.19	124.43	126.89	243996.0

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

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