PREVIEW / etf_daily / 2001-09-19

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-19.parquet
  size:    9 KB
  rows:    108

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-09-19	SPY	ETF	104.1	104.5	98.56	101.95	42771800.0
2001-09-19	QQQ	ETF	30.64	31.0	28.26	29.97	116639300.0
2001-09-19	IWM	ETF	41.255	41.35	38.8	40.08	1636000.0
2001-09-19	DIA	ETF	89.43	89.8	84.9	87.47	9969500.0
2001-09-19	BBH	ETF	36.2833	36.33	34.0133	35.5	6782700.0
2001-09-19	BITS	ETF	10.6	11.28	10.4	11.16	2375.0
2001-09-19	CEF	ETF	3.39	3.65	3.31	3.65	211100.0
2001-09-19	CHB	ETF	7.6	7.72	6.75	7.02	175200.0
2001-09-19	CNXT	ETF	9.05	9.4	7.999	8.86	5191920.0
2001-09-19	CSB	ETF	3.09999990463257	3.09999990463257	3.0	3.0	131600.0
2001-09-19	DGT	ETF	60.9	60.9	59.05	60.1	1100.0
2001-09-19	EFA	ETF	37.2	37.2	36.2833	36.75	435600.0
2001-09-19	EWA	ETF	8.0	8.0	7.75	8.0	13000.0
2001-09-19	EWC	ETF	9.8	10.05	9.48	9.5	31500.0
2001-09-19	EWD	ETF	11.0	11.0	10.4	10.4	6500.0
2001-09-19	EWG	ETF	12.45	12.65	11.75	12.05	83400.0
2001-09-19	EWH	ETF	7.46	7.88	7.2	7.4	56600.0
2001-09-19	EWI	ETF	29.0	29.0	27.9	28.0	4200.0
2001-09-19	EWJ	ETF	33.96	34.2	32.4	33.84	193975.0
2001-09-19	EWK	ETF	10.2	10.4	10.15	10.15	800.0
2001-09-19	EWL	ETF	11.75	11.85	11.55	11.8	16200.0
2001-09-19	EWM	ETF	17.6	17.96	17.48	17.64	20475.0
2001-09-19	EWN	ETF	15.65	15.75	15.45	15.5	4700.0
2001-09-19	EWO	ETF	7.4	7.4	7.4	7.4	1200.0
2001-09-19	EWP	ETF	18.05	18.05	17.77	17.9	3600.0
2001-09-19	EWQ	ETF	16.75	16.95	16.35	16.55	24700.0
2001-09-19	EWS	ETF	8.6	9.1	8.34	8.56	28500.0
2001-09-19	EWT	ETF	14.92	15.16	14.86	14.98	35200.0
2001-09-19	EWU	ETF	26.9	27.4	26.5	27.22	40450.0
2001-09-19	EWW	ETF	12.35	12.65	12.15	12.15	34900.0
2001-09-19	EWY	ETF	11.75	11.75	11.2	11.56	12600.0
2001-09-19	EWZ	ETF	9.35	9.37	9.33	9.33	2300.0
2001-09-19	EZU	ETF	24.25	24.5	23.575	24.0	15600.0
2001-09-19	FCTR	ETF	16.05	16.85	16.05	16.5	35300.0
2001-09-19	FMAR	ETF	8.5	8.5	8.19	8.5	3800.0
2001-09-19	GLDB	ETF	7.48	7.5	7.31	7.4	186300.0
2001-09-19	GSIG	ETF	7.03	7.05	6.11	6.36	285900.0
2001-09-19	IBB	ETF	24.5833	24.5833	22.7	23.8333	500100.0
2001-09-19	ICF	ETF	20.9	20.9	20.25	20.5625	182800.0
2001-09-19	IDU	ETF	34.85	35.0	33.7	34.0	12200.0
2001-09-19	IEV	ETF	26.8	26.8	25.815	26.35	89600.0
2001-09-19	IGLD	ETF	70.0	70.0	67.0	70.0	43.0
2001-09-19	IGM	ETF	6.6333	6.6333	6.2083	6.5083	154800.0
2001-09-19	IGN	ETF	24.66	25.45	24.11	25.45	1600.0
2001-09-19	IGV	ETF	6.2	6.2	6.2	6.2	500.0
2001-09-19	IJH	ETF	8.8	8.8	8.331	8.465	188000.0
2001-09-19	IJJ	ETF	20.075	20.1375	19.2125	19.6775	170400.0
2001-09-19	IJK	ETF	11.8188	11.8188	11.1375	11.5875	666400.0
2001-09-19	IJR	ETF	16.2167	16.2667	15.4	15.8583	1742400.0
2001-09-19	IJS	ETF	18.35	18.4725	17.5275	17.925	178000.0

> showing 50 of 108 rows — these rows as CSV

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