PREVIEW / etf_daily / 2002-06-27

all etf daily files

  file:    by_date/etf_daily/2002/2002-06-27.parquet
  size:    9 KB
  rows:    121

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-06-27	SPY	ETF	98.5	99.49	96.57	99.43	31616400.0
2002-06-27	QQQ	ETF	26.0	26.25	20.59	26.21	121391100.0
2002-06-27	IWM	ETF	45.65	45.85	44.74	45.85	4792200.0
2002-06-27	DIA	ETF	92.16	92.88	90.3	92.86	6814900.0
2002-06-27	AAA	ETF	49.56	49.56	49.0	49.0	1800.0
2002-06-27	ARB	ETF	31.6	31.64	30.74	31.0	175100.0
2002-06-27	BBH	ETF	27.6333	27.9167	27.0033	27.8733	2850900.0
2002-06-27	BITS	ETF	11.802	11.804	11.6	11.8	2375.0
2002-06-27	CEF	ETF	4.32	4.35	4.23	4.31	216500.0
2002-06-27	CHB	ETF	5.02	5.3	4.92	5.3	381900.0
2002-06-27	CNXT	ETF	1.4	1.53	1.28	1.47	29453110.0
2002-06-27	CSB	ETF	4.34999990463257	4.3600001335144	4.34999990463257	4.34999990463257	3400.0
2002-06-27	DGT	ETF	54.65	55.11	54.4	55.11	500.0
2002-06-27	EFA	ETF	38.4667	38.8433	38.18	38.8433	768300.0
2002-06-27	ELV	ETF	33.375	33.74	32.95	33.45	1206300.0
2002-06-27	EPP	ETF	18.66	18.8467	18.66	18.8467	145500.0
2002-06-27	EWA	ETF	9.92	10.08	9.89	10.01	224200.0
2002-06-27	EWC	ETF	10.65	10.65	10.49	10.63	338400.0
2002-06-27	EWD	ETF	11.49	11.6	11.36	11.56	6700.0
2002-06-27	EWG	ETF	13.78	14.05	13.6	14.05	37300.0
2002-06-27	EWH	ETF	8.69	8.95	8.68	8.85	562200.0
2002-06-27	EWI	ETF	32.52	32.74	32.04	32.36	4750.0
2002-06-27	EWJ	ETF	32.84	33.08	32.64	33.08	544800.0
2002-06-27	EWK	ETF	11.46	11.65	11.46	11.5	5700.0
2002-06-27	EWL	ETF	13.09	13.09	12.91	13.04	29400.0
2002-06-27	EWM	ETF	22.2	22.64	22.0	22.36	318650.0
2002-06-27	EWN	ETF	16.89	16.9	16.84	16.85	26600.0
2002-06-27	EWO	ETF	8.95	9.17	8.95	9.13	41000.0
2002-06-27	EWP	ETF	19.09	19.09	18.97	19.05	9600.0
2002-06-27	EWQ	ETF	17.52	17.73	17.39	17.65	75500.0
2002-06-27	EWS	ETF	10.1	10.4	10.1	10.2	4800.0
2002-06-27	EWT	ETF	19.9	19.9	19.54	19.72	83150.0
2002-06-27	EWU	ETF	27.38	27.58	27.02	27.4	34450.0
2002-06-27	EWW	ETF	13.96	14.25	13.8	14.25	549800.0
2002-06-27	EWY	ETF	21.15	21.3	20.77	21.3	240400.0
2002-06-27	EWZ	ETF	9.25	9.38	9.05	9.38	557600.0
2002-06-27	EZU	ETF	25.9	26.095	25.655	25.9	22400.0
2002-06-27	FCTR	ETF	18.53	19.5	18.35	19.39	33400.0
2002-06-27	FMAR	ETF	11.196	11.395	10.996	11.394	2900.0
2002-06-27	GLDB	ETF	10.41	10.84	10.2	10.84	309700.0
2002-06-27	GSIG	ETF	7.0	7.81	7.0	7.81	105000.0
2002-06-27	IBB	ETF	16.7333	16.7967	16.2667	16.7967	709500.0
2002-06-27	ICF	ETF	22.875	22.975	22.75	22.975	432800.0
2002-06-27	IDU	ETF	29.05	29.05	28.4	28.78	49000.0
2002-06-27	IEV	ETF	27.745	27.75	27.455	27.745	31000.0
2002-06-27	IGE	ETF	15.85	15.8583	15.85	15.8583	2400.0
2002-06-27	IGLD	ETF	101.0	101.0	101.0	101.0	89.0
2002-06-27	IGM	ETF	5.5733	5.5733	5.375	5.5633	33000.0
2002-06-27	IGN	ETF	14.82	14.82	14.05	14.68	3100.0
2002-06-27	IGV	ETF	5.45	5.48	5.358	5.48	19000.0

> showing 50 of 121 rows — these rows as CSV

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