PREVIEW / etf_daily / 2016-10-31

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-31.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-10-31	SPY	ETF	212.93	213.19	212.36	212.55	61272500.0
2016-10-31	QQQ	ETF	117.53	117.53	116.93	116.99	18749357.0
2016-10-31	IWM	ETF	118.18	118.64	117.8	118.5	20311800.0
2016-10-31	DIA	ETF	181.58	181.7	181.05	181.17	1415600.0
2016-10-31	GLD	ETF	121.51	122.0	121.23	121.94	7722100.0
2016-10-31	TLT	ETF	130.89	131.29	130.71	131.25	7047500.0
2016-10-31	AADR	ETF	41.54	41.71	41.47	41.68	3800.0
2016-10-31	AAXJ	ETF	58.84	59.1	58.82	58.92	1516800.0
2016-10-31	ACTX	ETF	14.7501	15.3401	10.6201	12.7441	3046.0
2016-10-31	ACWI	ETF	57.98	58.1	57.88	57.97	1366400.0
2016-10-31	ACWV	ETF	73.58	73.86	73.44	73.83	58600.0
2016-10-31	ACWX	ETF	40.72	40.81	40.625	40.75	991175.0
2016-10-31	ADRE	ETF	35.5	35.52	35.2744	35.3334	3966.0
2016-10-31	AFK	ETF	20.6	20.84	20.09	20.53	19423.0
2016-10-31	AFTY	ETF	13.53	13.53	13.52	13.52	400.0
2016-10-31	AGG	ETF	111.3	111.33	111.21	111.3	3260300.0
2016-10-31	AGGY	ETF	51.28	51.372	51.28	51.35	7900.0
2016-10-31	AGNG	ETF	15.02	15.02	15.02	15.02	300.0
2016-10-31	AGQ	ETF	41.36	41.67	41.05	41.54	69300.0
2016-10-31	AGZ	ETF	114.89	115.15	114.75	115.07	21341.0
2016-10-31	AIA	ETF	48.97	49.1362	48.97	49.03	27981.0
2016-10-31	AIQ	ETF	8.5	9.05	8.2	8.35	9059.0
2016-10-31	AIRR	ETF	19.428	19.58	19.42	19.57	5300.0
2016-10-31	AIVI	ETF	37.6	37.67	37.52	37.65	15400.0
2016-10-31	ALTY	ETF	15.023	15.023	15.023	15.023	300.0
2016-10-31	AMJ	ETF	30.38	30.4713	29.98	30.14	1724781.0
2016-10-31	AMLP	ETF	62.2	62.2	61.15	61.15	1791300.0
2016-10-31	AMZA	ETF	107.7	107.8	105.9	106.5	29060.0
2016-10-31	ANGL	ETF	29.13	29.13	28.7	28.74	978900.0
2016-10-31	AOA	ETF	46.64	46.64	46.46	46.57	21300.0
2016-10-31	AOK	ETF	32.87	32.9236	32.8001	32.89	37936.0
2016-10-31	AOM	ETF	35.41	35.4732	35.37	35.37	110988.0
2016-10-31	AOR	ETF	40.34	40.38	40.2501	40.36	68171.0
2016-10-31	ARGT	ETF	23.78	23.84	23.68	23.8	39100.0
2016-10-31	ARKG	ETF	16.9	16.9	16.715	16.715	800.0
2016-10-31	ARKK	ETF	19.98	20.007	19.89	19.917	1600.0
2016-10-31	ARKQ	ETF	20.8	20.81	20.79	20.79	2500.0
2016-10-31	ARKW	ETF	25.1	25.1	24.63	24.72	2900.0
2016-10-31	ASEA	ETF	13.76	13.76	13.55	13.57	2100.0
2016-10-31	ASHR	ETF	24.63	24.68	24.6	24.64	295600.0
2016-10-31	ASHS	ETF	34.71	34.71	34.51	34.51	3300.0
2016-10-31	ASHX	ETF	22.77	22.8202	22.76	22.76	10200.0
2016-10-31	ATMP	ETF	22.27	22.42	22.17	22.27	34900.0
2016-10-31	BAB	ETF	30.67	30.77	30.6582	30.72	97101.0
2016-10-31	BAL	ETF	46.01	46.01	45.57	45.6487	14027.0
2016-10-31	BBC	ETF	18.48	18.48	18.1299	18.143	6953.0
2016-10-31	BBH	ETF	104.39	104.82	102.8	102.82	211700.0
2016-10-31	BBP	ETF	29.19	29.19	28.87	28.94	4500.0
2016-10-31	BCM	ETF	26.43	26.43	26.2537	26.2652	920.0
2016-10-31	BFOR	ETF	7.8075	7.8375	7.785	7.8375	12800.0

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

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