PREVIEW / etf_daily / 2022-11-01

all etf daily files

  file:    by_date/etf_daily/2022/2022-11-01.parquet
  size:    105 KB
  rows:    2,853

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
2022-11-01	SPY	ETF	390.14	390.39	383.29	384.52	85407600.0
2022-11-01	QQQ	ETF	281.495	282.07	274.74	275.11	45895897.0
2022-11-01	IWM	ETF	185.24	185.6	182.88	183.58	27446700.0
2022-11-01	DIA	ETF	329.37	329.83	324.8	326.41	4376400.0
2022-11-01	GLD	ETF	153.82	153.98	152.87	153.46	4603600.0
2022-11-01	TLT	ETF	97.38	97.42	96.21	96.77	17585100.0
2022-11-01	AAA	ETF	24.105	24.105	24.105	24.105	2.0
2022-11-01	AAAU	ETF	16.39	16.42	16.3	16.36	906100.0
2022-11-01	AADR	ETF	47.39	47.59	47.31	47.31	2500.0
2022-11-01	AAPB	ETF	20.93	20.93	20.26	20.5918	4237.0
2022-11-01	AAPD	ETF	25.87	26.9	25.8601	26.6539	169134.0
2022-11-01	AAPU	ETF	22.25	22.2766	21.0	21.29	70864.0
2022-11-01	AAXJ	ETF	57.09	57.32	56.66	56.69	492100.0
2022-11-01	ABEQ	ETF	27.06	27.08	26.95	27.004	6800.0
2022-11-01	ACES	ETF	55.97	55.97	54.3	54.37	58600.0
2022-11-01	ACIO	ETF	29.447	29.447	29.32	29.4	15400.0
2022-11-01	ACSI	ETF	43.5376	43.5376	43.5376	43.5376	16.0
2022-11-01	ACT	ETF	25.65	25.65	24.8	24.96	134200.0
2022-11-01	ACTV	ETF	29.06	29.225	28.96	29.11	5409.0
2022-11-01	ACTX	ETF	0.48	0.48	0.48	0.48	639.0
2022-11-01	ACVF	ETF	29.344	29.54	29.344	29.54	400.0
2022-11-01	ACWF	ETF	31.595	31.6124	31.59	31.6124	5104.0
2022-11-01	ACWI	ETF	83.98	83.99	82.59	82.85	2923000.0
2022-11-01	ACWV	ETF	93.49	93.49	92.42	92.58	192400.0
2022-11-01	ACWX	ETF	42.32	42.34	41.72	41.87	2432672.0
2022-11-01	ADFI	ETF	8.22	8.24	8.22	8.23	9800.0
2022-11-01	ADIV	ETF	11.39	11.424	11.39	11.424	600.0
2022-11-01	ADME	ETF	35.09	35.09	34.58	34.58	10900.0
2022-11-01	ADRE	ETF	33.45	33.45	33.08	33.08	8711.0
2022-11-01	AEMB	ETF	35.42	35.42	35.42	35.42	100.0
2022-11-01	AESR	ETF	11.54	11.57	11.53	11.56	15000.0
2022-11-01	AFIF	ETF	8.64	8.67	8.63	8.67	38991.0
2022-11-01	AFK	ETF	15.95	15.95	15.383	15.64	15105.0
2022-11-01	AFLG	ETF	23.57	23.57	23.548	23.548	700.0
2022-11-01	AFSM	ETF	23.45	23.45	23.35	23.356	5900.0
2022-11-01	AFTY	ETF	13.685	13.685	13.685	13.685	300.0
2022-11-01	AGG	ETF	95.25	95.35	94.65	94.86	8096800.0
2022-11-01	AGGH	ETF	22.0	22.0485	22.0	22.0485	1835.0
2022-11-01	AGGY	ETF	41.79	41.8	41.42	41.61	161100.0
2022-11-01	AGNG	ETF	25.02	25.02	25.02	25.02	200.0
2022-11-01	AGOV	ETF	80.8	80.8	80.16	80.765	873.0
2022-11-01	AGOX	ETF	20.8	20.83	20.61	20.655	9800.0
2022-11-01	AGQ	ETF	22.43	22.53	21.5	21.81	1419300.0
2022-11-01	AGZ	ETF	105.72	105.72	105.535	105.61	14516.0
2022-11-01	AGZD	ETF	22.73	22.845	22.695	22.805	222000.0
2022-11-01	AHHX	ETF	8.53	8.53	8.41	8.455	10544.0
2022-11-01	AHYB	ETF	42.719	42.809	42.719	42.809	200.0
2022-11-01	AIA	ETF	47.73	47.73	47.21	47.23	27930.0
2022-11-01	AIEQ	ETF	32.29	32.3	31.71	31.798	5300.0
2022-11-01	AIQ	ETF	20.12	20.1419	19.67	19.67	6858.0

> showing 50 of 2,853 rows — these rows as CSV

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