PREVIEW / etf_daily / 2017-08-02

all etf daily files

  file:    by_date/etf_daily/2017/2017-08-02.parquet
  size:    56 KB
  rows:    1,439

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-08-02	SPY	ETF	247.47	247.6	246.37	247.44	47211200.0
2017-08-02	QQQ	ETF	144.45	144.52	142.61	143.95	41769667.0
2017-08-02	IWM	ETF	141.59	141.82	139.73	140.23	19934300.0
2017-08-02	DIA	ETF	219.83	220.13	219.44	219.89	3063300.0
2017-08-02	GLD	ETF	120.51	121.02	120.34	120.4	5945300.0
2017-08-02	TLT	ETF	124.77	125.17	124.68	124.71	5745600.0
2017-08-02	AADR	ETF	49.8	49.8	49.16	49.63	17400.0
2017-08-02	AAXJ	ETF	71.47	71.47	70.87	71.22	2299800.0
2017-08-02	ACSI	ETF	29.2	29.2	29.03	29.13	11431.0
2017-08-02	ACTX	ETF	72.5707	82.6007	71.9806	80.8307	828.0
2017-08-02	ACWF	ETF	28.09	28.09	28.04	28.04	1665.0
2017-08-02	ACWI	ETF	67.79	67.79	67.26	67.54	1061500.0
2017-08-02	ACWV	ETF	80.75	80.78	80.64	80.76	1531400.0
2017-08-02	ACWX	ETF	47.42	47.5	47.31	47.48	567079.0
2017-08-02	ADRE	ETF	41.53	41.5693	41.1301	41.4992	8589.0
2017-08-02	AFK	ETF	23.1	23.1599	23.0001	23.1599	7106.0
2017-08-02	AFTY	ETF	16.365	16.43	16.365	16.43	3700.0
2017-08-02	AGG	ETF	109.71	109.77	109.64	109.64	2253300.0
2017-08-02	AGGY	ETF	50.8	50.83	50.765	50.77	30400.0
2017-08-02	AGNG	ETF	18.62	18.66	18.5	18.501	2000.0
2017-08-02	AGQ	ETF	33.49	34.07	33.28	33.35	145200.0
2017-08-02	AGZ	ETF	113.88	113.9	113.7816	113.81	8306.0
2017-08-02	AGZD	ETF	23.985	24.085	23.98	24.085	1400.0
2017-08-02	AIA	ETF	60.93	60.93	60.6	60.69	56115.0
2017-08-02	AIQ	ETF	13.15	13.2	12.9144	13.0	293755.0
2017-08-02	AIRR	ETF	24.0	24.11	23.03	23.78	98000.0
2017-08-02	AIVI	ETF	42.17	42.2	42.05	42.15	11200.0
2017-08-02	ALTY	ETF	15.68	15.697	15.68	15.685	3100.0
2017-08-02	AMJ	ETF	30.06	30.2363	30.02	30.18	667174.0
2017-08-02	AMLP	ETF	60.05	60.2	59.85	60.15	1134960.0
2017-08-02	AMZA	ETF	97.5	97.7	97.21	97.6	73720.0
2017-08-02	ANGL	ETF	29.87	29.9	29.82	29.87	132500.0
2017-08-02	AOA	ETF	52.63	52.7	52.55	52.7	26800.0
2017-08-02	AOK	ETF	34.19	34.2708	34.19	34.2	34109.0
2017-08-02	AOM	ETF	37.57	37.639	37.53	37.53	80422.0
2017-08-02	AOR	ETF	44.2	44.24	44.1299	44.24	42082.0
2017-08-02	ARCM	ETF	99.975	99.975	99.975	99.975	20.0
2017-08-02	ARGT	ETF	29.73	29.73	29.4	29.64	21000.0
2017-08-02	ARKG	ETF	22.239	22.37	21.733	22.223	11700.0
2017-08-02	ARKK	ETF	29.7	29.883	29.278	29.812	27100.0
2017-08-02	ARKQ	ETF	29.53	29.635	29.11	29.385	28100.0
2017-08-02	ARKW	ETF	37.26	37.27	36.561	36.955	30500.0
2017-08-02	ASEA	ETF	15.41	15.43	15.39	15.43	1000.0
2017-08-02	ASET	ETF	27.98	28.03	27.98	28.03	1787.0
2017-08-02	ASHR	ETF	28.4	28.41	28.31	28.38	693000.0
2017-08-02	ASHS	ETF	33.96	33.96	33.87	33.87	7300.0
2017-08-02	ASHX	ETF	21.3201	21.3204	21.3201	21.3204	300.0
2017-08-02	ATMP	ETF	22.77	22.86	22.74	22.84	91200.0
2017-08-02	BAB	ETF	30.21	30.24	30.1301	30.19	96389.0
2017-08-02	BAL	ETF	45.9359	46.4828	45.9359	46.3701	7248.0

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

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