PREVIEW / etf_daily / 2001-12-18

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-18.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-18	SPY	ETF	114.63	115.15	114.34	114.98	13663700.0
2001-12-18	QQQ	ETF	41.16	41.5	40.16	41.26	50850400.0
2001-12-18	IWM	ETF	48.25	48.325	47.815	48.275	1727800.0
2001-12-18	DIA	ETF	99.86	100.4	99.61	100.4	1557500.0
2001-12-18	ARB	ETF	31.0	32.19	31.0	32.19	188500.0
2001-12-18	BBH	ETF	44.75	45.0967	44.5167	44.96	1747500.0
2001-12-18	BITS	ETF	26.12	26.6	23.36	25.4	16775.0
2001-12-18	CEF	ETF	3.44	3.44	3.37	3.37	20100.0
2001-12-18	CHB	ETF	12.9	13.05	12.67	12.8	448300.0
2001-12-18	CNXT	ETF	16.94	17.4	15.81	16.23	7069800.0
2001-12-18	DGT	ETF	66.64	66.64	66.36	66.36	600.0
2001-12-18	EFA	ETF	39.6167	39.7333	39.4733	39.5633	908400.0
2001-12-18	ELV	ETF	24.75	24.8	24.61	24.65	404600.0
2001-12-18	EPP	ETF	17.88	17.9133	17.88	17.9	91500.0
2001-12-18	EWA	ETF	9.2	9.29	9.1	9.15	27300.0
2001-12-18	EWC	ETF	10.98	10.98	10.75	10.75	8200.0
2001-12-18	EWD	ETF	13.75	13.78	13.56	13.61	3100.0
2001-12-18	EWG	ETF	14.95	14.95	14.75	14.8	72600.0
2001-12-18	EWH	ETF	9.25	9.39	9.22	9.22	32900.0
2001-12-18	EWI	ETF	32.22	32.58	32.2	32.22	2100.0
2001-12-18	EWJ	ETF	31.4	31.44	31.12	31.4	326925.0
2001-12-18	EWK	ETF	10.47	10.47	10.47	10.47	200.0
2001-12-18	EWL	ETF	12.37	12.55	12.36	12.55	4900.0
2001-12-18	EWM	ETF	19.4	19.4	19.4	19.4	5400.0
2001-12-18	EWN	ETF	16.79	16.79	16.46	16.51	1100.0
2001-12-18	EWO	ETF	7.4	7.47	7.4	7.47	2000.0
2001-12-18	EWP	ETF	21.48	21.48	21.11	21.11	2200.0
2001-12-18	EWQ	ETF	18.35	18.45	18.3	18.32	13200.0
2001-12-18	EWS	ETF	10.06	10.18	9.96	10.1	87900.0
2001-12-18	EWT	ETF	21.2	21.2	20.78	20.88	60050.0
2001-12-18	EWU	ETF	29.6	29.68	29.36	29.58	62150.0
2001-12-18	EWW	ETF	14.87	15.09	14.87	15.0	19500.0
2001-12-18	EWY	ETF	16.56	16.85	16.56	16.85	22000.0
2001-12-18	EWZ	ETF	11.96	12.15	11.96	12.15	11100.0
2001-12-18	EZU	ETF	27.5	27.805	27.45	27.65	40000.0
2001-12-18	FCTR	ETF	18.1	18.38	17.8	18.2	30900.0
2001-12-18	FMAR	ETF	8.745	8.895	8.705	8.745	37200.0
2001-12-18	GLDB	ETF	7.35	7.35	7.22	7.29	52200.0
2001-12-18	GRNB	ETF	17.179	17.179	17.179	17.179	1211.0
2001-12-18	GSIG	ETF	7.6	7.99	7.6	7.92	82500.0
2001-12-18	IBB	ETF	31.1667	31.25	30.8	31.1667	781500.0
2001-12-18	ICF	ETF	21.045	21.06	20.8775	20.8775	7600.0
2001-12-18	IDU	ETF	29.89	30.325	29.785	30.315	220200.0
2001-12-18	IEV	ETF	29.4	29.535	29.22	29.36	176800.0
2001-12-18	IGE	ETF	15.0083	15.135	15.0083	15.135	7800.0
2001-12-18	IGLD	ETF	90.0	90.0	86.5	90.0	200.0
2001-12-18	IGM	ETF	8.75	8.825	8.7333	8.7867	42000.0
2001-12-18	IGN	ETF	31.85	31.85	31.4	31.66	907600.0
2001-12-18	IGV	ETF	9.39	9.514	9.39	9.514	77000.0
2001-12-18	IJH	ETF	9.977	10.063	9.97	10.058	1267000.0

> showing 50 of 117 rows — these rows as CSV

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