PREVIEW / etf_daily / 2009-03-23

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-23.parquet
  size:    28 KB
  rows:    646

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-03-23	SPY	ETF	78.74	82.29	78.31	82.22	419933300.0
2009-03-23	QQQ	ETF	29.86	30.94	29.1984	30.9	179642565.0
2009-03-23	IWM	ETF	41.34	43.52	40.93	43.38	94771600.0
2009-03-23	DIA	ETF	74.55	77.78	74.17	77.76	25706800.0
2009-03-23	GLD	ETF	93.44	93.91	91.95	92.08	17652600.0
2009-03-23	TLT	ETF	104.29	104.42	102.97	103.02	2097000.0
2009-03-23	AAXJ	ETF	34.9	35.0	32.71	34.2	344500.0
2009-03-23	ACWI	ETF	28.39	29.59	27.33	29.59	149800.0
2009-03-23	ACWX	ETF	26.73	27.83	26.73	27.83	76109.0
2009-03-23	ADRE	ETF	28.05	29.02	27.8435	28.96	258638.0
2009-03-23	AFK	ETF	20.54	21.19	20.27	20.6	1400.0
2009-03-23	AGG	ETF	101.44	101.49	101.17	101.33	518100.0
2009-03-23	AGQ	ETF	88.64	90.4	86.7	86.98	180400.0
2009-03-23	AGZ	ETF	108.18	112.46	107.66	107.9	164533.0
2009-03-23	AIA	ETF	25.35	26.22	25.23	26.22	26568.0
2009-03-23	AIQ	ETF	33.6	35.95	33.35	35.4	36978.0
2009-03-23	AIS	ETF	0.47	0.47	0.4	0.42	126472.0
2009-03-23	AIVI	ETF	28.46	29.82	28.46	29.82	15000.0
2009-03-23	AOA	ETF	21.9	22.41	21.57	22.41	15100.0
2009-03-23	AOK	ETF	24.83	24.95	24.8299	24.95	2438.0
2009-03-23	AOM	ETF	24.88	25.03	23.91	24.33	8758.0
2009-03-23	AOR	ETF	22.87	23.47	22.87	23.47	11422.0
2009-03-23	ARB	ETF	12.88	13.82	12.83	13.5	308371.0
2009-03-23	BAL	ETF	25.58	25.88	25.58	25.88	22400.0
2009-03-23	BBH	ETF	57.2567	58.05	56.97	58.0167	422700.0
2009-03-23	BIL	ETF	91.76	91.76	91.7	91.76	165300.0
2009-03-23	BITS	ETF	18.12	18.56	16.88	18.56	2106.0
2009-03-23	BIV	ETF	76.9	77.08	76.22	76.26	210900.0
2009-03-23	BJK	ETF	17.44	17.44	15.42	15.45	6200.0
2009-03-23	BKF	ETF	26.19	26.39	24.88	26.37	91458.0
2009-03-23	BLV	ETF	73.36	73.93	73.04	73.15	22100.0
2009-03-23	BMVP	ETF	9.63	10.07	9.63	10.07	35515.0
2009-03-23	BND	ETF	77.1	77.17	76.82	76.82	335100.0
2009-03-23	BNE	ETF	2.88	3.74	2.85	3.74	833976.0
2009-03-23	BSV	ETF	78.5	78.7	78.45	78.6	140200.0
2009-03-23	BTF	ETF	39.24999999999999	41.3	39.148999999999994	41.3	10898.400000000001
2009-03-23	BWX	ETF	26.05	26.2	25.9682	26.19	331962.0
2009-03-23	BWZ	ETF	33.26	33.425	33.26	33.41	1269.0
2009-03-23	CBON	ETF	1.24	1.4101	1.15	1.25	31329.0
2009-03-23	CEF	ETF	12.54	12.68	12.42	12.49	2675800.0
2009-03-23	CGO	ETF	8.75	9.2	8.75	9.1676	19427.0
2009-03-23	CGW	ETF	11.97	12.5	11.9301	12.39	59174.0
2009-03-23	CHB	ETF	0.2648	0.37	0.25	0.36	3252337.0
2009-03-23	CHI	ETF	8.39	8.58	8.29	8.58	178776.0
2009-03-23	CHIC	ETF	6.91	7.58	6.8	7.58	341395.0
2009-03-23	CHW	ETF	5.27	5.62	5.24	5.61	229215.0
2009-03-23	CHY	ETF	8.09	8.25	7.99	8.25	200274.0
2009-03-23	CMF	ETF	51.595	53.5	51.595	51.92	17762.0
2009-03-23	CNXT	ETF	0.72	0.72	0.65	0.7097	236042.0
2009-03-23	COW	ETF	31.4	31.6	31.1301	31.3199	39177.0

> showing 50 of 646 rows — these rows as CSV

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