PREVIEW / etf_daily / 2001-12-27

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-27.parquet
  size:    9 KB
  rows:    118

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-27	SPY	ETF	115.3	116.08	115.25	116.06	9407300.0
2001-12-27	QQQ	ETF	39.85	40.202	39.6	40.01	34255200.0
2001-12-27	IWM	ETF	48.75	49.075	48.73	48.95	1705200.0
2001-12-27	DIA	ETF	101.12	101.55	100.89	101.49	1850300.0
2001-12-27	ARB	ETF	33.2	33.9	33.19	33.5	162000.0
2001-12-27	BBH	ETF	44.9967	45.2333	44.6167	44.8533	2307000.0
2001-12-27	BITS	ETF	25.8	27.6	25.8	27.6	3400.0
2001-12-27	CEF	ETF	3.4	3.49	3.38	3.47	16000.0
2001-12-27	CHB	ETF	12.62	12.62	12.25	12.52	106100.0
2001-12-27	CNXT	ETF	13.51	14.13	13.5	14.04	4263000.0
2001-12-27	CSB	ETF	3.84999990463257	3.84999990463257	3.84999990463257	3.84999990463257	1000.0
2001-12-27	DGT	ETF	66.85	66.93	66.82	66.93	500.0
2001-12-27	EFA	ETF	39.3333	39.5333	39.2833	39.4667	418500.0
2001-12-27	ELV	ETF	23.175	23.65	23.175	23.45	962700.0
2001-12-27	EPP	ETF	17.9767	18.0133	17.9767	18.0133	3600.0
2001-12-27	EWA	ETF	9.25	9.39	9.25	9.26	10900.0
2001-12-27	EWC	ETF	10.8	10.8	10.55	10.55	22000.0
2001-12-27	EWD	ETF	13.49	13.58	13.49	13.58	7100.0
2001-12-27	EWG	ETF	14.57	14.74	14.57	14.61	115100.0
2001-12-27	EWH	ETF	9.23	9.35	9.21	9.21	31100.0
2001-12-27	EWI	ETF	31.8	32.2	31.76	32.0	6050.0
2001-12-27	EWJ	ETF	30.8	30.92	30.6	30.68	143850.0
2001-12-27	EWK	ETF	11.0	11.0	10.99	10.99	4000.0
2001-12-27	EWL	ETF	12.32	12.51	12.31	12.45	21100.0
2001-12-27	EWM	ETF	19.92	19.92	19.6	19.6	2400.0
2001-12-27	EWN	ETF	16.84	16.95	16.76	16.93	16200.0
2001-12-27	EWO	ETF	7.34	7.34	7.34	7.34	6000.0
2001-12-27	EWP	ETF	20.69	20.8	20.69	20.8	7000.0
2001-12-27	EWQ	ETF	18.3	18.55	18.3	18.53	35600.0
2001-12-27	EWS	ETF	9.88	10.1	9.88	10.1	30600.0
2001-12-27	EWT	ETF	20.8	20.98	20.54	20.98	5750.0
2001-12-27	EWU	ETF	29.08	29.36	29.02	29.02	30150.0
2001-12-27	EWW	ETF	15.35	15.4	15.17	15.32	17700.0
2001-12-27	EWY	ETF	16.6	16.94	16.6	16.89	9400.0
2001-12-27	EWZ	ETF	12.58	12.6	12.48	12.6	22200.0
2001-12-27	EZU	ETF	27.525	27.665	27.375	27.655	22200.0
2001-12-27	FCTR	ETF	18.46	18.5	17.51	17.78	24200.0
2001-12-27	FMAR	ETF	8.87	9.1	8.87	9.1	17000.0
2001-12-27	GLDB	ETF	7.21	7.35	7.16	7.25	24600.0
2001-12-27	GSIG	ETF	8.0	8.5	8.0	8.5	60900.0
2001-12-27	IBB	ETF	31.2	31.2167	30.8833	31.05	211200.0
2001-12-27	ICF	ETF	21.1075	21.2175	21.0625	21.09	128800.0
2001-12-27	IDU	ETF	31.5	31.745	31.485	31.745	108800.0
2001-12-27	IEV	ETF	29.1	29.465	29.1	29.465	37000.0
2001-12-27	IGLD	ETF	89.0	91.0	89.0	91.0	283.0
2001-12-27	IGM	ETF	8.4167	8.5567	8.4167	8.5283	1027800.0
2001-12-27	IGN	ETF	30.25	30.5	30.2	30.45	320000.0
2001-12-27	IGV	ETF	9.156	9.158	9.01	9.08	87000.0
2001-12-27	IJH	ETF	10.165	10.221	10.164	10.209	556000.0
2001-12-27	IJJ	ETF	22.55	22.6625	22.55	22.6425	37200.0

> showing 50 of 118 rows — these rows as CSV

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