PREVIEW / etf_daily / 2001-06-20

all etf daily files

  file:    by_date/etf_daily/2001/2001-06-20.parquet
  size:    8 KB
  rows:    96

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-20	SPY	ETF	121.19	122.86	121.1	122.43	8787200.0
2001-06-20	QQQ	ETF	41.3	42.97	41.28	42.77	83591600.0
2001-06-20	IWM	ETF	48.5	49.55	48.5	49.425	861400.0
2001-06-20	DIA	ETF	105.95	107.14	105.67	106.73	3386000.0
2001-06-20	BBH	ETF	43.7467	45.4833	43.55	45.4667	5810700.0
2001-06-20	BITS	ETF	13.0	13.56	12.84	12.88	8100.0
2001-06-20	CEF	ETF	3.27	3.27	3.27	3.27	3800.0
2001-06-20	CHB	ETF	9.57	10.95	9.56	10.95	890400.0
2001-06-20	CNXT	ETF	7.26	7.86	7.009	7.38	3334340.0
2001-06-20	DGT	ETF	70.28	71.0	70.28	71.0	54900.0
2001-06-20	EWA	ETF	9.71	9.79	9.7	9.71	7700.0
2001-06-20	EWC	ETF	11.5	11.5	11.2	11.2	16900.0
2001-06-20	EWD	ETF	12.99	12.99	12.99	12.99	3800.0
2001-06-20	EWG	ETF	16.02	16.3	16.02	16.18	24300.0
2001-06-20	EWH	ETF	10.09	10.34	10.09	10.16	38300.0
2001-06-20	EWI	ETF	36.0	36.0	35.3	35.6	6250.0
2001-06-20	EWJ	ETF	40.16	40.52	40.0	40.32	72750.0
2001-06-20	EWK	ETF	11.0	11.0	11.0	11.0	200.0
2001-06-20	EWL	ETF	13.4	13.55	13.35	13.55	9800.0
2001-06-20	EWM	ETF	16.8	17.0	16.8	17.0	1075.0
2001-06-20	EWN	ETF	19.05	19.05	18.9	19.02	13700.0
2001-06-20	EWO	ETF	8.05	8.05	8.05	8.05	1800.0
2001-06-20	EWP	ETF	21.4	21.82	21.4	21.75	10600.0
2001-06-20	EWQ	ETF	19.87	20.1	19.87	20.1	16300.0
2001-06-20	EWS	ETF	10.76	10.84	10.74	10.76	11050.0
2001-06-20	EWU	ETF	31.24	31.32	31.02	31.32	9000.0
2001-06-20	EWW	ETF	15.7	16.11	15.7	16.11	27400.0
2001-06-20	EWY	ETF	14.31	14.31	14.21	14.25	7400.0
2001-06-20	EWZ	ETF	13.5	13.78	13.5	13.71	1400.0
2001-06-20	EZU	ETF	29.96	30.05	29.65	29.825	13000.0
2001-06-20	FCTR	ETF	16.35	16.5	16.25	16.41	27900.0
2001-06-20	FMAR	ETF	6.67	6.67	6.5	6.5	1800.0
2001-06-20	GLDB	ETF	7.02	7.13	7.015	7.09	41700.0
2001-06-20	GSIG	ETF	9.16	9.16	8.54	8.65	270300.0
2001-06-20	IBB	ETF	32.2333	33.6667	32.2333	33.6667	463500.0
2001-06-20	ICF	ETF	20.9375	21.0125	20.9375	20.9625	5200.0
2001-06-20	IDU	ETF	39.525	39.8	39.525	39.55	1600.0
2001-06-20	IEV	ETF	30.75	31.6	30.75	31.16	20000.0
2001-06-20	IGLD	ETF	70.0	73.0	69.0	70.0	90.0
2001-06-20	IGM	ETF	9.0417	9.0417	9.0083	9.0083	6600.0
2001-06-20	IJH	ETF	10.05	10.231	10.05	10.231	168000.0
2001-06-20	IJJ	ETF	22.0025	22.27	22.0025	22.2575	82400.0
2001-06-20	IJK	ETF	14.2588	14.5838	14.2588	14.5838	46400.0
2001-06-20	IJR	ETF	18.0633	18.3583	18.0583	18.3167	870000.0
2001-06-20	IJS	ETF	20.32	20.6625	20.32	20.6625	58000.0
2001-06-20	IJT	ETF	18.1	18.255	18.075	18.255	12400.0
2001-06-20	IOO	ETF	31.325	31.475	31.3	31.375	66200.0
2001-06-20	IUSG	ETF	21.86	21.905	21.755	21.905	13800.0
2001-06-20	IUSV	ETF	25.0067	25.0567	25.0067	25.0567	1200.0
2001-06-20	IVE	ETF	60.87	61.42	60.72	60.99	37700.0

> showing 50 of 96 rows — these rows as CSV

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