PREVIEW / etf_daily / 2000-06-12

all etf daily files

  file:    by_date/etf_daily/2000/2000-06-12.parquet
  size:    7 KB
  rows:    61

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-12	SPY	ETF	146.9688	146.9688	144.875	144.875	3678900.0
2000-06-12	QQQ	ETF	94.3125	94.3125	90.0	90.75	16484700.0
2000-06-12	IWM	ETF	52.5	52.5	50.75	50.7891	85200.0
2000-06-12	DIA	ETF	106.6406	106.6875	105.6562	105.7188	429700.0
2000-06-12	BBH	ETF	53.3333	53.3333	50.6667	50.75	1501200.0
2000-06-12	BITS	ETF	30.375	31.5	29.0	31.5	21675.0
2000-06-12	CEF	ETF	3.375	3.5	3.375	3.4375	26900.0
2000-06-12	CHB	ETF	6.13	6.19	6.0	6.0	79600.0
2000-06-12	CNXT	ETF	45.66	45.84	43.91	44.03	3078950.0
2000-06-12	EWA	ETF	10.0	10.1875	10.0	10.0	23400.0
2000-06-12	EWC	ETF	19.1875	19.3125	19.1875	19.25	21500.0
2000-06-12	EWD	ETF	33.3125	33.6875	33.3125	33.5625	11900.0
2000-06-12	EWG	ETF	25.375	25.75	25.25	25.625	80200.0
2000-06-12	EWH	ETF	12.5625	12.5625	12.25	12.3125	42900.0
2000-06-12	EWI	ETF	51.125	51.25	51.125	51.25	1050.0
2000-06-12	EWJ	ETF	60.0	60.25	59.25	59.25	61350.0
2000-06-12	EWK	ETF	13.5	13.5	13.25	13.5	5600.0
2000-06-12	EWL	ETF	16.25	16.3125	16.25	16.25	5100.0
2000-06-12	EWM	ETF	26.25	26.5	26.0	26.0	21625.0
2000-06-12	EWN	ETF	25.0625	25.0625	24.8125	25.0	1200.0
2000-06-12	EWO	ETF	8.125	8.375	8.125	8.375	13500.0
2000-06-12	EWP	ETF	26.5	26.75	26.5	26.6875	4300.0
2000-06-12	EWQ	ETF	29.125	29.3125	29.0	29.0	21800.0
2000-06-12	EWS	ETF	14.875	15.125	14.75	14.75	21650.0
2000-06-12	EWU	ETF	38.625	38.875	38.375	38.375	11900.0
2000-06-12	EWW	ETF	15.5	15.8125	15.5	15.5625	18900.0
2000-06-12	EWY	ETF	22.5625	22.5625	22.0	22.0	12100.0
2000-06-12	FCTR	ETF	16.625	16.8125	16.625	16.75	23200.0
2000-06-12	FMAR	ETF	6.12	6.12	6.12	6.12	500.0
2000-06-12	GLDB	ETF	6.0938	6.5	6.0938	6.4688	49600.0
2000-06-12	GSIG	ETF	26.0	27.5	25.94	27.25	1177200.0
2000-06-12	IGLD	ETF	975.0	975.0	962.5	962.5	397.0
2000-06-12	IJH	ETF	9.9625	9.9625	9.7578	9.7609	731000.0
2000-06-12	IJR	ETF	17.599	17.599	17.2813	17.2813	3600.0
2000-06-12	IVE	ETF	61.5625	61.5625	61.4844	61.5	1800.0
2000-06-12	IVV	ETF	146.625	146.625	144.8594	144.8594	17600.0
2000-06-12	IVW	ETF	21.8828	21.9336	21.6445	21.6562	20400.0
2000-06-12	IWB	ETF	77.8281	77.8438	77.4531	77.4531	1100.0
2000-06-12	IWD	ETF	57.4062	57.4688	57.4062	57.4688	4200.0
2000-06-12	IWF	ETF	21.324225	21.34375	20.96485	20.96485	15200.0
2000-06-12	IWV	ETF	80.6875	80.6875	79.7031	79.75	7100.0
2000-06-12	IYF	ETF	37.3516	37.4062	37.3516	37.375	800.0
2000-06-12	IYW	ETF	31.5703	31.5703	30.9375	31.125	3600.0
2000-06-12	IYZ	ETF	63.0	63.0	62.0	62.0	1600.0
2000-06-12	KTEC	ETF	8.84375	8.96875	8.71875	8.75	3600.0
2000-06-12	MDY	ETF	92.0	92.0	89.5625	89.75	1287800.0
2000-06-12	MIG	ETF	5.625	5.625	5.625	5.625	4700.0
2000-06-12	PPH	ETF	47.75	47.75	46.7812	46.7812	40000.0
2000-06-12	SFY	ETF	27.75	29.3125	27.4375	28.375	297400.0
2000-06-12	SMH	ETF	49.625	49.625	47.3125	47.4062	112400.0

> showing 50 of 61 rows — these rows as CSV

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