PREVIEW / etf_daily / 2000-03-02

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-02.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-02	SPY	ETF	138.6875	139.125	137.3438	138.5312	7600200.0
2000-03-02	QQQ	ETF	54.0312	54.0938	52.375	52.5664	32739200.0
2000-03-02	DIA	ETF	101.4688	102.25	101.0	101.6875	576000.0
2000-03-02	BBH	ETF	76.5625	76.5625	73.6667	75.7292	2383800.0
2000-03-02	BITS	ETF	34.0	34.0	32.0	32.25	56225.0
2000-03-02	CEF	ETF	3.5625	3.5625	3.4375	3.4375	13400.0
2000-03-02	CHB	ETF	6.25	6.5	6.25	6.31	64700.0
2000-03-02	CNXT	ETF	89.69	90.69	78.5	78.94	12696200.0
2000-03-02	CSB	ETF	4.0	4.0	4.0	4.0	2100.0
2000-03-02	EWA	ETF	10.25	10.5	10.25	10.5	14400.0
2000-03-02	EWC	ETF	17.625	17.875	17.625	17.875	15900.0
2000-03-02	EWD	ETF	35.875	36.625	35.875	36.625	9600.0
2000-03-02	EWG	ETF	28.1875	28.75	27.9375	28.6875	38600.0
2000-03-02	EWH	ETF	13.0	13.125	12.9375	13.125	71600.0
2000-03-02	EWI	ETF	53.75	54.875	53.75	54.625	19450.0
2000-03-02	EWJ	ETF	62.0	62.0	60.75	60.75	122700.0
2000-03-02	EWK	ETF	12.75	12.875	12.625	12.875	7800.0
2000-03-02	EWL	ETF	14.625	14.75	14.4375	14.75	23600.0
2000-03-02	EWM	ETF	28.0	28.5	27.75	27.75	31000.0
2000-03-02	EWN	ETF	24.125	24.125	23.75	24.0625	20500.0
2000-03-02	EWO	ETF	7.5625	7.8125	7.5625	7.8125	1800.0
2000-03-02	EWP	ETF	28.75	29.1875	28.75	29.1875	2200.0
2000-03-02	EWQ	ETF	28.625	29.1875	28.5625	29.1875	54400.0
2000-03-02	EWS	ETF	14.5	14.5	14.375	14.375	81200.0
2000-03-02	EWU	ETF	39.0	39.375	38.75	39.125	34400.0
2000-03-02	EWW	ETF	18.5	19.375	18.5	19.375	16800.0
2000-03-02	FCTR	ETF	13.375	14.0	13.0	14.0	30100.0
2000-03-02	FMAR	ETF	6.94	6.94	6.62	6.69	2800.0
2000-03-02	GLDB	ETF	7.8438	7.875	7.625	7.75	116300.0
2000-03-02	GSIG	ETF	23.94	26.0	23.0	24.0	1095900.0
2000-03-02	IGLD	ETF	2387.5	2450.0	2250.0	2350.0	1330.0
2000-03-02	KTEC	ETF	8.875	9.0625	8.875	8.9375	1100.0
2000-03-02	MDY	ETF	86.375	86.7969	85.3125	85.6875	399600.0
2000-03-02	MIG	ETF	5.625	5.8125	5.625	5.8125	3300.0
2000-03-02	PPH	ETF	39.125	39.9688	39.125	39.5625	304400.0
2000-03-02	SFY	ETF	12.1875	12.625	12.0	12.4375	56200.0
2000-03-02	TDSC	ETF	5.94	5.97	5.69	5.78	196400.0
2000-03-02	TINY	ETF	25.0	25.0	22.0	22.25	330000.0
2000-03-02	XLB	ETF	10.375	10.375	10.0781	10.1562	368000.0
2000-03-02	XLE	ETF	13.4453	13.7031	13.4375	13.6562	785400.0
2000-03-02	XLF	ETF	16.8562	16.9832	16.5643	16.8562	600359.0
2000-03-02	XLI	ETF	25.7812	25.8125	25.4062	25.6406	421400.0
2000-03-02	XLK	ETF	28.4375	28.6562	28.0469	28.5	2195200.0
2000-03-02	XLP	ETF	20.1719	20.4688	20.1719	20.375	1447500.0
2000-03-02	XLU	ETF	12.7969	13.0625	12.7969	13.0	211200.0
2000-03-02	XLV	ETF	28.3438	28.4375	28.1562	28.25	47600.0
2000-03-02	XLY	ETF	12.8281	12.8438	12.664	12.6797	417200.0

> showing 47 of 47 rows — these rows as CSV

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