PREVIEW / etf_daily / 2001-08-16

all etf daily files

  file:    by_date/etf_daily/2001/2001-08-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-08-16	SPY	ETF	117.8	118.75	117.0	118.65	10734700.0
2001-08-16	QQQ	ETF	38.649	39.59	38.041	39.56	68227300.0
2001-08-16	IWM	ETF	47.625	48.25	47.25	48.1	1579400.0
2001-08-16	DIA	ETF	103.32	104.25	102.89	104.25	3778100.0
2001-08-16	BBH	ETF	38.5333	39.43	38.1	39.3133	6221700.0
2001-08-16	BITS	ETF	14.4	14.4	14.04	14.08	4375.0
2001-08-16	CEF	ETF	3.15	3.15	3.15	3.15	1000.0
2001-08-16	CHB	ETF	9.65	9.74	9.62	9.74	118300.0
2001-08-16	CNXT	ETF	9.83	10.02	9.228	9.94	3397440.0
2001-08-16	DGT	ETF	67.69	67.69	67.69	67.69	100.0
2001-08-16	EWA	ETF	9.65	9.65	9.56	9.56	13300.0
2001-08-16	EWC	ETF	11.24	11.24	11.06	11.06	1800.0
2001-08-16	EWD	ETF	13.6	13.64	13.6	13.64	1100.0
2001-08-16	EWG	ETF	15.85	15.96	15.85	15.9	27300.0
2001-08-16	EWH	ETF	9.05	9.14	9.05	9.13	43100.0
2001-08-16	EWI	ETF	36.94	37.34	36.94	37.34	100.0
2001-08-16	EWJ	ETF	38.44	38.88	38.12	38.64	91650.0
2001-08-16	EWK	ETF	11.85	11.85	11.85	11.85	100.0
2001-08-16	EWL	ETF	13.17	13.17	13.16	13.16	6600.0
2001-08-16	EWM	ETF	19.12	19.36	19.12	19.12	5625.0
2001-08-16	EWN	ETF	19.19	19.45	19.15	19.45	3400.0
2001-08-16	EWP	ETF	21.6	21.74	21.6	21.74	4200.0
2001-08-16	EWQ	ETF	20.35	20.39	20.34	20.39	11100.0
2001-08-16	EWS	ETF	10.68	10.68	10.54	10.56	14650.0
2001-08-16	EWT	ETF	18.98	19.28	18.92	19.28	5750.0
2001-08-16	EWU	ETF	30.82	30.94	30.8	30.92	3950.0
2001-08-16	EWW	ETF	15.91	15.91	15.4	15.5	13200.0
2001-08-16	EWY	ETF	14.01	14.23	14.01	14.23	500.0
2001-08-16	EWZ	ETF	12.7	12.7	12.56	12.56	2400.0
2001-08-16	EZU	ETF	29.925	29.925	29.55	29.895	5600.0
2001-08-16	FCTR	ETF	18.1	18.3	18.0	18.25	21900.0
2001-08-16	FMAR	ETF	9.2	9.47	9.2	9.33	3700.0
2001-08-16	GLDB	ETF	7.92	7.95	7.8	7.89	88800.0
2001-08-16	GSIG	ETF	8.23	8.23	7.85	8.05	79500.0
2001-08-16	IBB	ETF	27.2667	27.8167	26.95	27.8167	504300.0
2001-08-16	ICF	ETF	22.0625	22.0625	21.945	21.95	5200.0
2001-08-16	IEV	ETF	31.05	31.14	30.98	31.12	9400.0
2001-08-16	IGLD	ETF	69.0	80.0	61.0	72.0	255.0
2001-08-16	IGM	ETF	8.3417	8.4983	8.3417	8.4983	11400.0
2001-08-16	IGV	ETF	8.372	8.53	8.372	8.53	981000.0
2001-08-16	IJH	ETF	10.0	10.067	9.951	10.067	122000.0
2001-08-16	IJJ	ETF	22.725	22.855	22.5825	22.855	166400.0
2001-08-16	IJK	ETF	13.6125	13.7362	13.56	13.7362	35200.0
2001-08-16	IJR	ETF	18.76	18.955	18.6767	18.955	1041600.0
2001-08-16	IJS	ETF	21.275	21.435	21.085	21.43	177200.0
2001-08-16	IJT	ETF	18.645	18.845	18.525	18.845	20400.0
2001-08-16	IOO	ETF	29.76	30.105	29.76	30.105	64000.0
2001-08-16	IUSG	ETF	20.535	20.535	20.405	20.405	17400.0
2001-08-16	IUSV	ETF	24.5433	24.5567	24.5433	24.5433	9000.0
2001-08-16	IVE	ETF	58.9	59.17	58.48	59.12	14900.0

> showing 50 of 100 rows — these rows as CSV

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