PREVIEW / etf_daily / 2014-02-07

all etf daily files

  file:    by_date/etf_daily/2014/2014-02-07.parquet
  size:    43 KB
  rows:    1,070

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-02-07	SPY	ETF	178.31	179.87	177.73	179.68	170787200.0
2014-02-07	QQQ	ETF	86.27	87.359	86.0	87.3	38467242.0
2014-02-07	IWM	ETF	109.97	110.84	109.5	110.75	44068600.0
2014-02-07	DIA	ETF	156.56	157.8	156.05	157.78	11528500.0
2014-02-07	GLD	ETF	121.24	122.24	121.23	122.17	6674700.0
2014-02-07	TLT	ETF	106.46	107.22	106.44	106.79	7039200.0
2014-02-07	AADR	ETF	36.13	36.25	36.12	36.25	5000.0
2014-02-07	AAXJ	ETF	56.23	56.5	56.09	56.3	1099900.0
2014-02-07	ACWI	ETF	55.48	55.85	55.26	55.79	1431600.0
2014-02-07	ACWV	ETF	60.82	61.38	60.82	61.28	43000.0
2014-02-07	ACWX	ETF	44.48	44.78	44.37	44.75	377340.0
2014-02-07	ADRE	ETF	34.06	34.25	33.93	34.2155	26449.0
2014-02-07	AFK	ETF	29.93	30.32	29.82	30.32	11805.0
2014-02-07	AGG	ETF	107.68	107.9	107.65	107.82	611700.0
2014-02-07	AGQ	ETF	65.53	66.35	64.93	66.2	259100.0
2014-02-07	AGZ	ETF	111.77	111.77	111.65	111.7	12723.0
2014-02-07	AGZD	ETF	24.99	24.99	24.99	24.99	800.0
2014-02-07	AIA	ETF	43.72	43.9656	43.72	43.87	100702.0
2014-02-07	AIQ	ETF	28.0	28.69	27.65	28.21	15328.0
2014-02-07	AIVI	ETF	46.33	46.76	46.27	46.74	16300.0
2014-02-07	ALTL	ETF	32.236	32.236	32.236	32.236	850.0
2014-02-07	AMJ	ETF	47.0399	47.22	46.551	47.01	456889.0
2014-02-07	AMLP	ETF	87.55	88.5	87.55	88.2	688940.0
2014-02-07	ANGL	ETF	26.98	27.07	26.98	27.07	5400.0
2014-02-07	AOA	ETF	43.45	43.6	43.26	43.59	21400.0
2014-02-07	AOK	ETF	31.79	31.88	31.784	31.88	19880.0
2014-02-07	AOM	ETF	33.96	34.05	33.9104	34.0	23152.0
2014-02-07	AOR	ETF	37.76	37.96	37.71	37.96	20647.0
2014-02-07	ARGT	ETF	17.33	17.54	17.33	17.53	2500.0
2014-02-07	ASEA	ETF	14.95	15.05	14.95	14.99	4800.0
2014-02-07	ASHR	ETF	23.16	23.25	23.09	23.16	242900.0
2014-02-07	ATMP	ETF	27.51	27.77	27.51	27.77	19700.0
2014-02-07	AVIV	ETF	23.63	23.81	23.45	23.57	112055.0
2014-02-07	AWAY	ETF	39.64	40.19	39.15	40.01	863988.0
2014-02-07	BAB	ETF	28.13	28.24	28.12	28.17	93242.0
2014-02-07	BAL	ETF	54.4	55.269	54.4	54.96	9254.0
2014-02-07	BALT	ETF	6.11	6.14	6.02	6.09	700737.0
2014-02-07	BBH	ETF	94.59	97.48	94.45	97.47	166600.0
2014-02-07	BCM	ETF	39.53	39.66	39.53	39.66	41426.0
2014-02-07	BFOR	ETF	7.1225	7.1675	7.1	7.1675	375200.0
2014-02-07	BIB	ETF	41.565	43.98	41.025	43.955	697696.0
2014-02-07	BICK	ETF	22.77	22.8257	22.72	22.8257	760.0
2014-02-07	BIL	ETF	91.54	91.56	91.54	91.56	433800.0
2014-02-07	BIS	ETF	728.12	730.56	681.6	681.6	3562.5
2014-02-07	BIV	ETF	83.44	83.58	83.4	83.47	286200.0
2014-02-07	BIZD	ETF	20.75	20.85	20.74	20.84	8300.0
2014-02-07	BJK	ETF	51.65	51.82	51.15	51.68	12900.0
2014-02-07	BKF	ETF	34.71	34.8887	34.49	34.65	74693.0
2014-02-07	BKLN	ETF	24.89	24.91	24.87	24.9	3686900.0
2014-02-07	BLV	ETF	84.91	85.1	84.81	84.94	176700.0

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

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