PREVIEW / etf_daily / 2001-01-04

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-04.parquet
  size:    8 KB
  rows:    93

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
2001-01-04	SPY	ETF	134.9375	135.4688	133.0	133.5469	9219000.0
2001-01-04	QQQ	ETF	61.625	63.625	60.2344	61.3125	58472800.0
2001-01-04	IWM	ETF	47.9375	48.2812	47.3125	47.5	506600.0
2001-01-04	DIA	ETF	109.1406	110.4062	108.75	109.2344	1516600.0
2001-01-04	BBH	ETF	56.25	57.4375	52.125	53.375	4234200.0
2001-01-04	BITS	ETF	10.25	11.0	10.0	11.0	3150.0
2001-01-04	BOSS	ETF	22.9	23.0	22.9	23.0	100.0
2001-01-04	CEF	ETF	3.125	3.125	3.0625	3.125	45600.0
2001-01-04	CHB	ETF	3.56	4.38	3.56	4.13	184400.0
2001-01-04	CNXT	ETF	16.5	17.902	16.0	17.25	4876810.0
2001-01-04	DGT	ETF	80.0	80.2031	79.7812	79.7812	2500.0
2001-01-04	EWA	ETF	9.8125	10.0	9.8125	10.0	93600.0
2001-01-04	EWC	ETF	13.375	13.5	13.375	13.4375	7400.0
2001-01-04	EWD	ETF	18.1875	18.1875	18.125	18.125	700.0
2001-01-04	EWG	ETF	19.625	19.8125	19.4375	19.8125	89600.0
2001-01-04	EWH	ETF	11.875	12.0	11.625	11.625	168200.0
2001-01-04	EWI	ETF	44.75	44.75	44.75	44.75	1650.0
2001-01-04	EWJ	ETF	44.5	44.75	43.25	43.75	373900.0
2001-01-04	EWL	ETF	16.75	17.125	16.75	17.125	17500.0
2001-01-04	EWM	ETF	19.5	19.5	19.5	19.5	6175.0
2001-01-04	EWN	ETF	23.1875	23.1875	22.9375	23.1875	6700.0
2001-01-04	EWO	ETF	7.625	7.75	7.625	7.75	13400.0
2001-01-04	EWP	ETF	24.5625	25.0	24.5625	25.0	4700.0
2001-01-04	EWQ	ETF	24.375	24.4375	24.1875	24.4375	37900.0
2001-01-04	EWS	ETF	13.5	13.5	13.0	13.25	60850.0
2001-01-04	EWT	ETF	23.0	23.0	22.0	22.375	45800.0
2001-01-04	EWU	ETF	35.875	36.0	35.25	35.375	376150.0
2001-01-04	EWW	ETF	13.875	14.25	13.875	14.125	29100.0
2001-01-04	EWY	ETF	13.625	13.6875	13.4375	13.4375	69200.0
2001-01-04	EWZ	ETF	17.875	17.9375	17.75	17.75	4000.0
2001-01-04	EZU	ETF	36.8125	36.8125	36.0	36.2188	338400.0
2001-01-04	FCTR	ETF	14.75	14.875	14.125	14.375	32800.0
2001-01-04	FMAR	ETF	5.5	5.5018	5.0	5.38	13100.0
2001-01-04	GLDB	ETF	4.9375	5.375	4.9375	5.375	349400.0
2001-01-04	GSIG	ETF	8.7	9.69	8.69	9.5	402300.0
2001-01-04	IDU	ETF	39.4375	39.4375	37.9531	38.2188	127400.0
2001-01-04	IEV	ETF	38.5625	38.5625	38.2812	38.4375	136000.0
2001-01-04	IGLD	ETF	215.625	225.0	215.625	225.0	95.0
2001-01-04	IJH	ETF	10.2563	10.2594	10.0344	10.0375	709000.0
2001-01-04	IJJ	ETF	21.3594	21.4375	21.1953	21.2383	111600.0
2001-01-04	IJK	ETF	15.2031	15.2676	14.7539	14.8652	90400.0
2001-01-04	IJR	ETF	18.0938	18.1302	17.8021	17.8125	685200.0
2001-01-04	IJS	ETF	19.2812	19.3438	19.211	19.211	157600.0
2001-01-04	IJT	ETF	19.375	19.375	18.8281	18.8828	32000.0
2001-01-04	IOO	ETF	35.5234	35.6172	35.2188	35.2188	3800.0
2001-01-04	IUSG	ETF	26.375	26.6016	26.1484	26.1484	14600.0
2001-01-04	IUSV	ETF	25.2396	25.2708	25.0625	25.1979	34200.0
2001-01-04	IVE	ETF	65.25	65.7188	64.9531	65.1875	80700.0
2001-01-04	IVV	ETF	134.6875	135.2188	133.125	133.5625	153500.0
2001-01-04	IVW	ETF	17.4258	17.4375	17.0508	17.1328	105600.0

> showing 50 of 93 rows — these rows as CSV

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