PREVIEW / etf_daily / 2001-10-31

all etf daily files

  file:    by_date/etf_daily/2001/2001-10-31.parquet
  size:    9 KB
  rows:    110

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-10-31	SPY	ETF	106.9	107.86	105.8	105.8	28124200.0
2001-10-31	QQQ	ETF	34.04	34.96	33.68	33.9	106175500.0
2001-10-31	IWM	ETF	42.325	42.885	42.205	42.55	1531200.0
2001-10-31	DIA	ETF	91.92	92.43	90.6	90.68	4741700.0
2001-10-31	ARB	ETF	26.8	27.5	26.77	27.15	66400.0
2001-10-31	BBH	ETF	42.4333	42.8633	42.0833	42.1833	4254900.0
2001-10-31	BITS	ETF	15.64	16.4	15.64	15.64	2700.0
2001-10-31	CEF	ETF	3.53	3.54	3.43	3.51	22900.0
2001-10-31	CHB	ETF	8.1	9.0	8.09	8.67	185200.0
2001-10-31	CNXT	ETF	10.2	10.88	9.93	10.15	3543000.0
2001-10-31	DGT	ETF	63.45	63.5	63.45	63.45	300.0
2001-10-31	EFA	ETF	38.6333	38.75	38.22	38.2733	783000.0
2001-10-31	ELV	ETF	20.55	21.25	20.505	20.94	5552200.0
2001-10-31	EWA	ETF	8.7	8.88	8.7	8.78	20600.0
2001-10-31	EWC	ETF	9.6	9.63	9.6	9.62	2500.0
2001-10-31	EWD	ETF	11.7	11.7	11.46	11.46	1000.0
2001-10-31	EWG	ETF	13.22	13.31	13.1	13.15	147100.0
2001-10-31	EWH	ETF	7.98	8.05	7.86	8.03	82700.0
2001-10-31	EWI	ETF	31.3	31.3	31.28	31.28	5250.0
2001-10-31	EWJ	ETF	33.6	33.96	33.48	33.56	112150.0
2001-10-31	EWK	ETF	10.36	10.36	10.36	10.36	200.0
2001-10-31	EWL	ETF	12.01	12.24	12.01	12.24	6500.0
2001-10-31	EWM	ETF	17.92	17.96	17.6	17.6	8575.0
2001-10-31	EWN	ETF	16.09	16.09	16.06	16.06	1200.0
2001-10-31	EWO	ETF	6.75	6.75	6.75	6.75	1500.0
2001-10-31	EWP	ETF	19.4	19.4	19.26	19.26	5200.0
2001-10-31	EWQ	ETF	17.61	17.8	17.6	17.7	52600.0
2001-10-31	EWS	ETF	8.7	8.7	8.5	8.62	75900.0
2001-10-31	EWT	ETF	15.22	15.66	15.22	15.66	5600.0
2001-10-31	EWU	ETF	28.74	28.78	28.38	28.54	54400.0
2001-10-31	EWW	ETF	13.15	13.3	12.9	13.01	4400.0
2001-10-31	EWY	ETF	12.85	13.08	12.82	12.82	1400.0
2001-10-31	EWZ	ETF	9.59	9.59	9.5	9.5	6700.0
2001-10-31	EZU	ETF	26.0	26.04	25.77	25.875	9400.0
2001-10-31	FCTR	ETF	16.995	17.21	16.25	16.3	19800.0
2001-10-31	FMAR	ETF	7.95	7.95	7.9	7.93	3400.0
2001-10-31	GLDB	ETF	7.49	7.65	7.41	7.47	174100.0
2001-10-31	GSIG	ETF	7.66	7.76	7.47	7.53	61800.0
2001-10-31	IBB	ETF	29.05	29.2667	28.6667	28.7667	638700.0
2001-10-31	ICF	ETF	19.755	19.8375	19.7125	19.8375	66800.0
2001-10-31	IDU	ETF	32.0	32.24	32.0	32.075	3600.0
2001-10-31	IEV	ETF	28.1	28.255	27.7	27.775	49800.0
2001-10-31	IGLD	ETF	72.25	75.0	72.25	75.0	69.0
2001-10-31	IGM	ETF	7.3333	7.4817	7.2833	7.3583	94800.0
2001-10-31	IGN	ETF	28.3	28.9	28.3	28.9	3100.0
2001-10-31	IGV	ETF	7.34	7.5	7.26	7.408	32000.0
2001-10-31	IJH	ETF	9.005	9.109	8.975	9.016	201000.0
2001-10-31	IJJ	ETF	20.05	20.245	19.995	20.115	46400.0
2001-10-31	IJK	ETF	12.5812	12.6962	12.4825	12.5738	80000.0
2001-10-31	IJR	ETF	16.7067	16.8833	16.635	16.7933	268800.0

> showing 50 of 110 rows — these rows as CSV

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