PREVIEW / etf_daily / 2001-06-27

all etf daily files

  file:    by_date/etf_daily/2001/2001-06-27.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-06-27	SPY	ETF	121.6	122.24	120.91	121.48	10105100.0
2001-06-27	QQQ	ETF	43.681	44.15	43.0	43.79	53289400.0
2001-06-27	IWM	ETF	49.1	49.6	48.95	49.475	989000.0
2001-06-27	DIA	ETF	104.88	105.4	104.06	104.5	1937200.0
2001-06-27	BBH	ETF	43.0667	43.6233	42.4833	43.3	4598700.0
2001-06-27	BITS	ETF	12.96	12.96	12.28	12.28	3225.0
2001-06-27	CHB	ETF	11.0	11.05	10.94	10.99	149300.0
2001-06-27	CNXT	ETF	7.64	7.99	7.44	7.79	1302300.0
2001-06-27	CSB	ETF	2.20000004768372	2.20000004768372	2.20000004768372	2.20000004768372	71600.0
2001-06-27	DGT	ETF	70.25	70.25	69.7	69.92	300.0
2001-06-27	EWA	ETF	9.78	9.85	9.7	9.8	385500.0
2001-06-27	EWC	ETF	11.45	11.45	11.15	11.17	3000.0
2001-06-27	EWD	ETF	13.5	13.5	13.1	13.1	9000.0
2001-06-27	EWG	ETF	16.18	16.35	16.18	16.34	43400.0
2001-06-27	EWH	ETF	10.0	10.06	9.94	9.96	50500.0
2001-06-27	EWI	ETF	36.2	36.2	36.2	36.2	1500.0
2001-06-27	EWJ	ETF	40.72	40.88	40.4	40.64	72475.0
2001-06-27	EWL	ETF	13.15	13.35	13.15	13.3	5200.0
2001-06-27	EWM	ETF	16.8	17.0	16.8	17.0	875.0
2001-06-27	EWN	ETF	19.15	19.25	19.1	19.1	4900.0
2001-06-27	EWO	ETF	8.1	8.1	8.0	8.0	15400.0
2001-06-27	EWP	ETF	21.3	21.5	21.3	21.5	900.0
2001-06-27	EWQ	ETF	19.71	19.8	19.65	19.65	14800.0
2001-06-27	EWS	ETF	10.76	10.8	10.64	10.66	19350.0
2001-06-27	EWT	ETF	20.06	20.1	19.6	20.0	19250.0
2001-06-27	EWU	ETF	31.2	31.54	31.12	31.54	10550.0
2001-06-27	EWW	ETF	16.65	16.8	16.5	16.7	90200.0
2001-06-27	EWY	ETF	13.8	13.82	13.8	13.81	3000.0
2001-06-27	EWZ	ETF	14.38	14.47	14.31	14.31	111600.0
2001-06-27	EZU	ETF	29.925	29.925	29.75	29.84	2000.0
2001-06-27	FCTR	ETF	16.86	17.1	16.7	17.0	109500.0
2001-06-27	FMAR	ETF	6.65	6.65	5.66	6.5	11900.0
2001-06-27	GLDB	ETF	7.45	7.5	7.34	7.34	24800.0
2001-06-27	GRNB	ETF	26.3869	26.3869	26.3869	26.3869	202.0
2001-06-27	GSIG	ETF	8.9	9.3	8.73	9.25	70800.0
2001-06-27	IBB	ETF	32.15	32.2833	31.6167	32.0333	456000.0
2001-06-27	ICF	ETF	21.045	21.0625	21.0275	21.03	10000.0
2001-06-27	IDU	ETF	38.585	39.015	38.585	39.015	4800.0
2001-06-27	IEV	ETF	31.125	31.475	30.91	31.425	22800.0
2001-06-27	IGLD	ETF	66.0	66.0	66.0	66.0	23.0
2001-06-27	IGM	ETF	9.4717	9.5083	9.4717	9.5083	9600.0
2001-06-27	IJH	ETF	10.095	10.171	10.078	10.145	378000.0
2001-06-27	IJJ	ETF	22.23	22.4525	22.2225	22.41	122800.0
2001-06-27	IJK	ETF	14.2438	14.3	14.1862	14.275	52000.0
2001-06-27	IJR	ETF	18.31	18.4833	18.2967	18.4717	519600.0
2001-06-27	IJS	ETF	20.4375	20.6	20.4375	20.5675	58000.0
2001-06-27	IJT	ETF	18.46	18.645	18.46	18.6175	46000.0
2001-06-27	IOO	ETF	31.25	31.33	31.04	31.22	5200.0
2001-06-27	IUSG	ETF	21.925	21.945	21.81	21.81	6600.0
2001-06-27	IUSV	ETF	24.72	24.9033	24.72	24.8	107100.0

> showing 50 of 99 rows — these rows as CSV

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