PREVIEW / etf_daily / 2011-02-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-09.parquet
  size:    35 KB
  rows:    830

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-09	SPY	ETF	132.21	132.63	131.61	132.27	146436700.0
2011-02-09	QQQ	ETF	57.94	58.12	57.75	57.93	62540760.0
2011-02-09	IWM	ETF	81.01	81.3	80.42	80.87	43298900.0
2011-02-09	DIA	ETF	122.11	122.4	121.75	122.28	7682100.0
2011-02-09	GLD	ETF	133.19	133.39	132.49	133.07	10178400.0
2011-02-09	TLT	ETF	88.69	89.66	88.14	89.22	13078600.0
2011-02-09	AADR	ETF	30.3	30.3	30.2	30.2	800.0
2011-02-09	AAXJ	ETF	61.27	61.51	60.68	60.92	2089700.0
2011-02-09	ACWI	ETF	48.61	48.62	48.25	48.46	1269200.0
2011-02-09	ACWX	ETF	45.3	45.4261	45.125	45.2544	131872.0
2011-02-09	ADRE	ETF	46.32	46.48	45.75	45.94	81066.0
2011-02-09	AFK	ETF	33.7	33.97	33.61	33.67	20555.0
2011-02-09	AGG	ETF	104.04	104.32	103.93	104.19	518100.0
2011-02-09	AGQ	ETF	302.2	303.88	295.36	298.26	433600.0
2011-02-09	AGZ	ETF	108.64	108.84	108.55	108.66	42847.0
2011-02-09	AIA	ETF	47.28	47.36	46.73	46.89	150307.0
2011-02-09	AIQ	ETF	21.1	21.35	20.6	20.95	11419.0
2011-02-09	AIS	ETF	1.71	1.82	1.7	1.8	1284704.0
2011-02-09	AIVI	ETF	46.52	46.73	46.42	46.73	18000.0
2011-02-09	AMJ	ETF	37.44	37.58	37.37	37.43	990114.0
2011-02-09	AMLP	ETF	80.0	80.55	80.0	80.3	90000.0
2011-02-09	AOA	ETF	35.56	35.64	35.43	35.55	32900.0
2011-02-09	AOK	ETF	28.87	28.92	28.85	28.91	10230.0
2011-02-09	AOM	ETF	30.3	30.33	30.25	30.3	18194.0
2011-02-09	AOR	ETF	32.25	32.2999	32.188	32.26	29737.0
2011-02-09	ARB	ETF	44.09	44.67	43.84	44.06	102945.0
2011-02-09	BAB	ETF	24.56	24.765	24.49	24.68	354659.0
2011-02-09	BAL	ETF	88.87	92.55	88.14	92.24	66961.0
2011-02-09	BALT	ETF	8.9	8.933	8.79	8.9	132753.0
2011-02-09	BBH	ETF	33.8367	33.92	33.61	33.6533	25200.0
2011-02-09	BIB	ETF	7.5125	7.5125	7.416	7.416	1600.0
2011-02-09	BICK	ETF	31.29	31.29	30.55	30.595	238722.0
2011-02-09	BIL	ETF	91.72	91.72	91.7	91.72	147700.0
2011-02-09	BIS	ETF	8096.0	8096.0	8096.0	8096.0	0.625
2011-02-09	BITS	ETF	27.8	27.96	26.8	27.56	2195.0
2011-02-09	BIV	ETF	81.21	81.58	81.14	81.45	261900.0
2011-02-09	BJK	ETF	32.29	32.53	32.24	32.38	14800.0
2011-02-09	BKF	ETF	46.88	46.88	46.315	46.65	289784.0
2011-02-09	BLV	ETF	76.48	77.0	76.03	76.81	24600.0
2011-02-09	BMVP	ETF	15.32	15.37	15.28	15.32	17927.0
2011-02-09	BND	ETF	79.12	79.4	79.02	79.28	1252300.0
2011-02-09	BNO	ETF	33.615	34.05	33.585	34.05	23200.0
2011-02-09	BRF	ETF	51.73	51.75	50.8	51.06	344795.0
2011-02-09	BSCE	ETF	20.73	20.79	20.6701	20.733	9210.0
2011-02-09	BSV	ETF	79.93	80.06	79.92	80.04	1283300.0
2011-02-09	BTF	ETF	83.98649999999999	84.3	83.49999999999999	83.49999999999999	3793.0
2011-02-09	BWX	ETF	29.285	29.285	29.04	29.04	910120.0
2011-02-09	BWZ	ETF	37.71	37.8	37.51	37.75	405506.0
2011-02-09	BZQ	ETF	2776.0	2880.0	2764.8	2868.8	1474.5
2011-02-09	CEF	ETF	20.04	20.08	19.68	19.7	1351200.0

> showing 50 of 830 rows — these rows as CSV

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