PREVIEW / etf_daily / 2000-01-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-01-18.parquet
  size:    6 KB
  rows:    46

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-18	SPY	ETF	145.3438	146.625	145.1875	145.8125	6488500.0
2000-01-18	DIA	ETF	116.4375	116.875	115.5	115.7188	656500.0
2000-01-18	BBH	ETF	52.8333	54.5	52.3333	53.9167	810000.0
2000-01-18	BITS	ETF	21.125	23.0	21.0	23.0	51000.0
2000-01-18	BOSS	ETF	11.0	11.0	11.0	11.0	700.0
2000-01-18	CEF	ETF	3.625	3.625	3.5	3.5	68000.0
2000-01-18	CHB	ETF	8.19	8.19	8.13	8.13	62000.0
2000-01-18	CNXT	ETF	74.62	83.31	74.12	81.31	5856200.0
2000-01-18	CSB	ETF	2.70000004768372	2.70000004768372	2.59999990463257	2.59999990463257	2600.0
2000-01-18	EWA	ETF	11.125	11.25	11.0	11.25	13200.0
2000-01-18	EWC	ETF	16.5	16.625	16.3125	16.625	7400.0
2000-01-18	EWD	ETF	30.4375	30.625	30.3125	30.3125	3700.0
2000-01-18	EWG	ETF	27.3125	27.375	27.0625	27.25	88200.0
2000-01-18	EWH	ETF	13.0625	13.1875	13.0	13.0	94700.0
2000-01-18	EWI	ETF	48.5	48.75	48.25	48.5	2250.0
2000-01-18	EWJ	ETF	62.5	62.5	60.75	61.0	158450.0
2000-01-18	EWK	ETF	14.6875	14.8125	14.5625	14.75	20300.0
2000-01-18	EWL	ETF	15.75	16.0	15.75	15.8125	18100.0
2000-01-18	EWM	ETF	31.75	33.0	31.75	32.75	105975.0
2000-01-18	EWN	ETF	24.375	24.4375	24.1875	24.4375	15200.0
2000-01-18	EWO	ETF	8.5625	8.5625	8.4375	8.5	3700.0
2000-01-18	EWP	ETF	27.0625	27.125	26.875	27.0469	6600.0
2000-01-18	EWQ	ETF	26.5	26.5625	26.1875	26.4688	30600.0
2000-01-18	EWS	ETF	17.5	17.625	16.875	17.25	153300.0
2000-01-18	EWU	ETF	41.125	41.375	40.875	41.1562	38650.0
2000-01-18	EWW	ETF	18.625	18.75	18.375	18.5625	26800.0
2000-01-18	FCTR	ETF	14.6875	14.875	14.5625	14.625	8200.0
2000-01-18	FMAR	ETF	8.1	8.1	7.6	7.6	6520.0
2000-01-18	GLDB	ETF	9.0	9.25	8.875	8.9375	112300.0
2000-01-18	GSIG	ETF	10.56	11.0	10.5	10.94	138600.0
2000-01-18	IGLD	ETF	2068.75	2075.0	1975.0	2000.0	3996.0
2000-01-18	KTEC	ETF	9.625	9.75	9.0	9.0	5800.0
2000-01-18	MDY	ETF	81.875	82.75	81.625	82.5938	857100.0
2000-01-18	MIG	ETF	7.0	7.0	6.75	6.875	13300.0
2000-01-18	SFY	ETF	11.875	12.9375	11.875	12.9375	173000.0
2000-01-18	TDSC	ETF	3.735	3.875	3.44	3.75	119200.0
2000-01-18	TINY	ETF	10.88	11.94	10.75	11.0	226700.0
2000-01-18	XLB	ETF	13.1094	13.1562	12.8438	12.961	68800.0
2000-01-18	XLE	ETF	13.9375	14.2812	13.9375	14.2031	221000.0
2000-01-18	XLF	ETF	19.3694	19.3694	18.7855	18.7855	466180.0
2000-01-18	XLI	ETF	28.7812	29.0938	28.7656	28.9688	83600.0
2000-01-18	XLK	ETF	26.375	26.8594	26.3047	26.5781	1101600.0
2000-01-18	XLP	ETF	23.8906	24.0469	23.6562	23.75	218300.0
2000-01-18	XLU	ETF	13.4688	13.6406	13.4297	13.4297	92000.0
2000-01-18	XLV	ETF	31.875	31.875	31.4688	31.5	417300.0
2000-01-18	XLY	ETF	15.0	15.0625	14.8281	14.9844	107600.0

> showing 46 of 46 rows — these rows as CSV

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