PREVIEW / etf_daily / 2016-12-09

all etf daily files

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

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-09	SPY	ETF	225.41	226.53	225.37	226.51	88005800.0
2016-12-09	QQQ	ETF	119.03	119.5402	119.0	119.5	21863133.0
2016-12-09	IWM	ETF	138.4	138.82	137.75	138.31	34313500.0
2016-12-09	DIA	ETF	196.44	197.72	196.37	197.69	4392300.0
2016-12-09	GLD	ETF	111.18	111.25	110.19	110.4	10507700.0
2016-12-09	TLT	ETF	118.64	118.86	117.28	117.5	14646400.0
2016-12-09	AADR	ETF	40.8	40.8	40.64	40.68	2900.0
2016-12-09	AAXJ	ETF	57.48	57.58	57.39	57.49	2689400.0
2016-12-09	ACSI	ETF	27.39	27.42	27.38	27.42	6562.0
2016-12-09	ACTX	ETF	18.2902	22.4202	15.3401	20.0602	1572.0
2016-12-09	ACWF	ETF	24.7572	24.96	24.7572	24.9233	372.0
2016-12-09	ACWI	ETF	60.1	60.31	60.04	60.31	1580800.0
2016-12-09	ACWV	ETF	73.07	73.35	73.07	73.31	135800.0
2016-12-09	ACWX	ETF	40.99	41.12	40.96	41.09	827393.0
2016-12-09	ADRE	ETF	33.56	33.64	33.4864	33.54	15004.0
2016-12-09	AFK	ETF	19.9	20.24	19.86	20.1313	32791.0
2016-12-09	AFTY	ETF	13.94	14.084	13.94	14.059	5600.0
2016-12-09	AGG	ETF	108.08	108.18	107.72	107.84	4530900.0
2016-12-09	AGGY	ETF	49.574	49.574	49.36	49.36	24400.0
2016-12-09	AGQ	ETF	37.09	37.17	36.0	36.24	178700.0
2016-12-09	AGZ	ETF	112.73	112.7966	112.3701	112.65	15790.0
2016-12-09	AGZD	ETF	24.005	24.005	24.005	24.005	200.0
2016-12-09	AIA	ETF	48.63	48.6494	48.51	48.61	13980.0
2016-12-09	AIQ	ETF	8.05	8.0501	7.95	7.95	11741.0
2016-12-09	AIRR	ETF	24.35	24.35	24.076	24.24	378400.0
2016-12-09	AIVI	ETF	37.6	37.89	37.6	37.85	27700.0
2016-12-09	ALTY	ETF	14.95	14.95	14.95	14.95	300.0
2016-12-09	AMJ	ETF	30.35	30.35	30.02	30.11	1690977.0
2016-12-09	AMLP	ETF	61.45	61.55	61.15	61.15	1410720.0
2016-12-09	AMZA	ETF	108.8	109.2	108.0	108.3	22120.0
2016-12-09	ANGL	ETF	29.01	29.01	28.93	28.95	245000.0
2016-12-09	AOA	ETF	47.73	47.86	47.71	47.77	136100.0
2016-12-09	AOK	ETF	32.65	32.65	32.5301	32.59	93216.0
2016-12-09	AOM	ETF	35.56	35.58	35.365	35.49	372259.0
2016-12-09	AOR	ETF	40.95	40.95	40.81	40.91	293623.0
2016-12-09	ARGT	ETF	23.13	23.35	23.1	23.14	16500.0
2016-12-09	ARKG	ETF	17.58	17.8	17.44	17.485	34500.0
2016-12-09	ARKK	ETF	20.43	20.43	20.4	20.4	7200.0
2016-12-09	ARKQ	ETF	22.325	22.33	22.277	22.277	2700.0
2016-12-09	ARKW	ETF	25.465	25.465	25.31	25.32	8100.0
2016-12-09	ASEA	ETF	13.41	13.41	13.35	13.38	1200.0
2016-12-09	ASHR	ETF	25.54	25.54	25.36	25.44	947000.0
2016-12-09	ASHS	ETF	34.15	34.21	34.05	34.21	6300.0
2016-12-09	ASHX	ETF	24.01	24.01	24.01	24.01	100.0
2016-12-09	ATMP	ETF	22.84	22.85	22.57	22.57	59600.0
2016-12-09	BAB	ETF	29.22	29.25	29.03	29.13	186504.0
2016-12-09	BAL	ETF	47.2	47.3	46.3763	46.6	10571.0
2016-12-09	BBC	ETF	19.96	20.192	19.59	19.59	15822.0
2016-12-09	BBH	ETF	107.53	109.5	107.35	107.57	132500.0
2016-12-09	BBP	ETF	35.0	35.0	33.77	33.93	45300.0

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

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