PREVIEW / etf_daily / 2000-04-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-04-27.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-27	SPY	ETF	143.0	147.3438	143.0	146.0	15595300.0
2000-04-27	QQQ	ETF	83.5	92.4844	82.25	91.25	37036300.0
2000-04-27	DIA	ETF	107.0938	109.5	107.0938	108.375	1656700.0
2000-04-27	BBH	ETF	42.6667	43.1667	41.8333	42.5833	1188300.0
2000-04-27	BITS	ETF	21.0	25.0	20.25	24.5	52875.0
2000-04-27	BOSS	ETF	14.2	14.5	14.2	14.2	100.0
2000-04-27	CEF	ETF	3.5	3.5	3.4375	3.4375	6500.0
2000-04-27	CHB	ETF	7.06	7.25	7.0	7.0	85200.0
2000-04-27	CNXT	ETF	54.39	61.38	53.0	60.44	4450050.0
2000-04-27	EWA	ETF	9.6875	9.875	9.6875	9.6875	1500.0
2000-04-27	EWC	ETF	17.75	17.9375	17.75	17.875	11800.0
2000-04-27	EWD	ETF	32.625	32.625	32.625	32.625	100.0
2000-04-27	EWG	ETF	24.125	24.5	24.125	24.5	44800.0
2000-04-27	EWH	ETF	12.125	12.5	12.125	12.5	31800.0
2000-04-27	EWI	ETF	45.875	45.875	45.5	45.875	3450.0
2000-04-27	EWJ	ETF	60.5	61.25	60.25	60.75	71350.0
2000-04-27	EWK	ETF	12.3125	12.4375	12.1875	12.4375	5500.0
2000-04-27	EWL	ETF	14.625	14.875	14.5625	14.75	47100.0
2000-04-27	EWM	ETF	24.0	24.75	24.0	24.75	7525.0
2000-04-27	EWN	ETF	22.9375	22.9375	22.625	22.625	15700.0
2000-04-27	EWO	ETF	7.6875	7.6875	7.6875	7.6875	1500.0
2000-04-27	EWP	ETF	26.5	26.5	26.125	26.125	5300.0
2000-04-27	EWQ	ETF	26.1875	26.375	26.125	26.375	8400.0
2000-04-27	EWS	ETF	14.625	15.0	14.5	14.875	34700.0
2000-04-27	EWU	ETF	38.5	39.0	38.25	39.0	6700.0
2000-04-27	EWW	ETF	15.875	16.6875	15.875	16.4375	19600.0
2000-04-27	FCTR	ETF	13.75	14.0	13.6875	13.9375	21300.0
2000-04-27	FMAR	ETF	5.25	5.38	5.25	5.38	3400.0
2000-04-27	GLDB	ETF	6.2188	6.3125	6.0625	6.1875	74900.0
2000-04-27	GSIG	ETF	16.75	18.06	16.62	18.06	499900.0
2000-04-27	IGLD	ETF	1093.75	1162.5	1093.75	1112.5	205.0
2000-04-27	KTEC	ETF	9.375	9.375	8.1875	8.375	138000.0
2000-04-27	MDY	ETF	84.875	87.25	84.4375	87.25	896800.0
2000-04-27	MIG	ETF	5.1875	5.625	5.1875	5.625	5000.0
2000-04-27	PPH	ETF	46.8125	47.9688	46.8125	47.5625	154800.0
2000-04-27	SFY	ETF	19.625	20.625	19.0	20.375	96000.0
2000-04-27	TDSC	ETF	5.19	5.345	5.155	5.19	70200.0
2000-04-27	TINY	ETF	10.44	11.19	9.75	10.88	83200.0
2000-04-27	XLB	ETF	11.0938	11.2031	11.0	11.0547	128800.0
2000-04-27	XLE	ETF	14.5625	14.8906	14.5078	14.875	55000.0
2000-04-27	XLF	ETF	19.2933	19.6741	19.1536	19.4963	170247.0
2000-04-27	XLI	ETF	29.3594	29.8281	29.3594	29.8281	6500.0
2000-04-27	XLK	ETF	26.1875	27.5	26.1875	27.4219	963400.0
2000-04-27	XLP	ETF	22.7031	23.0	22.6719	23.0	27900.0
2000-04-27	XLU	ETF	14.4375	14.5469	14.25	14.25	22200.0
2000-04-27	XLV	ETF	29.625	30.1875	29.625	30.0312	5200.0
2000-04-27	XLY	ETF	14.6562	14.7031	14.5312	14.7031	6600.0

> showing 47 of 47 rows — these rows as CSV

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