PREVIEW / etf_daily / 2001-09-17

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-17.parquet
  size:    9 KB
  rows:    105

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-09-17	SPY	ETF	101.0	106.4	100.0	104.3	32388700.0
2001-09-17	QQQ	ETF	31.25	32.8	31.09	31.2	97738700.0
2001-09-17	IWM	ETF	41.0	42.495	41.0	41.75	1338800.0
2001-09-17	DIA	ETF	90.5	92.3	88.95	89.1	13237400.0
2001-09-17	BBH	ETF	38.3333	38.7667	37.3333	37.4167	4106100.0
2001-09-17	BITS	ETF	12.0	12.6	10.8	11.2	6300.0
2001-09-17	CEF	ETF	3.45	3.46	3.27	3.39	158100.0
2001-09-17	CHB	ETF	8.5	8.5	7.72	7.85	138300.0
2001-09-17	CNXT	ETF	9.75	10.15	8.65	9.45	3214940.0
2001-09-17	CSB	ETF	2.79999995231628	3.25	2.79999995231628	3.25	37000.0
2001-09-17	DGT	ETF	60.0	61.7	60.0	61.05	1200.0
2001-09-17	EFA	ETF	36.75	37.3	36.7	37.15	170400.0
2001-09-17	EWA	ETF	7.65	8.1	7.65	7.85	27300.0
2001-09-17	EWC	ETF	10.0	10.26	10.0	10.15	24400.0
2001-09-17	EWD	ETF	11.1	11.2	11.0	11.0	1700.0
2001-09-17	EWG	ETF	12.5	12.95	12.35	12.55	80400.0
2001-09-17	EWH	ETF	7.5	8.0	7.3	7.6	56500.0
2001-09-17	EWI	ETF	29.4	29.8	29.4	29.8	5800.0
2001-09-17	EWJ	ETF	33.6	33.92	32.36	33.16	181950.0
2001-09-17	EWL	ETF	11.7	11.9	11.6	11.9	6100.0
2001-09-17	EWM	ETF	17.2	17.8	17.0	17.8	10950.0
2001-09-17	EWN	ETF	16.05	16.05	15.75	15.75	1500.0
2001-09-17	EWP	ETF	17.95	18.15	17.65	18.15	600.0
2001-09-17	EWQ	ETF	16.9	16.95	16.35	16.6	18700.0
2001-09-17	EWS	ETF	9.3	9.3	8.92	9.04	20500.0
2001-09-17	EWT	ETF	15.5	15.56	14.7	15.2	36500.0
2001-09-17	EWU	ETF	27.1	28.5	27.1	27.68	26350.0
2001-09-17	EWW	ETF	12.6	12.85	12.0	12.0	19500.0
2001-09-17	EWY	ETF	11.25	11.66	11.05	11.3	60300.0
2001-09-17	EWZ	ETF	9.0	9.43	9.0	9.2	141600.0
2001-09-17	EZU	ETF	23.75	24.675	23.75	24.625	23400.0
2001-09-17	FCTR	ETF	16.0	16.61	15.08	16.34	29900.0
2001-09-17	FMAR	ETF	8.9	9.36	6.9	7.62	9100.0
2001-09-17	GLDB	ETF	7.4	7.74	6.85	7.25	65400.0
2001-09-17	GRNB	ETF	18.6514	18.6514	18.6514	18.6514	101.0
2001-09-17	GSIG	ETF	7.44	7.44	7.0	7.02	132300.0
2001-09-17	IBB	ETF	25.9333	26.7333	25.5333	25.7	371100.0
2001-09-17	ICF	ETF	20.8125	20.875	20.4875	20.495	7200.0
2001-09-17	IDU	ETF	35.25	35.675	35.205	35.5	6600.0
2001-09-17	IEV	ETF	27.75	27.75	26.225	27.0	77800.0
2001-09-17	IGLD	ETF	57.5	60.0	52.0	54.0	59.0
2001-09-17	IGM	ETF	6.8333	6.9833	6.775	6.775	54000.0
2001-09-17	IGN	ETF	25.5	25.5	25.5	25.5	500.0
2001-09-17	IGV	ETF	6.73	6.856	6.64	6.64	7000.0
2001-09-17	IJH	ETF	8.78	9.09	8.78	8.93	592000.0
2001-09-17	IJJ	ETF	20.35	20.625	20.2125	20.3	264000.0
2001-09-17	IJK	ETF	12.1	12.3938	12.0875	12.125	105600.0
2001-09-17	IJR	ETF	16.4667	16.8667	16.4667	16.5417	1123200.0
2001-09-17	IJS	ETF	18.75	19.1125	18.7125	18.75	161600.0
2001-09-17	IJT	ETF	16.225	16.7125	16.225	16.425	61600.0

> showing 50 of 105 rows — these rows as CSV

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