PREVIEW / etf_daily / 2017-07-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-12.parquet
  size:    56 KB
  rows:    1,425

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-07-12	SPY	ETF	243.3	244.2	243.3	244.01	59610400.0
2017-07-12	QQQ	ETF	140.21	140.86	139.955	140.7	36045799.0
2017-07-12	IWM	ETF	141.05	142.22	141.01	141.37	19358600.0
2017-07-12	DIA	ETF	214.98	215.7	214.89	215.23	2103300.0
2017-07-12	GLD	ETF	116.21	116.33	115.87	116.03	4654400.0
2017-07-12	TLT	ETF	123.89	124.04	123.49	123.96	7839900.0
2017-07-12	AADR	ETF	47.8	48.56	47.75	48.39	15700.0
2017-07-12	AAXJ	ETF	68.83	69.38	68.81	69.33	5801600.0
2017-07-12	ACSI	ETF	28.5896	28.6	28.58	28.58	11048.0
2017-07-12	ACTX	ETF	85.5508	86.1408	73.7507	81.1257	502.0
2017-07-12	ACWF	ETF	27.55	27.745	27.55	27.745	535.0
2017-07-12	ACWI	ETF	65.93	66.25	65.93	66.18	1509300.0
2017-07-12	ACWV	ETF	78.78	79.08	78.72	79.06	555200.0
2017-07-12	ACWX	ETF	46.03	46.26	46.03	46.21	384999.0
2017-07-12	ADRE	ETF	39.39	39.8328	39.39	39.775	7662.0
2017-07-12	AFK	ETF	22.19	22.19	21.95	22.12	7002.0
2017-07-12	AFTY	ETF	15.59	15.63	15.55	15.63	3100.0
2017-07-12	AGG	ETF	109.38	109.43	109.26	109.38	2129900.0
2017-07-12	AGGY	ETF	50.54	50.55	50.47	50.54	17800.0
2017-07-12	AGQ	ETF	31.0	31.19	30.78	30.93	112500.0
2017-07-12	AGZ	ETF	113.58	113.72	113.55	113.61	24943.0
2017-07-12	AGZD	ETF	24.0	24.005	24.0	24.005	1000.0
2017-07-12	AIA	ETF	58.53	58.785	58.48	58.74	47590.0
2017-07-12	AIQ	ETF	13.2	13.25	13.2	13.25	12388.0
2017-07-12	AIRR	ETF	23.98	24.06	23.85	23.88	28000.0
2017-07-12	AIVI	ETF	40.99	41.16	40.99	41.13	17500.0
2017-07-12	ALTY	ETF	15.523	15.523	15.461	15.52	5500.0
2017-07-12	AMJ	ETF	29.71	29.93	29.67	29.82	1429202.0
2017-07-12	AMLP	ETF	59.65	59.9	59.5	59.75	1683880.0
2017-07-12	AMZA	ETF	95.9	96.9	95.0	96.4	48320.0
2017-07-12	ANGL	ETF	29.37	29.47	29.37	29.43	283900.0
2017-07-12	AOA	ETF	51.68	51.81	51.66	51.77	39500.0
2017-07-12	AOK	ETF	33.87	33.9673	33.86	33.95	79178.0
2017-07-12	AOM	ETF	37.13	37.2	37.091	37.18	90418.0
2017-07-12	AOR	ETF	43.51	43.605	43.5	43.6	129718.0
2017-07-12	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-12	ARGT	ETF	29.95	30.15	29.95	30.12	58200.0
2017-07-12	ARKG	ETF	22.22	22.337	22.21	22.325	15500.0
2017-07-12	ARKK	ETF	29.16	29.42	29.113	29.39	49900.0
2017-07-12	ARKQ	ETF	28.9	29.147	28.9	29.14	25100.0
2017-07-12	ARKW	ETF	35.78	36.32	35.78	36.3	51800.0
2017-07-12	ASEA	ETF	15.12	15.28	15.12	15.26	54500.0
2017-07-12	ASHR	ETF	27.39	27.47	27.29	27.44	444000.0
2017-07-12	ASHS	ETF	32.98	33.05	32.98	33.05	800.0
2017-07-12	ASHX	ETF	20.8353	20.84	20.8353	20.84	264.0
2017-07-12	ATMP	ETF	22.47	22.52	22.32	22.48	31700.0
2017-07-12	BAB	ETF	30.07	30.088	30.0	30.05	130574.0
2017-07-12	BAL	ETF	44.39	44.39	44.33	44.33	699.0
2017-07-12	BBC	ETF	25.09	25.09	24.75	24.8954	7772.0
2017-07-12	BBH	ETF	126.0	126.79	126.0	126.71	22800.0

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

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