PREVIEW / etf_daily / 2016-02-02

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-02.parquet
  size:    50 KB
  rows:    1,245

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-02-02	SPY	ETF	191.96	191.97	189.54	190.16	182564900.0
2016-02-02	QQQ	ETF	103.97	103.97	101.84	102.15	44928088.0
2016-02-02	IWM	ETF	101.33	101.47	99.77	100.28	39692700.0
2016-02-02	DIA	ETF	162.7	162.7	160.94	161.41	7901000.0
2016-02-02	GLD	ETF	107.92	108.18	107.35	108.09	6656000.0
2016-02-02	TLT	ETF	128.1	129.04	128.0	129.02	10400000.0
2016-02-02	AADR	ETF	36.26	36.27	35.71	36.13	14800.0
2016-02-02	AAXJ	ETF	48.69	48.75	47.94	48.09	1034100.0
2016-02-02	ACTX	ETF	5.31	5.9001	4.602	4.72	2124.0
2016-02-02	ACWF	ETF	21.46	21.46	21.3	21.3	3669.0
2016-02-02	ACWI	ETF	52.15	52.18	51.48	51.64	2834500.0
2016-02-02	ACWV	ETF	68.36	68.36	67.77	67.99	164100.0
2016-02-02	ACWX	ETF	36.72	36.72	36.27	36.37	2965689.0
2016-02-02	ADRE	ETF	26.67	26.67	26.16	26.2	7792.0
2016-02-02	AFK	ETF	16.3	16.3	16.03	16.12	69014.0
2016-02-02	AFTY	ETF	11.53	11.57	11.454	11.454	5200.0
2016-02-02	AGG	ETF	109.23	109.38	109.13	109.32	4835100.0
2016-02-02	AGGY	ETF	49.68	49.775	49.622	49.76	10300.0
2016-02-02	AGQ	ETF	28.92	29.12	28.45	28.72	125800.0
2016-02-02	AGZ	ETF	114.02	114.22	113.88	114.15	14521.0
2016-02-02	AGZD	ETF	23.64	23.645	23.575	23.64	12200.0
2016-02-02	AIA	ETF	38.14	38.14	37.754	37.94	38983.0
2016-02-02	AIQ	ETF	7.26	7.73	7.06	7.14	8386.0
2016-02-02	AIRR	ETF	14.91	14.91	14.72	14.72	14400.0
2016-02-02	AIVI	ETF	36.32	36.32	35.99	36.05	33000.0
2016-02-02	ALTY	ETF	12.97	13.02	12.97	13.02	500.0
2016-02-02	AMJ	ETF	24.8	25.065	24.29	24.74	7844990.0
2016-02-02	AMLP	ETF	50.25	50.7	49.05	50.1	2114680.0
2016-02-02	AMZA	ETF	86.0	88.2	81.0	83.3	11640.0
2016-02-02	ANGL	ETF	23.86	23.86	23.69	23.78	46000.0
2016-02-02	AOA	ETF	42.52	42.67	42.15	42.23	67100.0
2016-02-02	AOK	ETF	31.17	31.17	31.04	31.05	41399.0
2016-02-02	AOM	ETF	33.34	33.4	33.185	33.24	54079.0
2016-02-02	AOR	ETF	37.44	37.44	37.15	37.2	98743.0
2016-02-02	ARGT	ETF	17.01	17.01	16.7	16.7	8900.0
2016-02-02	ARKG	ETF	16.53	16.53	16.53	16.53	100.0
2016-02-02	ARKK	ETF	16.46	16.46	16.46	16.46	100.0
2016-02-02	ARKQ	ETF	16.1	16.1	15.809	15.809	1000.0
2016-02-02	ARKW	ETF	18.87	18.87	18.87	18.87	200.0
2016-02-02	ASEA	ETF	11.67	11.67	11.47	11.51	10600.0
2016-02-02	ASHR	ETF	22.04	22.04	21.61	21.74	1324500.0
2016-02-02	ASHS	ETF	29.69	30.61	29.07	29.59	176800.0
2016-02-02	ASHX	ETF	19.73	19.92	19.73	19.8	1707.0
2016-02-02	ATMP	ETF	16.39	16.47	16.05	16.17	471300.0
2016-02-02	BAB	ETF	29.97	30.0	29.8973	29.99	266717.0
2016-02-02	BAL	ETF	41.0	41.38	41.0	41.2289	809.0
2016-02-02	BBC	ETF	18.755	19.1999	18.7101	18.79	3027.0
2016-02-02	BBH	ETF	101.39	101.59	98.93	99.36	74300.0
2016-02-02	BBP	ETF	23.355	23.48	23.35	23.48	900.0
2016-02-02	BCM	ETF	22.65	22.696	22.65	22.696	576.0

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

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