PREVIEW / etf_daily / 2000-06-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-06-27.parquet
  size:    7 KB
  rows:    70

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-06-27	SPY	ETF	145.9844	146.7188	145.0156	145.1562	4159500.0
2000-06-27	QQQ	ETF	93.7656	95.0625	92.375	92.875	14786000.0
2000-06-27	IWM	ETF	51.6094	52.0625	50.7188	50.7188	112800.0
2000-06-27	DIA	ETF	105.6562	106.25	105.0938	105.375	415600.0
2000-06-27	BBH	ETF	58.9583	59.0417	57.4167	57.4167	1396500.0
2000-06-27	BITS	ETF	27.125	28.0	26.0	26.0	5650.0
2000-06-27	CEF	ETF	3.375	3.5	3.375	3.4375	49300.0
2000-06-27	CHB	ETF	4.75	4.94	4.75	4.88	99200.0
2000-06-27	CNXT	ETF	52.37	53.24	50.13	50.69	3222800.0
2000-06-27	CSB	ETF	3.5	3.5	3.5	3.5	15800.0
2000-06-27	EWA	ETF	10.25	10.4375	10.25	10.4375	4900.0
2000-06-27	EWC	ETF	19.375	19.4375	19.1875	19.3125	47000.0
2000-06-27	EWD	ETF	30.125	30.125	30.125	30.125	1300.0
2000-06-27	EWG	ETF	23.9375	24.3125	23.875	24.3125	26600.0
2000-06-27	EWH	ETF	12.5	12.5	12.375	12.4375	20500.0
2000-06-27	EWI	ETF	50.25	50.375	49.875	50.25	12600.0
2000-06-27	EWJ	ETF	60.25	60.5	60.0	60.25	51100.0
2000-06-27	EWK	ETF	13.1875	13.25	13.1875	13.25	400.0
2000-06-27	EWL	ETF	15.8125	15.9375	15.625	15.9375	9200.0
2000-06-27	EWM	ETF	24.75	25.0	24.5	24.75	20525.0
2000-06-27	EWN	ETF	24.9375	24.9375	24.8125	24.8125	1300.0
2000-06-27	EWO	ETF	7.8125	7.8125	7.8125	7.8125	100.0
2000-06-27	EWP	ETF	25.25	25.5	25.25	25.5	700.0
2000-06-27	EWQ	ETF	28.75	29.125	28.75	28.875	30800.0
2000-06-27	EWS	ETF	14.75	15.125	14.75	15.125	33750.0
2000-06-27	EWT	ETF	37.625	37.875	37.5	37.875	2200.0
2000-06-27	EWU	ETF	37.5	38.125	37.5	38.125	12700.0
2000-06-27	EWW	ETF	15.5	15.75	15.5	15.5	2800.0
2000-06-27	EWY	ETF	20.8125	20.875	20.75	20.8125	30800.0
2000-06-27	FCTR	ETF	16.625	16.9688	16.625	16.6875	89400.0
2000-06-27	FMAR	ETF	5.5	6.0	5.5	6.0	1200.0
2000-06-27	GLDB	ETF	6.0	6.375	6.0	6.1875	271600.0
2000-06-27	GSIG	ETF	26.75	29.62	26.37	29.06	831100.0
2000-06-27	IDU	ETF	33.6719	33.6719	33.4375	33.4531	41000.0
2000-06-27	IGLD	ETF	850.0	875.0	837.5	843.75	190.0
2000-06-27	IJH	ETF	9.825	9.8391	9.7125	9.7375	488000.0
2000-06-27	IJR	ETF	17.3594	17.3802	17.2813	17.2813	724800.0
2000-06-27	IVE	ETF	59.6562	59.6562	59.3125	59.3125	13800.0
2000-06-27	IVV	ETF	145.8125	146.2969	145.25	145.25	40900.0
2000-06-27	IWB	ETF	77.2969	77.375	77.2656	77.2656	300.0
2000-06-27	IWD	ETF	56.0	56.0	55.5938	55.5938	14400.0
2000-06-27	IWF	ETF	21.46095	21.5078	21.40235	21.40235	23600.0
2000-06-27	IWV	ETF	79.7969	79.7969	79.5625	79.5625	2000.0
2000-06-27	IYE	ETF	16.5833	16.5833	16.5417	16.5417	2400.0
2000-06-27	IYF	ETF	36.25	36.2969	36.0938	36.0938	3400.0
2000-06-27	IYG	ETF	27.5313	27.5833	27.5	27.5625	3000.0
2000-06-27	IYH	ETF	12.8062	12.8562	12.7469	12.7906	138500.0
2000-06-27	IYK	ETF	13.6354	13.6354	13.6354	13.6354	75000.0
2000-06-27	IYM	ETF	34.8125	34.8125	34.8125	34.8125	500.0
2000-06-27	IYR	ETF	35.3594	35.375	35.3594	35.375	2600.0

> showing 50 of 70 rows — these rows as CSV

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