PREVIEW / etf_daily / 2000-04-06

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-06.parquet
  size:    6 KB
  rows:    46

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-06	SPY	ETF	150.25	151.6875	149.0	150.4844	6378500.0
2000-04-06	QQQ	ETF	102.375	103.875	99.75	102.5	30499900.0
2000-04-06	DIA	ETF	111.375	112.2188	110.375	111.4219	2279700.0
2000-04-06	BBH	ETF	61.0	61.25	56.8333	58.75	3187500.0
2000-04-06	BITS	ETF	41.5	43.0	40.25	42.25	27325.0
2000-04-06	CEF	ETF	3.5	3.5	3.4375	3.4375	33800.0
2000-04-06	CHB	ETF	6.25	6.56	6.25	6.44	215500.0
2000-04-06	CNXT	ETF	68.37	70.81	66.62	69.37	6141650.0
2000-04-06	EWA	ETF	10.3125	10.3125	10.125	10.3125	6000.0
2000-04-06	EWC	ETF	18.0	18.375	18.0	18.375	14000.0
2000-04-06	EWD	ETF	33.4375	33.9375	33.4375	33.9375	7300.0
2000-04-06	EWG	ETF	26.5625	26.625	26.3125	26.625	32700.0
2000-04-06	EWH	ETF	13.125	13.25	13.125	13.25	65800.0
2000-04-06	EWI	ETF	49.125	49.625	49.125	49.375	1450.0
2000-04-06	EWJ	ETF	63.25	63.5	62.5	63.5	50875.0
2000-04-06	EWK	ETF	13.25	13.25	13.25	13.25	100.0
2000-04-06	EWL	ETF	15.6875	15.75	15.6875	15.75	2100.0
2000-04-06	EWM	ETF	27.0	28.5	27.0	28.0	11475.0
2000-04-06	EWN	ETF	24.0	24.0	23.6875	24.0	7800.0
2000-04-06	EWO	ETF	8.0	8.0	8.0	8.0	2400.0
2000-04-06	EWP	ETF	28.0625	28.3125	28.0625	28.3125	5200.0
2000-04-06	EWQ	ETF	27.4375	27.6875	27.4375	27.6875	23600.0
2000-04-06	EWS	ETF	14.5	14.75	14.5	14.75	54650.0
2000-04-06	EWU	ETF	40.5	40.625	40.125	40.5	11500.0
2000-04-06	EWW	ETF	18.0625	18.375	18.0625	18.3125	13900.0
2000-04-06	FCTR	ETF	13.3438	13.9375	13.0625	13.9375	56600.0
2000-04-06	FMAR	ETF	5.69	6.25	5.69	6.25	400.0
2000-04-06	GLDB	ETF	6.4375	6.5	6.3125	6.4375	125400.0
2000-04-06	GSIG	ETF	16.06	18.75	15.62	18.75	536400.0
2000-04-06	IGLD	ETF	1787.5	1887.5	1775.0	1800.0	1443.0
2000-04-06	KTEC	ETF	9.625	9.625	9.1875	9.625	12900.0
2000-04-06	MDY	ETF	88.5	89.75	87.5	89.2188	843200.0
2000-04-06	MIG	ETF	5.8125	5.8125	5.8125	5.8125	5500.0
2000-04-06	PPH	ETF	45.375	45.8438	44.3125	44.75	336000.0
2000-04-06	SFY	ETF	16.75	17.1875	16.5625	16.9375	49100.0
2000-04-06	TDSC	ETF	5.25	5.31	4.81	5.125	39800.0
2000-04-06	TINY	ETF	13.75	16.69	13.75	16.06	386100.0
2000-04-06	XLB	ETF	11.6797	11.8672	11.6172	11.625	45200.0
2000-04-06	XLE	ETF	14.3438	14.6875	14.3438	14.6562	76000.0
2000-04-06	XLF	ETF	19.9406	19.9533	19.7121	19.9025	343080.0
2000-04-06	XLI	ETF	29.2031	29.4375	29.0938	29.1406	23000.0
2000-04-06	XLK	ETF	29.375	29.7188	28.875	29.2812	346000.0
2000-04-06	XLP	ETF	22.25	22.4375	21.8281	22.0938	55100.0
2000-04-06	XLU	ETF	13.9453	14.0	13.8281	13.9062	258400.0
2000-04-06	XLV	ETF	30.2812	30.8438	30.2812	30.6875	29000.0
2000-04-06	XLY	ETF	14.8281	15.164	14.8281	15.0625	27200.0

> showing 46 of 46 rows — these rows as CSV

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