PREVIEW / etf_daily / 2000-09-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-09-18.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-09-18	SPY	ETF	146.375	146.9688	144.2031	144.6562	5109300.0
2000-09-18	QQQ	ETF	91.8125	93.0	88.0	89.875	29218500.0
2000-09-18	IWM	ETF	53.1406	53.1406	51.5078	51.6562	201400.0
2000-09-18	DIA	ETF	109.4375	109.4688	107.8594	108.25	1033800.0
2000-09-18	BBH	ETF	61.625	62.3125	58.125	58.25	2281200.0
2000-09-18	BITS	ETF	17.0	18.0	16.0	17.0	8625.0
2000-09-18	CEF	ETF	3.25	3.3125	3.25	3.25	106500.0
2000-09-18	CHB	ETF	5.0	5.25	4.88	4.94	124100.0
2000-09-18	CNXT	ETF	48.75	49.75	45.31	47.38	8219760.0
2000-09-18	CSB	ETF	1.79999995231628	1.79999995231628	1.79999995231628	1.79999995231628	8000.0
2000-09-18	EWA	ETF	9.6875	9.6875	9.375	9.4375	17100.0
2000-09-18	EWC	ETF	17.125	17.125	16.5625	16.75	15200.0
2000-09-18	EWD	ETF	22.8125	22.8125	22.4375	22.4375	1100.0
2000-09-18	EWG	ETF	19.3125	19.3125	18.9375	19.0	42400.0
2000-09-18	EWH	ETF	11.75	11.875	11.625	11.6875	147800.0
2000-09-18	EWI	ETF	42.375	42.375	42.0	42.125	9000.0
2000-09-18	EWJ	ETF	53.5	53.75	53.0	53.0	71375.0
2000-09-18	EWK	ETF	12.1875	12.3125	12.125	12.125	2000.0
2000-09-18	EWL	ETF	14.6875	14.9375	14.6875	14.875	9000.0
2000-09-18	EWM	ETF	22.25	22.5	22.0	22.0	21275.0
2000-09-18	EWN	ETF	22.5625	22.5625	22.3125	22.3125	3500.0
2000-09-18	EWO	ETF	7.3125	7.4375	7.3125	7.4375	2800.0
2000-09-18	EWP	ETF	24.25	24.25	23.5625	23.75	15300.0
2000-09-18	EWQ	ETF	25.25	25.25	24.8125	24.9375	35400.0
2000-09-18	EWS	ETF	13.875	13.875	13.5	13.5	24300.0
2000-09-18	EWT	ETF	29.875	30.25	29.875	30.25	250.0
2000-09-18	EWU	ETF	34.25	34.75	34.25	34.5	22950.0
2000-09-18	EWW	ETF	16.5	16.5	16.0625	16.1875	26900.0
2000-09-18	EWY	ETF	14.8125	15.125	14.8125	15.0	6700.0
2000-09-18	EWZ	ETF	18.375	18.375	18.125	18.1875	1000.0
2000-09-18	EZU	ETF	36.3125	36.375	35.9062	35.9062	5400.0
2000-09-18	FCTR	ETF	16.0938	16.0938	15.875	15.9375	27100.0
2000-09-18	FMAR	ETF	5.62	5.62	5.12	5.16	2900.0
2000-09-18	GLDB	ETF	5.0313	5.1875	5.0313	5.0625	99300.0
2000-09-18	GSIG	ETF	20.06	22.19	20.0	21.0	294000.0
2000-09-18	IDU	ETF	43.5	43.5	43.1562	43.1562	13400.0
2000-09-18	IEV	ETF	38.0	38.1875	37.9922	38.125	56000.0
2000-09-18	IGLD	ETF	587.5	600.0	556.25	593.75	709.0
2000-09-18	IJH	ETF	10.8656	10.8656	10.5156	10.525	4780000.0
2000-09-18	IJJ	ETF	19.6445	19.6445	19.5469	19.5469	1200.0
2000-09-18	IJK	ETF	18.2656	18.2656	17.6211	17.6211	19200.0
2000-09-18	IJR	ETF	18.5781	18.5781	18.0625	18.0729	136800.0
2000-09-18	IJS	ETF	18.25	18.25	17.8945	17.8945	12400.0
2000-09-18	IJT	ETF	21.8008	21.8008	21.1562	21.1562	178000.0
2000-09-18	IVE	ETF	63.2188	63.2188	62.2031	62.2031	20000.0
2000-09-18	IVV	ETF	146.75	147.1875	144.9688	145.0	144700.0
2000-09-18	IVW	ETF	21.4336	21.6406	21.1367	21.1445	81200.0
2000-09-18	IWB	ETF	78.3906	78.3906	77.5	77.5	7600.0
2000-09-18	IWD	ETF	57.7812	57.7812	57.125	57.125	27700.0
2000-09-18	IWF	ETF	21.1953	21.1953	20.83595	20.83595	34400.0

> showing 50 of 81 rows — these rows as CSV

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