PREVIEW / etf_daily / 2000-10-31

all etf daily files

  file:    by_date/etf_daily/2000/2000-10-31.parquet
  size:    8 KB
  rows:    85

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
2000-10-31	SPY	ETF	141.0156	143.6875	140.0625	142.9531	7752400.0
2000-10-31	QQQ	ETF	78.0	82.5625	77.875	81.7031	43863800.0
2000-10-31	IWM	ETF	48.4375	49.6797	48.4375	49.5	285000.0
2000-10-31	DIA	ETF	108.9219	109.9219	107.8438	109.4062	4993400.0
2000-10-31	BBH	ETF	57.7917	60.0417	57.5417	59.125	2834700.0
2000-10-31	BITS	ETF	13.375	14.0	12.5	12.75	9175.0
2000-10-31	CEF	ETF	3.0	3.0	2.875	2.875	118600.0
2000-10-31	CHB	ETF	3.69	4.0	3.69	3.75	139300.0
2000-10-31	CNXT	ETF	23.87	27.12	23.62	26.31	6170210.0
2000-10-31	EWA	ETF	8.875	9.0	8.8125	9.0	30800.0
2000-10-31	EWC	ETF	14.4375	14.9375	14.3125	14.875	25700.0
2000-10-31	EWD	ETF	19.9375	20.8125	19.9375	20.8125	7600.0
2000-10-31	EWG	ETF	19.1875	19.5	19.1875	19.5	52800.0
2000-10-31	EWH	ETF	11.375	11.5625	11.1875	11.4375	244200.0
2000-10-31	EWI	ETF	43.25	43.5	43.0	43.5	16750.0
2000-10-31	EWJ	ETF	50.25	50.75	50.0	50.75	94300.0
2000-10-31	EWK	ETF	12.3125	12.8125	12.3125	12.8125	5900.0
2000-10-31	EWL	ETF	14.875	15.5625	14.875	15.3125	49100.0
2000-10-31	EWM	ETF	22.5	23.0	22.5	23.0	19850.0
2000-10-31	EWN	ETF	22.125	22.875	22.125	22.75	26800.0
2000-10-31	EWO	ETF	7.0625	7.25	7.0625	7.1875	18600.0
2000-10-31	EWP	ETF	23.0625	23.5	23.0625	23.5	21600.0
2000-10-31	EWQ	ETF	23.75	24.3125	23.75	24.3125	36800.0
2000-10-31	EWS	ETF	13.5	14.0	13.5	13.75	56700.0
2000-10-31	EWT	ETF	24.625	25.25	24.625	24.875	23600.0
2000-10-31	EWU	ETF	35.625	36.875	35.625	36.75	35900.0
2000-10-31	EWW	ETF	15.5625	15.8125	15.3125	15.8125	66700.0
2000-10-31	EWY	ETF	13.625	13.75	13.5625	13.6875	4000.0
2000-10-31	EWZ	ETF	16.125	16.125	16.125	16.125	500.0
2000-10-31	EZU	ETF	35.6875	35.9375	35.6875	35.9375	2000.0
2000-10-31	FCTR	ETF	15.375	15.625	15.375	15.4375	92900.0
2000-10-31	FMAR	ETF	4.88	4.88	4.88	4.88	100.0
2000-10-31	GLDB	ETF	4.25	4.625	4.25	4.625	121800.0
2000-10-31	GSIG	ETF	11.5	13.19	11.5	12.62	322000.0
2000-10-31	IDU	ETF	41.0	41.4531	40.7969	41.4531	8000.0
2000-10-31	IEV	ETF	36.375	36.5	36.3125	36.4062	181200.0
2000-10-31	IGLD	ETF	321.875	337.5	318.75	331.25	676.0
2000-10-31	IJH	ETF	10.225	10.4469	10.225	10.4	1051000.0
2000-10-31	IJJ	ETF	19.375	19.4805	19.3125	19.4805	34400.0
2000-10-31	IJK	ETF	16.8496	17.2461	16.8496	17.2344	52800.0
2000-10-31	IJR	ETF	17.5208	18.2031	17.5208	18.2031	295200.0
2000-10-31	IJS	ETF	17.6016	17.9062	17.6016	17.9062	6400.0
2000-10-31	IJT	ETF	20.6562	21.125	20.6562	21.125	4000.0
2000-10-31	IUSG	ETF	30.9297	30.9297	30.9297	30.9297	200.0
2000-10-31	IUSV	ETF	24.8698	25.1354	24.8021	25.1042	350700.0
2000-10-31	IVE	ETF	63.75	64.2812	63.4375	64.2188	33700.0
2000-10-31	IVV	ETF	141.1406	143.7188	141.0312	143.1406	124000.0
2000-10-31	IVW	ETF	19.7422	20.1875	19.7227	20.125	177200.0
2000-10-31	IWB	ETF	75.04	76.42	75.02	76.42	10400.0
2000-10-31	IWD	ETF	58.9375	59.5938	58.7656	59.5312	17400.0

> showing 50 of 85 rows — these rows as CSV

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