PREVIEW / etf_daily / 2000-04-17

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-17.parquet
  size:    6 KB
  rows:    48

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-04-17	SPY	ETF	135.1875	140.75	134.6875	140.75	23918200.0
2000-04-17	QQQ	ETF	78.0156	90.0	78.0	89.625	55398600.0
2000-04-17	DIA	ETF	102.875	106.0312	102.25	106.0	5978400.0
2000-04-17	BBH	ETF	44.0	45.6667	42.1667	45.3125	2274000.0
2000-04-17	BITS	ETF	17.0	20.5	17.0	20.0	62900.0
2000-04-17	BOSS	ETF	13.5	13.8	13.5	13.8	400.0
2000-04-17	CEF	ETF	3.4375	3.5	3.375	3.4375	110600.0
2000-04-17	CHB	ETF	6.13	6.13	6.06	6.06	117400.0
2000-04-17	CNXT	ETF	41.25	52.5	41.0	52.44	7956200.0
2000-04-17	CSB	ETF	4.0	4.0	3.79999995231628	3.79999995231628	22500.0
2000-04-17	EWA	ETF	9.125	9.5	9.125	9.4375	20200.0
2000-04-17	EWC	ETF	16.3125	16.875	16.3125	16.875	115500.0
2000-04-17	EWD	ETF	30.0	31.0	30.0	31.0	6000.0
2000-04-17	EWG	ETF	24.5	25.75	24.5	25.75	90400.0
2000-04-17	EWH	ETF	12.0	12.125	11.625	12.125	114800.0
2000-04-17	EWI	ETF	45.5	46.625	45.5	46.625	6550.0
2000-04-17	EWJ	ETF	58.75	60.5	58.75	60.5	181575.0
2000-04-17	EWK	ETF	13.125	13.125	13.125	13.125	800.0
2000-04-17	EWL	ETF	15.3125	15.4375	15.1875	15.4375	5800.0
2000-04-17	EWM	ETF	24.0	24.75	23.75	24.5	38675.0
2000-04-17	EWN	ETF	23.0	23.3125	23.0	23.25	5100.0
2000-04-17	EWO	ETF	7.5625	7.8125	7.5625	7.8125	1800.0
2000-04-17	EWP	ETF	26.9375	27.5	26.9375	27.375	1200.0
2000-04-17	EWQ	ETF	25.9375	26.875	25.9375	26.875	21200.0
2000-04-17	EWS	ETF	13.75	14.25	13.5	14.25	120150.0
2000-04-17	EWU	ETF	36.75	37.875	36.75	37.625	29450.0
2000-04-17	EWW	ETF	15.4375	15.5	15.1875	15.5	19200.0
2000-04-17	FCTR	ETF	12.9375	12.9375	12.5	12.5	39300.0
2000-04-17	FMAR	ETF	5.5	6.25	5.5	6.25	3300.0
2000-04-17	GLDB	ETF	5.9375	6.125	5.875	6.125	165800.0
2000-04-17	GSIG	ETF	14.0	14.5	11.75	14.12	748100.0
2000-04-17	IGLD	ETF	950.0	1125.0	950.0	1100.0	2459.0
2000-04-17	KTEC	ETF	8.5625	9.0	8.1875	9.0	22600.0
2000-04-17	MDY	ETF	77.6875	82.75	77.6875	82.0	1659500.0
2000-04-17	MIG	ETF	5.25	5.3125	5.125	5.3125	2100.0
2000-04-17	PPH	ETF	45.1875	45.75	44.5938	45.5938	529400.0
2000-04-17	SFY	ETF	17.75	18.3125	17.125	18.25	115400.0
2000-04-17	TDSC	ETF	4.31	4.375	4.0	4.25	94200.0
2000-04-17	TINY	ETF	8.62	9.75	7.88	8.81	374900.0
2000-04-17	XLB	ETF	11.4844	11.4844	11.1875	11.3281	105600.0
2000-04-17	XLE	ETF	14.125	14.2031	13.7578	13.9062	432200.0
2000-04-17	XLF	ETF	18.684	18.7094	18.0747	18.4048	498309.0
2000-04-17	XLI	ETF	27.9219	28.2656	27.6875	28.2656	20200.0
2000-04-17	XLK	ETF	24.375	26.0938	24.3125	26.0938	1810800.0
2000-04-17	XLP	ETF	22.3281	22.3594	21.7188	22.3594	139500.0
2000-04-17	XLU	ETF	13.836	13.836	13.0	13.6016	235600.0
2000-04-17	XLV	ETF	27.7812	28.0625	27.1406	27.9531	16900.0
2000-04-17	XLY	ETF	14.1875	14.1875	13.6875	14.0156	281200.0

> showing 48 of 48 rows — these rows as CSV

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