PREVIEW / etf_daily / 2016-02-17

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-17.parquet
  size:    50 KB
  rows:    1,240

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-02-17	SPY	ETF	191.16	193.32	191.01	192.88	136009500.0
2016-02-17	QQQ	ETF	101.01	102.64	100.7	102.5	41766451.0
2016-02-17	IWM	ETF	99.57	101.09	99.53	100.43	40940400.0
2016-02-17	DIA	ETF	163.43	165.26	163.33	164.93	5584200.0
2016-02-17	GLD	ETF	115.47	116.07	114.89	115.48	10582400.0
2016-02-17	TLT	ETF	129.64	129.83	128.71	129.31	13157300.0
2016-02-17	AADR	ETF	36.36	36.61	36.23	36.48	40100.0
2016-02-17	AAXJ	ETF	49.13	49.63	49.05	49.59	632300.0
2016-02-17	ACTX	ETF	4.72	4.779	4.72	4.72	403.0
2016-02-17	ACWF	ETF	21.49	21.5	21.47	21.47	6319.0
2016-02-17	ACWI	ETF	51.63	52.4	51.63	52.33	1509500.0
2016-02-17	ACWV	ETF	68.61	69.0	68.39	68.94	505900.0
2016-02-17	ACWX	ETF	36.47	36.89	36.46	36.83	967176.0
2016-02-17	ADRE	ETF	26.9	27.29	26.87	27.191	16161.0
2016-02-17	AFK	ETF	16.65	16.989	16.54	16.86	85684.0
2016-02-17	AFTY	ETF	12.0	12.21	12.0	12.2	15400.0
2016-02-17	AGG	ETF	109.43	109.46	109.22	109.44	2446600.0
2016-02-17	AGGY	ETF	49.57	49.57	49.34	49.457	9400.0
2016-02-17	AGQ	ETF	32.58	33.07	32.55	32.58	133400.0
2016-02-17	AGZ	ETF	114.5	114.7	114.3501	114.68	23296.0
2016-02-17	AGZD	ETF	23.545	23.545	23.53	23.53	800.0
2016-02-17	AIA	ETF	38.79	39.27	38.79	39.27	13800.0
2016-02-17	AIQ	ETF	7.01	7.21	6.6	7.18	9069.0
2016-02-17	AIRR	ETF	14.99	14.991	14.99	14.991	200.0
2016-02-17	AIVI	ETF	36.28	36.66	36.28	36.6	23600.0
2016-02-17	AMJ	ETF	24.25	24.94	23.94	24.65	6911766.0
2016-02-17	AMLP	ETF	47.25	48.75	46.45	48.0	4364820.0
2016-02-17	AMZA	ETF	77.6	79.3	75.0	78.8	9130.0
2016-02-17	ANGL	ETF	23.49	23.72	23.49	23.7	67900.0
2016-02-17	AOA	ETF	42.34	42.67	42.25	42.64	77400.0
2016-02-17	AOK	ETF	31.17	31.255	31.09	31.18	118498.0
2016-02-17	AOM	ETF	33.26	33.4399	33.2594	33.42	37797.0
2016-02-17	AOR	ETF	37.24	37.5	37.236	37.49	188876.0
2016-02-17	ARGT	ETF	17.33	17.81	17.33	17.69	157400.0
2016-02-17	ARKG	ETF	16.372	16.372	16.372	16.372	100.0
2016-02-17	ARKK	ETF	15.999	16.13	15.999	16.13	500.0
2016-02-17	ARKQ	ETF	15.756	15.78	15.756	15.78	300.0
2016-02-17	ARKW	ETF	17.937	18.04	17.93	18.04	700.0
2016-02-17	ASEA	ETF	12.27	12.38	12.27	12.38	1400.0
2016-02-17	ASET	ETF	23.57	23.58	23.57	23.58	1914.0
2016-02-17	ASHR	ETF	23.03	23.48	22.98	23.43	2225000.0
2016-02-17	ASHS	ETF	32.64	33.23	32.6	33.13	82200.0
2016-02-17	ASHX	ETF	20.68	20.68	20.68	20.68	600.0
2016-02-17	ATMP	ETF	16.0	16.58	15.82	16.58	44600.0
2016-02-17	BAB	ETF	29.75	29.835	29.67	29.72	168406.0
2016-02-17	BAL	ETF	39.22	39.22	38.81	38.81	11135.0
2016-02-17	BBC	ETF	19.53	19.71	18.3614	19.01	20515.0
2016-02-17	BBH	ETF	102.41	103.75	101.33	103.68	118600.0
2016-02-17	BBP	ETF	23.51	24.02	23.51	23.84	5200.0
2016-02-17	BCM	ETF	22.98	23.306	22.98	23.29	3769.0

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

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