PREVIEW / etf_daily / 2001-07-23

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-23.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-07-23	SPY	ETF	121.8	121.88	118.95	118.95	8065200.0
2001-07-23	QQQ	ETF	42.24	42.4	40.55	40.61	55330500.0
2001-07-23	IWM	ETF	48.825	48.825	48.0	48.15	1452000.0
2001-07-23	DIA	ETF	106.22	106.33	103.75	103.9	1805900.0
2001-07-23	BBH	ETF	39.6667	40.3	38.3833	38.3833	2686800.0
2001-07-23	BITS	ETF	15.0	15.04	13.4	13.4	6325.0
2001-07-23	BOSS	ETF	29.2	29.2	29.2	29.2	100.0
2001-07-23	CEF	ETF	3.12	3.12	3.1	3.1	6200.0
2001-07-23	CHB	ETF	11.15	11.94	11.1	11.75	377500.0
2001-07-23	CNXT	ETF	9.02	9.3	8.4	8.41	2129200.0
2001-07-23	DGT	ETF	69.4	69.4	68.77	68.77	2300.0
2001-07-23	EWA	ETF	9.44	9.44	9.33	9.42	4800.0
2001-07-23	EWC	ETF	11.1	11.3	11.1	11.2	2400.0
2001-07-23	EWD	ETF	12.85	12.85	12.7	12.7	2900.0
2001-07-23	EWG	ETF	16.21	16.21	16.05	16.05	31400.0
2001-07-23	EWH	ETF	9.8	9.8	9.58	9.6	23000.0
2001-07-23	EWI	ETF	35.44	35.44	35.14	35.4	2050.0
2001-07-23	EWJ	ETF	37.16	37.2	36.64	36.8	95200.0
2001-07-23	EWL	ETF	13.4	13.4	13.1	13.3	6200.0
2001-07-23	EWM	ETF	18.68	18.68	18.04	18.04	1075.0
2001-07-23	EWN	ETF	18.55	18.56	18.4	18.48	10800.0
2001-07-23	EWO	ETF	8.33	8.33	8.33	8.33	300.0
2001-07-23	EWP	ETF	20.5	20.55	20.4	20.4	15600.0
2001-07-23	EWQ	ETF	19.3	19.45	19.23	19.38	7800.0
2001-07-23	EWS	ETF	10.02	10.02	9.84	9.84	12350.0
2001-07-23	EWT	ETF	17.06	17.18	16.82	17.14	3500.0
2001-07-23	EWU	ETF	30.2	30.5	29.9	30.12	16750.0
2001-07-23	EWW	ETF	15.8	15.8	15.35	15.4	34700.0
2001-07-23	EWY	ETF	12.7	12.74	12.54	12.54	2400.0
2001-07-23	EWZ	ETF	13.4	13.4	13.2	13.2	4700.0
2001-07-23	EZU	ETF	29.49	29.49	29.12	29.12	6200.0
2001-07-23	FCTR	ETF	18.015	18.48	17.95	17.95	23400.0
2001-07-23	FMAR	ETF	9.47	9.65	9.0	9.49	20100.0
2001-07-23	GLDB	ETF	7.54	7.74	7.46	7.5	39100.0
2001-07-23	GRNB	ETF	26.0139	26.0139	26.0139	26.0139	101.0
2001-07-23	GSIG	ETF	7.68	7.84	7.63	7.63	88800.0
2001-07-23	IBB	ETF	29.8167	29.8333	28.7	28.7	220200.0
2001-07-23	ICF	ETF	21.175	21.175	21.05	21.05	4800.0
2001-07-23	IDU	ETF	37.9	37.9	36.75	37.0	12000.0
2001-07-23	IEV	ETF	30.51	30.64	30.25	30.485	13800.0
2001-07-23	IGLD	ETF	70.0	70.0	70.0	70.0	43.0
2001-07-23	IGM	ETF	9.1	9.1	8.775	8.775	318000.0
2001-07-23	IJH	ETF	10.241	10.241	10.08	10.08	125000.0
2001-07-23	IJJ	ETF	22.6375	22.6775	22.3525	22.4125	68800.0
2001-07-23	IJK	ETF	14.1875	14.2238	14.0875	14.0875	87200.0
2001-07-23	IJR	ETF	18.9	18.9	18.6367	18.6417	1434600.0
2001-07-23	IJS	ETF	21.1375	21.17	20.9125	20.9375	318400.0
2001-07-23	IJT	ETF	18.75	18.835	18.7475	18.7725	98800.0
2001-07-23	IOO	ETF	30.625	30.625	30.1	30.125	47400.0
2001-07-23	IUSG	ETF	21.67	21.67	21.07	21.07	97000.0

> showing 50 of 99 rows — these rows as CSV

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