PREVIEW / etf_daily / 2017-10-13

all etf daily files

  file:    by_date/etf_daily/2017/2017-10-13.parquet
  size:    58 KB
  rows:    1,477

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-10-13	SPY	ETF	255.14	255.27	254.64	254.95	54800400.0
2017-10-13	QQQ	ETF	148.4	148.51	147.7772	148.34	18409888.0
2017-10-13	IWM	ETF	149.92	149.99	149.23	149.37	15464400.0
2017-10-13	DIA	ETF	228.71	228.97	228.51	228.73	1744300.0
2017-10-13	GLD	ETF	123.66	123.86	123.34	123.82	6820300.0
2017-10-13	TLT	ETF	125.58	125.94	125.17	125.85	7746900.0
2017-10-13	AADR	ETF	57.35	57.4	57.2	57.3	46000.0
2017-10-13	AAXJ	ETF	74.99	75.37	74.99	75.24	394500.0
2017-10-13	ACSI	ETF	29.4899	29.4899	29.45	29.45	1994.0
2017-10-13	ACTX	ETF	59.0005	60.1805	54.2805	59.0005	243.0
2017-10-13	ACWF	ETF	29.85	29.85	29.8324	29.8324	1910.0
2017-10-13	ACWI	ETF	70.0	70.07	69.96	70.0	650200.0
2017-10-13	ACWV	ETF	82.82	82.85	82.66	82.66	126100.0
2017-10-13	ACWX	ETF	49.34	49.4	49.32	49.35	314110.0
2017-10-13	ADRE	ETF	43.53	43.5692	43.37	43.455	3800.0
2017-10-13	AFK	ETF	24.0	24.1	23.85	23.95	6792.0
2017-10-13	AFTY	ETF	17.55	17.55	17.44	17.44	5900.0
2017-10-13	AGG	ETF	109.82	109.87	109.69	109.86	1743800.0
2017-10-13	AGGY	ETF	50.9	50.92	50.78	50.92	13900.0
2017-10-13	AGNG	ETF	19.65	19.73	19.48	19.5	126900.0
2017-10-13	AGQ	ETF	35.86	36.12	35.69	36.08	85300.0
2017-10-13	AGZ	ETF	113.75	113.75	113.6301	113.73	11714.0
2017-10-13	AGZD	ETF	24.155	24.155	24.055	24.055	5400.0
2017-10-13	AIA	ETF	64.09	64.16	63.88	64.02	42700.0
2017-10-13	AIRR	ETF	26.201	26.23	26.06	26.111	16200.0
2017-10-13	AIVI	ETF	43.15	43.23	43.08	43.1	12900.0
2017-10-13	ALTY	ETF	15.95	15.95	15.73	15.76	3700.0
2017-10-13	AMJ	ETF	28.49	28.58	28.11	28.15	1963576.0
2017-10-13	AMLP	ETF	56.8	57.0	55.8	55.9	1251520.0
2017-10-13	AMUB	ETF	17.95	17.95	17.95	17.95	450.0
2017-10-13	AMZA	ETF	90.0	90.0	88.1	88.4	170380.0
2017-10-13	ANGL	ETF	30.25	30.25	30.2	30.24	203000.0
2017-10-13	AOA	ETF	54.27	54.41	54.16	54.25	63600.0
2017-10-13	AOK	ETF	34.69	34.71	34.62	34.71	52430.0
2017-10-13	AOM	ETF	38.15	38.2	38.09	38.12	123375.0
2017-10-13	AOR	ETF	45.25	45.25	45.19	45.21	146437.0
2017-10-13	ARGT	ETF	32.03	32.04	31.8	31.9	65400.0
2017-10-13	ARKG	ETF	26.78	26.78	26.3	26.396	30900.0
2017-10-13	ARKK	ETF	35.14	35.14	34.65	34.785	82700.0
2017-10-13	ARKQ	ETF	32.91	32.91	32.52	32.69	31900.0
2017-10-13	ARKW	ETF	41.91	41.919	41.67	41.71	66500.0
2017-10-13	ASEA	ETF	15.93	16.0	15.93	15.98	1800.0
2017-10-13	ASET	ETF	28.45	28.45	28.4	28.4162	7248.0
2017-10-13	ASHR	ETF	30.34	30.41	30.34	30.39	555300.0
2017-10-13	ASHS	ETF	37.13	37.38	37.13	37.38	5100.0
2017-10-13	ATMP	ETF	21.76	21.76	21.32	21.35	37200.0
2017-10-13	BAB	ETF	30.6	30.62	30.51	30.61	143061.0
2017-10-13	BAL	ETF	44.85	45.4	44.85	45.4	5038.0
2017-10-13	BAR	ETF	12.991	13.011	12.991	13.011	15180.0
2017-10-13	BBC	ETF	29.7	29.7	28.9301	28.945	15657.0

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

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