PREVIEW / etf_daily / 2001-10-23

all etf daily files

  file:    by_date/etf_daily/2001/2001-10-23.parquet
  size:    9 KB
  rows:    107

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
2001-10-23	SPY	ETF	109.96	110.28	108.38	108.91	22062500.0
2001-10-23	QQQ	ETF	34.822	35.401	34.0	34.63	104062200.0
2001-10-23	IWM	ETF	43.005	43.145	42.4	42.4	851600.0
2001-10-23	DIA	ETF	94.4	94.54	92.8	93.6	3764900.0
2001-10-23	ARB	ETF	28.1	28.15	27.5	27.77	84800.0
2001-10-23	BBH	ETF	41.8333	42.0	40.6667	41.0	5418900.0
2001-10-23	BITS	ETF	16.9108	17.6	16.2	16.9944	7350.0
2001-10-23	CEF	ETF	3.41	3.42	3.41	3.41	8800.0
2001-10-23	CHB	ETF	7.16	7.69	7.15	7.6	367000.0
2001-10-23	CNXT	ETF	10.65	11.1	10.58	10.8	6321200.0
2001-10-23	CSB	ETF	3.90000009536743	3.90000009536743	3.90000009536743	3.90000009536743	1000.0
2001-10-23	DGT	ETF	64.4	64.76	64.4	64.76	2100.0
2001-10-23	EFA	ETF	38.9667	39.1	38.84	38.84	159300.0
2001-10-23	EWA	ETF	8.82	8.82	8.73	8.81	25000.0
2001-10-23	EWC	ETF	10.04	10.04	9.85	9.85	2900.0
2001-10-23	EWD	ETF	11.98	11.99	11.8	11.8	6000.0
2001-10-23	EWG	ETF	13.55	13.55	13.31	13.31	53700.0
2001-10-23	EWH	ETF	8.12	8.24	8.03	8.03	111600.0
2001-10-23	EWI	ETF	31.7	31.7	31.32	31.7	2650.0
2001-10-23	EWJ	ETF	34.8	35.0	34.56	34.6	121250.0
2001-10-23	EWK	ETF	10.43	10.43	10.43	10.43	900.0
2001-10-23	EWL	ETF	12.4	12.4	12.21	12.37	7400.0
2001-10-23	EWM	ETF	17.72	18.08	17.72	18.08	4100.0
2001-10-23	EWN	ETF	16.05	16.4	16.05	16.4	2300.0
2001-10-23	EWO	ETF	6.87	6.87	6.87	6.87	2100.0
2001-10-23	EWP	ETF	19.45	19.47	19.45	19.47	700.0
2001-10-23	EWQ	ETF	17.82	17.95	17.8	17.81	3800.0
2001-10-23	EWS	ETF	8.96	9.1	8.96	8.98	11800.0
2001-10-23	EWT	ETF	15.58	15.6	15.2	15.2	44150.0
2001-10-23	EWU	ETF	28.56	28.94	28.5	28.6	20050.0
2001-10-23	EWW	ETF	13.45	13.45	13.25	13.34	14300.0
2001-10-23	EWY	ETF	12.5	12.5	12.41	12.41	1500.0
2001-10-23	EWZ	ETF	9.55	9.94	9.55	9.83	7600.0
2001-10-23	EZU	ETF	26.2	26.245	25.925	25.925	66200.0
2001-10-23	FCTR	ETF	17.88	17.88	17.3	17.5	25000.0
2001-10-23	FMAR	ETF	7.9	8.0	7.9	7.9	26200.0
2001-10-23	GLDB	ETF	7.54	7.65	7.42	7.65	66700.0
2001-10-23	GSIG	ETF	7.4	7.85	7.4	7.66	59100.0
2001-10-23	IBB	ETF	29.0	29.0	28.2	28.2	137400.0
2001-10-23	ICF	ETF	19.8375	19.8375	19.675	19.675	12800.0
2001-10-23	IDU	ETF	33.725	33.74	33.165	33.215	3600.0
2001-10-23	IEV	ETF	28.245	28.245	27.89	28.085	24600.0
2001-10-23	IGLD	ETF	78.0	78.0	72.0	75.0	187.0
2001-10-23	IGM	ETF	7.5	7.5167	7.4167	7.4417	18000.0
2001-10-23	IGN	ETF	29.8	30.0	29.4	29.4	6700.0
2001-10-23	IGV	ETF	7.57	7.678	7.46	7.46	49000.0
2001-10-23	IJH	ETF	9.16	9.205	9.07	9.089	294000.0
2001-10-23	IJJ	ETF	20.445	20.5475	20.35	20.3875	22000.0
2001-10-23	IJK	ETF	12.6875	12.825	12.5488	12.61	61600.0
2001-10-23	IJR	ETF	16.9667	16.99	16.7333	16.7333	729600.0

> showing 50 of 107 rows — these rows as CSV

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