PREVIEW / etf_daily / 2014-11-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-06.parquet
  size:    46 KB
  rows:    1,130

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
2014-11-06	SPY	ETF	202.39	203.26	201.64	203.15	107089000.0
2014-11-06	QQQ	ETF	101.32	101.72	100.921	101.69	24671900.0
2014-11-06	IWM	ETF	115.98	116.53	115.56	116.53	31720900.0
2014-11-06	DIA	ETF	174.75	175.41	174.18	175.29	7191700.0
2014-11-06	GLD	ETF	109.92	110.49	109.75	109.88	7019900.0
2014-11-06	TLT	ETF	118.6	118.93	118.31	118.39	5901900.0
2014-11-06	AADR	ETF	39.7	39.7	37.33	37.33	2500.0
2014-11-06	AAXJ	ETF	62.07	62.17	61.86	61.91	1565500.0
2014-11-06	ACWI	ETF	59.2	59.35	59.0	59.26	595000.0
2014-11-06	ACWV	ETF	69.07	69.07	68.69	68.95	300300.0
2014-11-06	ACWX	ETF	44.77	44.83	44.4888	44.54	313523.0
2014-11-06	ADRE	ETF	39.13	39.13	38.6301	38.67	9705.0
2014-11-06	AFK	ETF	29.19	29.19	28.51	28.71	34859.0
2014-11-06	AGG	ETF	109.52	109.67	109.5	109.54	1391400.0
2014-11-06	AGQ	ETF	37.0	37.63	36.81	37.56	227100.0
2014-11-06	AGZ	ETF	112.472	112.939	112.472	112.92	31801.0
2014-11-06	AGZD	ETF	24.75	24.815	24.75	24.76	11800.0
2014-11-06	AIA	ETF	47.3	47.4	47.28	47.29	15969.0
2014-11-06	AIQ	ETF	25.5	25.5399	23.48	24.04	23775.0
2014-11-06	AIRR	ETF	18.77	19.06	18.77	19.03	17300.0
2014-11-06	AIVI	ETF	45.74	45.74	45.4	45.44	20900.0
2014-11-06	AMJ	ETF	50.08	50.324	49.55	49.99	910798.0
2014-11-06	AMLP	ETF	91.2	91.45	90.35	90.95	594500.0
2014-11-06	AMZA	ETF	240.0	240.6	239.06	240.6	260.0
2014-11-06	ANGL	ETF	27.81	27.82	27.73	27.73	1800.0
2014-11-06	AOA	ETF	46.34	46.35	46.26	46.35	16900.0
2014-11-06	AOK	ETF	32.63	32.67	32.62	32.63	32948.0
2014-11-06	AOM	ETF	35.3	35.3	35.1742	35.22	37364.0
2014-11-06	AOR	ETF	39.98	40.065	39.96	40.05	45850.0
2014-11-06	ARGT	ETF	20.63	20.77	20.42	20.74	7300.0
2014-11-06	ARKG	ETF	19.75	19.78	19.7	19.747	2000.0
2014-11-06	ARKK	ETF	20.09	20.14	20.07	20.14	2000.0
2014-11-06	ARKQ	ETF	19.7	19.87	19.7	19.87	1000.0
2014-11-06	ARKW	ETF	20.19	20.28	20.15	20.278	1400.0
2014-11-06	ASEA	ETF	16.73	16.73	16.58	16.61	5700.0
2014-11-06	ASHR	ETF	26.52	26.52	26.41	26.44	195100.0
2014-11-06	ASHS	ETF	34.34	34.34	34.29	34.34	7400.0
2014-11-06	ATMP	ETF	31.08	31.16	30.95	31.15	14000.0
2014-11-06	AVIV	ETF	33.63	33.95	33.18	33.21	363498.0
2014-11-06	AWAY	ETF	28.6	29.9	28.06	29.62	2231501.0
2014-11-06	BAB	ETF	29.74	29.8394	29.74	29.7845	45147.0
2014-11-06	BAL	ETF	41.9	42.35	41.9	42.35	7158.0
2014-11-06	BALT	ETF	3.5	3.53	3.25	3.45	1119130.0
2014-11-06	BAR	ETF	2.5412	2.5449	2.5412	2.5449	6060.0
2014-11-06	BBH	ETF	113.82	115.38	113.82	115.24	83800.0
2014-11-06	BCHP	ETF	18.2117	18.2801	18.2117	18.2801	762.0
2014-11-06	BFOR	ETF	7.84	7.875	7.83	7.875	123600.0
2014-11-06	BIB	ETF	57.955	59.34	57.5865	59.24	499918.0
2014-11-06	BICK	ETF	24.79	24.82	24.73	24.74	912.0
2014-11-06	BIL	ETF	91.5	91.5	91.48	91.5	407200.0

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

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