PREVIEW / etf_daily / 2001-08-23

all etf daily files

  file:    by_date/etf_daily/2001/2001-08-23.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-08-23	SPY	ETF	116.96	117.52	116.49	116.6	8744100.0
2001-08-23	QQQ	ETF	37.679	38.46	37.299	37.32	54711800.0
2001-08-23	IWM	ETF	47.6	47.995	47.05	47.05	842200.0
2001-08-23	DIA	ETF	102.65	103.04	102.23	102.45	2266300.0
2001-08-23	BBH	ETF	39.75	41.66	39.4667	41.3667	5621400.0
2001-08-23	BITS	ETF	16.56	16.8	16.0	16.24	11125.0
2001-08-23	CEF	ETF	3.2	3.25	3.2	3.25	7000.0
2001-08-23	CHB	ETF	9.35	9.5	9.06	9.13	131500.0
2001-08-23	CNXT	ETF	10.15	11.34	10.08	11.05	7625400.0
2001-08-23	CSB	ETF	3.0	4.0	3.0	3.15000009536743	410800.0
2001-08-23	DGT	ETF	66.86	66.86	66.86	66.86	2000.0
2001-08-23	EWA	ETF	9.66	9.75	9.66	9.74	1300.0
2001-08-23	EWC	ETF	10.86	11.17	10.85	10.96	1900.0
2001-08-23	EWD	ETF	13.49	13.65	13.49	13.65	1400.0
2001-08-23	EWG	ETF	15.74	15.74	15.6	15.61	20300.0
2001-08-23	EWH	ETF	9.05	9.27	9.05	9.16	24000.0
2001-08-23	EWI	ETF	37.08	37.08	36.72	36.72	500.0
2001-08-23	EWJ	ETF	37.72	37.96	37.44	37.44	170475.0
2001-08-23	EWL	ETF	13.28	13.28	13.04	13.06	1300.0
2001-08-23	EWM	ETF	19.12	19.4	19.04	19.08	2575.0
2001-08-23	EWP	ETF	21.71	21.89	21.71	21.89	3400.0
2001-08-23	EWQ	ETF	20.2	20.2	20.15	20.15	14700.0
2001-08-23	EWS	ETF	10.54	10.66	10.54	10.66	15650.0
2001-08-23	EWT	ETF	17.92	18.38	17.92	18.18	1800.0
2001-08-23	EWU	ETF	30.94	31.2	30.66	30.94	10900.0
2001-08-23	EWW	ETF	15.38	15.5	15.38	15.39	7000.0
2001-08-23	EWY	ETF	13.7	14.0	13.7	13.8	17300.0
2001-08-23	EWZ	ETF	12.3	12.3	12.3	12.3	2000.0
2001-08-23	EZU	ETF	29.525	29.72	29.475	29.665	22600.0
2001-08-23	FCTR	ETF	18.3	18.5	17.95	18.05	25300.0
2001-08-23	FMAR	ETF	9.15	9.45	9.1	9.45	15600.0
2001-08-23	GLDB	ETF	7.71	7.75	7.62	7.62	37300.0
2001-08-23	GSIG	ETF	8.03	8.38	7.94	8.35	44700.0
2001-08-23	IBB	ETF	28.1667	29.2667	28.1667	29.13	419400.0
2001-08-23	ICF	ETF	22.42	22.49	22.405	22.4625	24400.0
2001-08-23	IDU	ETF	36.56	36.85	36.56	36.7	5600.0
2001-08-23	IEV	ETF	30.725	31.02	30.675	30.76	67400.0
2001-08-23	IGLD	ETF	62.0	64.0	59.0	62.0	128.0
2001-08-23	IGM	ETF	8.2583	8.29	8.25	8.29	25800.0
2001-08-23	IGV	ETF	8.35	8.35	8.07	8.07	5500.0
2001-08-23	IJH	ETF	9.974	10.035	9.954	9.957	400000.0
2001-08-23	IJJ	ETF	22.6925	22.8125	22.6225	22.6575	30000.0
2001-08-23	IJK	ETF	13.55	13.6988	13.55	13.5862	56000.0
2001-08-23	IJR	ETF	18.7433	18.8917	18.6017	18.6017	679800.0
2001-08-23	IJS	ETF	21.1825	21.3075	21.0025	21.0125	59600.0
2001-08-23	IJT	ETF	18.735	18.81	18.5225	18.5225	8800.0
2001-08-23	IOO	ETF	29.68	29.68	29.47	29.47	41600.0
2001-08-23	IUSG	ETF	20.355	20.47	20.295	20.335	14600.0
2001-08-23	IUSV	ETF	24.5433	24.56	24.4667	24.4667	118200.0
2001-08-23	IVE	ETF	58.4	58.59	58.15	58.25	26200.0

> showing 50 of 99 rows — these rows as CSV

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