PREVIEW / etf_daily / 2001-07-02

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-02.parquet
  size:    8 KB
  rows:    98

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-02	SPY	ETF	122.8	124.32	122.62	124.13	8522200.0
2001-07-02	QQQ	ETF	45.652	46.48	45.19	45.45	50884300.0
2001-07-02	IWM	ETF	50.8	50.8	49.655	49.8	2142000.0
2001-07-02	DIA	ETF	104.78	106.58	104.55	106.21	1604000.0
2001-07-02	BBH	ETF	44.0	44.41	43.75	43.9167	1792500.0
2001-07-02	BITS	ETF	12.32	13.24	12.32	13.0	6550.0
2001-07-02	BOSS	ETF	29.5	29.5	29.5	29.5	100.0
2001-07-02	CEF	ETF	3.29	3.29	3.23	3.23	3400.0
2001-07-02	CHB	ETF	11.38	11.9	11.3	11.76	313400.0
2001-07-02	CNXT	ETF	8.85	9.3	8.493	8.7	1856010.0
2001-07-02	DGT	ETF	70.3	71.55	70.3	71.45	66000.0
2001-07-02	EWA	ETF	9.64	9.7	9.6	9.7	15400.0
2001-07-02	EWC	ETF	11.4	11.65	11.4	11.47	14400.0
2001-07-02	EWD	ETF	13.79	13.85	13.7	13.7	800.0
2001-07-02	EWG	ETF	16.54	16.75	16.41	16.75	18400.0
2001-07-02	EWH	ETF	10.04	10.1	9.99	10.08	14600.0
2001-07-02	EWI	ETF	35.92	36.68	35.92	36.68	1200.0
2001-07-02	EWJ	ETF	40.8	40.96	40.64	40.84	274775.0
2001-07-02	EWL	ETF	13.5	13.6	13.35	13.45	30100.0
2001-07-02	EWM	ETF	17.2	17.2	16.8	17.0	9375.0
2001-07-02	EWN	ETF	19.45	19.7	19.45	19.7	3400.0
2001-07-02	EWO	ETF	7.75	7.75	7.75	7.75	1100.0
2001-07-02	EWP	ETF	21.35	21.85	21.35	21.85	3400.0
2001-07-02	EWQ	ETF	20.09	20.25	20.09	20.25	24400.0
2001-07-02	EWS	ETF	10.72	10.72	10.68	10.7	13450.0
2001-07-02	EWT	ETF	20.48	20.5	20.24	20.36	8850.0
2001-07-02	EWU	ETF	31.74	31.9	31.44	31.7	14650.0
2001-07-02	EWW	ETF	16.6	17.05	16.6	17.05	14700.0
2001-07-02	EWY	ETF	14.36	14.49	14.26	14.26	6500.0
2001-07-02	EWZ	ETF	14.4	14.43	14.4	14.41	1600.0
2001-07-02	EZU	ETF	30.125	30.445	29.975	30.445	29200.0
2001-07-02	FCTR	ETF	17.7	18.25	17.33	17.5	76000.0
2001-07-02	FMAR	ETF	6.3	6.35	6.3	6.3	2700.0
2001-07-02	GLDB	ETF	7.7	7.78	7.58	7.73	156000.0
2001-07-02	GSIG	ETF	9.37	9.37	9.05	9.25	60000.0
2001-07-02	IBB	ETF	33.3	33.4367	32.9533	32.9533	216900.0
2001-07-02	ICF	ETF	21.31	21.34	21.185	21.34	166800.0
2001-07-02	IDU	ETF	39.2	39.55	39.2	39.32	2000.0
2001-07-02	IEV	ETF	31.575	32.01	31.575	31.985	10000.0
2001-07-02	IGLD	ETF	69.0	74.0	67.0	67.0	446.0
2001-07-02	IGM	ETF	9.775	9.905	9.775	9.905	137400.0
2001-07-02	IJH	ETF	10.313	10.34	10.295	10.295	90000.0
2001-07-02	IJJ	ETF	22.815	22.88	22.7425	22.84	71600.0
2001-07-02	IJK	ETF	14.5638	14.5875	14.525	14.525	44000.0
2001-07-02	IJR	ETF	19.1117	19.155	18.8633	18.9167	423000.0
2001-07-02	IJS	ETF	21.2875	21.31	21.075	21.0925	77600.0
2001-07-02	IJT	ETF	19.3625	19.3825	19.05	19.05	32800.0
2001-07-02	IOO	ETF	31.5	31.875	31.5	31.815	21800.0
2001-07-02	IUSG	ETF	22.535	22.535	22.335	22.35	1600.0
2001-07-02	IUSV	ETF	25.0667	25.24	25.0667	25.2167	21900.0

> showing 50 of 98 rows — these rows as CSV

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