PREVIEW / etf_daily / 2001-08-20

all etf daily files

  file:    by_date/etf_daily/2001/2001-08-20.parquet
  size:    8 KB
  rows:    100

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-08-20	SPY	ETF	116.8	117.9	116.55	117.83	10417400.0
2001-08-20	QQQ	ETF	37.85	38.65	37.52	38.28	49921300.0
2001-08-20	IWM	ETF	47.3	47.875	47.275	47.875	2469600.0
2001-08-20	DIA	ETF	102.4	103.6	102.15	103.58	2005200.0
2001-08-20	BBH	ETF	38.6667	38.7333	37.9367	38.44	2351100.0
2001-08-20	BITS	ETF	14.68	15.36	14.64	15.0	2050.0
2001-08-20	BOSS	ETF	23.3	23.3	23.3	23.3	100.0
2001-08-20	CEF	ETF	3.2	3.24	3.16	3.16	39000.0
2001-08-20	CHB	ETF	9.6	9.67	9.51	9.67	63300.0
2001-08-20	CNXT	ETF	9.87	10.6	9.6	10.48	4683030.0
2001-08-20	DGT	ETF	66.86	66.91	66.69	66.69	2800.0
2001-08-20	EWA	ETF	9.65	9.66	9.56	9.66	7300.0
2001-08-20	EWC	ETF	11.1	11.1	11.1	11.1	2900.0
2001-08-20	EWD	ETF	12.81	12.81	12.8	12.8	400.0
2001-08-20	EWG	ETF	15.45	15.55	15.31	15.44	35500.0
2001-08-20	EWH	ETF	9.15	9.39	9.11	9.21	24300.0
2001-08-20	EWI	ETF	36.4	36.4	36.3	36.3	5300.0
2001-08-20	EWJ	ETF	37.4	37.76	37.4	37.6	104750.0
2001-08-20	EWL	ETF	13.12	13.25	13.12	13.25	400.0
2001-08-20	EWM	ETF	19.4	19.4	18.4	18.72	33200.0
2001-08-20	EWN	ETF	19.1	19.1	18.85	18.85	1500.0
2001-08-20	EWO	ETF	8.37	8.37	8.27	8.27	1600.0
2001-08-20	EWP	ETF	21.33	21.33	21.29	21.29	900.0
2001-08-20	EWQ	ETF	20.04	20.1	19.9	20.1	21600.0
2001-08-20	EWS	ETF	10.4	10.58	10.4	10.44	19100.0
2001-08-20	EWT	ETF	18.9	18.9	18.4	18.4	1450.0
2001-08-20	EWU	ETF	30.86	30.86	30.32	30.6	3150.0
2001-08-20	EWW	ETF	15.0	15.44	15.0	15.15	15100.0
2001-08-20	EWY	ETF	13.94	13.94	13.74	13.94	18500.0
2001-08-20	EWZ	ETF	12.3	12.32	12.22	12.32	5000.0
2001-08-20	EZU	ETF	29.01	29.22	28.93	29.22	6200.0
2001-08-20	FCTR	ETF	17.9	18.28	17.9	18.19	26000.0
2001-08-20	FMAR	ETF	9.75	9.8	9.6	9.6	10000.0
2001-08-20	GLDB	ETF	7.78	7.93	7.7	7.85	42200.0
2001-08-20	GSIG	ETF	8.08	8.09	7.97	8.02	39000.0
2001-08-20	IBB	ETF	27.2667	27.3667	26.7333	27.0667	79800.0
2001-08-20	ICF	ETF	22.105	22.1925	22.105	22.1925	13600.0
2001-08-20	IDU	ETF	36.35	36.505	36.35	36.455	2600.0
2001-08-20	IEV	ETF	30.675	30.85	30.655	30.795	112400.0
2001-08-20	IGLD	ETF	65.0	68.0	65.0	67.5	101.0
2001-08-20	IGM	ETF	8.3	8.3	8.2483	8.2917	39600.0
2001-08-20	IJH	ETF	9.92	9.951	9.867	9.951	235000.0
2001-08-20	IJJ	ETF	22.625	22.67	22.4875	22.6625	33600.0
2001-08-20	IJK	ETF	13.4688	13.4912	13.4162	13.4912	47200.0
2001-08-20	IJR	ETF	18.7217	18.8867	18.675	18.8417	219000.0
2001-08-20	IJS	ETF	21.28	21.34	21.15	21.31	56800.0
2001-08-20	IJT	ETF	18.58	18.73	18.5475	18.73	61200.0
2001-08-20	IOO	ETF	29.41	29.59	29.33	29.565	39000.0
2001-08-20	IUSG	ETF	20.34	20.5	20.34	20.35	15800.0
2001-08-20	IUSV	ETF	24.4167	24.5667	24.4133	24.5667	7800.0

> showing 50 of 100 rows — these rows as CSV

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