PREVIEW / etf_daily / 2016-07-22

all etf daily files

  file:    by_date/etf_daily/2016/2016-07-22.parquet
  size:    51 KB
  rows:    1,292

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-07-22	SPY	ETF	216.41	217.3	216.1	217.24	62787500.0
2016-07-22	QQQ	ETF	113.28	113.78	112.911	113.65	20003363.0
2016-07-22	IWM	ETF	119.58	120.65	119.35	120.4	17796100.0
2016-07-22	DIA	ETF	185.0	185.57	184.76	185.51	3078300.0
2016-07-22	GLD	ETF	126.43	126.52	126.01	126.35	7716000.0
2016-07-22	TLT	ETF	137.93	139.24	137.87	138.8	5811400.0
2016-07-22	AADR	ETF	40.33	40.33	40.33	40.33	200.0
2016-07-22	AAXJ	ETF	57.12	57.29	57.0	57.24	522500.0
2016-07-22	ACTX	ETF	3.54	3.54	3.54	3.54	340.0
2016-07-22	ACWF	ETF	23.4207	23.4207	23.4207	23.4207	131.0
2016-07-22	ACWI	ETF	57.89	57.97	57.75	57.96	974500.0
2016-07-22	ACWV	ETF	77.43	77.77	77.32	77.64	218100.0
2016-07-22	ACWX	ETF	40.06	40.07	39.926	40.05	294463.0
2016-07-22	ADRE	ETF	32.89	32.956	32.7301	32.956	4396.0
2016-07-22	AFK	ETF	20.489	20.489	19.67	19.67	54922.0
2016-07-22	AFTY	ETF	12.98	13.06	12.98	13.06	3700.0
2016-07-22	AGG	ETF	112.38	112.61	112.35	112.53	2315900.0
2016-07-22	AGGY	ETF	52.02	52.14	51.961	52.05	44200.0
2016-07-22	AGQ	ETF	51.53	51.89	51.16	51.51	113500.0
2016-07-22	AGZ	ETF	115.38	115.73	115.38	115.6599	10979.0
2016-07-22	AGZD	ETF	23.97	23.97	23.91	23.91	9000.0
2016-07-22	AIA	ETF	46.83	47.03	46.76	46.97	39446.0
2016-07-22	AIQ	ETF	6.1185	6.28	6.06	6.19	37523.0
2016-07-22	AIRR	ETF	19.101	19.269	19.101	19.269	9000.0
2016-07-22	AIVI	ETF	38.36	38.39	38.25	38.26	8000.0
2016-07-22	ALTY	ETF	15.48	15.61	15.48	15.546	3000.0
2016-07-22	AMJ	ETF	32.26	32.345	32.06	32.3	988064.0
2016-07-22	AMLP	ETF	64.6	64.7	64.3	64.55	1204580.0
2016-07-22	AMZA	ETF	114.0	114.0	112.7	113.4	9490.0
2016-07-22	ANGL	ETF	28.36	28.36	28.3	28.36	161900.0
2016-07-22	AOA	ETF	46.47	46.73	46.47	46.71	24900.0
2016-07-22	AOK	ETF	33.13	33.21	33.05	33.16	39742.0
2016-07-22	AOM	ETF	35.7	35.72	35.5701	35.67	91144.0
2016-07-22	AOR	ETF	40.53	40.55	40.384	40.51	44116.0
2016-07-22	ARGT	ETF	22.71	22.84	22.61	22.84	23600.0
2016-07-22	ARKG	ETF	18.205	18.205	18.205	18.205	200.0
2016-07-22	ARKK	ETF	20.135	20.135	20.135	20.135	100.0
2016-07-22	ARKQ	ETF	20.422	20.422	20.422	20.422	200.0
2016-07-22	ARKW	ETF	23.63	23.66	23.53	23.66	300.0
2016-07-22	ASEA	ETF	13.88	13.95	13.87	13.95	3300.0
2016-07-22	ASHR	ETF	24.3	24.37	24.29	24.34	684400.0
2016-07-22	ASHS	ETF	35.26	35.3	35.23	35.3	4200.0
2016-07-22	ATMP	ETF	22.9	22.9	22.71	22.86	117700.0
2016-07-22	BAB	ETF	31.37	31.5	31.3075	31.43	149654.0
2016-07-22	BAL	ETF	48.04	48.57	47.89	48.46	16926.0
2016-07-22	BBC	ETF	19.06	19.5	19.06	19.3	12350.0
2016-07-22	BBH	ETF	111.72	112.45	111.34	111.85	105000.0
2016-07-22	BBP	ETF	29.82	30.18	29.82	29.91	14200.0
2016-07-22	BCM	ETF	26.18	26.25	25.998	26.21	19448.0
2016-07-22	BFOR	ETF	7.945	8.0075	7.935	8.005	29600.0

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

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