PREVIEW / etf_daily / 2000-04-04

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-04.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-04-04	SPY	ETF	151.75	153.0	141.3906	150.125	19585500.0
2000-04-04	QQQ	ETF	103.625	103.9375	88.3125	101.9375	66214200.0
2000-04-04	DIA	ETF	112.5625	114.3438	106.3438	111.6875	6635600.0
2000-04-04	BBH	ETF	53.5	54.375	45.0833	52.0417	3291000.0
2000-04-04	BITS	ETF	48.0	48.25	33.0	40.0	119450.0
2000-04-04	CEF	ETF	3.4375	3.5625	3.4375	3.5	41600.0
2000-04-04	CHB	ETF	6.06	6.13	5.88	6.0	151400.0
2000-04-04	CNXT	ETF	68.87	68.87	52.63	60.13	8652390.0
2000-04-04	CSB	ETF	4.0	4.0	4.0	4.0	600.0
2000-04-04	EWA	ETF	10.4375	10.4375	10.1875	10.375	10500.0
2000-04-04	EWC	ETF	18.0	18.0	17.5	17.5	25000.0
2000-04-04	EWD	ETF	33.875	33.875	33.0625	33.6875	12600.0
2000-04-04	EWG	ETF	26.5625	26.625	25.5	26.375	114600.0
2000-04-04	EWH	ETF	13.25	13.3125	12.5	13.1875	192700.0
2000-04-04	EWI	ETF	49.125	49.625	49.125	49.5	2950.0
2000-04-04	EWJ	ETF	64.5	64.5	62.75	63.5	151150.0
2000-04-04	EWK	ETF	12.875	12.9375	12.875	12.9375	2400.0
2000-04-04	EWL	ETF	15.75	15.875	15.5625	15.875	36300.0
2000-04-04	EWM	ETF	27.0	27.5	26.0	26.0	38825.0
2000-04-04	EWN	ETF	23.8125	23.8125	23.3125	23.5	12600.0
2000-04-04	EWO	ETF	7.8125	7.8125	7.8125	7.8125	16200.0
2000-04-04	EWP	ETF	28.4375	28.5	28.0	28.5	10500.0
2000-04-04	EWQ	ETF	27.375	27.5	26.5	27.25	80000.0
2000-04-04	EWS	ETF	14.125	14.25	13.625	14.125	69100.0
2000-04-04	EWU	ETF	41.0	41.0	39.5	40.625	23900.0
2000-04-04	EWW	ETF	18.0625	18.375	16.875	17.5625	57700.0
2000-04-04	FCTR	ETF	12.375	13.125	12.375	13.0	31500.0
2000-04-04	FMAR	ETF	6.5	6.5	5.69	5.69	2500.0
2000-04-04	GLDB	ETF	6.6875	6.75	5.8125	6.125	125300.0
2000-04-04	GSIG	ETF	16.12	17.0	14.25	15.94	968500.0
2000-04-04	IGLD	ETF	2000.0	2006.25	1550.0	1687.5	2248.0
2000-04-04	KTEC	ETF	8.875	9.125	8.875	9.0	25900.0
2000-04-04	MDY	ETF	88.75	88.8438	81.0	87.4375	1451100.0
2000-04-04	MIG	ETF	5.5	5.5625	5.25	5.25	18900.0
2000-04-04	PPH	ETF	45.9688	46.5625	44.25	46.4688	679200.0
2000-04-04	SFY	ETF	18.6875	18.6875	16.0	16.0	233500.0
2000-04-04	TDSC	ETF	4.75	5.375	4.625	5.0	272600.0
2000-04-04	TINY	ETF	12.94	13.88	7.5	11.5	600100.0
2000-04-04	XLB	ETF	12.0781	12.2656	11.5781	11.789	371000.0
2000-04-04	XLE	ETF	15.0	15.0781	14.4688	14.7188	829200.0
2000-04-04	XLF	ETF	20.7149	20.8164	19.0775	19.8391	1568048.0
2000-04-04	XLI	ETF	29.375	29.875	27.875	29.0	220700.0
2000-04-04	XLK	ETF	28.8594	29.375	26.1406	28.7188	4423000.0
2000-04-04	XLP	ETF	22.0625	23.0	21.9219	22.8125	823600.0
2000-04-04	XLU	ETF	13.7734	14.0312	13.5156	13.6406	129000.0
2000-04-04	XLV	ETF	30.8281	31.125	29.4375	30.3125	7600.0
2000-04-04	XLY	ETF	15.3203	15.375	14.2969	14.8828	142000.0

> showing 47 of 47 rows — these rows as CSV

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