PREVIEW / etf_daily / 2016-12-13

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-13.parquet
  size:    54 KB
  rows:    1,351

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-12-13	SPY	ETF	227.02	228.34	227.0	227.76	110477500.0
2016-12-13	QQQ	ETF	119.35	121.11	119.32	120.46	54477889.0
2016-12-13	IWM	ETF	137.53	138.05	136.24	136.86	32624600.0
2016-12-13	DIA	ETF	198.96	199.72	198.64	199.23	5357500.0
2016-12-13	GLD	ETF	110.57	110.79	110.06	110.45	7961600.0
2016-12-13	TLT	ETF	118.4	118.49	117.44	118.14	12189200.0
2016-12-13	AADR	ETF	41.0	41.0	40.62	40.83	4300.0
2016-12-13	AAXJ	ETF	57.19	57.65	57.19	57.57	2407300.0
2016-12-13	ACSI	ETF	27.55	27.55	27.38	27.51	10350.0
2016-12-13	ACTX	ETF	20.6502	21.2402	19.4702	21.2402	420.0
2016-12-13	ACWF	ETF	24.89	24.89	24.89	24.89	167.0
2016-12-13	ACWI	ETF	60.4	60.77	60.4	60.6	1796100.0
2016-12-13	ACWV	ETF	73.99	74.22	73.97	74.1	233500.0
2016-12-13	ACWX	ETF	41.3	41.47	41.245	41.38	1067483.0
2016-12-13	ADRE	ETF	33.45	33.62	33.45	33.54	5394.0
2016-12-13	AFK	ETF	20.0	20.4565	19.8297	20.02	6714.0
2016-12-13	AFTY	ETF	13.81	13.81	13.81	13.81	500.0
2016-12-13	AGG	ETF	107.87	107.94	107.71	107.88	3665900.0
2016-12-13	AGGY	ETF	49.52	49.53	49.35	49.44	14400.0
2016-12-13	AGQ	ETF	37.26	37.41	35.91	36.46	143500.0
2016-12-13	AGZ	ETF	112.35	112.97	112.2622	112.47	20009.0
2016-12-13	AGZD	ETF	23.99	24.025	23.99	24.025	600.0
2016-12-13	AIA	ETF	48.46	48.635	48.37	48.52	29515.0
2016-12-13	AIQ	ETF	9.1	9.2	8.9	9.15	52764.0
2016-12-13	AIRR	ETF	24.44	24.45	23.801	23.94	189500.0
2016-12-13	AIVI	ETF	38.28	38.45	38.25	38.35	69400.0
2016-12-13	ALTY	ETF	15.148	15.148	14.9	14.91	1900.0
2016-12-13	AMJ	ETF	30.16	30.4	30.06	30.3	1722774.0
2016-12-13	AMLP	ETF	61.7	61.7	61.2	61.6	1734520.0
2016-12-13	AMZA	ETF	108.9	109.1	108.0	108.8	22870.0
2016-12-13	ANGL	ETF	29.07	29.07	28.94	29.04	226500.0
2016-12-13	AOA	ETF	48.0	48.18	47.91	48.06	252400.0
2016-12-13	AOK	ETF	32.67	32.7099	32.538	32.67	201163.0
2016-12-13	AOM	ETF	35.6	35.62	35.49	35.55	339934.0
2016-12-13	AOR	ETF	40.91	41.11	40.91	41.05	373261.0
2016-12-13	ARGT	ETF	23.26	23.38	23.12	23.25	257900.0
2016-12-13	ARKG	ETF	17.69	17.69	17.67	17.67	1900.0
2016-12-13	ARKK	ETF	20.56	20.56	20.534	20.55	3200.0
2016-12-13	ARKQ	ETF	22.32	22.428	22.32	22.41	2000.0
2016-12-13	ARKW	ETF	24.99	25.46	24.99	25.36	2400.0
2016-12-13	ASEA	ETF	13.46	13.5	13.4	13.49	3300.0
2016-12-13	ASET	ETF	26.05	26.05	26.04	26.04	541.0
2016-12-13	ASHR	ETF	24.62	24.69	24.61	24.63	1604100.0
2016-12-13	ASHS	ETF	32.52	32.78	32.52	32.7	9400.0
2016-12-13	ASHX	ETF	23.3211	23.3211	23.3211	23.3211	100.0
2016-12-13	ATMP	ETF	22.74	22.86	22.62	22.84	259800.0
2016-12-13	BAB	ETF	29.02	29.0636	28.93	29.05	270429.0
2016-12-13	BAL	ETF	47.65	47.65	46.92	47.36	16202.0
2016-12-13	BBC	ETF	19.12	19.299	19.035	19.05	20958.0
2016-12-13	BBH	ETF	107.3	108.64	107.3	107.92	151900.0

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

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