PREVIEW / etf_daily / 2016-04-19

all etf daily files

  file:    by_date/etf_daily/2016/2016-04-19.parquet
  size:    50 KB
  rows:    1,265

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-19	SPY	ETF	209.74	210.2	208.94	209.9	88316100.0
2016-04-19	QQQ	ETF	111.44	111.44	109.88	110.55	42481435.0
2016-04-19	IWM	ETF	113.51	114.13	112.89	113.39	23228100.0
2016-04-19	DIA	ETF	180.14	180.77	179.59	180.32	2992100.0
2016-04-19	GLD	ETF	119.87	120.09	119.37	119.58	21031500.0
2016-04-19	TLT	ETF	131.08	131.31	130.29	130.9	5212200.0
2016-04-19	AADR	ETF	39.59	39.59	39.4	39.4	1000.0
2016-04-19	AAXJ	ETF	55.78	56.14	55.69	56.07	566900.0
2016-04-19	ACTX	ETF	4.13	5.31	4.13	5.31	469.0
2016-04-19	ACWF	ETF	23.68	23.68	23.68	23.68	600.0
2016-04-19	ACWI	ETF	57.61	57.91	57.57	57.85	1316200.0
2016-04-19	ACWV	ETF	75.08	75.18	74.84	75.04	208100.0
2016-04-19	ACWX	ETF	41.13	41.29	41.05	41.235	248434.0
2016-04-19	ADRE	ETF	31.87	32.2499	31.87	32.05	38118.0
2016-04-19	AFK	ETF	19.82	20.23	19.75	20.23	49327.0
2016-04-19	AFTY	ETF	13.02	13.06	12.98	12.98	24200.0
2016-04-19	AGG	ETF	110.94	111.0	110.77	110.93	2019200.0
2016-04-19	AGGY	ETF	50.875	50.88	50.77	50.88	3500.0
2016-04-19	AGQ	ETF	39.83	39.89	39.12	39.52	536400.0
2016-04-19	AGZ	ETF	114.88	114.88	114.53	114.65	14610.0
2016-04-19	AGZD	ETF	23.88	23.905	23.875	23.905	800.0
2016-04-19	AIA	ETF	44.38	44.517	44.25	44.49	7591.0
2016-04-19	AIQ	ETF	7.1427	7.1427	6.92	7.05	8983.0
2016-04-19	AIRR	ETF	17.95	18.145	17.95	18.145	6300.0
2016-04-19	AIVI	ETF	39.78	40.0	39.77	39.94	26800.0
2016-04-19	ALTY	ETF	14.65	14.67	14.65	14.65	800.0
2016-04-19	AMJ	ETF	27.93	29.05	27.71	28.99	6113444.0
2016-04-19	AMLP	ETF	57.6	59.5	57.5	59.35	2538420.0
2016-04-19	AMZA	ETF	94.8	98.5	94.7	97.9	7400.0
2016-04-19	ANGL	ETF	26.54	26.68	26.46	26.67	135200.0
2016-04-19	AOA	ETF	46.08	46.38	46.08	46.3	44200.0
2016-04-19	AOK	ETF	32.62	32.66	32.54	32.64	49077.0
2016-04-19	AOM	ETF	35.13	35.18	35.07	35.17	81666.0
2016-04-19	AOR	ETF	40.1	40.182	39.9657	40.09	92543.0
2016-04-19	ARGT	ETF	20.63	21.07	20.61	21.07	83900.0
2016-04-19	ARKG	ETF	18.38	18.38	18.16	18.16	900.0
2016-04-19	ARKK	ETF	19.63	19.63	19.394	19.394	1100.0
2016-04-19	ARKQ	ETF	19.48	19.56	19.27	19.41	2300.0
2016-04-19	ARKW	ETF	21.39	21.39	21.0	21.0	1800.0
2016-04-19	ASEA	ETF	13.82	13.87	13.82	13.87	1500.0
2016-04-19	ASET	ETF	26.249	26.249	26.249	26.249	301.0
2016-04-19	ASHR	ETF	24.81	24.9	24.74	24.88	1280700.0
2016-04-19	ASHS	ETF	35.73	35.82	35.6	35.73	29100.0
2016-04-19	ASHX	ETF	22.04	22.044	22.04	22.044	303.0
2016-04-19	ATMP	ETF	19.43	19.83	19.42	19.83	38600.0
2016-04-19	BAB	ETF	30.27	30.275	30.19	30.24	168619.0
2016-04-19	BAL	ETF	41.6	41.86	41.4	41.76	10210.0
2016-04-19	BBC	ETF	21.15	21.2799	20.55	20.8901	10461.0
2016-04-19	BBH	ETF	111.54	111.54	109.75	110.21	67800.0
2016-04-19	BBP	ETF	26.89	26.9	26.66	26.66	2000.0

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

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