PREVIEW / etf_daily / 2000-04-19

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-19.parquet
  size:    6 KB
  rows:    47

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-19	SPY	ETF	144.5	145.125	142.5312	143.125	6553700.0
2000-04-19	QQQ	ETF	92.5	93.625	89.0625	89.1875	28082500.0
2000-04-19	DIA	ETF	107.4375	108.0625	106.3281	106.8125	1536500.0
2000-04-19	BBH	ETF	49.2292	49.2292	46.6042	46.8542	1749900.0
2000-04-19	BITS	ETF	28.0	29.75	22.5	23.25	53275.0
2000-04-19	CEF	ETF	3.375	3.4375	3.375	3.4375	17800.0
2000-04-19	CHB	ETF	6.06	6.06	6.0	6.06	517100.0
2000-04-19	CNXT	ETF	57.75	59.56	54.25	57.25	4939460.0
2000-04-19	CSB	ETF	4.0	4.0	4.0	4.0	1000.0
2000-04-19	EWA	ETF	9.875	9.875	9.75	9.875	2400.0
2000-04-19	EWC	ETF	17.75	17.75	17.75	17.75	300.0
2000-04-19	EWD	ETF	32.875	32.875	32.5625	32.8125	7500.0
2000-04-19	EWG	ETF	25.1875	25.1875	24.8125	24.875	71300.0
2000-04-19	EWH	ETF	12.5625	12.5625	12.375	12.4375	14100.0
2000-04-19	EWI	ETF	46.625	46.625	45.75	45.75	3850.0
2000-04-19	EWJ	ETF	61.0	61.25	60.25	60.25	71950.0
2000-04-19	EWK	ETF	13.125	13.125	13.0	13.0	4600.0
2000-04-19	EWL	ETF	15.0	15.25	14.9375	15.1875	18300.0
2000-04-19	EWM	ETF	25.0	25.0	24.25	24.5	30125.0
2000-04-19	EWN	ETF	23.1875	23.4375	23.0	23.0	8700.0
2000-04-19	EWO	ETF	7.75	7.75	7.75	7.75	11600.0
2000-04-19	EWP	ETF	27.25	27.4375	27.125	27.25	1000.0
2000-04-19	EWQ	ETF	26.875	27.0625	26.6875	26.6875	9000.0
2000-04-19	EWS	ETF	14.625	14.75	14.5	14.5	32150.0
2000-04-19	EWU	ETF	39.0	39.125	38.625	39.0	26550.0
2000-04-19	EWW	ETF	16.1875	16.3125	16.0	16.0625	23100.0
2000-04-19	FCTR	ETF	13.0	13.75	13.0	13.375	34100.0
2000-04-19	FMAR	ETF	5.5	6.6312	5.3794	6.19	11300.0
2000-04-19	GLDB	ETF	6.0	6.25	5.875	6.125	37900.0
2000-04-19	GSIG	ETF	16.12	17.25	15.87	17.06	508300.0
2000-04-19	IGLD	ETF	1250.0	1300.0	1187.5	1200.0	835.0
2000-04-19	KTEC	ETF	9.15625	9.5	9.125	9.5	19100.0
2000-04-19	MDY	ETF	85.25	85.5	84.0	84.625	613100.0
2000-04-19	MIG	ETF	5.25	5.25	5.25	5.25	1000.0
2000-04-19	PPH	ETF	46.9688	48.125	45.0	46.9375	737800.0
2000-04-19	SFY	ETF	19.0625	19.0625	18.5	18.8125	36500.0
2000-04-19	TDSC	ETF	4.81	4.875	4.625	4.875	40600.0
2000-04-19	TINY	ETF	11.69	12.0	10.75	11.06	134100.0
2000-04-19	XLB	ETF	11.1562	11.2734	10.8906	10.9766	55000.0
2000-04-19	XLE	ETF	14.0	14.3047	14.0	14.2812	755600.0
2000-04-19	XLF	ETF	19.0141	19.1663	18.6332	18.8871	218626.0
2000-04-19	XLI	ETF	28.4531	28.6875	28.25	28.4844	13700.0
2000-04-19	XLK	ETF	27.125	27.5625	26.625	26.6719	710600.0
2000-04-19	XLP	ETF	22.6094	23.0	22.25	22.7656	39500.0
2000-04-19	XLU	ETF	13.6953	13.7656	13.6406	13.7656	14400.0
2000-04-19	XLV	ETF	29.1875	29.5	29.0938	29.4688	7200.0
2000-04-19	XLY	ETF	14.2031	14.4844	14.2031	14.4219	16800.0

> showing 47 of 47 rows — these rows as CSV

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