PREVIEW / etf_daily / 2001-07-26

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-26.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-26	SPY	ETF	119.06	120.85	118.56	120.35	12898200.0
2001-07-26	QQQ	ETF	40.45	41.89	39.98	41.1	69221800.0
2001-07-26	IWM	ETF	47.505	48.55	47.23	48.325	622800.0
2001-07-26	DIA	ETF	103.7	104.74	102.85	104.64	2436500.0
2001-07-26	BBH	ETF	38.5	39.3333	38.15	39.0	4062600.0
2001-07-26	BITS	ETF	14.04	14.2	13.84	14.0	9150.0
2001-07-26	BOSS	ETF	28.5	28.5	28.0	28.0	200.0
2001-07-26	CEF	ETF	3.06	3.08	3.06	3.08	8100.0
2001-07-26	CHB	ETF	10.8	11.0	10.73	10.91	210300.0
2001-07-26	CNXT	ETF	8.31	8.94	8.13	8.64	4828850.0
2001-07-26	DGT	ETF	67.8	68.45	67.8	68.45	1000.0
2001-07-26	EWA	ETF	9.18	9.18	9.05	9.1	106800.0
2001-07-26	EWC	ETF	11.3	11.3	11.3	11.3	1500.0
2001-07-26	EWG	ETF	16.0	16.04	15.85	16.0	12400.0
2001-07-26	EWH	ETF	9.52	9.53	9.41	9.51	137700.0
2001-07-26	EWI	ETF	35.44	35.7	35.44	35.7	1300.0
2001-07-26	EWJ	ETF	37.84	37.84	37.28	37.44	206775.0
2001-07-26	EWL	ETF	12.9	12.95	12.75	12.85	13300.0
2001-07-26	EWM	ETF	18.12	18.6	18.04	18.6	15925.0
2001-07-26	EWN	ETF	18.55	18.55	18.4	18.46	4000.0
2001-07-26	EWO	ETF	8.22	8.22	8.22	8.22	4000.0
2001-07-26	EWP	ETF	20.45	20.45	20.31	20.31	10600.0
2001-07-26	EWQ	ETF	19.07	19.37	19.07	19.26	30600.0
2001-07-26	EWS	ETF	10.38	10.38	10.24	10.26	30850.0
2001-07-26	EWT	ETF	17.2	17.4	17.12	17.4	68100.0
2001-07-26	EWU	ETF	29.86	29.94	29.56	29.94	18800.0
2001-07-26	EWW	ETF	15.45	15.8	15.41	15.6	8000.0
2001-07-26	EWY	ETF	12.97	12.97	12.97	12.97	400.0
2001-07-26	EWZ	ETF	12.86	13.05	12.86	13.05	93000.0
2001-07-26	EZU	ETF	28.95	29.05	28.735	29.05	546600.0
2001-07-26	FCTR	ETF	18.09	18.5	18.0	18.45	28200.0
2001-07-26	FMAR	ETF	9.0	9.1	8.9	9.08	13000.0
2001-07-26	GLDB	ETF	7.785	7.91	7.68	7.85	137100.0
2001-07-26	GSIG	ETF	7.13	7.37	7.12	7.23	308100.0
2001-07-26	IBB	ETF	28.2333	29.0333	28.1833	28.8	220200.0
2001-07-26	ICF	ETF	20.975	20.98	20.975	20.98	1600.0
2001-07-26	IDU	ETF	36.95	37.36	36.43	37.33	8400.0
2001-07-26	IEV	ETF	30.0	30.295	29.735	30.0	22400.0
2001-07-26	IGLD	ETF	70.0	70.0	70.0	70.0	2.0
2001-07-26	IGM	ETF	8.7917	9.05	8.7917	9.05	21600.0
2001-07-26	IGV	ETF	9.54	9.75	9.54	9.75	500000.0
2001-07-26	IJH	ETF	9.968	10.138	9.956	10.106	116000.0
2001-07-26	IJJ	ETF	22.2375	22.5575	22.1225	22.4875	115200.0
2001-07-26	IJK	ETF	13.9488	14.0888	13.8275	14.0888	31200.0
2001-07-26	IJR	ETF	18.45	18.8367	18.45	18.7917	573600.0
2001-07-26	IJS	ETF	20.7875	21.1225	20.715	21.0975	68000.0
2001-07-26	IJT	ETF	18.47	18.8675	18.46	18.84	36400.0
2001-07-26	IOO	ETF	29.915	30.3	29.785	30.3	90800.0
2001-07-26	IUSG	ETF	20.99	21.145	20.99	21.1	3000.0
2001-07-26	IUSV	ETF	24.4867	24.8367	24.4867	24.8367	5700.0

> showing 50 of 99 rows — these rows as CSV

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