PREVIEW / etf_daily / 2016-11-02

all etf daily files

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

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-11-02	SPY	ETF	210.65	211.1	209.23	209.74	103330800.0
2016-11-02	QQQ	ETF	116.05	116.3	114.89	115.18	26960093.0
2016-11-02	IWM	ETF	116.87	117.0	115.39	115.56	29859900.0
2016-11-02	DIA	ETF	179.66	180.21	179.05	179.35	3552700.0
2016-11-02	GLD	ETF	123.76	124.76	123.56	123.64	15692400.0
2016-11-02	TLT	ETF	131.3	132.11	131.03	131.58	8666200.0
2016-11-02	AADR	ETF	41.15	41.25	40.53	40.62	7900.0
2016-11-02	AAXJ	ETF	58.73	58.73	58.05	58.28	2284500.0
2016-11-02	ACSI	ETF	24.74	24.74	24.66	24.7	18891.0
2016-11-02	ACTX	ETF	12.9801	12.9801	10.6201	11.8001	2586.0
2016-11-02	ACWF	ETF	23.75	23.75	23.75	23.75	1001.0
2016-11-02	ACWI	ETF	57.51	57.62	57.08	57.19	2884200.0
2016-11-02	ACWV	ETF	73.41	73.68	73.36	73.37	115900.0
2016-11-02	ACWX	ETF	40.57	40.58	40.17	40.24	1830042.0
2016-11-02	ADRE	ETF	34.725	34.725	34.2264	34.2264	7978.0
2016-11-02	AFK	ETF	20.71	20.86	20.1901	20.42	11483.0
2016-11-02	AFTY	ETF	13.56	13.56	13.52	13.52	800.0
2016-11-02	AGG	ETF	111.12	111.32	111.06	111.16	2572600.0
2016-11-02	AGGY	ETF	51.38	51.42	51.3	51.38	6800.0
2016-11-02	AGQ	ETF	44.8	45.51	44.31	44.35	358100.0
2016-11-02	AGZ	ETF	115.25	115.32	114.9501	115.11	22897.0
2016-11-02	AGZD	ETF	24.0	24.015	23.94	24.015	21000.0
2016-11-02	AIA	ETF	48.83	48.89	48.35	48.54	54944.0
2016-11-02	AIQ	ETF	8.3	9.0	8.3	8.75	13576.0
2016-11-02	AIRR	ETF	19.21	19.21	19.02	19.02	5600.0
2016-11-02	AIVI	ETF	37.46	37.49	37.12	37.22	23700.0
2016-11-02	ALTY	ETF	14.58	14.58	14.58	14.58	400.0
2016-11-02	AMJ	ETF	29.69	29.705	28.95	29.51	2548800.0
2016-11-02	AMLP	ETF	60.7	60.7	59.05	60.25	2604960.0
2016-11-02	AMZA	ETF	105.5	105.5	102.1	104.1	45880.0
2016-11-02	ANGL	ETF	28.49	28.61	28.39	28.4	177800.0
2016-11-02	AOA	ETF	46.24	46.32	46.01	46.04	64200.0
2016-11-02	AOK	ETF	32.77	32.8099	32.7	32.74	44427.0
2016-11-02	AOM	ETF	35.35	35.3699	35.22	35.22	68669.0
2016-11-02	AOR	ETF	40.2	40.2	40.024	40.04	79042.0
2016-11-02	ARGT	ETF	23.41	23.46	23.01	23.15	74500.0
2016-11-02	ARKG	ETF	16.339	16.339	16.339	16.339	100.0
2016-11-02	ARKK	ETF	19.555	19.555	19.32	19.32	1000.0
2016-11-02	ARKQ	ETF	20.15	20.183	20.15	20.183	600.0
2016-11-02	ARKW	ETF	24.378	24.378	24.0	24.116	2300.0
2016-11-02	ASEA	ETF	13.48	13.49	13.48	13.49	700.0
2016-11-02	ASET	ETF	25.29	25.29	25.29	25.29	100.0
2016-11-02	ASHR	ETF	24.73	24.77	24.63	24.64	473700.0
2016-11-02	ASHS	ETF	34.71	34.71	34.54	34.57	2400.0
2016-11-02	ATMP	ETF	22.08	22.08	21.46	21.83	24800.0
2016-11-02	BAB	ETF	30.78	30.85	30.74	30.8168	137813.0
2016-11-02	BAL	ETF	45.165	45.439	45.165	45.39	3286.0
2016-11-02	BBC	ETF	18.23	18.23	17.5652	17.5652	5891.0
2016-11-02	BBH	ETF	103.22	103.63	101.75	101.75	127300.0
2016-11-02	BBP	ETF	29.35	29.35	28.971	29.05	4100.0

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

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