PREVIEW / etf_daily / 2000-07-14

all etf daily files

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

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-14	SPY	ETF	150.4375	151.25	149.6719	151.25	5341900.0
2000-07-14	QQQ	ETF	100.25	101.125	98.8125	100.625	17219400.0
2000-07-14	IWM	ETF	54.5469	54.5469	53.875	54.3125	54800.0
2000-07-14	DIA	ETF	108.1875	108.4375	107.625	108.25	551300.0
2000-07-14	BBH	ETF	61.0	62.2292	60.1875	61.3333	1792500.0
2000-07-14	BITS	ETF	20.75	21.75	20.25	20.5	16175.0
2000-07-14	CEF	ETF	3.375	3.4375	3.375	3.375	37700.0
2000-07-14	CHB	ETF	5.38	5.38	5.13	5.19	40500.0
2000-07-14	CNXT	ETF	53.25	54.0	50.5	52.88	4180300.0
2000-07-14	CSB	ETF	3.20000004768372	3.20000004768372	3.20000004768372	3.20000004768372	6000.0
2000-07-14	EWA	ETF	10.625	10.625	10.4375	10.5625	8200.0
2000-07-14	EWC	ETF	20.6875	21.0	20.6875	20.8125	25100.0
2000-07-14	EWD	ETF	32.75	33.0625	32.3125	33.0625	6300.0
2000-07-14	EWG	ETF	25.0	25.125	24.875	25.0	103900.0
2000-07-14	EWH	ETF	13.5	13.6875	13.5	13.5625	34600.0
2000-07-14	EWI	ETF	52.875	52.875	52.625	52.75	1150.0
2000-07-14	EWJ	ETF	59.0	59.25	58.5	59.0	38550.0
2000-07-14	EWK	ETF	14.0	14.0	13.75	13.875	4600.0
2000-07-14	EWL	ETF	16.3125	16.375	16.0625	16.125	11700.0
2000-07-14	EWM	ETF	26.0	26.5	26.0	26.25	11850.0
2000-07-14	EWN	ETF	24.9375	24.9375	24.5625	24.9375	4300.0
2000-07-14	EWO	ETF	7.8125	7.8125	7.625	7.625	1900.0
2000-07-14	EWP	ETF	26.375	26.9375	26.375	26.9375	3100.0
2000-07-14	EWQ	ETF	29.0	29.0625	28.875	28.9375	17300.0
2000-07-14	EWS	ETF	15.125	15.25	15.0	15.0	28900.0
2000-07-14	EWT	ETF	38.0	38.125	38.0	38.125	1850.0
2000-07-14	EWU	ETF	39.25	39.25	38.75	38.75	18300.0
2000-07-14	EWW	ETF	18.625	18.875	18.375	18.5	49400.0
2000-07-14	EWY	ETF	21.375	21.375	21.25	21.25	1600.0
2000-07-14	EWZ	ETF	18.75	18.875	18.75	18.875	16300.0
2000-07-14	FCTR	ETF	15.75	17.0	15.75	16.875	10800.0
2000-07-14	FMAR	ETF	5.25	5.5	5.25	5.5	7500.0
2000-07-14	GLDB	ETF	4.9375	5.0625	4.875	4.9688	94100.0
2000-07-14	GSIG	ETF	35.94	38.0	33.75	37.5	620100.0
2000-07-14	IGLD	ETF	1018.75	1062.5	950.0	962.5	685.0
2000-07-14	IJH	ETF	10.3359	10.3578	10.2922	10.3578	801000.0
2000-07-14	IJR	ETF	18.3906	18.3906	18.2839	18.3229	12600.0
2000-07-14	IVE	ETF	61.2188	61.2188	61.125	61.1562	3000.0
2000-07-14	IVV	ETF	150.25	151.125	149.8125	150.9844	158800.0
2000-07-14	IVW	ETF	23.0547	23.207	22.9922	23.207	37600.0
2000-07-14	IWB	ETF	79.9219	80.1094	79.5469	80.1094	3000.0
2000-07-14	IWD	ETF	56.125	56.125	55.8594	55.9531	13500.0
2000-07-14	IWF	ETF	22.574225	22.75	22.41015	22.75	102000.0
2000-07-14	IWV	ETF	82.75	82.9375	82.5469	82.9375	1400.0
2000-07-14	IYC	ETF	15.9297	15.9297	15.9297	15.9297	3200.0
2000-07-14	IYE	ETF	16.1042	16.1042	15.9479	16.0104	3300.0
2000-07-14	IYF	ETF	37.6875	38.2344	37.6875	38.2344	3800.0
2000-07-14	IYG	ETF	28.9375	29.3021	28.9375	29.3021	3000.0
2000-07-14	IYH	ETF	12.9	12.9	12.5812	12.6969	55000.0
2000-07-14	IYK	ETF	13.9063	13.9063	13.9063	13.9063	300.0

> showing 50 of 73 rows — these rows as CSV

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