PREVIEW / etf_daily / 2017-03-17

all etf daily files

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

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-17	SPY	ETF	237.75	237.97	237.03	237.03	89002100.0
2017-03-17	QQQ	ETF	131.86	132.04	131.62	131.69	21234529.0
2017-03-17	IWM	ETF	138.14	138.73	137.31	138.46	33324600.0
2017-03-17	DIA	ETF	209.53	209.53	208.83	208.86	2873200.0
2017-03-17	GLD	ETF	117.04	117.27	116.91	116.99	4683000.0
2017-03-17	TLT	ETF	118.11	118.75	118.03	118.64	7266800.0
2017-03-17	AADR	ETF	46.33	46.49	45.97	45.99	50000.0
2017-03-17	AAXJ	ETF	62.92	63.04	62.86	62.94	3716500.0
2017-03-17	ACSI	ETF	28.1079	28.1199	28.1079	28.1199	1272.0
2017-03-17	ACTX	ETF	105.6109	106.201	98.8849	106.201	857.0
2017-03-17	ACWF	ETF	25.8801	25.9884	25.88	25.9884	3516.0
2017-03-17	ACWI	ETF	63.62	63.72	63.48	63.51	1595400.0
2017-03-17	ACWV	ETF	77.37	77.61	77.32	77.48	55100.0
2017-03-17	ACWX	ETF	43.63	43.67	43.51	43.57	419388.0
2017-03-17	ADRE	ETF	36.56	36.67	36.54	36.5444	13831.0
2017-03-17	AFK	ETF	21.31	21.31	21.03	21.17	9728.0
2017-03-17	AFTY	ETF	13.75	13.769	13.72	13.72	13100.0
2017-03-17	AGG	ETF	107.72	107.91	107.69	107.89	2368800.0
2017-03-17	AGGY	ETF	49.48	49.55	49.43	49.513	7500.0
2017-03-17	AGQ	ETF	37.47	37.8	37.42	37.64	102200.0
2017-03-17	AGZ	ETF	112.56	112.7799	112.43	112.53	24268.0
2017-03-17	AGZD	ETF	24.07	24.075	24.04	24.075	9600.0
2017-03-17	AIA	ETF	52.66	52.72	52.5797	52.65	15546.0
2017-03-17	AIQ	ETF	10.1	10.3	10.05	10.2	15358.0
2017-03-17	AIRR	ETF	23.9	23.968	23.74	23.94	110900.0
2017-03-17	AIVI	ETF	39.63	39.87	39.61	39.81	20800.0
2017-03-17	ALTY	ETF	15.42	15.42	14.983	15.41	6800.0
2017-03-17	AMJ	ETF	32.1	32.1	31.72	31.77	2224684.0
2017-03-17	AMLP	ETF	63.5	63.65	62.85	63.0	1359800.0
2017-03-17	AMZA	ETF	110.8	111.02	109.53	109.7	67610.0
2017-03-17	ANGL	ETF	29.24	29.26	29.18	29.21	938100.0
2017-03-17	AOA	ETF	50.0	50.08	49.92	49.99	49900.0
2017-03-17	AOK	ETF	33.17	33.21	33.15	33.19	19773.0
2017-03-17	AOM	ETF	36.24	36.34	36.24	36.3	76347.0
2017-03-17	AOR	ETF	42.36	42.4099	42.3	42.37	66186.0
2017-03-17	ARGT	ETF	27.59	27.7	27.46	27.48	46000.0
2017-03-17	ARKG	ETF	20.75	20.75	20.559	20.62	4700.0
2017-03-17	ARKK	ETF	23.7	23.81	23.7	23.713	2200.0
2017-03-17	ARKQ	ETF	24.3	24.45	24.3	24.436	3900.0
2017-03-17	ARKW	ETF	28.87	28.98	28.827	28.84	8100.0
2017-03-17	ASEA	ETF	14.0	14.0	13.96	13.96	3200.0
2017-03-17	ASET	ETF	26.3355	26.4198	26.3355	26.38	730.0
2017-03-17	ASHR	ETF	25.05	25.05	24.96	24.96	571800.0
2017-03-17	ASHS	ETF	34.09	34.16	34.09	34.15	3700.0
2017-03-17	ASHX	ETF	19.51	19.51	19.51	19.51	320.0
2017-03-17	ATMP	ETF	23.57	23.59	23.37	23.41	77000.0
2017-03-17	BAB	ETF	29.07	29.1599	29.07	29.12	107030.0
2017-03-17	BAL	ETF	50.8602	51.026	50.8602	50.97	5045.0
2017-03-17	BBC	ETF	23.73	23.73	23.0687	23.53	24923.0
2017-03-17	BBH	ETF	119.99	120.47	118.92	119.4	40900.0

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

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