PREVIEW / etf_daily / 2001-09-25

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-25.parquet
  size:    9 KB
  rows:    106

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-09-25	SPY	ETF	100.75	102.0	99.9	101.75	25466200.0
2001-09-25	QQQ	ETF	29.71	30.43	28.95	29.7	83861500.0
2001-09-25	IWM	ETF	39.12	39.75	38.875	39.475	924600.0
2001-09-25	DIA	ETF	86.25	87.2	85.05	86.9	7317500.0
2001-09-25	BBH	ETF	34.3333	35.3	34.1833	34.9967	4930800.0
2001-09-25	BITS	ETF	11.2	11.76	10.8	11.08	17700.0
2001-09-25	CEF	ETF	3.63	3.63	3.48	3.51	51100.0
2001-09-25	CHB	ETF	7.5	7.5	6.8	7.05	165300.0
2001-09-25	CNXT	ETF	9.51	10.02	9.008	9.18	3396630.0
2001-09-25	DGT	ETF	59.2	59.6	59.2	59.6	1800.0
2001-09-25	EFA	ETF	36.1333	36.4333	35.85	36.1667	151500.0
2001-09-25	EWA	ETF	7.9	8.0	7.9	8.0	4700.0
2001-09-25	EWC	ETF	9.45	9.6	9.45	9.6	17800.0
2001-09-25	EWD	ETF	10.8	10.83	10.8	10.83	5800.0
2001-09-25	EWG	ETF	12.05	12.23	11.9	12.0	56800.0
2001-09-25	EWH	ETF	7.34	7.58	7.15	7.24	72800.0
2001-09-25	EWI	ETF	27.5	28.1	27.5	27.9	6650.0
2001-09-25	EWJ	ETF	33.6	33.64	33.0	33.4	76100.0
2001-09-25	EWK	ETF	10.2	10.2	10.01	10.01	400.0
2001-09-25	EWL	ETF	11.5	11.85	11.5	11.85	4300.0
2001-09-25	EWM	ETF	16.8	17.08	16.8	17.0	5000.0
2001-09-25	EWN	ETF	15.0	15.5	15.0	15.2	10600.0
2001-09-25	EWO	ETF	7.2	7.2	7.2	7.2	700.0
2001-09-25	EWP	ETF	18.0	18.0	17.75	17.75	700.0
2001-09-25	EWQ	ETF	16.35	16.65	16.35	16.4	21400.0
2001-09-25	EWS	ETF	8.12	8.38	8.12	8.22	7650.0
2001-09-25	EWT	ETF	13.9	13.9	13.36	13.5	53950.0
2001-09-25	EWU	ETF	26.68	26.7	25.7	25.7	22350.0
2001-09-25	EWW	ETF	12.6	12.6	12.1	12.5	1800.0
2001-09-25	EWY	ETF	11.0	11.14	10.92	10.95	10300.0
2001-09-25	EWZ	ETF	9.18	9.2	8.88	8.88	1600.0
2001-09-25	EZU	ETF	23.625	23.975	23.6	23.6	4600.0
2001-09-25	FCTR	ETF	16.42	16.95	16.36	16.69	51200.0
2001-09-25	FMAR	ETF	7.6	7.6	7.5	7.5	1500.0
2001-09-25	GLDB	ETF	7.18	7.33	7.12	7.3	91600.0
2001-09-25	GSIG	ETF	6.7	7.0	6.65	6.75	128100.0
2001-09-25	IBB	ETF	23.3333	23.6167	23.05	23.3667	118500.0
2001-09-25	ICF	ETF	20.125	20.3175	20.125	20.25	23600.0
2001-09-25	IDU	ETF	33.7	33.7	33.465	33.625	7000.0
2001-09-25	IEV	ETF	26.0	26.325	25.7	26.05	89800.0
2001-09-25	IGLD	ETF	64.0	64.0	60.0	60.0	83.0
2001-09-25	IGM	ETF	6.4	6.6167	6.3333	6.475	48000.0
2001-09-25	IGN	ETF	25.25	25.25	25.25	25.25	100.0
2001-09-25	IGV	ETF	6.33	6.33	6.33	6.33	500.0
2001-09-25	IJH	ETF	8.4	8.44	8.32	8.393	125000.0
2001-09-25	IJJ	ETF	19.2375	19.3375	19.125	19.2875	50400.0
2001-09-25	IJK	ETF	11.275	11.4	11.1625	11.3188	28800.0
2001-09-25	IJR	ETF	15.5083	15.7283	15.5083	15.6583	1500600.0
2001-09-25	IJS	ETF	17.4375	17.545	17.3125	17.3875	51200.0
2001-09-25	IJT	ETF	15.775	15.845	15.6875	15.845	33200.0

> showing 50 of 106 rows — these rows as CSV

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