PREVIEW / etf_daily / 2000-03-09

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-09.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-09	SPY	ETF	137.25	140.875	136.125	140.875	5500900.0
2000-03-09	QQQ	ETF	55.6094	57.75	54.5469	57.5	30101400.0
2000-03-09	DIA	ETF	98.8438	100.4375	97.3125	100.3281	1715100.0
2000-03-09	BBH	ETF	73.0833	73.0833	69.6667	70.1042	2320800.0
2000-03-09	BITS	ETF	34.75	47.625	33.0	43.25	313450.0
2000-03-09	BOSS	ETF	11.4	11.4	11.4	11.4	200.0
2000-03-09	CEF	ETF	3.5	3.5625	3.5	3.5	19800.0
2000-03-09	CHB	ETF	5.88	5.88	5.31	5.63	1255200.0
2000-03-09	CNXT	ETF	92.12	95.31	91.19	94.06	2994210.0
2000-03-09	EWA	ETF	10.5	10.5	10.25	10.25	4300.0
2000-03-09	EWC	ETF	17.3125	17.3125	17.3125	17.3125	3100.0
2000-03-09	EWD	ETF	36.1875	36.1875	35.8125	36.125	2300.0
2000-03-09	EWG	ETF	28.25	28.8125	28.0625	28.8125	131100.0
2000-03-09	EWH	ETF	14.0	14.0	13.75	14.0	58200.0
2000-03-09	EWI	ETF	53.875	54.5	53.75	54.25	4650.0
2000-03-09	EWJ	ETF	60.0	60.25	59.5	60.25	58425.0
2000-03-09	EWK	ETF	12.375	12.5	12.125	12.25	2100.0
2000-03-09	EWL	ETF	14.25	14.625	14.25	14.625	41500.0
2000-03-09	EWM	ETF	28.0	28.0	27.75	27.75	11925.0
2000-03-09	EWN	ETF	23.3125	23.75	23.3125	23.5625	8100.0
2000-03-09	EWO	ETF	7.3125	7.375	7.25	7.375	4200.0
2000-03-09	EWP	ETF	29.125	29.3125	29.0	29.25	5200.0
2000-03-09	EWQ	ETF	28.75	29.0625	28.5625	29.0625	94900.0
2000-03-09	EWS	ETF	14.125	14.5	14.0	14.375	63650.0
2000-03-09	EWU	ETF	39.625	40.25	39.375	40.25	77400.0
2000-03-09	EWW	ETF	20.75	20.8125	20.375	20.5625	16700.0
2000-03-09	FCTR	ETF	13.25	13.375	13.0	13.25	33500.0
2000-03-09	FMAR	ETF	6.5	6.5	5.0	5.62	23500.0
2000-03-09	GLDB	ETF	7.1875	7.25	7.125	7.125	43700.0
2000-03-09	GSIG	ETF	23.0	23.87	22.19	23.37	480100.0
2000-03-09	IGLD	ETF	2306.25	2887.5	2300.0	2725.0	4812.0
2000-03-09	KTEC	ETF	9.0625	9.5	8.875	9.25	23500.0
2000-03-09	MDY	ETF	87.4375	89.0625	86.875	89.0	245600.0
2000-03-09	MIG	ETF	5.875	5.875	5.75	5.75	5500.0
2000-03-09	PPH	ETF	39.3125	41.1875	38.6875	41.1562	766600.0
2000-03-09	SFY	ETF	13.4375	13.4375	12.5625	12.9375	61000.0
2000-03-09	TDSC	ETF	5.53	5.625	5.19	5.56	144200.0
2000-03-09	TINY	ETF	30.5	30.75	28.25	28.38	271200.0
2000-03-09	XLB	ETF	9.9453	10.125	9.914	10.1016	224800.0
2000-03-09	XLE	ETF	13.8438	14.0781	13.6875	14.0625	716800.0
2000-03-09	XLF	ETF	15.955	16.3231	15.8916	16.2343	385180.0
2000-03-09	XLI	ETF	25.5	25.8594	25.1875	25.7188	30400.0
2000-03-09	XLK	ETF	28.9688	29.875	28.6875	29.8125	571800.0
2000-03-09	XLP	ETF	19.3594	19.9688	19.25	19.8125	1267300.0
2000-03-09	XLU	ETF	12.5703	12.836	12.5703	12.789	313400.0
2000-03-09	XLV	ETF	27.4688	28.1562	27.375	28.0625	15400.0
2000-03-09	XLY	ETF	12.2578	12.6719	12.1406	12.6562	612800.0

> showing 47 of 47 rows — these rows as CSV

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