PREVIEW / etf_daily / 2016-10-20

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-20.parquet
  size:    52 KB
  rows:    1,298

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-10-20	SPY	ETF	213.87	214.53	213.11	213.88	73639800.0
2016-10-20	QQQ	ETF	117.68	117.97	117.03	117.71	18132245.0
2016-10-20	IWM	ETF	121.14	122.0	120.41	121.13	20485600.0
2016-10-20	DIA	ETF	181.72	182.45	181.22	181.54	2359600.0
2016-10-20	GLD	ETF	121.39	121.59	120.63	120.74	6496700.0
2016-10-20	TLT	ETF	133.64	133.75	132.9	133.11	6082300.0
2016-10-20	AADR	ETF	41.08	41.08	41.08	41.08	200.0
2016-10-20	AAXJ	ETF	59.94	60.18	59.79	59.93	478000.0
2016-10-20	ACTX	ETF	10.0301	12.3901	9.9121	12.3901	1648.0
2016-10-20	ACWF	ETF	23.8999	23.8999	23.8999	23.8999	134.0
2016-10-20	ACWI	ETF	58.47	58.64	58.29	58.46	1672000.0
2016-10-20	ACWV	ETF	74.33	74.5	74.11	74.2	127700.0
2016-10-20	ACWX	ETF	41.03	41.22	40.99	41.12	150246.0
2016-10-20	ADRE	ETF	35.68	35.8455	35.67	35.8455	5392.0
2016-10-20	AFK	ETF	20.37	20.39	20.2713	20.35	2909.0
2016-10-20	AFTY	ETF	13.515	13.515	13.515	13.515	200.0
2016-10-20	AGG	ETF	111.84	111.9	111.73	111.76	1420800.0
2016-10-20	AGGY	ETF	51.78	51.85	51.742	51.78	73100.0
2016-10-20	AGQ	ETF	40.79	40.79	39.55	39.97	136300.0
2016-10-20	AGZ	ETF	115.18	115.51	115.0275	115.11	14037.0
2016-10-20	AGZD	ETF	23.99	24.025	23.975	23.975	2400.0
2016-10-20	AIA	ETF	49.64	49.88	49.57	49.77	53211.0
2016-10-20	AIQ	ETF	7.75	7.95	7.75	7.9	3844.0
2016-10-20	AIRR	ETF	19.954	19.954	19.82	19.82	4500.0
2016-10-20	AIVI	ETF	37.85	38.17	37.85	38.11	8200.0
2016-10-20	ALTY	ETF	15.41	15.41	15.21	15.28	2900.0
2016-10-20	AMJ	ETF	31.45	31.48	31.16	31.47	2998166.0
2016-10-20	AMLP	ETF	63.35	63.4	62.95	63.4	1208660.0
2016-10-20	AMZA	ETF	109.3	109.3	108.3	109.3	9040.0
2016-10-20	ANGL	ETF	29.17	29.22	29.09	29.2	127300.0
2016-10-20	AOA	ETF	46.89	46.98	46.75	46.94	25000.0
2016-10-20	AOK	ETF	33.15	33.15	33.026	33.1101	34601.0
2016-10-20	AOM	ETF	35.61	35.71	35.52	35.64	58027.0
2016-10-20	AOR	ETF	40.66	40.68	40.5192	40.56	67008.0
2016-10-20	ARGT	ETF	24.33	24.43	24.06	24.37	153600.0
2016-10-20	ARKG	ETF	17.74	17.8	17.74	17.799	7700.0
2016-10-20	ARKK	ETF	20.67	20.67	20.57	20.57	400.0
2016-10-20	ARKQ	ETF	21.4	21.4	21.24	21.24	900.0
2016-10-20	ARKW	ETF	24.95	24.95	24.923	24.923	400.0
2016-10-20	ASEA	ETF	13.72	13.8	13.72	13.8	400.0
2016-10-20	ASHR	ETF	24.66	24.78	24.66	24.76	429900.0
2016-10-20	ASHS	ETF	35.01	35.07	34.98	35.06	14400.0
2016-10-20	ATMP	ETF	23.16	23.28	23.09	23.23	20400.0
2016-10-20	BAB	ETF	30.97	30.97	30.87	30.89	99030.0
2016-10-20	BAL	ETF	47.28	47.38	45.9201	46.22	11162.0
2016-10-20	BBC	ETF	19.6441	20.0508	19.6441	20.0508	3701.0
2016-10-20	BBH	ETF	106.83	107.89	106.64	107.53	129100.0
2016-10-20	BBP	ETF	30.45	30.497	30.228	30.4	3800.0
2016-10-20	BCM	ETF	26.5949	26.63	26.556	26.5676	1502.0
2016-10-20	BFOR	ETF	7.95	7.9675	7.925	7.9375	18400.0

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

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