PREVIEW / etf_daily / 2000-07-26

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-26.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-07-26	SPY	ETF	146.9688	147.1562	145.6406	145.875	12062500.0
2000-07-26	QQQ	ETF	95.5	96.125	93.25	95.625	20318700.0
2000-07-26	IWM	ETF	51.0	51.2812	50.4688	51.2812	15800.0
2000-07-26	DIA	ETF	106.5312	106.75	105.3906	105.5	406500.0
2000-07-26	BBH	ETF	57.3333	60.4583	56.4583	58.5	2284500.0
2000-07-26	BITS	ETF	18.0	18.0	14.5	16.5	15000.0
2000-07-26	BOSS	ETF	16.5	16.5	16.5	16.5	200.0
2000-07-26	CEF	ETF	3.25	3.3125	3.25	3.25	9400.0
2000-07-26	CHB	ETF	5.31	5.94	5.31	5.81	134500.0
2000-07-26	CNXT	ETF	36.75	36.75	35.38	35.75	3434600.0
2000-07-26	EWA	ETF	10.375	10.4375	10.375	10.4375	6900.0
2000-07-26	EWC	ETF	21.375	21.5625	21.25	21.5	29800.0
2000-07-26	EWD	ETF	31.1875	31.1875	31.125	31.1875	300.0
2000-07-26	EWG	ETF	24.8125	24.875	24.625	24.75	31300.0
2000-07-26	EWH	ETF	13.4375	13.5	13.25	13.3125	46000.0
2000-07-26	EWI	ETF	52.5	52.5	51.75	51.75	7750.0
2000-07-26	EWJ	ETF	55.25	55.5	54.75	55.25	45150.0
2000-07-26	EWK	ETF	14.125	14.125	14.125	14.125	200.0
2000-07-26	EWL	ETF	16.4375	16.4375	16.4375	16.4375	4300.0
2000-07-26	EWM	ETF	24.5	24.5	24.25	24.25	10675.0
2000-07-26	EWN	ETF	24.4375	24.5625	24.375	24.5625	30300.0
2000-07-26	EWO	ETF	8.1875	8.1875	8.125	8.125	1700.0
2000-07-26	EWP	ETF	26.375	26.4375	26.375	26.4375	2600.0
2000-07-26	EWQ	ETF	28.4375	28.625	28.4375	28.5625	101100.0
2000-07-26	EWS	ETF	15.125	15.125	14.875	14.875	20500.0
2000-07-26	EWU	ETF	39.125	39.125	38.625	39.125	18850.0
2000-07-26	EWW	ETF	17.0	17.125	16.875	17.0	60900.0
2000-07-26	EWY	ETF	19.5	19.5625	19.4375	19.4375	10700.0
2000-07-26	FCTR	ETF	15.125	15.75	15.125	15.75	7600.0
2000-07-26	FMAR	ETF	5.25	5.25	5.0	5.25	3900.0
2000-07-26	GLDB	ETF	5.0	5.0	4.875	4.9688	76900.0
2000-07-26	GSIG	ETF	33.5	33.94	30.75	32.06	903100.0
2000-07-26	IDU	ETF	35.2969	35.2969	35.0469	35.0469	40000.0
2000-07-26	IGLD	ETF	750.0	781.25	725.0	743.75	975.0
2000-07-26	IJH	ETF	9.9391	9.9391	9.8094	9.925	665000.0
2000-07-26	IJR	ETF	17.4115	17.4115	17.2552	17.388	117000.0
2000-07-26	IVE	ETF	60.125	60.125	59.4375	59.4375	26500.0
2000-07-26	IVV	ETF	146.875	146.8906	145.75	146.0	474800.0
2000-07-26	IVW	ETF	22.4844	22.5273	22.25	22.4883	86800.0
2000-07-26	IWB	ETF	77.5	77.5	77.0	77.4844	12000.0
2000-07-26	IWD	ETF	55.125	55.2812	54.75	54.9062	19100.0
2000-07-26	IWF	ETF	21.71875	21.71875	21.4453	21.640625	63600.0
2000-07-26	IWV	ETF	80.2031	80.2031	79.5312	79.9219	7100.0
2000-07-26	IYC	ETF	15.3594	15.3594	15.3594	15.3594	400.0
2000-07-26	IYE	ETF	15.2708	15.2708	15.1667	15.1667	15300.0
2000-07-26	IYF	ETF	38.3203	38.3203	38.0	38.0625	3600.0
2000-07-26	IYH	ETF	12.5625	12.6812	12.4969	12.525	15500.0
2000-07-26	IYR	ETF	36.75	37.1484	36.75	37.1484	11200.0
2000-07-26	IYW	ETF	31.1719	31.2891	31.0	31.2891	5200.0
2000-07-26	IYY	ETF	33.9766	34.0938	33.9688	34.0938	2200.0

> showing 50 of 69 rows — these rows as CSV

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