PREVIEW / etf_daily / 2017-11-15

all etf daily files

  file:    by_date/etf_daily/2017/2017-11-15.parquet
  size:    59 KB
  rows:    1,517

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-15	SPY	ETF	256.62	257.22	255.63	256.44	80811500.0
2017-11-15	QQQ	ETF	152.61	153.0	151.78	152.59	24808004.0
2017-11-15	IWM	ETF	145.35	146.21	144.5	145.63	23925200.0
2017-11-15	DIA	ETF	233.16	233.67	232.65	232.96	2823600.0
2017-11-15	GLD	ETF	122.13	122.36	121.25	121.41	4984800.0
2017-11-15	TLT	ETF	126.06	126.67	125.64	126.56	9568200.0
2017-11-15	AADR	ETF	54.86	55.74	54.21	55.51	29100.0
2017-11-15	AAXJ	ETF	75.22	75.43	74.96	75.24	886600.0
2017-11-15	ACSI	ETF	29.61	29.6399	29.55	29.55	2318.0
2017-11-15	ACTX	ETF	46.0204	51.9205	44.8404	50.1505	612.0
2017-11-15	ACWF	ETF	29.651	29.9	29.651	29.8899	12634.0
2017-11-15	ACWI	ETF	69.7	69.94	69.53	69.79	1198400.0
2017-11-15	ACWV	ETF	82.78	82.84	82.55	82.58	103600.0
2017-11-15	ACWX	ETF	48.54	48.7375	48.48	48.685	695994.0
2017-11-15	ADRE	ETF	41.75	42.2476	41.6001	42.15	27331.0
2017-11-15	AFK	ETF	23.31	23.33	22.81	23.33	9393.0
2017-11-15	AFTY	ETF	18.23	18.28	18.23	18.23	6000.0
2017-11-15	AGG	ETF	109.26	109.38	109.14	109.31	2495700.0
2017-11-15	AGGY	ETF	50.53	50.66	50.53	50.66	44600.0
2017-11-15	AGNG	ETF	19.1	19.35	19.1	19.22	2400.0
2017-11-15	AGQ	ETF	34.89	35.04	34.09	34.24	107600.0
2017-11-15	AGZ	ETF	113.4279	113.4999	113.348	113.4999	10112.0
2017-11-15	AGZD	ETF	24.06	24.06	24.06	24.06	4200.0
2017-11-15	AIA	ETF	65.56	65.6399	65.2475	65.5	59947.0
2017-11-15	AIEQ	ETF	24.12	24.325	24.03	24.28	53200.0
2017-11-15	AIRR	ETF	25.41	25.41	25.18	25.2	22200.0
2017-11-15	AIVI	ETF	42.4	42.46	42.35	42.4	5900.0
2017-11-15	ALTY	ETF	15.3	15.38	15.191	15.32	6600.0
2017-11-15	AMJ	ETF	26.08	26.56	25.89	26.48	2554952.0
2017-11-15	AMLP	ETF	50.65	51.45	49.95	51.2	4342500.0
2017-11-15	AMZA	ETF	79.5	80.5	78.0	80.2	149570.0
2017-11-15	ANGL	ETF	29.63	29.69	29.51	29.68	549600.0
2017-11-15	AOA	ETF	54.0	54.07	53.84	54.0	49600.0
2017-11-15	AOK	ETF	34.52	34.56	34.4734	34.55	74318.0
2017-11-15	AOM	ETF	38.04	38.08	37.97	38.01	123127.0
2017-11-15	AOR	ETF	45.02	45.08	44.901	45.07	64959.0
2017-11-15	ARGT	ETF	30.51	31.23	30.13	31.01	176900.0
2017-11-15	ARKG	ETF	23.69	24.211	23.54	24.13	42100.0
2017-11-15	ARKK	ETF	34.35	34.641	33.98	34.6	196300.0
2017-11-15	ARKQ	ETF	32.81	32.85	32.501	32.79	31600.0
2017-11-15	ARKW	ETF	42.68	42.939	42.451	42.86	90600.0
2017-11-15	ASEA	ETF	16.18	16.19	15.9	16.15	6600.0
2017-11-15	ASET	ETF	28.129	28.15	28.119	28.119	4609.0
2017-11-15	ASHR	ETF	31.0	31.05	30.95	30.95	593300.0
2017-11-15	ASHS	ETF	36.0	36.0	35.7	35.74	12900.0
2017-11-15	ASHX	ETF	22.865	22.865	22.865	22.865	200.0
2017-11-15	ATMP	ETF	19.64	20.05	19.64	19.99	208900.0
2017-11-15	BAB	ETF	30.69	30.719	30.56	30.56	236821.0
2017-11-15	BAL	ETF	45.2	45.21	45.2	45.21	1034.0
2017-11-15	BAR	ETF	12.81	12.81	12.776	12.778	32010.0

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

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