PREVIEW / etf_daily / 2000-05-19

all etf daily files

  file:    by_date/etf_daily/2000/2000-05-19.parquet
  size:    7 KB
  rows:    49

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-05-19	SPY	ETF	142.5625	143.2344	140.4062	141.125	6518400.0
2000-05-19	QQQ	ETF	83.75	85.0	81.3125	81.6875	28178100.0
2000-05-19	DIA	ETF	106.5625	107.0312	105.5156	106.5625	1394200.0
2000-05-19	BBH	ETF	45.9167	47.0625	45.4583	45.8125	1036500.0
2000-05-19	BITS	ETF	24.25	25.0	23.5	24.0	30900.0
2000-05-19	CEF	ETF	3.375	3.375	3.375	3.375	7500.0
2000-05-19	CHB	ETF	6.19	6.25	6.19	6.19	25900.0
2000-05-19	CNXT	ETF	41.75	42.25	39.27	39.5	6677030.0
2000-05-19	EWA	ETF	9.375	9.4375	9.25	9.4375	17100.0
2000-05-19	EWC	ETF	18.375	18.4375	18.1875	18.1875	6900.0
2000-05-19	EWD	ETF	31.3125	31.3125	30.875	31.0	5000.0
2000-05-19	EWG	ETF	22.6875	22.875	22.625	22.8125	33000.0
2000-05-19	EWH	ETF	11.75	11.875	11.5	11.75	26200.0
2000-05-19	EWI	ETF	44.75	44.75	44.75	44.75	400.0
2000-05-19	EWJ	ETF	58.25	58.5	57.75	58.0	87875.0
2000-05-19	EWK	ETF	12.125	12.3125	12.125	12.1875	1100.0
2000-05-19	EWL	ETF	15.125	15.1875	14.8125	15.1875	3200.0
2000-05-19	EWM	ETF	29.0	29.25	28.5	28.75	40850.0
2000-05-19	EWN	ETF	22.9375	22.9375	22.6875	22.9375	2000.0
2000-05-19	EWO	ETF	7.4375	7.4375	7.3125	7.4375	2500.0
2000-05-19	EWP	ETF	24.625	24.625	24.375	24.375	4700.0
2000-05-19	EWQ	ETF	25.875	26.0	25.75	25.875	20700.0
2000-05-19	EWS	ETF	13.625	14.0	13.375	13.75	25200.0
2000-05-19	EWU	ETF	36.25	36.25	35.625	35.875	10850.0
2000-05-19	EWW	ETF	15.0	15.0	14.4375	14.5625	11000.0
2000-05-19	EWY	ETF	19.3125	19.3125	19.3125	19.3125	18000.0
2000-05-19	FCTR	ETF	15.4375	15.4375	15.0	15.25	3200.0
2000-05-19	FMAR	ETF	6.75	6.75	6.03	6.03	4100.0
2000-05-19	GLDB	ETF	6.0	6.0	5.75	6.0	27200.0
2000-05-19	GSIG	ETF	22.87	23.06	20.75	21.25	504300.0
2000-05-19	IGLD	ETF	937.5	950.0	875.0	881.25	2303.0
2000-05-19	IVV	ETF	142.66	142.66	140.25	140.69	600200.0
2000-05-19	IWB	ETF	75.40625	75.40625	74.5	74.5	8100.0
2000-05-19	IYW	ETF	27.765	27.765	27.4375	27.4375	74800.0
2000-05-19	MDY	ETF	87.0625	87.5625	85.875	86.0	184200.0
2000-05-19	MIG	ETF	5.375	5.375	5.375	5.375	1000.0
2000-05-19	PPH	ETF	49.0	49.9688	48.8125	49.8125	207600.0
2000-05-19	SFY	ETF	23.9375	24.4375	23.625	24.4375	137800.0
2000-05-19	TDSC	ETF	5.25	5.405	5.25	5.31	157400.0
2000-05-19	TINY	ETF	7.81	7.81	7.38	7.5	39000.0
2000-05-19	XLB	ETF	11.5547	11.664	11.5312	11.625	44400.0
2000-05-19	XLE	ETF	15.7656	15.9922	15.6953	15.9062	142800.0
2000-05-19	XLF	ETF	20.0295	20.0295	19.4963	19.6487	182311.0
2000-05-19	XLI	ETF	30.0	30.0	29.6875	29.6875	3900.0
2000-05-19	XLK	ETF	25.0625	25.0938	24.1406	24.2812	1555000.0
2000-05-19	XLP	ETF	23.625	23.9844	23.5312	23.9844	17800.0
2000-05-19	XLU	ETF	13.9062	14.0	13.7578	13.9219	14800.0
2000-05-19	XLV	ETF	29.1562	29.1562	28.8125	28.8438	5500.0
2000-05-19	XLY	ETF	14.1562	14.3125	14.0625	14.0703	3800.0

> showing 49 of 49 rows — these rows as CSV

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