PREVIEW / etf_daily / 2000-03-17

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-17.parquet
  size:    6 KB
  rows:    47

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-03-17	SPY	ETF	145.8125	148.0	145.4375	146.9375	10272900.0
2000-03-17	QQQ	ETF	54.0	55.5312	53.9688	55.4062	31422400.0
2000-03-17	DIA	ETF	106.0	107.7188	105.6719	106.125	3710500.0
2000-03-17	BBH	ETF	63.3125	64.1667	61.0	61.7917	1528800.0
2000-03-17	BITS	ETF	42.75	47.0	42.75	44.75	60050.0
2000-03-17	CEF	ETF	3.5	3.5	3.4375	3.4375	21000.0
2000-03-17	CHB	ETF	6.31	6.63	6.25	6.31	255900.0
2000-03-17	CNXT	ETF	79.44	80.44	77.62	79.18	7238160.0
2000-03-17	CSB	ETF	4.0	4.0	4.0	4.0	5000.0
2000-03-17	EWA	ETF	10.3125	10.5625	10.25	10.25	20600.0
2000-03-17	EWC	ETF	17.8125	17.8125	17.8125	17.8125	3300.0
2000-03-17	EWD	ETF	35.125	35.5	35.0625	35.3125	6300.0
2000-03-17	EWG	ETF	26.9375	28.0625	26.9375	28.0	116800.0
2000-03-17	EWH	ETF	13.625	13.625	13.5	13.5625	12700.0
2000-03-17	EWI	ETF	52.0	52.5	52.0	52.25	8500.0
2000-03-17	EWJ	ETF	60.5	60.5	59.75	60.0	185625.0
2000-03-17	EWK	ETF	13.25	13.3125	13.125	13.125	4800.0
2000-03-17	EWL	ETF	14.625	14.875	14.625	14.875	4100.0
2000-03-17	EWM	ETF	28.0	28.0	27.25	27.75	35100.0
2000-03-17	EWN	ETF	24.0	24.0	23.5625	23.625	17800.0
2000-03-17	EWO	ETF	7.6875	7.75	7.6875	7.75	1300.0
2000-03-17	EWP	ETF	29.0	29.375	29.0	29.0625	3600.0
2000-03-17	EWQ	ETF	28.5	28.625	28.3125	28.625	32600.0
2000-03-17	EWS	ETF	14.375	14.625	14.25	14.375	59600.0
2000-03-17	EWU	ETF	40.5	40.75	40.375	40.375	65400.0
2000-03-17	EWW	ETF	19.5	19.75	19.3125	19.625	35500.0
2000-03-17	FCTR	ETF	13.75	13.75	12.75	12.75	39100.0
2000-03-17	FMAR	ETF	6.03	6.03	5.75	5.75	4100.0
2000-03-17	GLDB	ETF	6.2188	6.8125	6.1719	6.625	89600.0
2000-03-17	GSIG	ETF	15.62	18.12	15.62	17.44	686600.0
2000-03-17	IGLD	ETF	2550.0	2781.25	2550.0	2781.25	549.0
2000-03-17	KTEC	ETF	9.0625	9.125	8.75	9.0625	18600.0
2000-03-17	MDY	ETF	88.875	90.0	88.5625	90.0	1274300.0
2000-03-17	MIG	ETF	5.375	5.375	5.375	5.375	3000.0
2000-03-17	PPH	ETF	43.8125	43.8125	42.375	42.4375	230800.0
2000-03-17	SFY	ETF	13.1875	13.1875	12.5625	12.5625	52200.0
2000-03-17	TDSC	ETF	5.5	5.69	5.345	5.69	126200.0
2000-03-17	TINY	ETF	27.5	28.0	26.19	26.31	100500.0
2000-03-17	XLB	ETF	11.4297	11.4297	11.0	11.0	130400.0
2000-03-17	XLE	ETF	14.3125	14.3125	13.8828	13.8906	299600.0
2000-03-17	XLF	ETF	18.8363	19.2425	18.7094	18.8236	1075771.0
2000-03-17	XLI	ETF	27.7969	28.125	27.3906	27.5938	34400.0
2000-03-17	XLK	ETF	29.375	30.0	29.3438	29.9375	882000.0
2000-03-17	XLP	ETF	21.625	21.6406	20.9219	21.0938	116000.0
2000-03-17	XLU	ETF	13.3281	13.5469	13.2812	13.3203	125600.0
2000-03-17	XLV	ETF	29.1562	29.5938	29.0625	29.3125	62000.0
2000-03-17	XLY	ETF	14.125	14.25	14.0312	14.1328	48600.0

> showing 47 of 47 rows — these rows as CSV

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