PREVIEW / etf_daily / 2000-07-19

all etf daily files

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

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-19	SPY	ETF	149.4688	149.9062	148.25	148.5625	8506800.0
2000-07-19	QQQ	ETF	98.3125	98.9375	95.6563	97.25	21828500.0
2000-07-19	IWM	ETF	53.3906	53.3906	52.625	52.625	35400.0
2000-07-19	DIA	ETF	107.5625	108.1562	106.9375	107.1875	764300.0
2000-07-19	BBH	ETF	63.7917	63.7917	60.5833	60.6875	1260900.0
2000-07-19	BITS	ETF	20.75	21.0	19.5	20.0	16775.0
2000-07-19	CEF	ETF	3.375	3.375	3.25	3.25	79200.0
2000-07-19	CHB	ETF	5.06	5.25	5.06	5.19	14400.0
2000-07-19	CNXT	ETF	51.56	52.38	48.5	48.94	3495420.0
2000-07-19	EWA	ETF	10.4375	10.4375	10.1875	10.3125	2900.0
2000-07-19	EWC	ETF	20.875	20.875	20.625	20.625	20700.0
2000-07-19	EWD	ETF	31.5625	31.8125	31.5625	31.5625	500.0
2000-07-19	EWG	ETF	24.875	25.0	24.5625	24.8125	180500.0
2000-07-19	EWH	ETF	13.5	13.5625	13.4375	13.5	48200.0
2000-07-19	EWI	ETF	51.75	51.875	51.5	51.5	1200.0
2000-07-19	EWJ	ETF	57.0	57.25	56.25	56.5	61650.0
2000-07-19	EWK	ETF	13.5	13.625	13.375	13.4375	2500.0
2000-07-19	EWL	ETF	16.0	16.0625	15.8125	16.0625	3000.0
2000-07-19	EWM	ETF	25.75	25.75	25.0	25.5	10350.0
2000-07-19	EWN	ETF	24.125	24.375	24.0	24.0	29400.0
2000-07-19	EWO	ETF	7.625	7.6875	7.625	7.6875	1900.0
2000-07-19	EWP	ETF	25.875	26.0625	25.875	26.0625	400.0
2000-07-19	EWQ	ETF	28.0625	28.25	28.0	28.1875	14100.0
2000-07-19	EWS	ETF	15.375	15.625	15.25	15.5	34550.0
2000-07-19	EWT	ETF	37.25	37.25	36.625	36.625	800.0
2000-07-19	EWU	ETF	38.25	38.875	38.25	38.875	3100.0
2000-07-19	EWW	ETF	17.625	17.875	17.0	17.4375	36400.0
2000-07-19	EWY	ETF	20.25	20.6875	20.25	20.6875	37400.0
2000-07-19	EWZ	ETF	19.4375	19.4375	19.4375	19.4375	10000.0
2000-07-19	FCTR	ETF	16.25	16.25	15.9375	16.0	14700.0
2000-07-19	FMAR	ETF	5.0	5.62	5.0	5.62	6700.0
2000-07-19	GLDB	ETF	5.0	5.0313	4.9688	5.0	47400.0
2000-07-19	GSIG	ETF	41.19	41.5	38.62	39.75	651300.0
2000-07-19	IGLD	ETF	909.375	912.5	850.0	875.0	375.0
2000-07-19	IJH	ETF	10.2125	10.2563	10.125	10.125	883000.0
2000-07-19	IJR	ETF	18.1979	18.1979	17.9245	17.9245	316200.0
2000-07-19	IVE	ETF	60.5156	60.6875	60.25	60.25	29100.0
2000-07-19	IVV	ETF	149.3438	149.5781	148.4062	148.4062	120000.0
2000-07-19	IVW	ETF	22.836	22.8984	22.7656	22.832	10800.0
2000-07-19	IWB	ETF	79.1875	79.3438	78.5938	78.75	2700.0
2000-07-19	IWD	ETF	55.4375	55.6562	55.3125	55.3125	22700.0
2000-07-19	IWF	ETF	22.421875	22.421875	22.0664	22.140625	271200.0
2000-07-19	IWV	ETF	81.3594	81.6094	81.3594	81.375	62100.0
2000-07-19	IYC	ETF	15.75	15.75	15.7422	15.7422	4000.0
2000-07-19	IYE	ETF	16.0833	16.0833	16.0833	16.0833	300.0
2000-07-19	IYF	ETF	37.2812	37.3125	37.2188	37.3125	2200.0
2000-07-19	IYG	ETF	28.4792	28.5208	28.4792	28.5208	3600.0
2000-07-19	IYH	ETF	13.0062	13.0062	12.675	12.7312	37000.0
2000-07-19	IYJ	ETF	30.1875	30.1875	30.1875	30.1875	200.0
2000-07-19	IYR	ETF	35.7344	35.875	35.625	35.7812	98400.0

> showing 50 of 71 rows — these rows as CSV

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