PREVIEW / etf_daily / 2005-03-02

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-02.parquet
  size:    14 KB
  rows:    252

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
2005-03-02	SPY	ETF	120.76	121.93	120.65	121.17	64226500.0
2005-03-02	QQQ	ETF	37.42	38.02	37.356	37.61	107985175.0
2005-03-02	IWM	ETF	63.355	64.13	63.25	63.51	21102400.0
2005-03-02	DIA	ETF	107.81	108.69	107.74	108.07	7239700.0
2005-03-02	GLD	ETF	43.16	43.35	43.08	43.25	1188000.0
2005-03-02	TLT	ETF	89.45	89.72	89.42	89.59	1139300.0
2005-03-02	AAA	ETF	62.72	63.2	62.72	63.14	2800.0
2005-03-02	ADRE	ETF	90.0	90.42	89.666	90.24	5076.0
2005-03-02	AFK	ETF	26.3	26.3	26.25	26.25	600.0
2005-03-02	AGG	ETF	101.61	101.89	101.61	101.72	171000.0
2005-03-02	AIQ	ETF	55.4	58.5	54.5	57.85	68840.0
2005-03-02	ARB	ETF	40.8	41.25	40.5	40.6	188300.0
2005-03-02	BAB	ETF	52.4	53.16	52.22	52.84	38600.0
2005-03-02	BBH	ETF	45.65	46.7733	45.65	45.9267	5053500.0
2005-03-02	BCM	ETF	56.04	56.83	56.04	56.77	33000.0
2005-03-02	BIS	ETF	800.0	800.0	784.0	798.4	248.0
2005-03-02	BITS	ETF	11.6	11.6	10.04	10.36	43728.0
2005-03-02	BKF	ETF	42.07	42.15	41.8	42.15	14600.0
2005-03-02	BNE	ETF	16.11	16.16	15.78	15.82	227000.0
2005-03-02	BOSS	ETF	23.53	23.81	23.53	23.81	100.0
2005-03-02	BRF	ETF	15.81	15.84	15.79	15.84	2600.0
2005-03-02	BTF	ETF	90.6	90.99999999999999	90.55	90.99999999999999	860.0
2005-03-02	CBON	ETF	27.1	27.1	26.74	26.98	7400.0
2005-03-02	CDC	ETF	10.25	10.25	10.05	10.11	4900.0
2005-03-02	CDL	ETF	14.3	14.53	14.25	14.25	586500.0
2005-03-02	CEF	ETF	5.56	5.58	5.52	5.55	153800.0
2005-03-02	CEW	ETF	26.94	26.94	26.8	26.8	2500.0
2005-03-02	CGW	ETF	29.7	29.98	29.6	29.6	77500.0
2005-03-02	CHB	ETF	10.46	10.49	10.21	10.32	613500.0
2005-03-02	CHIC	ETF	12.2	12.7	12.1	12.35	716339.0
2005-03-02	CHIR	ETF	35.4201	41.1	35.1	37.6899	15479098.0
2005-03-02	CID	ETF	9.44	9.5	9.44	9.44	1800.0
2005-03-02	CIL	ETF	26.26	26.3	26.25	26.3	2600.0
2005-03-02	CN	ETF	28.72	28.79	28.68	28.71	15700.0
2005-03-02	CNXT	ETF	1.76	1.81	1.73	1.8	7926850.0
2005-03-02	CPI	ETF	18.3	18.5	18.3	18.5	700.0
2005-03-02	CSB	ETF	34.8	35.3	34.8	35.3	13300.0
2005-03-02	CTEC	ETF	55.05	56.449999999999996	54.105	55.05	7977.400000000001
2005-03-02	CURE	ETF	0.4313	0.495	0.425	0.4725	7145752.0
2005-03-02	CYA	ETF	206.8	207.6	204.0	204.0	245.0
2005-03-02	CYB	ETF	3.65	3.73	3.6	3.73	9000.0
2005-03-02	CZA	ETF	10.37	10.37	10.37	10.37	1100.0
2005-03-02	DGT	ETF	65.7	65.77	65.44	65.51	6000.0
2005-03-02	DIV	ETF	14.15	14.15	14.11	14.13	19100.0
2005-03-02	DJP	ETF	27.01	27.06	27.01	27.03	400.0
2005-03-02	DRIV	ETF	28.87	30.0	28.18	29.32	871739.0
2005-03-02	DSI	ETF	6.0	6.025	5.975	6.025	12000.0
2005-03-02	DUSA	ETF	13.14	13.14	12.46	12.85	331958.0
2005-03-02	DVY	ETF	61.05	61.57	61.05	61.4	371800.0
2005-03-02	EDEN	ETF	0.75	0.77	0.74	0.75	127650.0

> showing 50 of 252 rows — these rows as CSV

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