PREVIEW / etf_daily / 2000-01-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-01-27.parquet
  size:    6 KB
  rows:    45

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-01-27	SPY	ETF	141.8438	142.2188	138.125	140.25	10922700.0
2000-01-27	DIA	ETF	111.125	111.6094	109.1875	110.4688	853900.0
2000-01-27	BBH	ETF	56.9792	57.0	54.0833	55.1667	1278300.0
2000-01-27	BITS	ETF	24.25	29.0	23.0	27.5	467700.0
2000-01-27	CEF	ETF	3.4375	3.5	3.375	3.4375	27400.0
2000-01-27	CHB	ETF	8.25	8.25	8.06	8.13	195400.0
2000-01-27	CNXT	ETF	89.0	89.94	85.0	87.56	14264310.0
2000-01-27	CSB	ETF	2.75	2.75	2.75	2.75	2000.0
2000-01-27	EWA	ETF	10.8125	10.8125	10.75	10.75	5300.0
2000-01-27	EWC	ETF	17.1875	17.3125	17.0625	17.0625	2900.0
2000-01-27	EWD	ETF	30.0625	30.125	29.875	29.875	19200.0
2000-01-27	EWG	ETF	26.25	26.625	26.125	26.4375	62600.0
2000-01-27	EWH	ETF	13.25	13.4375	13.125	13.375	132300.0
2000-01-27	EWI	ETF	48.125	48.875	48.125	48.875	6550.0
2000-01-27	EWJ	ETF	61.75	62.25	60.5	60.5	105100.0
2000-01-27	EWK	ETF	13.9375	14.0	13.8125	13.9375	5600.0
2000-01-27	EWL	ETF	15.0	15.1875	15.0	15.1875	49000.0
2000-01-27	EWM	ETF	29.0	29.5	29.0	29.0	16150.0
2000-01-27	EWN	ETF	23.5	23.625	23.25	23.25	9800.0
2000-01-27	EWO	ETF	8.1875	8.25	8.1875	8.1875	3900.0
2000-01-27	EWP	ETF	26.75	27.0625	26.75	26.9375	39200.0
2000-01-27	EWQ	ETF	26.25	26.5625	26.25	26.375	32800.0
2000-01-27	EWS	ETF	17.125	17.375	16.5	16.5	74850.0
2000-01-27	EWU	ETF	39.875	40.5	39.875	40.375	43850.0
2000-01-27	EWW	ETF	17.0625	17.375	17.0	17.1875	29600.0
2000-01-27	FCTR	ETF	13.875	14.0	13.875	13.9375	12300.0
2000-01-27	FMAR	ETF	7.48	7.48	6.79	6.79	11720.0
2000-01-27	GLDB	ETF	9.0	9.125	8.75	9.0	10300.0
2000-01-27	GSIG	ETF	12.59	12.87	12.0	12.25	122400.0
2000-01-27	IGLD	ETF	1993.75	2150.0	1950.0	2112.5	1714.0
2000-01-27	KTEC	ETF	9.9375	10.0	8.5	9.0	63300.0
2000-01-27	MDY	ETF	81.6562	82.4062	79.875	81.2969	901400.0
2000-01-27	MIG	ETF	6.125	6.25	6.125	6.125	18700.0
2000-01-27	SFY	ETF	11.4375	11.4375	10.8125	11.0	46000.0
2000-01-27	TDSC	ETF	4.985	5.045	4.625	4.81	159200.0
2000-01-27	TINY	ETF	11.69	12.12	10.75	11.0	194500.0
2000-01-27	XLB	ETF	12.0	12.086	11.875	11.9375	108600.0
2000-01-27	XLE	ETF	13.8281	13.9375	13.3203	13.5	3377600.0
2000-01-27	XLF	ETF	18.7729	19.0013	18.5825	18.8871	262572.0
2000-01-27	XLI	ETF	27.6406	28.2812	27.6406	27.7344	156000.0
2000-01-27	XLK	ETF	25.9375	26.0625	24.8594	25.375	2476200.0
2000-01-27	XLP	ETF	22.5781	23.0312	22.3906	23.0	67800.0
2000-01-27	XLU	ETF	13.4062	13.4688	13.2812	13.2812	37400.0
2000-01-27	XLV	ETF	31.2031	31.3906	30.875	30.875	10700.0
2000-01-27	XLY	ETF	14.2031	14.2031	13.8281	14.0547	238200.0

> showing 45 of 45 rows — these rows as CSV

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