PREVIEW / etf_daily / 2014-07-29

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-29.parquet
  size:    45 KB
  rows:    1,106

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-29	SPY	ETF	198.17	198.45	196.92	196.95	80466000.0
2014-07-29	QQQ	ETF	96.97	97.2	96.52	96.6	27022232.0
2014-07-29	IWM	ETF	113.39	114.11	113.03	113.34	30574500.0
2014-07-29	DIA	ETF	169.89	170.19	168.78	168.78	3683100.0
2014-07-29	GLD	ETF	125.79	125.88	124.72	125.2	5267700.0
2014-07-29	TLT	ETF	115.87	116.07	115.42	115.93	6579300.0
2014-07-29	AAXJ	ETF	65.75	65.88	65.5	65.53	639200.0
2014-07-29	ACWI	ETF	60.82	60.88	60.48	60.48	443700.0
2014-07-29	ACWV	ETF	67.48	67.89	67.33	67.33	30200.0
2014-07-29	ACWX	ETF	48.32	48.4	48.12	48.12	37693.0
2014-07-29	ADRE	ETF	41.8	41.97	41.551	41.568	17513.0
2014-07-29	AFK	ETF	34.22	34.23	33.88	34.02	47988.0
2014-07-29	AGG	ETF	109.45	109.52	109.34	109.46	2977100.0
2014-07-29	AGQ	ETF	68.37	68.63	67.16	68.12	107700.0
2014-07-29	AGZ	ETF	112.62	112.62	112.39	112.47	18718.0
2014-07-29	AGZD	ETF	25.055	25.06	25.055	25.06	600.0
2014-07-29	AIA	ETF	50.71	50.89	50.71	50.74	19646.0
2014-07-29	AIQ	ETF	29.04	29.92	28.23	29.83	65655.0
2014-07-29	AIRR	ETF	18.311	18.311	18.14	18.155	19700.0
2014-07-29	AIVI	ETF	50.78	50.9	50.71	50.72	14500.0
2014-07-29	ALTL	ETF	35.7514	35.7514	35.5515	35.5515	537.0
2014-07-29	AMJ	ETF	52.24	52.46	51.95	52.01	283783.0
2014-07-29	AMLP	ETF	94.75	95.15	94.35	94.45	446800.0
2014-07-29	ANGL	ETF	28.2	28.2	28.0	28.19	21200.0
2014-07-29	AOA	ETF	46.9	46.9	46.65	46.65	55000.0
2014-07-29	AOK	ETF	32.97	32.97	32.87	32.87	20784.0
2014-07-29	AOM	ETF	35.53	35.53	35.4199	35.42	38843.0
2014-07-29	AOR	ETF	40.4	40.4	40.11	40.11	28792.0
2014-07-29	ARGT	ETF	21.65	22.11	21.44	22.11	35500.0
2014-07-29	ASEA	ETF	17.46	17.46	17.39	17.39	1800.0
2014-07-29	ASHR	ETF	24.69	24.7	24.58	24.6	1819200.0
2014-07-29	ASHS	ETF	29.07	29.07	28.78	28.83	5600.0
2014-07-29	ATMP	ETF	32.07	32.07	31.63	31.67	39100.0
2014-07-29	AVIV	ETF	29.01	29.01	28.68	28.71	151648.0
2014-07-29	AWAY	ETF	35.27	36.14	34.98	35.76	1216268.0
2014-07-29	BAB	ETF	29.58	29.63	29.5	29.63	25903.0
2014-07-29	BAL	ETF	43.92	43.96	43.3801	43.86	13841.0
2014-07-29	BALT	ETF	5.31	5.35	5.18	5.27	271583.0
2014-07-29	BBH	ETF	97.01	98.74	97.01	98.52	56600.0
2014-07-29	BCHP	ETF	20.62	20.62	20.5799	20.59	5261.0
2014-07-29	BFOR	ETF	7.7775	7.8	7.63	7.74	50400.0
2014-07-29	BIB	ETF	44.3	45.89	44.26	45.45	296464.0
2014-07-29	BICK	ETF	27.34	27.41	27.34	27.3892	393.0
2014-07-29	BIL	ETF	91.52	91.52	91.5	91.52	123900.0
2014-07-29	BIS	ETF	586.4	586.4	562.0	568.4	8349.5
2014-07-29	BIV	ETF	84.78	84.82	84.63	84.77	185000.0
2014-07-29	BIZD	ETF	20.59	20.59	20.45	20.45	8400.0
2014-07-29	BJK	ETF	51.22	51.45	51.03	51.03	25800.0
2014-07-29	BKF	ETF	40.64	40.64	40.31	40.35	109963.0
2014-07-29	BKLN	ETF	24.75	24.77	24.73	24.73	2993100.0

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

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