PREVIEW / etf_daily / 2017-07-20

all etf daily files

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

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-20	SPY	ETF	247.28	247.42	246.47	247.1	47135200.0
2017-07-20	QQQ	ETF	144.31	144.44	143.52	144.17	36139449.0
2017-07-20	IWM	ETF	143.12	143.52	142.8	143.2	17047800.0
2017-07-20	DIA	ETF	216.57	216.58	215.71	216.19	1372000.0
2017-07-20	GLD	ETF	117.92	118.62	117.66	118.24	5571600.0
2017-07-20	TLT	ETF	125.49	125.73	124.97	125.16	12239100.0
2017-07-20	AADR	ETF	49.27	49.57	49.2	49.33	7000.0
2017-07-20	AAXJ	ETF	70.57	70.62	70.39	70.51	450400.0
2017-07-20	ACSI	ETF	28.9218	29.0	28.9218	29.0	13465.0
2017-07-20	ACTX	ETF	76.7007	80.8307	76.7007	80.2407	198.0
2017-07-20	ACWF	ETF	28.13	28.16	28.1	28.16	915.0
2017-07-20	ACWI	ETF	67.25	67.28	67.06	67.2	1669500.0
2017-07-20	ACWV	ETF	79.88	80.14	79.83	80.07	141600.0
2017-07-20	ACWX	ETF	47.07	47.12	46.96	47.08	1047098.0
2017-07-20	ADRE	ETF	40.75	40.75	40.6005	40.6005	6185.0
2017-07-20	AFK	ETF	22.8	22.8054	22.8	22.8001	2392.0
2017-07-20	AFTY	ETF	16.27	16.27	16.21	16.22	5300.0
2017-07-20	AGG	ETF	109.85	109.88	109.7	109.73	1802600.0
2017-07-20	AGGY	ETF	50.86	50.87	50.76	50.8	18400.0
2017-07-20	AGNG	ETF	19.278	19.278	19.14	19.225	800.0
2017-07-20	AGQ	ETF	32.35	32.81	31.86	32.4	174200.0
2017-07-20	AGZ	ETF	113.82	113.9396	113.7835	113.82	7741.0
2017-07-20	AGZD	ETF	24.025	24.055	24.005	24.025	7200.0
2017-07-20	AIA	ETF	60.12	60.12	59.84	59.98	27867.0
2017-07-20	AIQ	ETF	13.2	13.3	13.2	13.25	46453.0
2017-07-20	AIRR	ETF	24.08	24.11	23.95	24.02	18600.0
2017-07-20	AIVI	ETF	41.81	41.97	41.81	41.93	10500.0
2017-07-20	ALTY	ETF	15.75	15.75	15.59	15.654	1600.0
2017-07-20	AMJ	ETF	30.33	30.35	29.95	29.99	1092590.0
2017-07-20	AMLP	ETF	60.55	60.55	59.75	59.75	2108700.0
2017-07-20	AMZA	ETF	98.2	98.3	97.0	97.3	71010.0
2017-07-20	ANGL	ETF	29.83	29.83	29.77	29.78	216400.0
2017-07-20	AOA	ETF	52.46	52.55	52.36	52.41	25100.0
2017-07-20	AOK	ETF	34.2	34.24	34.1332	34.22	29341.0
2017-07-20	AOM	ETF	37.48	37.55	37.4407	37.49	35482.0
2017-07-20	AOR	ETF	44.04	44.12	44.0264	44.06	78979.0
2017-07-20	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-20	ARGT	ETF	29.79	29.99	29.76	29.87	205100.0
2017-07-20	ARKG	ETF	22.19	22.509	22.19	22.375	13100.0
2017-07-20	ARKK	ETF	29.45	29.76	29.45	29.73	47300.0
2017-07-20	ARKQ	ETF	29.39	29.39	29.22	29.36	17600.0
2017-07-20	ARKW	ETF	36.86	37.13	36.825	37.05	35100.0
2017-07-20	ASEA	ETF	15.21	15.27	15.21	15.25	3600.0
2017-07-20	ASET	ETF	27.765	27.765	27.765	27.765	117.0
2017-07-20	ASHR	ETF	28.06	28.1	28.0	28.07	513600.0
2017-07-20	ASHS	ETF	32.89	32.91	32.87	32.87	4600.0
2017-07-20	ASHX	ETF	21.19	21.2295	21.18	21.2295	1600.0
2017-07-20	ATMP	ETF	22.95	22.95	22.71	22.74	113800.0
2017-07-20	BAB	ETF	30.09	30.1245	30.0	30.02	129365.0
2017-07-20	BAL	ETF	45.38	45.62	45.29	45.55	6991.0

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

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