PREVIEW / etf_daily / 2001-11-16

all etf daily files

  file:    by_date/etf_daily/2001/2001-11-16.parquet
  size:    9 KB
  rows:    113

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-11-16	SPY	ETF	115.08	115.1	113.4	114.36	18134900.0
2001-11-16	QQQ	ETF	39.48	39.68	38.92	39.37	64035500.0
2001-11-16	IWM	ETF	44.83	45.075	44.64	44.995	423200.0
2001-11-16	DIA	ETF	99.16	99.34	98.01	98.87	3945800.0
2001-11-16	ARB	ETF	29.2	29.4	29.2	29.34	166800.0
2001-11-16	BBH	ETF	43.9	44.1167	43.48	43.7333	2250900.0
2001-11-16	BITS	ETF	17.96	19.4	17.6	19.4	24525.0
2001-11-16	CEF	ETF	3.29	3.34	3.29	3.32	13200.0
2001-11-16	CHB	ETF	11.7	12.5	11.7	12.35	363500.0
2001-11-16	CNXT	ETF	14.08	14.18	13.3	13.84	5266200.0
2001-11-16	CSB	ETF	4.0	4.0	4.0	4.0	20100.0
2001-11-16	DGT	ETF	67.3	67.3	67.12	67.12	200.0
2001-11-16	EFA	ETF	40.0	40.0933	39.8467	39.9933	659700.0
2001-11-16	ELV	ETF	23.45	23.6	23.15	23.4	1088100.0
2001-11-16	EPP	ETF	17.8067	17.8067	17.65	17.65	1500.0
2001-11-16	EWA	ETF	9.44	9.44	9.35	9.35	12400.0
2001-11-16	EWC	ETF	10.5	10.6	10.5	10.58	13100.0
2001-11-16	EWD	ETF	13.49	13.49	13.26	13.26	1500.0
2001-11-16	EWG	ETF	14.5	14.61	14.36	14.4	20700.0
2001-11-16	EWH	ETF	9.05	9.09	8.89	9.0	60700.0
2001-11-16	EWI	ETF	31.76	31.98	31.6	31.62	2800.0
2001-11-16	EWJ	ETF	33.44	33.6	33.2	33.4	151500.0
2001-11-16	EWK	ETF	10.56	10.74	10.56	10.56	1800.0
2001-11-16	EWL	ETF	12.89	13.07	12.81	12.81	17600.0
2001-11-16	EWM	ETF	18.6	18.6	18.08	18.08	1925.0
2001-11-16	EWN	ETF	16.9	16.9	16.76	16.76	2900.0
2001-11-16	EWO	ETF	7.08	7.08	7.0	7.0	14600.0
2001-11-16	EWP	ETF	20.95	20.95	20.81	20.82	3500.0
2001-11-16	EWQ	ETF	18.22	18.3	18.22	18.22	12000.0
2001-11-16	EWS	ETF	8.98	9.08	8.86	9.0	28200.0
2001-11-16	EWT	ETF	17.98	18.08	17.88	18.08	8050.0
2001-11-16	EWU	ETF	29.5	29.72	29.3	29.36	25300.0
2001-11-16	EWW	ETF	13.94	13.94	13.66	13.66	7700.0
2001-11-16	EWY	ETF	15.34	15.34	15.26	15.27	53100.0
2001-11-16	EWZ	ETF	11.2	11.2	11.05	11.15	15200.0
2001-11-16	EZU	ETF	27.375	27.385	27.16	27.19	19200.0
2001-11-16	FCTR	ETF	17.28	17.47	17.0	17.04	15200.0
2001-11-16	FMAR	ETF	8.29	8.3	8.15	8.15	8900.0
2001-11-16	GLDB	ETF	7.5	7.54	7.35	7.5	46300.0
2001-11-16	GSIG	ETF	8.35	8.35	8.18	8.35	70800.0
2001-11-16	IBB	ETF	29.4667	29.7633	29.4333	29.7333	72600.0
2001-11-16	ICF	ETF	20.98	21.0375	20.95	20.95	103200.0
2001-11-16	IDU	ETF	32.375	32.495	32.165	32.23	5800.0
2001-11-16	IEV	ETF	29.425	29.55	29.155	29.205	33600.0
2001-11-16	IGLD	ETF	91.0	91.0	89.0	89.0	159.0
2001-11-16	IGM	ETF	8.55	8.5833	8.4583	8.4617	913800.0
2001-11-16	IGN	ETF	34.0	34.9	33.9	34.9	5400.0
2001-11-16	IGV	ETF	8.53	8.53	8.45	8.47	5500.0
2001-11-16	IJH	ETF	9.545	9.582	9.521	9.553	209000.0
2001-11-16	IJJ	ETF	21.1875	21.275	21.115	21.25	68800.0

> showing 50 of 113 rows — these rows as CSV

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