PREVIEW / etf_daily / 2000-08-23

all etf daily files

  file:    by_date/etf_daily/2000/2000-08-23.parquet
  size:    8 KB
  rows:    81

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-08-23	SPY	ETF	149.8125	151.2812	149.2812	150.8438	5483200.0
2000-08-23	QQQ	ETF	94.6875	97.4375	93.8281	97.0625	21395900.0
2000-08-23	IWM	ETF	51.5938	51.75	51.375	51.5781	153000.0
2000-08-23	DIA	ETF	111.1875	111.875	110.6562	111.5	602900.0
2000-08-23	BBH	ETF	60.25	61.3333	59.4583	60.9167	1143900.0
2000-08-23	BITS	ETF	12.75	13.25	12.125	12.125	13525.0
2000-08-23	CEF	ETF	3.3125	3.375	3.3125	3.3125	85700.0
2000-08-23	CHB	ETF	5.75	5.75	5.63	5.75	13200.0
2000-08-23	CNXT	ETF	37.47	38.97	36.03	38.97	3101120.0
2000-08-23	EWA	ETF	10.375	10.5	10.375	10.5	5400.0
2000-08-23	EWC	ETF	21.75	21.8125	21.625	21.625	6900.0
2000-08-23	EWD	ETF	29.125	29.6875	29.125	29.6875	11800.0
2000-08-23	EWG	ETF	23.0	23.1875	23.0	23.1875	33200.0
2000-08-23	EWH	ETF	13.5625	13.8125	13.5625	13.8125	52100.0
2000-08-23	EWI	ETF	48.625	49.25	48.625	49.125	2950.0
2000-08-23	EWJ	ETF	56.0	56.25	55.75	56.25	100050.0
2000-08-23	EWK	ETF	14.0625	14.0625	14.0	14.0	3800.0
2000-08-23	EWL	ETF	15.9375	16.25	15.9375	16.125	27200.0
2000-08-23	EWM	ETF	24.25	24.25	24.0	24.25	7600.0
2000-08-23	EWN	ETF	24.0	24.4375	24.0	24.4375	18400.0
2000-08-23	EWO	ETF	8.0	8.0	8.0	8.0	900.0
2000-08-23	EWP	ETF	25.25	25.6875	25.25	25.6875	1000.0
2000-08-23	EWQ	ETF	27.375	27.6875	27.25	27.5	36000.0
2000-08-23	EWS	ETF	16.125	16.25	16.0	16.25	23900.0
2000-08-23	EWU	ETF	38.75	39.125	38.75	39.0	7700.0
2000-08-23	EWW	ETF	16.3125	16.625	16.25	16.5	25100.0
2000-08-23	EWY	ETF	19.125	19.125	18.8125	18.8125	300.0
2000-08-23	EZU	ETF	37.875	37.875	37.875	37.875	2000.0
2000-08-23	FCTR	ETF	14.75	15.75	14.75	15.75	21200.0
2000-08-23	FMAR	ETF	5.0	5.25	5.0	5.12	3700.0
2000-08-23	GLDB	ETF	5.3125	5.375	5.1875	5.375	45600.0
2000-08-23	GSIG	ETF	25.62	25.62	24.87	25.37	240600.0
2000-08-23	IDU	ETF	39.125	39.6719	39.125	39.6719	3800.0
2000-08-23	IEV	ETF	39.0	39.3672	38.9219	39.3672	39600.0
2000-08-23	IGLD	ETF	671.875	725.0	637.5	637.5	1869.0
2000-08-23	IJH	ETF	10.4813	10.5375	10.4234	10.5375	1216000.0
2000-08-23	IJK	ETF	17.6367	17.8047	17.5918	17.8047	2400.0
2000-08-23	IJR	ETF	17.8021	17.9453	17.7917	17.9453	41400.0
2000-08-23	IJS	ETF	17.7539	17.7578	17.7539	17.7578	12800.0
2000-08-23	IJT	ETF	21.0195	21.0195	20.9492	20.9492	800.0
2000-08-23	IUSG	ETF	34.8438	34.8438	34.8438	34.8438	400.0
2000-08-23	IUSV	ETF	24.3906	24.4375	24.3906	24.4375	1200.0
2000-08-23	IVE	ETF	62.7969	62.9062	62.6875	62.9062	26000.0
2000-08-23	IVV	ETF	149.875	150.9844	149.3438	150.8281	239100.0
2000-08-23	IVW	ETF	22.4297	22.707	22.3242	22.707	39600.0
2000-08-23	IWB	ETF	79.3906	80.0312	79.3906	79.75	5000.0
2000-08-23	IWD	ETF	57.5	57.5625	57.4688	57.5625	22200.0
2000-08-23	IWF	ETF	21.859375	22.1875	21.859375	22.1875	70000.0
2000-08-23	IWN	ETF	35.7969	35.7969	35.7969	35.7969	300.0
2000-08-23	IWO	ETF	79.5469	79.875	79.5469	79.875	12900.0

> showing 50 of 81 rows — these rows as CSV

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