PREVIEW / etf_daily / 2011-02-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-08.parquet
  size:    35 KB
  rows:    829

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
2011-02-08	SPY	ETF	132.09	132.64	131.73	132.57	99072800.0
2011-02-08	QQQ	ETF	57.65	58.07	57.56	58.025	38099821.0
2011-02-08	IWM	ETF	80.66	81.27	80.34	81.23	37563900.0
2011-02-08	DIA	ETF	121.45	122.22	121.33	122.14	6032000.0
2011-02-08	GLD	ETF	132.96	133.5	132.8	133.14	16220900.0
2011-02-08	TLT	ETF	89.31	89.54	88.36	88.45	10454200.0
2011-02-08	AADR	ETF	30.56	30.56	30.23	30.23	900.0
2011-02-08	AAXJ	ETF	62.18	62.28	61.93	62.27	711700.0
2011-02-08	ACWI	ETF	48.28	48.69	48.27	48.69	1043400.0
2011-02-08	ACWX	ETF	45.41	45.57	45.231	45.57	60819.0
2011-02-08	ADRE	ETF	46.9	46.94	46.62	46.94	84869.0
2011-02-08	AFK	ETF	33.53	34.14	33.51	33.95	39326.0
2011-02-08	AGG	ETF	104.31	104.32	103.91	104.0	741000.0
2011-02-08	AGQ	ETF	288.38	301.22	287.6	300.72	638150.0
2011-02-08	AGZ	ETF	108.74	109.0387	108.46	108.46	36322.0
2011-02-08	AIA	ETF	47.57	47.93	47.57	47.92	70819.0
2011-02-08	AIQ	ETF	21.1	21.5	20.95	21.1	13601.0
2011-02-08	AIS	ETF	1.7	1.73	1.65	1.73	669725.0
2011-02-08	AIVI	ETF	46.35	46.6	46.22	46.6	19800.0
2011-02-08	AMJ	ETF	37.75	37.75	37.3619	37.44	562654.0
2011-02-08	AMLP	ETF	79.0	81.45	79.0	80.45	173480.0
2011-02-08	AOA	ETF	35.55	35.64	35.45	35.64	17600.0
2011-02-08	AOK	ETF	28.93	28.94	28.8793	28.8793	11121.0
2011-02-08	AOM	ETF	30.26	30.3398	30.26	30.27	12194.0
2011-02-08	AOR	ETF	32.26	32.3	32.24	32.3	17229.0
2011-02-08	ARB	ETF	43.98	44.45	43.59	44.44	97822.0
2011-02-08	BAB	ETF	24.61	24.7	24.47	24.53	234149.0
2011-02-08	BAL	ETF	88.92	89.719	87.82	89.25	77907.0
2011-02-08	BALT	ETF	8.8	8.95	8.76	8.9	230378.0
2011-02-08	BBH	ETF	33.7367	33.9967	33.73	33.97	20700.0
2011-02-08	BIB	ETF	7.5113	7.5587	7.4912	7.5587	19800.0
2011-02-08	BICK	ETF	31.41	31.5	31.3	31.4	111548.0
2011-02-08	BIL	ETF	91.72	91.72	91.7	91.7	155400.0
2011-02-08	BIS	ETF	8017.6	8022.4	8017.6	8022.4	64.0
2011-02-08	BITS	ETF	28.0	28.16	27.84	27.92	800.0
2011-02-08	BIV	ETF	81.44	81.52	81.01	81.05	150700.0
2011-02-08	BJK	ETF	32.48	32.65	32.43	32.56	10300.0
2011-02-08	BKF	ETF	47.55	47.55	47.05	47.21	246592.0
2011-02-08	BLV	ETF	76.58	76.86	76.1	76.18	21100.0
2011-02-08	BMVP	ETF	15.2483	15.3698	15.2483	15.3667	4114.0
2011-02-08	BND	ETF	79.34	79.38	79.07	79.09	994100.0
2011-02-08	BNO	ETF	33.02	33.54	32.945	33.475	21800.0
2011-02-08	BRF	ETF	51.33	52.31	51.33	52.31	337298.0
2011-02-08	BSCE	ETF	20.75	20.75	20.661	20.682	94791.0
2011-02-08	BSV	ETF	80.04	80.06	79.9	79.92	678400.0
2011-02-08	BTF	ETF	83.75	84.35	83.69999999999999	84.1925	4536.2
2011-02-08	BWX	ETF	29.265	29.435	29.1	29.175	512670.0
2011-02-08	BWZ	ETF	37.38	37.61	37.31	37.545	16714.0
2011-02-08	BZQ	ETF	2716.8	2764.8	2708.8	2713.6	1219.5
2011-02-08	CEF	ETF	19.72	20.0	19.65	19.93	1353300.0

> showing 50 of 829 rows — these rows as CSV

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