PREVIEW / etf_daily / 2001-10-18

all etf daily files

  file:    by_date/etf_daily/2001/2001-10-18.parquet
  size:    9 KB
  rows:    106

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-10-18	SPY	ETF	107.82	108.16	106.75	107.42	16510000.0
2001-10-18	QQQ	ETF	32.7	33.54	32.4	33.33	94448300.0
2001-10-18	IWM	ETF	42.275	42.275	41.65	41.78	969400.0
2001-10-18	DIA	ETF	92.25	92.57	91.45	91.99	2821400.0
2001-10-18	ARB	ETF	27.42	27.66	27.33	27.47	19000.0
2001-10-18	BBH	ETF	38.8333	39.3133	38.5833	39.2333	3344400.0
2001-10-18	BITS	ETF	14.8	16.64	14.2	16.0	18975.0
2001-10-18	CEF	ETF	3.49	3.49	3.42	3.42	18300.0
2001-10-18	CHB	ETF	7.8	7.8	7.05	7.1	95200.0
2001-10-18	CNXT	ETF	9.07	9.99	9.02	9.75	4225940.0
2001-10-18	DGT	ETF	63.9	63.9	63.3	63.3	500.0
2001-10-18	EFA	ETF	38.7667	38.8667	38.3333	38.65	260700.0
2001-10-18	EWA	ETF	8.85	8.85	8.75	8.78	5700.0
2001-10-18	EWC	ETF	9.7	9.85	9.66	9.85	1900.0
2001-10-18	EWD	ETF	11.98	11.98	11.98	11.98	200.0
2001-10-18	EWG	ETF	13.25	13.36	13.19	13.19	28300.0
2001-10-18	EWH	ETF	7.91	7.91	7.81	7.87	679900.0
2001-10-18	EWI	ETF	31.58	31.6	31.5	31.6	1850.0
2001-10-18	EWJ	ETF	34.24	34.4	34.0	34.2	48825.0
2001-10-18	EWK	ETF	10.41	10.41	10.41	10.41	1600.0
2001-10-18	EWL	ETF	12.1	12.25	12.06	12.25	20900.0
2001-10-18	EWM	ETF	18.08	18.28	17.92	17.92	4775.0
2001-10-18	EWO	ETF	7.22	7.22	7.22	7.22	200.0
2001-10-18	EWP	ETF	19.5	19.5	19.35	19.45	5100.0
2001-10-18	EWQ	ETF	17.85	17.94	17.7	17.93	23600.0
2001-10-18	EWS	ETF	9.1	9.14	8.98	9.0	7350.0
2001-10-18	EWT	ETF	15.24	15.24	14.84	14.84	700.0
2001-10-18	EWU	ETF	28.5	28.94	28.5	28.82	4550.0
2001-10-18	EWW	ETF	13.45	13.45	13.24	13.29	13900.0
2001-10-18	EWY	ETF	12.36	12.43	12.36	12.43	1000.0
2001-10-18	EWZ	ETF	9.5	9.5	9.49	9.49	1400.0
2001-10-18	EZU	ETF	25.91	25.91	25.655	25.79	5800.0
2001-10-18	FCTR	ETF	17.0	17.65	16.8	17.65	80800.0
2001-10-18	FMAR	ETF	7.95	8.1	7.95	8.0	20100.0
2001-10-18	GLDB	ETF	7.2	7.64	7.2	7.4	55500.0
2001-10-18	GSIG	ETF	7.22	7.34	7.22	7.27	21600.0
2001-10-18	IBB	ETF	26.75	27.4467	26.7	27.2667	643500.0
2001-10-18	ICF	ETF	20.4375	20.4375	20.2025	20.24	60000.0
2001-10-18	IDU	ETF	34.31	34.36	33.75	33.75	15200.0
2001-10-18	IEV	ETF	27.9	28.14	27.825	28.04	48000.0
2001-10-18	IGLD	ETF	69.0	77.0	69.0	77.0	146.0
2001-10-18	IGM	ETF	7.1333	7.2	7.1083	7.2	22800.0
2001-10-18	IGN	ETF	28.75	29.14	28.55	28.6	5200.0
2001-10-18	IGV	ETF	7.15	7.26	7.15	7.16	12500.0
2001-10-18	IJH	ETF	8.895	8.939	8.836	8.853	439000.0
2001-10-18	IJJ	ETF	20.275	20.275	19.95	19.95	42400.0
2001-10-18	IJK	ETF	12.1875	12.2675	12.1625	12.1625	83200.0
2001-10-18	IJR	ETF	16.5867	16.6517	16.4467	16.4667	111000.0
2001-10-18	IJS	ETF	18.4	18.43	18.26	18.3075	52400.0
2001-10-18	IJT	ETF	16.78	16.9375	16.685	16.685	51600.0

> showing 50 of 106 rows — these rows as CSV

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