PREVIEW / etf_daily / 2001-09-06

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-06.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-09-06	SPY	ETF	112.65	113.3	110.77	110.77	21653000.0
2001-09-06	QQQ	ETF	34.74	35.52	33.78	33.9	88702400.0
2001-09-06	IWM	ETF	45.75	45.9	45.1	45.1	305400.0
2001-09-06	DIA	ETF	99.8	100.2	98.33	98.35	5873600.0
2001-09-06	BBH	ETF	41.2667	41.2667	40.3333	40.4667	4364700.0
2001-09-06	BITS	ETF	14.68	14.68	12.04	12.8	7575.0
2001-09-06	BOSS	ETF	18.5	19.9	18.5	19.9	100.0
2001-09-06	CEF	ETF	3.22	3.22	3.15	3.15	3800.0
2001-09-06	CHB	ETF	10.38	10.38	10.05	10.06	112500.0
2001-09-06	CNXT	ETF	11.03	11.35	9.9	10.13	4100880.0
2001-09-06	CSB	ETF	3.45000004768372	3.5	3.45000004768372	3.5	10000.0
2001-09-06	EFA	ETF	39.8333	39.8333	39.5333	39.5333	284700.0
2001-09-06	EWA	ETF	9.11	9.2	9.11	9.2	110500.0
2001-09-06	EWC	ETF	10.71	10.8	10.6	10.6	13000.0
2001-09-06	EWD	ETF	11.85	11.95	11.75	11.95	20100.0
2001-09-06	EWG	ETF	14.11	14.17	13.95	14.02	92500.0
2001-09-06	EWH	ETF	8.67	8.67	8.41	8.41	32000.0
2001-09-06	EWI	ETF	33.28	33.36	32.6	32.6	5850.0
2001-09-06	EWJ	ETF	35.04	35.2	34.56	34.68	110625.0
2001-09-06	EWK	ETF	11.25	11.25	11.16	11.16	900.0
2001-09-06	EWL	ETF	12.5	12.5	12.41	12.47	5400.0
2001-09-06	EWM	ETF	20.2	20.32	19.92	19.92	5450.0
2001-09-06	EWN	ETF	17.35	17.45	17.26	17.36	900.0
2001-09-06	EWO	ETF	8.0	8.0	7.91	8.0	5900.0
2001-09-06	EWP	ETF	19.95	19.95	19.66	19.7	3600.0
2001-09-06	EWQ	ETF	18.42	18.45	18.3	18.35	27000.0
2001-09-06	EWS	ETF	10.52	10.6	10.26	10.38	10100.0
2001-09-06	EWT	ETF	17.32	17.72	17.3	17.3	15750.0
2001-09-06	EWU	ETF	29.6	29.6	29.0	29.3	25950.0
2001-09-06	EWW	ETF	14.3	14.43	14.0	14.0	10800.0
2001-09-06	EWY	ETF	13.3	13.35	13.2	13.2	22100.0
2001-09-06	EWZ	ETF	10.9	10.9	10.9	10.9	100.0
2001-09-06	EZU	ETF	26.665	26.665	26.5	26.625	11200.0
2001-09-06	FCTR	ETF	17.05	17.35	16.82	16.9	21300.0
2001-09-06	FMAR	ETF	9.1	9.45	9.1	9.1	14300.0
2001-09-06	GLDB	ETF	7.5	7.55	7.46	7.55	62400.0
2001-09-06	GSIG	ETF	8.23	8.23	8.08	8.19	237300.0
2001-09-06	IBB	ETF	29.2	29.2	28.5167	28.7967	505800.0
2001-09-06	ICF	ETF	21.525	21.5625	21.3925	21.465	87600.0
2001-09-06	IDU	ETF	36.405	36.495	36.25	36.32	2200.0
2001-09-06	IEV	ETF	29.05	29.075	28.72	29.065	96400.0
2001-09-06	IGLD	ETF	66.0	66.0	62.0	66.0	13.0
2001-09-06	IGM	ETF	7.4167	7.515	7.2583	7.2583	30600.0
2001-09-06	IGN	ETF	28.0	28.0	27.0	27.35	4200.0
2001-09-06	IGV	ETF	7.34	7.34	7.152	7.17	11500.0
2001-09-06	IJH	ETF	9.68	9.68	9.562	9.564	117000.0
2001-09-06	IJJ	ETF	22.05	22.05	21.7375	21.745	157600.0
2001-09-06	IJK	ETF	13.2125	13.2125	13.0062	13.0312	96000.0
2001-09-06	IJR	ETF	18.2283	18.2283	17.9583	17.9583	119400.0
2001-09-06	IJS	ETF	20.675	20.735	20.44	20.44	88000.0

> showing 50 of 108 rows — these rows as CSV

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