PREVIEW / etf_daily / 2000-01-21

all etf daily files

  file:    by_date/etf_daily/2000/2000-01-21.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-21	SPY	ETF	145.5	145.5	144.0625	144.4375	6244800.0
2000-01-21	DIA	ETF	114.1875	114.1875	112.3125	112.8125	783200.0
2000-01-21	BBH	ETF	59.2083	60.9167	58.25	60.9167	3705000.0
2000-01-21	BITS	ETF	23.0	23.25	20.75	21.25	49825.0
2000-01-21	BOSS	ETF	10.92	10.92	10.92	10.92	100.0
2000-01-21	CEF	ETF	3.5625	3.625	3.5	3.625	15300.0
2000-01-21	CHB	ETF	8.13	8.31	8.13	8.13	104400.0
2000-01-21	CNXT	ETF	79.44	79.94	76.12	78.5	3794900.0
2000-01-21	EWA	ETF	11.0	11.125	10.9375	10.9375	3200.0
2000-01-21	EWC	ETF	16.8125	16.8125	16.8125	16.8125	900.0
2000-01-21	EWD	ETF	30.25	30.25	30.0625	30.25	4700.0
2000-01-21	EWG	ETF	26.8125	26.9375	26.0	26.5625	49200.0
2000-01-21	EWH	ETF	12.8125	12.9375	12.75	12.75	82100.0
2000-01-21	EWI	ETF	49.125	49.25	49.0	49.25	950.0
2000-01-21	EWJ	ETF	60.5	60.75	59.75	59.75	165850.0
2000-01-21	EWK	ETF	14.5625	14.5625	14.5	14.5	1100.0
2000-01-21	EWL	ETF	15.8125	15.8125	15.5	15.5	1700.0
2000-01-21	EWM	ETF	32.0	32.0	31.5	31.5	49475.0
2000-01-21	EWN	ETF	23.875	24.1875	23.875	24.1875	500.0
2000-01-21	EWO	ETF	8.3125	8.5	8.3125	8.3125	6500.0
2000-01-21	EWP	ETF	27.0	27.0	26.75	26.75	2800.0
2000-01-21	EWQ	ETF	26.5	26.5	26.0	26.125	16000.0
2000-01-21	EWS	ETF	17.0	17.25	16.875	17.125	25000.0
2000-01-21	EWU	ETF	40.25	40.625	40.25	40.625	25650.0
2000-01-21	EWW	ETF	17.625	17.625	17.4375	17.5	7900.0
2000-01-21	FCTR	ETF	14.8125	14.8125	13.9375	13.9375	31400.0
2000-01-21	FMAR	ETF	7.35	7.35	6.9754	7.1	4300.0
2000-01-21	GLDB	ETF	8.5	8.75	8.25	8.5625	35600.0
2000-01-21	GSIG	ETF	12.44	13.87	12.25	12.81	860600.0
2000-01-21	IGLD	ETF	2237.5	2250.0	2143.75	2200.0	1569.0
2000-01-21	KTEC	ETF	9.6875	11.1875	9.5	10.25	63000.0
2000-01-21	MDY	ETF	83.5	83.5469	82.5312	83.0	302000.0
2000-01-21	MIG	ETF	6.375	6.375	6.375	6.375	2500.0
2000-01-21	SFY	ETF	12.1875	12.5625	12.1875	12.5	250200.0
2000-01-21	TDSC	ETF	3.94	4.125	3.94	4.11	97400.0
2000-01-21	TINY	ETF	10.78	11.19	10.5	10.94	138400.0
2000-01-21	XLB	ETF	12.5625	12.5625	12.2812	12.4297	360200.0
2000-01-21	XLE	ETF	14.4688	14.6172	14.3906	14.5469	966600.0
2000-01-21	XLF	ETF	18.4809	18.4809	18.0494	18.1509	498309.0
2000-01-21	XLI	ETF	28.6562	28.7656	28.3281	28.3281	45700.0
2000-01-21	XLK	ETF	26.9375	26.9375	26.5703	26.8125	2869400.0
2000-01-21	XLP	ETF	23.7344	23.7344	23.125	23.3281	345000.0
2000-01-21	XLU	ETF	13.7812	13.9531	13.6875	13.9375	402200.0
2000-01-21	XLV	ETF	31.875	32.0469	31.6875	31.9375	37300.0
2000-01-21	XLY	ETF	14.7656	14.7656	14.4453	14.4453	340400.0

> showing 45 of 45 rows — these rows as CSV

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