PREVIEW / etf_daily / 2001-07-17

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-17.parquet
  size:    8 KB
  rows:    99

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-07-17	SPY	ETF	120.2	121.95	119.83	121.84	7469800.0
2001-07-17	QQQ	ETF	41.829	43.4	41.54	43.3	59813000.0
2001-07-17	IWM	ETF	48.05	49.025	47.95	49.025	558400.0
2001-07-17	DIA	ETF	104.6	106.49	104.45	106.15	1513100.0
2001-07-17	BBH	ETF	37.4	37.8567	37.0233	37.73	3660600.0
2001-07-17	BITS	ETF	13.8	14.0	13.2	13.96	5000.0
2001-07-17	CEF	ETF	3.05	3.08	3.05	3.08	13400.0
2001-07-17	CHB	ETF	10.9	11.05	10.85	10.99	392500.0
2001-07-17	CNXT	ETF	7.8	8.95	7.63	8.67	2817870.0
2001-07-17	DGT	ETF	68.7	68.85	68.7	68.85	4000.0
2001-07-17	EWA	ETF	9.45	9.5	9.45	9.5	10100.0
2001-07-17	EWC	ETF	11.05	11.25	11.05	11.15	1500.0
2001-07-17	EWD	ETF	12.5	13.05	12.5	13.05	1500.0
2001-07-17	EWG	ETF	15.84	16.24	15.74	16.11	82300.0
2001-07-17	EWH	ETF	9.71	9.82	9.7	9.82	25200.0
2001-07-17	EWI	ETF	34.5	34.62	34.5	34.62	1050.0
2001-07-17	EWJ	ETF	38.04	38.68	38.04	38.48	44550.0
2001-07-17	EWL	ETF	12.7	13.2	12.7	13.2	1600.0
2001-07-17	EWM	ETF	18.04	18.4	18.04	18.2	625.0
2001-07-17	EWN	ETF	18.25	18.55	18.25	18.55	3800.0
2001-07-17	EWP	ETF	20.2	20.25	20.2	20.25	1100.0
2001-07-17	EWQ	ETF	19.11	19.49	19.11	19.36	10500.0
2001-07-17	EWS	ETF	10.02	10.16	10.02	10.02	9850.0
2001-07-17	EWT	ETF	17.9	17.9	17.72	17.72	28200.0
2001-07-17	EWU	ETF	29.8	30.1	29.7	29.94	57800.0
2001-07-17	EWW	ETF	15.25	15.54	15.25	15.54	11000.0
2001-07-17	EWY	ETF	12.82	13.0	12.82	13.0	11300.0
2001-07-17	EWZ	ETF	12.4	12.65	12.4	12.65	2400.0
2001-07-17	EZU	ETF	28.25	28.975	28.25	28.975	9200.0
2001-07-17	FCTR	ETF	17.19	17.5	17.05	17.5	22500.0
2001-07-17	FMAR	ETF	6.6	8.1	6.3	8.1	27300.0
2001-07-17	GLDB	ETF	7.4	7.75	7.33	7.75	35800.0
2001-07-17	GSIG	ETF	8.01	8.01	7.75	7.95	69600.0
2001-07-17	IBB	ETF	28.4167	28.7133	28.1667	28.7	383700.0
2001-07-17	ICF	ETF	21.0775	21.0775	21.0775	21.0775	1200.0
2001-07-17	IDU	ETF	39.475	39.625	39.295	39.43	4000.0
2001-07-17	IEV	ETF	30.0	30.32	29.875	30.1	51400.0
2001-07-17	IGLD	ETF	68.0	69.0	67.0	68.0	157.0
2001-07-17	IGM	ETF	9.0333	9.18	9.0333	9.18	65400.0
2001-07-17	IGV	ETF	10.15	10.15	10.128	10.128	1500.0
2001-07-17	IJH	ETF	10.002	10.164	10.0	10.164	357000.0
2001-07-17	IJJ	ETF	22.4	22.655	22.35	22.655	36000.0
2001-07-17	IJK	ETF	13.9588	14.0938	13.9362	14.0938	80800.0
2001-07-17	IJR	ETF	18.5	18.815	18.4317	18.815	751800.0
2001-07-17	IJS	ETF	20.7	20.9675	20.625	20.9675	63200.0
2001-07-17	IJT	ETF	18.6125	18.9325	18.5375	18.9325	32400.0
2001-07-17	IOO	ETF	30.19	30.63	30.125	30.63	26400.0
2001-07-17	IUSG	ETF	21.38	21.635	21.36	21.635	2400.0
2001-07-17	IUSV	ETF	24.8333	25.0333	24.77	25.0333	2400.0
2001-07-17	IVE	ETF	60.42	60.99	60.28	60.95	20600.0

> showing 50 of 99 rows — these rows as CSV

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