PREVIEW / etf_daily / 2017-11-08

all etf daily files

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

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-08	SPY	ETF	258.47	259.22	258.15	259.11	50469600.0
2017-11-08	QQQ	ETF	153.81	154.54	153.62	154.5	17373517.0
2017-11-08	IWM	ETF	146.66	147.45	145.84	147.2	30682500.0
2017-11-08	DIA	ETF	235.37	235.61	234.97	235.46	1531900.0
2017-11-08	GLD	ETF	121.95	122.25	121.59	121.63	5565200.0
2017-11-08	TLT	ETF	126.59	126.8	126.21	126.36	3356200.0
2017-11-08	AADR	ETF	57.31	57.55	57.22	57.49	71800.0
2017-11-08	AAXJ	ETF	76.37	76.59	76.29	76.57	681100.0
2017-11-08	ACSI	ETF	29.489	29.53	29.4328	29.53	3975.0
2017-11-08	ACTX	ETF	41.3004	53.1005	38.9404	50.0914	960.0
2017-11-08	ACWF	ETF	30.21	30.21	30.05	30.21	7877.0
2017-11-08	ACWI	ETF	70.71	70.87	70.61	70.84	536900.0
2017-11-08	ACWV	ETF	82.92	83.14	82.92	83.07	154600.0
2017-11-08	ACWX	ETF	49.55	49.6699	49.49	49.61	418877.0
2017-11-08	ADRE	ETF	43.26	43.4928	43.26	43.4357	2602.0
2017-11-08	AFK	ETF	23.72	23.9	23.711	23.9	5662.0
2017-11-08	AFTY	ETF	18.037	18.07	18.037	18.07	4000.0
2017-11-08	AGG	ETF	109.54	109.6	109.46	109.51	2742600.0
2017-11-08	AGGY	ETF	50.77	50.82	50.762	50.769	64200.0
2017-11-08	AGNG	ETF	19.46	19.46	19.35	19.395	2100.0
2017-11-08	AGQ	ETF	34.78	35.39	34.41	34.42	83900.0
2017-11-08	AGZ	ETF	113.65	113.65	113.56	113.59	8907.0
2017-11-08	AGZD	ETF	24.145	24.145	24.09	24.145	6200.0
2017-11-08	AIA	ETF	66.04	66.18	65.93	66.15	80855.0
2017-11-08	AIEQ	ETF	24.39	24.6	24.32	24.56	150300.0
2017-11-08	AIRR	ETF	26.29	26.29	25.925	26.16	42100.0
2017-11-08	AIVI	ETF	43.48	43.61	43.47	43.61	7600.0
2017-11-08	ALTY	ETF	15.448	15.5	15.448	15.492	900.0
2017-11-08	AMJ	ETF	27.73	27.8	27.34	27.39	2246209.0
2017-11-08	AMLP	ETF	54.85	55.1	54.1	54.2	2107900.0
2017-11-08	AMZA	ETF	84.9	85.5	83.5	84.1	64910.0
2017-11-08	ANGL	ETF	30.13	30.13	29.95	29.96	1559800.0
2017-11-08	AOA	ETF	54.58	54.7	54.55	54.64	53100.0
2017-11-08	AOK	ETF	34.74	34.7699	34.689	34.69	114934.0
2017-11-08	AOM	ETF	38.32	38.3595	38.23	38.35	155302.0
2017-11-08	AOR	ETF	45.47	45.52	45.4068	45.52	58920.0
2017-11-08	ARCM	ETF	100.08	100.08	100.08	100.08	20000.0
2017-11-08	ARGT	ETF	32.78	32.89	32.63	32.71	103400.0
2017-11-08	ARKG	ETF	24.66	24.73	24.5	24.67	91400.0
2017-11-08	ARKK	ETF	34.82	34.981	34.61	34.93	122000.0
2017-11-08	ARKQ	ETF	33.49	33.49	33.151	33.45	21100.0
2017-11-08	ARKW	ETF	43.17	43.49	43.08	43.43	60200.0
2017-11-08	ASEA	ETF	15.96	16.02	15.96	16.02	900.0
2017-11-08	ASET	ETF	28.4283	28.469	28.4283	28.469	603.0
2017-11-08	ASHR	ETF	30.92	30.92	30.76	30.86	468100.0
2017-11-08	ASHS	ETF	36.05	36.06	35.88	35.88	9000.0
2017-11-08	ASHX	ETF	22.797	22.797	22.797	22.797	399.0
2017-11-08	ATMP	ETF	20.7	20.9	20.63	20.72	54000.0
2017-11-08	BAB	ETF	30.61	30.6999	30.52	30.54	269230.0
2017-11-08	BAL	ETF	45.19	45.295	45.19	45.295	2309.0

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

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