PREVIEW / etf_daily / 2000-03-29

all etf daily files

  file:    by_date/etf_daily/2000/2000-03-29.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-29	SPY	ETF	151.5625	152.4844	149.6562	151.2188	6747500.0
2000-03-29	QQQ	ETF	115.375	115.4375	110.0	110.0	27190900.0
2000-03-29	DIA	ETF	109.8438	111.2188	108.9375	110.75	1426600.0
2000-03-29	BBH	ETF	59.0833	59.5	53.9167	55.3333	2955600.0
2000-03-29	BITS	ETF	49.75	50.0	46.0	46.5	69525.0
2000-03-29	BOSS	ETF	11.4	11.401	11.4	11.401	100.0
2000-03-29	CEF	ETF	3.5	3.5625	3.5	3.5	11700.0
2000-03-29	CHB	ETF	6.44	6.5	6.06	6.06	145400.0
2000-03-29	CNXT	ETF	77.51	78.01	72.02	72.48	3553210.0
2000-03-29	EWA	ETF	10.5	10.5	10.25	10.3125	5700.0
2000-03-29	EWC	ETF	19.0625	19.0625	18.5	18.5	20800.0
2000-03-29	EWD	ETF	34.6875	34.75	34.5	34.6875	3000.0
2000-03-29	EWG	ETF	28.0625	28.125	27.625	27.75	65800.0
2000-03-29	EWH	ETF	14.0	14.0	13.8125	13.8125	50100.0
2000-03-29	EWI	ETF	51.0	51.25	50.5	50.5	13350.0
2000-03-29	EWJ	ETF	64.0	64.5	63.75	64.0	114350.0
2000-03-29	EWK	ETF	12.75	12.75	12.75	12.75	30000.0
2000-03-29	EWL	ETF	15.25	15.375	15.125	15.125	29300.0
2000-03-29	EWM	ETF	28.25	28.5	28.25	28.25	4725.0
2000-03-29	EWN	ETF	24.3125	24.3125	24.125	24.3125	4500.0
2000-03-29	EWO	ETF	7.8125	7.8125	7.75	7.75	1600.0
2000-03-29	EWP	ETF	28.9375	28.9375	28.5	28.75	6300.0
2000-03-29	EWQ	ETF	28.9375	29.0	28.5	28.75	46500.0
2000-03-29	EWS	ETF	15.625	15.75	15.375	15.5	73000.0
2000-03-29	EWU	ETF	41.125	41.25	40.5	41.0	90800.0
2000-03-29	EWW	ETF	19.3125	19.625	19.25	19.3125	60300.0
2000-03-29	FCTR	ETF	13.0	13.0	12.6875	12.6875	14800.0
2000-03-29	FMAR	ETF	6.22	6.5	5.62	6.5	10600.0
2000-03-29	GLDB	ETF	6.9688	7.125	6.9375	7.0625	140100.0
2000-03-29	GSIG	ETF	18.41	19.25	17.5	18.37	420100.0
2000-03-29	IGLD	ETF	2281.25	2343.75	2075.0	2100.0	697.0
2000-03-29	KTEC	ETF	9.0	9.0	8.875	9.0	15400.0
2000-03-29	MDY	ETF	90.25	90.25	87.5938	88.25	805500.0
2000-03-29	MIG	ETF	5.9375	5.9375	5.6875	5.6875	2800.0
2000-03-29	PPH	ETF	42.25	43.0	41.875	42.6562	169200.0
2000-03-29	SFY	ETF	15.0625	15.75	15.0625	15.4375	188200.0
2000-03-29	TDSC	ETF	5.25	5.345	5.25	5.31	135000.0
2000-03-29	TINY	ETF	20.69	21.0	18.0	19.19	265200.0
2000-03-29	XLB	ETF	11.0625	11.2266	10.9766	11.2266	55000.0
2000-03-29	XLE	ETF	13.9375	14.7812	13.9375	14.7344	465600.0
2000-03-29	XLF	ETF	19.9025	19.9025	19.3567	19.5471	237091.0
2000-03-29	XLI	ETF	28.7812	29.0625	28.5625	28.9688	5200.0
2000-03-29	XLK	ETF	31.5	31.5312	30.3906	30.5469	6663800.0
2000-03-29	XLP	ETF	20.6875	21.125	20.5625	21.0469	36200.0
2000-03-29	XLU	ETF	13.25	13.3984	13.1875	13.3203	25800.0
2000-03-29	XLV	ETF	30.7812	30.8281	30.4062	30.5625	6800.0
2000-03-29	XLY	ETF	14.3125	14.5156	14.3125	14.4688	24600.0

> showing 47 of 47 rows — these rows as CSV

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