PREVIEW / etf_daily / 2017-06-16

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-16.parquet
  size:    54 KB
  rows:    1,382

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
2017-06-16	SPY	ETF	242.77	242.83	241.63	242.64	84553100.0
2017-06-16	QQQ	ETF	138.72	138.777	137.638	138.15	48087413.0
2017-06-16	IWM	ETF	140.03	140.22	139.28	140.19	35608400.0
2017-06-16	DIA	ETF	213.33	213.58	212.82	213.56	2372000.0
2017-06-16	GLD	ETF	119.35	119.5	119.24	119.34	6435700.0
2017-06-16	TLT	ETF	126.08	126.44	126.01	126.35	6672500.0
2017-06-16	AADR	ETF	46.57	46.72	46.38	46.72	6700.0
2017-06-16	AAXJ	ETF	67.22	67.22	66.89	67.18	650700.0
2017-06-16	ACSI	ETF	28.81	28.87	28.8	28.87	10910.0
2017-06-16	ACTX	ETF	83.4857	93.8108	79.6507	89.5628	485.0
2017-06-16	ACWI	ETF	66.16	66.27	65.96	66.27	1534700.0
2017-06-16	ACWV	ETF	80.75	80.89	80.56	80.89	146400.0
2017-06-16	ACWX	ETF	46.01	46.16	45.9	46.16	249054.0
2017-06-16	ADRE	ETF	38.02	38.02	37.77	37.81	10971.0
2017-06-16	AFK	ETF	21.96	21.96	21.65	21.74	4705.0
2017-06-16	AFTY	ETF	14.73	14.75	14.72	14.72	1600.0
2017-06-16	AGG	ETF	109.86	109.97	109.85	109.94	2216600.0
2017-06-16	AGGY	ETF	50.82	50.822	50.75	50.813	25000.0
2017-06-16	AGNG	ETF	18.45	18.51	18.45	18.51	200.0
2017-06-16	AGQ	ETF	34.25	34.28	34.03	34.18	169500.0
2017-06-16	AGZ	ETF	113.92	114.5107	113.74	113.98	9795.0
2017-06-16	AGZD	ETF	23.975	23.98	23.955	23.97	10400.0
2017-06-16	AIA	ETF	56.66	56.66	56.37	56.63	32977.0
2017-06-16	AIQ	ETF	13.2	13.275	13.2	13.25	17547.0
2017-06-16	AIRR	ETF	23.71	23.72	23.57	23.65	16800.0
2017-06-16	AIVI	ETF	41.56	41.74	41.55	41.71	3700.0
2017-06-16	ALTY	ETF	15.58	15.58	15.518	15.518	1500.0
2017-06-16	AMJ	ETF	28.56	28.89	28.43	28.87	1338327.0
2017-06-16	AMLP	ETF	57.25	58.1	57.1	57.9	1746940.0
2017-06-16	AMZA	ETF	93.7	95.7	93.57	95.4	54010.0
2017-06-16	ANGL	ETF	29.65	29.65	29.56	29.58	213500.0
2017-06-16	AOA	ETF	51.83	51.9	51.69	51.9	26800.0
2017-06-16	AOK	ETF	34.06	34.1	34.045	34.1	104893.0
2017-06-16	AOM	ETF	37.38	37.39	37.27	37.39	63590.0
2017-06-16	AOR	ETF	43.69	43.75	43.64	43.71	59997.0
2017-06-16	ARCM	ETF	100.245	100.245	100.245	100.245	20.0
2017-06-16	ARGT	ETF	29.18	29.3	29.07	29.29	60100.0
2017-06-16	ARKG	ETF	21.01	21.15	20.93	21.12	13700.0
2017-06-16	ARKK	ETF	28.3	28.649	28.3	28.529	23600.0
2017-06-16	ARKQ	ETF	28.74	28.78	28.557	28.557	32700.0
2017-06-16	ARKW	ETF	34.81	35.18	34.81	35.12	66700.0
2017-06-16	ASEA	ETF	15.13	15.13	15.01	15.08	3000.0
2017-06-16	ASET	ETF	27.74	27.88	27.74	27.88	3053.0
2017-06-16	ASHR	ETF	25.96	26.01	25.86	25.97	452900.0
2017-06-16	ASHS	ETF	32.11	32.17	32.07	32.17	4400.0
2017-06-16	ATMP	ETF	21.4	21.71	21.34	21.71	71900.0
2017-06-16	BAB	ETF	29.95	30.07	29.95	30.0	97484.0
2017-06-16	BAL	ETF	45.58	45.88	45.29	45.75	19991.0
2017-06-16	BBC	ETF	22.14	22.2499	22.14	22.2401	2690.0
2017-06-16	BBH	ETF	121.15	121.52	119.85	120.25	167000.0

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

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