PREVIEW / etf_daily / 2016-02-09

all etf daily files

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

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-09	SPY	ETF	183.36	186.94	183.2	185.43	184513100.0
2016-02-09	QQQ	ETF	95.36	97.78	95.18	96.32	73778426.0
2016-02-09	IWM	ETF	95.13	97.13	95.02	95.78	55857200.0
2016-02-09	DIA	ETF	158.54	161.46	158.51	160.24	11449200.0
2016-02-09	GLD	ETF	114.43	114.69	113.55	113.58	18156700.0
2016-02-09	TLT	ETF	132.04	132.06	130.96	131.63	15232100.0
2016-02-09	AADR	ETF	34.75	34.75	34.75	34.75	200.0
2016-02-09	AAXJ	ETF	47.37	48.0	47.09	47.53	1144300.0
2016-02-09	ACTX	ETF	5.31	5.9001	4.72	4.72	1640.0
2016-02-09	ACWF	ETF	20.48	20.61	20.47	20.59	8396.0
2016-02-09	ACWI	ETF	49.75	50.53	49.47	50.2	2900300.0
2016-02-09	ACWV	ETF	66.84	67.61	66.84	67.32	314400.0
2016-02-09	ACWX	ETF	35.18	35.555	35.0554	35.33	4285092.0
2016-02-09	ADRE	ETF	25.52	25.75	25.345	25.6028	13666.0
2016-02-09	AFK	ETF	16.55	16.55	16.1801	16.2905	10496.0
2016-02-09	AFTY	ETF	11.38	11.38	11.325	11.325	800.0
2016-02-09	AGG	ETF	109.92	109.93	109.66	109.73	3023800.0
2016-02-09	AGGY	ETF	49.98	49.98	49.73	49.828	17200.0
2016-02-09	AGQ	ETF	33.11	33.43	32.31	32.44	236900.0
2016-02-09	AGZ	ETF	114.76	115.09	114.5101	114.62	31519.0
2016-02-09	AIA	ETF	37.22	37.66	36.97	37.37	34755.0
2016-02-09	AIQ	ETF	6.65	6.7	6.56	6.57	12021.0
2016-02-09	AIRR	ETF	14.24	14.32	14.24	14.27	12900.0
2016-02-09	AIVI	ETF	35.11	35.59	35.11	35.37	32300.0
2016-02-09	AMJ	ETF	22.12	22.22	21.11	21.68	5356271.0
2016-02-09	AMLP	ETF	44.1	44.4	42.0	43.4	3326760.0
2016-02-09	AMZA	ETF	66.7	68.97	63.02	65.5	12820.0
2016-02-09	ANGL	ETF	23.5	23.57	23.42	23.56	42200.0
2016-02-09	AOA	ETF	41.03	41.46	41.03	41.32	51500.0
2016-02-09	AOK	ETF	30.84	30.9799	30.83	30.92	32779.0
2016-02-09	AOM	ETF	32.85	33.01	32.85	32.95	68264.0
2016-02-09	AOR	ETF	36.41	36.78	36.4	36.67	95640.0
2016-02-09	ARGT	ETF	16.68	16.73	16.5	16.64	17000.0
2016-02-09	ARKG	ETF	15.638	15.64	15.638	15.64	200.0
2016-02-09	ARKK	ETF	14.815	14.976	14.815	14.86	800.0
2016-02-09	ARKQ	ETF	14.736	14.74	14.35	14.48	2500.0
2016-02-09	ARKW	ETF	16.4	16.6	16.14	16.369	1900.0
2016-02-09	ASEA	ETF	11.85	11.94	11.82	11.82	1700.0
2016-02-09	ASHR	ETF	21.2	21.49	21.19	21.33	669000.0
2016-02-09	ASHS	ETF	29.89	29.94	29.41	29.71	21400.0
2016-02-09	ASHX	ETF	19.27	19.27	19.27	19.27	600.0
2016-02-09	ATMP	ETF	13.82	14.26	13.82	14.16	38400.0
2016-02-09	BAB	ETF	30.41	30.41	30.25	30.36	153006.0
2016-02-09	BAL	ETF	38.99	39.4	38.5631	38.62	11760.0
2016-02-09	BBC	ETF	16.06	17.04	16.06	16.5548	7853.0
2016-02-09	BBH	ETF	93.5	97.8	93.1	96.11	141100.0
2016-02-09	BBP	ETF	21.47	22.55	21.47	22.54	3200.0
2016-02-09	BCM	ETF	22.79	22.82	22.39	22.39	700.0
2016-02-09	BFOR	ETF	6.55	6.645	6.5175	6.5825	224800.0
2016-02-09	BIB	ETF	35.33	39.12	35.227	37.59	1134155.0

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

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