PREVIEW / etf_daily / 2000-08-09

all etf daily files

  file:    by_date/etf_daily/2000/2000-08-09.parquet
  size:    8 KB
  rows:    75

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-09	SPY	ETF	149.1406	149.2188	147.375	147.4375	5383800.0
2000-08-09	QQQ	ETF	93.6875	94.4375	91.375	91.625	18649800.0
2000-08-09	IWM	ETF	51.2812	51.2812	50.5391	50.5391	23000.0
2000-08-09	DIA	ETF	109.4062	109.7969	108.9062	109.125	1227000.0
2000-08-09	BBH	ETF	63.4167	64.0	62.3333	62.3333	1643100.0
2000-08-09	BITS	ETF	14.0	15.0	11.0	11.625	72900.0
2000-08-09	CEF	ETF	3.3125	3.3125	3.3125	3.3125	10000.0
2000-08-09	CHB	ETF	5.5	5.5	5.38	5.44	42800.0
2000-08-09	CNXT	ETF	30.06	30.5	29.12	29.56	3843260.0
2000-08-09	EWA	ETF	10.25	10.375	10.1875	10.1875	5200.0
2000-08-09	EWC	ETF	21.4375	21.5	21.125	21.3125	38100.0
2000-08-09	EWD	ETF	29.4375	29.4375	29.0625	29.375	2600.0
2000-08-09	EWG	ETF	23.75	23.8125	23.5	23.625	45200.0
2000-08-09	EWH	ETF	13.3125	13.4375	13.3125	13.375	37000.0
2000-08-09	EWI	ETF	50.125	50.125	49.75	50.0	11850.0
2000-08-09	EWJ	ETF	55.5	55.5	55.0	55.0	64725.0
2000-08-09	EWK	ETF	13.75	14.0	13.75	14.0	28100.0
2000-08-09	EWL	ETF	16.25	16.25	16.0	16.1875	20400.0
2000-08-09	EWM	ETF	25.0	25.0	24.25	24.25	43450.0
2000-08-09	EWN	ETF	23.8125	23.875	23.625	23.8125	4400.0
2000-08-09	EWO	ETF	8.0	8.0	7.9375	7.9375	1500.0
2000-08-09	EWP	ETF	26.0	26.125	25.6875	25.6875	25300.0
2000-08-09	EWQ	ETF	27.625	27.875	27.625	27.75	55600.0
2000-08-09	EWS	ETF	15.0	15.25	14.875	14.875	68550.0
2000-08-09	EWT	ETF	36.0	36.75	36.0	36.625	25450.0
2000-08-09	EWU	ETF	38.625	39.125	38.5	38.75	7950.0
2000-08-09	EWW	ETF	17.0625	17.0625	16.5625	16.5625	27400.0
2000-08-09	EWY	ETF	18.5	18.5	18.4375	18.5	4200.0
2000-08-09	EZU	ETF	38.2188	38.2188	38.125	38.125	20200.0
2000-08-09	FCTR	ETF	14.75	15.25	14.625	15.0	44200.0
2000-08-09	FMAR	ETF	5.0	5.25	5.0	5.25	4500.0
2000-08-09	GLDB	ETF	4.75	4.9375	4.75	4.875	33400.0
2000-08-09	GSIG	ETF	25.19	25.75	23.25	23.5	768600.0
2000-08-09	IDU	ETF	38.3125	38.3125	38.0	38.0	44800.0
2000-08-09	IEV	ETF	38.7734	38.8125	38.2891	38.5	7800.0
2000-08-09	IGLD	ETF	675.0	700.0	675.0	675.0	383.0
2000-08-09	IJH	ETF	10.2984	10.3141	10.1469	10.1469	652000.0
2000-08-09	IJJ	ETF	18.8438	18.8438	18.8438	18.8438	1600.0
2000-08-09	IJK	ETF	17.2188	17.2539	16.9746	16.9746	11200.0
2000-08-09	IJR	ETF	17.5313	17.5313	17.4141	17.4141	3600.0
2000-08-09	IVE	ETF	61.9688	61.9688	61.3281	61.6875	63500.0
2000-08-09	IVV	ETF	149.0938	149.0938	147.8125	147.8125	123100.0
2000-08-09	IVW	ETF	22.4961	22.4961	22.1875	22.1875	37200.0
2000-08-09	IWB	ETF	78.2969	78.5938	78.2969	78.5938	300.0
2000-08-09	IWD	ETF	57.0	57.0	56.5	56.5625	30200.0
2000-08-09	IWF	ETF	21.703125	21.703125	21.3125	21.359375	34000.0
2000-08-09	IWN	ETF	35.5781	35.6146	35.401	35.401	3000.0
2000-08-09	IWO	ETF	78.3906	78.5	77.25	77.2656	47600.0
2000-08-09	IWV	ETF	80.9062	81.0625	80.4688	80.4688	2500.0
2000-08-09	IYE	ETF	16.6875	16.8021	16.6667	16.7396	21600.0

> showing 50 of 75 rows — these rows as CSV

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