PREVIEW / etf_daily / 2003-07-31

all etf daily files

  file:    by_date/etf_daily/2003/2003-07-31.parquet
  size:    10 KB
  rows:    131

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
2003-07-31	SPY	ETF	99.98	100.91	99.17	99.39	54937200.0
2003-07-31	QQQ	ETF	31.79	32.33	31.52	31.8	85700300.0
2003-07-31	IWM	ETF	47.5	47.87	47.235	47.34	5324600.0
2003-07-31	DIA	ETF	92.91	93.77	92.3	92.47	10218800.0
2003-07-31	TLT	ETF	83.69	83.71	82.23	82.95	4706400.0
2003-07-31	AAA	ETF	61.75	61.75	61.75	61.75	500.0
2003-07-31	ADRE	ETF	57.1	64.5	57.1	64.5	600.0
2003-07-31	ARB	ETF	37.15	37.95	36.8	37.2	163200.0
2003-07-31	BBH	ETF	45.0167	45.6667	44.72	44.99	2015700.0
2003-07-31	BITS	ETF	11.644	12.0	11.6	12.0	1875.0
2003-07-31	CEF	ETF	4.54	4.59	4.52	4.59	105200.0
2003-07-31	CHB	ETF	5.95	6.5	5.79	6.48	983700.0
2003-07-31	CNXT	ETF	5.0	5.16	4.9	4.91	2742520.0
2003-07-31	CSB	ETF	17.3999996185303	17.3999996185303	17.3999996185303	17.3999996185303	2400.0
2003-07-31	DGT	ETF	54.64	55.19	54.45	54.45	9400.0
2003-07-31	EEM	ETF	14.0333	14.1211	14.0333	14.0778	339300.0
2003-07-31	EFA	ETF	37.0967	37.2167	36.5867	36.65	3659400.0
2003-07-31	ELV	ETF	39.49	39.49	36.916	37.755	3945300.0
2003-07-31	EPP	ETF	20.16	20.2767	20.02	20.1	234000.0
2003-07-31	EWA	ETF	10.96	11.13	10.96	10.96	256500.0
2003-07-31	EWC	ETF	11.56	11.66	11.56	11.66	8684900.0
2003-07-31	EWD	ETF	12.47	12.48	12.19	12.19	14100.0
2003-07-31	EWG	ETF	12.81	12.81	12.62	12.7	5100.0
2003-07-31	EWH	ETF	8.11	8.18	8.06	8.15	258500.0
2003-07-31	EWI	ETF	34.64	34.64	34.48	34.48	7050.0
2003-07-31	EWJ	ETF	30.6	30.6	30.28	30.4	1049425.0
2003-07-31	EWK	ETF	11.06	11.26	11.06	11.26	800.0
2003-07-31	EWL	ETF	12.16	12.23	12.09	12.09	3500.0
2003-07-31	EWM	ETF	23.6	23.96	23.56	23.6	8625.0
2003-07-31	EWN	ETF	14.04	14.04	13.81	13.94	7600.0
2003-07-31	EWP	ETF	22.77	22.82	22.71	22.74	6000.0
2003-07-31	EWQ	ETF	16.86	16.86	16.75	16.83	5700.0
2003-07-31	EWS	ETF	10.4	10.8	10.38	10.54	13300.0
2003-07-31	EWT	ETF	20.12	20.94	20.1	20.44	69800.0
2003-07-31	EWU	ETF	26.14	26.58	25.86	25.98	17300.0
2003-07-31	EWW	ETF	15.08	15.24	15.05	15.12	295800.0
2003-07-31	EWY	ETF	21.67	22.23	21.67	21.7	90500.0
2003-07-31	EWZ	ETF	10.96	10.99	10.86	10.92	1227000.0
2003-07-31	EZA	ETF	21.95	22.155	21.95	22.155	2400.0
2003-07-31	EZU	ETF	25.34	25.345	24.95	24.95	59600.0
2003-07-31	FCTR	ETF	18.685	18.85	18.41	18.5	33912.0
2003-07-31	FEZ	ETF	28.69	28.69	28.15	28.15	76100.0
2003-07-31	FMAR	ETF	14.955	14.985	14.855	14.945	11900.0
2003-07-31	GLDB	ETF	10.755	11.09	10.46	11.05	468431.0
2003-07-31	GRNB	ETF	25.366	25.3954	24.3157	25.2776	6964.0
2003-07-31	GSIG	ETF	8.2	8.86	8.2	8.79	28200.0
2003-07-31	IBB	ETF	24.45	24.7	24.22	24.3833	1930200.0
2003-07-31	ICF	ETF	23.9	24.0	23.7175	23.8825	147600.0
2003-07-31	IDU	ETF	25.725	25.83	25.505	25.64	42200.0
2003-07-31	IEF	ETF	83.5	83.72	82.7	83.38	241800.0

> showing 50 of 131 rows — these rows as CSV

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