PREVIEW / etf_daily / 2009-03-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-03-02.parquet
  size:    28 KB
  rows:    640

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-02	SPY	ETF	72.52	73.92	70.37	70.6	426452600.0
2009-03-02	QQQ	ETF	27.12	27.51	26.47	26.64	188175935.0
2009-03-02	IWM	ETF	38.26	38.42	36.82	36.94	83622800.0
2009-03-02	DIA	ETF	69.65	69.82	67.59	67.83	36931600.0
2009-03-02	GLD	ETF	93.4	93.61	90.62	90.93	24269300.0
2009-03-02	TLT	ETF	102.22	103.28	102.09	103.28	3302000.0
2009-03-02	AAXJ	ETF	28.83	28.83	26.69	26.7	96200.0
2009-03-02	ACWI	ETF	25.4	25.4	24.48	24.49	60800.0
2009-03-02	ACWX	ETF	23.46	23.49	22.6	22.66	128077.0
2009-03-02	ADRE	ETF	23.99	24.09	22.98	23.01	402421.0
2009-03-02	AFK	ETF	18.08	18.08	17.44	17.49	1556.0
2009-03-02	AGG	ETF	100.7	100.82	100.3	100.7	627400.0
2009-03-02	AGQ	ETF	82.18	82.44	76.3	79.6	138150.0
2009-03-02	AGZ	ETF	107.55	107.79	107.26	107.72	15009.0
2009-03-02	AIA	ETF	21.1	21.23	20.46	20.46	11624.0
2009-03-02	AIQ	ETF	40.3	40.95	37.7	37.9	50344.0
2009-03-02	AIS	ETF	0.37	0.43	0.37	0.4	126001.0
2009-03-02	AIVI	ETF	25.76	25.76	24.46	24.49	79700.0
2009-03-02	AOA	ETF	19.96	19.96	19.47	19.47	3700.0
2009-03-02	AOK	ETF	24.36	24.36	23.2	24.01	5100.0
2009-03-02	AOM	ETF	22.8644	23.7299	21.81	22.56	6309.0
2009-03-02	AOR	ETF	21.34	21.38	21.2	21.2	869.0
2009-03-02	ARB	ETF	12.56	13.06	12.08	12.25	263206.0
2009-03-02	BAL	ETF	24.0501	24.0501	23.56	23.602	1600.0
2009-03-02	BBH	ETF	53.73	53.74	52.3267	52.41	1043100.0
2009-03-02	BIL	ETF	91.76	91.8	91.72	91.78	325450.0
2009-03-02	BITS	ETF	17.8	17.8	15.8	17.36	869.0
2009-03-02	BIV	ETF	75.71	75.93	75.42	75.72	186300.0
2009-03-02	BJK	ETF	13.86	13.86	13.2	13.71	600.0
2009-03-02	BKF	ETF	20.88	21.09	20.09	20.12	44511.0
2009-03-02	BLV	ETF	72.52	72.74	71.65	71.93	52200.0
2009-03-02	BMVP	ETF	9.03	9.05	8.77	8.78	101875.0
2009-03-02	BND	ETF	76.29	76.59	76.2	76.44	759200.0
2009-03-02	BNE	ETF	1.57	1.57	1.4	1.46	185111.0
2009-03-02	BSV	ETF	78.56	78.84	78.42	78.54	226600.0
2009-03-02	BTF	ETF	37.2	37.25	35.199999999999996	35.199999999999996	21322.2
2009-03-02	BWX	ETF	24.305	24.3696	24.225	24.285	363872.0
2009-03-02	BWZ	ETF	31.43	31.43	31.36	31.36	473.0
2009-03-02	CBON	ETF	0.9	0.92	0.52	0.58	29298.0
2009-03-02	CDL	ETF	0.1118	0.1118	0.09	0.09	1672126.0
2009-03-02	CEF	ETF	12.0	12.0	11.42	11.51	1876900.0
2009-03-02	CGO	ETF	8.35	8.35	7.5175	7.68	50526.0
2009-03-02	CGW	ETF	11.09	11.54	10.8	10.84	183625.0
2009-03-02	CHB	ETF	0.29	0.32	0.26	0.27	503119.0
2009-03-02	CHI	ETF	7.79	7.79	7.03	7.18	347195.0
2009-03-02	CHIC	ETF	5.18	5.24	4.87	4.88	136984.0
2009-03-02	CHW	ETF	4.73	4.8	4.29	4.48	425815.0
2009-03-02	CHY	ETF	7.7	7.7994	7.0	7.39	567227.0
2009-03-02	CMF	ETF	51.335	51.43	51.05	51.05	9808.0
2009-03-02	CNXT	ETF	0.43	0.43	0.26	0.3199	719014.0

> showing 50 of 640 rows — these rows as CSV

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