PREVIEW / etf_daily / 2000-06-28

all etf daily files

  file:    by_date/etf_daily/2000/2000-06-28.parquet
  size:    7 KB
  rows:    69

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-06-28	SPY	ETF	145.625	146.9844	145.3125	145.5625	5347700.0
2000-06-28	QQQ	ETF	92.9844	95.5	92.5	94.0	19259800.0
2000-06-28	IWM	ETF	50.9375	52.1875	50.9375	52.0	170600.0
2000-06-28	DIA	ETF	105.75	106.4531	105.0781	105.375	516900.0
2000-06-28	BBH	ETF	57.625	60.8125	57.4583	60.0417	2382600.0
2000-06-28	BITS	ETF	26.0	27.5	26.0	26.25	9475.0
2000-06-28	CEF	ETF	3.5	3.5625	3.5	3.5	9700.0
2000-06-28	CHB	ETF	4.88	5.5	4.88	5.38	81300.0
2000-06-28	CNXT	ETF	48.06	53.5	47.5	51.69	5792920.0
2000-06-28	CSB	ETF	3.5	3.5	3.5	3.5	3000.0
2000-06-28	EWA	ETF	10.5	10.5	10.375	10.5	10500.0
2000-06-28	EWC	ETF	19.4375	20.0	19.4375	20.0	2200.0
2000-06-28	EWD	ETF	30.5	31.0625	30.5	30.9375	2100.0
2000-06-28	EWG	ETF	24.1875	24.4375	24.1875	24.3125	29000.0
2000-06-28	EWH	ETF	12.5625	12.625	12.4375	12.5625	9600.0
2000-06-28	EWI	ETF	50.75	51.5	50.75	51.5	2300.0
2000-06-28	EWJ	ETF	60.5	61.0	60.0	61.0	172475.0
2000-06-28	EWK	ETF	13.4375	13.5	13.25	13.4375	3300.0
2000-06-28	EWL	ETF	16.0	16.0625	15.75	15.75	12500.0
2000-06-28	EWM	ETF	25.0	25.5	25.0	25.5	48900.0
2000-06-28	EWN	ETF	24.6875	25.0625	24.6875	24.9375	9600.0
2000-06-28	EWO	ETF	7.8125	8.0	7.8125	7.8125	5900.0
2000-06-28	EWP	ETF	25.875	25.875	25.625	25.875	6300.0
2000-06-28	EWQ	ETF	28.9375	29.3125	28.875	29.25	23600.0
2000-06-28	EWS	ETF	14.875	15.25	14.875	15.0	20500.0
2000-06-28	EWT	ETF	37.75	37.75	37.75	37.75	500.0
2000-06-28	EWU	ETF	38.25	38.25	37.875	38.25	11700.0
2000-06-28	EWW	ETF	16.0	16.0	15.6875	16.0	17900.0
2000-06-28	EWY	ETF	21.0	21.25	21.0	21.1875	1100.0
2000-06-28	FCTR	ETF	16.5625	17.0	16.4375	17.0	39400.0
2000-06-28	FMAR	ETF	5.5	5.5	5.5	5.5	200.0
2000-06-28	GLDB	ETF	6.0	6.75	6.0	6.75	269800.0
2000-06-28	GSIG	ETF	29.12	30.0	27.81	29.25	404700.0
2000-06-28	IDU	ETF	33.5625	33.5625	33.3125	33.4844	22000.0
2000-06-28	IGLD	ETF	843.75	868.75	812.5	868.75	171.0
2000-06-28	IJH	ETF	9.7281	9.8469	9.7281	9.8469	25000.0
2000-06-28	IJR	ETF	17.3021	17.7604	17.3021	17.7604	456000.0
2000-06-28	IVE	ETF	59.5312	59.8594	59.1719	59.2969	12200.0
2000-06-28	IVV	ETF	145.3125	146.9062	145.3125	145.9219	51200.0
2000-06-28	IVW	ETF	22.3555	22.4453	22.3516	22.4453	6400.0
2000-06-28	IWB	ETF	77.0938	77.75	77.0938	77.4688	18000.0
2000-06-28	IWD	ETF	55.7188	55.9062	55.375	55.4062	5800.0
2000-06-28	IWF	ETF	21.3789	21.671875	21.3789	21.65235	24400.0
2000-06-28	IWV	ETF	79.9219	80.25	79.8125	79.8125	1300.0
2000-06-28	IYC	ETF	14.9225	14.9225	14.9225	14.9225	800.0
2000-06-28	IYE	ETF	16.4583	16.5313	16.4167	16.5208	3000.0
2000-06-28	IYF	ETF	36.4844	36.5625	36.0938	36.0938	1800.0
2000-06-28	IYG	ETF	27.875	27.875	27.3542	27.3542	107400.0
2000-06-28	IYH	ETF	12.8	12.875	12.4437	12.875	103000.0
2000-06-28	IYW	ETF	31.7656	32.3672	31.7656	32.0	10000.0

> showing 50 of 69 rows — these rows as CSV

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