PREVIEW / etf_daily / 2001-11-20

all etf daily files

  file:    by_date/etf_daily/2001/2001-11-20.parquet
  size:    9 KB
  rows:    112

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-11-20	SPY	ETF	115.37	115.8	114.64	114.8	16209700.0
2001-11-20	QQQ	ETF	40.08	40.23	38.48	38.62	85216500.0
2001-11-20	IWM	ETF	45.5	45.825	45.05	45.24	457000.0
2001-11-20	DIA	ETF	99.7	99.99	99.05	99.13	3313500.0
2001-11-20	ARB	ETF	29.35	29.4	29.02	29.25	176000.0
2001-11-20	BBH	ETF	45.0	45.0967	44.1233	44.15	2766900.0
2001-11-20	BITS	ETF	19.4	19.48	18.56	19.2	3800.0
2001-11-20	CEF	ETF	3.25	3.29	3.25	3.27	20500.0
2001-11-20	CHB	ETF	12.4	12.4	11.56	11.69	282300.0
2001-11-20	CNXT	ETF	13.37	13.4	12.2	12.47	5308680.0
2001-11-20	CSB	ETF	3.95000004768372	3.95000004768372	3.79999995231628	3.79999995231628	17700.0
2001-11-20	DGT	ETF	67.8	67.8	67.55	67.66	700.0
2001-11-20	EFA	ETF	40.1667	40.1833	39.9167	39.9167	358800.0
2001-11-20	ELV	ETF	23.65	24.625	23.625	24.4	1401500.0
2001-11-20	EWA	ETF	9.35	9.45	9.35	9.44	13500.0
2001-11-20	EWC	ETF	10.65	10.75	10.4	10.64	10100.0
2001-11-20	EWD	ETF	13.05	13.24	13.05	13.19	2300.0
2001-11-20	EWG	ETF	14.67	14.67	14.45	14.45	55200.0
2001-11-20	EWH	ETF	8.85	9.01	8.8	8.82	41100.0
2001-11-20	EWI	ETF	32.3	32.58	32.2	32.2	4750.0
2001-11-20	EWJ	ETF	33.64	33.92	33.56	33.64	51700.0
2001-11-20	EWK	ETF	10.57	10.57	10.57	10.57	200.0
2001-11-20	EWL	ETF	13.05	13.05	12.91	13.04	5100.0
2001-11-20	EWM	ETF	18.52	18.52	18.4	18.4	17825.0
2001-11-20	EWN	ETF	16.7	16.89	16.7	16.89	4700.0
2001-11-20	EWO	ETF	6.91	6.91	6.91	6.91	600.0
2001-11-20	EWP	ETF	20.95	20.95	20.76	20.94	4600.0
2001-11-20	EWQ	ETF	18.25	18.35	18.21	18.21	10800.0
2001-11-20	EWS	ETF	9.02	9.18	9.02	9.02	25950.0
2001-11-20	EWT	ETF	18.12	18.12	17.62	17.86	163550.0
2001-11-20	EWU	ETF	29.26	29.66	29.24	29.38	8400.0
2001-11-20	EWW	ETF	13.63	13.85	13.6	13.63	7900.0
2001-11-20	EWY	ETF	15.95	15.95	15.26	15.38	8300.0
2001-11-20	EWZ	ETF	11.15	11.24	10.81	10.81	238000.0
2001-11-20	EZU	ETF	27.425	27.45	27.155	27.375	18600.0
2001-11-20	FCTR	ETF	17.75	17.99	17.6	17.68	12800.0
2001-11-20	FMAR	ETF	8.25	8.25	8.05	8.05	6700.0
2001-11-20	GLDB	ETF	7.5	7.59	7.4	7.43	33900.0
2001-11-20	GSIG	ETF	8.81	8.94	8.56	8.6	102600.0
2001-11-20	IBB	ETF	30.75	30.8333	30.1667	30.1833	244200.0
2001-11-20	ICF	ETF	20.9375	20.9375	20.7925	20.8625	38000.0
2001-11-20	IDU	ETF	32.325	32.565	32.3	32.47	23400.0
2001-11-20	IEV	ETF	29.45	29.525	29.275	29.3	117200.0
2001-11-20	IGLD	ETF	90.0	92.0	89.0	90.0	269.0
2001-11-20	IGM	ETF	8.5667	8.5667	8.375	8.4017	118800.0
2001-11-20	IGN	ETF	35.4	35.4	33.85	33.85	207500.0
2001-11-20	IGV	ETF	8.78	8.828	8.482	8.482	21000.0
2001-11-20	IJH	ETF	9.655	9.688	9.606	9.606	250000.0
2001-11-20	IJJ	ETF	21.405	21.46	21.3025	21.3625	62800.0
2001-11-20	IJK	ETF	13.5562	13.5712	13.4175	13.4175	159200.0

> showing 50 of 112 rows — these rows as CSV

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