PREVIEW / etf_daily / 2001-01-16

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-16.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-16	SPY	ETF	132.0	133.1875	131.5156	132.8438	8542200.0
2001-01-16	QQQ	ETF	62.5625	62.9219	60.5625	61.9844	32203300.0
2001-01-16	IWM	ETF	48.25	49.3438	48.0312	49.3438	445200.0
2001-01-16	DIA	ETF	105.25	106.7812	104.8125	106.4375	1052400.0
2001-01-16	BBH	ETF	51.0	51.5833	49.8333	51.2083	1986600.0
2001-01-16	BITS	ETF	12.0	12.5	11.75	12.0	16700.0
2001-01-16	BOSS	ETF	23.95	24.0	23.95	24.0	300.0
2001-01-16	CEF	ETF	3.1875	3.1875	3.125	3.125	11100.0
2001-01-16	CHB	ETF	5.25	5.31	4.88	5.0	277900.0
2001-01-16	CNXT	ETF	20.25	20.5	18.37	19.87	3506320.0
2001-01-16	DGT	ETF	77.875	77.875	77.25	77.875	7900.0
2001-01-16	EWA	ETF	9.6875	9.6875	9.625	9.6875	2500.0
2001-01-16	EWC	ETF	13.1875	13.1875	13.0	13.0	4600.0
2001-01-16	EWD	ETF	18.9375	18.9375	18.625	18.6875	36600.0
2001-01-16	EWG	ETF	19.875	19.875	19.6875	19.8125	53300.0
2001-01-16	EWH	ETF	11.625	11.8125	11.5625	11.6875	72200.0
2001-01-16	EWI	ETF	45.625	45.75	45.375	45.375	24050.0
2001-01-16	EWJ	ETF	42.5	43.0	42.5	42.75	65500.0
2001-01-16	EWK	ETF	12.6875	12.9375	12.6875	12.75	17600.0
2001-01-16	EWL	ETF	16.3125	16.4375	16.1875	16.25	13600.0
2001-01-16	EWM	ETF	20.0	20.25	20.0	20.0	2250.0
2001-01-16	EWN	ETF	22.9375	22.9375	22.8125	22.8125	300.0
2001-01-16	EWO	ETF	8.0	8.0	7.75	7.75	6700.0
2001-01-16	EWP	ETF	25.25	25.25	25.0	25.0	3300.0
2001-01-16	EWQ	ETF	24.3125	24.3125	24.0	24.1875	31800.0
2001-01-16	EWS	ETF	13.0	13.25	13.0	13.125	6300.0
2001-01-16	EWT	ETF	25.25	25.5	25.0	25.125	22700.0
2001-01-16	EWU	ETF	34.875	35.0	34.5	34.75	21150.0
2001-01-16	EWW	ETF	13.75	14.0	13.75	13.875	65200.0
2001-01-16	EWY	ETF	14.375	14.375	14.125	14.1875	2500.0
2001-01-16	EWZ	ETF	17.8125	17.8125	17.4375	17.4375	3300.0
2001-01-16	EZU	ETF	36.6562	36.6875	36.3438	36.4688	5600.0
2001-01-16	FCTR	ETF	13.75	15.5	13.75	15.5	198500.0
2001-01-16	FMAR	ETF	5.12	5.125	4.9967	5.12	4400.0
2001-01-16	GLDB	ETF	5.3125	5.5	5.25	5.4375	149300.0
2001-01-16	GSIG	ETF	11.0	11.31	10.44	11.19	312500.0
2001-01-16	IDU	ETF	36.9062	37.0	36.1406	37.0	51000.0
2001-01-16	IEV	ETF	37.9375	37.9375	37.4375	37.5938	88400.0
2001-01-16	IGLD	ETF	250.0	256.25	243.75	250.0	595.0
2001-01-16	IJH	ETF	10.1219	10.1266	10.0594	10.1156	56000.0
2001-01-16	IJJ	ETF	21.2617	21.5039	21.2617	21.5039	24400.0
2001-01-16	IJK	ETF	14.8008	14.8438	14.7246	14.8281	14400.0
2001-01-16	IJR	ETF	18.2188	18.3984	18.1146	18.3542	147600.0
2001-01-16	IJS	ETF	19.7734	20.086	19.6992	20.086	188000.0
2001-01-16	IJT	ETF	19.1562	19.1719	18.8594	19.082	38800.0
2001-01-16	IOO	ETF	34.8906	34.9766	34.8281	34.8828	2600.0
2001-01-16	IUSG	ETF	26.1953	26.1953	26.164	26.164	1000.0
2001-01-16	IUSV	ETF	24.7813	24.9375	24.7813	24.9375	900.0
2001-01-16	IVE	ETF	64.1875	64.625	64.0625	64.4688	21500.0
2001-01-16	IVV	ETF	132.1406	132.9531	131.5	132.6719	100500.0

> showing 50 of 93 rows — these rows as CSV

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