PREVIEW / etf_daily / 2001-12-17

all etf daily files

  file:    by_date/etf_daily/2001/2001-12-17.parquet
  size:    9 KB
  rows:    111

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-17	SPY	ETF	112.99	114.36	112.9	114.3	13925900.0
2001-12-17	QQQ	ETF	40.02	41.24	40.02	40.8	62454400.0
2001-12-17	IWM	ETF	46.83	47.85	46.83	47.85	798800.0
2001-12-17	DIA	ETF	98.35	99.6	98.34	99.3	2430900.0
2001-12-17	ARB	ETF	31.0	31.06	30.5	31.0	185500.0
2001-12-17	BBH	ETF	43.1333	45.1333	43.1333	44.8833	5388000.0
2001-12-17	BITS	ETF	27.96	30.0	26.04	26.12	22400.0
2001-12-17	CEF	ETF	3.39	3.43	3.36	3.36	31100.0
2001-12-17	CHB	ETF	13.3	13.47	12.7	13.0	244900.0
2001-12-17	CNXT	ETF	16.69	17.7	16.07	16.57	15108400.0
2001-12-17	DGT	ETF	65.4	66.17	65.4	66.17	600.0
2001-12-17	EFA	ETF	39.1667	39.6167	39.15	39.4567	678300.0
2001-12-17	ELV	ETF	24.05	24.65	23.96	24.625	211100.0
2001-12-17	EWA	ETF	9.1	9.14	9.1	9.1	33300.0
2001-12-17	EWC	ETF	10.75	10.85	10.75	10.75	22800.0
2001-12-17	EWG	ETF	14.6	14.95	14.6	14.9	101000.0
2001-12-17	EWH	ETF	9.26	9.35	9.2	9.3	77000.0
2001-12-17	EWI	ETF	32.0	32.4	32.0	32.34	1000.0
2001-12-17	EWJ	ETF	31.16	31.36	30.92	31.16	136025.0
2001-12-17	EWK	ETF	10.63	10.63	10.63	10.63	100.0
2001-12-17	EWL	ETF	12.47	12.64	12.46	12.55	13200.0
2001-12-17	EWM	ETF	19.72	19.72	19.08	19.4	6075.0
2001-12-17	EWN	ETF	16.4	16.74	16.37	16.55	13400.0
2001-12-17	EWP	ETF	21.08	21.39	21.08	21.37	600.0
2001-12-17	EWQ	ETF	18.19	18.41	18.1	18.4	8700.0
2001-12-17	EWS	ETF	9.96	10.1	9.92	9.92	29000.0
2001-12-17	EWT	ETF	21.54	21.84	21.22	21.48	29200.0
2001-12-17	EWU	ETF	28.8	29.38	28.76	29.26	80050.0
2001-12-17	EWW	ETF	14.57	15.04	14.57	14.9	76700.0
2001-12-17	EWY	ETF	16.51	16.78	16.51	16.73	75300.0
2001-12-17	EWZ	ETF	11.82	12.0	11.82	11.99	8400.0
2001-12-17	EZU	ETF	27.4	27.75	27.4	27.7	17400.0
2001-12-17	FCTR	ETF	17.69	18.2	17.69	18.19	58100.0
2001-12-17	FMAR	ETF	8.34	8.87	8.34	8.75	117500.0
2001-12-17	GLDB	ETF	7.2302	7.35	7.2	7.3	56800.0
2001-12-17	GSIG	ETF	7.66	7.9	7.62	7.63	60000.0
2001-12-17	IBB	ETF	30.0	31.0	30.0	30.9667	293400.0
2001-12-17	ICF	ETF	20.9175	20.9375	20.835	20.9025	16800.0
2001-12-17	IDU	ETF	29.875	30.11	29.645	29.75	31800.0
2001-12-17	IEV	ETF	29.35	29.675	29.35	29.45	160600.0
2001-12-17	IGLD	ETF	97.0	97.0	87.0	90.0	104.0
2001-12-17	IGM	ETF	8.6167	8.7817	8.6167	8.7017	12600.0
2001-12-17	IGN	ETF	31.44	31.85	31.29	31.31	958600.0
2001-12-17	IGV	ETF	9.08	9.264	9.08	9.096	6023000.0
2001-12-17	IJH	ETF	9.85	9.95	9.831	9.927	377000.0
2001-12-17	IJJ	ETF	21.6625	21.9	21.6625	21.8175	341200.0
2001-12-17	IJK	ETF	13.9338	14.0525	13.9338	14.0362	385600.0
2001-12-17	IJR	ETF	18.4583	18.7317	18.415	18.7317	875400.0
2001-12-17	IJS	ETF	20.6875	21.0625	20.6575	21.0625	310400.0
2001-12-17	IJT	ETF	18.3625	18.67	18.3625	18.655	87200.0

> showing 50 of 111 rows — these rows as CSV

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