PREVIEW / etf_daily / 2001-01-09

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-09.parquet
  size:    8 KB
  rows:    91

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-09	SPY	ETF	131.0469	131.5	129.4219	129.8438	5702400.0
2001-01-09	QQQ	ETF	57.75	59.125	56.625	57.25	53318900.0
2001-01-09	IWM	ETF	46.1875	46.5625	45.8438	46.1172	327600.0
2001-01-09	DIA	ETF	106.9375	106.9688	105.1562	105.4375	1313100.0
2001-01-09	BBH	ETF	45.5417	47.7917	45.5	47.4792	5059500.0
2001-01-09	BITS	ETF	10.0	10.5	9.0	10.0	15825.0
2001-01-09	CEF	ETF	3.1875	3.1875	3.125	3.1875	5200.0
2001-01-09	CHB	ETF	4.31	4.69	4.31	4.5	614400.0
2001-01-09	CNXT	ETF	16.44	17.37	16.12	16.94	2632700.0
2001-01-09	DGT	ETF	78.125	78.125	77.6719	77.9688	600.0
2001-01-09	EWA	ETF	9.75	9.75	9.5625	9.75	6600.0
2001-01-09	EWC	ETF	13.0	13.0625	12.875	12.9375	18700.0
2001-01-09	EWD	ETF	18.3125	18.5	18.3125	18.5	2500.0
2001-01-09	EWG	ETF	19.5	19.5	19.3125	19.4375	84800.0
2001-01-09	EWH	ETF	11.6875	11.9375	11.6875	11.9375	84600.0
2001-01-09	EWI	ETF	44.375	44.75	44.375	44.75	2750.0
2001-01-09	EWJ	ETF	43.5	43.75	43.0	43.5	65375.0
2001-01-09	EWK	ETF	13.0	13.125	13.0	13.125	11500.0
2001-01-09	EWL	ETF	16.4375	16.5	16.375	16.375	42100.0
2001-01-09	EWM	ETF	19.75	20.0	19.75	19.75	3675.0
2001-01-09	EWN	ETF	22.625	23.0	22.625	23.0	4200.0
2001-01-09	EWO	ETF	7.8125	7.8125	7.8125	7.8125	1900.0
2001-01-09	EWP	ETF	24.75	24.9375	24.625	24.9375	7600.0
2001-01-09	EWQ	ETF	23.9375	23.9375	23.625	23.875	49800.0
2001-01-09	EWS	ETF	13.375	13.75	13.375	13.75	11400.0
2001-01-09	EWT	ETF	23.625	24.0	23.5	23.875	8700.0
2001-01-09	EWU	ETF	35.5	35.5	34.875	34.875	18100.0
2001-01-09	EWW	ETF	14.125	14.25	13.75	13.75	21700.0
2001-01-09	EWY	ETF	14.5	14.625	14.5	14.625	8000.0
2001-01-09	EWZ	ETF	17.9375	17.9375	17.875	17.875	2700.0
2001-01-09	EZU	ETF	36.0	36.0938	35.7188	35.8125	14600.0
2001-01-09	FCTR	ETF	13.875	13.9063	13.5	13.625	13100.0
2001-01-09	FMAR	ETF	5.09	5.25	4.75	5.25	1900.0
2001-01-09	GLDB	ETF	4.9688	4.9688	4.6875	4.8125	49200.0
2001-01-09	GSIG	ETF	8.75	9.12	8.56	8.69	69000.0
2001-01-09	IDU	ETF	38.6562	38.8125	38.3906	38.5	219400.0
2001-01-09	IEV	ETF	37.875	37.875	37.7188	37.8125	24400.0
2001-01-09	IGLD	ETF	206.25	212.5	200.0	212.5	268.0
2001-01-09	IJH	ETF	9.8031	9.8125	9.6891	9.7469	1294000.0
2001-01-09	IJJ	ETF	20.9375	20.9375	20.711	20.7852	23200.0
2001-01-09	IJK	ETF	14.2578	14.2949	14.0566	14.1484	35200.0
2001-01-09	IJR	ETF	17.4479	17.599	17.3594	17.375	326400.0
2001-01-09	IJS	ETF	18.9648	19.0781	18.9414	19.0625	28400.0
2001-01-09	IJT	ETF	18.336	18.4062	18.0586	18.1641	24000.0
2001-01-09	IUSG	ETF	25.0	25.0	25.0	25.0	4000.0
2001-01-09	IUSV	ETF	24.8854	24.8854	24.7552	24.7552	1500.0
2001-01-09	IVE	ETF	63.75	63.9062	63.3281	63.625	34300.0
2001-01-09	IVV	ETF	130.75	131.4062	129.5312	129.9375	128600.0
2001-01-09	IVW	ETF	16.75	16.8672	16.6016	16.7188	116800.0
2001-01-09	IWB	ETF	68.87	69.03	68.21	68.68	30400.0

> showing 50 of 91 rows — these rows as CSV

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