PREVIEW / etf_daily / 2000-07-07

all etf daily files

  file:    by_date/etf_daily/2000/2000-07-07.parquet
  size:    7 KB
  rows:    70

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-07	SPY	ETF	146.6875	148.7812	146.25	148.0938	3034800.0
2000-07-07	QQQ	ETF	95.0	97.0	94.4375	95.9375	16603200.0
2000-07-07	IWM	ETF	52.4297	52.9531	52.4297	52.75	71800.0
2000-07-07	DIA	ETF	105.5625	106.75	105.1562	106.3281	634500.0
2000-07-07	BBH	ETF	64.1667	66.3125	63.7083	65.7292	2188800.0
2000-07-07	BITS	ETF	23.625	24.0	22.0	22.25	18175.0
2000-07-07	CEF	ETF	3.375	3.4375	3.375	3.4375	39700.0
2000-07-07	CHB	ETF	5.88	5.88	5.63	5.69	37000.0
2000-07-07	CNXT	ETF	48.19	51.0	47.31	48.5	3242940.0
2000-07-07	EWA	ETF	10.625	10.6875	10.625	10.6875	24400.0
2000-07-07	EWC	ETF	19.9375	20.0625	19.9375	20.0625	5400.0
2000-07-07	EWD	ETF	31.625	31.625	31.3125	31.3125	2200.0
2000-07-07	EWG	ETF	24.25	24.5	24.25	24.5	23300.0
2000-07-07	EWH	ETF	12.8125	13.1875	12.8125	13.1875	61400.0
2000-07-07	EWI	ETF	52.5	53.0	52.5	52.5	10850.0
2000-07-07	EWJ	ETF	60.25	60.5	60.0	60.5	57900.0
2000-07-07	EWK	ETF	13.5625	13.875	13.5625	13.875	6600.0
2000-07-07	EWL	ETF	16.25	16.5	16.25	16.4375	7800.0
2000-07-07	EWM	ETF	24.75	25.0	24.75	24.75	11200.0
2000-07-07	EWN	ETF	24.4375	24.9375	24.4375	24.9375	53000.0
2000-07-07	EWO	ETF	7.8125	7.9375	7.8125	7.8125	16600.0
2000-07-07	EWP	ETF	26.5	26.8125	26.5	26.8125	10400.0
2000-07-07	EWQ	ETF	28.9375	29.1875	28.9375	29.1875	16100.0
2000-07-07	EWS	ETF	15.125	15.75	15.0	15.5	42450.0
2000-07-07	EWT	ETF	37.5	37.75	37.5	37.625	18050.0
2000-07-07	EWU	ETF	38.875	39.625	38.875	39.625	17800.0
2000-07-07	EWW	ETF	17.5625	18.0625	17.5625	17.9375	46500.0
2000-07-07	EWY	ETF	21.75	22.0	21.6875	22.0	24400.0
2000-07-07	FCTR	ETF	16.5	16.75	15.75	15.875	26200.0
2000-07-07	FMAR	ETF	5.47	5.47	5.25	5.25	5700.0
2000-07-07	GLDB	ETF	5.0625	5.375	5.0	5.25	395500.0
2000-07-07	GSIG	ETF	36.87	37.5	36.5	37.25	629400.0
2000-07-07	IDU	ETF	33.9375	33.9375	33.9375	33.9375	600.0
2000-07-07	IGLD	ETF	828.125	843.75	800.0	800.0	149.0
2000-07-07	IJH	ETF	9.8719	9.9641	9.8719	9.9438	269000.0
2000-07-07	IJR	ETF	17.7995	18.0	17.7995	17.9766	54000.0
2000-07-07	IVE	ETF	59.4688	60.1406	59.4688	60.0312	28100.0
2000-07-07	IVV	ETF	146.375	148.5	146.375	147.9688	65500.0
2000-07-07	IVW	ETF	22.4219	22.875	22.4219	22.875	22400.0
2000-07-07	IWB	ETF	77.7812	78.5	77.7812	78.4062	1200.0
2000-07-07	IWD	ETF	54.1094	55.6406	54.1094	55.4375	5500.0
2000-07-07	IWF	ETF	21.8086	22.08985	21.8086	21.953125	24800.0
2000-07-07	IWV	ETF	80.3125	81.25	80.3125	81.1875	4700.0
2000-07-07	IYC	ETF	15.5547	15.5547	15.5547	15.5547	2000.0
2000-07-07	IYE	ETF	15.875	15.8958	15.875	15.875	7500.0
2000-07-07	IYF	ETF	37.0469	37.2344	37.0469	37.2344	2400.0
2000-07-07	IYG	ETF	28.25	28.2708	27.8906	28.2292	6900.0
2000-07-07	IYH	ETF	13.3625	13.4688	13.35	13.3688	156500.0
2000-07-07	IYR	ETF	36.1094	36.3906	36.1094	36.2812	8400.0
2000-07-07	IYW	ETF	32.0156	32.4062	32.0156	32.2188	12800.0

> showing 50 of 70 rows — these rows as CSV

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