PREVIEW / etf_daily / 2011-02-07

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-07.parquet
  size:    35 KB
  rows:    826

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-07	SPY	ETF	131.44	132.4	131.43	131.97	112439100.0
2011-02-07	QQQ	ETF	57.49	57.97	57.4	57.65	45626804.0
2011-02-07	IWM	ETF	79.98	81.25	79.91	80.66	40835200.0
2011-02-07	DIA	ETF	120.88	121.65	120.85	121.35	7317100.0
2011-02-07	GLD	ETF	131.67	131.95	131.23	131.68	7176300.0
2011-02-07	TLT	ETF	88.7	89.3	88.57	89.27	8554800.0
2011-02-07	AADR	ETF	30.29	30.4	30.29	30.4	700.0
2011-02-07	AAXJ	ETF	62.38	62.77	62.29	62.64	536200.0
2011-02-07	ACWI	ETF	48.18	48.58	48.18	48.43	218300.0
2011-02-07	ACWX	ETF	45.25	45.49	45.25	45.41	63691.0
2011-02-07	ADRE	ETF	46.59	46.9625	46.59	46.64	48275.0
2011-02-07	AFK	ETF	33.58	33.73	33.51	33.66	53501.0
2011-02-07	AGG	ETF	104.17	104.33	104.11	104.3	604700.0
2011-02-07	AGQ	ETF	279.32	284.0	276.46	282.08	360100.0
2011-02-07	AGZ	ETF	108.95	108.974	108.72	108.782	321824.0
2011-02-07	AIA	ETF	48.1	48.32	48.03	48.09	62240.0
2011-02-07	AIQ	ETF	21.25	21.45	20.705	21.2	7099.0
2011-02-07	AIS	ETF	1.62	1.68	1.62	1.66	427518.0
2011-02-07	AIVI	ETF	46.15	46.4	46.15	46.33	26200.0
2011-02-07	AMJ	ETF	37.77	37.7887	37.57	37.66	515475.0
2011-02-07	AMLP	ETF	81.1	81.1	80.5	80.55	133060.0
2011-02-07	AOA	ETF	35.38	35.61	35.38	35.5	57200.0
2011-02-07	AOK	ETF	28.89	28.94	28.87	28.924	5019.0
2011-02-07	AOM	ETF	30.21	30.32	30.21	30.29	9354.0
2011-02-07	AOR	ETF	32.15	32.27	32.15	32.21	14055.0
2011-02-07	ARB	ETF	44.0	44.04	43.561	43.95	124973.0
2011-02-07	BAB	ETF	24.55	24.69	24.55	24.69	198313.0
2011-02-07	BAL	ETF	87.43	89.55	87.001	89.02	107204.0
2011-02-07	BALT	ETF	8.95	9.0	8.78	8.83	242159.0
2011-02-07	BBH	ETF	33.9933	34.01	33.73	33.78	77100.0
2011-02-07	BIB	ETF	7.4275	7.5901	7.4275	7.5412	27600.0
2011-02-07	BICK	ETF	31.38	31.74	31.38	31.5	42567.0
2011-02-07	BIL	ETF	91.72	91.72	91.7	91.7	131550.0
2011-02-07	BIS	ETF	7964.8	7969.6	7964.8	7969.6	1.25
2011-02-07	BITS	ETF	27.998	28.12	27.32	28.12	4351.0
2011-02-07	BIV	ETF	81.4	81.57	81.3	81.5	174900.0
2011-02-07	BJK	ETF	32.45	32.76	32.39	32.53	31200.0
2011-02-07	BKF	ETF	47.21	47.55	47.13	47.29	388851.0
2011-02-07	BLV	ETF	76.11	76.69	76.11	76.69	69500.0
2011-02-07	BMVP	ETF	15.27	15.33	15.27	15.29	8979.0
2011-02-07	BND	ETF	79.25	79.4	79.21	79.34	1222300.0
2011-02-07	BNO	ETF	33.44	33.445	33.07	33.19	25000.0
2011-02-07	BOSS	ETF	49.15	49.15	49.15	49.15	100.0
2011-02-07	BRF	ETF	50.79	51.595	50.67	51.29	657138.0
2011-02-07	BSCE	ETF	20.72	20.74	20.715	20.74	106502.0
2011-02-07	BSV	ETF	80.0	80.09	79.94	80.08	877700.0
2011-02-07	BTF	ETF	82.79999999999998	83.9	82.79999999999998	83.9	10392.6
2011-02-07	BWX	ETF	29.235	29.323	29.15	29.255	714406.0
2011-02-07	BWZ	ETF	37.35	37.53	37.22	37.52	43610.0
2011-02-07	BZQ	ETF	2782.4	2793.6	2723.2	2793.6	829.0

> showing 50 of 826 rows — these rows as CSV

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