PREVIEW / etf_daily / 2000-10-27

all etf daily files

  file:    by_date/etf_daily/2000/2000-10-27.parquet
  size:    8 KB
  rows:    84

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-10-27	SPY	ETF	137.875	139.2812	136.625	139.2812	9762900.0
2000-10-27	QQQ	ETF	80.8594	81.8594	77.4844	79.7188	51046400.0
2000-10-27	IWM	ETF	47.625	48.25	47.625	48.0312	138800.0
2000-10-27	DIA	ETF	104.3125	106.4062	103.75	106.1875	1576000.0
2000-10-27	BBH	ETF	57.8333	59.2917	57.75	58.3333	3349200.0
2000-10-27	BITS	ETF	10.5	13.0	9.0	11.0	10325.0
2000-10-27	CEF	ETF	3.0	3.0	2.9375	2.9375	6200.0
2000-10-27	CHB	ETF	3.31	3.56	3.31	3.56	84700.0
2000-10-27	CNXT	ETF	23.69	24.19	21.75	21.88	4737580.0
2000-10-27	DGT	ETF	82.3594	82.3594	82.3594	82.3594	100.0
2000-10-27	EWA	ETF	9.0625	9.0625	8.875	8.875	12700.0
2000-10-27	EWC	ETF	14.625	14.8125	14.5	14.6875	125600.0
2000-10-27	EWD	ETF	19.5625	19.875	19.5625	19.75	3500.0
2000-10-27	EWG	ETF	18.625	18.9375	18.5	18.8125	51100.0
2000-10-27	EWH	ETF	11.1875	11.1875	11.0	11.125	43600.0
2000-10-27	EWI	ETF	42.125	42.75	42.125	42.75	13000.0
2000-10-27	EWJ	ETF	50.75	51.0	50.5	51.0	58325.0
2000-10-27	EWK	ETF	11.875	12.0625	11.875	12.0625	600.0
2000-10-27	EWL	ETF	14.625	14.875	14.625	14.875	2600.0
2000-10-27	EWM	ETF	23.0	24.0	23.0	24.0	96225.0
2000-10-27	EWN	ETF	21.8125	22.0625	21.75	21.75	4000.0
2000-10-27	EWO	ETF	6.875	7.0	6.875	7.0	12200.0
2000-10-27	EWP	ETF	22.8125	23.0625	22.75	22.75	2700.0
2000-10-27	EWQ	ETF	23.25	23.5625	23.25	23.375	35700.0
2000-10-27	EWS	ETF	13.25	13.5	13.0	13.375	32450.0
2000-10-27	EWT	ETF	25.375	25.375	25.0	25.125	92050.0
2000-10-27	EWU	ETF	35.0	35.875	35.0	35.875	36650.0
2000-10-27	EWW	ETF	14.9375	15.125	14.75	15.0625	30100.0
2000-10-27	EWY	ETF	13.5625	13.625	13.25	13.5	5000.0
2000-10-27	EZU	ETF	34.6562	34.9062	34.625	34.875	29400.0
2000-10-27	FCTR	ETF	15.5	15.8125	15.5	15.75	22100.0
2000-10-27	FMAR	ETF	4.27	4.62	4.27	4.62	600.0
2000-10-27	GLDB	ETF	4.0625	4.125	3.9375	4.125	410400.0
2000-10-27	GSIG	ETF	12.0	13.0	11.62	12.0	1135200.0
2000-10-27	IDU	ETF	39.3906	40.25	39.1094	40.1484	21600.0
2000-10-27	IEV	ETF	36.1875	36.25	36.0625	36.1875	35400.0
2000-10-27	IGLD	ETF	331.25	346.875	318.75	318.75	215.0
2000-10-27	IJH	ETF	10.0656	10.1297	9.9828	10.1016	591000.0
2000-10-27	IJJ	ETF	18.75	18.9648	18.75	18.9297	181200.0
2000-10-27	IJK	ETF	16.8281	16.834	16.5606	16.6348	38400.0
2000-10-27	IJR	ETF	17.3958	17.4219	17.2839	17.3255	190800.0
2000-10-27	IJS	ETF	17.0938	17.1797	17.0938	17.1797	14800.0
2000-10-27	IJT	ETF	20.3438	20.3438	20.1953	20.2656	26400.0
2000-10-27	IUSG	ETF	29.7812	30.1016	29.7812	29.9375	2200.0
2000-10-27	IVE	ETF	60.625	61.4688	60.625	61.4375	18100.0
2000-10-27	IVV	ETF	138.0	139.25	136.75	139.25	60200.0
2000-10-27	IVW	ETF	19.6641	19.6875	19.4531	19.6328	190000.0
2000-10-27	IWB	ETF	73.08	74.08	73.08	73.62	10000.0
2000-10-27	IWD	ETF	56.375	57.4219	56.375	57.4219	19000.0
2000-10-27	IWF	ETF	18.921875	19.125	18.730475	19.03125	52000.0

> showing 50 of 84 rows — these rows as CSV

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