PREVIEW / etf_daily / 2001-07-16

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-16.parquet
  size:    9 KB
  rows:    100

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-07-16	SPY	ETF	121.77	122.28	120.29	120.71	6915300.0
2001-07-16	QQQ	ETF	43.37	43.86	41.9	42.35	53390800.0
2001-07-16	IWM	ETF	48.85	48.995	48.075	48.075	547200.0
2001-07-16	DIA	ETF	105.46	105.84	104.57	105.05	912400.0
2001-07-16	BBH	ETF	38.5333	38.7	36.58	36.7833	4943100.0
2001-07-16	BITS	ETF	12.76	14.0	12.72	13.8	5775.0
2001-07-16	BOSS	ETF	28.8	28.8	28.8	28.8	100.0
2001-07-16	CEF	ETF	3.07	3.07	3.03	3.03	13500.0
2001-07-16	CHB	ETF	10.95	11.0	10.91	10.96	150400.0
2001-07-16	CNXT	ETF	8.75	8.98	7.92	7.98	1594050.0
2001-07-16	CSB	ETF	2.59999990463257	2.59999990463257	2.51999998092651	2.51999998092651	25000.0
2001-07-16	DGT	ETF	69.65	69.65	69.05	69.05	200.0
2001-07-16	EWA	ETF	9.53	9.63	9.48	9.55	11800.0
2001-07-16	EWC	ETF	11.15	11.35	11.05	11.05	4300.0
2001-07-16	EWD	ETF	13.15	13.15	13.05	13.05	400.0
2001-07-16	EWG	ETF	16.2	16.2	16.01	16.09	8600.0
2001-07-16	EWH	ETF	9.85	9.88	9.75	9.88	13000.0
2001-07-16	EWI	ETF	35.2	35.2	35.12	35.12	550.0
2001-07-16	EWJ	ETF	38.68	38.92	38.4	38.6	57250.0
2001-07-16	EWK	ETF	11.55	11.55	11.55	11.55	100.0
2001-07-16	EWL	ETF	13.1	13.1	13.0	13.1	4400.0
2001-07-16	EWM	ETF	17.8	18.4	17.8	18.0	625.0
2001-07-16	EWP	ETF	19.95	19.95	19.95	19.95	900.0
2001-07-16	EWQ	ETF	19.41	19.41	19.26	19.26	2200.0
2001-07-16	EWS	ETF	10.16	10.2	10.06	10.2	5450.0
2001-07-16	EWT	ETF	17.98	17.98	17.54	17.58	26450.0
2001-07-16	EWU	ETF	30.6	30.8	30.2	30.6	18100.0
2001-07-16	EWW	ETF	15.45	15.65	15.15	15.15	88100.0
2001-07-16	EWY	ETF	12.95	13.1	12.86	12.91	11800.0
2001-07-16	EWZ	ETF	12.28	12.48	12.26	12.26	2300.0
2001-07-16	EZU	ETF	28.975	28.99	28.725	28.725	47200.0
2001-07-16	FCTR	ETF	16.7	17.45	16.7	16.94	28800.0
2001-07-16	FMAR	ETF	6.39	6.39	5.8	5.86	5500.0
2001-07-16	GLDB	ETF	7.34	7.49	7.33	7.4	23200.0
2001-07-16	GSIG	ETF	8.2	8.24	7.97	8.04	88200.0
2001-07-16	IBB	ETF	29.6667	29.6667	27.9667	28.0833	1349700.0
2001-07-16	ICF	ETF	21.1125	21.13	21.0875	21.0875	11600.0
2001-07-16	IDU	ETF	39.95	39.965	39.765	39.85	1800.0
2001-07-16	IEV	ETF	30.375	30.52	30.2	30.325	44600.0
2001-07-16	IGLD	ETF	69.0	69.0	68.0	69.0	55.0
2001-07-16	IGM	ETF	9.4333	9.4333	9.3083	9.3083	16200.0
2001-07-16	IJH	ETF	10.181	10.181	10.024	10.037	147000.0
2001-07-16	IJJ	ETF	22.6625	22.6625	22.455	22.475	37600.0
2001-07-16	IJK	ETF	14.1812	14.1812	13.8912	13.9	83200.0
2001-07-16	IJR	ETF	18.7667	18.8367	18.5117	18.58	786600.0
2001-07-16	IJS	ETF	20.94	20.9975	20.72	20.7775	110800.0
2001-07-16	IJT	ETF	18.9375	18.965	18.665	18.6975	42400.0
2001-07-16	IOO	ETF	30.735	30.735	30.3	30.34	81200.0
2001-07-16	IUSG	ETF	21.795	21.795	21.42	21.44	20600.0
2001-07-16	IUSV	ETF	25.0	25.0367	24.8133	24.8133	25500.0

> showing 50 of 100 rows — these rows as CSV

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