PREVIEW / etf_daily / 2000-01-20

all etf daily files

  file:    by_date/etf_daily/2000/2000-01-20.parquet
  size:    6 KB
  rows:    45

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-01-20	SPY	ETF	146.9688	146.9688	143.8125	144.75	5800100.0
2000-01-20	DIA	ETF	115.9375	115.9688	112.6562	113.7344	887000.0
2000-01-20	BBH	ETF	56.0	58.25	55.1667	58.1667	1862700.0
2000-01-20	BITS	ETF	23.75	25.0	22.25	23.0	44875.0
2000-01-20	BOSS	ETF	10.8	11.0	10.8	10.93	1000.0
2000-01-20	CEF	ETF	3.4375	3.5625	3.4375	3.5625	41900.0
2000-01-20	CHB	ETF	8.19	8.25	8.13	8.19	75400.0
2000-01-20	CNXT	ETF	81.44	81.5	73.5	76.81	8402500.0
2000-01-20	EWA	ETF	11.1875	11.1875	10.9375	11.0625	6700.0
2000-01-20	EWC	ETF	16.6875	16.875	16.6875	16.875	6400.0
2000-01-20	EWD	ETF	30.375	30.5	30.375	30.5	400.0
2000-01-20	EWG	ETF	26.9375	27.375	26.8125	27.375	250100.0
2000-01-20	EWH	ETF	12.9375	12.9375	12.75	12.8125	45400.0
2000-01-20	EWI	ETF	49.25	49.75	48.875	49.375	4150.0
2000-01-20	EWJ	ETF	60.25	60.5	59.5	60.0	98350.0
2000-01-20	EWK	ETF	14.6875	14.6875	14.5625	14.5625	1400.0
2000-01-20	EWL	ETF	15.5625	15.8125	15.5	15.8125	22200.0
2000-01-20	EWM	ETF	32.0	32.5	31.5	32.0	37225.0
2000-01-20	EWN	ETF	24.0625	24.3125	24.0625	24.3125	2100.0
2000-01-20	EWO	ETF	8.6875	8.6875	8.375	8.375	2100.0
2000-01-20	EWP	ETF	27.1875	27.25	27.0625	27.0625	11500.0
2000-01-20	EWQ	ETF	26.625	26.625	26.1875	26.625	18100.0
2000-01-20	EWS	ETF	17.375	17.375	17.0	17.0	16950.0
2000-01-20	EWU	ETF	40.75	40.75	40.0	40.375	33550.0
2000-01-20	EWW	ETF	18.0625	18.3125	17.5	17.5	94400.0
2000-01-20	FCTR	ETF	14.875	14.875	14.5	14.5	31700.0
2000-01-20	FMAR	ETF	7.35	7.6	7.35	7.35	4810.0
2000-01-20	GLDB	ETF	9.0	9.0	8.375	8.375	57000.0
2000-01-20	GSIG	ETF	12.06	12.87	12.0	12.12	749900.0
2000-01-20	IGLD	ETF	2068.75	2268.75	2050.0	2243.75	2928.0
2000-01-20	KTEC	ETF	9.28125	9.625	9.28125	9.5	7300.0
2000-01-20	MDY	ETF	83.5625	83.6875	82.1875	83.0	853200.0
2000-01-20	MIG	ETF	7.0	7.0	6.5	6.5	12300.0
2000-01-20	SFY	ETF	12.5625	12.8125	12.0	12.125	108200.0
2000-01-20	TDSC	ETF	4.115	4.25	3.875	4.11	108200.0
2000-01-20	TINY	ETF	10.75	11.0	10.31	10.56	152800.0
2000-01-20	XLB	ETF	12.8438	12.8438	12.375	12.375	198800.0
2000-01-20	XLE	ETF	14.2031	14.2031	13.9688	14.1562	688600.0
2000-01-20	XLF	ETF	18.8617	18.8617	18.2778	18.3794	588172.0
2000-01-20	XLI	ETF	29.0	29.0	28.375	28.6875	49600.0
2000-01-20	XLK	ETF	27.125	27.2188	26.5625	26.7812	2191200.0
2000-01-20	XLP	ETF	24.0469	24.0469	23.3906	23.5938	425500.0
2000-01-20	XLU	ETF	13.461	13.5781	13.4297	13.5	225000.0
2000-01-20	XLV	ETF	32.4062	32.5	31.875	32.0	64200.0
2000-01-20	XLY	ETF	15.0312	15.0312	14.6719	14.75	322800.0

> showing 45 of 45 rows — these rows as CSV

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