PREVIEW / etf_daily / 2001-03-09

all etf daily files

  file:    by_date/etf_daily/2001/2001-03-09.parquet
  size:    8 KB
  rows:    95

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-03-09	SPY	ETF	126.1	126.1	123.11	123.36	10020300.0
2001-03-09	QQQ	ETF	47.25	47.37	44.95	45.1	79990900.0
2001-03-09	IWM	ETF	47.3	47.775	46.955	46.955	246600.0
2001-03-09	DIA	ETF	108.0	108.0	105.75	106.15	3106100.0
2001-03-09	BBH	ETF	44.5833	46.33	44.05	44.1667	2565600.0
2001-03-09	BITS	ETF	9.0	10.0	9.0	10.0	2025.0
2001-03-09	CEF	ETF	3.22	3.24	3.17	3.18	16000.0
2001-03-09	CHB	ETF	5.4	5.4	5.03	5.09	49000.0
2001-03-09	CNXT	ETF	13.38	13.38	12.13	12.5	2221580.0
2001-03-09	CSB	ETF	1.70000004768372	1.70000004768372	1.60000002384186	1.60000002384186	8100.0
2001-03-09	DGT	ETF	73.3	73.3	72.49	72.49	400.0
2001-03-09	EWA	ETF	9.15	9.23	9.1	9.1	13300.0
2001-03-09	EWC	ETF	12.05	12.05	11.85	11.9	11300.0
2001-03-09	EWD	ETF	16.85	17.1	16.77	16.77	97700.0
2001-03-09	EWG	ETF	18.85	18.85	18.6	18.6	22600.0
2001-03-09	EWH	ETF	11.7	11.7	11.5	11.6	36200.0
2001-03-09	EWI	ETF	41.4	41.4	40.9	40.92	3400.0
2001-03-09	EWJ	ETF	40.96	41.12	40.24	40.24	125700.0
2001-03-09	EWL	ETF	15.5	15.5	15.2	15.38	4700.0
2001-03-09	EWM	ETF	20.6	20.6	20.4	20.4	5075.0
2001-03-09	EWN	ETF	21.65	21.72	21.5	21.5	21600.0
2001-03-09	EWO	ETF	8.62	8.62	8.62	8.62	1100.0
2001-03-09	EWP	ETF	25.25	25.35	24.9	24.9	2400.0
2001-03-09	EWQ	ETF	22.35	22.35	22.05	22.15	27700.0
2001-03-09	EWS	ETF	12.64	12.74	12.36	12.36	41350.0
2001-03-09	EWT	ETF	24.0	24.0	23.48	23.48	16950.0
2001-03-09	EWU	ETF	34.0	34.0	33.48	33.48	25500.0
2001-03-09	EWW	ETF	15.1	15.1	14.75	14.96	12700.0
2001-03-09	EWY	ETF	13.6	13.75	13.26	13.27	56300.0
2001-03-09	EWZ	ETF	16.9	17.0	16.68	17.0	400.0
2001-03-09	EZU	ETF	33.5547	33.75	33.4531	33.4609	9200.0
2001-03-09	FCTR	ETF	15.9844	16.0	15.25	15.75	34700.0
2001-03-09	FMAR	ETF	5.62	5.81	5.2491	5.81	3500.0
2001-03-09	GLDB	ETF	7.5	7.5938	7.4375	7.4688	100700.0
2001-03-09	GSIG	ETF	9.81	9.87	9.66	9.81	46200.0
2001-03-09	IBB	ETF	29.2656	29.9688	28.8333	28.8333	36300.0
2001-03-09	ICF	ETF	19.9297	20.0156	19.9297	20.0	21600.0
2001-03-09	IDU	ETF	41.7	41.7	41.395	41.46	1200.0
2001-03-09	IEV	ETF	35.3	35.3	34.755	34.945	79200.0
2001-03-09	IGLD	ETF	171.875	175.0	171.875	175.0	46.0
2001-03-09	IJH	ETF	10.021	10.028	9.925	9.925	619000.0
2001-03-09	IJJ	ETF	21.965	21.965	21.7175	21.8225	116000.0
2001-03-09	IJK	ETF	14.1912	14.2038	14.0425	14.0488	39200.0
2001-03-09	IJR	ETF	17.9833	17.9833	17.805	17.805	651600.0
2001-03-09	IJS	ETF	20.0825	20.125	19.94	20.0675	79600.0
2001-03-09	IJT	ETF	18.1125	18.1225	17.875	17.875	14000.0
2001-03-09	IOO	ETF	33.0	33.0	32.5	32.6875	5600.0
2001-03-09	IUSG	ETF	22.17	22.295	22.1	22.155	10000.0
2001-03-09	IUSV	ETF	25.1067	25.1067	24.9467	24.97	21000.0
2001-03-09	IVE	ETF	63.77	63.77	63.1	63.11	102400.0

> showing 50 of 95 rows — these rows as CSV

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