PREVIEW / etf_daily / 2001-12-28

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-28.parquet
  size:    9 KB
  rows:    119

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-28	SPY	ETF	116.29	116.75	115.92	116.0	10593800.0
2001-12-28	QQQ	ETF	40.292	40.802	40.23	40.33	38254000.0
2001-12-28	IWM	ETF	49.15	49.265	48.875	49.0	2017600.0
2001-12-28	DIA	ETF	101.7	101.94	101.13	101.16	1401100.0
2001-12-28	ARB	ETF	33.5	34.0	33.35	33.74	28500.0
2001-12-28	BBH	ETF	45.1	45.7867	45.1	45.6467	2056800.0
2001-12-28	BITS	ETF	27.56	28.0	24.36	25.404	8700.0
2001-12-28	CEF	ETF	3.45	3.45	3.26	3.28	45600.0
2001-12-28	CHB	ETF	12.62	12.75	12.25	12.35	197000.0
2001-12-28	CNXT	ETF	14.26	14.58	14.24	14.52	5536130.0
2001-12-28	CSB	ETF	3.59999990463257	3.84999990463257	3.59999990463257	3.84999990463257	4300.0
2001-12-28	DGT	ETF	67.25	67.25	67.14	67.14	300.0
2001-12-28	EFA	ETF	39.7	39.8267	39.6667	39.78	1309200.0
2001-12-28	ELV	ETF	23.475	24.25	23.475	24.25	857400.0
2001-12-28	EPP	ETF	18.16	18.16	18.16	18.16	11700.0
2001-12-28	EWA	ETF	9.31	9.41	9.31	9.41	7800.0
2001-12-28	EWC	ETF	10.8	10.8	10.7	10.71	3600.0
2001-12-28	EWD	ETF	13.59	13.79	13.59	13.79	2500.0
2001-12-28	EWG	ETF	14.81	14.89	14.8	14.8	146400.0
2001-12-28	EWH	ETF	9.15	9.28	9.14	9.26	24600.0
2001-12-28	EWI	ETF	32.0	32.02	32.0	32.0	1150.0
2001-12-28	EWJ	ETF	31.48	31.56	31.24	31.4	312625.0
2001-12-28	EWK	ETF	11.0	11.0	11.0	11.0	200.0
2001-12-28	EWL	ETF	12.26	12.54	12.26	12.54	9800.0
2001-12-28	EWM	ETF	19.92	20.2	19.92	20.04	9125.0
2001-12-28	EWN	ETF	16.7	16.81	16.7	16.81	5400.0
2001-12-28	EWO	ETF	7.33	7.33	7.26	7.26	6900.0
2001-12-28	EWP	ETF	20.52	20.69	20.52	20.69	1700.0
2001-12-28	EWQ	ETF	18.4	18.55	18.4	18.5	56900.0
2001-12-28	EWS	ETF	10.0	10.22	10.0	10.02	13100.0
2001-12-28	EWT	ETF	20.98	21.1	20.8	21.1	12050.0
2001-12-28	EWU	ETF	29.02	29.34	29.02	29.3	18500.0
2001-12-28	EWW	ETF	15.07	15.44	15.07	15.44	4700.0
2001-12-28	EWY	ETF	17.25	17.39	17.25	17.36	30100.0
2001-12-28	EWZ	ETF	12.97	12.97	12.77	12.77	27700.0
2001-12-28	EZU	ETF	27.675	27.865	27.64	27.685	6600.0
2001-12-28	FCTR	ETF	17.67	17.86	17.5	17.6	38000.0
2001-12-28	FMAR	ETF	9.3	9.43	9.0	9.4	10300.0
2001-12-28	GLDB	ETF	7.3	7.35	7.15	7.15	34500.0
2001-12-28	GSIG	ETF	8.14	8.61	8.14	8.56	132300.0
2001-12-28	IBB	ETF	31.3	31.55	31.1667	31.3867	411600.0
2001-12-28	ICF	ETF	21.025	21.175	21.0	21.15	227200.0
2001-12-28	IDU	ETF	31.7	31.95	31.45	31.95	198000.0
2001-12-28	IEV	ETF	29.275	29.635	29.275	29.56	61000.0
2001-12-28	IGE	ETF	16.06	16.06	16.06	16.06	600.0
2001-12-28	IGLD	ETF	89.0	91.0	88.0	89.0	225.0
2001-12-28	IGM	ETF	8.625	8.6483	8.5533	8.5667	166200.0
2001-12-28	IGN	ETF	30.55	30.96	30.55	30.67	229900.0
2001-12-28	IGV	ETF	9.24	9.28	9.206	9.26	275000.0
2001-12-28	IJH	ETF	10.242	10.279	10.237	10.24	463000.0

> showing 50 of 119 rows — these rows as CSV

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