PREVIEW / etf_daily / 2001-09-21

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-21.parquet
  size:    9 KB
  rows:    105

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-21	SPY	ETF	94.28	98.99	93.8	97.28	49782100.0
2001-09-21	QQQ	ETF	27.41	28.97	27.2	28.19	112296900.0
2001-09-21	IWM	ETF	37.25	38.025	36.75	37.83	1011200.0
2001-09-21	DIA	ETF	80.05	85.0	79.5	82.8	12533400.0
2001-09-21	BBH	ETF	34.15	35.4167	33.77	34.35	6678600.0
2001-09-21	BITS	ETF	10.44	10.44	9.92	10.4	3750.0
2001-09-21	CEF	ETF	3.69	3.8	3.55	3.57	109400.0
2001-09-21	CHB	ETF	6.5	6.64	6.25	6.5	141800.0
2001-09-21	CNXT	ETF	8.16	8.6	7.77	8.31	4352660.0
2001-09-21	CSB	ETF	2.79999995231628	2.90000009536743	2.70000004768372	2.70000004768372	71500.0
2001-09-21	DGT	ETF	55.3	57.65	55.3	55.75	1900.0
2001-09-21	EFA	ETF	32.6667	34.5	32.6667	34.1667	110100.0
2001-09-21	EWA	ETF	7.7	7.75	7.5	7.6	18000.0
2001-09-21	EWC	ETF	8.75	9.5	8.7	9.5	12600.0
2001-09-21	EWD	ETF	8.85	9.36	8.85	9.35	800.0
2001-09-21	EWG	ETF	10.4	11.35	10.35	11.3	70100.0
2001-09-21	EWH	ETF	6.85	7.25	6.85	7.2	47900.0
2001-09-21	EWI	ETF	24.8	26.0	24.5	25.16	6450.0
2001-09-21	EWJ	ETF	32.0	33.0	31.08	32.4	102625.0
2001-09-21	EWK	ETF	9.05	9.6	9.05	9.6	5100.0
2001-09-21	EWL	ETF	11.0	11.0	10.55	10.65	34100.0
2001-09-21	EWM	ETF	16.0	17.6	16.0	17.6	14125.0
2001-09-21	EWN	ETF	13.2	13.65	13.2	13.65	1600.0
2001-09-21	EWP	ETF	16.0	16.55	16.0	16.4	17500.0
2001-09-21	EWQ	ETF	14.5	15.3	14.5	15.3	39800.0
2001-09-21	EWS	ETF	7.8	8.3	7.62	7.62	28150.0
2001-09-21	EWT	ETF	14.0	14.0	13.3	13.7	51750.0
2001-09-21	EWU	ETF	23.8	25.4	23.8	25.4	38850.0
2001-09-21	EWW	ETF	11.7	12.1	11.0	11.9	34000.0
2001-09-21	EWY	ETF	10.45	10.95	10.32	10.95	13300.0
2001-09-21	EWZ	ETF	8.5	8.83	8.5	8.82	6100.0
2001-09-21	EZU	ETF	21.7	21.925	21.65	21.925	50400.0
2001-09-21	FCTR	ETF	15.67	15.92	14.86	15.46	74400.0
2001-09-21	FMAR	ETF	8.2	8.68	7.6	7.75	9000.0
2001-09-21	GLDB	ETF	7.29	7.4	6.85	7.2	233500.0
2001-09-21	GSIG	ETF	6.3	6.39	6.18	6.18	86700.0
2001-09-21	IBB	ETF	23.0	23.3333	22.6667	23.0	233400.0
2001-09-21	ICF	ETF	19.775	19.9375	19.775	19.9375	29200.0
2001-09-21	IDU	ETF	33.505	34.1	33.505	33.85	12600.0
2001-09-21	IEV	ETF	22.8	24.485	22.76	24.19	59600.0
2001-09-21	IGLD	ETF	50.0	69.0	50.0	69.0	33.0
2001-09-21	IGM	ETF	5.7917	6.0833	5.7917	6.075	221400.0
2001-09-21	IGV	ETF	5.9	5.9	5.9	5.9	13000.0
2001-09-21	IJH	ETF	7.91	8.14	7.91	8.105	425000.0
2001-09-21	IJJ	ETF	18.1875	18.65	18.175	18.6	130000.0
2001-09-21	IJK	ETF	10.7	11.0125	10.6562	10.975	252000.0
2001-09-21	IJR	ETF	14.7083	15.075	14.7083	14.95	1240200.0
2001-09-21	IJS	ETF	16.6	16.8625	16.5875	16.8125	72800.0
2001-09-21	IJT	ETF	14.7125	15.075	14.625	14.9875	47600.0
2001-09-21	IOO	ETF	24.25	24.75	24.1	24.725	4600.0

> showing 50 of 105 rows — these rows as CSV

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