PREVIEW / etf_daily / 2013-05-22

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-22.parquet
  size:    41 KB
  rows:    996

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-22	SPY	ETF	167.34	169.07	165.17	165.93	244031800.0
2013-05-22	QQQ	ETF	74.36	74.95	73.24	73.619	59843165.0
2013-05-22	IWM	ETF	99.41	100.38	97.11	97.78	68650700.0
2013-05-22	DIA	ETF	153.71	155.14	152.35	152.84	12806500.0
2013-05-22	GLD	ETF	134.18	136.77	130.95	131.94	25975200.0
2013-05-22	TLT	ETF	118.02	118.55	115.8	116.09	18361500.0
2013-05-22	AADR	ETF	35.03	35.03	34.5	34.5	1000.0
2013-05-22	AAXJ	ETF	60.9	61.47	60.23	60.41	408200.0
2013-05-22	ACTV	ETF	6.13	6.425	6.11	6.24	705134.0
2013-05-22	ACWI	ETF	54.08	54.53	53.32	53.5	1161800.0
2013-05-22	ACWV	ETF	63.78	64.49	63.21	63.41	64900.0
2013-05-22	ACWX	ETF	45.31	45.72	44.7	44.8	476642.0
2013-05-22	ADRE	ETF	39.09	39.55	38.55	38.61	56940.0
2013-05-22	AFK	ETF	30.52	30.85	30.15	30.2	41615.0
2013-05-22	AGEM	ETF	22.99	22.99	22.6461	22.6461	1412.0
2013-05-22	AGG	ETF	110.36	110.48	109.83	109.92	1134400.0
2013-05-22	AGQ	ETF	93.0	97.76	88.52	89.04	1220700.0
2013-05-22	AGZ	ETF	113.48	113.48	113.0201	113.21	10135.0
2013-05-22	AIA	ETF	47.13	47.45	46.64	46.64	13701.0
2013-05-22	AIQ	ETF	12.72	13.0	12.72	12.81	49803.0
2013-05-22	AIVI	ETF	44.73	45.13	44.22	44.34	39400.0
2013-05-22	AMJ	ETF	48.45	49.31	48.0	48.28	887055.0
2013-05-22	AMLP	ETF	90.4	90.7	89.95	90.35	621740.0
2013-05-22	AOA	ETF	41.83	42.1	41.28	41.36	21900.0
2013-05-22	AOK	ETF	31.8	31.88	31.592	31.61	32386.0
2013-05-22	AOM	ETF	33.65	33.77	33.386	33.42	26409.0
2013-05-22	AOR	ETF	37.02	37.17	36.6232	36.7	83992.0
2013-05-22	ARB	ETF	46.78	46.85	46.75	46.78	519055.0
2013-05-22	ARGT	ETF	18.17	18.34	17.87	17.87	10700.0
2013-05-22	ASEA	ETF	18.87	18.94	18.56	18.65	32200.0
2013-05-22	ATMP	ETF	27.11	27.21	26.9	26.96	45700.0
2013-05-22	AVIV	ETF	30.2	30.2	29.03	29.37	725743.0
2013-05-22	AWAY	ETF	30.86	32.09	30.28	30.44	1240942.0
2013-05-22	BAB	ETF	30.4	30.552	30.13	30.14	476140.0
2013-05-22	BAL	ETF	53.09	53.23	52.39	52.43	34226.0
2013-05-22	BALT	ETF	3.7	3.72	3.5	3.66	1831311.0
2013-05-22	BBH	ETF	73.46	74.91	72.2	72.78	346200.0
2013-05-22	BCM	ETF	40.466	40.4699	40.466	40.4699	279.0
2013-05-22	BIB	ETF	25.1875	26.25	24.405	24.8075	307932.0
2013-05-22	BICK	ETF	24.45	24.45	24.07	24.07	797.0
2013-05-22	BIL	ETF	91.6	91.62	91.6	91.62	121000.0
2013-05-22	BIS	ETF	1405.596	1458.0	1360.0	1450.0	265.0
2013-05-22	BIV	ETF	87.62	87.79	87.04	87.08	369500.0
2013-05-22	BIZD	ETF	21.01	21.01	20.49	20.49	21800.0
2013-05-22	BJK	ETF	43.55	43.68	42.73	42.84	61500.0
2013-05-22	BKF	ETF	40.06	40.4	39.4601	39.61	100055.0
2013-05-22	BKLN	ETF	25.24	25.24	25.2	25.23	4361000.0
2013-05-22	BLV	ETF	91.89	92.39	90.85	90.87	51500.0
2013-05-22	BMVP	ETF	19.52	19.677	19.34	19.354	4446.0
2013-05-22	BND	ETF	83.3	83.41	82.97	83.0	1320000.0

> showing 50 of 996 rows — these rows as CSV

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