PREVIEW / etf_daily / 2009-03-09

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-09.parquet
  size:    28 KB
  rows:    637

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-09	SPY	ETF	67.95	70.0	67.73	68.11	379905300.0
2009-03-09	QQQ	ETF	26.05	26.81	25.6301	25.74	181154015.0
2009-03-09	IWM	ETF	34.73	35.64	34.26	34.39	75737000.0
2009-03-09	DIA	ETF	65.51	67.17	65.25	65.44	28114400.0
2009-03-09	GLD	ETF	92.29	92.33	89.57	90.57	18311100.0
2009-03-09	TLT	ETF	104.51	104.55	103.12	103.65	2070500.0
2009-03-09	AAXJ	ETF	27.57	28.17	27.5	27.64	29200.0
2009-03-09	ACWI	ETF	23.74	24.42	23.67	23.93	167000.0
2009-03-09	ACWX	ETF	22.11	22.62	22.0	22.23	83654.0
2009-03-09	ADRE	ETF	23.72	24.41	23.59	23.72	292289.0
2009-03-09	AFK	ETF	17.52	17.78	17.47	17.4901	1614.0
2009-03-09	AGG	ETF	100.71	100.71	100.01	100.01	645300.0
2009-03-09	AGQ	ETF	88.66	88.72	76.94	79.02	289000.0
2009-03-09	AGZ	ETF	107.34	107.76	107.12	107.76	22764.0
2009-03-09	AIA	ETF	21.07	21.82	21.07	21.18	25588.0
2009-03-09	AIQ	ETF	37.3	37.55	34.55	34.6	59339.0
2009-03-09	AIS	ETF	0.36	0.39	0.36	0.39	25600.0
2009-03-09	AIVI	ETF	22.94	23.39	22.94	23.11	130600.0
2009-03-09	AOA	ETF	18.46	19.21	18.46	18.92	5200.0
2009-03-09	AOK	ETF	24.29	24.29	23.44	23.66	11167.0
2009-03-09	AOM	ETF	23.16	23.16	22.075	22.3	4800.0
2009-03-09	AOR	ETF	21.8	21.8	20.86	20.86	14429.0
2009-03-09	ARB	ETF	12.48	12.79	11.65	11.83	312446.0
2009-03-09	BBH	ETF	54.31	55.2767	53.3	55.0433	1068000.0
2009-03-09	BIL	ETF	91.8	91.8	91.74	91.76	258650.0
2009-03-09	BITS	ETF	16.64	16.64	16.0	16.52	2274.0
2009-03-09	BIV	ETF	75.49	75.5	74.87	75.14	60900.0
2009-03-09	BJK	ETF	13.99	13.99	11.36	12.82	44700.0
2009-03-09	BKF	ETF	20.65	21.5	20.65	20.9101	13111.0
2009-03-09	BLV	ETF	72.97	72.97	72.0	72.67	13700.0
2009-03-09	BMVP	ETF	8.5833	8.7833	8.5363	8.5667	32476.0
2009-03-09	BND	ETF	76.33	76.35	75.82	75.92	754100.0
2009-03-09	BNE	ETF	1.41	1.49	1.13	1.28	238362.0
2009-03-09	BOSS	ETF	8.71	9.0	8.71	9.0	100.0
2009-03-09	BSV	ETF	78.16	78.2	77.85	78.07	238400.0
2009-03-09	BTF	ETF	31.6	33.3	31.499999999999996	32.99999999999999	40415.600000000006
2009-03-09	BWX	ETF	24.125	24.345	24.125	24.275	269054.0
2009-03-09	BWZ	ETF	31.27	31.27	31.27	31.27	200.0
2009-03-09	CBON	ETF	0.7172	0.8	0.716	0.8	5713.0
2009-03-09	CEF	ETF	11.93	12.08	11.52	11.68	919600.0
2009-03-09	CGO	ETF	7.27	7.4919	7.17	7.2001	36402.0
2009-03-09	CGW	ETF	10.35	10.5756	10.16	10.33	187157.0
2009-03-09	CHB	ETF	0.2	0.22	0.19	0.19	463305.0
2009-03-09	CHI	ETF	6.3	6.63	6.27	6.53	287267.0
2009-03-09	CHIC	ETF	5.47	5.82	5.19	5.54	370981.0
2009-03-09	CHW	ETF	4.14	4.32	4.07	4.07	334042.0
2009-03-09	CHY	ETF	6.3	6.56	6.22	6.37	505211.0
2009-03-09	CMF	ETF	50.995	50.995	50.525	50.5625	17444.0
2009-03-09	CNXT	ETF	0.35	0.36	0.34	0.35	44264.0
2009-03-09	COW	ETF	30.79	31.15	30.73	31.15	13770.0

> showing 50 of 637 rows — these rows as CSV

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