PREVIEW / etf_daily / 2016-12-29

all etf daily files

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

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-29	SPY	ETF	224.48	224.89	223.84	224.35	48696100.0
2016-12-29	QQQ	ETF	119.86	120.13	119.33	119.71	13267519.0
2016-12-29	IWM	ETF	135.29	136.26	134.69	135.37	21312900.0
2016-12-29	DIA	ETF	197.99	198.52	197.63	197.99	3018700.0
2016-12-29	GLD	ETF	109.23	110.53	109.16	110.29	7563900.0
2016-12-29	TLT	ETF	118.8	119.27	118.66	118.95	8581400.0
2016-12-29	AADR	ETF	40.02	40.22	40.02	40.22	1800.0
2016-12-29	AAXJ	ETF	54.79	55.2	54.79	55.11	1102700.0
2016-12-29	ACSI	ETF	27.2	27.2	27.09	27.15	4051.0
2016-12-29	ACTX	ETF	18.2902	23.6002	18.2902	20.0602	1116.0
2016-12-29	ACWF	ETF	24.016	24.016	24.016	24.016	117.0
2016-12-29	ACWI	ETF	59.31	59.35	59.2	59.26	2055200.0
2016-12-29	ACWV	ETF	72.54	72.72	72.45	72.7	189000.0
2016-12-29	ACWX	ETF	40.17	40.295	40.17	40.26	1324905.0
2016-12-29	ADRE	ETF	32.39	32.5	32.33	32.48	26806.0
2016-12-29	AFK	ETF	19.7	20.14	19.4702	19.97	29628.0
2016-12-29	AFTY	ETF	12.92	12.92	12.92	12.92	200.0
2016-12-29	AGG	ETF	107.73	107.88	107.65	107.84	3649600.0
2016-12-29	AGGY	ETF	49.45	49.505	49.415	49.5	24600.0
2016-12-29	AGQ	ETF	32.69	33.44	32.45	33.11	291200.0
2016-12-29	AGZ	ETF	112.09	112.49	112.05	112.39	15610.0
2016-12-29	AGZD	ETF	24.14	24.14	23.995	23.995	2000.0
2016-12-29	AIA	ETF	46.22	46.38	46.18	46.34	21751.0
2016-12-29	AIQ	ETF	9.55	9.65	9.55	9.6	6735.0
2016-12-29	AIRR	ETF	24.01	24.16	23.75	23.85	105800.0
2016-12-29	AIVI	ETF	37.36	37.45	37.3	37.4	51000.0
2016-12-29	ALTY	ETF	14.95	15.02	14.926	14.942	2300.0
2016-12-29	AMJ	ETF	31.52	31.63	31.4	31.41	1217822.0
2016-12-29	AMLP	ETF	63.35	63.35	62.95	63.05	823880.0
2016-12-29	AMUB	ETF	19.87	19.87	19.8699	19.8699	300.0
2016-12-29	AMZA	ETF	113.4	113.4	112.2	112.7	43440.0
2016-12-29	ANGL	ETF	28.89	28.89	28.78	28.79	781200.0
2016-12-29	AOA	ETF	47.15	47.28	47.15	47.23	100700.0
2016-12-29	AOK	ETF	32.48	32.52	32.4624	32.48	98224.0
2016-12-29	AOM	ETF	35.25	35.3	35.13	35.24	299115.0
2016-12-29	AOR	ETF	40.51	40.55	40.47	40.51	192958.0
2016-12-29	ARGT	ETF	22.88	23.08	22.68	23.08	7500.0
2016-12-29	ARKG	ETF	17.139	17.139	17.139	17.139	300.0
2016-12-29	ARKK	ETF	20.19	20.19	20.19	20.19	400.0
2016-12-29	ARKQ	ETF	22.07	22.07	22.06	22.065	700.0
2016-12-29	ARKW	ETF	25.15	25.18	25.11	25.11	600.0
2016-12-29	ASEA	ETF	12.73	12.73	12.73	12.73	500.0
2016-12-29	ASET	ETF	25.35	25.35	25.35	25.35	500.0
2016-12-29	ASHR	ETF	23.44	23.55	23.44	23.54	432500.0
2016-12-29	ASHS	ETF	32.33	32.5	32.33	32.47	26000.0
2016-12-29	ASHX	ETF	18.96	18.96	18.96	18.96	200.0
2016-12-29	ATMP	ETF	23.52	23.65	23.42	23.49	110900.0
2016-12-29	BAB	ETF	29.04	29.203	29.025	29.1	127741.0
2016-12-29	BAL	ETF	45.95	46.6	45.95	46.37	23028.0
2016-12-29	BBC	ETF	18.9439	18.9439	18.37	18.4	5787.0

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

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