PREVIEW / etf_daily / 2013-07-29

all etf daily files

  file:    by_date/etf_daily/2013/2013-07-29.parquet
  size:    41 KB
  rows:    1,016

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
2013-07-29	SPY	ETF	168.68	169.06	168.11	168.59	79695000.0
2013-07-29	QQQ	ETF	75.22	75.54	75.0299	75.23	20970308.0
2013-07-29	IWM	ETF	103.84	104.27	103.0	103.39	30360800.0
2013-07-29	DIA	ETF	154.86	155.14	154.45	154.93	2592500.0
2013-07-29	GLD	ETF	128.45	128.78	128.25	128.47	3554100.0
2013-07-29	TLT	ETF	107.65	107.82	107.07	107.35	6397800.0
2013-07-29	AADR	ETF	33.98	34.0	33.86	33.96	3100.0
2013-07-29	AAXJ	ETF	56.46	56.5	56.23	56.32	651200.0
2013-07-29	ACTV	ETF	8.78	8.79	8.56	8.6	275829.0
2013-07-29	ACWI	ETF	52.38	52.47	52.25	52.38	570300.0
2013-07-29	ACWV	ETF	61.8	61.88	61.65	61.72	31800.0
2013-07-29	ACWX	ETF	42.72	42.72	42.5656	42.64	477442.0
2013-07-29	ADRE	ETF	35.58	35.58	35.41	35.41	8931.0
2013-07-29	AFK	ETF	28.86	28.99	28.6801	28.78	14615.0
2013-07-29	AGG	ETF	107.26	107.27	107.13	107.26	459600.0
2013-07-29	AGQ	ETF	69.92	70.2	69.24	69.24	271375.0
2013-07-29	AGZ	ETF	111.42	111.42	110.8301	111.11	25801.0
2013-07-29	AIA	ETF	44.13	44.17	44.025	44.04	22307.0
2013-07-29	AIQ	ETF	18.98	19.415	18.98	19.09	58184.0
2013-07-29	AIVI	ETF	42.58	42.58	42.42	42.55	29400.0
2013-07-29	ALTL	ETF	29.7153	29.7153	29.7153	29.7153	335.0
2013-07-29	AMJ	ETF	46.56	46.91	46.28	46.5	432309.0
2013-07-29	AMLP	ETF	90.15	90.15	89.15	89.35	365100.0
2013-07-29	ANGL	ETF	26.86	26.9	26.86	26.89	1600.0
2013-07-29	AOA	ETF	41.22	41.3	41.16	41.21	19200.0
2013-07-29	AOK	ETF	31.17	31.17	31.11	31.12	21061.0
2013-07-29	AOM	ETF	32.94	33.0	32.9	32.95	41630.0
2013-07-29	AOR	ETF	36.34	36.43	36.3001	36.36	30111.0
2013-07-29	ARB	ETF	45.64	45.94	45.49	45.83	148452.0
2013-07-29	ARGT	ETF	17.5	17.5	17.47	17.47	700.0
2013-07-29	ASEA	ETF	17.08	17.09	17.02	17.04	29600.0
2013-07-29	ATMP	ETF	26.74	26.74	26.43	26.49	57700.0
2013-07-29	AVIV	ETF	25.37	25.52	24.95	25.04	51556.0
2013-07-29	AWAY	ETF	31.49	31.7	29.88	30.46	2031223.0
2013-07-29	BAB	ETF	27.74	27.878	27.67	27.71	208206.0
2013-07-29	BAL	ETF	54.21	54.5699	54.21	54.28	12764.0
2013-07-29	BALT	ETF	4.04	4.08	3.98	3.99	91719.0
2013-07-29	BBH	ETF	78.58	78.63	77.65	77.96	51600.0
2013-07-29	BCM	ETF	39.641	39.6646	39.641	39.6601	2934.0
2013-07-29	BFOR	ETF	6.5325	6.5575	6.5075	6.53	146800.0
2013-07-29	BIB	ETF	28.9825	28.9825	28.2125	28.366	53856.0
2013-07-29	BICK	ETF	21.91	21.9644	21.88	21.9	2385.0
2013-07-29	BIL	ETF	91.58	91.6	91.58	91.6	160600.0
2013-07-29	BIS	ETF	1189.6	1213.996	1188.8	1208.36	67.0
2013-07-29	BIV	ETF	83.62	83.7	83.53	83.59	342900.0
2013-07-29	BIZD	ETF	20.4	20.43	20.38	20.39	4600.0
2013-07-29	BJK	ETF	41.48	41.62	41.45	41.57	2600.0
2013-07-29	BKF	ETF	35.22	35.3	35.07	35.07	86253.0
2013-07-29	BKLN	ETF	24.94	24.95	24.91	24.94	2926600.0
2013-07-29	BLV	ETF	84.38	84.63	84.03	84.21	96200.0

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

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