PREVIEW / etf_daily / 2016-10-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-14.parquet
  size:    52 KB
  rows:    1,301

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
2016-10-14	SPY	ETF	214.15	214.69	213.03	213.12	93346200.0
2016-10-14	QQQ	ETF	117.58	118.05	117.07	117.14	21313321.0
2016-10-14	IWM	ETF	121.36	121.84	120.4	120.43	24554600.0
2016-10-14	DIA	ETF	182.0	182.46	181.21	181.29	2698100.0
2016-10-14	GLD	ETF	119.37	120.16	119.29	119.36	6577300.0
2016-10-14	TLT	ETF	132.27	132.95	131.53	131.59	11415100.0
2016-10-14	AADR	ETF	40.32	40.46	40.19	40.19	1400.0
2016-10-14	AAXJ	ETF	59.6	59.64	59.1	59.13	1249100.0
2016-10-14	ACTX	ETF	12.9801	13.5701	11.8001	12.0951	4210.0
2016-10-14	ACWI	ETF	58.31	58.46	57.99	58.01	864300.0
2016-10-14	ACWV	ETF	74.49	74.57	74.11	74.11	142800.0
2016-10-14	ACWX	ETF	40.83	40.89	40.57	40.57	313126.0
2016-10-14	ADRE	ETF	35.38	35.466	35.08	35.11	6436.0
2016-10-14	AFK	ETF	20.0	20.0554	20.0	20.01	1957.0
2016-10-14	AFTY	ETF	13.52	13.55	13.48	13.5	6900.0
2016-10-14	AGG	ETF	111.47	111.61	111.33	111.37	2471500.0
2016-10-14	AGGY	ETF	51.61	51.678	51.545	51.56	9400.0
2016-10-14	AGQ	ETF	39.6	40.12	39.24	39.62	157300.0
2016-10-14	AGZ	ETF	114.82	115.1499	114.82	115.01	10772.0
2016-10-14	AGZD	ETF	23.955	24.035	23.94	23.95	12200.0
2016-10-14	AIA	ETF	49.34	49.43	49.02	49.065	190627.0
2016-10-14	AIQ	ETF	7.57	7.85	7.57	7.63	16906.0
2016-10-14	AIRR	ETF	20.085	20.085	19.779	19.83	6800.0
2016-10-14	AIVI	ETF	38.01	38.07	37.77	37.77	15400.0
2016-10-14	ALTY	ETF	15.172	15.19	15.093	15.19	900.0
2016-10-14	AMJ	ETF	31.12	31.23	30.81	30.89	1482290.0
2016-10-14	AMLP	ETF	62.7	63.0	62.5	62.55	690300.0
2016-10-14	AMZA	ETF	107.7	108.05	106.6	107.4	21750.0
2016-10-14	ANGL	ETF	29.08	29.09	29.01	29.02	171400.0
2016-10-14	AOA	ETF	46.73	46.82	46.5	46.58	13400.0
2016-10-14	AOK	ETF	33.0	33.0	32.9	32.91	22037.0
2016-10-14	AOM	ETF	35.5	35.63	35.4115	35.46	47989.0
2016-10-14	AOR	ETF	40.53	40.5622	40.3	40.3	44154.0
2016-10-14	ARGT	ETF	24.0	24.0	23.71	23.84	16900.0
2016-10-14	ARKG	ETF	18.07	18.07	17.66	17.66	300.0
2016-10-14	ARKK	ETF	20.54	20.54	20.379	20.38	1000.0
2016-10-14	ARKQ	ETF	21.31	21.44	21.291	21.291	800.0
2016-10-14	ARKW	ETF	24.615	24.615	24.538	24.538	1500.0
2016-10-14	ASEA	ETF	13.56	13.56	13.56	13.56	1100.0
2016-10-14	ASHR	ETF	24.72	24.77	24.69	24.7	533900.0
2016-10-14	ASHS	ETF	35.19	35.21	35.07	35.07	6300.0
2016-10-14	ATMP	ETF	23.02	23.02	22.74	22.86	62100.0
2016-10-14	BAB	ETF	30.86	30.91	30.7874	30.8	64648.0
2016-10-14	BAL	ETF	46.65	46.923	46.641	46.85	2838.0
2016-10-14	BBC	ETF	20.65	20.65	20.09	20.09	4540.0
2016-10-14	BBH	ETF	108.2	108.22	105.8	105.8	68300.0
2016-10-14	BBP	ETF	31.7	31.7	30.629	30.629	14600.0
2016-10-14	BCM	ETF	26.59	26.59	26.59	26.59	200.0
2016-10-14	BFOR	ETF	7.925	7.97	7.9025	7.91	21200.0
2016-10-14	BIB	ETF	42.93	43.201	40.76	40.79	701697.0

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

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