PREVIEW / etf_daily / 2001-11-19

all etf daily files

  file:    by_date/etf_daily/2001/2001-11-19.parquet
  size:    9 KB
  rows:    113

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-11-19	SPY	ETF	114.92	115.85	114.45	115.77	13625400.0
2001-11-19	QQQ	ETF	39.79	40.49	39.49	40.49	69196300.0
2001-11-19	IWM	ETF	45.075	45.69	45.005	45.5	316200.0
2001-11-19	DIA	ETF	99.45	100.14	98.9	100.1	2794300.0
2001-11-19	ARB	ETF	29.35	29.55	29.2	29.23	108400.0
2001-11-19	BBH	ETF	44.0	45.3333	43.9067	45.2167	3202800.0
2001-11-19	BITS	ETF	19.0	19.92	19.0	19.6	14450.0
2001-11-19	CEF	ETF	3.42	3.42	3.25	3.3	8200.0
2001-11-19	CHB	ETF	12.38	12.5	11.9	12.11	399200.0
2001-11-19	CNXT	ETF	14.07	14.17	13.0	13.46	5736000.0
2001-11-19	DGT	ETF	67.6	67.6	67.39	67.55	400.0
2001-11-19	EFA	ETF	40.4	40.4767	40.1367	40.1933	432900.0
2001-11-19	ELV	ETF	23.375	23.785	23.2	23.75	1003600.0
2001-11-19	EPP	ETF	17.8	17.8267	17.8	17.8267	1500.0
2001-11-19	EWA	ETF	9.36	9.4	9.3	9.4	19900.0
2001-11-19	EWC	ETF	10.6	10.75	10.6	10.7	21600.0
2001-11-19	EWD	ETF	13.31	13.48	13.31	13.48	1000.0
2001-11-19	EWG	ETF	14.69	14.75	14.61	14.7	22700.0
2001-11-19	EWH	ETF	9.01	9.13	8.96	9.11	54500.0
2001-11-19	EWI	ETF	32.22	32.6	32.2	32.6	5550.0
2001-11-19	EWJ	ETF	34.24	34.24	33.64	33.64	85275.0
2001-11-19	EWK	ETF	12.82	12.82	10.51	10.51	1300.0
2001-11-19	EWL	ETF	13.0	13.11	12.86	12.96	16000.0
2001-11-19	EWM	ETF	18.4	18.52	18.4	18.52	6225.0
2001-11-19	EWN	ETF	17.04	17.04	16.76	16.93	1700.0
2001-11-19	EWO	ETF	6.9	6.9	6.85	6.85	4400.0
2001-11-19	EWP	ETF	21.14	21.2	21.01	21.2	139300.0
2001-11-19	EWQ	ETF	18.49	18.54	18.4	18.41	8100.0
2001-11-19	EWS	ETF	9.16	9.2	9.16	9.18	65650.0
2001-11-19	EWT	ETF	18.72	18.72	18.4	18.48	82350.0
2001-11-19	EWU	ETF	30.02	30.02	29.32	29.64	14200.0
2001-11-19	EWW	ETF	13.6	13.8	13.6	13.8	7800.0
2001-11-19	EWY	ETF	15.5	16.01	15.5	15.84	165600.0
2001-11-19	EWZ	ETF	11.54	11.54	11.11	11.29	2400.0
2001-11-19	EZU	ETF	27.45	27.62	27.4	27.6	106400.0
2001-11-19	FCTR	ETF	17.49	17.74	17.0	17.74	21000.0
2001-11-19	FMAR	ETF	8.15	8.15	8.15	8.15	2700.0
2001-11-19	GLDB	ETF	7.52	7.55	7.21	7.53	46600.0
2001-11-19	GRNB	ETF	17.6698	17.6698	17.6698	17.6698	303.0
2001-11-19	GSIG	ETF	8.49	8.9	8.3	8.9	178800.0
2001-11-19	IBB	ETF	29.8667	30.8167	29.7	30.8167	2115600.0
2001-11-19	ICF	ETF	21.05	21.05	20.865	20.9725	12800.0
2001-11-19	IDU	ETF	32.275	32.325	31.875	32.23	23600.0
2001-11-19	IEV	ETF	29.695	29.775	29.425	29.675	95800.0
2001-11-19	IGLD	ETF	89.0	95.0	89.0	92.0	354.0
2001-11-19	IGM	ETF	8.6667	8.7083	8.5633	8.6833	183000.0
2001-11-19	IGN	ETF	35.5	36.0	35.3	35.75	13800.0
2001-11-19	IGV	ETF	8.662	8.784	8.66	8.766	40500.0
2001-11-19	IJH	ETF	9.59	9.654	9.571	9.653	287000.0
2001-11-19	IJJ	ETF	21.2725	21.415	21.2425	21.3975	26000.0

> showing 50 of 113 rows — these rows as CSV

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