PREVIEW / etf_daily / 2000-02-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-02-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-02-18	SPY	ETF	138.875	138.875	134.625	135.3125	9409200.0
2000-02-18	DIA	ETF	105.0	105.0	102.0	102.25	1526700.0
2000-02-18	BBH	ETF	67.2292	70.4792	64.375	66.3333	4658400.0
2000-02-18	BITS	ETF	30.0	34.5	29.5	34.0	88825.0
2000-02-18	CEF	ETF	3.75	3.8125	3.625	3.8125	5500.0
2000-02-18	CHB	ETF	7.13	7.38	7.13	7.38	50100.0
2000-02-18	CNXT	ETF	123.37	123.75	111.5	111.87	3967310.0
2000-02-18	CSB	ETF	3.20000004768372	3.29999995231628	3.20000004768372	3.29999995231628	1300.0
2000-02-18	EWA	ETF	10.25	10.3125	10.125	10.125	22500.0
2000-02-18	EWC	ETF	18.25	18.25	18.1875	18.1875	2500.0
2000-02-18	EWD	ETF	33.5625	33.5625	33.0625	33.0625	16000.0
2000-02-18	EWG	ETF	28.25	28.4375	27.75	27.75	61700.0
2000-02-18	EWH	ETF	13.5	13.6875	13.125	13.25	21100.0
2000-02-18	EWI	ETF	52.625	52.625	52.25	52.5	6150.0
2000-02-18	EWJ	ETF	60.25	61.0	59.5	59.75	133650.0
2000-02-18	EWK	ETF	13.5625	13.5625	13.25	13.25	3300.0
2000-02-18	EWL	ETF	14.6875	15.0	14.6875	15.0	8700.0
2000-02-18	EWM	ETF	31.0	31.25	30.0	30.5	44000.0
2000-02-18	EWN	ETF	24.1875	24.1875	23.75	23.75	3500.0
2000-02-18	EWO	ETF	7.9375	7.9375	7.75	7.75	11800.0
2000-02-18	EWP	ETF	27.9375	28.25	27.9375	28.1875	3300.0
2000-02-18	EWQ	ETF	27.625	27.875	27.125	27.375	22700.0
2000-02-18	EWS	ETF	15.375	15.375	14.5	14.625	66800.0
2000-02-18	EWU	ETF	38.375	38.375	37.5	37.5	15950.0
2000-02-18	EWW	ETF	18.8125	18.8125	18.0	18.0	11500.0
2000-02-18	FCTR	ETF	13.75	13.75	13.125	13.5313	33700.0
2000-02-18	FMAR	ETF	6.75	6.75	6.5	6.5	11200.0
2000-02-18	GLDB	ETF	8.4063	8.4375	8.25	8.375	15200.0
2000-02-18	GSIG	ETF	13.87	17.81	13.75	15.62	1073000.0
2000-02-18	IGLD	ETF	2137.5	2575.0	2137.5	2375.0	4799.0
2000-02-18	KTEC	ETF	9.0	9.4375	9.0	9.25	16100.0
2000-02-18	MDY	ETF	83.1719	83.1719	80.1875	80.4375	562500.0
2000-02-18	MIG	ETF	4.9375	4.9375	4.75	4.875	27400.0
2000-02-18	PPH	ETF	42.5625	42.5625	41.0625	41.25	267800.0
2000-02-18	SFY	ETF	11.25	11.25	11.0	11.1875	59600.0
2000-02-18	TDSC	ETF	4.94	5.06	4.75	4.875	138000.0
2000-02-18	TINY	ETF	19.06	19.12	17.44	18.19	304100.0
2000-02-18	XLB	ETF	11.289	11.289	10.8594	10.8828	181000.0
2000-02-18	XLE	ETF	13.5938	13.5938	13.2188	13.2578	283400.0
2000-02-18	XLF	ETF	16.9832	16.9832	16.2977	16.45	881765.0
2000-02-18	XLI	ETF	26.4844	26.5	25.7031	25.7969	115300.0
2000-02-18	XLK	ETF	27.7812	27.7812	26.75	26.8125	725400.0
2000-02-18	XLP	ETF	21.5938	21.625	21.0625	21.2812	191300.0
2000-02-18	XLU	ETF	12.8438	12.8438	12.4844	12.4922	29800.0
2000-02-18	XLV	ETF	28.9375	28.9844	28.2031	28.2031	109900.0
2000-02-18	XLY	ETF	12.6172	12.664	12.414	12.5	15000.0

> showing 46 of 46 rows — these rows as CSV

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