PREVIEW / etf_daily / 2017-06-20

all etf daily files

  file:    by_date/etf_daily/2017/2017-06-20.parquet
  size:    56 KB
  rows:    1,417

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-20	SPY	ETF	244.25	244.26	242.99	243.01	56906400.0
2017-06-20	QQQ	ETF	140.31	140.5	139.31	139.36	40935078.0
2017-06-20	IWM	ETF	140.88	140.97	139.7	139.8	20111900.0
2017-06-20	DIA	ETF	214.89	215.07	214.37	214.4	1762100.0
2017-06-20	GLD	ETF	118.42	118.46	118.07	118.18	4617400.0
2017-06-20	TLT	ETF	126.79	127.4	126.79	127.3	8405700.0
2017-06-20	AADR	ETF	47.34	47.34	46.68	46.7	16300.0
2017-06-20	AAXJ	ETF	67.5	67.59	67.18	67.23	887800.0
2017-06-20	ACSI	ETF	28.92	28.93	28.81	28.81	9673.0
2017-06-20	ACTX	ETF	97.3509	101.4809	89.6808	100.3009	536.0
2017-06-20	ACWF	ETF	27.18	27.19	27.18	27.1852	1021.0
2017-06-20	ACWI	ETF	65.86	65.86	65.41	65.41	2155100.0
2017-06-20	ACWV	ETF	80.19	80.3	79.9	79.96	194700.0
2017-06-20	ACWX	ETF	45.61	45.61	45.25	45.29	231266.0
2017-06-20	ADRE	ETF	38.33	38.33	37.88	38.04	6782.0
2017-06-20	AFK	ETF	21.655	21.655	21.55	21.55	8405.0
2017-06-20	AFTY	ETF	14.98	14.98	14.76	14.76	1800.0
2017-06-20	AGG	ETF	109.85	110.03	109.8	109.96	2195100.0
2017-06-20	AGGY	ETF	50.81	50.83	50.81	50.83	8800.0
2017-06-20	AGNG	ETF	18.874	18.874	18.85	18.85	21200.0
2017-06-20	AGQ	ETF	33.29	33.46	33.0	33.26	124400.0
2017-06-20	AGZ	ETF	113.94	113.99	113.7704	113.95	16962.0
2017-06-20	AGZD	ETF	23.985	23.99	23.965	23.98	5200.0
2017-06-20	AIA	ETF	57.45	57.45	57.0	57.03	49548.0
2017-06-20	AIQ	ETF	13.4	13.4	13.25	13.3	5454.0
2017-06-20	AIRR	ETF	23.76	23.76	23.488	23.49	38700.0
2017-06-20	AIVI	ETF	41.58	41.58	41.3	41.38	33600.0
2017-06-20	ALTY	ETF	15.57	15.57	15.535	15.55	4900.0
2017-06-20	AMJ	ETF	28.24	28.41	27.59	27.82	3232626.0
2017-06-20	AMLP	ETF	56.95	56.95	55.25	55.85	4274300.0
2017-06-20	AMZA	ETF	93.9	93.9	90.0	91.3	200060.0
2017-06-20	ANGL	ETF	29.59	29.63	29.54	29.55	862500.0
2017-06-20	AOA	ETF	52.08	52.08	51.76	51.76	52700.0
2017-06-20	AOK	ETF	34.15	34.1528	34.05	34.11	63787.0
2017-06-20	AOM	ETF	37.39	37.5099	37.31	37.39	79659.0
2017-06-20	AOR	ETF	43.88	43.89	43.71	43.75	74491.0
2017-06-20	ARCM	ETF	100.3	100.35	100.3	100.35	60.0
2017-06-20	ARGT	ETF	29.9	29.95	29.53	29.77	246600.0
2017-06-20	ARKG	ETF	21.87	22.333	21.797	21.86	39300.0
2017-06-20	ARKK	ETF	29.44	29.66	29.283	29.35	85600.0
2017-06-20	ARKQ	ETF	29.28	29.28	28.82	28.84	26700.0
2017-06-20	ARKW	ETF	35.96	36.073	35.73	35.8	40800.0
2017-06-20	ASEA	ETF	15.08	15.08	15.04	15.04	1000.0
2017-06-20	ASET	ETF	27.56	27.59	27.555	27.56	1103.0
2017-06-20	ASHR	ETF	26.18	26.21	26.04	26.09	2297800.0
2017-06-20	ASHS	ETF	32.37	32.39	32.26	32.31	16800.0
2017-06-20	ASHX	ETF	20.05	20.05	19.98	20.02	1000.0
2017-06-20	ATMP	ETF	21.3	21.3	20.84	20.94	98100.0
2017-06-20	BAB	ETF	30.08	30.1	30.025	30.05	93886.0
2017-06-20	BAL	ETF	45.21	45.5	45.13	45.34	4938.0

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

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