PREVIEW / etf_daily / 2017-11-17

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-17.parquet
  size:    58 KB
  rows:    1,501

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-11-17	SPY	ETF	258.22	258.59	257.77	257.86	75756800.0
2017-11-17	QQQ	ETF	154.58	154.69	153.8	153.95	28725800.0
2017-11-17	IWM	ETF	147.25	149.03	147.17	148.45	25816700.0
2017-11-17	DIA	ETF	233.77	233.97	233.36	233.39	3483300.0
2017-11-17	GLD	ETF	122.15	123.17	121.95	122.86	10614000.0
2017-11-17	TLT	ETF	126.07	126.44	125.96	126.39	6938800.0
2017-11-17	AADR	ETF	56.96	57.15	56.85	56.93	55900.0
2017-11-17	AAXJ	ETF	76.67	76.92	76.66	76.7	781500.0
2017-11-17	ACSI	ETF	29.8257	29.8452	29.791	29.791	1835.0
2017-11-17	ACTX	ETF	50.1505	51.3305	47.7904	49.3834	374.0
2017-11-17	ACWF	ETF	30.15	30.22	30.15	30.1681	5694.0
2017-11-17	ACWI	ETF	70.33	70.47	70.31	70.38	591100.0
2017-11-17	ACWV	ETF	83.1	83.18	82.95	82.96	66000.0
2017-11-17	ACWX	ETF	49.13	49.25	49.07	49.18	458245.0
2017-11-17	ADRE	ETF	42.95	43.33	42.95	43.22	30574.0
2017-11-17	AFK	ETF	23.52	23.85	23.52	23.81	7023.0
2017-11-17	AFTY	ETF	18.88	18.88	18.75	18.768	13900.0
2017-11-17	AGG	ETF	109.33	109.39	109.26	109.31	3544600.0
2017-11-17	AGGY	ETF	50.59	50.69	50.57	50.6	43400.0
2017-11-17	AGNG	ETF	19.46	19.56	19.35	19.55	2200.0
2017-11-17	AGQ	ETF	34.7	35.88	34.59	35.47	143400.0
2017-11-17	AGZ	ETF	113.42	113.472	113.36	113.39	5942.0
2017-11-17	AGZD	ETF	24.1	24.125	24.06	24.115	16800.0
2017-11-17	AIA	ETF	66.33	66.685	66.33	66.565	122118.0
2017-11-17	AIEQ	ETF	24.55	24.75	24.527	24.72	46100.0
2017-11-17	AIRR	ETF	25.505	25.71	25.47	25.63	8600.0
2017-11-17	AIVI	ETF	42.54	42.56	42.47	42.53	3800.0
2017-11-17	ALTY	ETF	15.315	15.42	15.315	15.42	8800.0
2017-11-17	AMJ	ETF	26.5	26.65	26.29	26.5	4703788.0
2017-11-17	AMLP	ETF	51.2	51.4	50.8	51.35	3175420.0
2017-11-17	AMZA	ETF	80.0	80.49	79.3	80.2	75640.0
2017-11-17	ANGL	ETF	29.85	29.91	29.83	29.87	182700.0
2017-11-17	AOA	ETF	54.4	54.45	54.33	54.38	46500.0
2017-11-17	AOK	ETF	34.64	34.66	34.58	34.65	60747.0
2017-11-17	AOM	ETF	38.23	38.24	38.13	38.2	93626.0
2017-11-17	AOR	ETF	45.3	45.34	45.24	45.25	106340.0
2017-11-17	ARGT	ETF	31.82	32.0	31.73	31.97	48000.0
2017-11-17	ARKG	ETF	24.63	24.709	24.348	24.65	33500.0
2017-11-17	ARKK	ETF	35.47	35.64	35.32	35.48	174700.0
2017-11-17	ARKQ	ETF	33.43	33.59	33.41	33.51	25300.0
2017-11-17	ARKW	ETF	43.84	44.199	43.84	44.07	109300.0
2017-11-17	ASEA	ETF	16.3	16.3	16.19	16.19	1400.0
2017-11-17	ASET	ETF	28.159	28.16	28.1483	28.15	2817.0
2017-11-17	ASHR	ETF	31.43	31.46	31.38	31.38	282100.0
2017-11-17	ASHS	ETF	35.38	35.38	34.79	34.9	62900.0
2017-11-17	ASHX	ETF	23.27	23.27	23.27	23.27	200.0
2017-11-17	ATMP	ETF	19.88	19.99	19.77	19.95	196100.0
2017-11-17	BAB	ETF	30.62	30.6699	30.48	30.5	93413.0
2017-11-17	BAL	ETF	45.84	45.85	45.5972	45.74	1519.0
2017-11-17	BAR	ETF	12.888	12.928	12.888	12.928	35530.0

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

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