PREVIEW / etf_daily / 2002-09-18

all etf daily files

  file:    by_date/etf_daily/2002/2002-09-18.parquet
  size:    9 KB
  rows:    123

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-09-18	SPY	ETF	87.01	88.5	86.28	86.95	54719400.0
2002-09-18	QQQ	ETF	22.01	22.55	21.78	21.93	92413000.0
2002-09-18	IWM	ETF	37.325	37.85	37.1	37.775	2323200.0
2002-09-18	DIA	ETF	81.41	82.9	80.77	81.42	11649100.0
2002-09-18	TLT	ETF	89.16	89.56	89.02	89.12	196600.0
2002-09-18	AAA	ETF	39.69	40.77	39.69	40.71	8700.0
2002-09-18	ARB	ETF	31.6	32.13	31.01	31.85	58300.0
2002-09-18	BBH	ETF	27.2767	27.5667	26.35	27.2333	3552000.0
2002-09-18	BITS	ETF	10.2	10.2	10.0	10.04	26042.0
2002-09-18	CEF	ETF	4.27	4.3	4.25	4.29	122400.0
2002-09-18	CHB	ETF	2.62	2.65	2.49	2.49	115200.0
2002-09-18	CNXT	ETF	1.3054	1.3553	1.2656	1.2746	3518800.0
2002-09-18	CSB	ETF	6.69999980926514	6.69999980926514	6.63000011444092	6.65000009536743	30000.0
2002-09-18	DGT	ETF	47.65	48.5	47.65	48.5	15100.0
2002-09-18	EFA	ETF	32.8167	32.85	32.4533	32.8167	1149900.0
2002-09-18	ELV	ETF	34.5	34.765	34.025	34.62	1127600.0
2002-09-18	EPP	ETF	17.29	17.3967	17.27	17.3333	10800.0
2002-09-18	EWA	ETF	9.4	9.4	9.24	9.39	14400.0
2002-09-18	EWC	ETF	8.91	9.14	8.86	9.04	7000.0
2002-09-18	EWD	ETF	8.9	8.9	8.85	8.85	32000.0
2002-09-18	EWG	ETF	10.22	10.4	10.04	10.1	58000.0
2002-09-18	EWH	ETF	7.59	7.59	7.37	7.53	26100.0
2002-09-18	EWI	ETF	27.9	27.9	27.64	27.66	1000.0
2002-09-18	EWJ	ETF	29.8	30.92	29.8	30.72	583100.0
2002-09-18	EWL	ETF	10.57	10.91	10.55	10.91	12000.0
2002-09-18	EWM	ETF	21.8	21.88	21.48	21.88	6200.0
2002-09-18	EWN	ETF	12.8	12.8	12.8	12.8	100.0
2002-09-18	EWO	ETF	7.8	7.8	7.75	7.75	7700.0
2002-09-18	EWP	ETF	16.42	16.6	16.4	16.6	1400.0
2002-09-18	EWQ	ETF	13.96	14.0	13.9	14.0	45100.0
2002-09-18	EWS	ETF	9.46	9.46	9.18	9.42	16300.0
2002-09-18	EWT	ETF	16.2	16.2	16.02	16.06	5700.0
2002-09-18	EWU	ETF	24.16	24.16	23.5	24.12	32100.0
2002-09-18	EWW	ETF	12.91	13.02	12.8	12.91	46100.0
2002-09-18	EWY	ETF	20.2	20.3	20.01	20.2	17000.0
2002-09-18	EWZ	ETF	7.25	7.44	7.12	7.17	278300.0
2002-09-18	EZU	ETF	20.4	20.57	20.205	20.435	32600.0
2002-09-18	FCTR	ETF	16.85	17.0	16.55	17.0	23400.0
2002-09-18	FMAR	ETF	10.5	10.5	10.499	10.5	5900.0
2002-09-18	GLDB	ETF	9.81	9.98	9.8	9.88	29200.0
2002-09-18	GRNB	ETF	16.1974	16.1974	16.1974	16.1974	3230.0
2002-09-18	GSIG	ETF	5.44	5.49	5.36	5.38	80100.0
2002-09-18	IBB	ETF	16.0667	16.3333	15.6433	16.1333	1501500.0
2002-09-18	ICF	ETF	21.275	21.315	21.1375	21.1525	46800.0
2002-09-18	IDU	ETF	23.35	24.4	23.175	24.025	258000.0
2002-09-18	IEF	ETF	85.92	86.22	85.91	86.0	76400.0
2002-09-18	IEV	ETF	22.625	22.995	22.505	22.6	123400.0
2002-09-18	IGE	ETF	13.1833	13.235	13.0533	13.2	91800.0
2002-09-18	IGLD	ETF	98.0	98.1	98.0	98.1	67.0
2002-09-18	IGM	ETF	4.5417	4.63	4.51	4.5917	121200.0

> showing 50 of 123 rows — these rows as CSV

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