PREVIEW / etf_daily / 2016-12-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-21.parquet
  size:    53 KB
  rows:    1,349

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-12-21	SPY	ETF	226.25	226.45	225.77	225.77	67909000.0
2016-12-21	QQQ	ETF	120.57	120.68	120.19	120.46	7079300.0
2016-12-21	IWM	ETF	137.85	138.15	137.01	137.06	23215900.0
2016-12-21	DIA	ETF	199.43	199.61	199.14	199.16	2523500.0
2016-12-21	GLD	ETF	108.25	108.31	107.68	107.85	5188700.0
2016-12-21	TLT	ETF	117.92	118.4	117.73	118.33	4624700.0
2016-12-21	AADR	ETF	39.65	39.66	39.35	39.65	6900.0
2016-12-21	AAXJ	ETF	54.87	54.9	54.63	54.63	2053100.0
2016-12-21	ACSI	ETF	27.59	27.59	27.5	27.505	7295.0
2016-12-21	ACTX	ETF	17.1102	21.8302	15.3401	17.7002	1058.0
2016-12-21	ACWF	ETF	24.32	24.32	24.32	24.32	144.0
2016-12-21	ACWI	ETF	59.5	59.57	59.42	59.42	1620200.0
2016-12-21	ACWV	ETF	72.48	72.58	72.33	72.33	190100.0
2016-12-21	ACWX	ETF	40.23	40.23	40.14	40.19	2028143.0
2016-12-21	ADRE	ETF	32.33	32.33	32.2407	32.28	10629.0
2016-12-21	AFK	ETF	19.42	19.53	19.11	19.11	39221.0
2016-12-21	AFTY	ETF	13.11	13.13	13.02	13.13	2800.0
2016-12-21	AGG	ETF	107.5	107.66	107.43	107.64	4066900.0
2016-12-21	AGGY	ETF	49.246	49.355	49.24	49.24	14200.0
2016-12-21	AGQ	ETF	32.88	33.05	32.12	32.3	116400.0
2016-12-21	AGZ	ETF	112.2	112.3264	112.1111	112.29	14089.0
2016-12-21	AGZD	ETF	24.05	24.145	24.045	24.145	10800.0
2016-12-21	AIA	ETF	47.07	47.12	46.96	46.97	23146.0
2016-12-21	AIQ	ETF	9.6	9.6	9.55	9.6	16827.0
2016-12-21	AIRR	ETF	24.46	24.46	24.203	24.203	121600.0
2016-12-21	AIVI	ETF	37.62	37.68	37.56	37.57	20100.0
2016-12-21	ALTY	ETF	14.71	14.88	14.71	14.88	1200.0
2016-12-21	AMJ	ETF	30.61	31.18	30.61	31.12	1603977.0
2016-12-21	AMLP	ETF	62.25	62.7	62.0	62.5	2846160.0
2016-12-21	AMUB	ETF	19.428	19.6304	19.428	19.6304	450.0
2016-12-21	AMZA	ETF	111.0	112.1	110.71	111.9	66280.0
2016-12-21	ANGL	ETF	28.96	28.97	28.86	28.92	156000.0
2016-12-21	AOA	ETF	47.78	47.78	47.62	47.68	139000.0
2016-12-21	AOK	ETF	32.63	32.63	32.5	32.5	132633.0
2016-12-21	AOM	ETF	35.35	35.46	35.32	35.32	345732.0
2016-12-21	AOR	ETF	40.86	40.86	40.7501	40.81	300582.0
2016-12-21	ARGT	ETF	22.47	22.61	22.21	22.56	73600.0
2016-12-21	ARKG	ETF	17.86	17.92	17.46	17.46	1000.0
2016-12-21	ARKK	ETF	20.66	20.66	20.5	20.5	800.0
2016-12-21	ARKQ	ETF	22.5	22.5	22.38	22.38	500.0
2016-12-21	ARKW	ETF	25.56	25.61	25.56	25.61	1800.0
2016-12-21	ASEA	ETF	12.96	12.98	12.96	12.96	2100.0
2016-12-21	ASET	ETF	25.78	25.785	25.78	25.785	732.0
2016-12-21	ASHR	ETF	23.91	23.93	23.85	23.86	680900.0
2016-12-21	ASHS	ETF	32.89	33.04	32.89	32.99	13000.0
2016-12-21	ATMP	ETF	23.11	23.37	23.11	23.35	103000.0
2016-12-21	BAB	ETF	28.91	28.95	28.8701	28.89	132598.0
2016-12-21	BAL	ETF	46.45	46.55	45.79	46.21	10676.0
2016-12-21	BBC	ETF	18.93	18.93	18.62	18.62	2417.0
2016-12-21	BBH	ETF	108.19	108.42	107.05	107.3	47400.0

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

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