PREVIEW / etf_daily / 2001-08-09

all etf daily files

  file:    by_date/etf_daily/2001/2001-08-09.parquet
  size:    8 KB
  rows:    99

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-08-09	SPY	ETF	118.7	118.97	117.86	118.88	14118500.0
2001-08-09	QQQ	ETF	40.41	40.88	39.98	40.67	66861400.0
2001-08-09	IWM	ETF	47.1	47.35	46.725	47.35	535200.0
2001-08-09	DIA	ETF	102.99	103.25	102.13	103.15	5422800.0
2001-08-09	BBH	ETF	38.15	38.53	36.9	38.3933	6095400.0
2001-08-09	BITS	ETF	14.72	14.88	14.28	14.48	3675.0
2001-08-09	BOSS	ETF	25.3	25.3	25.3	25.3	100.0
2001-08-09	CEF	ETF	3.11	3.15	3.05	3.11	41200.0
2001-08-09	CHB	ETF	10.5	10.5	10.26	10.3	299700.0
2001-08-09	CNXT	ETF	9.22	9.49	8.9	9.35	2215300.0
2001-08-09	EWA	ETF	9.6	9.6	9.5	9.5	4200.0
2001-08-09	EWC	ETF	11.22	11.22	11.22	11.22	600.0
2001-08-09	EWG	ETF	15.78	15.87	15.7	15.87	93400.0
2001-08-09	EWH	ETF	9.15	9.15	9.02	9.07	16700.0
2001-08-09	EWI	ETF	36.6	36.9	36.6	36.62	350.0
2001-08-09	EWJ	ETF	37.88	38.32	37.8	38.24	60200.0
2001-08-09	EWK	ETF	11.57	11.57	11.57	11.57	1200.0
2001-08-09	EWL	ETF	13.25	13.28	13.11	13.28	2100.0
2001-08-09	EWM	ETF	19.12	19.28	19.08	19.08	3550.0
2001-08-09	EWN	ETF	18.87	18.87	18.71	18.73	1400.0
2001-08-09	EWO	ETF	8.1	8.1	8.09	8.09	4000.0
2001-08-09	EWP	ETF	20.9	20.9	20.9	20.9	300.0
2001-08-09	EWQ	ETF	19.72	19.74	19.62	19.72	2600.0
2001-08-09	EWS	ETF	10.48	10.64	10.42	10.64	12550.0
2001-08-09	EWT	ETF	17.98	18.34	17.96	18.32	900.0
2001-08-09	EWU	ETF	30.34	30.38	29.92	30.38	5650.0
2001-08-09	EWW	ETF	16.13	16.36	16.13	16.28	2500.0
2001-08-09	EWY	ETF	13.6	13.6	13.32	13.48	3000.0
2001-08-09	EWZ	ETF	12.89	13.12	12.89	13.12	400.0
2001-08-09	EZU	ETF	29.24	29.4	29.01	29.4	5800.0
2001-08-09	FCTR	ETF	18.05	18.14	18.0	18.14	15000.0
2001-08-09	FMAR	ETF	9.3	9.55	9.25	9.25	26500.0
2001-08-09	GLDB	ETF	7.54	7.54	7.31	7.46	9100.0
2001-08-09	GSIG	ETF	8.4	8.46	8.35	8.46	50400.0
2001-08-09	IBB	ETF	27.5	27.5	26.6333	27.3	453900.0
2001-08-09	ICF	ETF	21.2875	21.3675	21.2875	21.3675	24800.0
2001-08-09	IDU	ETF	36.45	36.73	36.41	36.73	2800.0
2001-08-09	IEV	ETF	30.37	30.57	30.15	30.565	10400.0
2001-08-09	IGLD	ETF	65.0	70.0	65.0	67.0	237.0
2001-08-09	IGM	ETF	8.8333	8.85	8.7667	8.8267	86400.0
2001-08-09	IGV	ETF	9.04	9.14	9.04	9.14	3000.0
2001-08-09	IJH	ETF	9.925	9.937	9.836	9.913	150000.0
2001-08-09	IJJ	ETF	22.4425	22.4625	22.34	22.4125	634400.0
2001-08-09	IJK	ETF	13.5588	13.5662	13.45	13.51	100000.0
2001-08-09	IJR	ETF	18.3917	18.4667	18.2883	18.4583	202200.0
2001-08-09	IJS	ETF	20.8125	20.915	20.735	20.915	60800.0
2001-08-09	IJT	ETF	18.285	18.41	18.135	18.41	22000.0
2001-08-09	IOO	ETF	29.945	30.05	29.79	30.005	60800.0
2001-08-09	IUSG	ETF	20.8	20.8	20.73	20.765	1800.0
2001-08-09	IUSV	ETF	24.3667	24.5733	24.3667	24.49	2400.0

> showing 50 of 99 rows — these rows as CSV

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