PREVIEW / etf_daily / 2000-05-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-05-18.parquet
  size:    6 KB
  rows:    46

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-18	SPY	ETF	145.625	146.3125	143.375	143.375	4325600.0
2000-05-18	QQQ	ETF	89.0	89.3594	85.375	85.75	19063000.0
2000-05-18	DIA	ETF	108.0156	108.8125	107.4062	107.4375	931300.0
2000-05-18	BBH	ETF	48.6667	48.6667	46.75	46.8125	769800.0
2000-05-18	BITS	ETF	26.0	26.75	24.5	25.125	23550.0
2000-05-18	CEF	ETF	3.4375	3.4375	3.4375	3.4375	5500.0
2000-05-18	CHB	ETF	6.31	6.44	6.13	6.25	56200.0
2000-05-18	CNXT	ETF	47.38	48.25	42.99	43.75	5644040.0
2000-05-18	EWA	ETF	9.4375	9.4375	9.1875	9.1875	14600.0
2000-05-18	EWD	ETF	32.4375	32.4375	32.1875	32.375	1000.0
2000-05-18	EWG	ETF	23.6875	23.6875	23.3125	23.3125	104600.0
2000-05-18	EWH	ETF	11.9375	11.9375	11.6875	11.75	32200.0
2000-05-18	EWI	ETF	47.0	47.0	46.5	46.5	2600.0
2000-05-18	EWJ	ETF	59.0	59.25	58.5	58.75	81900.0
2000-05-18	EWK	ETF	12.6875	12.6875	12.5625	12.5625	400.0
2000-05-18	EWL	ETF	15.0625	15.375	15.0625	15.3125	19800.0
2000-05-18	EWM	ETF	28.0	28.25	28.0	28.0	30500.0
2000-05-18	EWN	ETF	23.4375	23.4375	23.0625	23.3125	600.0
2000-05-18	EWO	ETF	7.5	7.5	7.5	7.5	1100.0
2000-05-18	EWP	ETF	25.5	25.5	25.125	25.4375	1400.0
2000-05-18	EWQ	ETF	27.0625	27.0625	26.75	26.75	73300.0
2000-05-18	EWS	ETF	14.375	14.375	13.75	13.75	19850.0
2000-05-18	EWU	ETF	37.0	37.125	36.5	36.5	78800.0
2000-05-18	EWW	ETF	15.5	15.5	15.0	15.125	42700.0
2000-05-18	EWY	ETF	19.3125	19.3125	19.25	19.25	800.0
2000-05-18	FCTR	ETF	15.0625	15.4375	15.0	15.125	40400.0
2000-05-18	FMAR	ETF	6.75	6.75	6.75	6.75	100.0
2000-05-18	GLDB	ETF	6.1563	6.1563	5.75	5.75	30400.0
2000-05-18	GSIG	ETF	23.03	23.5	22.75	23.12	445300.0
2000-05-18	IGLD	ETF	1012.5	1018.75	906.25	931.25	551.0
2000-05-18	KTEC	ETF	8.125	8.25	8.125	8.125	27900.0
2000-05-18	MDY	ETF	89.1875	89.5625	87.9375	88.9375	332400.0
2000-05-18	MIG	ETF	5.5	5.5	5.5	5.5	3200.0
2000-05-18	PPH	ETF	48.9375	49.5	48.9062	49.375	236400.0
2000-05-18	SFY	ETF	24.3125	25.25	24.1875	24.75	235700.0
2000-05-18	TDSC	ETF	4.875	5.5	4.81	5.31	293800.0
2000-05-18	TINY	ETF	7.88	8.12	7.88	7.88	17000.0
2000-05-18	XLB	ETF	11.6562	11.6953	11.5	11.5938	420400.0
2000-05-18	XLE	ETF	15.875	15.9922	15.6875	15.875	1779400.0
2000-05-18	XLF	ETF	19.8771	20.3849	19.8771	20.0041	283992.0
2000-05-18	XLI	ETF	30.7812	30.7812	30.5312	30.5312	500.0
2000-05-18	XLK	ETF	25.9375	25.9375	25.1875	25.2656	413600.0
2000-05-18	XLP	ETF	23.7188	23.9844	23.7188	23.8125	12100.0
2000-05-18	XLU	ETF	14.1875	14.3281	14.1172	14.1875	24000.0
2000-05-18	XLV	ETF	29.8125	29.8125	29.5625	29.625	2200.0
2000-05-18	XLY	ETF	14.1562	14.4375	14.1562	14.4375	3200.0

> showing 46 of 46 rows — these rows as CSV

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