PREVIEW / etf_daily / 2001-11-07

all etf daily files

  file:    by_date/etf_daily/2001/2001-11-07.parquet
  size:    9 KB
  rows:    110

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-07	SPY	ETF	111.77	113.12	111.64	112.25	19716000.0
2001-11-07	QQQ	ETF	37.61	38.84	37.5	38.19	92562500.0
2001-11-07	IWM	ETF	43.85	44.325	43.805	43.95	584200.0
2001-11-07	DIA	ETF	95.38	96.6	95.26	95.75	2955300.0
2001-11-07	ARB	ETF	27.8	28.35	27.77	28.25	55500.0
2001-11-07	BBH	ETF	44.81	45.3333	44.1	44.3	3959100.0
2001-11-07	BITS	ETF	16.6	16.84	16.0	16.4	8025.0
2001-11-07	CEF	ETF	3.54	3.54	3.33	3.34	13000.0
2001-11-07	CHB	ETF	9.8	10.1	9.8	9.95	218500.0
2001-11-07	CNXT	ETF	12.69	13.7	12.67	13.19	9510800.0
2001-11-07	DGT	ETF	66.0	66.41	66.0	66.41	1000.0
2001-11-07	EFA	ETF	39.3	39.6333	39.2667	39.5167	352200.0
2001-11-07	ELV	ETF	21.875	21.875	21.245	21.625	1337600.0
2001-11-07	EWA	ETF	9.05	9.05	8.95	9.0	31300.0
2001-11-07	EWC	ETF	10.25	10.25	10.08	10.17	30300.0
2001-11-07	EWD	ETF	12.36	12.36	12.3	12.3	1600.0
2001-11-07	EWG	ETF	13.76	13.95	13.76	13.87	16600.0
2001-11-07	EWH	ETF	7.97	8.1	7.96	8.01	59800.0
2001-11-07	EWI	ETF	31.1	31.42	31.06	31.32	950.0
2001-11-07	EWJ	ETF	33.52	33.76	33.4	33.52	64025.0
2001-11-07	EWK	ETF	10.74	10.74	10.74	10.74	200.0
2001-11-07	EWL	ETF	12.3	12.56	12.3	12.56	2200.0
2001-11-07	EWM	ETF	17.16	17.36	17.16	17.16	2625.0
2001-11-07	EWN	ETF	16.79	16.81	16.61	16.8	600.0
2001-11-07	EWP	ETF	19.9	20.1	19.9	20.1	3700.0
2001-11-07	EWQ	ETF	18.16	18.3	18.06	18.29	10400.0
2001-11-07	EWS	ETF	8.42	8.54	8.32	8.48	35750.0
2001-11-07	EWT	ETF	16.5	17.04	16.5	16.86	62900.0
2001-11-07	EWU	ETF	29.6	29.9	29.46	29.8	10650.0
2001-11-07	EWW	ETF	13.46	13.7	13.46	13.51	16700.0
2001-11-07	EWY	ETF	13.7	13.81	13.66	13.8	3000.0
2001-11-07	EWZ	ETF	10.5	11.22	10.5	11.0	44100.0
2001-11-07	EZU	ETF	26.375	26.915	26.375	26.745	18000.0
2001-11-07	FCTR	ETF	17.4149	17.9	17.28	17.28	11100.0
2001-11-07	FMAR	ETF	8.093	8.097	8.093	8.097	1100.0
2001-11-07	GLDB	ETF	7.4	7.59	7.4	7.44	51000.0
2001-11-07	GSIG	ETF	8.23	8.95	8.2	8.78	238200.0
2001-11-07	IBB	ETF	29.9	30.35	29.6267	29.6667	408600.0
2001-11-07	ICF	ETF	20.3125	20.4075	20.285	20.3725	5600.0
2001-11-07	IDU	ETF	32.625	32.625	32.2	32.2	5000.0
2001-11-07	IEV	ETF	28.925	29.14	28.875	29.05	31400.0
2001-11-07	IGLD	ETF	75.0	84.0	73.0	84.0	2005.0
2001-11-07	IGM	ETF	8.125	8.3083	8.125	8.125	544200.0
2001-11-07	IGN	ETF	30.6	31.67	30.6	30.85	25800.0
2001-11-07	IGV	ETF	8.138	8.436	8.138	8.306	22000.0
2001-11-07	IJH	ETF	9.42	9.498	9.401	9.436	949000.0
2001-11-07	IJJ	ETF	20.875	21.035	20.8725	20.9	89600.0
2001-11-07	IJK	ETF	13.19	13.3312	13.19	13.225	1102400.0
2001-11-07	IJR	ETF	17.3083	17.4183	17.255	17.3167	747600.0
2001-11-07	IJS	ETF	19.1	19.2225	19.0525	19.1475	168800.0

> showing 50 of 110 rows — these rows as CSV

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