PREVIEW / etf_daily / 2001-10-17

all etf daily files

  file:    by_date/etf_daily/2001/2001-10-17.parquet
  size:    9 KB
  rows:    108

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-10-17	SPY	ETF	111.07	111.15	107.65	107.65	28542300.0
2001-10-17	QQQ	ETF	35.87	36.0	32.3	32.45	141532800.0
2001-10-17	IWM	ETF	43.65	43.725	42.05	42.05	797400.0
2001-10-17	DIA	ETF	95.1	95.18	92.01	92.01	14080700.0
2001-10-17	ARB	ETF	27.7	27.83	27.41	27.41	40100.0
2001-10-17	BBH	ETF	40.75	40.8333	38.86	38.8833	3132600.0
2001-10-17	BITS	ETF	14.36	15.0	14.12	14.8	8775.0
2001-10-17	CEF	ETF	3.5	3.5	3.46	3.5	13400.0
2001-10-17	CHB	ETF	8.5	8.5	7.45	7.45	199500.0
2001-10-17	CNXT	ETF	10.65	10.77	9.0	9.01	4146000.0
2001-10-17	CSB	ETF	3.65000009536743	3.65000009536743	3.65000009536743	3.65000009536743	2100.0
2001-10-17	DGT	ETF	65.23	65.23	65.23	65.23	100.0
2001-10-17	EFA	ETF	39.6667	39.6667	38.9667	38.9667	224700.0
2001-10-17	EWA	ETF	8.87	8.9	8.8	8.85	13600.0
2001-10-17	EWC	ETF	10.0	10.0	9.96	9.96	200.0
2001-10-17	EWD	ETF	12.35	12.35	12.3	12.3	1300.0
2001-10-17	EWG	ETF	13.75	13.75	13.25	13.25	39300.0
2001-10-17	EWH	ETF	8.16	8.2	8.01	8.01	30000.0
2001-10-17	EWI	ETF	31.7	32.0	31.5	31.9	9950.0
2001-10-17	EWJ	ETF	35.2	35.44	34.4	34.44	138200.0
2001-10-17	EWK	ETF	10.7	10.7	10.35	10.35	7800.0
2001-10-17	EWL	ETF	12.12	12.2	11.91	11.92	24000.0
2001-10-17	EWM	ETF	18.08	18.08	18.08	18.08	200.0
2001-10-17	EWN	ETF	16.4	16.4	16.27	16.27	4200.0
2001-10-17	EWO	ETF	7.32	7.32	7.32	7.32	2000.0
2001-10-17	EWP	ETF	19.8	19.8	19.55	19.66	4300.0
2001-10-17	EWQ	ETF	18.0	18.2	17.9	17.9	27800.0
2001-10-17	EWS	ETF	9.18	9.32	9.12	9.12	12500.0
2001-10-17	EWT	ETF	15.32	15.34	15.06	15.06	105250.0
2001-10-17	EWU	ETF	28.9	29.38	28.9	28.9	5000.0
2001-10-17	EWW	ETF	13.55	13.7	13.3	13.4	97600.0
2001-10-17	EWY	ETF	12.4	12.52	12.31	12.31	2700.0
2001-10-17	EWZ	ETF	9.75	9.75	9.65	9.65	1300.0
2001-10-17	EZU	ETF	26.7	26.7	26.035	26.035	10200.0
2001-10-17	FCTR	ETF	16.11	17.0	16.07	16.9	18000.0
2001-10-17	FMAR	ETF	8.15	8.15	7.95	7.95	63900.0
2001-10-17	GLDB	ETF	7.48	7.5	7.2	7.21	87200.0
2001-10-17	GSIG	ETF	7.39	7.59	7.24	7.24	27900.0
2001-10-17	IBB	ETF	28.6333	28.6333	27.0	27.0333	258900.0
2001-10-17	ICF	ETF	20.5375	20.5375	20.3125	20.3125	23600.0
2001-10-17	IDU	ETF	35.125	35.235	34.585	34.7	11200.0
2001-10-17	IEV	ETF	28.7	28.7	28.115	28.135	26800.0
2001-10-17	IGLD	ETF	75.0	75.0	69.0	70.0	532.0
2001-10-17	IGM	ETF	7.6833	7.6833	7.0833	7.0833	115200.0
2001-10-17	IGN	ETF	31.1	31.1	29.15	29.15	7500.0
2001-10-17	IGV	ETF	7.72	7.72	7.16	7.16	12000.0
2001-10-17	IJH	ETF	9.243	9.255	8.928	8.928	272000.0
2001-10-17	IJJ	ETF	20.825	20.825	20.35	20.35	50000.0
2001-10-17	IJK	ETF	12.6938	12.71	12.1613	12.1613	120800.0
2001-10-17	IJR	ETF	17.095	17.1133	16.585	16.585	554400.0

> showing 50 of 108 rows — these rows as CSV

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