PREVIEW / etf_daily / 2001-01-23

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-23.parquet
  size:    8 KB
  rows:    92

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-23	SPY	ETF	134.4688	136.6562	134.1562	135.9688	8463100.0
2001-01-23	QQQ	ETF	65.9063	68.4063	65.3125	67.7656	49864400.0
2001-01-23	IWM	ETF	49.0	50.1875	48.875	50.1875	3197400.0
2001-01-23	DIA	ETF	105.625	106.9219	105.5312	106.5	1362700.0
2001-01-23	BBH	ETF	50.25	52.25	49.7083	52.125	3323400.0
2001-01-23	BITS	ETF	11.875	13.5	11.875	12.5	13475.0
2001-01-23	CEF	ETF	3.25	3.25	3.0625	3.125	91800.0
2001-01-23	CHB	ETF	6.5	6.63	6.38	6.56	194800.0
2001-01-23	CNXT	ETF	17.61	18.87	17.328	18.5	2816280.0
2001-01-23	DGT	ETF	79.0	79.7031	78.625	79.5312	1700.0
2001-01-23	EWA	ETF	9.6875	9.8125	9.6875	9.8125	11900.0
2001-01-23	EWC	ETF	13.6875	13.875	13.5625	13.875	30700.0
2001-01-23	EWD	ETF	19.1875	19.3125	18.9375	19.0625	4800.0
2001-01-23	EWG	ETF	19.9375	20.1875	19.9375	20.1875	42800.0
2001-01-23	EWH	ETF	12.1875	12.4375	12.1875	12.4375	41600.0
2001-01-23	EWI	ETF	45.625	45.625	45.375	45.5	3150.0
2001-01-23	EWJ	ETF	44.25	44.25	43.5	44.25	198900.0
2001-01-23	EWK	ETF	12.75	12.9375	12.75	12.875	3900.0
2001-01-23	EWL	ETF	16.3125	16.5625	16.3125	16.5	27500.0
2001-01-23	EWM	ETF	21.75	21.75	21.0	21.75	6675.0
2001-01-23	EWN	ETF	22.5625	22.9375	22.5625	22.8125	3400.0
2001-01-23	EWO	ETF	7.875	7.9375	7.75	7.9375	4200.0
2001-01-23	EWP	ETF	25.4375	25.8125	25.1875	25.75	48700.0
2001-01-23	EWQ	ETF	24.25	24.875	24.125	24.3125	50700.0
2001-01-23	EWS	ETF	12.75	13.0	12.75	13.0	7200.0
2001-01-23	EWT	ETF	27.5	27.5	26.625	27.375	1600.0
2001-01-23	EWU	ETF	35.5	35.5	34.875	35.25	29450.0
2001-01-23	EWW	ETF	14.8125	15.0	14.5	14.875	77700.0
2001-01-23	EWY	ETF	15.9375	16.125	15.5	15.875	40800.0
2001-01-23	EWZ	ETF	18.625	18.625	18.375	18.625	62400.0
2001-01-23	EZU	ETF	36.3438	36.9375	36.3438	36.875	13400.0
2001-01-23	FCTR	ETF	14.75	15.125	14.5625	15.125	19600.0
2001-01-23	FMAR	ETF	5.75	5.75	5.5	5.5	6800.0
2001-01-23	GLDB	ETF	5.375	5.5	5.375	5.375	73700.0
2001-01-23	GSIG	ETF	11.87	12.5	11.25	12.12	271000.0
2001-01-23	IDU	ETF	39.4531	39.875	39.375	39.4219	81200.0
2001-01-23	IEV	ETF	37.3125	37.7812	37.3125	37.625	78000.0
2001-01-23	IGLD	ETF	268.75	275.0	268.75	271.875	52.0
2001-01-23	IJH	ETF	10.1375	10.3922	10.1281	10.3922	941000.0
2001-01-23	IJJ	ETF	21.5469	21.8633	21.4688	21.8438	75600.0
2001-01-23	IJK	ETF	14.7891	15.334	14.7891	15.3106	1033600.0
2001-01-23	IJR	ETF	18.3333	18.724	18.3177	18.6875	348000.0
2001-01-23	IJS	ETF	20.0	20.2969	20.0	20.2969	68400.0
2001-01-23	IJT	ETF	19.0	19.4727	18.9688	19.4727	90400.0
2001-01-23	IOO	ETF	35.7266	36.1328	35.6484	36.1328	13000.0
2001-01-23	IUSG	ETF	27.0078	27.7969	27.0078	27.7969	35200.0
2001-01-23	IUSV	ETF	24.9219	25.0625	24.9219	25.0625	1800.0
2001-01-23	IVE	ETF	64.5	65.4375	64.5	65.2969	39300.0
2001-01-23	IVV	ETF	134.5625	136.5	134.25	135.9219	35100.0
2001-01-23	IVW	ETF	17.5469	17.7812	17.4531	17.7617	300000.0

> showing 50 of 92 rows — these rows as CSV

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