PREVIEW / etf_daily / 2000-05-23

all etf daily files

  file:    by_date/etf_daily/2000/2000-05-23.parquet
  size:    7 KB
  rows:    50

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-23	SPY	ETF	140.4375	140.8125	137.5625	138.0	7979200.0
2000-05-23	QQQ	ETF	81.375	82.625	74.25	74.8125	31920500.0
2000-05-23	DIA	ETF	105.5938	105.6875	104.0156	104.4375	715700.0
2000-05-23	BBH	ETF	43.4167	44.2292	40.3542	40.5	1398300.0
2000-05-23	BITS	ETF	22.25	22.75	21.25	22.0	7750.0
2000-05-23	CEF	ETF	3.4375	3.4375	3.375	3.375	9800.0
2000-05-23	CHB	ETF	5.88	6.0	5.88	6.0	81400.0
2000-05-23	CNXT	ETF	35.72	38.47	34.78	34.91	4465260.0
2000-05-23	EWA	ETF	9.25	9.5	9.25	9.5	11000.0
2000-05-23	EWC	ETF	17.875	17.875	17.75	17.75	1200.0
2000-05-23	EWD	ETF	30.125	30.5625	30.0	30.125	8800.0
2000-05-23	EWG	ETF	23.0625	23.25	22.875	22.875	59100.0
2000-05-23	EWH	ETF	11.5625	11.6875	11.375	11.375	10000.0
2000-05-23	EWI	ETF	45.5	45.5	45.5	45.5	10000.0
2000-05-23	EWJ	ETF	56.75	57.0	56.5	56.5	312225.0
2000-05-23	EWK	ETF	12.6875	12.6875	12.4375	12.4375	18600.0
2000-05-23	EWL	ETF	15.125	15.25	15.0	15.0	16400.0
2000-05-23	EWM	ETF	28.0	28.0	27.25	27.25	35775.0
2000-05-23	EWN	ETF	22.875	22.9375	22.75	22.75	2000.0
2000-05-23	EWO	ETF	7.375	7.75	7.375	7.75	38300.0
2000-05-23	EWP	ETF	24.375	24.375	24.3125	24.3125	2000.0
2000-05-23	EWQ	ETF	25.75	26.0	25.75	25.75	18800.0
2000-05-23	EWS	ETF	13.125	13.375	12.75	13.0	55750.0
2000-05-23	EWU	ETF	36.125	36.25	35.75	35.875	12450.0
2000-05-23	EWW	ETF	14.125	14.25	14.125	14.1875	6700.0
2000-05-23	EWY	ETF	17.9375	18.125	17.875	17.875	51300.0
2000-05-23	FCTR	ETF	14.75	15.0625	14.75	14.875	14900.0
2000-05-23	FMAR	ETF	6.5	6.5	5.75	5.75	7700.0
2000-05-23	GLDB	ETF	6.0	6.0	5.875	5.9375	21100.0
2000-05-23	GSIG	ETF	20.0	21.12	19.5	19.69	205800.0
2000-05-23	IGLD	ETF	950.0	950.0	900.0	912.5	560.0
2000-05-23	IVV	ETF	140.2188	140.2188	137.6875	137.6875	373900.0
2000-05-23	IWB	ETF	74.125	74.125	72.8438	72.8438	271200.0
2000-05-23	IYW	ETF	27.3125	27.3125	27.0	27.0938	104000.0
2000-05-23	KTEC	ETF	8.125	8.375	8.125	8.25	800.0
2000-05-23	MDY	ETF	84.9375	85.875	83.625	83.625	270400.0
2000-05-23	MIG	ETF	5.125	5.125	5.0625	5.0625	7300.0
2000-05-23	PPH	ETF	49.25	49.8125	49.0625	49.5312	198800.0
2000-05-23	SFY	ETF	23.9375	24.5625	23.5625	23.5625	125600.0
2000-05-23	TDSC	ETF	5.25	5.31	4.845	5.19	153800.0
2000-05-23	TINY	ETF	6.5	7.0	6.28	6.31	136300.0
2000-05-23	XLB	ETF	11.4688	11.4688	11.3047	11.3984	105600.0
2000-05-23	XLE	ETF	15.75	15.875	15.6094	15.711	280600.0
2000-05-23	XLF	ETF	19.801	20.1056	19.7248	20.0295	203731.0
2000-05-23	XLI	ETF	29.1719	29.1719	28.9062	29.0469	800.0
2000-05-23	XLK	ETF	24.25	24.25	22.9688	23.0	668600.0
2000-05-23	XLP	ETF	23.6875	23.875	23.625	23.7812	17700.0
2000-05-23	XLU	ETF	13.9844	13.9844	13.7578	13.7578	30200.0
2000-05-23	XLV	ETF	28.5625	28.6562	28.2812	28.2812	6600.0
2000-05-23	XLY	ETF	13.8438	14.0312	13.7969	13.7969	40000.0

> showing 50 of 50 rows — these rows as CSV

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