PREVIEW / etf_daily / 2011-02-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-03.parquet
  size:    35 KB
  rows:    822

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-03	SPY	ETF	130.26	130.98	129.57	130.78	145886700.0
2011-02-03	QQQ	ETF	56.85	57.14	56.4	57.0575	45341867.0
2011-02-03	IWM	ETF	79.39	79.85	78.5	79.73	41156200.0
2011-02-03	DIA	ETF	120.03	120.57	119.56	120.37	6338100.0
2011-02-03	GLD	ETF	130.07	132.32	129.28	132.2	17374700.0
2011-02-03	TLT	ETF	89.96	90.57	89.71	89.72	12785800.0
2011-02-03	AADR	ETF	30.29	30.47	30.2	30.47	800.0
2011-02-03	AAXJ	ETF	62.5	62.67	62.22	62.49	315900.0
2011-02-03	ACWI	ETF	48.09	48.29	47.77	48.26	437000.0
2011-02-03	ACWX	ETF	45.19	45.36	44.94	45.36	97318.0
2011-02-03	ADRE	ETF	47.19	47.2581	46.82	47.16	54091.0
2011-02-03	AFK	ETF	33.2	33.37	32.99	33.2858	23121.0
2011-02-03	AGG	ETF	104.79	104.87	104.61	104.61	912300.0
2011-02-03	AGQ	ETF	263.66	275.26	256.24	274.16	508600.0
2011-02-03	AGZ	ETF	109.3	109.39	109.14	109.28	11041.0
2011-02-03	AIA	ETF	48.29	48.3	48.0701	48.21	160069.0
2011-02-03	AIQ	ETF	21.0	21.65	20.95	21.4	10524.0
2011-02-03	AIS	ETF	1.61	1.62	1.58	1.62	181731.0
2011-02-03	AIVI	ETF	46.2	46.36	45.85	46.36	22200.0
2011-02-03	AMJ	ETF	37.72	37.8	37.51	37.78	507308.0
2011-02-03	AMLP	ETF	81.9	81.95	81.6	81.95	106500.0
2011-02-03	AOA	ETF	35.17	35.26	34.96	35.26	6900.0
2011-02-03	AOK	ETF	28.93	28.93	28.89	28.93	21586.0
2011-02-03	AOM	ETF	30.21	30.26	30.208	30.26	4171.0
2011-02-03	AOR	ETF	32.07	32.13	31.98	32.12	10337.0
2011-02-03	ARB	ETF	44.04	44.21	43.64	44.07	174185.0
2011-02-03	BAB	ETF	24.75	24.8299	24.69	24.7	175986.0
2011-02-03	BAL	ETF	92.46	92.46	86.61	87.1	202849.0
2011-02-03	BALT	ETF	8.98	9.06	8.75	8.87	293495.0
2011-02-03	BBH	ETF	33.93	34.09	33.8633	34.0433	87300.0
2011-02-03	BICK	ETF	31.64	31.909	31.5602	31.84	32011.0
2011-02-03	BIL	ETF	91.72	91.72	91.7	91.7	91000.0
2011-02-03	BITS	ETF	28.16	28.16	27.96	28.08	212.0
2011-02-03	BIV	ETF	82.11	82.17	81.92	81.94	148600.0
2011-02-03	BJK	ETF	32.75	33.04	32.74	33.0	19800.0
2011-02-03	BKF	ETF	47.86	47.99	47.41	47.78	213077.0
2011-02-03	BLV	ETF	76.83	77.36	76.83	76.92	16000.0
2011-02-03	BMVP	ETF	15.16	15.28	15.09	15.25	16804.0
2011-02-03	BND	ETF	79.7	79.81	79.6	79.6	851500.0
2011-02-03	BNO	ETF	36.985	36.985	33.845	33.91	50000.0
2011-02-03	BRF	ETF	52.54	52.64	51.9	51.9	323241.0
2011-02-03	BSCE	ETF	20.75	20.81	20.75	20.81	29400.0
2011-02-03	BSV	ETF	80.27	80.31	80.22	80.24	571600.0
2011-02-03	BTF	ETF	82.05	82.69999999999999	81.85	82.6	11121.400000000001
2011-02-03	BWX	ETF	29.485	29.51	29.36	29.5075	305382.0
2011-02-03	BWZ	ETF	37.59	37.94	37.5101	37.5101	9573.0
2011-02-03	BZQ	ETF	2636.8	2700.8	2633.6	2656.0	683.0
2011-02-03	CEF	ETF	19.11	19.45	18.94	19.33	1253100.0
2011-02-03	CEW	ETF	22.39	22.403	22.32	22.39	135783.0
2011-02-03	CGO	ETF	15.01	15.12	15.0	15.07	20833.0

> showing 50 of 822 rows — these rows as CSV

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