PREVIEW / etf_daily / 2001-09-04

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-04.parquet
  size:    9 KB
  rows:    104

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-04	SPY	ETF	113.85	116.17	113.37	113.42	24473400.0
2001-09-04	QQQ	ETF	36.518	37.5	35.35	35.47	74073600.0
2001-09-04	IWM	ETF	46.85	47.245	46.5	46.5	697400.0
2001-09-04	DIA	ETF	99.7	102.07	99.36	99.97	8618800.0
2001-09-04	BBH	ETF	41.0833	42.2667	40.8433	40.9333	3962400.0
2001-09-04	BITS	ETF	15.0	15.96	15.0	15.4	3275.0
2001-09-04	CEF	ETF	3.16	3.2	3.15	3.16	17900.0
2001-09-04	CHB	ETF	10.5	10.55	10.14	10.14	512600.0
2001-09-04	CNXT	ETF	11.93	12.43	11.19	11.34	4125510.0
2001-09-04	CSB	ETF	3.25	3.25	3.25	3.25	2000.0
2001-09-04	DGT	ETF	65.62	65.64	65.62	65.64	800.0
2001-09-04	EFA	ETF	40.7667	41.1667	40.7	40.7	570000.0
2001-09-04	EWA	ETF	9.31	9.31	9.25	9.3	4200.0
2001-09-04	EWC	ETF	10.7	10.95	10.7	10.95	3500.0
2001-09-04	EWD	ETF	12.06	12.25	12.06	12.25	4000.0
2001-09-04	EWG	ETF	14.75	15.0	14.7	14.78	45500.0
2001-09-04	EWH	ETF	9.04	9.15	8.97	8.97	26300.0
2001-09-04	EWJ	ETF	36.16	36.32	35.84	35.84	70225.0
2001-09-04	EWL	ETF	12.65	12.67	12.6	12.6	3100.0
2001-09-04	EWM	ETF	19.68	20.08	19.68	19.8	8750.0
2001-09-04	EWN	ETF	17.9	17.9	17.9	17.9	200.0
2001-09-04	EWO	ETF	8.0	8.01	8.0	8.01	1100.0
2001-09-04	EWP	ETF	20.75	20.75	20.6	20.6	2800.0
2001-09-04	EWQ	ETF	19.0	19.1	18.8	19.1	30900.0
2001-09-04	EWS	ETF	10.66	10.68	10.48	10.6	18450.0
2001-09-04	EWT	ETF	18.56	18.78	18.1	18.48	107750.0
2001-09-04	EWU	ETF	30.04	30.4	29.8	30.26	8850.0
2001-09-04	EWW	ETF	15.4	15.5	15.1	15.2	17700.0
2001-09-04	EWY	ETF	13.8	13.88	13.4	13.4	69700.0
2001-09-04	EWZ	ETF	11.25	11.25	11.0	11.07	32300.0
2001-09-04	EZU	ETF	27.665	27.735	27.5	27.705	57000.0
2001-09-04	FCTR	ETF	17.15	17.61	17.0	17.0	20400.0
2001-09-04	FMAR	ETF	9.28	9.5	9.1	9.1	8800.0
2001-09-04	GLDB	ETF	7.41	7.7	7.41	7.5	62000.0
2001-09-04	GSIG	ETF	8.3	8.4	8.2	8.22	18900.0
2001-09-04	IBB	ETF	29.2667	30.25	29.2667	29.38	238500.0
2001-09-04	ICF	ETF	21.73	21.73	21.73	21.73	1200.0
2001-09-04	IDU	ETF	36.89	37.2	36.795	36.795	6400.0
2001-09-04	IEV	ETF	29.945	30.0	29.665	29.665	32000.0
2001-09-04	IGLD	ETF	64.0	68.0	63.0	68.0	41.0
2001-09-04	IGM	ETF	7.9	8.0	7.7833	7.7833	24000.0
2001-09-04	IGN	ETF	31.05	31.25	30.6	30.6	5000.0
2001-09-04	IJH	ETF	9.877	9.992	9.838	9.847	68000.0
2001-09-04	IJJ	ETF	22.375	22.56	22.345	22.345	88000.0
2001-09-04	IJK	ETF	13.5125	13.75	13.4938	13.4938	26400.0
2001-09-04	IJR	ETF	18.4833	18.6667	18.45	18.45	715200.0
2001-09-04	IJS	ETF	20.9	21.1325	20.8975	20.925	146400.0
2001-09-04	IJT	ETF	18.34	18.555	18.3	18.3475	23200.0
2001-09-04	IOO	ETF	28.63	29.135	28.615	28.775	53200.0
2001-09-04	IUSG	ETF	20.14	20.14	20.075	20.075	1400.0

> showing 50 of 104 rows — these rows as CSV

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