PREVIEW / etf_daily / 2001-12-20

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-20.parquet
  size:    9 KB
  rows:    116

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-12-20	SPY	ETF	115.5	115.8	114.55	114.65	14867900.0
2001-12-20	QQQ	ETF	40.1	40.3	38.68	38.79	83048800.0
2001-12-20	IWM	ETF	47.9	47.915	46.975	47.15	5581600.0
2001-12-20	DIA	ETF	100.8	101.07	100.1	100.21	2260600.0
2001-12-20	ARB	ETF	31.95	32.12	31.65	31.65	208900.0
2001-12-20	BBH	ETF	44.7667	45.0233	44.1667	44.1667	3279300.0
2001-12-20	BITS	ETF	24.2	24.32	21.92	23.4	12525.0
2001-12-20	CEF	ETF	3.35	3.41	3.34	3.41	11900.0
2001-12-20	CHB	ETF	13.1	13.1	12.63	12.64	218900.0
2001-12-20	CNXT	ETF	14.1	14.3	12.72	13.03	13186700.0
2001-12-20	CSB	ETF	3.75	3.84999990463257	3.70000004768372	3.75	33400.0
2001-12-20	EFA	ETF	39.0	39.1	38.85	38.96	1377600.0
2001-12-20	ELV	ETF	23.88	24.0	23.4	23.45	656000.0
2001-12-20	EPP	ETF	17.86	17.86	17.86	17.86	300.0
2001-12-20	EWA	ETF	9.24	9.24	9.03	9.18	11100.0
2001-12-20	EWC	ETF	10.8	10.9	10.65	10.9	11300.0
2001-12-20	EWD	ETF	13.19	13.19	13.06	13.19	1200.0
2001-12-20	EWG	ETF	14.6	14.6	14.42	14.5	196800.0
2001-12-20	EWH	ETF	9.41	9.46	9.3	9.31	48000.0
2001-12-20	EWI	ETF	31.32	31.6	31.2	31.3	1300.0
2001-12-20	EWJ	ETF	31.48	31.48	31.16	31.2	173250.0
2001-12-20	EWK	ETF	10.51	10.69	10.51	10.69	200.0
2001-12-20	EWL	ETF	12.54	12.54	12.31	12.48	58500.0
2001-12-20	EWM	ETF	19.56	19.72	19.44	19.68	1575.0
2001-12-20	EWN	ETF	16.45	16.45	16.21	16.21	2600.0
2001-12-20	EWO	ETF	7.24	7.3	7.24	7.29	3700.0
2001-12-20	EWP	ETF	20.54	20.64	20.36	20.64	4600.0
2001-12-20	EWQ	ETF	18.29	18.3	18.05	18.3	36000.0
2001-12-20	EWS	ETF	10.0	10.1	9.88	9.9	11500.0
2001-12-20	EWT	ETF	21.32	21.32	20.5	20.5	13050.0
2001-12-20	EWU	ETF	29.12	29.12	28.74	28.8	185700.0
2001-12-20	EWW	ETF	14.95	14.95	14.67	14.67	3900.0
2001-12-20	EWY	ETF	16.9	16.93	16.71	16.71	466800.0
2001-12-20	EWZ	ETF	12.35	12.35	12.0	12.0	35200.0
2001-12-20	EZU	ETF	27.125	27.145	26.805	27.0	203200.0
2001-12-20	FCTR	ETF	18.1	18.22	18.0	18.03	24800.0
2001-12-20	FMAR	ETF	9.25	9.25	9.07	9.15	41000.0
2001-12-20	GLDB	ETF	7.31	7.44	7.31	7.35	42200.0
2001-12-20	GRNB	ETF	17.179	17.179	17.179	17.179	4037.0
2001-12-20	GSIG	ETF	7.65	7.7	7.25	7.28	219900.0
2001-12-20	IBB	ETF	30.6333	30.8167	30.2267	30.3833	384300.0
2001-12-20	ICF	ETF	20.92	20.92	20.7875	20.7875	37600.0
2001-12-20	IDU	ETF	31.05	31.085	30.62	30.95	65000.0
2001-12-20	IEV	ETF	28.975	29.015	28.735	28.78	211200.0
2001-12-20	IGLD	ETF	88.5	88.5	87.0	88.0	305.0
2001-12-20	IGM	ETF	8.6	8.6	8.3167	8.3333	559800.0
2001-12-20	IGN	ETF	30.0	30.0	29.1	29.3	608300.0
2001-12-20	IGV	ETF	9.37	9.37	8.952	8.96	25500.0
2001-12-20	IJH	ETF	10.02	10.047	9.921	9.927	469000.0
2001-12-20	IJJ	ETF	21.9875	22.0825	21.82	21.9275	64000.0

> showing 50 of 116 rows — these rows as CSV

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