PREVIEW / etf_daily / 2000-06-20

all etf daily files

  file:    by_date/etf_daily/2000/2000-06-20.parquet
  size:    7 KB
  rows:    66

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-20	SPY	ETF	148.1875	148.875	147.0	147.9375	6480000.0
2000-06-20	QQQ	ETF	98.25	99.6875	97.1875	97.625	20988300.0
2000-06-20	IWM	ETF	52.3281	52.6719	52.125	52.5938	47000.0
2000-06-20	DIA	ETF	105.4062	105.4375	104.0625	104.75	1360800.0
2000-06-20	BBH	ETF	58.2083	59.6667	57.25	58.9792	2553300.0
2000-06-20	BITS	ETF	28.125	28.5	25.5	27.5	19175.0
2000-06-20	CEF	ETF	3.5	3.5	3.375	3.375	58200.0
2000-06-20	CHB	ETF	5.31	5.31	5.13	5.13	118100.0
2000-06-20	CNXT	ETF	55.69	57.75	54.44	54.88	8300070.0
2000-06-20	EWA	ETF	10.375	10.375	10.375	10.375	1800.0
2000-06-20	EWC	ETF	20.0	20.125	19.875	20.0	15400.0
2000-06-20	EWD	ETF	31.8125	32.0	31.8125	32.0	700.0
2000-06-20	EWG	ETF	25.3125	25.375	25.0625	25.375	101300.0
2000-06-20	EWH	ETF	12.5625	12.5625	12.3125	12.375	38000.0
2000-06-20	EWI	ETF	51.375	51.5	51.25	51.25	4150.0
2000-06-20	EWJ	ETF	59.75	60.0	59.25	59.75	54350.0
2000-06-20	EWK	ETF	13.625	13.625	13.625	13.625	1200.0
2000-06-20	EWL	ETF	16.0625	16.3125	16.0625	16.3125	11900.0
2000-06-20	EWM	ETF	24.5	25.0	24.5	24.75	25175.0
2000-06-20	EWN	ETF	25.1875	25.25	25.0625	25.1875	5900.0
2000-06-20	EWO	ETF	7.9375	8.0	7.9375	8.0	6400.0
2000-06-20	EWP	ETF	26.125	26.4375	26.0	26.0625	14900.0
2000-06-20	EWQ	ETF	29.3125	29.375	29.25	29.375	28000.0
2000-06-20	EWS	ETF	14.5	14.625	14.25	14.25	21050.0
2000-06-20	EWU	ETF	39.125	39.375	39.0	39.375	15400.0
2000-06-20	EWW	ETF	15.75	15.75	15.3125	15.4375	50600.0
2000-06-20	EWY	ETF	20.75	20.75	20.625	20.625	3300.0
2000-06-20	FCTR	ETF	16.625	17.0	16.625	16.9375	35200.0
2000-06-20	FMAR	ETF	5.81	6.0	5.75	6.0	1800.0
2000-06-20	GLDB	ETF	6.75	6.8594	6.625	6.6875	46200.0
2000-06-20	GSIG	ETF	28.34	30.0	28.25	29.5	1302900.0
2000-06-20	IDU	ETF	34.345	34.345	34.345	34.345	200.0
2000-06-20	IGLD	ETF	887.5	925.0	875.0	893.75	324.0
2000-06-20	IJH	ETF	10.1125	10.15	10.0516	10.1391	776000.0
2000-06-20	IJR	ETF	17.6094	17.625	17.4375	17.5156	448800.0
2000-06-20	IVE	ETF	60.375	60.375	59.875	60.1562	40900.0
2000-06-20	IVV	ETF	148.625	148.6406	147.2969	147.7031	182600.0
2000-06-20	IVW	ETF	22.625	22.875	22.6016	22.6094	3200.0
2000-06-20	IWB	ETF	78.6094	78.8906	78.4375	78.4375	500.0
2000-06-20	IWD	ETF	56.4375	56.625	56.0	56.0	19500.0
2000-06-20	IWF	ETF	21.988275	22.042975	21.8672	21.89845	446800.0
2000-06-20	IWV	ETF	81.625	81.625	80.8438	81.5312	1200.0
2000-06-20	IYE	ETF	16.7031	16.7031	16.5938	16.5938	3000.0
2000-06-20	IYH	ETF	12.8	12.8	12.6875	12.6875	24000.0
2000-06-20	IYM	ETF	35.0	35.0	35.0	35.0	200.0
2000-06-20	IYR	ETF	35.125	35.1797	35.125	35.1797	400.0
2000-06-20	IYW	ETF	33.5312	33.5312	32.9726	32.9726	40400.0
2000-06-20	IYY	ETF	34.625	34.625	34.375	34.5	9600.0
2000-06-20	IYZ	ETF	63.375	63.5625	63.0	63.2812	3500.0
2000-06-20	KTEC	ETF	8.6875	8.75	8.6875	8.75	1200.0

> showing 50 of 66 rows — these rows as CSV

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