PREVIEW / etf_daily / 2011-02-25

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-25.parquet
  size:    35 KB
  rows:    832

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-25	SPY	ETF	131.48	132.41	131.4	132.33	141686900.0
2011-02-25	QQQ	ETF	57.16	57.72	57.12	57.65	54094579.0
2011-02-25	IWM	ETF	80.7	82.21	80.64	82.18	58566800.0
2011-02-25	DIA	ETF	120.94	121.33	120.74	121.14	5649800.0
2011-02-25	GLD	ETF	137.22	137.74	136.77	137.38	10351400.0
2011-02-25	TLT	ETF	91.74	92.28	91.64	92.28	6841700.0
2011-02-25	AADR	ETF	30.17	30.23	30.17	30.23	9400.0
2011-02-25	AAXJ	ETF	59.57	60.09	59.57	60.03	602500.0
2011-02-25	ACWI	ETF	48.16	48.44	48.05	48.4	790400.0
2011-02-25	ACWX	ETF	45.07	45.32	45.06	45.29	120480.0
2011-02-25	ADRE	ETF	46.61	46.7	46.3075	46.7	27889.0
2011-02-25	AFK	ETF	32.8	33.18	32.8	33.1	14605.0
2011-02-25	AGG	ETF	105.27	105.47	105.25	105.45	542000.0
2011-02-25	AGQ	ETF	350.32	360.48	344.14	359.64	623100.0
2011-02-25	AGZ	ETF	108.88	109.3	108.88	109.0	25190.0
2011-02-25	AIA	ETF	45.4	45.85	45.4	45.66	96798.0
2011-02-25	AIQ	ETF	20.95	21.4	20.35	20.75	31735.0
2011-02-25	AIS	ETF	1.6	1.67	1.57	1.58	488137.0
2011-02-25	AIVI	ETF	46.11	46.32	46.08	46.27	8600.0
2011-02-25	AMJ	ETF	37.85	38.01	37.61	38.01	809048.0
2011-02-25	AMLP	ETF	82.0	82.3	81.65	82.3	105320.0
2011-02-25	AOA	ETF	35.35	35.66	35.35	35.66	5600.0
2011-02-25	AOK	ETF	29.08	29.14	29.08	29.14	20839.0
2011-02-25	AOM	ETF	30.42	30.4999	30.42	30.4999	17901.0
2011-02-25	AOR	ETF	32.2756	32.42	32.2756	32.3972	15447.0
2011-02-25	ARB	ETF	39.96	40.33	39.84	40.13	495912.0
2011-02-25	ASEA	ETF	15.22	15.22	15.02	15.06	14100.0
2011-02-25	BAB	ETF	25.11	25.29	25.11	25.228	453540.0
2011-02-25	BAL	ETF	90.87	97.62	90.5	96.586	131178.0
2011-02-25	BALT	ETF	9.17	9.47	9.17	9.36	147368.0
2011-02-25	BBH	ETF	33.3933	33.7933	33.3933	33.77	24300.0
2011-02-25	BIB	ETF	7.3937	7.3937	7.3937	7.3937	800.0
2011-02-25	BICK	ETF	30.47	30.8345	30.47	30.77	72279.0
2011-02-25	BIL	ETF	91.72	91.72	91.7	91.72	91350.0
2011-02-25	BITS	ETF	26.84	27.32	26.48	27.12	1625.0
2011-02-25	BIV	ETF	82.34	82.61	82.34	82.61	80600.0
2011-02-25	BJK	ETF	31.3	31.62	31.3	31.59	52900.0
2011-02-25	BKF	ETF	47.25	47.57	46.9999	47.545	779603.0
2011-02-25	BLV	ETF	78.44	78.65	78.25	78.65	33400.0
2011-02-25	BMVP	ETF	15.4615	15.5734	15.33	15.5734	2212.0
2011-02-25	BND	ETF	80.1	80.24	80.06	80.24	998100.0
2011-02-25	BNO	ETF	37.145	37.415	36.84	37.29	114600.0
2011-02-25	BRF	ETF	52.3	52.5	51.87	52.2	217301.0
2011-02-25	BSCE	ETF	20.862	20.92	20.862	20.92	37165.0
2011-02-25	BSV	ETF	80.33	80.42	80.28	80.42	1036000.0
2011-02-25	BTF	ETF	84.35	85.44999999999999	84.35	85.44999999999999	4632.400000000001
2011-02-25	BWX	ETF	29.54	29.585	29.43	29.54	208472.0
2011-02-25	BWZ	ETF	37.74	37.91	37.56	37.87	17367.0
2011-02-25	BZQ	ETF	2558.4	2622.4	2544.0	2582.4	582.0
2011-02-25	CEF	ETF	21.04	21.35	20.96	21.25	1129200.0

> showing 50 of 832 rows — these rows as CSV

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