PREVIEW / etf_daily / 2001-07-31

all etf daily files

  file:    by_date/etf_daily/2001/2001-07-31.parquet
  size:    9 KB
  rows:    100

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-07-31	SPY	ETF	121.0	122.68	120.8	121.35	11918100.0
2001-07-31	QQQ	ETF	41.84	42.78	41.5	41.76	55732500.0
2001-07-31	IWM	ETF	48.295	48.835	48.06	48.115	652200.0
2001-07-31	DIA	ETF	104.25	106.05	104.16	105.03	2736600.0
2001-07-31	BBH	ETF	39.8333	40.8067	39.8	40.0567	1828800.0
2001-07-31	BITS	ETF	16.96	19.04	16.36	18.4	27675.0
2001-07-31	CEF	ETF	3.1	3.1	3.05	3.06	25600.0
2001-07-31	CHB	ETF	10.89	11.04	10.75	10.8	169700.0
2001-07-31	CNXT	ETF	9.12	9.891	9.12	9.51	3029210.0
2001-07-31	CSB	ETF	2.20000004768372	2.45000004768372	2.20000004768372	2.45000004768372	10000.0
2001-07-31	DGT	ETF	69.8	69.95	69.55	69.75	10800.0
2001-07-31	EWA	ETF	9.28	9.35	9.19	9.35	39400.0
2001-07-31	EWC	ETF	11.2	11.55	11.2	11.36	41500.0
2001-07-31	EWD	ETF	13.9	13.9	13.9	13.9	300.0
2001-07-31	EWG	ETF	16.35	16.59	16.35	16.44	63500.0
2001-07-31	EWH	ETF	9.63	9.87	9.61	9.8	27000.0
2001-07-31	EWI	ETF	36.3	36.7	36.12	36.7	10050.0
2001-07-31	EWJ	ETF	37.56	37.76	37.4	37.6	81025.0
2001-07-31	EWK	ETF	11.75	11.75	11.75	11.75	200.0
2001-07-31	EWL	ETF	13.25	13.4	13.1	13.1	52200.0
2001-07-31	EWM	ETF	19.32	19.4	19.0	19.0	13250.0
2001-07-31	EWN	ETF	18.99	19.35	18.99	19.35	20800.0
2001-07-31	EWO	ETF	8.27	8.27	8.18	8.18	3000.0
2001-07-31	EWP	ETF	20.75	21.04	20.75	21.04	1900.0
2001-07-31	EWQ	ETF	19.99	20.2	19.94	20.06	52600.0
2001-07-31	EWS	ETF	10.48	10.62	10.48	10.52	22000.0
2001-07-31	EWT	ETF	17.2	17.78	17.2	17.6	2300.0
2001-07-31	EWU	ETF	30.98	31.48	30.6	31.1	64800.0
2001-07-31	EWW	ETF	15.9	16.1	15.8	15.91	23600.0
2001-07-31	EWY	ETF	13.1	13.12	13.06	13.1	56400.0
2001-07-31	EWZ	ETF	13.19	13.19	12.7	12.7	2800.0
2001-07-31	EZU	ETF	30.095	30.185	29.805	29.95	19200.0
2001-07-31	FCTR	ETF	18.31	18.5	17.85	18.11	36800.0
2001-07-31	FMAR	ETF	9.06	9.55	9.06	9.5	14200.0
2001-07-31	GLDB	ETF	7.79	7.88	7.61	7.61	56400.0
2001-07-31	GSIG	ETF	7.39	7.95	7.39	7.95	64200.0
2001-07-31	IBB	ETF	28.9333	29.5333	28.9333	29.0	921600.0
2001-07-31	ICF	ETF	20.75	20.8025	20.75	20.8025	1600.0
2001-07-31	IDU	ETF	37.575	37.575	37.31	37.31	6000.0
2001-07-31	IEV	ETF	30.89	31.4	30.89	31.4	68600.0
2001-07-31	IGLD	ETF	67.0	70.0	66.0	66.0	47.0
2001-07-31	IGM	ETF	9.1217	9.2417	9.1217	9.2033	2268000.0
2001-07-31	IGV	ETF	9.738	9.86	9.738	9.86	26000.0
2001-07-31	IJH	ETF	10.205	10.291	10.172	10.172	158000.0
2001-07-31	IJJ	ETF	22.725	22.9425	22.725	22.82	168400.0
2001-07-31	IJK	ETF	14.2975	14.315	14.1588	14.1588	6400.0
2001-07-31	IJR	ETF	18.8967	19.07	18.8033	18.875	583800.0
2001-07-31	IJS	ETF	21.15	21.375	21.0875	21.0875	334000.0
2001-07-31	IJT	ETF	18.995	19.1325	18.8275	18.9	198400.0
2001-07-31	IOO	ETF	30.495	30.87	30.495	30.58	34200.0

> showing 50 of 100 rows — these rows as CSV

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