PREVIEW / etf_daily / 2001-01-17

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-17.parquet
  size:    8 KB
  rows:    93

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
2001-01-17	SPY	ETF	134.8438	135.0469	132.6406	133.4531	7851400.0
2001-01-17	QQQ	ETF	64.5	65.6094	63.1406	63.875	61400500.0
2001-01-17	IWM	ETF	50.0938	50.1875	48.9688	49.3125	1089600.0
2001-01-17	DIA	ETF	107.2344	107.375	105.4531	105.9688	2434700.0
2001-01-17	BBH	ETF	52.125	52.1458	48.1667	48.6667	3356700.0
2001-01-17	BITS	ETF	12.0	13.5	11.25	12.5	21525.0
2001-01-17	CEF	ETF	3.1875	3.1875	3.125	3.125	2700.0
2001-01-17	CHB	ETF	5.13	5.44	5.0	5.25	112000.0
2001-01-17	CNXT	ETF	20.62	21.5	19.69	19.81	3760730.0
2001-01-17	DGT	ETF	79.3125	79.3125	78.125	78.125	4800.0
2001-01-17	EWA	ETF	9.75	9.75	9.625	9.75	3800.0
2001-01-17	EWC	ETF	13.25	13.4375	13.1875	13.3125	12300.0
2001-01-17	EWD	ETF	18.9375	19.0	18.8125	18.875	92800.0
2001-01-17	EWG	ETF	20.0	20.0	19.8125	20.0	202800.0
2001-01-17	EWH	ETF	11.8125	11.9375	11.6875	11.6875	42500.0
2001-01-17	EWI	ETF	45.75	45.75	45.125	45.25	71500.0
2001-01-17	EWJ	ETF	43.5	43.75	43.25	43.5	500850.0
2001-01-17	EWK	ETF	12.875	12.875	12.6875	12.75	3000.0
2001-01-17	EWL	ETF	16.1875	16.3125	16.1875	16.3125	12400.0
2001-01-17	EWM	ETF	20.75	20.75	20.0	20.25	4875.0
2001-01-17	EWN	ETF	23.0	23.0	22.5625	22.875	43000.0
2001-01-17	EWO	ETF	7.875	7.875	7.875	7.875	7400.0
2001-01-17	EWP	ETF	25.5	25.5	25.0	25.1875	135500.0
2001-01-17	EWQ	ETF	24.4375	24.5	24.3125	24.5	123000.0
2001-01-17	EWS	ETF	13.25	13.25	13.0	13.0	7050.0
2001-01-17	EWT	ETF	26.0	26.5	25.75	26.5	23900.0
2001-01-17	EWU	ETF	35.5	35.5	34.75	35.25	115550.0
2001-01-17	EWW	ETF	14.375	14.5	14.125	14.1875	84200.0
2001-01-17	EWY	ETF	14.625	14.9375	14.625	14.75	25600.0
2001-01-17	EWZ	ETF	17.875	18.25	17.875	18.25	10800.0
2001-01-17	EZU	ETF	36.9375	36.9375	36.5312	36.8125	48000.0
2001-01-17	FCTR	ETF	14.7031	15.75	14.7031	15.75	77100.0
2001-01-17	FMAR	ETF	5.06	5.25	5.0	5.25	9800.0
2001-01-17	GLDB	ETF	5.375	5.5	5.375	5.375	43700.0
2001-01-17	GSIG	ETF	11.25	12.0	11.25	11.37	242800.0
2001-01-17	IDU	ETF	37.0625	37.4844	37.0625	37.3125	6600.0
2001-01-17	IEV	ETF	38.0625	38.1875	37.8125	38.125	65200.0
2001-01-17	IGLD	ETF	268.75	275.0	212.5	262.5	161.0
2001-01-17	IJH	ETF	10.3	10.3125	10.15	10.1625	527000.0
2001-01-17	IJJ	ETF	21.7578	21.793	21.5625	21.6016	25200.0
2001-01-17	IJK	ETF	15.0938	15.1621	14.9062	14.9062	583200.0
2001-01-17	IJR	ETF	18.6563	18.7708	18.4167	18.4479	708600.0
2001-01-17	IJS	ETF	20.25	20.4531	20.2188	20.2656	153600.0
2001-01-17	IJT	ETF	19.375	19.5	19.0781	19.0781	24000.0
2001-01-17	IOO	ETF	35.4453	35.6172	35.0469	35.0469	1600.0
2001-01-17	IUSG	ETF	27.0	27.0703	26.6406	26.6406	28000.0
2001-01-17	IUSV	ETF	25.1458	25.1458	24.9167	24.9167	3000.0
2001-01-17	IVE	ETF	65.3125	65.3594	64.6562	64.9375	53800.0
2001-01-17	IVV	ETF	134.625	134.9375	132.7344	133.3281	100600.0
2001-01-17	IVW	ETF	17.375	17.4336	17.082	17.0938	48400.0

> showing 50 of 93 rows — these rows as CSV

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