PREVIEW / etf_daily / 2017-06-19

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-19.parquet
  size:    55 KB
  rows:    1,409

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-06-19	SPY	ETF	243.59	244.73	243.48	244.66	65123800.0
2017-06-19	QQQ	ETF	139.45	140.59	139.28	140.46	39626533.0
2017-06-19	IWM	ETF	140.56	141.58	140.51	141.23	25163300.0
2017-06-19	DIA	ETF	214.36	215.01	214.08	214.92	2103300.0
2017-06-19	GLD	ETF	118.74	118.84	118.33	118.43	6787000.0
2017-06-19	TLT	ETF	126.32	126.48	126.03	126.17	5641300.0
2017-06-19	AADR	ETF	46.79	47.59	46.79	47.48	14100.0
2017-06-19	AAXJ	ETF	67.77	68.02	67.68	67.92	570900.0
2017-06-19	ACSI	ETF	28.98	28.98	28.95	28.95	11115.0
2017-06-19	ACTX	ETF	89.6808	100.3009	88.5008	95.5809	550.0
2017-06-19	ACWF	ETF	27.5	27.5625	27.5	27.5625	24947.0
2017-06-19	ACWI	ETF	66.5	66.73	66.47	66.66	1774600.0
2017-06-19	ACWV	ETF	81.05	81.16	80.94	81.13	132200.0
2017-06-19	ACWX	ETF	46.35	46.46	46.32	46.4	292085.0
2017-06-19	ADRE	ETF	38.12	38.4625	38.12	38.4403	4545.0
2017-06-19	AFK	ETF	21.7	21.79	21.65	21.65	3907.0
2017-06-19	AFTY	ETF	14.83	14.9	14.8	14.87	13800.0
2017-06-19	AGG	ETF	109.87	109.9	109.74	109.79	1610400.0
2017-06-19	AGGY	ETF	50.82	50.82	50.7	50.719	5700.0
2017-06-19	AGNG	ETF	18.64	18.75	18.64	18.738	1000.0
2017-06-19	AGQ	ETF	33.71	33.76	33.35	33.38	172300.0
2017-06-19	AGZ	ETF	113.95	114.1399	113.525	114.0	11085.0
2017-06-19	AGZD	ETF	23.975	23.985	23.975	23.985	6800.0
2017-06-19	AIA	ETF	57.35	57.46	57.24	57.44	157756.0
2017-06-19	AIQ	ETF	13.3	13.6	13.25	13.3	18838.0
2017-06-19	AIRR	ETF	23.69	23.9	23.69	23.86	37200.0
2017-06-19	AIVI	ETF	41.87	41.87	41.77	41.86	24700.0
2017-06-19	ALTY	ETF	15.68	15.68	15.54	15.581	4700.0
2017-06-19	AMJ	ETF	28.92	28.98	28.47	28.55	1615635.0
2017-06-19	AMLP	ETF	58.05	58.35	57.2	57.45	1081220.0
2017-06-19	AMZA	ETF	96.0	96.5	94.3	94.6	67760.0
2017-06-19	ANGL	ETF	29.65	29.69	29.61	29.64	263400.0
2017-06-19	AOA	ETF	52.04	52.19	52.04	52.15	29300.0
2017-06-19	AOK	ETF	34.23	34.23	34.07	34.07	51956.0
2017-06-19	AOM	ETF	37.45	37.49	37.36	37.47	84837.0
2017-06-19	AOR	ETF	43.87	43.9399	43.85	43.93	57329.0
2017-06-19	ARCM	ETF	100.245	100.245	100.245	100.245	20.0
2017-06-19	ARGT	ETF	29.54	29.99	29.54	29.89	69200.0
2017-06-19	ARKG	ETF	21.36	21.81	21.318	21.793	12400.0
2017-06-19	ARKK	ETF	28.83	29.34	28.83	29.32	56000.0
2017-06-19	ARKQ	ETF	28.95	29.1	28.864	29.09	34100.0
2017-06-19	ARKW	ETF	35.54	35.87	35.52	35.86	67200.0
2017-06-19	ASEA	ETF	15.05	15.17	15.05	15.16	1800.0
2017-06-19	ASET	ETF	27.875	27.8798	27.86	27.86	522.0
2017-06-19	ASHR	ETF	26.19	26.34	26.11	26.21	3019000.0
2017-06-19	ASHS	ETF	32.31	32.42	32.31	32.35	4100.0
2017-06-19	ASHX	ETF	20.14	20.14	20.14	20.14	287.0
2017-06-19	ATMP	ETF	21.77	21.77	21.46	21.54	49100.0
2017-06-19	BAB	ETF	29.99	30.06	29.96	30.02	66996.0
2017-06-19	BAL	ETF	45.62	45.62	45.28	45.4	9633.0

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

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