PREVIEW / etf_daily / 2000-08-21

all etf daily files

  file:    by_date/etf_daily/2000/2000-08-21.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-21	SPY	ETF	150.0312	150.7188	149.4062	150.5	2380600.0
2000-08-21	QQQ	ETF	96.0	96.8594	94.375	95.5	13560100.0
2000-08-21	IWM	ETF	51.875	51.9219	51.4062	51.7344	129200.0
2000-08-21	DIA	ETF	110.9375	111.125	110.2188	111.125	755100.0
2000-08-21	BBH	ETF	57.9167	59.8333	57.8333	59.1042	1276200.0
2000-08-21	BITS	ETF	12.25	12.75	12.125	12.125	7200.0
2000-08-21	BOSS	ETF	20.5	20.6	20.5	20.6	400.0
2000-08-21	CEF	ETF	3.3125	3.3125	3.25	3.3125	75300.0
2000-08-21	CHB	ETF	6.0	6.06	5.63	5.69	52700.0
2000-08-21	CNXT	ETF	40.75	40.88	36.44	37.5	5239170.0
2000-08-21	EWA	ETF	10.6875	10.6875	10.625	10.6875	2400.0
2000-08-21	EWC	ETF	21.625	21.75	21.5625	21.5625	26800.0
2000-08-21	EWG	ETF	23.4375	23.4375	23.1875	23.3125	60300.0
2000-08-21	EWH	ETF	13.75	13.9375	13.75	13.8125	20700.0
2000-08-21	EWI	ETF	50.0	50.0	49.5	49.5	11050.0
2000-08-21	EWJ	ETF	55.0	55.25	54.5	55.0	30400.0
2000-08-21	EWK	ETF	14.125	14.125	14.0	14.0	1200.0
2000-08-21	EWL	ETF	16.1875	16.25	15.9375	16.1875	1800.0
2000-08-21	EWM	ETF	25.0	25.0	24.5	24.5	900.0
2000-08-21	EWN	ETF	24.5	24.5	24.125	24.1875	1800.0
2000-08-21	EWO	ETF	8.0625	8.125	8.0625	8.0625	96600.0
2000-08-21	EWP	ETF	26.4375	26.5625	26.375	26.4375	600.0
2000-08-21	EWQ	ETF	27.8125	27.875	27.6875	27.75	6000.0
2000-08-21	EWS	ETF	16.25	16.625	16.125	16.25	21200.0
2000-08-21	EWT	ETF	37.25	37.625	37.125	37.25	1200.0
2000-08-21	EWU	ETF	39.625	39.625	39.125	39.625	6000.0
2000-08-21	EWW	ETF	16.6875	16.6875	16.25	16.4375	37500.0
2000-08-21	EWY	ETF	19.5	19.5	19.0	19.0625	1800.0
2000-08-21	EWZ	ETF	19.75	19.75	19.75	19.75	300.0
2000-08-21	EZU	ETF	38.625	38.625	38.375	38.375	20800.0
2000-08-21	FCTR	ETF	14.25	14.375	14.0625	14.25	20200.0
2000-08-21	FMAR	ETF	4.94	5.0025	4.94	4.94	3300.0
2000-08-21	GLDB	ETF	5.3125	5.875	5.25	5.3125	106100.0
2000-08-21	GSIG	ETF	26.19	26.25	24.62	26.12	627100.0
2000-08-21	IDU	ETF	39.125	39.125	39.0	39.0625	2800.0
2000-08-21	IEV	ETF	39.3906	39.4375	39.25	39.3438	72200.0
2000-08-21	IGLD	ETF	637.5	637.5	581.25	600.0	1449.0
2000-08-21	IJH	ETF	10.5219	10.5375	10.4656	10.4953	108000.0
2000-08-21	IJJ	ETF	19.2344	19.2344	19.1875	19.1953	4000.0
2000-08-21	IJK	ETF	17.7148	17.791	17.7148	17.7578	11200.0
2000-08-21	IJR	ETF	17.9375	17.9714	17.875	17.875	3600.0
2000-08-21	IJS	ETF	17.7578	17.7578	17.6875	17.6875	172000.0
2000-08-21	IJT	ETF	21.0625	21.0625	21.0625	21.0625	1600.0
2000-08-21	IUSG	ETF	34.6094	34.7812	34.6094	34.7812	800.0
2000-08-21	IVE	ETF	62.6875	62.8125	62.5	62.8125	29500.0
2000-08-21	IVV	ETF	150.1562	150.5156	149.4375	149.4375	43000.0
2000-08-21	IVW	ETF	22.5664	22.6758	22.4062	22.5195	19600.0
2000-08-21	IWD	ETF	57.375	57.5312	57.3594	57.5312	3000.0
2000-08-21	IWF	ETF	21.9453	22.0625	21.8125	21.890625	60400.0
2000-08-21	IWN	ETF	35.7917	35.7917	35.7813	35.7813	3000.0

> showing 50 of 81 rows — these rows as CSV

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