PREVIEW / etf_daily / 2001-02-27

all etf daily files

  file:    by_date/etf_daily/2001/2001-02-27.parquet
  size:    8 KB
  rows:    93

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-02-27	SPY	ETF	126.8	127.84	125.51	126.44	11415000.0
2001-02-27	QQQ	ETF	51.54	52.08	48.9	49.0	66743500.0
2001-02-27	IWM	ETF	48.65	48.65	47.625	47.775	448400.0
2001-02-27	DIA	ETF	106.28	107.2	105.6	106.6	2046300.0
2001-02-27	BBH	ETF	50.85	50.85	48.8	49.0	2064600.0
2001-02-27	BITS	ETF	8.5	9.5	8.0	8.5	12100.0
2001-02-27	CEF	ETF	3.2	3.24	3.11	3.15	18600.0
2001-02-27	CHB	ETF	6.32	6.5	5.8	5.89	90700.0
2001-02-27	CNXT	ETF	14.44	14.69	13.0	13.0	3468710.0
2001-02-27	CSB	ETF	1.64999997615814	1.64999997615814	1.64999997615814	1.64999997615814	12200.0
2001-02-27	EWA	ETF	9.15	9.45	9.15	9.4	45800.0
2001-02-27	EWC	ETF	12.15	12.25	12.0	12.05	31400.0
2001-02-27	EWD	ETF	16.88	16.95	16.75	16.95	1700.0
2001-02-27	EWG	ETF	18.39	18.45	18.2	18.23	102100.0
2001-02-27	EWH	ETF	11.8	11.92	11.79	11.82	18600.0
2001-02-27	EWI	ETF	41.4	41.4	41.0	41.0	9500.0
2001-02-27	EWJ	ETF	42.64	42.92	42.36	42.4	86550.0
2001-02-27	EWK	ETF	12.63	12.81	12.63	12.81	2800.0
2001-02-27	EWL	ETF	15.5	15.5	15.4	15.42	11200.0
2001-02-27	EWM	ETF	20.44	20.6	20.44	20.6	24975.0
2001-02-27	EWN	ETF	21.65	21.65	21.4	21.5	5300.0
2001-02-27	EWO	ETF	8.45	8.6	8.45	8.46	13600.0
2001-02-27	EWP	ETF	24.3	24.3	24.15	24.15	41500.0
2001-02-27	EWQ	ETF	22.25	22.25	22.0	22.0	64300.0
2001-02-27	EWS	ETF	13.08	13.08	12.76	12.76	6100.0
2001-02-27	EWT	ETF	24.52	24.52	24.0	24.1	8300.0
2001-02-27	EWU	ETF	33.12	33.22	33.0	33.08	35600.0
2001-02-27	EWW	ETF	14.4	14.55	14.2	14.2	33300.0
2001-02-27	EWY	ETF	14.22	14.22	14.2	14.2	300.0
2001-02-27	EWZ	ETF	16.6	16.6	16.24	16.4	9800.0
2001-02-27	EZU	ETF	33.125	33.5469	33.125	33.3203	178200.0
2001-02-27	FCTR	ETF	14.6094	14.875	14.3906	14.5625	19400.0
2001-02-27	FMAR	ETF	5.88	5.88	5.88	5.88	500.0
2001-02-27	GLDB	ETF	7.1719	7.1719	7.0625	7.125	35200.0
2001-02-27	GSIG	ETF	9.67	9.67	8.94	8.97	67800.0
2001-02-27	IBB	ETF	33.3333	33.3333	32.2656	32.3333	61200.0
2001-02-27	ICF	ETF	19.4492	19.5703	19.4492	19.5703	1200.0
2001-02-27	IDU	ETF	41.425	41.6	41.15	41.15	4600.0
2001-02-27	IEV	ETF	34.45	34.495	34.225	34.45	98200.0
2001-02-27	IGLD	ETF	206.25	206.25	190.625	190.625	666.0
2001-02-27	IJH	ETF	10.19	10.19	10.023	10.031	551000.0
2001-02-27	IJJ	ETF	21.855	21.8825	21.5375	21.6725	111200.0
2001-02-27	IJK	ETF	14.73	14.73	14.4462	14.4462	2261600.0
2001-02-27	IJR	ETF	18.3733	18.3733	17.99	17.99	638400.0
2001-02-27	IJS	ETF	20.425	20.425	20.0625	20.12	102000.0
2001-02-27	IJT	ETF	18.475	18.5125	18.2975	18.2975	10000.0
2001-02-27	IOO	ETF	32.9375	33.1719	32.7656	32.7969	90600.0
2001-02-27	IUSG	ETF	23.815	23.815	23.41	23.41	2000.0
2001-02-27	IUSV	ETF	25.17	25.17	24.92	24.92	1800.0
2001-02-27	IVE	ETF	62.97	63.35	62.57	62.78	32600.0

> showing 50 of 93 rows — these rows as CSV

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