PREVIEW / etf_daily / 2000-03-23

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-23.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-23	SPY	ETF	149.1562	153.4688	149.1562	152.6562	11654500.0
2000-03-23	QQQ	ETF	116.0	116.0	116.0	116.0	9613150.0
2000-03-23	DIA	ETF	108.375	111.5	108.25	111.125	1894400.0
2000-03-23	BBH	ETF	61.125	61.25	59.0833	59.4375	1702800.0
2000-03-23	BITS	ETF	38.0	42.0	37.0	41.5	24125.0
2000-03-23	CEF	ETF	3.5625	3.5625	3.5	3.5	8700.0
2000-03-23	CHB	ETF	6.75	6.75	6.38	6.5	434500.0
2000-03-23	CNXT	ETF	74.31	82.87	69.12	80.06	15245730.0
2000-03-23	CSB	ETF	4.0	4.0	4.0	4.0	1000.0
2000-03-23	EWA	ETF	10.0625	10.5	10.0625	10.5	23700.0
2000-03-23	EWC	ETF	18.625	19.0	18.375	19.0	14000.0
2000-03-23	EWD	ETF	35.0	35.75	35.0	35.75	6800.0
2000-03-23	EWG	ETF	27.3125	28.5	27.3125	28.5	205800.0
2000-03-23	EWH	ETF	13.5625	13.75	13.5625	13.75	69200.0
2000-03-23	EWI	ETF	49.0	50.875	49.0	50.875	22450.0
2000-03-23	EWJ	ETF	59.25	60.0	59.25	59.75	658625.0
2000-03-23	EWK	ETF	13.625	13.625	13.375	13.625	4000.0
2000-03-23	EWL	ETF	15.0625	15.625	15.0625	15.625	52500.0
2000-03-23	EWM	ETF	28.25	28.75	27.75	28.0	42875.0
2000-03-23	EWN	ETF	24.0625	24.3125	24.0	24.3125	6200.0
2000-03-23	EWO	ETF	7.75	7.75	7.5	7.75	15300.0
2000-03-23	EWP	ETF	28.8125	29.5	28.8125	29.5	6600.0
2000-03-23	EWQ	ETF	28.0	28.625	27.875	28.625	66300.0
2000-03-23	EWS	ETF	14.875	15.375	14.75	15.0	40350.0
2000-03-23	EWU	ETF	40.875	41.5	40.375	41.0	94550.0
2000-03-23	EWW	ETF	19.0	19.625	19.0	19.625	17000.0
2000-03-23	FCTR	ETF	13.5	13.5	12.75	13.5	33700.0
2000-03-23	FMAR	ETF	6.0	6.0	5.5	5.5	13200.0
2000-03-23	GLDB	ETF	6.625	7.0	6.5	6.75	139400.0
2000-03-23	GSIG	ETF	21.0	21.69	20.44	20.87	596200.0
2000-03-23	IGLD	ETF	2450.0	2537.5	2375.0	2418.75	455.0
2000-03-23	KTEC	ETF	8.875	9.0	8.875	8.875	5100.0
2000-03-23	MDY	ETF	90.6875	91.8438	90.25	91.25	572800.0
2000-03-23	MIG	ETF	5.0625	5.0625	5.0	5.0625	8500.0
2000-03-23	PPH	ETF	43.25	43.4688	42.7812	43.0938	184600.0
2000-03-23	SFY	ETF	13.125	13.75	13.125	13.6875	106000.0
2000-03-23	TDSC	ETF	5.25	5.25	5.03	5.19	173800.0
2000-03-23	TINY	ETF	24.5	24.5	22.5	23.12	137800.0
2000-03-23	XLB	ETF	11.039	11.3672	10.9844	11.3125	63400.0
2000-03-23	XLE	ETF	13.9062	14.1562	13.8281	13.9844	83000.0
2000-03-23	XLF	ETF	19.2679	20.1056	19.1028	19.9787	724567.0
2000-03-23	XLI	ETF	28.3906	29.0312	28.2344	28.875	19200.0
2000-03-23	XLK	ETF	31.1562	32.0	31.0625	31.7188	968200.0
2000-03-23	XLP	ETF	21.1094	21.3438	20.8438	20.9531	126400.0
2000-03-23	XLU	ETF	12.9688	13.1406	12.8516	13.0938	14200.0
2000-03-23	XLV	ETF	30.625	31.1562	30.625	30.9531	24900.0
2000-03-23	XLY	ETF	13.8906	14.1953	13.8906	14.1328	18000.0

> showing 47 of 47 rows — these rows as CSV

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