PREVIEW / etf_daily / 2001-11-26

all etf daily files

  file:    by_date/etf_daily/2001/2001-11-26.parquet
  size:    9 KB
  rows:    117

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-26	SPY	ETF	115.75	116.34	115.07	115.93	13726000.0
2001-11-26	QQQ	ETF	39.58	40.36	39.01	40.25	75267500.0
2001-11-26	IWM	ETF	45.74	46.075	45.45	45.975	549200.0
2001-11-26	DIA	ETF	99.95	100.15	99.1	99.8	2250800.0
2001-11-26	ARB	ETF	30.0	30.29	29.67	30.19	40300.0
2001-11-26	BBH	ETF	45.5	46.6233	45.14	46.6	3652200.0
2001-11-26	BITS	ETF	19.64	19.96	19.24	19.6	14275.0
2001-11-26	BOSS	ETF	22.0	22.0	21.5	21.5	100.0
2001-11-26	CEF	ETF	3.25	3.25	3.2	3.2	16600.0
2001-11-26	CHB	ETF	11.95	11.95	11.25	11.34	163500.0
2001-11-26	CNXT	ETF	14.0	15.01	14.0	14.73	7852020.0
2001-11-26	CSB	ETF	3.79999995231628	3.79999995231628	3.79999995231628	3.79999995231628	2300.0
2001-11-26	DGT	ETF	67.42	67.42	67.42	67.42	100.0
2001-11-26	EFA	ETF	40.3	40.4	40.1267	40.3267	360300.0
2001-11-26	ELV	ETF	24.85	25.125	24.15	24.275	958700.0
2001-11-26	EPP	ETF	17.85	17.8767	17.8	17.8767	7800.0
2001-11-26	EWA	ETF	9.4	9.4	9.2	9.29	31300.0
2001-11-26	EWC	ETF	10.5	10.63	10.42	10.6	7100.0
2001-11-26	EWD	ETF	13.56	13.56	13.56	13.56	1300.0
2001-11-26	EWG	ETF	14.7	14.76	14.6	14.72	24700.0
2001-11-26	EWH	ETF	9.01	9.14	8.95	8.97	66900.0
2001-11-26	EWI	ETF	32.2	32.3	32.12	32.12	6100.0
2001-11-26	EWJ	ETF	34.4	34.68	34.08	34.48	253075.0
2001-11-26	EWK	ETF	10.45	10.45	10.45	10.45	200.0
2001-11-26	EWL	ETF	12.75	12.85	12.71	12.85	11400.0
2001-11-26	EWM	ETF	18.6	18.8	18.6	18.6	2750.0
2001-11-26	EWN	ETF	17.01	17.1	16.9	17.1	6000.0
2001-11-26	EWO	ETF	7.05	7.05	6.96	6.96	2300.0
2001-11-26	EWP	ETF	20.86	21.05	20.86	21.04	3000.0
2001-11-26	EWQ	ETF	18.3	18.4	18.11	18.39	17400.0
2001-11-26	EWS	ETF	9.1	9.4	9.1	9.36	43300.0
2001-11-26	EWT	ETF	18.5	18.58	18.28	18.48	23450.0
2001-11-26	EWU	ETF	29.6	29.6	29.24	29.6	48700.0
2001-11-26	EWW	ETF	13.65	13.94	13.65	13.94	6900.0
2001-11-26	EWY	ETF	17.7	17.7	17.21	17.27	42400.0
2001-11-26	EWZ	ETF	11.56	11.99	11.56	11.99	6400.0
2001-11-26	EZU	ETF	27.75	27.75	27.3	27.64	25200.0
2001-11-26	FCTR	ETF	17.65	18.0	17.5	18.0	13800.0
2001-11-26	FMAR	ETF	8.0	8.15	8.0	8.14	7700.0
2001-11-26	GLDB	ETF	7.53	7.54	7.2	7.22	85100.0
2001-11-26	GRNB	ETF	17.6698	17.6698	17.6698	17.6698	606.0
2001-11-26	GSIG	ETF	8.2	8.35	8.0	8.08	112200.0
2001-11-26	IBB	ETF	31.3	31.95	30.9667	31.95	837300.0
2001-11-26	ICF	ETF	21.0125	21.11	20.9275	20.9325	9200.0
2001-11-26	IDU	ETF	32.15	32.15	31.76	31.875	27000.0
2001-11-26	IEV	ETF	29.2	29.51	29.18	29.485	214200.0
2001-11-26	IGLD	ETF	88.0	88.0	77.0	81.0	638.0
2001-11-26	IGM	ETF	8.5667	8.6817	8.5	8.6617	59400.0
2001-11-26	IGN	ETF	34.75	35.05	34.26	34.54	3900.0
2001-11-26	IGV	ETF	8.63	8.76	8.578	8.76	2196000.0

> showing 50 of 117 rows — these rows as CSV

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