PREVIEW / etf_daily / 2016-10-17

all etf daily files

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

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-17	SPY	ETF	213.09	213.39	212.17	212.38	58275700.0
2016-10-17	QQQ	ETF	117.1	117.3	116.672	116.82	14182694.0
2016-10-17	IWM	ETF	120.58	120.85	120.16	120.29	17119500.0
2016-10-17	DIA	ETF	181.17	181.51	180.45	180.72	1801800.0
2016-10-17	GLD	ETF	119.7	119.92	119.58	119.68	4777900.0
2016-10-17	TLT	ETF	132.1	132.74	132.09	132.43	10595900.0
2016-10-17	AADR	ETF	40.36	40.6	40.22	40.22	3800.0
2016-10-17	AAXJ	ETF	59.0	59.16	58.91	59.0	401700.0
2016-10-17	ACTX	ETF	12.3901	14.1601	8.8501	11.2101	7084.0
2016-10-17	ACWI	ETF	57.93	58.05	57.79	57.84	1208500.0
2016-10-17	ACWV	ETF	74.15	74.22	73.96	73.99	287300.0
2016-10-17	ACWX	ETF	40.5	40.62	40.45	40.45	263409.0
2016-10-17	ADRE	ETF	35.05	35.1668	35.05	35.14	13701.0
2016-10-17	AFK	ETF	19.91	19.9527	19.88	19.9	5293.0
2016-10-17	AFTY	ETF	13.328	13.328	13.328	13.328	400.0
2016-10-17	AGG	ETF	111.45	111.61	111.39	111.56	1556800.0
2016-10-17	AGGY	ETF	51.51	51.673	51.51	51.65	13400.0
2016-10-17	AGNG	ETF	15.77	15.77	15.62	15.62	500.0
2016-10-17	AGQ	ETF	39.51	39.74	39.3	39.57	56300.0
2016-10-17	AGZ	ETF	115.09	115.1698	114.9701	115.0101	16454.0
2016-10-17	AGZD	ETF	23.945	24.02	23.945	24.02	1000.0
2016-10-17	AIA	ETF	48.9022	49.11	48.89	48.94	58843.0
2016-10-17	AIQ	ETF	7.6	7.8873	7.6	7.7	19204.0
2016-10-17	AIRR	ETF	19.86	19.86	19.74	19.791	8700.0
2016-10-17	AIVI	ETF	37.63	37.7	37.59	37.62	16700.0
2016-10-17	ALTY	ETF	15.34	15.34	15.09	15.15	3800.0
2016-10-17	AMJ	ETF	30.96	31.07	30.8	30.93	1119078.0
2016-10-17	AMLP	ETF	62.35	62.75	62.35	62.75	1053140.0
2016-10-17	AMZA	ETF	107.6	107.63	106.6	107.27	6560.0
2016-10-17	ANGL	ETF	29.08	29.08	29.01	29.05	175700.0
2016-10-17	AOA	ETF	46.48	46.56	46.43	46.48	31400.0
2016-10-17	AOK	ETF	32.9	32.985	32.8752	32.91	20518.0
2016-10-17	AOM	ETF	35.41	35.5	35.373	35.46	35683.0
2016-10-17	AOR	ETF	40.29	40.4099	40.2612	40.35	57006.0
2016-10-17	ARGT	ETF	23.7	24.0	23.7	23.98	7800.0
2016-10-17	ARKG	ETF	17.49	17.581	17.49	17.581	500.0
2016-10-17	ARKK	ETF	20.4	20.42	20.13	20.24	179900.0
2016-10-17	ARKQ	ETF	21.12	21.22	21.12	21.19	1000.0
2016-10-17	ARKW	ETF	24.32	24.32	24.32	24.32	1100.0
2016-10-17	ASEA	ETF	13.55	13.6	13.54	13.6	1000.0
2016-10-17	ASET	ETF	25.72	25.72	25.72	25.72	289.0
2016-10-17	ASHR	ETF	24.4	24.43	24.35	24.38	566700.0
2016-10-17	ASHS	ETF	34.4	34.65	34.4	34.58	2700.0
2016-10-17	ASHX	ETF	22.59	22.61	22.59	22.61	1000.0
2016-10-17	ATMP	ETF	22.76	22.84	22.71	22.84	30100.0
2016-10-17	BAB	ETF	30.85	30.92	30.79	30.85	120196.0
2016-10-17	BAL	ETF	46.8	47.27	46.78	47.27	11235.0
2016-10-17	BBC	ETF	20.06	20.06	19.5	19.63	12146.0
2016-10-17	BBH	ETF	105.28	106.82	104.82	106.1	64000.0
2016-10-17	BBP	ETF	30.68	30.68	30.08	30.33	10100.0

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

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