PREVIEW / etf_daily / 2001-09-20

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-20.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-09-20	SPY	ETF	100.4	101.81	98.56	98.71	36210900.0
2001-09-20	QQQ	ETF	29.3	30.09	28.8	28.97	90841700.0
2001-09-20	IWM	ETF	39.55	39.65	38.3	38.555	732000.0
2001-09-20	DIA	ETF	86.5	86.9	83.5	83.65	10182100.0
2001-09-20	BBH	ETF	34.7567	36.4667	34.66	36.0	6044400.0
2001-09-20	BITS	ETF	10.36	10.8028	9.92	10.4	16025.0
2001-09-20	CEF	ETF	3.5	3.64	3.46	3.59	31700.0
2001-09-20	CHB	ETF	6.75	6.9	6.5	6.5	314900.0
2001-09-20	CNXT	ETF	8.46	9.17	8.24	8.33	4789700.0
2001-09-20	CSB	ETF	2.90000009536743	2.90000009536743	2.90000009536743	2.90000009536743	42400.0
2001-09-20	DGT	ETF	59.1	59.1	57.7	57.7	1400.0
2001-09-20	EFA	ETF	35.7667	35.7667	35.15	35.15	123000.0
2001-09-20	EWA	ETF	7.95	7.95	7.71	7.85	19900.0
2001-09-20	EWC	ETF	9.6	9.75	9.3	9.5	18500.0
2001-09-20	EWD	ETF	10.35	10.35	10.0	10.0	4700.0
2001-09-20	EWG	ETF	11.75	11.8	11.1	11.15	99800.0
2001-09-20	EWH	ETF	7.4	7.4	7.1	7.1	42200.0
2001-09-20	EWI	ETF	27.0	27.0	26.3	26.3	8250.0
2001-09-20	EWJ	ETF	33.2	33.4	32.04	32.72	102275.0
2001-09-20	EWK	ETF	9.7	9.7	9.7	9.7	2000.0
2001-09-20	EWL	ETF	11.5	11.5	11.0	11.01	14100.0
2001-09-20	EWM	ETF	17.4	18.0	16.88	17.6	17025.0
2001-09-20	EWN	ETF	14.65	14.65	14.45	14.45	7400.0
2001-09-20	EWO	ETF	7.35	7.35	7.0	7.3	20700.0
2001-09-20	EWP	ETF	17.25	17.5	17.2	17.2	11800.0
2001-09-20	EWQ	ETF	16.2	16.2	15.65	15.8	29800.0
2001-09-20	EWS	ETF	8.56	8.58	8.4	8.58	13050.0
2001-09-20	EWT	ETF	14.8	14.8	14.32	14.54	3150.0
2001-09-20	EWU	ETF	26.48	26.48	25.5	25.8	29350.0
2001-09-20	EWW	ETF	12.2	12.2	11.75	11.9	97500.0
2001-09-20	EWY	ETF	11.27	11.3	10.81	10.81	11500.0
2001-09-20	EWZ	ETF	9.47	9.47	9.07	9.07	135800.0
2001-09-20	EZU	ETF	22.85	23.125	22.69	22.755	18000.0
2001-09-20	FCTR	ETF	16.37	16.6	16.03	16.15	32000.0
2001-09-20	FMAR	ETF	8.5	8.7	8.22	8.7	1000.0
2001-09-20	GLDB	ETF	7.35	7.49	7.25	7.49	221200.0
2001-09-20	GSIG	ETF	6.36	6.6	6.25	6.5	99600.0
2001-09-20	IBB	ETF	23.0	24.1667	23.0	23.9	290100.0
2001-09-20	ICF	ETF	20.525	20.525	20.115	20.115	29200.0
2001-09-20	IDU	ETF	33.875	34.65	33.875	34.55	5400.0
2001-09-20	IEV	ETF	25.5	25.55	24.95	25.2	82600.0
2001-09-20	IGLD	ETF	53.0	70.0	53.0	70.0	4.0
2001-09-20	IGM	ETF	6.3	6.4167	6.2833	6.3333	24000.0
2001-09-20	IGN	ETF	24.9	25.05	24.5	24.85	20700.0
2001-09-20	IGV	ETF	6.136	6.142	6.03	6.03	83500.0
2001-09-20	IJH	ETF	8.425	8.46	8.231	8.278	686000.0
2001-09-20	IJJ	ETF	19.4125	19.5	18.8375	18.875	156400.0
2001-09-20	IJK	ETF	11.3625	11.375	11.1062	11.1375	47200.0
2001-09-20	IJR	ETF	15.5833	15.6667	15.225	15.25	1080600.0
2001-09-20	IJS	ETF	17.625	17.7025	17.135	17.1625	163600.0

> showing 50 of 107 rows — these rows as CSV

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