PREVIEW / etf_daily / 2000-05-16

all etf daily files

  file:    by_date/etf_daily/2000/2000-05-16.parquet
  size:    7 KB
  rows:    49

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-05-16	SPY	ETF	146.5625	147.7188	145.3125	146.6875	8192200.0
2000-05-16	QQQ	ETF	90.0	91.5	88.0625	90.8125	23828900.0
2000-05-16	DIA	ETF	108.875	109.7812	108.1875	109.3125	1155300.0
2000-05-16	BBH	ETF	49.3333	49.875	48.0417	49.7917	3001200.0
2000-05-16	BITS	ETF	25.75	26.5	24.25	25.75	66875.0
2000-05-16	BOSS	ETF	15.4	15.4	15.2	15.3	200.0
2000-05-16	CEF	ETF	3.4375	3.4375	3.4375	3.4375	18400.0
2000-05-16	CHB	ETF	6.63	6.69	6.38	6.63	83600.0
2000-05-16	CNXT	ETF	46.94	48.5	46.56	48.31	8078880.0
2000-05-16	CSB	ETF	4.0	4.0	4.0	4.0	5000.0
2000-05-16	EWA	ETF	9.5	9.6875	9.5	9.6875	29300.0
2000-05-16	EWC	ETF	18.0625	18.375	18.0625	18.25	16500.0
2000-05-16	EWD	ETF	32.75	32.8125	32.5	32.75	12100.0
2000-05-16	EWG	ETF	24.3125	24.75	24.3125	24.75	37300.0
2000-05-16	EWH	ETF	12.3125	12.375	12.125	12.25	79800.0
2000-05-16	EWI	ETF	48.25	48.375	48.125	48.375	4500.0
2000-05-16	EWJ	ETF	60.0	60.5	59.75	60.0	134825.0
2000-05-16	EWK	ETF	12.8125	12.8125	12.625	12.625	1700.0
2000-05-16	EWL	ETF	15.625	15.625	15.4375	15.5625	49000.0
2000-05-16	EWM	ETF	27.25	27.5	27.25	27.5	13950.0
2000-05-16	EWN	ETF	23.625	23.75	23.5	23.6875	11000.0
2000-05-16	EWO	ETF	7.375	7.5625	7.375	7.5625	1400.0
2000-05-16	EWP	ETF	26.125	26.1875	25.8125	26.0625	3300.0
2000-05-16	EWQ	ETF	27.4375	27.75	27.375	27.75	17300.0
2000-05-16	EWS	ETF	14.375	14.625	14.25	14.5	45300.0
2000-05-16	EWU	ETF	38.25	38.25	37.75	38.0	30000.0
2000-05-16	EWW	ETF	16.0	16.0	15.75	15.75	9700.0
2000-05-16	EWY	ETF	19.8125	19.8125	19.8125	19.8125	300.0
2000-05-16	FCTR	ETF	16.625	16.75	15.375	16.125	44100.0
2000-05-16	FMAR	ETF	6.03	6.25	6.03	6.25	1100.0
2000-05-16	GLDB	ETF	6.0	6.25	5.875	6.1563	33300.0
2000-05-16	GSIG	ETF	23.94	23.94	23.25	23.44	1252900.0
2000-05-16	IGLD	ETF	1087.5	1087.5	1000.0	1018.75	716.0
2000-05-16	KTEC	ETF	8.0625	8.3125	8.0	8.125	28200.0
2000-05-16	MDY	ETF	89.75	90.4062	89.0	89.9062	696200.0
2000-05-16	MIG	ETF	5.375	5.5	5.375	5.5	4400.0
2000-05-16	PPH	ETF	49.25	49.25	48.3438	48.9062	169000.0
2000-05-16	SFY	ETF	23.25	24.3125	23.25	23.9375	345400.0
2000-05-16	TDSC	ETF	4.97	5.06	4.81	4.94	107400.0
2000-05-16	TINY	ETF	8.25	8.31	7.88	8.06	92300.0
2000-05-16	XLB	ETF	11.875	11.8906	11.6094	11.6562	2446000.0
2000-05-16	XLE	ETF	16.0	16.0625	15.6875	15.8203	1860800.0
2000-05-16	XLF	ETF	20.2198	20.3976	19.9279	20.0929	217272.0
2000-05-16	XLI	ETF	30.625	31.0625	30.625	30.875	10500.0
2000-05-16	XLK	ETF	26.125	26.375	25.6406	26.2969	816000.0
2000-05-16	XLP	ETF	23.9688	23.9688	23.5	23.7812	1201000.0
2000-05-16	XLU	ETF	14.3125	14.4062	14.1719	14.289	1812800.0
2000-05-16	XLV	ETF	29.8438	30.1562	29.8438	30.0	11200.0
2000-05-16	XLY	ETF	14.625	14.625	14.375	14.5	15400.0

> showing 49 of 49 rows — these rows as CSV

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