PREVIEW / etf_daily / 2000-09-14

all etf daily files

  file:    by_date/etf_daily/2000/2000-09-14.parquet
  size:    8 KB
  rows:    84

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-09-14	SPY	ETF	149.875	149.9375	148.1562	149.6406	3397100.0
2000-09-14	QQQ	ETF	95.25	95.9375	92.6406	93.0	28616300.0
2000-09-14	IWM	ETF	53.8281	54.1094	53.586	53.9062	114000.0
2000-09-14	DIA	ETF	112.1875	112.4688	110.7188	111.0156	663000.0
2000-09-14	BBH	ETF	62.625	63.3125	61.0833	61.6458	1692600.0
2000-09-14	BITS	ETF	20.125	20.25	17.0	19.25	7150.0
2000-09-14	CEF	ETF	3.3125	3.375	3.3125	3.375	52900.0
2000-09-14	CHB	ETF	4.88	4.94	4.75	4.94	112400.0
2000-09-14	CNXT	ETF	47.5	54.94	46.38	52.63	59487380.0
2000-09-14	CSB	ETF	1.79999995231628	1.79999995231628	1.79999995231628	1.79999995231628	37500.0
2000-09-14	EWA	ETF	9.875	9.875	9.75	9.75	9200.0
2000-09-14	EWC	ETF	16.75	17.0	16.75	17.0	17900.0
2000-09-14	EWD	ETF	23.625	23.75	23.5625	23.625	19200.0
2000-09-14	EWG	ETF	19.6875	19.8125	19.5	19.6875	167700.0
2000-09-14	EWH	ETF	12.5	12.6875	12.5	12.5625	69300.0
2000-09-14	EWI	ETF	43.375	43.75	43.25	43.375	5150.0
2000-09-14	EWJ	ETF	53.5	53.75	53.25	53.25	51675.0
2000-09-14	EWK	ETF	12.75	12.75	12.4375	12.4375	6900.0
2000-09-14	EWL	ETF	14.8125	14.8125	14.8125	14.8125	400.0
2000-09-14	EWM	ETF	22.25	22.5	22.25	22.25	6600.0
2000-09-14	EWN	ETF	22.9375	22.9375	22.5625	22.6875	18400.0
2000-09-14	EWO	ETF	7.5	7.5	7.5	7.5	1100.0
2000-09-14	EWP	ETF	24.375	24.375	24.3125	24.375	15000.0
2000-09-14	EWQ	ETF	25.8125	25.8125	25.5625	25.625	31000.0
2000-09-14	EWS	ETF	14.375	14.375	14.0	14.0	39450.0
2000-09-14	EWT	ETF	31.125	31.25	31.125	31.25	200.0
2000-09-14	EWU	ETF	35.75	35.75	35.0	35.0	18850.0
2000-09-14	EWW	ETF	16.75	16.8125	16.5625	16.8125	35300.0
2000-09-14	EWY	ETF	17.25	17.3125	17.1875	17.25	16600.0
2000-09-14	EWZ	ETF	19.0	19.0	19.0	19.0	1100.0
2000-09-14	EZU	ETF	37.3125	37.3125	37.0	37.0	23400.0
2000-09-14	FCTR	ETF	15.8125	16.375	15.8125	16.3125	81100.0
2000-09-14	FMAR	ETF	5.62	5.62	5.19	5.19	300.0
2000-09-14	GLDB	ETF	5.125	5.1875	5.0	5.0625	108800.0
2000-09-14	GSIG	ETF	22.37	24.0	22.37	22.69	247200.0
2000-09-14	IDU	ETF	42.8438	42.8438	42.2031	42.5625	20000.0
2000-09-14	IEV	ETF	38.5625	38.8438	38.5625	38.8438	30600.0
2000-09-14	IGLD	ETF	590.625	600.0	575.0	575.0	179.0
2000-09-14	IJH	ETF	10.9281	10.9797	10.9281	10.9328	1158000.0
2000-09-14	IJJ	ETF	20.0625	20.0625	19.9766	19.9766	12400.0
2000-09-14	IJK	ETF	18.375	18.5156	18.375	18.4277	12000.0
2000-09-14	IJR	ETF	18.6406	18.7734	18.6406	18.7057	148200.0
2000-09-14	IJS	ETF	18.3438	18.3789	18.3438	18.3555	2000.0
2000-09-14	IJT	ETF	22.082	22.2344	22.082	22.086	12000.0
2000-09-14	IUSG	ETF	34.2812	34.2812	34.125	34.125	19000.0
2000-09-14	IUSV	ETF	24.6667	24.6667	24.6615	24.6615	600.0
2000-09-14	IVE	ETF	63.9062	63.9062	63.4531	63.6406	75100.0
2000-09-14	IVV	ETF	149.75	149.8125	148.3281	148.4375	99900.0
2000-09-14	IVW	ETF	21.9727	21.9727	21.7773	21.7773	9200.0
2000-09-14	IWB	ETF	79.9531	79.9531	79.5625	79.5938	1700.0

> showing 50 of 84 rows — these rows as CSV

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