PREVIEW / etf_daily / 2017-03-31

all etf daily files

  file:    by_date/etf_daily/2017/2017-03-31.parquet
  size:    54 KB
  rows:    1,370

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-03-31	SPY	ETF	235.9	236.51	235.68	235.74	73733100.0
2017-03-31	QQQ	ETF	132.27	132.74	132.125	132.38	19841411.0
2017-03-31	IWM	ETF	137.42	138.17	136.94	137.48	29434300.0
2017-03-31	DIA	ETF	206.72	206.93	206.3	206.34	4179600.0
2017-03-31	GLD	ETF	118.61	119.08	118.46	118.72	8520800.0
2017-03-31	TLT	ETF	120.28	120.81	120.21	120.71	5144800.0
2017-03-31	AADR	ETF	46.47	46.78	46.33	46.71	7400.0
2017-03-31	AAXJ	ETF	63.03	63.09	62.91	62.94	295700.0
2017-03-31	ACSI	ETF	28.02	28.04	28.02	28.04	315.0
2017-03-31	ACTX	ETF	119.4761	128.0312	109.151	114.461	1908.0
2017-03-31	ACWI	ETF	63.24	63.47	63.24	63.26	2063400.0
2017-03-31	ACWV	ETF	77.16	77.33	77.1	77.13	152800.0
2017-03-31	ACWX	ETF	43.56	43.73	43.54	43.62	915769.0
2017-03-31	ADRE	ETF	36.6099	36.7669	36.51	36.7669	2068.0
2017-03-31	AFK	ETF	20.8	20.88	20.7	20.88	2652.0
2017-03-31	AFTY	ETF	13.8	13.845	13.8	13.845	500.0
2017-03-31	AGG	ETF	108.44	108.53	108.42	108.49	3717700.0
2017-03-31	AGGY	ETF	49.8	49.82	49.751	49.82	2300.0
2017-03-31	AGQ	ETF	41.23	41.47	41.11	41.23	194100.0
2017-03-31	AGZ	ETF	113.0472	113.16	113.03	113.05	19454.0
2017-03-31	AGZD	ETF	24.06	24.06	24.06	24.06	400.0
2017-03-31	AIA	ETF	52.69	52.69	52.51	52.51	32533.0
2017-03-31	AIQ	ETF	10.3054	10.4	10.25	10.25	10031.0
2017-03-31	AIRR	ETF	23.62	23.991	23.62	23.92	59500.0
2017-03-31	AIVI	ETF	39.58	39.85	39.58	39.77	11800.0
2017-03-31	ALTY	ETF	15.589	15.589	15.589	15.589	1700.0
2017-03-31	AMJ	ETF	31.83	32.35	31.76	32.3	933516.0
2017-03-31	AMLP	ETF	63.1	63.75	63.0	63.55	1014360.0
2017-03-31	AMZA	ETF	110.6	111.8	110.3	111.8	81850.0
2017-03-31	ANGL	ETF	29.59	29.64	29.46	29.56	303700.0
2017-03-31	AOA	ETF	49.91	50.05	49.86	49.94	35100.0
2017-03-31	AOK	ETF	33.31	33.33	33.24	33.33	21518.0
2017-03-31	AOM	ETF	36.35	36.43	36.35	36.35	128780.0
2017-03-31	AOR	ETF	42.4	42.44	42.305	42.39	74628.0
2017-03-31	ARCM	ETF	99.75	100.5	99.75	100.1	42040.0
2017-03-31	ARGT	ETF	28.28	28.35	28.18	28.25	52700.0
2017-03-31	ARKG	ETF	20.57	20.7	20.521	20.68	1300.0
2017-03-31	ARKK	ETF	23.91	23.982	23.83	23.96	3500.0
2017-03-31	ARKQ	ETF	24.67	24.72	24.586	24.67	17600.0
2017-03-31	ARKW	ETF	28.61	28.91	28.61	28.91	1400.0
2017-03-31	ASEA	ETF	14.15	14.16	14.08	14.14	14200.0
2017-03-31	ASET	ETF	26.46	26.55	26.4398	26.52	2281.0
2017-03-31	ASHR	ETF	25.04	25.15	25.04	25.13	577500.0
2017-03-31	ASHS	ETF	33.6	33.81	33.6	33.76	29800.0
2017-03-31	ASHX	ETF	19.52	19.52	19.5012	19.5012	288.0
2017-03-31	ATMP	ETF	23.52	23.89	23.52	23.89	22100.0
2017-03-31	BAB	ETF	29.38	29.4251	29.3001	29.36	91530.0
2017-03-31	BAL	ETF	49.49	50.31	49.28	50.17	9736.0
2017-03-31	BBC	ETF	23.31	23.33	23.0947	23.19	5888.0
2017-03-31	BBH	ETF	119.17	119.59	118.8	119.05	48700.0

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

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