PREVIEW / etf_daily / 2016-12-14

all etf daily files

  file:    by_date/etf_daily/2016/2016-12-14.parquet
  size:    54 KB
  rows:    1,357

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-12-14	SPY	ETF	227.41	228.23	225.37	225.88	142501800.0
2016-12-14	QQQ	ETF	120.56	121.0	119.86	120.21	28745991.0
2016-12-14	IWM	ETF	136.42	137.35	134.81	135.15	45923700.0
2016-12-14	DIA	ETF	198.97	199.83	197.61	198.14	7456100.0
2016-12-14	GLD	ETF	110.95	110.98	108.52	108.83	12933600.0
2016-12-14	TLT	ETF	119.08	119.21	116.8	116.82	16618400.0
2016-12-14	AADR	ETF	40.54	40.63	40.01	40.04	15100.0
2016-12-14	AAXJ	ETF	57.09	57.41	56.2	56.26	3193100.0
2016-12-14	ACSI	ETF	27.43	27.5	27.24	27.26	10867.0
2016-12-14	ACTX	ETF	21.2402	21.2402	19.4702	21.2402	378.0
2016-12-14	ACWF	ETF	24.654	24.654	24.654	24.654	270.0
2016-12-14	ACWI	ETF	60.52	60.62	59.8	59.87	2139400.0
2016-12-14	ACWV	ETF	74.0	74.16	73.11	73.17	306700.0
2016-12-14	ACWX	ETF	41.26	41.31	40.61	40.66	1327739.0
2016-12-14	ADRE	ETF	33.43	33.52	32.86	32.89	9926.0
2016-12-14	AFK	ETF	19.97	20.19	19.43	19.43	7509.0
2016-12-14	AFTY	ETF	13.86	13.97	13.78	13.97	4100.0
2016-12-14	AGG	ETF	108.07	108.12	107.29	107.29	3544100.0
2016-12-14	AGGY	ETF	49.5	49.66	49.155	49.166	31000.0
2016-12-14	AGQ	ETF	37.32	37.82	35.76	35.98	171500.0
2016-12-14	AGZ	ETF	112.54	112.5899	112.0501	112.1	19282.0
2016-12-14	AGZD	ETF	24.1	24.17	24.095	24.12	25800.0
2016-12-14	AIA	ETF	48.3	48.52	47.451	47.59	54199.0
2016-12-14	AIQ	ETF	9.15	9.45	9.15	9.3	83794.0
2016-12-14	AIRR	ETF	23.92	24.05	23.58	23.59	54000.0
2016-12-14	AIVI	ETF	38.21	38.35	37.64	37.7	50600.0
2016-12-14	ALTY	ETF	14.97	15.03	14.934	14.934	1800.0
2016-12-14	AMJ	ETF	30.22	30.2537	29.73	29.82	1493472.0
2016-12-14	AMLP	ETF	61.3	61.5	60.75	60.8	1391980.0
2016-12-14	AMZA	ETF	109.0	109.0	107.2	107.6	22520.0
2016-12-14	ANGL	ETF	29.09	29.12	28.77	28.87	272400.0
2016-12-14	AOA	ETF	47.93	48.19	47.54	47.54	197800.0
2016-12-14	AOK	ETF	32.75	32.78	32.46	32.46	254620.0
2016-12-14	AOM	ETF	35.5	35.67	35.28	35.28	481922.0
2016-12-14	AOR	ETF	41.05	41.0999	40.65	40.69	336460.0
2016-12-14	ARGT	ETF	23.26	23.28	22.89	22.9	49500.0
2016-12-14	ARKG	ETF	17.625	17.625	17.374	17.374	800.0
2016-12-14	ARKK	ETF	20.45	20.45	20.411	20.411	1700.0
2016-12-14	ARKQ	ETF	22.4	22.4	22.4	22.4	3300.0
2016-12-14	ARKW	ETF	25.28	25.336	25.28	25.33	1200.0
2016-12-14	ASEA	ETF	13.26	13.26	13.19	13.2	2500.0
2016-12-14	ASET	ETF	25.73	25.749	25.629	25.6299	1430.0
2016-12-14	ASHR	ETF	24.51	24.51	24.26	24.26	1327900.0
2016-12-14	ASHS	ETF	32.5	32.59	32.25	32.33	15200.0
2016-12-14	ASHX	ETF	23.04	23.04	23.04	23.04	480.0
2016-12-14	ATMP	ETF	22.66	22.7	22.42	22.45	224100.0
2016-12-14	BAB	ETF	29.11	29.1499	28.87	28.88	307946.0
2016-12-14	BAL	ETF	47.4572	47.5951	46.98	47.05	4950.0
2016-12-14	BBC	ETF	19.07	19.1324	18.61	18.825	6882.0
2016-12-14	BBH	ETF	107.27	108.83	107.27	108.5	52700.0

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

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