PREVIEW / etf_daily / 2000-04-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-18.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-18	SPY	ETF	140.5625	144.4688	139.7812	144.4688	11069200.0
2000-04-18	QQQ	ETF	89.4844	93.0	87.375	92.0	36261900.0
2000-04-18	DIA	ETF	106.4688	107.7812	105.8906	107.0625	1576900.0
2000-04-18	BBH	ETF	46.6667	49.1458	45.5	49.0	2399100.0
2000-04-18	BITS	ETF	20.25	26.25	20.0	26.25	68600.0
2000-04-18	BOSS	ETF	14.0	14.0	14.0	14.0	200.0
2000-04-18	CEF	ETF	3.375	3.4375	3.375	3.4375	8800.0
2000-04-18	CHB	ETF	6.06	6.13	6.0	6.06	186700.0
2000-04-18	CNXT	ETF	53.7	58.44	52.0	56.94	5321250.0
2000-04-18	EWA	ETF	9.4375	9.6875	9.4375	9.4375	1600.0
2000-04-18	EWC	ETF	17.0	17.5	17.0	17.375	3600.0
2000-04-18	EWD	ETF	31.875	31.9375	31.5625	31.9375	5200.0
2000-04-18	EWG	ETF	25.25	25.625	25.125	25.375	68000.0
2000-04-18	EWH	ETF	12.375	12.6875	12.25	12.5625	48400.0
2000-04-18	EWI	ETF	46.375	46.875	46.375	46.875	15650.0
2000-04-18	EWJ	ETF	60.5	61.0	60.25	60.75	71525.0
2000-04-18	EWK	ETF	13.125	13.25	13.125	13.25	1600.0
2000-04-18	EWL	ETF	15.25	15.3125	15.0625	15.125	17300.0
2000-04-18	EWM	ETF	24.5	25.5	24.0	25.0	40700.0
2000-04-18	EWN	ETF	23.25	23.4375	23.25	23.3125	10000.0
2000-04-18	EWO	ETF	7.8125	7.8125	7.8125	7.8125	700.0
2000-04-18	EWP	ETF	27.0625	27.3125	27.0	27.25	2200.0
2000-04-18	EWQ	ETF	27.0	27.0	26.5625	27.0	34700.0
2000-04-18	EWS	ETF	14.125	14.625	14.125	14.625	37750.0
2000-04-18	EWU	ETF	37.5	38.5	37.5	38.375	17300.0
2000-04-18	EWW	ETF	15.75	16.375	15.5	16.375	16200.0
2000-04-18	FCTR	ETF	12.5	13.5	12.5	13.375	24500.0
2000-04-18	FMAR	ETF	5.5	6.2532	5.4458	5.5	18390.0
2000-04-18	GLDB	ETF	5.8438	6.125	5.75	6.0	74800.0
2000-04-18	GSIG	ETF	14.12	16.0	14.12	15.81	271300.0
2000-04-18	IGLD	ETF	1112.5	1212.5	1062.5	1187.5	1217.0
2000-04-18	KTEC	ETF	8.25	9.3125	8.25	9.3125	22000.0
2000-04-18	MDY	ETF	82.25	85.125	81.5625	85.125	2134800.0
2000-04-18	MIG	ETF	5.25	5.3125	5.0	5.3125	9700.0
2000-04-18	PPH	ETF	45.5312	46.9062	45.5	46.5938	165800.0
2000-04-18	SFY	ETF	19.0	19.5	18.9375	19.0625	91000.0
2000-04-18	TDSC	ETF	4.31	4.875	4.25	4.81	114800.0
2000-04-18	TINY	ETF	9.0	11.5	8.94	11.31	325800.0
2000-04-18	XLB	ETF	11.2656	11.3516	11.0	11.1172	48000.0
2000-04-18	XLE	ETF	13.8125	14.0234	13.8125	13.9766	159200.0
2000-04-18	XLF	ETF	18.3286	19.2933	18.3286	19.1409	909586.0
2000-04-18	XLI	ETF	28.25	28.5156	28.1875	28.375	10700.0
2000-04-18	XLK	ETF	26.3125	27.5781	26.0625	27.5781	1146400.0
2000-04-18	XLP	ETF	22.0	22.5	22.0	22.5	129000.0
2000-04-18	XLU	ETF	13.625	13.7969	13.625	13.6406	95200.0
2000-04-18	XLV	ETF	27.8906	28.7188	27.8906	28.7188	50900.0
2000-04-18	XLY	ETF	13.9375	14.3594	13.8594	14.3125	104200.0

> showing 47 of 47 rows — these rows as CSV

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