PREVIEW / etf_daily / 2000-10-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-10-18.parquet
  size:    8 KB
  rows:    85

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-10-18	SPY	ETF	132.625	136.125	130.1562	134.25	10897300.0
2000-10-18	QQQ	ETF	76.75	81.1875	74.5625	78.0	64806600.0
2000-10-18	IWM	ETF	45.8203	46.8125	45.625	46.5312	343600.0
2000-10-18	DIA	ETF	99.0	100.8125	96.75	99.7812	3011000.0
2000-10-18	BBH	ETF	57.3333	60.8333	56.0417	59.8958	2624700.0
2000-10-18	BITS	ETF	8.75	9.0	8.0	9.0	14800.0
2000-10-18	CEF	ETF	3.125	3.125	3.125	3.125	59900.0
2000-10-18	CHB	ETF	3.0	3.31	2.81	3.31	166400.0
2000-10-18	CNXT	ETF	29.94	32.13	25.56	26.31	11603250.0
2000-10-18	CSB	ETF	1.04999995231628	1.04999995231628	1.04999995231628	1.04999995231628	1600.0
2000-10-18	DGT	ETF	78.9844	78.9844	78.9844	78.9844	100.0
2000-10-18	EWA	ETF	8.9375	9.0625	8.8125	9.0	20600.0
2000-10-18	EWC	ETF	15.125	15.375	15.0	15.25	12700.0
2000-10-18	EWD	ETF	18.6875	18.875	18.625	18.8125	2200.0
2000-10-18	EWG	ETF	17.5	17.75	17.375	17.5	103500.0
2000-10-18	EWH	ETF	10.5	10.75	10.0	10.5625	21300.0
2000-10-18	EWI	ETF	39.625	40.0	39.375	39.375	1100.0
2000-10-18	EWJ	ETF	49.75	50.75	49.25	50.0	50425.0
2000-10-18	EWK	ETF	11.75	12.0	11.75	11.875	4100.0
2000-10-18	EWL	ETF	14.4375	14.4375	14.1875	14.375	3800.0
2000-10-18	EWM	ETF	22.25	22.5	22.25	22.25	17275.0
2000-10-18	EWN	ETF	21.1875	21.3125	20.8125	20.8125	2100.0
2000-10-18	EWO	ETF	6.8125	6.8125	6.8125	6.8125	2500.0
2000-10-18	EWP	ETF	22.0	22.0625	21.8125	21.8125	1700.0
2000-10-18	EWQ	ETF	22.1875	22.625	22.125	22.25	17600.0
2000-10-18	EWS	ETF	11.875	12.5	11.875	12.25	19400.0
2000-10-18	EWT	ETF	23.25	23.875	23.125	23.5	59450.0
2000-10-18	EWU	ETF	33.625	34.625	33.5	34.0	11400.0
2000-10-18	EWW	ETF	13.375	14.1875	13.375	14.1875	80400.0
2000-10-18	EWY	ETF	13.3125	13.4375	13.25	13.25	15800.0
2000-10-18	EZU	ETF	32.625	32.9375	32.4062	32.7188	18000.0
2000-10-18	FCTR	ETF	14.0	14.6875	14.0	14.5625	53600.0
2000-10-18	FMAR	ETF	5.03	5.34	4.9982	5.0	5100.0
2000-10-18	GLDB	ETF	4.0625	4.25	3.5625	3.8125	104100.0
2000-10-18	GSIG	ETF	12.81	13.12	12.25	12.69	260300.0
2000-10-18	IDU	ETF	41.8125	41.9062	40.875	41.1719	5200.0
2000-10-18	IEV	ETF	34.875	35.2188	34.875	35.2188	14600.0
2000-10-18	IGLD	ETF	318.75	321.875	293.75	300.0	1340.0
2000-10-18	IJH	ETF	9.5375	9.9125	9.5375	9.9062	101000.0
2000-10-18	IJJ	ETF	18.2188	18.375	18.2188	18.375	4400.0
2000-10-18	IJK	ETF	15.6641	16.5078	15.6641	16.3125	58400.0
2000-10-18	IJR	ETF	16.3958	16.7578	16.3594	16.6406	631800.0
2000-10-18	IJS	ETF	16.6562	16.6562	16.6562	16.6562	400.0
2000-10-18	IJT	ETF	18.75	19.4844	18.75	19.4844	6000.0
2000-10-18	IUSG	ETF	29.9453	29.9453	29.5234	29.5234	1000.0
2000-10-18	IUSV	ETF	23.3698	23.3698	23.3698	23.3698	600.0
2000-10-18	IVE	ETF	58.5	59.7812	58.25	59.125	214600.0
2000-10-18	IVV	ETF	131.375	135.8906	131.0312	134.7656	81800.0
2000-10-18	IVW	ETF	18.75	19.4844	18.5625	19.2188	154400.0
2000-10-18	IWB	ETF	70.25	72.5	70.0	72.14	13300.0

> showing 50 of 85 rows — these rows as CSV

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