PREVIEW / etf_daily / 2000-09-19

all etf daily files

  file:    by_date/etf_daily/2000/2000-09-19.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-19	SPY	ETF	145.125	146.3125	144.7031	145.9688	6588200.0
2000-09-19	QQQ	ETF	90.75	93.7813	89.875	93.1875	27568700.0
2000-09-19	IWM	ETF	51.9844	52.7188	51.6328	52.5	54800.0
2000-09-19	DIA	ETF	108.4375	108.4375	107.5938	107.9688	714100.0
2000-09-19	BBH	ETF	59.4583	60.4375	58.5417	60.3125	1499400.0
2000-09-19	BITS	ETF	16.5	17.0	14.5	16.75	23900.0
2000-09-19	CEF	ETF	3.3125	3.3125	3.25	3.3125	8300.0
2000-09-19	CHB	ETF	4.94	5.0	4.69	4.75	112400.0
2000-09-19	CNXT	ETF	47.44	49.06	45.63	48.63	5069870.0
2000-09-19	EWA	ETF	9.3125	9.4375	9.3125	9.375	15600.0
2000-09-19	EWC	ETF	16.6875	16.8125	16.5625	16.8125	12300.0
2000-09-19	EWD	ETF	22.5	22.875	22.4375	22.625	22100.0
2000-09-19	EWG	ETF	19.0	19.0625	18.8125	19.0	32800.0
2000-09-19	EWH	ETF	11.9375	12.25	11.9375	12.25	118700.0
2000-09-19	EWI	ETF	41.75	42.25	41.625	41.75	3100.0
2000-09-19	EWJ	ETF	53.5	54.0	53.5	54.0	62975.0
2000-09-19	EWK	ETF	12.0	12.25	12.0	12.0625	5400.0
2000-09-19	EWL	ETF	14.875	14.875	14.5625	14.6875	22100.0
2000-09-19	EWM	ETF	22.0	22.25	22.0	22.25	2800.0
2000-09-19	EWN	ETF	22.5625	22.5625	22.1875	22.25	14600.0
2000-09-19	EWO	ETF	7.375	7.375	7.3125	7.3125	500.0
2000-09-19	EWP	ETF	23.625	23.625	23.3125	23.375	2400.0
2000-09-19	EWQ	ETF	24.875	25.125	24.875	25.0	17200.0
2000-09-19	EWS	ETF	13.75	14.125	13.625	14.0	57000.0
2000-09-19	EWT	ETF	29.5	29.5	29.5	29.5	150.0
2000-09-19	EWU	ETF	34.5	34.625	34.25	34.375	9050.0
2000-09-19	EWW	ETF	16.0	16.1875	15.875	16.1875	16500.0
2000-09-19	EWY	ETF	14.875	15.25	14.8125	15.125	15100.0
2000-09-19	EWZ	ETF	18.0	18.0625	18.0	18.0625	10500.0
2000-09-19	EZU	ETF	35.875	35.9688	35.8438	35.875	5400.0
2000-09-19	FCTR	ETF	15.6875	16.0	15.6875	16.0	38800.0
2000-09-19	FMAR	ETF	5.25	5.25	5.12	5.12	4800.0
2000-09-19	GLDB	ETF	5.1719	5.1719	5.0	5.0625	140400.0
2000-09-19	GSIG	ETF	20.91	22.5	20.5	21.75	323100.0
2000-09-19	IDU	ETF	43.125	43.125	41.4375	41.4688	36800.0
2000-09-19	IEV	ETF	38.3438	38.3438	38.125	38.2344	11400.0
2000-09-19	IGLD	ETF	600.0	606.25	593.75	600.0	371.0
2000-09-19	IJH	ETF	10.5672	10.6625	10.5312	10.6625	2391000.0
2000-09-19	IJJ	ETF	19.4062	19.4062	19.3633	19.3633	5600.0
2000-09-19	IJK	ETF	17.7012	17.8789	17.7012	17.8789	2400.0
2000-09-19	IJR	ETF	18.0833	18.1224	17.9948	18.1224	14400.0
2000-09-19	IJS	ETF	17.875	17.8789	17.793	17.8281	6400.0
2000-09-19	IJT	ETF	21.2188	21.2188	21.1016	21.1016	5200.0
2000-09-19	IUSV	ETF	24.2188	24.2188	24.2188	24.2188	300.0
2000-09-19	IVE	ETF	62.4531	62.4531	62.1406	62.1875	28200.0
2000-09-19	IVV	ETF	145.625	146.5781	145.1719	146.3438	128300.0
2000-09-19	IVW	ETF	21.3398	21.625	21.2969	21.625	16400.0
2000-09-19	IWB	ETF	77.75	78.2031	77.75	78.2031	1200.0
2000-09-19	IWD	ETF	57.0312	57.25	57.0	57.0	4500.0
2000-09-19	IWF	ETF	21.1172	21.375	21.1172	21.375	12000.0

> showing 50 of 81 rows — these rows as CSV

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