PREVIEW / etf_daily / 2001-04-19

all etf daily files

  file:    by_date/etf_daily/2001/2001-04-19.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-04-19	SPY	ETF	124.25	125.84	123.58	125.65	13809900.0
2001-04-19	QQQ	ETF	46.1	48.75	45.58	48.3	110467600.0
2001-04-19	IWM	ETF	46.65	47.245	46.35	47.195	251200.0
2001-04-19	DIA	ETF	106.4	107.23	105.7	107.18	3677200.0
2001-04-19	BBH	ETF	42.2	42.8	41.5033	42.67	1858200.0
2001-04-19	BITS	ETF	7.0	8.0	6.8	7.96	2075.0
2001-04-19	BOSS	ETF	27.0	27.35	27.0	27.35	100.0
2001-04-19	CEF	ETF	3.07	3.17	3.07	3.17	10800.0
2001-04-19	CHB	ETF	5.78	7.15	5.78	7.05	905200.0
2001-04-19	CNXT	ETF	12.25	12.75	11.3	12.45	6476200.0
2001-04-19	CSB	ETF	1.39999997615814	1.39999997615814	1.39999997615814	1.39999997615814	27600.0
2001-04-19	DGT	ETF	73.1	74.25	73.08	74.25	2300.0
2001-04-19	EWA	ETF	9.25	9.4	9.25	9.4	18200.0
2001-04-19	EWC	ETF	11.65	11.9	11.65	11.9	2000.0
2001-04-19	EWD	ETF	14.95	15.35	14.95	15.35	1400.0
2001-04-19	EWG	ETF	17.41	17.75	17.4	17.65	224700.0
2001-04-19	EWH	ETF	11.0	11.09	10.91	11.03	108000.0
2001-04-19	EWI	ETF	39.72	40.5	39.72	40.5	5150.0
2001-04-19	EWJ	ETF	43.76	43.8	43.24	43.68	293825.0
2001-04-19	EWK	ETF	11.84	11.84	11.84	11.84	4700.0
2001-04-19	EWL	ETF	14.45	14.55	14.2	14.55	9800.0
2001-04-19	EWM	ETF	16.2	16.6	16.0	16.56	9450.0
2001-04-19	EWN	ETF	20.2	20.35	20.2	20.35	600.0
2001-04-19	EWO	ETF	8.2	8.2	8.15	8.15	9700.0
2001-04-19	EWP	ETF	24.19	24.23	24.19	24.21	3200.0
2001-04-19	EWQ	ETF	21.55	21.78	21.55	21.7	53400.0
2001-04-19	EWS	ETF	10.8	10.86	10.6	10.72	27350.0
2001-04-19	EWT	ETF	23.7	23.78	23.2	23.64	25300.0
2001-04-19	EWU	ETF	32.6	33.28	32.6	32.92	122100.0
2001-04-19	EWW	ETF	15.35	15.45	15.2	15.4	61900.0
2001-04-19	EWY	ETF	13.81	14.0	13.7	13.8	21000.0
2001-04-19	EWZ	ETF	14.98	14.98	14.75	14.75	6600.0
2001-04-19	EZU	ETF	32.575	33.025	32.48	33.025	17800.0
2001-04-19	FCTR	ETF	15.5	16.25	15.4	16.22	87300.0
2001-04-19	FMAR	ETF	6.5	7.0	6.5	7.0	12900.0
2001-04-19	GLDB	ETF	6.9	7.05	6.85	7.02	288800.0
2001-04-19	GSIG	ETF	10.57	11.14	10.26	10.49	165900.0
2001-04-19	IBB	ETF	29.5	29.5	28.8667	29.5	61200.0
2001-04-19	ICF	ETF	19.45	19.575	19.45	19.575	2400.0
2001-04-19	IDU	ETF	42.15	42.15	41.425	41.625	10200.0
2001-04-19	IEV	ETF	33.47	34.015	33.29	34.015	105400.0
2001-04-19	IGLD	ETF	114.0	115.0	98.0	98.0	130.0
2001-04-19	IGM	ETF	10.125	10.725	10.125	10.7083	506400.0
2001-04-19	IJH	ETF	9.801	9.94	9.788	9.94	621000.0
2001-04-19	IJJ	ETF	21.4075	21.6975	21.4075	21.6875	70800.0
2001-04-19	IJK	ETF	13.8762	14.1362	13.8762	14.13	502400.0
2001-04-19	IJR	ETF	17.5333	17.75	17.5	17.75	66600.0
2001-04-19	IJS	ETF	19.2625	19.6	19.255	19.6	50000.0
2001-04-19	IJT	ETF	18.05	18.2	17.97	18.2	120400.0
2001-04-19	IOO	ETF	32.835	33.425	32.7	33.425	248800.0

> showing 50 of 99 rows — these rows as CSV

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