PREVIEW / etf_daily / 2001-07-27

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-27.parquet
  size:    8 KB
  rows:    99

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-27	SPY	ETF	120.83	121.35	119.91	120.81	8478800.0
2001-07-27	QQQ	ETF	41.64	42.26	40.9	41.95	47486200.0
2001-07-27	IWM	ETF	48.325	48.54	48.085	48.25	592200.0
2001-07-27	DIA	ETF	104.55	104.7	103.81	104.35	1409500.0
2001-07-27	BBH	ETF	39.6667	40.6667	39.6667	39.9067	4694100.0
2001-07-27	BITS	ETF	14.16	15.76	14.0	15.4	9225.0
2001-07-27	CEF	ETF	3.13	3.13	3.09	3.09	8500.0
2001-07-27	CHB	ETF	10.95	11.05	10.9	10.98	312000.0
2001-07-27	CNXT	ETF	8.68	10.0	8.68	9.36	7138800.0
2001-07-27	CSB	ETF	2.5	2.5	2.5	2.5	1100.0
2001-07-27	DGT	ETF	68.8	69.0	68.8	69.0	200.0
2001-07-27	EWA	ETF	9.1	9.17	9.1	9.17	2600.0
2001-07-27	EWC	ETF	11.3	11.35	11.3	11.35	500.0
2001-07-27	EWD	ETF	13.25	13.3	13.16	13.16	800.0
2001-07-27	EWG	ETF	16.31	16.39	16.06	16.39	133600.0
2001-07-27	EWH	ETF	9.54	9.57	9.5	9.56	32700.0
2001-07-27	EWI	ETF	35.98	35.98	35.98	35.98	1650.0
2001-07-27	EWJ	ETF	37.76	38.2	37.64	38.16	401275.0
2001-07-27	EWK	ETF	11.45	11.45	11.45	11.45	200.0
2001-07-27	EWL	ETF	13.0	13.05	12.85	12.91	1500.0
2001-07-27	EWM	ETF	19.04	19.4	18.92	19.4	13375.0
2001-07-27	EWN	ETF	18.8	18.8	18.8	18.8	500.0
2001-07-27	EWO	ETF	8.26	8.26	8.26	8.26	200.0
2001-07-27	EWP	ETF	20.25	20.49	20.25	20.49	3300.0
2001-07-27	EWQ	ETF	19.55	19.6	19.55	19.59	13300.0
2001-07-27	EWS	ETF	10.26	10.26	10.24	10.24	100.0
2001-07-27	EWT	ETF	17.5	17.52	17.5	17.52	2050.0
2001-07-27	EWU	ETF	30.5	30.5	30.12	30.44	32300.0
2001-07-27	EWW	ETF	15.85	15.94	15.65	15.94	8900.0
2001-07-27	EWY	ETF	12.95	13.18	12.95	13.18	900.0
2001-07-27	EWZ	ETF	12.9	12.9	12.72	12.72	1900.0
2001-07-27	EZU	ETF	29.1	29.49	29.1	29.49	8200.0
2001-07-27	FCTR	ETF	18.45	18.45	18.24	18.24	31000.0
2001-07-27	FMAR	ETF	9.08	9.66	8.85	9.4	5200.0
2001-07-27	GLDB	ETF	7.84	7.84	7.75	7.8	31600.0
2001-07-27	GRNB	ETF	25.0322	25.0322	25.0322	25.0322	202.0
2001-07-27	GSIG	ETF	7.2	7.55	7.15	7.41	69900.0
2001-07-27	IBB	ETF	29.1	29.8333	29.1	29.3967	1162800.0
2001-07-27	ICF	ETF	20.98	20.985	20.8975	20.985	5600.0
2001-07-27	IDU	ETF	37.265	37.265	36.98	36.98	2400.0
2001-07-27	IEV	ETF	30.375	30.645	30.125	30.64	26600.0
2001-07-27	IGLD	ETF	70.0	70.0	70.0	70.0	30.0
2001-07-27	IGV	ETF	9.78	9.9	9.78	9.88	152000.0
2001-07-27	IJH	ETF	10.155	10.224	10.115	10.223	1994000.0
2001-07-27	IJJ	ETF	22.55	22.6975	22.4275	22.6625	26800.0
2001-07-27	IJK	ETF	14.1075	14.3362	14.1075	14.2812	17600.0
2001-07-27	IJR	ETF	18.8133	18.9133	18.6983	18.8683	250200.0
2001-07-27	IJS	ETF	21.0375	21.1775	21.0	21.135	63600.0
2001-07-27	IJT	ETF	18.8325	19.0025	18.765	19.0025	12000.0
2001-07-27	IOO	ETF	30.215	30.365	30.07	30.32	4000.0

> showing 50 of 99 rows — these rows as CSV

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