PREVIEW / etf_daily / 2002-07-31

all etf daily files

  file:    by_date/etf_daily/2002/2002-07-31.parquet
  size:    9 KB
  rows:    124

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
2002-07-31	SPY	ETF	90.49	91.55	89.25	91.16	44669900.0
2002-07-31	QQQ	ETF	24.003	24.19	23.36	23.85	93884600.0
2002-07-31	IWM	ETF	39.895	39.95	39.175	39.275	1834800.0
2002-07-31	DIA	ETF	86.63	87.39	85.39	87.15	10756000.0
2002-07-31	TLT	ETF	81.95	82.8	81.9	82.53	29400.0
2002-07-31	AAA	ETF	49.85	49.85	49.7	49.7	1100.0
2002-07-31	ARB	ETF	34.25	34.25	33.0	33.65	92900.0
2002-07-31	BBH	ETF	27.3333	28.4833	27.2333	28.1667	7329300.0
2002-07-31	BITS	ETF	9.88	10.0	8.4	9.48	4100.0
2002-07-31	CEF	ETF	4.1	4.14	3.93	4.02	131700.0
2002-07-31	CHB	ETF	4.3	4.55	4.05	4.1	281700.0
2002-07-31	CNXT	ETF	1.9906	2.1187	1.8231	2.03	6901430.0
2002-07-31	DGT	ETF	51.4	51.4	51.4	51.4	300.0
2002-07-31	EFA	ETF	35.45	35.83	35.1333	35.75	600900.0
2002-07-31	ELV	ETF	32.625	34.565	32.38	33.94	6049400.0
2002-07-31	EPP	ETF	17.6467	17.6467	17.5	17.5967	48000.0
2002-07-31	EWA	ETF	9.09	9.14	8.98	9.14	32800.0
2002-07-31	EWC	ETF	9.25	9.42	9.21	9.26	14400.0
2002-07-31	EWD	ETF	9.85	10.0	9.71	9.86	94000.0
2002-07-31	EWG	ETF	12.33	12.33	12.0	12.17	148300.0
2002-07-31	EWH	ETF	8.27	8.37	8.22	8.37	71100.0
2002-07-31	EWI	ETF	29.8	30.0	29.64	30.0	7150.0
2002-07-31	EWJ	ETF	31.4	31.68	31.2	31.44	174400.0
2002-07-31	EWK	ETF	10.3	10.3	10.25	10.25	6200.0
2002-07-31	EWL	ETF	11.89	11.89	11.61	11.67	20300.0
2002-07-31	EWM	ETF	23.36	23.36	22.72	22.72	22075.0
2002-07-31	EWN	ETF	14.06	14.49	14.01	14.48	19200.0
2002-07-31	EWO	ETF	8.12	8.2	8.1	8.2	1700.0
2002-07-31	EWP	ETF	17.5	17.61	17.5	17.61	9000.0
2002-07-31	EWQ	ETF	15.65	15.76	15.27	15.6	137500.0
2002-07-31	EWS	ETF	10.16	10.16	9.8	9.82	22950.0
2002-07-31	EWT	ETF	18.56	18.56	17.76	17.84	41550.0
2002-07-31	EWU	ETF	25.78	26.26	25.42	26.2	48850.0
2002-07-31	EWW	ETF	13.48	13.48	13.05	13.2	534000.0
2002-07-31	EWY	ETF	20.65	20.75	20.1	20.25	264700.0
2002-07-31	EWZ	ETF	6.91	7.04	6.5	6.98	1816500.0
2002-07-31	EZU	ETF	23.025	23.15	22.675	23.15	27800.0
2002-07-31	FCTR	ETF	16.011	16.8	16.011	16.8	318000.0
2002-07-31	FMAR	ETF	10.33	10.55	10.33	10.46	13100.0
2002-07-31	GLDB	ETF	9.81	10.0	9.69	9.69	46300.0
2002-07-31	GRNB	ETF	15.7065	15.7065	15.7065	15.7065	4643.0
2002-07-31	GSIG	ETF	6.63	6.73	6.52	6.72	37500.0
2002-07-31	IBB	ETF	16.75	17.4267	16.6067	17.2	5329800.0
2002-07-31	ICF	ETF	21.8125	22.025	21.4	22.025	143600.0
2002-07-31	IDU	ETF	25.385	25.925	24.8	25.615	142000.0
2002-07-31	IEF	ETF	82.05	82.58	82.05	82.52	32600.0
2002-07-31	IEV	ETF	25.275	25.825	24.955	25.825	167800.0
2002-07-31	IGE	ETF	13.6083	13.7833	13.6083	13.7833	3600.0
2002-07-31	IGLD	ETF	105.0	105.0	103.1	103.1	16.0
2002-07-31	IGM	ETF	5.1	5.1067	4.9833	4.9917	43800.0

> showing 50 of 124 rows — these rows as CSV

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