PREVIEW / etf_daily / 2001-10-19

all etf daily files

  file:    by_date/etf_daily/2001/2001-10-19.parquet
  size:    9 KB
  rows:    106

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-19	SPY	ETF	107.0	107.91	106.01	107.35	21912500.0
2001-10-19	QQQ	ETF	32.869	33.75	32.0	33.55	73434200.0
2001-10-19	IWM	ETF	41.725	42.475	41.725	42.3	519200.0
2001-10-19	DIA	ETF	91.65	92.35	90.85	91.9	3465800.0
2001-10-19	ARB	ETF	27.5	28.52	27.5	28.15	180600.0
2001-10-19	BBH	ETF	39.2167	40.4133	38.9833	40.24	3725700.0
2001-10-19	BITS	ETF	16.44	18.0	16.4	17.4	23875.0
2001-10-19	CEF	ETF	3.41	3.5	3.41	3.49	5100.0
2001-10-19	CHB	ETF	7.25	7.4	7.0	7.02	157400.0
2001-10-19	CNXT	ETF	10.08	10.15	9.747	10.04	3395540.0
2001-10-19	CSB	ETF	3.65000009536743	3.79999995231628	3.65000009536743	3.79999995231628	5500.0
2001-10-19	DGT	ETF	63.1	63.25	63.1	63.25	1200.0
2001-10-19	EFA	ETF	38.1333	38.3	37.92	38.2667	258000.0
2001-10-19	EWA	ETF	8.73	8.73	8.63	8.63	1900.0
2001-10-19	EWD	ETF	11.4	11.4	11.4	11.4	200.0
2001-10-19	EWG	ETF	12.95	13.05	12.9	13.05	44000.0
2001-10-19	EWH	ETF	7.82	7.86	7.71	7.85	18800.0
2001-10-19	EWI	ETF	30.8	30.8	30.52	30.52	1300.0
2001-10-19	EWJ	ETF	34.04	34.24	33.88	34.24	30275.0
2001-10-19	EWK	ETF	10.25	10.25	10.25	10.25	100.0
2001-10-19	EWL	ETF	12.07	12.15	11.96	12.05	7000.0
2001-10-19	EWM	ETF	17.8	17.84	17.8	17.8	1625.0
2001-10-19	EWN	ETF	15.41	15.64	15.4	15.64	1400.0
2001-10-19	EWO	ETF	7.1	7.1	7.03	7.05	5300.0
2001-10-19	EWQ	ETF	17.3	17.46	17.3	17.46	24200.0
2001-10-19	EWS	ETF	8.96	8.96	8.74	8.74	12050.0
2001-10-19	EWT	ETF	15.3	15.3	14.92	15.0	39650.0
2001-10-19	EWU	ETF	28.44	28.44	27.92	28.0	25750.0
2001-10-19	EWW	ETF	13.42	13.45	13.01	13.2	61100.0
2001-10-19	EWY	ETF	12.3	12.5	12.27	12.3	10000.0
2001-10-19	EWZ	ETF	9.3	9.49	9.3	9.49	75000.0
2001-10-19	EZU	ETF	25.075	25.575	25.075	25.575	14400.0
2001-10-19	FCTR	ETF	17.797	17.85	17.01	17.5	32100.0
2001-10-19	FMAR	ETF	8.05	8.05	7.9	8.0	9900.0
2001-10-19	GLDB	ETF	7.5	7.5	7.31	7.49	60000.0
2001-10-19	GSIG	ETF	7.24	7.34	7.21	7.3	36300.0
2001-10-19	IBB	ETF	27.2	27.9167	26.95	27.9167	160800.0
2001-10-19	ICF	ETF	20.225	20.225	20.015	20.07	46000.0
2001-10-19	IDU	ETF	33.68	34.09	33.515	34.09	3800.0
2001-10-19	IEV	ETF	27.6	27.625	27.3	27.59	86400.0
2001-10-19	IGLD	ETF	69.0	80.0	69.0	75.0	387.0
2001-10-19	IGM	ETF	7.1083	7.2567	7.1083	7.25	16200.0
2001-10-19	IGN	ETF	28.5	29.15	28.39	29.15	600.0
2001-10-19	IJH	ETF	8.871	8.993	8.808	8.965	251000.0
2001-10-19	IJJ	ETF	19.9875	20.2075	19.8425	20.125	29200.0
2001-10-19	IJK	ETF	12.1875	12.4162	12.185	12.41	63200.0
2001-10-19	IJR	ETF	16.4283	16.7383	16.415	16.69	606000.0
2001-10-19	IJS	ETF	18.2625	18.4825	18.1875	18.46	28000.0
2001-10-19	IJT	ETF	16.7125	17.0425	16.6375	16.9925	22400.0
2001-10-19	IOO	ETF	27.51	27.875	27.51	27.875	6000.0

> showing 50 of 106 rows — these rows as CSV

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