PREVIEW / etf_daily / 2001-09-28

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-28.parquet
  size:    9 KB
  rows:    107

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-28	SPY	ETF	102.98	109.62	102.5	104.44	21687200.0
2001-09-28	QQQ	ETF	28.84	29.92	28.31	28.98	84810800.0
2001-09-28	IWM	ETF	39.8	40.39	39.64	40.1	2264800.0
2001-09-28	DIA	ETF	87.25	88.74	87.05	88.35	8187100.0
2001-09-28	BBH	ETF	37.75	38.6633	36.9333	36.9833	7732500.0
2001-09-28	BITS	ETF	9.84	10.6	8.72	10.52	14775.0
2001-09-28	CEF	ETF	3.6	3.62	3.56	3.62	14700.0
2001-09-28	CHB	ETF	7.1	7.18	6.95	6.95	292700.0
2001-09-28	CNXT	ETF	8.0	8.66	7.87	8.3	4421890.0
2001-09-28	DGT	ETF	61.0	61.5	61.0	61.5	9500.0
2001-09-28	EFA	ETF	37.3	37.72	37.2267	37.6433	663900.0
2001-09-28	EWA	ETF	7.85	7.88	7.7	7.71	8500.0
2001-09-28	EWC	ETF	9.6	9.65	9.4	9.65	13600.0
2001-09-28	EWD	ETF	10.55	10.95	10.55	10.95	11300.0
2001-09-28	EWG	ETF	12.64	12.66	12.4	12.44	88200.0
2001-09-28	EWH	ETF	7.89	7.95	7.51	7.93	699900.0
2001-09-28	EWI	ETF	30.2	30.6	30.2	30.2	1150.0
2001-09-28	EWJ	ETF	32.8	33.64	32.8	33.6	89525.0
2001-09-28	EWK	ETF	10.6	10.9	10.6	10.65	4000.0
2001-09-28	EWL	ETF	12.3	12.3	12.01	12.05	13600.0
2001-09-28	EWM	ETF	17.24	17.44	17.24	17.44	4975.0
2001-09-28	EWN	ETF	16.2	16.25	16.0	16.0	6100.0
2001-09-28	EWO	ETF	7.4	7.4	7.2	7.2	5200.0
2001-09-28	EWP	ETF	18.7	18.7	18.4	18.7	1900.0
2001-09-28	EWQ	ETF	17.09	17.15	16.88	16.88	5500.0
2001-09-28	EWS	ETF	8.4	8.5	8.24	8.32	7600.0
2001-09-28	EWT	ETF	13.98	14.2	13.98	14.2	2800.0
2001-09-28	EWU	ETF	27.3	28.0	27.3	28.0	26750.0
2001-09-28	EWW	ETF	12.35	12.35	12.35	12.35	1300.0
2001-09-28	EWY	ETF	11.25	11.29	11.0	11.01	14400.0
2001-09-28	EWZ	ETF	9.35	9.35	9.17	9.2	800.0
2001-09-28	EZU	ETF	24.75	24.875	24.5	24.85	20800.0
2001-09-28	FCTR	ETF	15.9	16.71	15.9	16.35	24700.0
2001-09-28	FMAR	ETF	7.4	7.7	7.25	7.4	2100.0
2001-09-28	GLDB	ETF	7.54	7.79	7.41	7.79	107300.0
2001-09-28	GSIG	ETF	6.72	6.8	6.69	6.8	120900.0
2001-09-28	IBB	ETF	25.1667	25.6333	24.59	24.7833	845700.0
2001-09-28	ICF	ETF	20.6875	21.075	20.6875	20.9875	24400.0
2001-09-28	IDU	ETF	32.41	33.2	32.41	33.2	22800.0
2001-09-28	IEV	ETF	27.2	27.33	26.9	27.175	24400.0
2001-09-28	IGLD	ETF	73.0	74.0	73.0	74.0	9.0
2001-09-28	IGM	ETF	6.2667	6.3467	6.2417	6.3083	9600.0
2001-09-28	IGN	ETF	25.35	25.35	24.1	24.1	1700.0
2001-09-28	IGV	ETF	6.03	6.03	6.0	6.0	10000.0
2001-09-28	IJH	ETF	8.5	8.68	8.5	8.665	190000.0
2001-09-28	IJJ	ETF	19.525	19.8925	19.45	19.8925	75600.0
2001-09-28	IJK	ETF	11.45	11.6938	11.45	11.6888	34400.0
2001-09-28	IJR	ETF	15.6667	15.975	15.6667	15.9167	979800.0
2001-09-28	IJS	ETF	17.375	17.85	17.3	17.85	90400.0
2001-09-28	IJT	ETF	15.9375	16.12	15.925	16.095	39200.0

> showing 50 of 107 rows — these rows as CSV

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