PREVIEW / etf_daily / 2001-09-27

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-27.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-27	SPY	ETF	101.25	102.29	100.0	102.27	20536800.0
2001-09-27	QQQ	ETF	28.4	28.79	27.42	28.48	70050700.0
2001-09-27	IWM	ETF	38.89	39.525	38.315	39.515	1879400.0
2001-09-27	DIA	ETF	86.0	86.99	84.8	86.75	4621500.0
2001-09-27	BBH	ETF	35.45	37.7	35.1	37.39	5352000.0
2001-09-27	BITS	ETF	10.08	10.08	9.9216	10.0	625.0
2001-09-27	CEF	ETF	3.55	3.6	3.55	3.6	23000.0
2001-09-27	CHB	ETF	6.52	7.01	6.5	7.01	129300.0
2001-09-27	CNXT	ETF	8.1	8.34	7.25	7.79	2938500.0
2001-09-27	CSB	ETF	3.09999990463257	3.09999990463257	3.0	3.09999990463257	21300.0
2001-09-27	DGT	ETF	59.6	59.6	59.6	59.6	2000.0
2001-09-27	EFA	ETF	36.35	36.9333	36.2833	36.9233	662400.0
2001-09-27	EWA	ETF	7.8	7.8	7.6	7.6	10100.0
2001-09-27	EWC	ETF	9.35	9.4	9.25	9.4	11700.0
2001-09-27	EWD	ETF	10.35	10.35	10.35	10.35	200.0
2001-09-27	EWG	ETF	12.14	12.45	11.98	12.35	61900.0
2001-09-27	EWH	ETF	7.4	7.64	7.4	7.63	6800.0
2001-09-27	EWI	ETF	28.9	29.1	28.9	29.1	5350.0
2001-09-27	EWJ	ETF	32.48	32.84	32.08	32.56	41275.0
2001-09-27	EWK	ETF	10.7	10.7	10.7	10.7	900.0
2001-09-27	EWL	ETF	11.55	12.05	11.55	12.05	4300.0
2001-09-27	EWM	ETF	17.04	17.4	17.04	17.08	2750.0
2001-09-27	EWP	ETF	18.1	18.15	18.1	18.15	800.0
2001-09-27	EWQ	ETF	16.65	16.86	16.6	16.86	13500.0
2001-09-27	EWS	ETF	8.06	8.38	8.06	8.12	10650.0
2001-09-27	EWT	ETF	14.1	14.14	13.76	14.14	31500.0
2001-09-27	EWU	ETF	26.5	27.3	26.3	27.2	11200.0
2001-09-27	EWW	ETF	12.5	12.5	11.9	12.38	136400.0
2001-09-27	EWY	ETF	10.97	11.07	10.75	10.85	24600.0
2001-09-27	EWZ	ETF	8.69	8.98	8.44	8.87	53000.0
2001-09-27	EZU	ETF	23.81	24.3	23.81	24.3	3200.0
2001-09-27	FCTR	ETF	16.26	16.76	15.68	15.93	26900.0
2001-09-27	FMAR	ETF	7.37	7.64	7.35	7.5	5500.0
2001-09-27	GLDB	ETF	7.3	7.62	7.3	7.55	59200.0
2001-09-27	GSIG	ETF	6.64	6.8	6.63	6.65	85500.0
2001-09-27	IBB	ETF	23.4	24.5667	23.1667	24.5333	1050600.0
2001-09-27	ICF	ETF	20.6875	20.72	20.6125	20.72	11200.0
2001-09-27	IDU	ETF	32.175	32.2	31.575	32.155	10600.0
2001-09-27	IEV	ETF	26.2	26.745	26.2	26.675	19800.0
2001-09-27	IGLD	ETF	63.0	73.0	63.0	69.0	127.0
2001-09-27	IGM	ETF	6.0417	6.1583	6.0417	6.1583	7200.0
2001-09-27	IGN	ETF	22.87	23.45	22.7	23.45	1200.0
2001-09-27	IGV	ETF	5.69	5.69	5.69	5.69	500.0
2001-09-27	IJH	ETF	8.33	8.46	8.205	8.46	210000.0
2001-09-27	IJJ	ETF	19.1625	19.4125	18.8875	19.4125	380800.0
2001-09-27	IJK	ETF	11.175	11.3375	11.0062	11.3375	68800.0
2001-09-27	IJR	ETF	15.4167	15.5833	15.225	15.5833	860400.0
2001-09-27	IJS	ETF	17.175	17.2875	16.95	17.2875	133600.0
2001-09-27	IJT	ETF	15.5	15.8125	15.3875	15.7	61200.0
2001-09-27	IOO	ETF	26.035	26.405	25.84	26.405	4400.0

> showing 50 of 105 rows — these rows as CSV

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