PREVIEW / etf_daily / 2000-08-18

all etf daily files

  file:    by_date/etf_daily/2000/2000-08-18.parquet
  size:    8 KB
  rows:    79

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-08-18	SPY	ETF	150.375	150.375	149.2188	149.6875	4626400.0
2000-08-18	QQQ	ETF	95.9375	96.625	94.6875	95.25	14706700.0
2000-08-18	IWM	ETF	51.8125	51.9375	51.4375	51.5469	52200.0
2000-08-18	DIA	ETF	110.9375	110.9375	109.9688	110.4375	349000.0
2000-08-18	BBH	ETF	58.7083	58.75	57.7083	57.7917	833700.0
2000-08-18	BITS	ETF	13.75	13.75	12.25	12.25	2975.0
2000-08-18	CEF	ETF	3.3125	3.3125	3.25	3.3125	11900.0
2000-08-18	CHB	ETF	6.31	6.31	6.0	6.0	166800.0
2000-08-18	CNXT	ETF	39.1	40.41	38.22	39.16	8861660.0
2000-08-18	CSB	ETF	2.29999995231628	2.29999995231628	2.29999995231628	2.29999995231628	5000.0
2000-08-18	EWA	ETF	10.5625	10.75	10.5625	10.75	9100.0
2000-08-18	EWC	ETF	21.75	21.8125	21.5625	21.5625	26900.0
2000-08-18	EWD	ETF	29.375	29.375	29.25	29.25	1500.0
2000-08-18	EWG	ETF	23.8125	23.8125	23.5625	23.75	35900.0
2000-08-18	EWH	ETF	13.75	13.875	13.75	13.75	13600.0
2000-08-18	EWI	ETF	50.0	50.25	49.75	50.25	3200.0
2000-08-18	EWJ	ETF	55.0	55.25	54.75	55.25	45650.0
2000-08-18	EWK	ETF	14.125	14.125	13.875	14.125	4000.0
2000-08-18	EWL	ETF	16.25	16.25	15.9375	16.0625	4500.0
2000-08-18	EWM	ETF	24.25	24.75	24.25	24.5	20625.0
2000-08-18	EWN	ETF	24.625	24.625	24.3125	24.4375	3900.0
2000-08-18	EWO	ETF	8.0625	8.125	8.0	8.125	5200.0
2000-08-18	EWP	ETF	26.5625	26.5625	26.25	26.5	3200.0
2000-08-18	EWQ	ETF	28.125	28.25	27.9375	28.0	22600.0
2000-08-18	EWS	ETF	16.125	16.375	16.0	16.0	21700.0
2000-08-18	EWT	ETF	37.25	37.25	37.25	37.25	5000.0
2000-08-18	EWU	ETF	39.625	39.625	39.25	39.625	28500.0
2000-08-18	EWW	ETF	17.0	17.1875	16.5	16.5	80800.0
2000-08-18	EWY	ETF	19.5625	19.5625	19.0	19.0	5000.0
2000-08-18	EWZ	ETF	19.75	19.75	19.75	19.75	200.0
2000-08-18	EZU	ETF	38.8438	38.9062	38.75	38.75	2400.0
2000-08-18	FCTR	ETF	13.9375	14.1875	13.9375	14.0	5100.0
2000-08-18	FMAR	ETF	5.0	5.25	4.94	5.0025	5000.0
2000-08-18	GLDB	ETF	5.5	5.5	5.125	5.1875	109000.0
2000-08-18	GSIG	ETF	25.25	26.0	24.12	24.81	2926300.0
2000-08-18	IDU	ETF	39.2812	39.4219	39.1719	39.2656	4000.0
2000-08-18	IEV	ETF	39.375	39.4688	39.3125	39.4688	46200.0
2000-08-18	IGLD	ETF	637.5	643.75	631.25	631.25	257.0
2000-08-18	IJH	ETF	10.5156	10.525	10.4531	10.4938	158000.0
2000-08-18	IJJ	ETF	19.1562	19.2422	19.1367	19.2422	7200.0
2000-08-18	IJK	ETF	17.5957	17.6172	17.5957	17.6172	3200.0
2000-08-18	IJR	ETF	17.9636	17.9636	17.8594	17.8698	127200.0
2000-08-18	IJS	ETF	17.7383	17.7383	17.7383	17.7383	2000.0
2000-08-18	IJT	ETF	21.0391	21.0391	21.0391	21.0391	1600.0
2000-08-18	IUSG	ETF	34.5547	34.6719	34.4844	34.4844	1800.0
2000-08-18	IVE	ETF	62.7188	62.7188	62.2969	62.6094	34200.0
2000-08-18	IVV	ETF	150.125	150.2188	149.3125	149.625	269000.0
2000-08-18	IVW	ETF	22.3828	22.4961	22.3828	22.4961	10400.0
2000-08-18	IWB	ETF	79.6094	79.6094	79.2812	79.2812	4200.0
2000-08-18	IWD	ETF	57.3438	57.3594	57.1562	57.3594	20900.0

> showing 50 of 79 rows — these rows as CSV

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