PREVIEW / etf_daily / 2000-03-14

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-14.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-03-14	SPY	ETF	139.2812	140.0938	136.1562	136.625	8263900.0
2000-03-14	QQQ	ETF	56.375	56.6875	52.5	53.6875	39106800.0
2000-03-14	DIA	ETF	100.3125	100.6875	98.0	98.4688	854300.0
2000-03-14	BBH	ETF	65.25	65.5833	55.3333	58.5	7215600.0
2000-03-14	BITS	ETF	49.25	49.75	42.0	44.25	59550.0
2000-03-14	CEF	ETF	3.625	3.6875	3.625	3.6875	5900.0
2000-03-14	CHB	ETF	5.75	5.94	5.75	5.81	154900.0
2000-03-14	CNXT	ETF	93.0	93.5	84.5	84.56	7084100.0
2000-03-14	CSB	ETF	3.79999995231628	4.0	3.79999995231628	4.0	48600.0
2000-03-14	EWA	ETF	10.4375	10.4375	10.1875	10.4375	3900.0
2000-03-14	EWC	ETF	17.5	17.5	17.25	17.25	6900.0
2000-03-14	EWD	ETF	35.375	35.4375	35.125	35.1875	9000.0
2000-03-14	EWG	ETF	27.8125	27.8125	27.25	27.25	29200.0
2000-03-14	EWH	ETF	13.625	13.625	13.1875	13.25	35700.0
2000-03-14	EWI	ETF	53.0	53.0	52.25	52.5	5200.0
2000-03-14	EWJ	ETF	58.0	58.25	57.75	57.75	153750.0
2000-03-14	EWK	ETF	11.625	11.875	11.625	11.875	2000.0
2000-03-14	EWL	ETF	14.125	14.375	14.0625	14.125	18000.0
2000-03-14	EWM	ETF	27.5	27.75	27.5	27.5	17975.0
2000-03-14	EWN	ETF	23.1875	23.5	23.1875	23.4375	1700.0
2000-03-14	EWO	ETF	7.6875	7.6875	7.625	7.6875	8300.0
2000-03-14	EWP	ETF	29.1875	29.25	29.0	29.0	1400.0
2000-03-14	EWQ	ETF	28.375	28.5625	28.25	28.25	19400.0
2000-03-14	EWS	ETF	14.0	14.25	13.875	14.25	68450.0
2000-03-14	EWU	ETF	40.125	40.375	39.75	40.0	51350.0
2000-03-14	EWW	ETF	19.625	19.625	19.0	19.0	12900.0
2000-03-14	FCTR	ETF	13.4375	13.4375	12.375	12.75	50800.0
2000-03-14	FMAR	ETF	5.87	6.44	5.87	5.87	1800.0
2000-03-14	GLDB	ETF	6.9375	7.0	6.5	6.5	69200.0
2000-03-14	GSIG	ETF	20.62	21.62	19.12	19.12	434500.0
2000-03-14	IGLD	ETF	2887.5	2975.0	2650.0	2687.5	1618.0
2000-03-14	KTEC	ETF	8.875	9.25	8.875	9.125	15200.0
2000-03-14	MDY	ETF	87.3125	88.125	83.875	84.1875	685500.0
2000-03-14	MIG	ETF	5.125	5.125	5.0	5.0	41800.0
2000-03-14	PPH	ETF	39.8125	39.8125	38.8125	39.0	299000.0
2000-03-14	SFY	ETF	12.375	12.4375	11.5625	11.625	49100.0
2000-03-14	TDSC	ETF	6.015	6.015	5.28	5.5	144000.0
2000-03-14	TINY	ETF	31.0	31.38	27.5	27.88	242800.0
2000-03-14	XLB	ETF	10.4297	10.4297	10.0781	10.164	32800.0
2000-03-14	XLE	ETF	13.5938	13.8594	13.5	13.8438	720800.0
2000-03-14	XLF	ETF	16.3738	16.6912	16.3485	16.3866	286208.0
2000-03-14	XLI	ETF	25.75	25.75	25.1719	25.25	38600.0
2000-03-14	XLK	ETF	29.8125	30.0625	28.6562	28.7656	928400.0
2000-03-14	XLP	ETF	19.5	19.5	19.0	19.1562	552800.0
2000-03-14	XLU	ETF	12.711	12.8125	12.625	12.7422	340000.0
2000-03-14	XLV	ETF	27.8125	28.0938	27.7031	27.7031	36200.0
2000-03-14	XLY	ETF	12.4062	12.5156	12.3047	12.4062	458600.0

> showing 47 of 47 rows — these rows as CSV

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