PREVIEW / etf_daily / 2001-08-31

all etf daily files

  file:    by_date/etf_daily/2001/2001-08-31.parquet
  size:    9 KB
  rows:    107

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-08-31	SPY	ETF	113.4	114.77	113.13	114.15	15985400.0
2001-08-31	QQQ	ETF	36.038	37.03	35.94	36.17	54309000.0
2001-08-31	IWM	ETF	46.7	47.07	46.63	46.945	995600.0
2001-08-31	DIA	ETF	99.4	100.67	99.07	99.88	3670700.0
2001-08-31	BBH	ETF	41.6167	41.6633	40.7167	41.2167	3162600.0
2001-08-31	BITS	ETF	15.0	15.72	15.0	15.0	3325.0
2001-08-31	BOSS	ETF	21.8	21.9	21.8	21.9	100.0
2001-08-31	CEF	ETF	3.21	3.21	3.21	3.21	2000.0
2001-08-31	CHB	ETF	10.4	10.5	10.4	10.5	352700.0
2001-08-31	CNXT	ETF	11.09	12.02	11.08	11.91	3461100.0
2001-08-31	CSB	ETF	3.25	3.25	3.25	3.25	10000.0
2001-08-31	DGT	ETF	65.38	65.38	65.38	65.38	100.0
2001-08-31	EFA	ETF	41.5333	41.7167	41.4667	41.65	1656900.0
2001-08-31	EWA	ETF	9.4	9.4	9.31	9.35	2700.0
2001-08-31	EWC	ETF	10.7	10.71	10.7	10.71	3800.0
2001-08-31	EWD	ETF	12.9	12.9	12.78	12.78	12300.0
2001-08-31	EWG	ETF	15.2	15.25	15.07	15.25	60000.0
2001-08-31	EWH	ETF	8.9	9.04	8.88	9.04	25000.0
2001-08-31	EWI	ETF	35.7	35.74	35.52	35.52	2100.0
2001-08-31	EWJ	ETF	36.2	36.64	36.2	36.56	61975.0
2001-08-31	EWK	ETF	11.8	11.8	11.71	11.71	1500.0
2001-08-31	EWL	ETF	12.82	13.05	12.82	13.05	3500.0
2001-08-31	EWM	ETF	19.6	19.92	19.28	19.8	5450.0
2001-08-31	EWN	ETF	18.6	18.75	18.51	18.51	2500.0
2001-08-31	EWP	ETF	21.15	21.45	21.15	21.4	2800.0
2001-08-31	EWQ	ETF	19.65	19.65	19.46	19.6	13000.0
2001-08-31	EWS	ETF	10.5	10.68	10.42	10.5	10450.0
2001-08-31	EWT	ETF	17.96	18.1	17.74	17.74	52200.0
2001-08-31	EWU	ETF	30.0	30.48	30.0	30.36	9300.0
2001-08-31	EWW	ETF	15.21	15.48	15.21	15.38	10100.0
2001-08-31	EWY	ETF	13.4	13.4	13.2	13.2	3500.0
2001-08-31	EWZ	ETF	11.14	11.15	11.08	11.08	1500.0
2001-08-31	EZU	ETF	28.335	28.57	28.335	28.57	5200.0
2001-08-31	FCTR	ETF	17.54	17.6	17.23	17.23	14200.0
2001-08-31	FMAR	ETF	9.72	9.72	9.72	9.72	100.0
2001-08-31	GLDB	ETF	7.45	7.57	7.3	7.45	127000.0
2001-08-31	GSIG	ETF	8.24	8.37	8.24	8.36	6000.0
2001-08-31	IBB	ETF	29.4333	29.5333	29.1	29.2667	370800.0
2001-08-31	ICF	ETF	21.8375	21.87	21.73	21.83	28800.0
2001-08-31	IDU	ETF	36.66	36.765	36.595	36.73	2200.0
2001-08-31	IEV	ETF	30.41	30.5	30.25	30.5	12800.0
2001-08-31	IGLD	ETF	70.0	70.0	64.0	64.0	79.0
2001-08-31	IGM	ETF	7.8333	7.95	7.8333	7.9333	53400.0
2001-08-31	IGN	ETF	31.15	31.15	31.15	31.15	100.0
2001-08-31	IGV	ETF	7.86	7.86	7.86	7.86	5000.0
2001-08-31	IJH	ETF	9.815	9.892	9.815	9.892	90000.0
2001-08-31	IJJ	ETF	22.145	22.385	22.1375	22.385	67200.0
2001-08-31	IJK	ETF	13.53	13.5562	13.525	13.5425	408800.0
2001-08-31	IJR	ETF	18.45	18.5833	18.4467	18.535	158400.0
2001-08-31	IJS	ETF	20.855	20.985	20.8	20.885	66800.0

> showing 50 of 107 rows — these rows as CSV

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