PREVIEW / etf_daily / 2001-09-24

all etf daily files

  file:    by_date/etf_daily/2001/2001-09-24.parquet
  size:    9 KB
  rows:    107

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-24	SPY	ETF	99.72	101.16	99.06	100.7	25549600.0
2001-09-24	QQQ	ETF	29.08	30.0	28.59	29.61	85696500.0
2001-09-24	IWM	ETF	38.25	39.29	38.25	39.0	1702800.0
2001-09-24	DIA	ETF	85.46	86.69	84.5	86.2	7953200.0
2001-09-24	BBH	ETF	35.5	35.6667	34.0333	34.1167	4497900.0
2001-09-24	BITS	ETF	10.84	11.2	10.0	10.88	108450.0
2001-09-24	CEF	ETF	3.7	3.7	3.55	3.55	53300.0
2001-09-24	CHB	ETF	6.5	7.9	6.5	7.51	232800.0
2001-09-24	CNXT	ETF	8.49	9.75	8.49	9.33	3870920.0
2001-09-24	DGT	ETF	56.25	59.03	56.25	59.03	2100.0
2001-09-24	EFA	ETF	35.3333	35.8167	35.1167	35.75	139500.0
2001-09-24	EWA	ETF	7.75	7.75	7.5	7.6	38200.0
2001-09-24	EWC	ETF	9.5	9.65	9.4	9.64	17600.0
2001-09-24	EWD	ETF	10.23	10.55	10.23	10.55	700.0
2001-09-24	EWG	ETF	11.5	11.89	11.5	11.76	57400.0
2001-09-24	EWH	ETF	7.25	7.49	7.25	7.37	107200.0
2001-09-24	EWI	ETF	26.2	27.1	26.2	26.7	2450.0
2001-09-24	EWJ	ETF	32.84	33.84	32.84	33.6	124825.0
2001-09-24	EWK	ETF	9.7	9.7	9.7	9.7	600.0
2001-09-24	EWL	ETF	10.9	11.4	10.9	11.4	6100.0
2001-09-24	EWM	ETF	16.6	17.4	16.6	17.04	7775.0
2001-09-24	EWN	ETF	14.3	14.55	14.3	14.55	7100.0
2001-09-24	EWO	ETF	7.2	7.25	7.15	7.15	4600.0
2001-09-24	EWP	ETF	17.1	17.3	17.1	17.25	21300.0
2001-09-24	EWQ	ETF	15.75	16.35	15.75	16.13	9900.0
2001-09-24	EWS	ETF	8.26	8.4	8.06	8.16	20750.0
2001-09-24	EWT	ETF	13.72	14.12	13.72	14.12	35850.0
2001-09-24	EWU	ETF	25.3	26.5	25.3	26.08	28050.0
2001-09-24	EWW	ETF	12.0	12.51	12.0	12.49	71200.0
2001-09-24	EWY	ETF	11.1	11.5	11.1	11.49	2900.0
2001-09-24	EWZ	ETF	9.1	9.24	9.1	9.1	2400.0
2001-09-24	EZU	ETF	23.05	23.225	22.825	23.05	14800.0
2001-09-24	FCTR	ETF	15.3	18.15	15.3	16.42	64800.0
2001-09-24	FMAR	ETF	7.6	7.75	7.35	7.5	6400.0
2001-09-24	GLDB	ETF	7.1	7.25	6.9	7.1113	67200.0
2001-09-24	GSIG	ETF	6.17	6.79	6.16	6.66	33600.0
2001-09-24	IBB	ETF	23.5333	23.7167	22.8733	23.0667	721800.0
2001-09-24	ICF	ETF	20.2625	20.45	19.8375	19.9375	90800.0
2001-09-24	IDU	ETF	33.975	34.05	33.79	33.79	7800.0
2001-09-24	IEV	ETF	24.7	25.635	24.675	25.405	89000.0
2001-09-24	IGLD	ETF	52.0	70.0	52.0	65.0	78.0
2001-09-24	IGM	ETF	6.375	6.5317	6.3167	6.5317	37200.0
2001-09-24	IGN	ETF	24.7	24.74	24.7	24.74	2000.0
2001-09-24	IGV	ETF	6.27	6.27	6.17	6.17	3000.0
2001-09-24	IJH	ETF	8.3	8.39	8.295	8.35	451000.0
2001-09-24	IJJ	ETF	18.775	19.225	18.775	19.075	115600.0
2001-09-24	IJK	ETF	11.1438	11.3562	11.1438	11.2812	181600.0
2001-09-24	IJR	ETF	15.3417	15.5583	15.2917	15.4833	2075400.0
2001-09-24	IJS	ETF	17.0	17.3825	17.0	17.315	191600.0
2001-09-24	IJT	ETF	15.4	15.64	15.4	15.625	57200.0

> showing 50 of 107 rows — these rows as CSV

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