PREVIEW / etf_daily / 2016-10-11

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-11.parquet
  size:    52 KB
  rows:    1,316

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-10-11	SPY	ETF	215.66	215.74	212.58	213.43	130367400.0
2016-10-11	QQQ	ETF	119.1	119.14	117.0	117.52	27774426.0
2016-10-11	IWM	ETF	124.05	124.11	121.34	122.03	31931300.0
2016-10-11	DIA	ETF	182.86	182.89	180.45	181.2	3949800.0
2016-10-11	GLD	ETF	119.92	120.16	119.53	119.55	6065300.0
2016-10-11	TLT	ETF	132.86	133.55	132.57	132.83	9670400.0
2016-10-11	AADR	ETF	40.08	40.08	40.08	40.08	200.0
2016-10-11	AAXJ	ETF	59.98	60.05	59.38	59.62	1634900.0
2016-10-11	ACTX	ETF	7.0801	8.2601	6.9031	6.9031	905.0
2016-10-11	ACWI	ETF	58.77	58.79	58.01	58.22	1561400.0
2016-10-11	ACWV	ETF	74.56	74.56	73.8	73.94	384800.0
2016-10-11	ACWX	ETF	41.13	41.13	40.67	40.78	570265.0
2016-10-11	ADRE	ETF	35.63	35.63	35.09	35.29	8805.0
2016-10-11	AFK	ETF	20.39	20.5182	20.15	20.5182	2843.0
2016-10-11	AFTY	ETF	13.65	13.65	13.468	13.47	1500.0
2016-10-11	AGG	ETF	111.49	111.54	111.35	111.36	2753300.0
2016-10-11	AGGY	ETF	51.578	51.64	51.578	51.584	2800.0
2016-10-11	AGQ	ETF	40.19	40.32	39.6	39.67	108000.0
2016-10-11	AGZ	ETF	114.952	115.11	114.87	114.97	10019.0
2016-10-11	AGZD	ETF	24.0	24.005	23.98	23.98	3800.0
2016-10-11	AIA	ETF	49.53	49.53	49.01	49.3	207136.0
2016-10-11	AIQ	ETF	7.552	7.77	7.39	7.39	19614.0
2016-10-11	AIRR	ETF	20.34	20.34	19.91	19.95	82200.0
2016-10-11	AIVI	ETF	38.45	38.45	37.96	38.05	34000.0
2016-10-11	ALTY	ETF	15.226	15.23	15.052	15.186	3200.0
2016-10-11	AMJ	ETF	31.22	31.22	30.81	31.07	854066.0
2016-10-11	AMLP	ETF	63.1	63.2	62.5	62.95	1034800.0
2016-10-11	AMZA	ETF	109.2	109.2	107.5	108.3	11190.0
2016-10-11	ANGL	ETF	28.92	29.01	28.89	28.92	216200.0
2016-10-11	AOA	ETF	47.09	47.09	46.55	46.72	54400.0
2016-10-11	AOK	ETF	33.1	33.1	32.881	32.99	35016.0
2016-10-11	AOM	ETF	35.7	35.7	35.48	35.54	75938.0
2016-10-11	AOR	ETF	40.74	40.75	40.341	40.47	43843.0
2016-10-11	ARGT	ETF	24.35	24.35	24.02	24.15	48200.0
2016-10-11	ARKG	ETF	19.08	19.08	18.379	18.379	7100.0
2016-10-11	ARKK	ETF	21.135	21.135	21.0	21.0	1200.0
2016-10-11	ARKQ	ETF	21.808	21.808	21.797	21.8	1600.0
2016-10-11	ARKW	ETF	25.48	25.48	25.0	25.005	8600.0
2016-10-11	ASEA	ETF	13.73	13.73	13.61	13.61	1000.0
2016-10-11	ASET	ETF	25.5699	25.5699	25.5699	25.5699	335.0
2016-10-11	ASHR	ETF	24.84	24.84	24.58	24.61	587300.0
2016-10-11	ASHS	ETF	35.44	35.44	34.96	35.01	10100.0
2016-10-11	ASHX	ETF	22.84	22.84	22.66	22.66	13600.0
2016-10-11	ATMP	ETF	23.15	23.15	22.74	22.93	31200.0
2016-10-11	BAB	ETF	30.84	30.9135	30.8001	30.88	211515.0
2016-10-11	BAL	ETF	44.54	44.54	44.42	44.42	1079.0
2016-10-11	BBC	ETF	22.08	22.2999	21.58	21.58	12966.0
2016-10-11	BBH	ETF	111.91	112.37	109.03	109.83	96700.0
2016-10-11	BBP	ETF	33.35	33.35	32.596	32.86	9100.0
2016-10-11	BCM	ETF	26.71	26.718	26.701	26.7075	1480.0

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

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