PREVIEW / etf_daily / 2000-03-15

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-15.parquet
  size:    7 KB
  rows:    48

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-15	SPY	ETF	136.875	140.4375	136.0625	139.8125	10300800.0
2000-03-15	QQQ	ETF	53.25	53.5	50.9375	51.4375	51202600.0
2000-03-15	DIA	ETF	98.625	101.9844	97.6562	101.625	2040200.0
2000-03-15	BBH	ETF	60.3333	61.375	58.3333	59.0	4059900.0
2000-03-15	BITS	ETF	45.75	48.0	43.5	47.5	50275.0
2000-03-15	BOSS	ETF	11.4	11.4	11.4	11.4	200.0
2000-03-15	CEF	ETF	3.625	3.6875	3.625	3.625	5800.0
2000-03-15	CHB	ETF	5.88	6.0	5.69	5.94	69900.0
2000-03-15	CNXT	ETF	86.31	86.37	79.86	81.44	6289490.0
2000-03-15	CSB	ETF	4.0	4.0	4.0	4.0	5300.0
2000-03-15	EWA	ETF	10.0	10.25	10.0	10.125	6500.0
2000-03-15	EWC	ETF	17.25	17.5	17.25	17.5	10700.0
2000-03-15	EWD	ETF	34.3125	34.5625	33.6875	34.5625	21900.0
2000-03-15	EWG	ETF	26.6875	27.0	26.4375	27.0	97600.0
2000-03-15	EWH	ETF	13.25	13.5	13.1875	13.4375	54100.0
2000-03-15	EWI	ETF	50.875	51.25	50.375	50.375	3200.0
2000-03-15	EWJ	ETF	57.5	58.5	57.5	58.5	187375.0
2000-03-15	EWK	ETF	12.9375	12.9375	12.6875	12.6875	500.0
2000-03-15	EWL	ETF	14.125	14.5	14.0625	14.5	9900.0
2000-03-15	EWM	ETF	27.25	27.5	27.0	27.5	40800.0
2000-03-15	EWN	ETF	23.0	23.25	22.875	23.25	9000.0
2000-03-15	EWO	ETF	7.75	7.75	7.75	7.75	1300.0
2000-03-15	EWP	ETF	28.75	29.1875	28.5	29.0	5100.0
2000-03-15	EWQ	ETF	27.6875	27.9375	27.5625	27.9375	7900.0
2000-03-15	EWS	ETF	13.75	14.0	13.625	14.0	37550.0
2000-03-15	EWU	ETF	39.625	40.0	39.0	39.625	44500.0
2000-03-15	EWW	ETF	18.9375	19.3125	18.6875	19.25	31500.0
2000-03-15	FCTR	ETF	12.75	13.4375	12.0	13.0	47200.0
2000-03-15	FMAR	ETF	5.87	6.25	5.87	6.25	3200.0
2000-03-15	GLDB	ETF	6.4688	6.5625	6.25	6.5	67700.0
2000-03-15	GSIG	ETF	19.06	19.12	16.5	17.19	1171000.0
2000-03-15	IGLD	ETF	2712.5	2775.0	2625.0	2662.5	802.0
2000-03-15	KTEC	ETF	9.1875	9.1875	9.0	9.125	1400.0
2000-03-15	MDY	ETF	84.0625	84.9688	83.0	84.125	853900.0
2000-03-15	MIG	ETF	5.0	5.125	5.0	5.125	1300.0
2000-03-15	PPH	ETF	38.9375	41.7188	38.9375	41.4688	578400.0
2000-03-15	SFY	ETF	11.6875	12.0	11.625	11.75	60900.0
2000-03-15	TDSC	ETF	5.405	5.44	5.125	5.28	281600.0
2000-03-15	TINY	ETF	30.5	31.12	28.0	28.38	357900.0
2000-03-15	XLB	ETF	10.086	11.25	10.086	10.7734	889200.0
2000-03-15	XLE	ETF	13.6953	13.875	13.5781	13.7812	839000.0
2000-03-15	XLF	ETF	16.4754	17.4655	16.247	17.3894	1206626.0
2000-03-15	XLI	ETF	24.9375	26.3438	24.9062	26.2656	121300.0
2000-03-15	XLK	ETF	29.0	29.0938	28.125	28.2656	1238600.0
2000-03-15	XLP	ETF	19.1719	20.4688	19.0312	20.375	1582200.0
2000-03-15	XLU	ETF	12.625	12.9766	12.6094	12.8125	427000.0
2000-03-15	XLV	ETF	27.8438	28.0625	27.5625	27.8438	42200.0
2000-03-15	XLY	ETF	12.4062	13.25	12.2812	13.1562	1443600.0

> showing 48 of 48 rows — these rows as CSV

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