PREVIEW / etf_daily / 2000-07-20

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-20.parquet
  size:    7 KB
  rows:    70

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-07-20	SPY	ETF	149.0	150.625	148.8125	150.625	4538900.0
2000-07-20	QQQ	ETF	97.875	100.5	97.2656	100.375	19521200.0
2000-07-20	IWM	ETF	53.125	53.5	53.125	53.5	150400.0
2000-07-20	DIA	ETF	107.8125	109.0938	107.8125	109.0938	657900.0
2000-07-20	BBH	ETF	60.8333	61.6667	60.2292	61.1667	3036000.0
2000-07-20	BITS	ETF	19.5	21.5	18.5	19.5	11225.0
2000-07-20	CEF	ETF	3.25	3.3125	3.25	3.3125	16900.0
2000-07-20	CHB	ETF	5.25	5.25	5.0	5.25	113100.0
2000-07-20	CNXT	ETF	38.75	39.38	35.13	39.06	36212640.0
2000-07-20	EWA	ETF	10.375	10.4375	10.3125	10.375	5300.0
2000-07-20	EWC	ETF	20.875	21.0625	20.875	21.0	16600.0
2000-07-20	EWD	ETF	32.0	32.3125	32.0	32.3125	1600.0
2000-07-20	EWG	ETF	24.9375	25.375	24.8125	25.3125	310500.0
2000-07-20	EWH	ETF	13.5625	13.9375	13.5	13.875	89000.0
2000-07-20	EWI	ETF	52.25	52.875	52.25	52.875	16150.0
2000-07-20	EWJ	ETF	56.5	57.75	56.25	57.75	182600.0
2000-07-20	EWK	ETF	13.8125	13.8125	13.625	13.75	700.0
2000-07-20	EWL	ETF	16.125	16.25	15.875	16.25	6300.0
2000-07-20	EWM	ETF	25.0	25.25	25.0	25.25	1775.0
2000-07-20	EWN	ETF	24.375	24.6875	24.375	24.625	11400.0
2000-07-20	EWO	ETF	7.75	7.8125	7.625	7.6875	19000.0
2000-07-20	EWP	ETF	26.375	26.5	26.3125	26.3125	2600.0
2000-07-20	EWQ	ETF	28.25	28.8125	28.1875	28.8125	145600.0
2000-07-20	EWS	ETF	15.5	15.625	15.375	15.5	22600.0
2000-07-20	EWT	ETF	36.25	36.75	36.25	36.75	5600.0
2000-07-20	EWU	ETF	38.875	39.375	38.625	39.375	17900.0
2000-07-20	EWW	ETF	17.625	17.8125	17.0	17.125	29100.0
2000-07-20	EWY	ETF	20.25	20.4375	20.25	20.375	11200.0
2000-07-20	EWZ	ETF	19.875	19.875	19.875	19.875	5000.0
2000-07-20	FCTR	ETF	16.0	16.0	15.8125	16.0	8900.0
2000-07-20	FMAR	ETF	5.31	5.62	5.0	5.5	3700.0
2000-07-20	GLDB	ETF	5.0	5.0313	4.9688	5.0313	19900.0
2000-07-20	GSIG	ETF	39.94	43.5	39.75	42.5	1233600.0
2000-07-20	IGLD	ETF	887.5	900.0	800.0	825.0	522.0
2000-07-20	IJH	ETF	10.2266	10.2672	10.2266	10.2359	93000.0
2000-07-20	IJR	ETF	18.0	18.1302	18.0	18.0	72000.0
2000-07-20	IVE	ETF	60.4688	60.75	60.4688	60.5	3300.0
2000-07-20	IVV	ETF	148.875	150.4219	148.7656	150.4219	96500.0
2000-07-20	IVW	ETF	22.8984	23.211	22.8984	23.211	10000.0
2000-07-20	IWB	ETF	78.9688	78.9688	78.9688	78.9688	100.0
2000-07-20	IWD	ETF	55.5156	55.7656	55.5156	55.7344	38800.0
2000-07-20	IWF	ETF	22.355475	22.625	22.355475	22.625	64800.0
2000-07-20	IWV	ETF	82.3438	82.6875	82.1562	82.6875	73300.0
2000-07-20	IYE	ETF	15.9896	15.9896	15.9896	15.9896	300.0
2000-07-20	IYF	ETF	37.5781	38.3125	37.4375	38.3125	103600.0
2000-07-20	IYG	ETF	29.2292	29.2292	29.2292	29.2292	300.0
2000-07-20	IYH	ETF	12.5875	12.65	12.55	12.55	79500.0
2000-07-20	IYJ	ETF	30.9531	30.9531	30.9531	30.9531	200.0
2000-07-20	IYK	ETF	14.1979	14.1979	14.1979	14.1979	300.0
2000-07-20	IYR	ETF	35.9062	35.9062	35.8281	35.8281	2200.0

> showing 50 of 70 rows — these rows as CSV

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