PREVIEW / etf_daily / 2000-07-31

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-31.parquet
  size:    8 KB
  rows:    80

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
2000-07-31	SPY	ETF	142.9375	144.125	142.0625	143.0	5265500.0
2000-07-31	QQQ	ETF	87.625	90.125	85.7188	89.4375	27609900.0
2000-07-31	IWM	ETF	49.25	50.25	48.6875	50.25	166400.0
2000-07-31	DIA	ETF	105.4375	106.0	104.875	105.0	352300.0
2000-07-31	BBH	ETF	56.3333	56.8958	54.5208	56.1667	2433900.0
2000-07-31	BITS	ETF	14.75	17.0	14.5	15.5	15575.0
2000-07-31	CEF	ETF	3.3125	3.3125	3.3125	3.3125	4800.0
2000-07-31	CHB	ETF	5.38	5.5	5.31	5.44	69200.0
2000-07-31	CNXT	ETF	32.94	33.13	30.5	32.0	2975790.0
2000-07-31	EWA	ETF	10.25	10.25	10.125	10.125	2500.0
2000-07-31	EWC	ETF	20.3125	20.625	20.125	20.5	48800.0
2000-07-31	EWD	ETF	30.0	30.0	29.875	29.875	1400.0
2000-07-31	EWG	ETF	24.125	24.3125	23.9375	24.1875	32500.0
2000-07-31	EWH	ETF	13.25	13.25	13.0	13.1875	49900.0
2000-07-31	EWI	ETF	50.0	50.0	50.0	50.0	450.0
2000-07-31	EWJ	ETF	53.75	54.25	53.5	54.0	87050.0
2000-07-31	EWK	ETF	14.0	14.0625	13.8125	14.0625	5800.0
2000-07-31	EWL	ETF	16.0	16.25	16.0	16.0	700.0
2000-07-31	EWM	ETF	24.0	24.5	24.0	24.0	6000.0
2000-07-31	EWN	ETF	24.0625	24.0625	24.0625	24.0625	800.0
2000-07-31	EWO	ETF	7.9375	8.0	7.875	8.0	1500.0
2000-07-31	EWP	ETF	25.3125	25.6875	25.1875	25.6875	2000.0
2000-07-31	EWQ	ETF	28.125	28.4375	27.875	28.25	65100.0
2000-07-31	EWS	ETF	14.75	15.0	14.625	14.875	62450.0
2000-07-31	EWU	ETF	38.0	38.625	38.0	38.375	3850.0
2000-07-31	EWW	ETF	16.375	16.5625	16.0	16.375	28700.0
2000-07-31	EWY	ETF	18.5	18.5	18.25	18.4375	7500.0
2000-07-31	EWZ	ETF	19.3125	19.375	19.3125	19.375	200.0
2000-07-31	EZU	ETF	38.7188	39.25	38.7188	39.25	2600.0
2000-07-31	FCTR	ETF	14.5	14.5625	14.375	14.5625	25400.0
2000-07-31	FMAR	ETF	5.0	5.25	5.0	5.25	1600.0
2000-07-31	GLDB	ETF	4.6875	4.875	4.625	4.875	115100.0
2000-07-31	GSIG	ETF	23.87	29.5	23.37	27.37	1450700.0
2000-07-31	IDU	ETF	35.3594	35.4688	35.125	35.125	2800.0
2000-07-31	IEV	ETF	38.5312	39.0312	38.375	39.0312	26000.0
2000-07-31	IGLD	ETF	737.5	762.5	712.5	725.0	171.0
2000-07-31	IJH	ETF	9.7375	9.7875	9.7375	9.7875	11000.0
2000-07-31	IJJ	ETF	18.0469	18.1211	18.0469	18.1211	6400.0
2000-07-31	IJK	ETF	16.1406	16.2676	16.0	16.2676	32000.0
2000-07-31	IJR	ETF	16.7813	17.0573	16.6771	17.0573	29400.0
2000-07-31	IJS	ETF	16.7344	16.8828	16.7344	16.8828	9200.0
2000-07-31	IJT	ETF	19.4531	19.6992	19.4531	19.6992	6800.0
2000-07-31	IUSG	ETF	32.8672	32.8672	32.8125	32.8125	1800.0
2000-07-31	IVE	ETF	59.1875	59.5938	59.0938	59.2969	30200.0
2000-07-31	IVV	ETF	142.9375	143.9531	142.4062	142.9375	332900.0
2000-07-31	IVW	ETF	21.6016	21.8125	21.4766	21.6289	111200.0
2000-07-31	IWB	ETF	75.0	75.75	75.0	75.75	2000.0
2000-07-31	IWD	ETF	54.75	54.9219	54.5938	54.7344	10100.0
2000-07-31	IWF	ETF	20.71095	20.917975	20.46875	20.78515	80000.0
2000-07-31	IWN	ETF	34.1146	34.3542	34.1146	34.3542	7500.0

> showing 50 of 80 rows — these rows as CSV

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