PREVIEW / etf_daily / 2001-12-31

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-31.parquet
  size:    9 KB
  rows:    117

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-31	SPY	ETF	116.15	116.39	114.23	114.3	14619500.0
2001-12-31	QQQ	ETF	40.31	40.45	38.91	38.91	46176900.0
2001-12-31	IWM	ETF	49.125	49.2	48.175	48.175	2346600.0
2001-12-31	DIA	ETF	101.34	101.47	99.66	99.8	1706300.0
2001-12-31	ARB	ETF	33.8	34.48	33.0	33.9	92000.0
2001-12-31	BBH	ETF	45.2	45.6333	43.99	44.0	2877600.0
2001-12-31	BITS	ETF	25.48	29.0	25.4	27.44	11350.0
2001-12-31	CEF	ETF	3.29	3.43	3.28	3.33	36500.0
2001-12-31	CHB	ETF	12.27	12.5	12.25	12.3	396600.0
2001-12-31	CNXT	ETF	14.59	14.95	14.25	14.36	4550960.0
2001-12-31	DGT	ETF	66.67	66.94	66.67	66.94	1000.0
2001-12-31	EFA	ETF	39.81	39.97	39.7667	39.7667	717300.0
2001-12-31	ELV	ETF	24.35	25.125	24.35	24.75	896400.0
2001-12-31	EPP	ETF	18.1433	18.1433	18.0567	18.0567	1200.0
2001-12-31	EWA	ETF	9.35	9.48	9.33	9.45	16100.0
2001-12-31	EWC	ETF	10.75	10.79	10.6	10.62	8900.0
2001-12-31	EWD	ETF	13.72	13.89	13.71	13.71	3400.0
2001-12-31	EWG	ETF	14.9	15.1	14.9	15.1	38100.0
2001-12-31	EWH	ETF	9.23	9.27	9.13	9.17	54200.0
2001-12-31	EWI	ETF	32.2	32.2	32.2	32.2	2200.0
2001-12-31	EWJ	ETF	31.36	31.52	30.8	30.84	100675.0
2001-12-31	EWL	ETF	12.6	12.7	12.46	12.54	27500.0
2001-12-31	EWM	ETF	20.12	20.8	20.12	20.8	19975.0
2001-12-31	EWN	ETF	17.08	17.14	16.97	16.97	2500.0
2001-12-31	EWO	ETF	7.3	7.3	7.28	7.28	5700.0
2001-12-31	EWP	ETF	20.69	20.81	20.59	20.66	8900.0
2001-12-31	EWQ	ETF	18.65	18.88	18.63	18.75	19600.0
2001-12-31	EWS	ETF	10.2	10.22	10.06	10.14	32050.0
2001-12-31	EWT	ETF	21.2	21.58	21.12	21.56	15100.0
2001-12-31	EWU	ETF	29.04	29.38	28.94	29.38	20900.0
2001-12-31	EWW	ETF	15.3	15.35	15.0	15.18	34900.0
2001-12-31	EWY	ETF	17.56	17.87	17.5	17.71	15500.0
2001-12-31	EWZ	ETF	12.72	12.76	12.7	12.7	9100.0
2001-12-31	EZU	ETF	27.875	28.1	27.855	27.995	91000.0
2001-12-31	FCTR	ETF	17.6	18.03	16.73	16.91	31300.0
2001-12-31	FMAR	ETF	9.16	9.4	9.16	9.16	3800.0
2001-12-31	GLDB	ETF	7.2	7.35	7.05	7.11	94100.0
2001-12-31	GRNB	ETF	15.7065	15.7065	15.7065	15.7065	8276.0
2001-12-31	GSIG	ETF	8.6	8.6	7.99	8.47	212700.0
2001-12-31	IBB	ETF	31.0833	31.1	30.3333	30.35	1073100.0
2001-12-31	ICF	ETF	21.15	21.32	21.06	21.075	120000.0
2001-12-31	IDU	ETF	32.125	32.48	31.755	31.985	1141200.0
2001-12-31	IEV	ETF	29.45	29.775	29.45	29.545	153000.0
2001-12-31	IGE	ETF	15.9333	15.9333	15.9333	15.9333	6000.0
2001-12-31	IGLD	ETF	89.0	95.0	89.0	95.0	506.0
2001-12-31	IGM	ETF	8.5667	8.6067	8.4483	8.4483	55800.0
2001-12-31	IGN	ETF	30.7	31.19	30.57	30.7	516000.0
2001-12-31	IGV	ETF	9.28	9.282	9.102	9.102	20000.0
2001-12-31	IJH	ETF	10.26	10.262	10.115	10.115	481000.0
2001-12-31	IJJ	ETF	22.725	22.7775	22.45	22.62	109200.0

> showing 50 of 117 rows — these rows as CSV

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