PREVIEW / etf_daily / 2000-06-09

all etf daily files

  file:    by_date/etf_daily/2000/2000-06-09.parquet
  size:    7 KB
  rows:    60

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-09	SPY	ETF	147.5	147.9688	145.625	146.5938	3085300.0
2000-06-09	QQQ	ETF	94.75	94.75	93.0	93.75	17014600.0
2000-06-09	IWM	ETF	51.9375	52.3438	51.9062	52.3438	41600.0
2000-06-09	DIA	ETF	107.7188	107.7188	105.8906	106.2656	818500.0
2000-06-09	BBH	ETF	52.0	53.9167	51.6875	53.3333	1666800.0
2000-06-09	BITS	ETF	30.25	30.25	29.25	29.5	15700.0
2000-06-09	CEF	ETF	3.4375	3.5	3.4375	3.4375	20300.0
2000-06-09	CHB	ETF	6.0	6.13	5.81	6.13	197700.0
2000-06-09	CNXT	ETF	47.03	47.28	43.91	44.16	6068790.0
2000-06-09	EWA	ETF	10.0	10.125	10.0	10.125	2100.0
2000-06-09	EWC	ETF	19.0	19.1875	18.9375	18.9375	12700.0
2000-06-09	EWD	ETF	33.6875	33.6875	33.125	33.375	2600.0
2000-06-09	EWG	ETF	25.5	25.5625	25.1875	25.25	32900.0
2000-06-09	EWH	ETF	12.5625	12.625	12.375	12.5	50300.0
2000-06-09	EWI	ETF	51.0	51.25	51.0	51.0	7150.0
2000-06-09	EWJ	ETF	60.0	60.0	59.25	59.5	31200.0
2000-06-09	EWK	ETF	13.125	13.5	13.125	13.5	2200.0
2000-06-09	EWL	ETF	16.125	16.3125	15.875	16.3125	29500.0
2000-06-09	EWM	ETF	26.25	26.75	26.25	26.5	21500.0
2000-06-09	EWN	ETF	24.9375	24.9375	24.6875	24.9375	15900.0
2000-06-09	EWO	ETF	8.125	8.125	8.125	8.125	100.0
2000-06-09	EWP	ETF	26.75	27.0	26.75	26.9375	2700.0
2000-06-09	EWQ	ETF	29.125	29.125	28.9375	28.9375	15600.0
2000-06-09	EWS	ETF	15.0	15.25	14.875	15.0	21100.0
2000-06-09	EWU	ETF	38.875	38.875	38.25	38.375	6950.0
2000-06-09	EWW	ETF	15.75	15.75	15.4375	15.4375	7100.0
2000-06-09	EWY	ETF	22.125	22.125	22.125	22.125	1300.0
2000-06-09	FCTR	ETF	16.5	16.75	16.5	16.6875	21200.0
2000-06-09	FMAR	ETF	6.3775	6.5025	6.3775	6.3775	4100.0
2000-06-09	GLDB	ETF	6.0313	6.4375	6.0	6.375	40000.0
2000-06-09	GSIG	ETF	25.31	26.25	24.12	25.75	1296000.0
2000-06-09	IGLD	ETF	956.25	975.0	950.0	975.0	312.0
2000-06-09	IJH	ETF	9.9156	9.9703	9.9156	9.9266	18000.0
2000-06-09	IJR	ETF	17.4844	17.4844	17.4375	17.4375	4200.0
2000-06-09	IVE	ETF	61.7969	61.7969	61.1562	61.1562	7100.0
2000-06-09	IVV	ETF	147.5156	147.5156	145.875	146.125	20200.0
2000-06-09	IVW	ETF	21.9688	22.0391	21.9219	21.9219	2400.0
2000-06-09	IWB	ETF	78.0781	78.0781	77.75	77.7656	1300.0
2000-06-09	IWD	ETF	57.7344	57.7344	57.3281	57.3281	4100.0
2000-06-09	IWF	ETF	21.41405	21.41405	21.261725	21.261725	6800.0
2000-06-09	IWV	ETF	80.75	80.7969	80.4062	80.4062	800.0
2000-06-09	IYF	ETF	38.0469	38.0938	37.3203	37.3203	2800.0
2000-06-09	IYW	ETF	31.7656	31.875	31.625	31.8125	12800.0
2000-06-09	IYZ	ETF	62.8125	63.0	62.4688	62.4688	800.0
2000-06-09	KTEC	ETF	8.65625	9.125	8.625	8.875	5700.0
2000-06-09	MDY	ETF	91.0	91.8125	90.7812	91.25	350800.0
2000-06-09	MIG	ETF	5.375	5.625	5.375	5.625	2900.0
2000-06-09	PPH	ETF	46.5625	47.5625	46.5625	47.125	73200.0
2000-06-09	SFY	ETF	25.625	27.1875	25.125	26.875	387100.0
2000-06-09	SMH	ETF	49.125	49.5	48.5312	49.3125	195000.0

> showing 50 of 60 rows — these rows as CSV

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