PREVIEW / etf_daily / 2000-09-20

all etf daily files

  file:    by_date/etf_daily/2000/2000-09-20.parquet
  size:    8 KB
  rows:    79

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-20	SPY	ETF	145.6875	146.0312	143.1562	144.8906	6508100.0
2000-09-20	QQQ	ETF	93.375	95.2344	91.3125	94.625	33123200.0
2000-09-20	IWM	ETF	52.3125	52.3125	51.625	51.9062	40400.0
2000-09-20	DIA	ETF	108.0	108.375	105.5312	106.9375	3727200.0
2000-09-20	BBH	ETF	60.1667	61.6667	59.5	61.6667	2090400.0
2000-09-20	BITS	ETF	15.75	16.875	15.5	16.875	2200.0
2000-09-20	CEF	ETF	3.3125	3.375	3.3125	3.3125	14500.0
2000-09-20	CHB	ETF	4.75	4.75	4.69	4.75	24300.0
2000-09-20	CNXT	ETF	48.38	49.25	43.25	48.81	12161790.0
2000-09-20	EWA	ETF	9.375	9.375	9.25	9.25	14700.0
2000-09-20	EWC	ETF	16.6875	16.75	16.4375	16.5	9200.0
2000-09-20	EWD	ETF	22.6875	22.6875	22.25	22.25	1300.0
2000-09-20	EWG	ETF	18.9375	18.9375	18.375	18.5	110100.0
2000-09-20	EWH	ETF	12.0625	12.0625	11.6875	11.8125	50800.0
2000-09-20	EWI	ETF	41.375	41.375	40.625	40.625	2450.0
2000-09-20	EWJ	ETF	54.5	54.75	54.0	54.25	84175.0
2000-09-20	EWK	ETF	12.0	12.0	11.9375	12.0	3600.0
2000-09-20	EWL	ETF	14.5	14.6875	14.4375	14.5	9300.0
2000-09-20	EWM	ETF	22.0	22.25	22.0	22.0	16425.0
2000-09-20	EWN	ETF	22.125	22.1875	22.0	22.0625	13400.0
2000-09-20	EWO	ETF	7.375	7.375	7.375	7.375	4000.0
2000-09-20	EWP	ETF	23.25	23.25	22.8125	22.875	3400.0
2000-09-20	EWQ	ETF	24.625	24.625	24.25	24.375	14500.0
2000-09-20	EWS	ETF	13.875	13.875	13.625	13.625	24850.0
2000-09-20	EWT	ETF	29.875	29.875	29.5	29.5	12150.0
2000-09-20	EWU	ETF	34.625	34.625	33.75	34.0	13900.0
2000-09-20	EWW	ETF	15.9375	16.25	15.9375	16.125	8500.0
2000-09-20	EWY	ETF	15.75	16.0	15.5	15.875	29500.0
2000-09-20	EWZ	ETF	17.625	17.6875	17.625	17.6875	400.0
2000-09-20	EZU	ETF	35.875	35.875	35.25	35.3125	4200.0
2000-09-20	FCTR	ETF	15.6875	16.1875	15.6875	16.0	71100.0
2000-09-20	FMAR	ETF	5.0	5.44	5.0	5.03	1500.0
2000-09-20	GLDB	ETF	5.0625	5.0625	5.0	5.0625	86700.0
2000-09-20	GSIG	ETF	22.19	22.25	20.75	21.75	207300.0
2000-09-20	IDU	ETF	41.3906	41.3906	40.5469	40.5781	38000.0
2000-09-20	IEV	ETF	38.0938	38.125	37.7812	38.0	18400.0
2000-09-20	IGLD	ETF	609.375	612.5	581.25	587.5	235.0
2000-09-20	IJH	ETF	10.6688	10.6688	10.5234	10.6469	2939000.0
2000-09-20	IJJ	ETF	19.375	19.375	19.3164	19.3555	5600.0
2000-09-20	IJK	ETF	17.7617	17.7617	17.7617	17.7617	200000.0
2000-09-20	IJR	ETF	18.1771	18.1823	18.0521	18.1458	558600.0
2000-09-20	IJS	ETF	17.9531	17.9531	17.8516	17.8516	3600.0
2000-09-20	IJT	ETF	21.0742	21.2891	21.0742	21.2891	3200.0
2000-09-20	IUSG	ETF	33.375	33.9375	33.375	33.9375	2000.0
2000-09-20	IVE	ETF	61.7969	61.7969	60.8594	61.1875	6200.0
2000-09-20	IVV	ETF	145.875	145.9219	143.4375	144.9844	127700.0
2000-09-20	IVW	ETF	21.543	21.6484	21.2305	21.543	6400.0
2000-09-20	IWB	ETF	77.7969	77.8281	77.3906	77.8281	3300.0
2000-09-20	IWD	ETF	56.8438	56.8438	55.875	56.1875	22400.0
2000-09-20	IWF	ETF	21.3125	21.3125	21.0625	21.0625	6000.0

> showing 50 of 79 rows — these rows as CSV

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