PREVIEW / etf_daily / 2000-07-17

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-17.parquet
  size:    7 KB
  rows:    72

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-17	SPY	ETF	150.9844	151.9844	150.6875	151.0	4208300.0
2000-07-17	QQQ	ETF	100.9375	102.0625	99.875	101.75	13140500.0
2000-07-17	IWM	ETF	54.3594	54.5938	54.2188	54.5	46600.0
2000-07-17	DIA	ETF	107.875	108.6875	107.5625	108.0	690600.0
2000-07-17	BBH	ETF	61.8333	63.0	60.6667	62.625	1854000.0
2000-07-17	BITS	ETF	20.5	23.0	20.25	21.375	19300.0
2000-07-17	BOSS	ETF	16.0	16.0	15.5	15.8	300.0
2000-07-17	CEF	ETF	3.375	3.4375	3.375	3.375	9300.0
2000-07-17	CHB	ETF	5.13	5.38	5.0	5.0	115500.0
2000-07-17	CNXT	ETF	53.19	57.06	51.5	55.25	4383300.0
2000-07-17	EWA	ETF	10.4375	10.5	10.4375	10.4375	4600.0
2000-07-17	EWC	ETF	20.6875	20.9375	20.6875	20.9375	37900.0
2000-07-17	EWD	ETF	33.25	33.3125	33.0	33.3125	1200.0
2000-07-17	EWG	ETF	25.125	25.3125	25.0	25.3125	120700.0
2000-07-17	EWH	ETF	13.5	13.625	13.4375	13.5	59900.0
2000-07-17	EWI	ETF	52.75	52.75	52.5	52.5	1750.0
2000-07-17	EWJ	ETF	58.75	58.75	58.25	58.75	64200.0
2000-07-17	EWK	ETF	13.75	14.0	13.75	13.75	3000.0
2000-07-17	EWL	ETF	16.25	16.25	16.0	16.25	13500.0
2000-07-17	EWM	ETF	26.0	26.0	25.5	26.0	4375.0
2000-07-17	EWN	ETF	24.9375	25.0	24.6875	25.0	45900.0
2000-07-17	EWO	ETF	7.8125	7.8125	7.6875	7.6875	21100.0
2000-07-17	EWP	ETF	26.375	26.625	26.375	26.625	6700.0
2000-07-17	EWQ	ETF	29.0625	29.125	28.875	29.125	18900.0
2000-07-17	EWS	ETF	15.25	15.375	15.125	15.25	26200.0
2000-07-17	EWT	ETF	38.75	38.875	38.75	38.875	4500.0
2000-07-17	EWU	ETF	39.0	39.375	38.75	39.375	13050.0
2000-07-17	EWW	ETF	18.5	18.5	18.1875	18.375	19700.0
2000-07-17	EWY	ETF	21.5	21.5	21.5	21.5	44000.0
2000-07-17	EWZ	ETF	19.9375	20.0	19.9375	20.0	10000.0
2000-07-17	FCTR	ETF	16.75	16.875	16.0625	16.6875	31600.0
2000-07-17	FMAR	ETF	5.62	5.7507	5.12	5.19	12600.0
2000-07-17	GLDB	ETF	4.9063	5.0625	4.9063	5.0	159300.0
2000-07-17	GSIG	ETF	37.62	40.37	36.19	39.81	772900.0
2000-07-17	IDU	ETF	35.1562	35.2656	35.1562	35.2188	10200.0
2000-07-17	IGLD	ETF	968.75	975.0	925.0	925.0	244.0
2000-07-17	IJH	ETF	10.3406	10.3672	10.3266	10.3625	133000.0
2000-07-17	IJR	ETF	18.2813	18.4427	18.2813	18.4427	12600.0
2000-07-17	IVE	ETF	60.875	60.9062	60.4062	60.4062	38800.0
2000-07-17	IVV	ETF	150.7344	151.9062	150.5938	150.8906	430100.0
2000-07-17	IVW	ETF	23.2656	23.5625	23.2656	23.5195	46400.0
2000-07-17	IWB	ETF	80.2188	80.5625	80.2188	80.5625	1200.0
2000-07-17	IWD	ETF	55.8438	55.8594	55.3906	55.3906	4800.0
2000-07-17	IWF	ETF	22.64845	23.082025	22.64845	22.96485	52400.0
2000-07-17	IWV	ETF	83.2188	83.5156	83.0312	83.4531	2900.0
2000-07-17	IYC	ETF	15.875	15.875	15.875	15.875	1600.0
2000-07-17	IYE	ETF	16.0938	16.0938	15.9063	15.9063	1800.0
2000-07-17	IYF	ETF	38.2969	38.2969	37.5938	37.5938	3000.0
2000-07-17	IYG	ETF	28.8125	28.8125	28.7344	28.8125	1500.0
2000-07-17	IYH	ETF	12.7469	13.1812	12.7469	13.1	94000.0

> showing 50 of 72 rows — these rows as CSV

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