PREVIEW / etf_daily / 2000-11-16

all etf daily files

  file:    by_date/etf_daily/2000/2000-11-16.parquet
  size:    8 KB
  rows:    86

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-11-16	SPY	ETF	138.5781	139.875	137.3125	137.375	6684100.0
2000-11-16	QQQ	ETF	75.375	77.0	72.875	72.875	33900900.0
2000-11-16	IWM	ETF	48.6406	49.2422	47.8516	47.8516	165400.0
2000-11-16	DIA	ETF	106.7812	107.875	106.4375	106.625	908100.0
2000-11-16	BBH	ETF	57.4583	58.1667	55.6875	55.8542	1563300.0
2000-11-16	BITS	ETF	10.625	11.5	10.25	11.5	8175.0
2000-11-16	CEF	ETF	2.9375	3.0	2.9375	3.0	33100.0
2000-11-16	CHB	ETF	3.25	3.31	3.19	3.31	59100.0
2000-11-16	CNXT	ETF	30.23	30.85	27.25	27.75	4328190.0
2000-11-16	EWA	ETF	9.125	9.125	9.0	9.125	14700.0
2000-11-16	EWC	ETF	13.8125	13.8125	13.625	13.625	25500.0
2000-11-16	EWD	ETF	18.875	18.875	18.5625	18.5625	1500.0
2000-11-16	EWG	ETF	18.8125	19.0	18.8125	18.875	13100.0
2000-11-16	EWH	ETF	11.25	11.25	11.0625	11.0625	44200.0
2000-11-16	EWI	ETF	44.625	44.625	44.125	44.125	8450.0
2000-11-16	EWJ	ETF	49.0	49.25	48.5	48.5	65725.0
2000-11-16	EWK	ETF	12.625	12.625	12.3125	12.3125	1000.0
2000-11-16	EWL	ETF	15.5	15.5	15.5	15.5	3300.0
2000-11-16	EWM	ETF	22.0	22.0	21.5	21.5	14575.0
2000-11-16	EWN	ETF	22.5625	22.5625	21.9375	21.9375	2300.0
2000-11-16	EWO	ETF	7.3125	7.3125	7.25	7.25	10200.0
2000-11-16	EWP	ETF	22.9375	22.9375	22.625	22.625	2400.0
2000-11-16	EWQ	ETF	23.875	23.9375	23.75	23.75	16400.0
2000-11-16	EWS	ETF	13.25	13.375	13.125	13.25	12750.0
2000-11-16	EWT	ETF	24.625	24.625	24.0	24.125	4150.0
2000-11-16	EWU	ETF	35.25	35.625	35.25	35.625	7150.0
2000-11-16	EWW	ETF	14.9375	14.9375	14.8125	14.9375	4800.0
2000-11-16	EWY	ETF	14.75	14.75	14.75	14.75	6000.0
2000-11-16	EWZ	ETF	15.8125	15.8125	15.8125	15.8125	200.0
2000-11-16	FCTR	ETF	15.0625	15.1875	14.625	14.625	46600.0
2000-11-16	FMAR	ETF	4.75	4.94	4.75	4.94	3000.0
2000-11-16	GLDB	ETF	4.4375	4.5313	4.4375	4.5313	74700.0
2000-11-16	GSIG	ETF	10.28	10.87	10.25	10.37	352000.0
2000-11-16	IDU	ETF	41.75	41.7812	41.5938	41.625	13200.0
2000-11-16	IEV	ETF	37.2812	37.5547	37.25	37.5	30600.0
2000-11-16	IGLD	ETF	278.125	278.125	275.0	275.0	189.0
2000-11-16	IJH	ETF	10.2234	10.2516	10.1281	10.1281	790000.0
2000-11-16	IJJ	ETF	19.461	19.582	19.461	19.4688	15200.0
2000-11-16	IJK	ETF	16.7285	16.8262	16.6211	16.6211	10400.0
2000-11-16	IJR	ETF	17.8906	17.9453	17.6146	17.6146	55800.0
2000-11-16	IJS	ETF	18.0469	18.1289	17.9883	18.0	15200.0
2000-11-16	IUSG	ETF	29.3516	29.3516	29.3516	29.3516	2000.0
2000-11-16	IUSV	ETF	24.625	24.625	24.5885	24.5885	1200.0
2000-11-16	IVE	ETF	62.6875	62.875	62.3438	62.3438	114100.0
2000-11-16	IVV	ETF	138.6875	139.5312	137.5156	137.5625	265600.0
2000-11-16	IVW	ETF	19.3594	19.4688	19.125	19.125	159600.0
2000-11-16	IWB	ETF	74.4	74.4	73.28	73.28	17900.0
2000-11-16	IWD	ETF	58.375	58.5	58.1562	58.1719	11600.0
2000-11-16	IWF	ETF	18.699225	18.875	18.39845	18.39845	44000.0
2000-11-16	IWN	ETF	36.0208	36.0208	35.6667	35.6667	6300.0

> showing 50 of 86 rows — these rows as CSV

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