PREVIEW / etf_daily / 2001-01-02

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-02.parquet
  size:    8 KB
  rows:    93

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
2001-01-02	SPY	ETF	132.0	132.1562	127.5625	128.8125	8737500.0
2001-01-02	QQQ	ETF	58.5625	58.6875	52.4375	53.4375	62519300.0
2001-01-02	IWM	ETF	47.875	47.875	45.8438	46.2031	826000.0
2001-01-02	DIA	ETF	107.1875	107.75	105.5938	106.4062	1468300.0
2001-01-02	BBH	ETF	57.0	57.5	52.8542	53.375	3804900.0
2001-01-02	BITS	ETF	10.375	10.5	8.5	9.75	3600.0
2001-01-02	BOSS	ETF	23.0	23.0	23.0	23.0	100.0
2001-01-02	CEF	ETF	3.125	3.1875	3.125	3.1875	8500.0
2001-01-02	CHB	ETF	2.81	3.13	2.81	3.06	84900.0
2001-01-02	CNXT	ETF	15.653	15.716	12.722	12.847	5843040.0
2001-01-02	DGT	ETF	77.25	77.25	76.4375	76.4375	2700.0
2001-01-02	EWA	ETF	9.625	9.75	9.5625	9.75	10100.0
2001-01-02	EWC	ETF	13.5	13.5	13.0625	13.0625	18700.0
2001-01-02	EWD	ETF	18.125	18.125	17.8125	17.8125	1400.0
2001-01-02	EWG	ETF	19.5	19.625	19.375	19.5625	69600.0
2001-01-02	EWH	ETF	11.5625	11.5625	11.125	11.25	90800.0
2001-01-02	EWI	ETF	45.25	45.25	44.75	44.75	11000.0
2001-01-02	EWJ	ETF	44.5	44.5	43.75	44.0	65075.0
2001-01-02	EWK	ETF	13.0	13.0625	13.0	13.0625	2900.0
2001-01-02	EWL	ETF	16.75	17.0	16.75	17.0	2400.0
2001-01-02	EWM	ETF	20.25	20.25	19.75	19.75	1725.0
2001-01-02	EWN	ETF	22.8125	23.125	22.625	22.625	4200.0
2001-01-02	EWO	ETF	7.625	7.75	7.625	7.75	11100.0
2001-01-02	EWP	ETF	23.375	23.5625	23.375	23.5625	23600.0
2001-01-02	EWQ	ETF	24.8125	24.8125	24.4375	24.6875	56000.0
2001-01-02	EWS	ETF	13.0	13.125	12.75	12.75	20700.0
2001-01-02	EWT	ETF	21.625	21.625	21.125	21.25	5350.0
2001-01-02	EWU	ETF	35.375	36.0	35.25	35.625	29850.0
2001-01-02	EWW	ETF	13.4375	13.625	13.0	13.0	41800.0
2001-01-02	EWY	ETF	12.625	12.625	12.375	12.4375	27300.0
2001-01-02	EWZ	ETF	16.875	16.875	16.4375	16.6875	27600.0
2001-01-02	EZU	ETF	36.7812	36.7812	36.25	36.5	27800.0
2001-01-02	FCTR	ETF	14.875	14.875	13.0625	13.4375	34400.0
2001-01-02	FMAR	ETF	4.25	4.91	4.0	4.44	15500.0
2001-01-02	GLDB	ETF	4.6875	5.0	4.6875	4.8125	114400.0
2001-01-02	GSIG	ETF	8.12	8.5	7.5	8.0	157500.0
2001-01-02	IDU	ETF	44.1719	44.1719	42.8594	42.9375	6400.0
2001-01-02	IEV	ETF	38.375	38.4062	38.125	38.1875	30200.0
2001-01-02	IGLD	ETF	193.75	212.5	168.75	200.0	707.0
2001-01-02	IJH	ETF	10.2281	10.2281	9.8375	9.8594	82000.0
2001-01-02	IJJ	ETF	21.2812	21.2812	20.7734	20.7734	60800.0
2001-01-02	IJK	ETF	15.3438	15.3438	14.6016	14.6016	24000.0
2001-01-02	IJR	ETF	18.0625	18.0625	17.3255	17.388	295800.0
2001-01-02	IJS	ETF	19.1875	19.1875	18.6797	18.711	91600.0
2001-01-02	IJT	ETF	18.8906	18.8906	18.5	18.5	29600.0
2001-01-02	IOO	ETF	34.9844	34.9844	34.5625	34.6094	2600.0
2001-01-02	IUSG	ETF	24.9844	24.9844	23.9766	23.9766	8600.0
2001-01-02	IUSV	ETF	25.0104	25.0104	24.9375	24.9688	1500.0
2001-01-02	IVE	ETF	63.4844	63.7812	62.6094	62.6094	136400.0
2001-01-02	IVV	ETF	131.5	131.7812	127.75	128.6875	174300.0

> showing 50 of 93 rows — these rows as CSV

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