PREVIEW / etf_daily / 2001-01-18

all etf daily files

  file:    by_date/etf_daily/2001/2001-01-18.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-18	SPY	ETF	133.4375	135.7031	132.9375	134.7812	8107000.0
2001-01-18	QQQ	ETF	64.125	66.75	62.6875	66.5625	54934700.0
2001-01-18	IWM	ETF	49.4375	49.5	48.7656	49.5	916200.0
2001-01-18	DIA	ETF	106.3125	107.4844	105.5938	106.7188	1189400.0
2001-01-18	BBH	ETF	48.5833	49.7917	48.0208	49.5208	1888800.0
2001-01-18	BITS	ETF	12.0	12.5	11.625	11.75	9700.0
2001-01-18	BOSS	ETF	24.5	25.5	24.5	25.5	200.0
2001-01-18	CEF	ETF	3.1875	3.25	3.0625	3.1875	53600.0
2001-01-18	CHB	ETF	5.13	5.63	5.13	5.56	100200.0
2001-01-18	CNXT	ETF	19.5	20.56	18.06	18.75	7546560.0
2001-01-18	DGT	ETF	78.5	80.1875	78.5	80.1875	2100.0
2001-01-18	EWA	ETF	9.8125	9.8125	9.8125	9.8125	12300.0
2001-01-18	EWC	ETF	13.375	13.375	13.1875	13.375	26100.0
2001-01-18	EWD	ETF	19.0625	19.9375	19.0625	19.875	2100.0
2001-01-18	EWG	ETF	20.0625	20.25	20.0	20.25	60800.0
2001-01-18	EWH	ETF	11.875	12.0	11.75	12.0	87400.0
2001-01-18	EWI	ETF	45.875	46.25	45.625	46.25	8550.0
2001-01-18	EWJ	ETF	44.0	44.75	43.5	44.75	477575.0
2001-01-18	EWK	ETF	12.9375	12.9375	12.9375	12.9375	200.0
2001-01-18	EWL	ETF	16.5	16.625	16.5	16.625	300.0
2001-01-18	EWM	ETF	20.0	20.5	20.0	20.25	17025.0
2001-01-18	EWN	ETF	23.0	23.0625	23.0	23.0625	4100.0
2001-01-18	EWO	ETF	7.9375	7.9375	7.875	7.875	12600.0
2001-01-18	EWP	ETF	25.25	25.9375	25.25	25.9375	76900.0
2001-01-18	EWQ	ETF	24.5	24.625	24.3125	24.625	11500.0
2001-01-18	EWS	ETF	12.875	13.0	12.75	13.0	26050.0
2001-01-18	EWT	ETF	27.875	27.875	26.75	27.5	65900.0
2001-01-18	EWU	ETF	35.375	35.375	34.875	35.375	22750.0
2001-01-18	EWW	ETF	14.4375	14.4375	14.0625	14.25	101300.0
2001-01-18	EWY	ETF	14.8125	15.0	14.6875	15.0	94300.0
2001-01-18	EWZ	ETF	18.375	18.4375	18.375	18.4375	1100.0
2001-01-18	EZU	ETF	36.875	37.3125	36.875	37.3125	9800.0
2001-01-18	FCTR	ETF	15.8125	15.9375	15.0	15.25	28500.0
2001-01-18	GLDB	ETF	5.4375	5.5	5.25	5.3125	37800.0
2001-01-18	GSIG	ETF	11.72	12.75	11.56	12.44	368600.0
2001-01-18	IDU	ETF	37.7344	37.7656	37.4531	37.7656	4000.0
2001-01-18	IEV	ETF	38.125	38.4062	37.9375	38.4062	171600.0
2001-01-18	IGLD	ETF	268.75	287.5	268.75	275.0	328.0
2001-01-18	IJH	ETF	10.1234	10.1688	10.1	10.1625	1652000.0
2001-01-18	IJJ	ETF	21.5469	21.5469	21.3828	21.5	142000.0
2001-01-18	IJK	ETF	14.7578	14.9297	14.7578	14.8906	440000.0
2001-01-18	IJR	ETF	18.4479	18.5287	18.3229	18.4688	704400.0
2001-01-18	IJS	ETF	20.1875	20.2656	20.086	20.2344	278000.0
2001-01-18	IJT	ETF	19.1406	19.1719	18.9766	19.1719	248800.0
2001-01-18	IOO	ETF	35.4531	36.0312	35.4531	36.0312	8000.0
2001-01-18	IUSG	ETF	26.7656	27.3828	26.7656	27.3828	11400.0
2001-01-18	IUSV	ETF	24.849	24.9635	24.849	24.9167	7500.0
2001-01-18	IVE	ETF	64.6875	65.2812	64.3125	65.1875	25400.0
2001-01-18	IVV	ETF	133.5781	135.5469	133.0	134.8438	69400.0
2001-01-18	IVW	ETF	17.1797	17.6172	17.1797	17.5156	110400.0

> showing 50 of 93 rows — these rows as CSV

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