PREVIEW / etf_daily / 2014-07-11

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-11.parquet
  size:    44 KB
  rows:    1,099

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-07-11	SPY	ETF	196.22	196.75	195.78	196.61	64243000.0
2014-07-11	QQQ	ETF	94.87	95.27	94.61	95.27	19570393.0
2014-07-11	IWM	ETF	115.18	115.38	114.51	115.1	33923700.0
2014-07-11	DIA	ETF	168.77	169.22	168.32	169.2	2830500.0
2014-07-11	GLD	ETF	128.41	128.83	128.38	128.78	4322100.0
2014-07-11	TLT	ETF	113.35	113.68	113.28	113.58	4676500.0
2014-07-11	AADR	ETF	38.58	38.58	38.58	38.58	400.0
2014-07-11	AAXJ	ETF	63.41	63.52	63.29	63.47	206700.0
2014-07-11	ACWI	ETF	60.22	60.28	60.02	60.23	486100.0
2014-07-11	ACWV	ETF	67.05	67.1	66.87	67.08	25800.0
2014-07-11	ACWX	ETF	47.71	47.77	47.61	47.75	375781.0
2014-07-11	ADRE	ETF	39.66	39.8401	39.6208	39.84	6531.0
2014-07-11	AFK	ETF	33.06	33.16	32.62	33.16	67387.0
2014-07-11	AGG	ETF	109.16	109.27	109.14	109.16	606800.0
2014-07-11	AGQ	ETF	73.31	74.0	73.3	73.86	127800.0
2014-07-11	AGZ	ETF	112.6563	112.6563	112.4325	112.453	4239.0
2014-07-11	AGZD	ETF	24.9	25.03	24.9	24.985	43600.0
2014-07-11	AIA	ETF	48.61	48.6999	48.52	48.65	19736.0
2014-07-11	AIQ	ETF	28.03	29.26	28.0	28.93	42191.0
2014-07-11	AIRR	ETF	18.79	18.81	18.77	18.77	3100.0
2014-07-11	AIVI	ETF	49.82	50.08	49.8	50.01	6600.0
2014-07-11	AMJ	ETF	51.48	51.5685	51.2	51.55	168030.0
2014-07-11	AMLP	ETF	93.5	93.95	93.25	93.85	397860.0
2014-07-11	ANGL	ETF	28.13	28.13	28.13	28.13	200.0
2014-07-11	AOA	ETF	46.5	46.61	46.43	46.59	13100.0
2014-07-11	AOK	ETF	32.8034	32.85	32.8	32.85	20790.0
2014-07-11	AOM	ETF	35.26	35.38	35.26	35.37	25091.0
2014-07-11	AOR	ETF	40.04	40.07	39.96	40.05	30169.0
2014-07-11	ARGT	ETF	23.53	23.79	23.3	23.77	15700.0
2014-07-11	ASEA	ETF	17.18	17.23	17.18	17.18	3300.0
2014-07-11	ASHR	ETF	22.36	22.52	22.36	22.47	226400.0
2014-07-11	ASHS	ETF	27.04	27.23	26.99	27.22	21600.0
2014-07-11	ATMP	ETF	31.07	31.18	30.98	31.18	9200.0
2014-07-11	AVIV	ETF	28.05	28.05	27.77	28.0	210373.0
2014-07-11	AWAY	ETF	33.14	33.41	32.82	33.21	531526.0
2014-07-11	BAB	ETF	29.42	29.42	29.32	29.41	139365.0
2014-07-11	BAL	ETF	45.75	46.31	45.2	45.8001	26475.0
2014-07-11	BALT	ETF	5.45	5.47	5.32	5.44	733449.0
2014-07-11	BBH	ETF	96.59	97.29	96.24	96.97	33300.0
2014-07-11	BCHP	ETF	20.64	20.64	20.62	20.64	896.0
2014-07-11	BCM	ETF	40.87	40.87	40.63	40.63	21200.0
2014-07-11	BFOR	ETF	7.79	7.79	7.7475	7.7825	40000.0
2014-07-11	BIB	ETF	46.02	46.645	45.3751	46.38	371414.0
2014-07-11	BICK	ETF	26.1999	26.1999	26.1999	26.1999	955.0
2014-07-11	BIL	ETF	91.52	91.54	91.5	91.52	63350.0
2014-07-11	BIS	ETF	575.6	576.76	560.4	566.0	6435.0
2014-07-11	BIV	ETF	84.59	84.65	84.53	84.6	126700.0
2014-07-11	BIZD	ETF	20.47	20.5	20.46	20.49	8100.0
2014-07-11	BJK	ETF	49.84	49.84	49.66	49.74	4100.0
2014-07-11	BKF	ETF	39.1	39.246	38.99	39.19	89189.0

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

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