PREVIEW / etf_daily / 2013-05-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-16.parquet
  size:    41 KB
  rows:    995

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-05-16	SPY	ETF	165.78	166.36	165.09	165.34	109913600.0
2013-05-16	QQQ	ETF	73.77	74.095	73.55	73.59	27253366.0
2013-05-16	IWM	ETF	98.03	98.56	97.7	97.95	42053300.0
2013-05-16	DIA	ETF	152.64	153.11	152.24	152.45	8194700.0
2013-05-16	GLD	ETF	133.18	134.48	133.0	134.09	12759200.0
2013-05-16	TLT	ETF	117.97	118.94	117.93	118.56	8458400.0
2013-05-16	AADR	ETF	34.94	35.16	34.9	34.9	700.0
2013-05-16	AAXJ	ETF	60.61	60.87	60.52	60.59	599800.0
2013-05-16	ACTV	ETF	6.0	6.39	6.0	6.32	477859.0
2013-05-16	ACWI	ETF	53.5	53.66	53.27	53.33	667400.0
2013-05-16	ACWV	ETF	64.06	64.28	63.72	63.86	44100.0
2013-05-16	ACWX	ETF	44.83	44.98	44.6501	44.7	135339.0
2013-05-16	ADRE	ETF	39.04	39.36	38.94	38.96	66996.0
2013-05-16	AFK	ETF	30.46	30.6646	30.41	30.56	30568.0
2013-05-16	AGEM	ETF	22.8777	22.928	22.73	22.73	55073.0
2013-05-16	AGG	ETF	110.36	110.58	110.36	110.58	1965700.0
2013-05-16	AGQ	ETF	90.96	93.88	90.6	93.0	404150.0
2013-05-16	AGZ	ETF	113.28	113.35	113.13	113.3404	33662.0
2013-05-16	AIA	ETF	46.92	47.02	46.8	46.84	56520.0
2013-05-16	AIQ	ETF	12.58	12.6	12.48	12.52	8904.0
2013-05-16	AIVI	ETF	44.12	44.25	43.95	44.01	51900.0
2013-05-16	AMJ	ETF	47.7	47.71	46.68	46.9	1249653.0
2013-05-16	AMLP	ETF	89.15	89.3	88.4	88.5	598680.0
2013-05-16	ANGL	ETF	27.99	27.99	27.72	27.87	7600.0
2013-05-16	AOA	ETF	41.47	41.57	41.33	41.4	39200.0
2013-05-16	AOK	ETF	31.68	31.726	31.64	31.64	26576.0
2013-05-16	AOM	ETF	33.47	33.569	33.47	33.5	19091.0
2013-05-16	AOR	ETF	36.77	36.85	36.69	36.74	85687.0
2013-05-16	ARB	ETF	46.8	46.87	46.79	46.85	411370.0
2013-05-16	ASEA	ETF	18.75	18.75	18.63	18.66	21900.0
2013-05-16	ATMP	ETF	26.74	26.74	26.4	26.41	105000.0
2013-05-16	AVIV	ETF	30.5	30.62	30.25	30.45	168470.0
2013-05-16	AWAY	ETF	31.14	31.5	30.41	30.43	827485.0
2013-05-16	BAB	ETF	30.32	30.48	30.29	30.45	194632.0
2013-05-16	BAL	ETF	53.96	54.5726	53.96	54.27	15731.0
2013-05-16	BALT	ETF	3.58	3.953	3.55	3.77	154382.0
2013-05-16	BBH	ETF	74.01	74.01	71.86	72.32	153700.0
2013-05-16	BCM	ETF	40.12	40.2806	40.12	40.25	7927.0
2013-05-16	BIB	ETF	25.8775	25.9975	24.43	24.575	347836.0
2013-05-16	BICK	ETF	24.3601	24.3601	24.29	24.29	266.0
2013-05-16	BIL	ETF	91.62	91.62	91.6	91.6	163650.0
2013-05-16	BIS	ETF	1407.2	1473.16	1407.2	1447.12	182.0
2013-05-16	BIV	ETF	87.6	87.87	87.54	87.75	194700.0
2013-05-16	BIZD	ETF	20.75	20.75	20.55	20.55	10500.0
2013-05-16	BJK	ETF	43.24	43.52	43.16	43.2	19100.0
2013-05-16	BKF	ETF	39.58	39.759	39.45	39.5	99672.0
2013-05-16	BKLN	ETF	25.2	25.21	25.19	25.21	2390700.0
2013-05-16	BLV	ETF	92.14	92.6	91.82	92.31	53900.0
2013-05-16	BMVP	ETF	19.4333	19.4333	19.29	19.29	2911.0
2013-05-16	BND	ETF	83.33	83.48	83.33	83.4	1367000.0

> showing 50 of 995 rows — these rows as CSV

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