PREVIEW / etf_daily / 2002-07-18

all etf daily files

  file:    by_date/etf_daily/2002/2002-07-18.parquet
  size:    9 KB
  rows:    118

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-18	SPY	ETF	90.7	91.1	87.75	87.8	32656700.0
2002-07-18	QQQ	ETF	25.389	25.57	24.52	24.73	114052300.0
2002-07-18	IWM	ETF	40.65	40.95	39.45	39.45	1829400.0
2002-07-18	DIA	ETF	85.56	86.45	83.85	83.85	8068300.0
2002-07-18	AAA	ETF	49.98	49.98	48.8	49.0	8000.0
2002-07-18	ARB	ETF	31.15	32.34	31.15	32.3	289300.0
2002-07-18	BBH	ETF	25.0667	25.1133	23.8	23.81	6646800.0
2002-07-18	BITS	ETF	8.4	10.64	8.4	9.876	3225.0
2002-07-18	CEF	ETF	4.37	4.37	4.28	4.31	104100.0
2002-07-18	CHB	ETF	3.4	3.7	3.3	3.3	389100.0
2002-07-18	CNXT	ETF	2.52	2.65	2.5	2.57	4847910.0
2002-07-18	CSB	ETF	4.94999980926514	4.94999980926514	4.94999980926514	4.94999980926514	15000.0
2002-07-18	DGT	ETF	50.4	50.4	50.4	50.4	200.0
2002-07-18	EFA	ETF	37.3767	37.66	37.2067	37.23	582900.0
2002-07-18	ELV	ETF	32.75	34.25	32.4	32.75	2717600.0
2002-07-18	EPP	ETF	18.3133	18.3133	18.2	18.2667	107100.0
2002-07-18	EWA	ETF	9.42	9.57	9.36	9.36	248400.0
2002-07-18	EWC	ETF	9.75	9.99	9.75	9.95	1900.0
2002-07-18	EWD	ETF	11.04	11.05	10.55	10.55	122900.0
2002-07-18	EWG	ETF	13.55	13.55	13.3	13.42	113000.0
2002-07-18	EWH	ETF	8.64	8.65	8.43	8.45	63300.0
2002-07-18	EWI	ETF	31.38	31.38	30.86	31.32	1300.0
2002-07-18	EWJ	ETF	33.96	34.0	33.64	33.68	326150.0
2002-07-18	EWK	ETF	10.86	10.87	10.8	10.87	4000.0
2002-07-18	EWL	ETF	12.23	12.29	12.11	12.24	22900.0
2002-07-18	EWM	ETF	23.2	23.36	23.12	23.32	51500.0
2002-07-18	EWN	ETF	15.5	15.5	15.41	15.41	1500.0
2002-07-18	EWO	ETF	9.05	9.12	8.98	8.98	27800.0
2002-07-18	EWP	ETF	19.3	19.3	19.26	19.27	4700.0
2002-07-18	EWQ	ETF	16.54	16.77	16.47	16.55	7500.0
2002-07-18	EWS	ETF	10.98	10.98	10.7	10.7	19250.0
2002-07-18	EWT	ETF	20.96	20.96	20.44	20.44	3550.0
2002-07-18	EWU	ETF	25.96	26.58	25.72	26.26	111250.0
2002-07-18	EWW	ETF	14.6	14.69	14.41	14.53	89100.0
2002-07-18	EWY	ETF	22.78	22.99	22.51	22.74	11800.0
2002-07-18	EWZ	ETF	9.15	9.25	9.05	9.25	45900.0
2002-07-18	EZU	ETF	24.825	24.97	24.53	24.53	265000.0
2002-07-18	FCTR	ETF	17.45	17.99	17.45	17.78	25400.0
2002-07-18	FMAR	ETF	11.779	11.779	10.61	10.611	6800.0
2002-07-18	GLDB	ETF	10.78	10.8	10.45	10.5	139100.0
2002-07-18	GSIG	ETF	8.15	8.48	8.15	8.46	130200.0
2002-07-18	IBB	ETF	15.9333	15.9333	15.1833	15.1833	1858200.0
2002-07-18	ICF	ETF	21.1	21.1	20.675	20.6875	724800.0
2002-07-18	IDU	ETF	24.925	24.925	24.5	24.53	68600.0
2002-07-18	IEV	ETF	26.475	26.675	26.1	26.1	89600.0
2002-07-18	IGE	ETF	14.28	14.28	14.225	14.225	1800.0
2002-07-18	IGM	ETF	5.4667	5.515	5.3833	5.3917	32400.0
2002-07-18	IGN	ETF	16.25	16.25	15.73	15.9	40000.0
2002-07-18	IGV	ETF	5.01	5.03	4.886	4.896	38500.0
2002-07-18	IJH	ETF	8.905	8.905	8.631	8.657	153000.0

> showing 50 of 118 rows — these rows as CSV

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