PREVIEW / etf_daily / 2000-09-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-09-27.parquet
  size:    8 KB
  rows:    82

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-09-27	SPY	ETF	143.5625	143.9688	142.125	143.1562	7186200.0
2000-09-27	QQQ	ETF	90.625	91.1875	88.0	89.5625	28482900.0
2000-09-27	IWM	ETF	51.1562	51.4062	50.5	50.6875	43600.0
2000-09-27	DIA	ETF	106.875	106.9062	105.7812	106.5156	612500.0
2000-09-27	BBH	ETF	65.375	66.25	64.2083	64.8333	2449800.0
2000-09-27	BITS	ETF	15.0	15.5	15.0	15.0	6625.0
2000-09-27	BOSS	ETF	19.5	20.001	19.3	20.001	600.0
2000-09-27	CEF	ETF	3.25	3.375	3.25	3.25	52100.0
2000-09-27	CHB	ETF	4.31	4.44	4.19	4.38	56900.0
2000-09-27	CNXT	ETF	42.06	43.69	40.68	41.25	2956590.0
2000-09-27	EWA	ETF	9.625	9.625	9.4375	9.5625	12700.0
2000-09-27	EWC	ETF	16.4375	16.4375	15.875	15.875	14200.0
2000-09-27	EWD	ETF	22.3125	22.3125	22.0625	22.0625	300.0
2000-09-27	EWG	ETF	19.3125	19.5	19.1875	19.3125	47600.0
2000-09-27	EWH	ETF	11.6875	11.875	11.6875	11.75	72500.0
2000-09-27	EWI	ETF	43.125	43.125	42.5	42.75	400.0
2000-09-27	EWJ	ETF	52.5	52.5	52.0	52.25	74975.0
2000-09-27	EWK	ETF	12.4375	12.4375	12.4375	12.4375	500.0
2000-09-27	EWL	ETF	15.125	15.1875	14.9375	15.1875	4500.0
2000-09-27	EWM	ETF	21.25	21.5	21.25	21.25	12150.0
2000-09-27	EWN	ETF	22.4375	22.625	22.3125	22.625	2400.0
2000-09-27	EWO	ETF	7.625	7.625	7.625	7.625	400.0
2000-09-27	EWP	ETF	24.375	24.375	24.0625	24.0625	1600.0
2000-09-27	EWQ	ETF	25.25	25.25	24.8125	25.0	42100.0
2000-09-27	EWS	ETF	13.5	13.5	13.375	13.375	9000.0
2000-09-27	EWT	ETF	29.25	29.375	29.25	29.375	10200.0
2000-09-27	EWU	ETF	35.875	35.875	35.125	35.5	21100.0
2000-09-27	EWW	ETF	15.4375	15.625	15.1875	15.1875	24900.0
2000-09-27	EWY	ETF	15.75	16.0	15.75	15.8125	13600.0
2000-09-27	EWZ	ETF	17.9375	17.9375	17.9375	17.9375	100.0
2000-09-27	EZU	ETF	36.5312	36.5625	36.0625	36.25	33800.0
2000-09-27	FCTR	ETF	14.125	14.625	14.125	14.125	23800.0
2000-09-27	FMAR	ETF	4.94	5.0	4.75	4.75	7300.0
2000-09-27	GLDB	ETF	5.0313	5.0625	4.8125	5.0	143300.0
2000-09-27	GSIG	ETF	16.87	18.12	16.62	16.62	691600.0
2000-09-27	IDU	ETF	42.6875	42.9453	41.9688	42.7969	40800.0
2000-09-27	IEV	ETF	39.1875	39.1875	38.25	38.25	9000.0
2000-09-27	IGLD	ETF	581.25	581.25	543.75	550.0	741.0
2000-09-27	IJH	ETF	10.6625	10.6734	10.5438	10.5812	2520000.0
2000-09-27	IJJ	ETF	19.2891	19.2891	19.2891	19.2891	800.0
2000-09-27	IJK	ETF	18.1055	18.1445	17.875	17.875	4800.0
2000-09-27	IJR	ETF	17.8802	17.9219	17.6875	17.7292	72600.0
2000-09-27	IJS	ETF	17.6445	17.6641	17.5977	17.6562	3200.0
2000-09-27	IJT	ETF	21.0781	21.0781	21.0781	21.0781	2800.0
2000-09-27	IVE	ETF	61.8594	61.8594	61.5469	61.7812	10600.0
2000-09-27	IVV	ETF	143.4844	143.5312	142.2969	142.7031	155200.0
2000-09-27	IVW	ETF	20.9297	20.9688	20.6094	20.6094	12000.0
2000-09-27	IWB	ETF	76.9	76.9	76.9	76.9	200.0
2000-09-27	IWD	ETF	56.8125	56.875	56.625	56.8438	8200.0
2000-09-27	IWF	ETF	20.671875	20.8203	20.4922	20.52345	18000.0

> showing 50 of 82 rows — these rows as CSV

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