PREVIEW / etf_daily / 2001-12-21

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-21.parquet
  size:    9 KB
  rows:    117

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-12-21	SPY	ETF	115.03	115.07	114.2	114.95	14037700.0
2001-12-21	QQQ	ETF	39.422	39.71	39.15	39.48	56205000.0
2001-12-21	IWM	ETF	47.45	48.24	47.205	48.1	1577800.0
2001-12-21	DIA	ETF	100.55	100.77	100.01	100.5	2951100.0
2001-12-21	ARB	ETF	31.3	31.9	31.3	31.7	236600.0
2001-12-21	BBH	ETF	44.1667	44.9167	43.9667	44.4967	4686900.0
2001-12-21	BITS	ETF	23.2	24.96	23.2	23.76	12050.0
2001-12-21	CEF	ETF	3.45	3.45	3.3	3.38	22600.0
2001-12-21	CHB	ETF	12.6	12.6	11.9	12.3	352900.0
2001-12-21	CNXT	ETF	13.94	13.94	12.95	13.23	9396990.0
2001-12-21	CSB	ETF	3.75	3.84999990463257	3.75	3.84999990463257	10500.0
2001-12-21	DGT	ETF	66.49	66.49	66.29	66.29	800.0
2001-12-21	EFA	ETF	39.0333	39.1567	38.9833	39.1567	901200.0
2001-12-21	ELV	ETF	23.4	23.4	22.625	22.875	2141900.0
2001-12-21	EPP	ETF	17.83	17.8767	17.8267	17.8767	8700.0
2001-12-21	EWA	ETF	9.15	9.33	9.15	9.21	15300.0
2001-12-21	EWC	ETF	10.75	10.95	10.71	10.95	21900.0
2001-12-21	EWD	ETF	12.97	12.97	12.97	12.97	400.0
2001-12-21	EWG	ETF	14.44	14.55	14.44	14.45	55900.0
2001-12-21	EWH	ETF	9.14	9.31	9.1	9.15	49000.0
2001-12-21	EWI	ETF	31.64	31.7	31.64	31.64	9350.0
2001-12-21	EWJ	ETF	31.12	31.36	31.0	31.24	95575.0
2001-12-21	EWK	ETF	10.51	10.52	10.51	10.52	10500.0
2001-12-21	EWL	ETF	12.42	12.59	12.36	12.37	2300.0
2001-12-21	EWM	ETF	19.6	19.84	19.6	19.6	6075.0
2001-12-21	EWN	ETF	16.46	16.64	16.46	16.46	2100.0
2001-12-21	EWO	ETF	7.3	7.35	7.3	7.33	1400.0
2001-12-21	EWP	ETF	20.36	20.49	20.27	20.36	7600.0
2001-12-21	EWQ	ETF	18.15	18.33	18.15	18.29	7800.0
2001-12-21	EWS	ETF	9.9	9.98	9.88	9.9	19300.0
2001-12-21	EWT	ETF	20.3	20.4	19.88	20.4	149450.0
2001-12-21	EWU	ETF	28.84	29.2	28.84	28.94	15600.0
2001-12-21	EWW	ETF	14.98	15.2	14.87	15.07	39500.0
2001-12-21	EWY	ETF	16.47	16.47	16.24	16.46	26600.0
2001-12-21	EWZ	ETF	12.0	12.24	11.9	12.24	3400.0
2001-12-21	EZU	ETF	27.075	27.235	26.93	27.225	5800.0
2001-12-21	FCTR	ETF	18.11	18.75	17.98	18.49	166400.0
2001-12-21	FMAR	ETF	9.2	9.2	9.02	9.05	6200.0
2001-12-21	GLDB	ETF	7.45	7.45	7.26	7.3	140700.0
2001-12-21	GSIG	ETF	7.2	7.71	7.2	7.54	316800.0
2001-12-21	IBB	ETF	30.45	31.0167	30.3367	30.85	77100.0
2001-12-21	ICF	ETF	20.81	20.8675	20.7025	20.8675	31600.0
2001-12-21	IDU	ETF	31.0	31.0	30.665	30.975	46400.0
2001-12-21	IEV	ETF	28.875	29.205	28.875	29.005	128600.0
2001-12-21	IGLD	ETF	89.0	93.0	89.0	92.0	199.0
2001-12-21	IGM	ETF	8.45	8.475	8.375	8.4417	135000.0
2001-12-21	IGN	ETF	30.15	30.15	29.64	29.87	210700.0
2001-12-21	IGV	ETF	9.12	9.17	9.084	9.124	67500.0
2001-12-21	IJH	ETF	9.95	10.041	9.933	10.033	445000.0
2001-12-21	IJJ	ETF	21.875	22.2125	21.875	22.1625	66400.0

> showing 50 of 117 rows — these rows as CSV

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