PREVIEW / etf_daily / 2000-04-07

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-07.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-07	SPY	ETF	151.5625	152.125	150.5	151.4375	6023600.0
2000-04-07	QQQ	ETF	104.125	107.375	102.625	106.625	20645500.0
2000-04-07	DIA	ETF	111.9688	111.9844	110.5625	110.9062	1027100.0
2000-04-07	BBH	ETF	60.2917	60.3333	56.1875	57.9792	2593800.0
2000-04-07	BITS	ETF	43.0	43.0	39.5	40.0	27250.0
2000-04-07	BOSS	ETF	13.8	13.8	13.4	13.4	300.0
2000-04-07	CEF	ETF	3.4375	3.5	3.4375	3.5	9700.0
2000-04-07	CHB	ETF	6.68	6.71	6.19	6.32	58954.0
2000-04-07	CNXT	ETF	73.2	78.64	73.2	77.69	3649600.0
2000-04-07	CSB	ETF	4.0	4.0	4.0	4.0	2500.0
2000-04-07	EWA	ETF	10.0625	10.25	10.0625	10.25	1800.0
2000-04-07	EWC	ETF	18.1875	18.1875	18.1875	18.1875	600.0
2000-04-07	EWD	ETF	34.125	34.125	34.0625	34.0625	300.0
2000-04-07	EWG	ETF	26.5	26.75	26.3125	26.5625	49300.0
2000-04-07	EWH	ETF	13.375	13.5	13.375	13.5	42800.0
2000-04-07	EWI	ETF	49.125	49.625	49.125	49.25	19050.0
2000-04-07	EWJ	ETF	63.5	63.75	63.0	63.75	39350.0
2000-04-07	EWK	ETF	12.9375	13.125	12.875	13.0	1600.0
2000-04-07	EWL	ETF	15.375	15.6875	15.375	15.5	4700.0
2000-04-07	EWM	ETF	27.25	27.75	27.25	27.5	11300.0
2000-04-07	EWN	ETF	24.125	24.125	24.125	24.125	1800.0
2000-04-07	EWO	ETF	8.0	8.0	7.75	7.875	3400.0
2000-04-07	EWP	ETF	28.0625	28.3125	28.0625	28.1875	2100.0
2000-04-07	EWQ	ETF	27.9375	27.9375	27.5625	27.75	55800.0
2000-04-07	EWS	ETF	14.75	15.0	14.75	15.0	39450.0
2000-04-07	EWU	ETF	40.5	41.25	40.5	41.25	4950.0
2000-04-07	EWW	ETF	18.8125	19.0	18.6875	19.0	27700.0
2000-04-07	FCTR	ETF	13.8125	14.0	13.125	13.75	67900.0
2000-04-07	FMAR	ETF	5.69	6.5	5.6891	5.69	4700.0
2000-04-07	GLDB	ETF	6.2813	6.5	6.125	6.5	139000.0
2000-04-07	GSIG	ETF	19.22	19.69	18.75	19.5	526500.0
2000-04-07	IGLD	ETF	1862.5	1900.0	1800.0	1825.0	2092.0
2000-04-07	KTEC	ETF	9.0	9.75	8.90625	9.25	11400.0
2000-04-07	MDY	ETF	90.0625	90.3125	89.4375	90.0	453100.0
2000-04-07	MIG	ETF	5.8125	5.8125	5.6875	5.8125	3600.0
2000-04-07	PPH	ETF	44.75	45.4375	44.4375	44.7188	185800.0
2000-04-07	SFY	ETF	16.9375	17.75	16.9375	17.375	85300.0
2000-04-07	TDSC	ETF	5.0	5.19	5.0	5.19	90400.0
2000-04-07	TINY	ETF	17.19	18.5	16.56	17.12	191000.0
2000-04-07	XLB	ETF	11.75	11.75	11.4375	11.4375	87400.0
2000-04-07	XLE	ETF	14.6562	14.6875	14.4062	14.4297	510800.0
2000-04-07	XLF	ETF	20.0295	20.0295	19.4456	19.4963	783408.0
2000-04-07	XLI	ETF	29.3906	29.6875	29.2969	29.5781	136600.0
2000-04-07	XLK	ETF	29.6562	30.3125	29.4375	30.2812	466000.0
2000-04-07	XLP	ETF	22.2812	22.3125	21.75	21.8125	169700.0
2000-04-07	XLU	ETF	13.961	13.961	13.7578	13.8672	339400.0
2000-04-07	XLV	ETF	30.8125	30.9062	30.5469	30.7656	6000.0
2000-04-07	XLY	ETF	15.1562	15.25	15.0625	15.0625	111400.0

> showing 48 of 48 rows — these rows as CSV

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