PREVIEW / etf_daily / 2009-02-05

all etf daily files

  file:    by_date/etf_daily/2009/2009-02-05.parquet
  size:    28 KB
  rows:    636

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
2009-02-05	SPY	ETF	82.7	85.29	77.73	84.57	417679400.0
2009-02-05	QQQ	ETF	29.47	30.77	29.46	30.57	217569553.0
2009-02-05	IWM	ETF	44.44	46.01	44.2	45.35	71623700.0
2009-02-05	DIA	ETF	79.26	81.15	78.5	80.55	39865100.0
2009-02-05	GLD	ETF	90.75	90.82	89.3	90.12	17196300.0
2009-02-05	TLT	ETF	103.24	103.88	102.21	102.61	2279500.0
2009-02-05	AAXJ	ETF	31.64	32.12	30.95	31.83	20600.0
2009-02-05	ACWI	ETF	29.06	29.89	28.91	29.68	278500.0
2009-02-05	ACWX	ETF	27.02	27.68	26.782	27.53	120463.0
2009-02-05	ADRE	ETF	26.21	27.38	26.18	27.22	271204.0
2009-02-05	AFK	ETF	18.2	18.2	18.0991	18.12	500.0
2009-02-05	AGG	ETF	101.27	101.47	100.61	100.68	702200.0
2009-02-05	AGQ	ETF	79.3	80.28	77.18	79.64	53950.0
2009-02-05	AGZ	ETF	107.18	107.23	106.52	107.09	2834.0
2009-02-05	AIA	ETF	25.56	25.56	23.83	24.34	11286.0
2009-02-05	AIQ	ETF	45.7	46.8	45.55	46.7	37578.0
2009-02-05	AIS	ETF	0.4	0.41	0.3697	0.41	1975322.0
2009-02-05	AIVI	ETF	28.71	29.64	28.46	29.33	6900.0
2009-02-05	AOA	ETF	22.62	22.62	22.57	22.57	500.0
2009-02-05	AOK	ETF	25.07	25.08	25.0	25.08	4419.0
2009-02-05	AOM	ETF	24.5	24.5	24.27	24.28	2550.0
2009-02-05	AOR	ETF	23.49	23.49	23.49	23.49	680.0
2009-02-05	ARB	ETF	13.6	13.95	13.3	13.75	295853.0
2009-02-05	BAL	ETF	29.07	29.09	29.07	29.09	10311.0
2009-02-05	BBH	ETF	57.5033	58.35	57.4333	58.08	277800.0
2009-02-05	BIL	ETF	91.74	91.78	91.7	91.74	121950.0
2009-02-05	BITS	ETF	20.0	20.96	19.152	20.6	1530.0
2009-02-05	BIV	ETF	76.32	77.14	76.26	76.56	120900.0
2009-02-05	BJK	ETF	15.42	15.42	15.42	15.42	200.0
2009-02-05	BKF	ETF	22.97	23.97	22.22	23.604	45710.0
2009-02-05	BLV	ETF	74.86	75.27	74.66	75.08	13700.0
2009-02-05	BMVP	ETF	10.18	10.46	10.15	10.38	40823.0
2009-02-05	BND	ETF	76.81	76.98	76.47	76.81	367500.0
2009-02-05	BNE	ETF	2.86	3.0	2.77	2.92	314597.0
2009-02-05	BSV	ETF	79.2	79.36	78.6	79.01	316200.0
2009-02-05	BTF	ETF	48.699999999999996	48.699999999999996	47.599999999999994	47.8005	5257.6
2009-02-05	BWX	ETF	25.075	25.25	25.055	25.24	203910.0
2009-02-05	BWZ	ETF	32.7	32.7	32.45	32.45	27600.0
2009-02-05	CBON	ETF	2.0	2.06	1.71	1.79	44196.0
2009-02-05	CDL	ETF	0.17	0.18	0.16	0.17	670182.0
2009-02-05	CEF	ETF	11.26	11.43	11.26	11.3	1018600.0
2009-02-05	CGO	ETF	10.03	10.03	9.92	9.98	21686.0
2009-02-05	CGW	ETF	13.15	13.42	13.0268	13.18	39835.0
2009-02-05	CHB	ETF	0.44	0.45	0.4	0.41	590037.0
2009-02-05	CHI	ETF	9.05	9.07	8.9	9.0	234690.0
2009-02-05	CHIC	ETF	4.88	5.11	4.88	5.06	301481.0
2009-02-05	CHW	ETF	6.25	6.39	6.16	6.3701	212820.0
2009-02-05	CHY	ETF	8.91	9.05	8.8	8.96	170996.0
2009-02-05	CMF	ETF	51.958	51.958	51.45	51.65	7842.0
2009-02-05	CNXT	ETF	0.61	0.64	0.6	0.6	253396.0

> showing 50 of 636 rows — these rows as CSV

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