PREVIEW / etf_daily / 2001-10-24

all etf daily files

  file:    by_date/etf_daily/2001/2001-10-24.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-10-24	SPY	ETF	108.98	109.45	108.22	108.62	16065200.0
2001-10-24	QQQ	ETF	34.6	35.68	34.32	35.38	90177600.0
2001-10-24	IWM	ETF	42.5	42.69	42.3	42.675	527600.0
2001-10-24	DIA	ETF	93.65	94.0	92.85	93.45	2824200.0
2001-10-24	ARB	ETF	27.6	27.68	27.3	27.38	90700.0
2001-10-24	BBH	ETF	40.9333	41.55	40.7167	41.2667	3796500.0
2001-10-24	BITS	ETF	16.2	17.16	16.12	16.6	2950.0
2001-10-24	CEF	ETF	3.42	3.42	3.36	3.36	18200.0
2001-10-24	CHB	ETF	7.58	8.08	7.55	7.66	82600.0
2001-10-24	CNXT	ETF	10.8	11.76	10.7	11.2	5395390.0
2001-10-24	CSB	ETF	3.90000009536743	3.90000009536743	3.15000009536743	3.84999990463257	2600.0
2001-10-24	DGT	ETF	64.44	64.44	64.44	64.44	300.0
2001-10-24	EFA	ETF	39.1667	39.3333	39.0333	39.23	161100.0
2001-10-24	EWA	ETF	8.81	8.9	8.81	8.9	16500.0
2001-10-24	EWC	ETF	9.82	9.99	9.81	9.81	106100.0
2001-10-24	EWD	ETF	11.8	12.15	11.8	12.15	14900.0
2001-10-24	EWG	ETF	13.61	13.74	13.61	13.62	8600.0
2001-10-24	EWH	ETF	8.1	8.19	8.04	8.18	182400.0
2001-10-24	EWI	ETF	31.72	32.1	31.72	31.92	8000.0
2001-10-24	EWJ	ETF	34.64	34.84	34.56	34.68	37350.0
2001-10-24	EWK	ETF	10.44	10.44	10.44	10.44	1800.0
2001-10-24	EWL	ETF	12.35	12.35	12.23	12.23	1300.0
2001-10-24	EWM	ETF	17.92	18.32	17.92	18.32	3050.0
2001-10-24	EWN	ETF	16.4	16.4	16.39	16.39	500.0
2001-10-24	EWO	ETF	6.87	6.87	6.81	6.81	1700.0
2001-10-24	EWP	ETF	19.9	19.99	19.86	19.99	1100.0
2001-10-24	EWQ	ETF	17.86	18.15	17.86	18.14	2600.0
2001-10-24	EWS	ETF	9.0	9.08	8.98	9.08	7700.0
2001-10-24	EWT	ETF	15.8	16.02	15.8	15.98	41400.0
2001-10-24	EWU	ETF	28.6	28.9	28.48	28.88	7700.0
2001-10-24	EWW	ETF	13.34	13.61	13.25	13.61	55000.0
2001-10-24	EWY	ETF	12.9	13.09	12.9	13.09	12700.0
2001-10-24	EWZ	ETF	9.7	9.74	9.59	9.59	3400.0
2001-10-24	EZU	ETF	26.05	26.63	26.05	26.475	12400.0
2001-10-24	FCTR	ETF	17.5	17.5	17.12	17.34	9800.0
2001-10-24	FMAR	ETF	7.93	8.05	7.9	7.9	2900.0
2001-10-24	GLDB	ETF	7.52	7.57	7.42	7.45	31800.0
2001-10-24	GSIG	ETF	7.61	7.79	7.51	7.76	47700.0
2001-10-24	IBB	ETF	28.4167	28.65	28.1333	28.5167	731100.0
2001-10-24	ICF	ETF	19.62	19.62	19.4725	19.5425	37600.0
2001-10-24	IDU	ETF	33.125	33.125	31.99	32.23	7800.0
2001-10-24	IEV	ETF	28.175	28.575	28.175	28.375	68400.0
2001-10-24	IGLD	ETF	70.0	74.0	69.0	74.0	658.0
2001-10-24	IGM	ETF	7.5	7.5583	7.4917	7.525	61800.0
2001-10-24	IGN	ETF	29.85	29.94	29.85	29.94	800.0
2001-10-24	IGV	ETF	7.56	7.77	7.56	7.77	13500.0
2001-10-24	IJH	ETF	9.057	9.125	9.057	9.111	338000.0
2001-10-24	IJJ	ETF	20.35	20.35	20.19	20.25	40400.0
2001-10-24	IJK	ETF	12.625	12.7275	12.6238	12.685	45600.0
2001-10-24	IJR	ETF	16.775	16.8167	16.6967	16.795	213000.0

> showing 50 of 106 rows — these rows as CSV

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