PREVIEW / etf_daily / 2000-07-18

all etf daily files

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

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-18	SPY	ETF	150.625	150.625	149.3438	149.7656	4262100.0
2000-07-18	QQQ	ETF	100.375	100.7813	98.3594	99.5	20684000.0
2000-07-18	IWM	ETF	54.1406	54.1406	53.5625	53.5625	235400.0
2000-07-18	DIA	ETF	107.5625	108.0	107.0312	107.625	347600.0
2000-07-18	BBH	ETF	62.3333	63.8333	62.2083	62.9792	1100100.0
2000-07-18	BITS	ETF	22.375	22.375	20.0	20.75	20125.0
2000-07-18	CEF	ETF	3.375	3.375	3.3125	3.3125	56500.0
2000-07-18	CHB	ETF	5.06	5.06	4.94	5.0	30400.0
2000-07-18	CNXT	ETF	54.47	54.47	50.72	51.47	3611280.0
2000-07-18	EWA	ETF	10.375	10.5	10.375	10.375	10300.0
2000-07-18	EWC	ETF	20.9375	20.9375	20.6875	20.8125	21500.0
2000-07-18	EWD	ETF	32.9375	32.9375	32.0625	32.25	5800.0
2000-07-18	EWG	ETF	25.25	25.4375	25.0	25.125	54000.0
2000-07-18	EWH	ETF	13.25	13.25	13.0	13.0625	25000.0
2000-07-18	EWI	ETF	52.5	52.5	51.875	52.125	8850.0
2000-07-18	EWJ	ETF	57.0	57.25	56.75	57.0	69450.0
2000-07-18	EWK	ETF	13.9375	13.9375	13.625	13.6875	5800.0
2000-07-18	EWL	ETF	16.1875	16.1875	15.8125	16.0	9100.0
2000-07-18	EWM	ETF	25.5	25.75	25.25	25.5	6975.0
2000-07-18	EWN	ETF	24.5	24.625	24.25	24.5625	16700.0
2000-07-18	EWO	ETF	7.625	7.75	7.625	7.75	2400.0
2000-07-18	EWP	ETF	26.375	26.375	25.6875	25.9375	15400.0
2000-07-18	EWQ	ETF	28.6875	28.875	28.375	28.625	49900.0
2000-07-18	EWS	ETF	15.25	15.375	15.0	15.0	41650.0
2000-07-18	EWT	ETF	37.25	37.25	37.25	37.25	850.0
2000-07-18	EWU	ETF	39.0	39.0	38.125	38.5	15700.0
2000-07-18	EWW	ETF	18.4375	18.4375	17.9375	18.25	31900.0
2000-07-18	EWY	ETF	20.875	21.125	20.875	20.875	1600.0
2000-07-18	EWZ	ETF	19.9375	19.9375	19.9375	19.9375	10000.0
2000-07-18	FCTR	ETF	16.5	16.5	16.0625	16.1875	12500.0
2000-07-18	FMAR	ETF	5.25	5.25	5.0	5.0	14600.0
2000-07-18	GLDB	ETF	5.0	5.0313	4.9688	5.0	66200.0
2000-07-18	GSIG	ETF	39.87	42.12	37.87	41.0	1459500.0
2000-07-18	IGLD	ETF	925.0	937.5	900.0	900.0	561.0
2000-07-18	IJH	ETF	10.325	10.3359	10.2344	10.2344	1706000.0
2000-07-18	IJR	ETF	18.3386	18.3776	18.2109	18.3021	33600.0
2000-07-18	IVE	ETF	60.375	60.375	60.25	60.3125	19800.0
2000-07-18	IVV	ETF	150.4688	150.5	149.375	149.8125	763600.0
2000-07-18	IVW	ETF	23.332	23.332	23.125	23.125	15600.0
2000-07-18	IWB	ETF	79.9375	79.9375	79.4062	79.5469	12100.0
2000-07-18	IWD	ETF	55.375	55.625	55.25	55.25	32700.0
2000-07-18	IWF	ETF	22.875	22.980475	22.52345	22.625	38000.0
2000-07-18	IWV	ETF	82.75	82.75	82.0	82.4062	5200.0
2000-07-18	IYF	ETF	37.3047	37.3125	37.1562	37.3125	5200.0
2000-07-18	IYG	ETF	28.4479	28.5208	28.4479	28.5208	1200.0
2000-07-18	IYH	ETF	13.1	13.1	12.9625	12.9688	10000.0
2000-07-18	IYR	ETF	36.2188	36.2188	36.2188	36.2188	400.0
2000-07-18	IYW	ETF	33.6406	33.6406	33.2539	33.375	16400.0
2000-07-18	IYY	ETF	35.3125	35.3125	35.0781	35.0781	1200.0
2000-07-18	IYZ	ETF	61.3438	61.9062	61.3438	61.8125	600.0

> showing 50 of 68 rows — these rows as CSV

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