PREVIEW / etf_daily / 2016-04-21

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-21.parquet
  size:    51 KB
  rows:    1,267

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-04-21	SPY	ETF	210.12	210.25	208.65	208.97	85695000.0
2016-04-21	QQQ	ETF	110.58	111.05	110.15	110.65	20215983.0
2016-04-21	IWM	ETF	113.47	113.92	112.66	112.99	20535700.0
2016-04-21	DIA	ETF	180.64	180.88	179.42	179.7	2760300.0
2016-04-21	GLD	ETF	120.42	120.55	119.13	119.42	14612800.0
2016-04-21	TLT	ETF	128.44	129.07	128.29	128.69	11154200.0
2016-04-21	AADR	ETF	39.8	39.8	39.01	39.01	800.0
2016-04-21	AAXJ	ETF	55.53	55.6	55.09	55.17	548400.0
2016-04-21	ACTX	ETF	4.425	4.72	4.13	4.72	572.0
2016-04-21	ACWF	ETF	23.4637	23.4637	23.4637	23.4637	100.0
2016-04-21	ACWI	ETF	57.8	57.85	57.41	57.52	922700.0
2016-04-21	ACWV	ETF	74.59	74.62	73.76	73.89	152700.0
2016-04-21	ACWX	ETF	41.16	41.22	40.87	40.96	830081.0
2016-04-21	ADRE	ETF	32.18	32.26	31.9353	31.9509	4563.0
2016-04-21	AFK	ETF	20.29	20.77	20.03	20.03	17703.0
2016-04-21	AFTY	ETF	12.86	12.87	12.78	12.78	5600.0
2016-04-21	AGG	ETF	110.52	110.62	110.45	110.51	2692800.0
2016-04-21	AGGY	ETF	50.79	50.81	50.71	50.71	5400.0
2016-04-21	AGQ	ETF	41.04	41.04	38.46	39.82	945300.0
2016-04-21	AGZ	ETF	114.31	114.46	114.28	114.36	8477.0
2016-04-21	AGZD	ETF	24.07	24.07	24.07	24.07	800.0
2016-04-21	AIA	ETF	44.13	44.19	43.85	43.85	9483.0
2016-04-21	AIQ	ETF	7.0	7.14	7.0	7.03	19068.0
2016-04-21	AIRR	ETF	18.07	18.07	17.92	17.92	2200.0
2016-04-21	AIVI	ETF	39.78	39.79	39.53	39.54	11400.0
2016-04-21	ALTY	ETF	14.452	14.54	14.452	14.54	300.0
2016-04-21	AMJ	ETF	29.57	29.95	29.45	29.58	2000517.0
2016-04-21	AMLP	ETF	60.55	61.25	60.1	60.5	2578700.0
2016-04-21	AMZA	ETF	102.5	103.4	101.0	101.9	6500.0
2016-04-21	ANGL	ETF	26.99	27.0	26.9	26.94	224100.0
2016-04-21	AOA	ETF	46.35	46.35	46.02	46.08	27900.0
2016-04-21	AOK	ETF	32.56	32.628	32.48	32.52	16280.0
2016-04-21	AOM	ETF	35.18	35.18	34.95	35.04	83983.0
2016-04-21	AOR	ETF	40.14	40.14	39.8305	39.9	187528.0
2016-04-21	ARGT	ETF	21.26	21.27	21.07	21.11	59100.0
2016-04-21	ARKG	ETF	18.5	18.5	18.5	18.5	100.0
2016-04-21	ARKK	ETF	19.664	19.757	19.664	19.757	500.0
2016-04-21	ARKQ	ETF	19.612	19.74	19.612	19.7	400.0
2016-04-21	ARKW	ETF	21.19	21.25	21.19	21.25	1200.0
2016-04-21	ASEA	ETF	13.65	13.65	13.62	13.62	1400.0
2016-04-21	ASET	ETF	25.9715	25.9715	25.8	25.8	571.0
2016-04-21	ASHR	ETF	24.04	24.05	23.76	23.77	2337500.0
2016-04-21	ASHS	ETF	33.44	33.44	33.09	33.18	101900.0
2016-04-21	ATMP	ETF	20.08	20.49	20.08	20.25	28000.0
2016-04-21	BAB	ETF	30.04	30.07	30.0	30.03	152647.0
2016-04-21	BAL	ETF	42.47	42.58	42.02	42.5	4561.0
2016-04-21	BBC	ETF	20.56	21.3	20.56	21.24	7396.0
2016-04-21	BBH	ETF	110.74	113.06	110.54	112.98	64000.0
2016-04-21	BBP	ETF	26.73	27.29	26.73	27.18	12500.0
2016-04-21	BCM	ETF	25.805	25.99	25.795	25.795	8568.0

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

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