PREVIEW / etf_daily / 2001-08-17

all etf daily files

  file:    by_date/etf_daily/2001/2001-08-17.parquet
  size:    9 KB
  rows:    103

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-17	SPY	ETF	117.65	117.87	116.01	116.75	11604600.0
2001-08-17	QQQ	ETF	38.441	38.8	37.71	37.76	56649300.0
2001-08-17	IWM	ETF	47.7	48.0	47.3	47.35	2412000.0
2001-08-17	DIA	ETF	103.15	103.62	101.88	102.5	3423400.0
2001-08-17	BBH	ETF	38.9333	39.43	38.4867	38.57	3849900.0
2001-08-17	BITS	ETF	14.4	15.16	14.4	14.76	1250.0
2001-08-17	CEF	ETF	3.14	3.23	3.14	3.21	22900.0
2001-08-17	CHB	ETF	9.74	9.74	9.5	9.55	114000.0
2001-08-17	CNXT	ETF	9.5	10.0	9.2	9.93	3629000.0
2001-08-17	CSB	ETF	2.59999990463257	2.59999990463257	2.54999995231628	2.54999995231628	14300.0
2001-08-17	DGT	ETF	66.07	66.07	66.07	66.07	700.0
2001-08-17	EWA	ETF	9.65	9.7	9.65	9.65	6000.0
2001-08-17	EWC	ETF	11.05	11.05	10.91	10.91	3100.0
2001-08-17	EWD	ETF	13.25	13.4	13.2	13.25	7900.0
2001-08-17	EWG	ETF	15.54	15.59	15.45	15.53	17200.0
2001-08-17	EWH	ETF	9.2	9.27	9.15	9.15	21800.0
2001-08-17	EWI	ETF	36.6	36.6	36.5	36.6	1000.0
2001-08-17	EWJ	ETF	37.72	38.08	37.28	37.44	103775.0
2001-08-17	EWK	ETF	11.85	11.85	11.85	11.85	6600.0
2001-08-17	EWL	ETF	13.3	13.31	13.09	13.1	1300.0
2001-08-17	EWM	ETF	19.0	19.0	19.0	19.0	1200.0
2001-08-17	EWN	ETF	18.95	18.95	18.91	18.92	1700.0
2001-08-17	EWO	ETF	8.44	8.55	8.4	8.4	9000.0
2001-08-17	EWP	ETF	21.16	21.4	21.15	21.4	2500.0
2001-08-17	EWQ	ETF	19.9	20.1	19.9	19.95	32400.0
2001-08-17	EWS	ETF	10.54	10.72	10.52	10.54	6500.0
2001-08-17	EWT	ETF	18.94	18.94	18.44	18.52	63400.0
2001-08-17	EWU	ETF	30.68	30.86	30.14	30.32	6800.0
2001-08-17	EWW	ETF	15.5	15.5	15.15	15.31	4600.0
2001-08-17	EWY	ETF	14.13	14.13	13.84	13.84	1200.0
2001-08-17	EWZ	ETF	12.4	12.44	12.34	12.34	4000.0
2001-08-17	EZU	ETF	29.35	29.4	29.13	29.14	11600.0
2001-08-17	FCTR	ETF	18.25	18.25	17.9	17.9	13200.0
2001-08-17	FMAR	ETF	9.32	9.6	9.32	9.6	9500.0
2001-08-17	GLDB	ETF	7.78	7.93	7.78	7.81	14300.0
2001-08-17	GSIG	ETF	8.1	8.24	8.0	8.15	351900.0
2001-08-17	IBB	ETF	27.3833	27.6167	27.2333	27.2333	313500.0
2001-08-17	ICF	ETF	22.075	22.1175	22.075	22.105	4400.0
2001-08-17	IDU	ETF	36.31	36.31	36.175	36.175	400.0
2001-08-17	IEV	ETF	30.775	30.775	30.41	30.465	27800.0
2001-08-17	IGLD	ETF	68.0	75.0	65.0	66.0	43.0
2001-08-17	IGM	ETF	8.35	8.35	8.275	8.275	49800.0
2001-08-17	IGV	ETF	8.35	8.37	8.33	8.33	1500.0
2001-08-17	IJH	ETF	9.982	9.982	9.883	9.883	134000.0
2001-08-17	IJJ	ETF	22.7	22.7375	22.5525	22.6275	46400.0
2001-08-17	IJK	ETF	13.6162	13.6162	13.4438	13.505	52800.0
2001-08-17	IJR	ETF	18.8133	18.8433	18.6967	18.77	885600.0
2001-08-17	IJS	ETF	21.3625	21.365	21.25	21.3	59200.0
2001-08-17	IJT	ETF	18.67	18.69	18.525	18.69	9600.0
2001-08-17	IOO	ETF	29.65	29.675	29.3	29.38	63400.0

> showing 50 of 103 rows — these rows as CSV

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