PREVIEW / etf_daily / 2014-08-22

all etf daily files

  file:    by_date/etf_daily/2014/2014-08-22.parquet
  size:    45 KB
  rows:    1,104

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-08-22	SPY	ETF	199.34	199.69	198.74	199.19	76107000.0
2014-08-22	QQQ	ETF	98.94	99.25	98.72	99.05	24699453.0
2014-08-22	IWM	ETF	115.04	115.63	114.61	115.21	30100100.0
2014-08-22	DIA	ETF	170.01	170.48	169.65	169.87	5152200.0
2014-08-22	GLD	ETF	123.09	123.33	122.57	123.19	4739200.0
2014-08-22	TLT	ETF	116.74	117.43	116.21	117.29	10149900.0
2014-08-22	AADR	ETF	38.38	38.38	38.1	38.23	14400.0
2014-08-22	AAXJ	ETF	65.77	65.97	65.48	65.71	224200.0
2014-08-22	ACWI	ETF	60.54	60.63	60.3	60.45	744100.0
2014-08-22	ACWV	ETF	68.13	68.13	67.74	67.85	9900.0
2014-08-22	ACWX	ETF	47.62	47.6382	47.36	47.51	146567.0
2014-08-22	ADRE	ETF	42.41	42.55	42.2826	42.38	20678.0
2014-08-22	AFK	ETF	33.34	33.34	33.131	33.22	28139.0
2014-08-22	AGG	ETF	109.53	109.61	109.35	109.56	801900.0
2014-08-22	AGQ	ETF	60.48	60.9	59.64	60.66	167800.0
2014-08-22	AGZ	ETF	112.5901	113.1179	112.47	112.72	10019.0
2014-08-22	AGZD	ETF	24.91	24.92	24.825	24.88	4000.0
2014-08-22	AIA	ETF	50.72	50.8852	50.56	50.74	13111.0
2014-08-22	AIQ	ETF	28.4	28.8	28.03	28.37	19278.0
2014-08-22	AIRR	ETF	19.04	19.13	18.986	19.1	8400.0
2014-08-22	AIVI	ETF	49.64	49.64	49.45	49.5	14900.0
2014-08-22	AMJ	ETF	53.46	53.5	53.15	53.26	248132.0
2014-08-22	AMLP	ETF	95.3	95.35	94.7	94.9	488660.0
2014-08-22	ANGL	ETF	28.03	28.18	28.03	28.18	700.0
2014-08-22	AOA	ETF	46.95	46.95	46.69	46.83	18100.0
2014-08-22	AOK	ETF	32.88	32.9	32.83	32.89	22877.0
2014-08-22	AOM	ETF	35.501	35.5272	35.4262	35.46	32429.0
2014-08-22	AOR	ETF	40.28	40.3199	40.19	40.23	22269.0
2014-08-22	ARGT	ETF	20.81	20.99	20.79	20.92	18600.0
2014-08-22	ASEA	ETF	17.41	17.45	17.4	17.45	2700.0
2014-08-22	ASHR	ETF	24.96	24.97	24.87	24.88	191800.0
2014-08-22	ASHS	ETF	30.84	30.84	30.78	30.78	2600.0
2014-08-22	ATMP	ETF	33.05	33.05	32.29	32.34	23300.0
2014-08-22	AVIV	ETF	28.34	28.45	28.12	28.33	105131.0
2014-08-22	AWAY	ETF	32.96	33.25	32.5	33.2	1165337.0
2014-08-22	BAB	ETF	29.69	29.7358	29.57	29.719	67049.0
2014-08-22	BAL	ETF	44.16	44.56	44.0501	44.5	15579.0
2014-08-22	BALT	ETF	5.97	6.07	5.84	5.88	442502.0
2014-08-22	BBH	ETF	102.72	103.47	102.11	102.99	139600.0
2014-08-22	BCHP	ETF	20.3248	20.3248	20.2901	20.2901	732.0
2014-08-22	BCM	ETF	39.25	39.25	39.2	39.2	1577.0
2014-08-22	BFOR	ETF	7.8475	7.85	7.825	7.8325	26000.0
2014-08-22	BIB	ETF	48.5	49.685	48.275	49.35	442476.0
2014-08-22	BICK	ETF	27.1	27.1	27.0999	27.0999	570.0
2014-08-22	BIL	ETF	91.52	91.52	91.5	91.52	84050.0
2014-08-22	BIS	ETF	528.4	529.2	514.0	518.0	13558.5
2014-08-22	BIV	ETF	84.99	85.02	84.77	84.93	193700.0
2014-08-22	BIZD	ETF	20.44	20.51	20.41	20.45	8900.0
2014-08-22	BJK	ETF	48.69	48.87	48.58	48.69	7600.0
2014-08-22	BKF	ETF	41.07	41.07	40.7139	40.8	60723.0

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

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