PREVIEW / etf_daily / 2016-11-07

all etf daily files

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

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-07	SPY	ETF	208.55	213.19	208.55	213.15	109794900.0
2016-11-07	QQQ	ETF	115.45	116.47	115.3	116.35	26591245.0
2016-11-07	IWM	ETF	118.0	118.82	117.71	118.57	32370900.0
2016-11-07	DIA	ETF	181.17	182.45	181.05	182.36	3402400.0
2016-11-07	GLD	ETF	122.66	122.71	121.88	122.15	10015000.0
2016-11-07	TLT	ETF	130.75	131.0	130.44	130.62	5386700.0
2016-11-07	AADR	ETF	41.32	41.32	41.06	41.06	1700.0
2016-11-07	AAXJ	ETF	58.74	59.14	58.62	59.11	458000.0
2016-11-07	ACSI	ETF	24.89	25.01	24.89	24.99	62608.0
2016-11-07	ACTX	ETF	14.1601	15.3401	12.9801	14.7501	3726.0
2016-11-07	ACWI	ETF	57.48	57.93	57.48	57.9	1906600.0
2016-11-07	ACWV	ETF	73.57	73.76	73.31	73.69	301600.0
2016-11-07	ACWX	ETF	40.43	40.66	40.38	40.66	713827.0
2016-11-07	ADRE	ETF	34.62	35.17	34.62	35.11	12619.0
2016-11-07	AFK	ETF	20.21	20.21	20.1579	20.17	1605.0
2016-11-07	AFTY	ETF	13.67	13.67	13.67	13.67	100.0
2016-11-07	AGG	ETF	111.14	111.18	111.07	111.11	2031000.0
2016-11-07	AGGY	ETF	51.4	51.42	51.338	51.41	30000.0
2016-11-07	AGQ	ETF	42.98	43.15	42.04	42.97	198800.0
2016-11-07	AGZ	ETF	115.0	115.17	114.79	115.17	37345.0
2016-11-07	AGZD	ETF	23.95	23.95	23.95	23.95	600.0
2016-11-07	AIA	ETF	48.75	49.2	48.75	49.17	35741.0
2016-11-07	AIQ	ETF	7.7	7.895	7.6	7.65	22643.0
2016-11-07	AIRR	ETF	19.35	19.502	19.34	19.409	35300.0
2016-11-07	AIVI	ETF	37.25	37.3	37.18	37.27	46100.0
2016-11-07	ALTY	ETF	14.7	14.718	14.644	14.718	1700.0
2016-11-07	AMJ	ETF	29.25	29.48	29.21	29.29	906423.0
2016-11-07	AMLP	ETF	59.75	60.25	59.6	59.7	1415580.0
2016-11-07	AMZA	ETF	103.5	103.5	102.6	103.0	14930.0
2016-11-07	ANGL	ETF	28.6	28.72	28.57	28.72	156000.0
2016-11-07	AOA	ETF	46.25	46.53	46.25	46.5	63000.0
2016-11-07	AOK	ETF	32.78	32.86	32.7001	32.85	300562.0
2016-11-07	AOM	ETF	35.33	35.445	35.2538	35.42	88791.0
2016-11-07	AOR	ETF	40.39	40.39	40.1201	40.31	48804.0
2016-11-07	ARGT	ETF	23.48	23.6	23.46	23.5	31100.0
2016-11-07	ARKG	ETF	16.09	16.86	16.09	16.86	4500.0
2016-11-07	ARKK	ETF	19.49	19.82	19.49	19.82	1000.0
2016-11-07	ARKW	ETF	24.55	24.72	24.53	24.72	1200.0
2016-11-07	ASEA	ETF	13.63	13.7	13.59	13.67	56600.0
2016-11-07	ASET	ETF	25.384	25.384	25.384	25.384	993.0
2016-11-07	ASHR	ETF	24.8	24.9	24.79	24.9	701100.0
2016-11-07	ASHS	ETF	34.4	34.78	34.4	34.73	7000.0
2016-11-07	ATMP	ETF	21.54	21.79	21.54	21.77	52900.0
2016-11-07	BAB	ETF	30.75	30.7623	30.65	30.69	90544.0
2016-11-07	BAL	ETF	45.8187	45.8187	45.27	45.3665	1352.0
2016-11-07	BBC	ETF	17.79	18.09	17.6593	17.9338	10008.0
2016-11-07	BBH	ETF	103.07	105.08	102.85	104.72	165100.0
2016-11-07	BBP	ETF	28.57	30.085	28.57	30.085	3200.0
2016-11-07	BCM	ETF	25.885	26.0299	25.885	26.02	2748.0
2016-11-07	BFOR	ETF	7.7375	7.85	7.7375	7.83	67200.0

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

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