PREVIEW / etf_daily / 2017-08-17

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-17.parquet
  size:    56 KB
  rows:    1,437

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
2017-08-17	SPY	ETF	246.24	246.6	243.09	243.09	128490400.0
2017-08-17	QQQ	ETF	143.73	143.94	141.33	141.33	70190975.0
2017-08-17	IWM	ETF	136.98	137.69	134.92	134.93	32722900.0
2017-08-17	DIA	ETF	220.0	220.07	217.77	217.81	3535800.0
2017-08-17	GLD	ETF	122.29	122.61	121.76	122.49	8183800.0
2017-08-17	TLT	ETF	125.7	126.68	125.51	126.65	9364700.0
2017-08-17	AADR	ETF	51.09	51.13	50.72	50.73	11300.0
2017-08-17	AAXJ	ETF	70.42	70.56	69.75	69.81	1320100.0
2017-08-17	ACSI	ETF	28.89	28.89	28.67	28.67	14231.0
2017-08-17	ACTX	ETF	82.3057	85.5508	73.7507	82.6007	416.0
2017-08-17	ACWF	ETF	27.86	27.91	27.6108	27.6108	3081.0
2017-08-17	ACWI	ETF	66.95	67.06	66.28	66.28	1594000.0
2017-08-17	ACWV	ETF	80.97	81.01	80.31	80.34	122100.0
2017-08-17	ACWX	ETF	46.93	46.97	46.51	46.53	464649.0
2017-08-17	ADRE	ETF	41.68	41.8199	41.1447	41.19	3647.0
2017-08-17	AFK	ETF	22.97	23.0	22.75	22.75	18717.0
2017-08-17	AFTY	ETF	16.11	16.13	16.11	16.13	2000.0
2017-08-17	AGG	ETF	109.83	110.02	109.78	110.02	5403500.0
2017-08-17	AGGY	ETF	50.74	50.809	50.74	50.798	8000.0
2017-08-17	AGNG	ETF	18.53	18.606	18.5	18.5	1400.0
2017-08-17	AGQ	ETF	35.37	35.54	34.77	35.04	102000.0
2017-08-17	AGZ	ETF	113.99	114.15	113.95	114.09	21503.0
2017-08-17	AGZD	ETF	23.95	23.985	23.945	23.975	11800.0
2017-08-17	AIA	ETF	59.92	59.9336	59.27	59.27	34384.0
2017-08-17	AIQ	ETF	13.15	13.2	13.05	13.1	59270.0
2017-08-17	AIRR	ETF	22.79	23.03	22.62	22.62	73900.0
2017-08-17	AIVI	ETF	41.7	41.7	41.5	41.5	4500.0
2017-08-17	ALTY	ETF	15.6	15.61	15.46	15.46	5200.0
2017-08-17	AMJ	ETF	27.42	27.69	27.42	27.44	3342195.0
2017-08-17	AMLP	ETF	53.9	54.15	53.55	53.65	2766780.0
2017-08-17	AMZA	ETF	87.8	88.7	87.7	87.9	75260.0
2017-08-17	ANGL	ETF	29.73	29.75	29.6	29.67	207600.0
2017-08-17	AOA	ETF	52.33	52.36	51.86	51.88	37700.0
2017-08-17	AOK	ETF	34.13	34.18	34.04	34.04	60446.0
2017-08-17	AOM	ETF	37.52	37.52	37.32	37.35	107007.0
2017-08-17	AOR	ETF	44.01	44.03	43.72	43.76	115144.0
2017-08-17	ARCM	ETF	100.0	100.0	100.0	100.0	1400.0
2017-08-17	ARGT	ETF	29.15	29.29	28.83	28.83	32800.0
2017-08-17	ARKG	ETF	22.46	22.572	21.95	21.95	37400.0
2017-08-17	ARKK	ETF	31.5	31.72	30.947	30.97	66300.0
2017-08-17	ARKQ	ETF	29.27	29.33	28.798	28.798	20500.0
2017-08-17	ARKW	ETF	39.03	39.18	38.33	38.35	61700.0
2017-08-17	ASEA	ETF	15.16	15.2	15.16	15.17	2500.0
2017-08-17	ASET	ETF	27.94	27.94	27.81	27.81	2214.0
2017-08-17	ASHR	ETF	28.07	28.07	27.94	27.96	887900.0
2017-08-17	ASHS	ETF	34.55	34.55	34.35	34.41	3900.0
2017-08-17	ASHX	ETF	20.95	20.95	20.95	20.95	200.0
2017-08-17	ATMP	ETF	21.05	21.05	20.74	20.75	59400.0
2017-08-17	BAB	ETF	30.25	30.32	30.16	30.29	82866.0
2017-08-17	BAL	ETF	43.99	44.01	43.88	44.0	3400.0

> showing 50 of 1,437 rows — these rows as CSV

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