PREVIEW / etf_daily / 2001-11-05

all etf daily files

  file:    by_date/etf_daily/2001/2001-11-05.parquet
  size:    9 KB
  rows:    112

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-11-05	SPY	ETF	110.12	111.09	109.95	110.68	15929500.0
2001-11-05	QQQ	ETF	36.26	37.16	36.16	36.76	64469300.0
2001-11-05	IWM	ETF	43.6	43.65	43.31	43.625	305600.0
2001-11-05	DIA	ETF	94.25	94.87	94.1	94.5	2273500.0
2001-11-05	ARB	ETF	28.6	28.78	28.25	28.35	43100.0
2001-11-05	BBH	ETF	43.1533	44.2	43.1533	44.0	2055000.0
2001-11-05	BITS	ETF	16.0	16.2	15.64	15.84	975.0
2001-11-05	CEF	ETF	3.42	3.44	3.35	3.38	16900.0
2001-11-05	CHB	ETF	9.0	10.08	9.0	9.71	182500.0
2001-11-05	CNXT	ETF	11.4	12.48	11.35	12.39	8358360.0
2001-11-05	CSB	ETF	3.84999990463257	3.90000009536743	3.79999995231628	3.90000009536743	3900.0
2001-11-05	DGT	ETF	65.56	65.56	65.56	65.56	200.0
2001-11-05	EFA	ETF	39.1333	39.5533	39.1333	39.4667	168600.0
2001-11-05	ELV	ETF	21.75	21.75	21.375	21.445	1381900.0
2001-11-05	EPP	ETF	16.6333	16.6667	16.6333	16.6667	2400.0
2001-11-05	EWA	ETF	8.86	8.86	8.85	8.85	5400.0
2001-11-05	EWC	ETF	9.85	9.87	9.85	9.87	8400.0
2001-11-05	EWD	ETF	12.02	12.2	11.96	12.2	6200.0
2001-11-05	EWG	ETF	13.55	13.74	13.55	13.7	14300.0
2001-11-05	EWH	ETF	8.15	8.29	8.15	8.29	24800.0
2001-11-05	EWI	ETF	31.22	31.84	31.22	31.84	4550.0
2001-11-05	EWJ	ETF	33.96	34.24	33.96	34.12	45550.0
2001-11-05	EWK	ETF	11.0	11.0	10.75	10.75	30200.0
2001-11-05	EWL	ETF	12.25	12.44	12.25	12.44	2500.0
2001-11-05	EWM	ETF	17.6	17.6	17.28	17.28	3900.0
2001-11-05	EWN	ETF	16.55	16.8	16.55	16.8	2500.0
2001-11-05	EWO	ETF	6.79	6.79	6.79	6.79	7500.0
2001-11-05	EWP	ETF	19.75	19.89	19.6	19.89	300.0
2001-11-05	EWQ	ETF	18.2	18.3	18.13	18.2	3600.0
2001-11-05	EWS	ETF	8.46	8.6	8.42	8.6	9550.0
2001-11-05	EWT	ETF	16.0	16.5	16.0	16.4	7500.0
2001-11-05	EWU	ETF	29.3	29.7	29.3	29.62	20400.0
2001-11-05	EWW	ETF	13.73	13.73	13.45	13.5	2500.0
2001-11-05	EWY	ETF	13.7	13.7	13.51	13.69	6200.0
2001-11-05	EWZ	ETF	10.21	10.59	10.05	10.59	21500.0
2001-11-05	EZU	ETF	26.525	26.745	26.5	26.555	46800.0
2001-11-05	FCTR	ETF	16.98	17.65	16.98	17.54	30600.0
2001-11-05	FMAR	ETF	8.0	8.0	7.95	8.0	33500.0
2001-11-05	GLDB	ETF	7.49	7.52	7.31	7.45	150900.0
2001-11-05	GRNB	ETF	16.6882	16.6882	16.6882	16.6882	1413.0
2001-11-05	GSIG	ETF	7.7	8.03	7.7	7.85	23700.0
2001-11-05	IBB	ETF	29.1	29.5667	29.0	29.5	314100.0
2001-11-05	ICF	ETF	20.1375	20.1475	20.05	20.055	33200.0
2001-11-05	IDU	ETF	32.425	32.56	32.395	32.5	5400.0
2001-11-05	IEV	ETF	28.575	28.85	28.575	28.82	184400.0
2001-11-05	IGLD	ETF	73.0	80.0	73.0	74.0	106.0
2001-11-05	IGM	ETF	7.7917	7.95	7.7917	7.95	143400.0
2001-11-05	IGN	ETF	30.3	30.3	30.29	30.29	600.0
2001-11-05	IGV	ETF	7.88	7.97	7.86	7.912	16500.0
2001-11-05	IJH	ETF	9.325	9.331	9.27	9.314	65000.0

> showing 50 of 112 rows — these rows as CSV

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