PREVIEW / etf_daily / 2001-01-19

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-19.parquet
  size:    8 KB
  rows:    91

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-19	SPY	ETF	136.1875	136.1875	133.875	134.0156	7782500.0
2001-01-19	QQQ	ETF	68.1406	68.3125	65.5625	66.3125	56292500.0
2001-01-19	IWM	ETF	49.9062	49.9062	48.3906	48.625	590800.0
2001-01-19	DIA	ETF	107.125	107.125	105.5625	105.5625	1057700.0
2001-01-19	BBH	ETF	48.7708	48.7708	47.1667	47.625	1730100.0
2001-01-19	BITS	ETF	12.5	12.5	11.75	11.875	5225.0
2001-01-19	CEF	ETF	3.1875	3.25	3.125	3.25	13800.0
2001-01-19	CHB	ETF	5.63	6.63	5.63	6.63	721200.0
2001-01-19	CNXT	ETF	18.12	18.75	16.94	17.19	8507890.0
2001-01-19	DGT	ETF	79.75	79.9375	79.25	79.4375	3100.0
2001-01-19	EWA	ETF	9.9375	10.0	9.8125	9.875	27700.0
2001-01-19	EWC	ETF	13.5625	13.75	13.5	13.75	10700.0
2001-01-19	EWD	ETF	20.125	20.125	19.5	19.5	52500.0
2001-01-19	EWG	ETF	20.3125	20.3125	20.0	20.0625	96200.0
2001-01-19	EWH	ETF	12.4375	12.4375	12.125	12.25	113100.0
2001-01-19	EWI	ETF	45.875	46.0	45.75	45.75	2550.0
2001-01-19	EWJ	ETF	44.5	44.75	44.0	44.0	184850.0
2001-01-19	EWK	ETF	12.6875	12.6875	12.6875	12.6875	10300.0
2001-01-19	EWL	ETF	16.625	16.625	16.1875	16.375	17000.0
2001-01-19	EWM	ETF	20.5	21.5	20.5	21.5	14625.0
2001-01-19	EWN	ETF	22.875	22.875	22.75	22.75	5300.0
2001-01-19	EWO	ETF	7.75	7.9375	7.75	7.9375	6100.0
2001-01-19	EWP	ETF	25.625	25.6875	25.3125	25.375	35800.0
2001-01-19	EWQ	ETF	24.5625	24.75	24.3125	24.3125	48300.0
2001-01-19	EWS	ETF	13.125	13.125	12.75	13.0	33450.0
2001-01-19	EWT	ETF	27.75	28.0	27.25	27.5	13350.0
2001-01-19	EWU	ETF	35.125	35.5	34.75	35.0	33650.0
2001-01-19	EWW	ETF	14.375	14.5	14.1875	14.375	26500.0
2001-01-19	EWY	ETF	15.375	15.375	15.0	15.25	82900.0
2001-01-19	EWZ	ETF	18.625	18.6875	18.5	18.625	60200.0
2001-01-19	EZU	ETF	37.125	37.125	36.5	36.6875	46000.0
2001-01-19	FCTR	ETF	15.25	15.8125	15.1875	15.6875	186200.0
2001-01-19	FMAR	ETF	5.25	5.5	5.25	5.5	5300.0
2001-01-19	GLDB	ETF	5.5	5.5	5.0625	5.25	56800.0
2001-01-19	GSIG	ETF	12.75	13.37	12.62	12.81	380500.0
2001-01-19	IDU	ETF	37.6875	38.4688	37.6875	38.1484	7200.0
2001-01-19	IEV	ETF	38.3125	38.3125	37.9375	38.125	36200.0
2001-01-19	IGLD	ETF	281.25	293.75	275.0	293.75	271.0
2001-01-19	IJH	ETF	10.2344	10.2375	10.0844	10.0844	554000.0
2001-01-19	IJJ	ETF	21.6055	21.6055	21.3594	21.4023	42800.0
2001-01-19	IJK	ETF	15.0	15.0	14.8047	14.9004	172000.0
2001-01-19	IJR	ETF	18.5208	18.5208	18.1875	18.1875	345000.0
2001-01-19	IJS	ETF	20.2656	20.2656	19.9414	19.9414	70800.0
2001-01-19	IJT	ETF	19.2812	19.2969	18.9102	18.9688	44400.0
2001-01-19	IOO	ETF	36.0312	36.0312	35.7188	35.8906	21600.0
2001-01-19	IUSG	ETF	27.6875	27.6875	27.2734	27.2734	1800.0
2001-01-19	IUSV	ETF	24.6875	24.6875	24.6719	24.6719	600.0
2001-01-19	IVE	ETF	65.1875	65.1875	64.5	64.75	127400.0
2001-01-19	IVV	ETF	135.9688	135.9688	133.875	134.375	39800.0
2001-01-19	IVW	ETF	17.6758	17.6758	17.4258	17.5	164800.0

> showing 50 of 91 rows — these rows as CSV

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