PREVIEW / etf_daily / 2016-12-15

all etf daily files

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

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-15	SPY	ETF	226.16	227.81	225.89	226.81	124972600.0
2016-12-15	QQQ	ETF	120.37	121.11	120.08	120.4	22762305.0
2016-12-15	IWM	ETF	135.37	137.14	134.96	136.16	41352500.0
2016-12-15	DIA	ETF	198.54	199.68	198.34	198.66	6033000.0
2016-12-15	GLD	ETF	107.85	107.99	107.0	107.34	14427500.0
2016-12-15	TLT	ETF	117.56	118.29	117.03	117.41	12400500.0
2016-12-15	AADR	ETF	41.95	41.95	39.81	40.12	13500.0
2016-12-15	AAXJ	ETF	56.29	56.31	56.07	56.13	1756100.0
2016-12-15	ACSI	ETF	27.45	27.4668	27.37	27.37	5635.0
2016-12-15	ACTX	ETF	21.2402	21.2402	17.7002	20.6502	1273.0
2016-12-15	ACWF	ETF	24.2626	24.67	24.2626	24.67	664.0
2016-12-15	ACWI	ETF	59.88	60.11	59.78	59.96	2508200.0
2016-12-15	ACWV	ETF	73.15	73.31	72.95	73.21	199500.0
2016-12-15	ACWX	ETF	40.53	40.65	40.48	40.595	1168539.0
2016-12-15	ADRE	ETF	32.83	32.8617	32.69	32.78	9442.0
2016-12-15	AFK	ETF	19.7	19.7	19.3	19.6	15751.0
2016-12-15	AFTY	ETF	13.53	13.53	13.409	13.458	4200.0
2016-12-15	AGG	ETF	107.37	107.42	107.15	107.16	4619100.0
2016-12-15	AGGY	ETF	49.11	49.33	49.08	49.11	58200.0
2016-12-15	AGQ	ETF	32.72	33.07	32.06	32.51	460900.0
2016-12-15	AGZ	ETF	112.21	112.24	111.94	111.95	11481.0
2016-12-15	AGZD	ETF	24.125	24.145	24.035	24.105	16800.0
2016-12-15	AIA	ETF	47.42	47.63	47.42	47.54	23508.0
2016-12-15	AIQ	ETF	9.4	9.55	9.35	9.55	73076.0
2016-12-15	AIRR	ETF	23.59	24.07	23.51	23.931	103000.0
2016-12-15	AIVI	ETF	37.41	37.53	37.34	37.45	50700.0
2016-12-15	ALTY	ETF	14.93	14.93	14.7	14.7	1400.0
2016-12-15	AMJ	ETF	29.7	30.205	29.57	30.19	2133416.0
2016-12-15	AMLP	ETF	60.7	61.45	60.25	61.3	2208180.0
2016-12-15	AMZA	ETF	107.0	108.4	106.8	108.3	23910.0
2016-12-15	ANGL	ETF	28.93	28.93	28.76	28.86	312600.0
2016-12-15	AOA	ETF	47.65	47.72	47.5	47.6	171400.0
2016-12-15	AOK	ETF	32.45	32.5	32.42	32.5	203462.0
2016-12-15	AOM	ETF	35.37	35.41	35.2308	35.3	376274.0
2016-12-15	AOR	ETF	40.7	40.7892	40.629	40.67	262531.0
2016-12-15	ARGT	ETF	22.76	22.98	22.68	22.83	30200.0
2016-12-15	ARKG	ETF	18.019	18.02	18.005	18.005	1500.0
2016-12-15	ARKK	ETF	20.749	20.781	20.749	20.781	600.0
2016-12-15	ARKQ	ETF	22.32	22.37	22.32	22.355	1500.0
2016-12-15	ARKW	ETF	25.63	25.7	25.537	25.545	3000.0
2016-12-15	ASEA	ETF	13.12	13.12	13.08	13.11	2100.0
2016-12-15	ASET	ETF	25.49	25.5	25.49	25.5	1600.0
2016-12-15	ASHR	ETF	24.06	24.1	24.0	24.05	1449400.0
2016-12-15	ASHS	ETF	32.49	32.73	32.4	32.59	35600.0
2016-12-15	ASHX	ETF	21.75	21.88	21.7258	21.87	6776.0
2016-12-15	ATMP	ETF	22.39	22.69	21.92	22.63	102700.0
2016-12-15	BAB	ETF	28.77	28.91	28.75	28.75	510993.0
2016-12-15	BAL	ETF	46.9001	47.11	46.9001	47.05	2405.0
2016-12-15	BBC	ETF	18.82	19.07	18.6274	19.06	7152.0
2016-12-15	BBH	ETF	108.18	109.79	108.18	109.72	39700.0

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

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