PREVIEW / etf_daily / 2022-10-31

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-31.parquet
  size:    106 KB
  rows:    2,861

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-10-31	SPY	ETF	386.44	388.4	385.26	386.21	96631300.0
2022-10-31	QQQ	ETF	278.92	279.76	275.99	277.95	47741952.0
2022-10-31	IWM	ETF	182.27	184.24	181.55	183.33	25699400.0
2022-10-31	DIA	ETF	326.92	328.82	325.86	327.42	5128200.0
2022-10-31	GLD	ETF	152.16	152.87	151.89	151.91	6097800.0
2022-10-31	TLT	ETF	96.36	96.62	95.03	96.11	23956700.0
2022-10-31	AAA	ETF	24.185	24.185	24.185	24.185	16.0
2022-10-31	AAAU	ETF	16.23	16.3	16.2	16.2	622900.0
2022-10-31	AADR	ETF	47.0	47.03	46.87	47.03	600.0
2022-10-31	AAPB	ETF	21.0101	21.3852	21.0101	21.1703	2490.0
2022-10-31	AAPD	ETF	26.22	26.4253	26.06	26.2	265300.0
2022-10-31	AAPU	ETF	21.85	22.069	21.59	21.89	52432.0
2022-10-31	AAXJ	ETF	55.22	55.68	55.19	55.51	869500.0
2022-10-31	ABEQ	ETF	26.955	27.088	26.95	26.983	32200.0
2022-10-31	ACES	ETF	53.62	55.02	53.43	54.65	106900.0
2022-10-31	ACIO	ETF	29.6	29.6	29.475	29.52	9300.0
2022-10-31	ACSI	ETF	44.15	44.15	43.9058	43.9058	361.0
2022-10-31	ACT	ETF	25.58	25.77	25.17	25.64	144605.0
2022-10-31	ACTV	ETF	28.83	29.05	28.8009	28.9	8129.0
2022-10-31	ACTX	ETF	0.4308	0.45	0.4308	0.45	506.0
2022-10-31	ACVF	ETF	29.447	29.67	29.447	29.489	5400.0
2022-10-31	ACWF	ETF	31.29	31.53	31.29	31.4167	4400.0
2022-10-31	ACWI	ETF	82.65	83.08	82.52	82.77	6739400.0
2022-10-31	ACWV	ETF	92.36	92.95	92.32	92.73	127300.0
2022-10-31	ACWX	ETF	41.33	41.52	41.28	41.42	4500087.0
2022-10-31	ADFI	ETF	8.22	8.22	8.195	8.195	2800.0
2022-10-31	ADIV	ETF	11.229	11.229	11.229	11.229	100.0
2022-10-31	ADME	ETF	34.97	34.97	34.74	34.77	9400.0
2022-10-31	ADRE	ETF	32.27	32.6439	32.27	32.58	5985.0
2022-10-31	AEMB	ETF	35.02	35.068	35.0	35.068	600.0
2022-10-31	AESR	ETF	11.575	11.58	11.53	11.53	8400.0
2022-10-31	AFIF	ETF	8.64	8.65	8.62	8.65	188405.0
2022-10-31	AFK	ETF	15.45	15.75	15.257	15.45	16782.0
2022-10-31	AFLG	ETF	23.53	23.58	23.51	23.511	2800.0
2022-10-31	AFSM	ETF	23.34	23.34	23.283	23.283	400.0
2022-10-31	AFTY	ETF	13.17	13.17	13.16	13.16	400.0
2022-10-31	AGG	ETF	95.01	95.06	94.6	94.9	10946400.0
2022-10-31	AGGH	ETF	21.99	22.07	21.98	22.0034	1070.0
2022-10-31	AGGY	ETF	41.56	41.58	41.382	41.53	146100.0
2022-10-31	AGNG	ETF	24.92	24.92	24.87	24.898	600.0
2022-10-31	AGOV	ETF	79.38	79.38	78.3265	78.3265	102.0
2022-10-31	AGOX	ETF	20.65	20.7	20.52	20.6	176800.0
2022-10-31	AGQ	ETF	20.3	20.91	20.18	20.68	512100.0
2022-10-31	AGZ	ETF	105.68	105.76	105.62	105.62	14260.0
2022-10-31	AGZD	ETF	22.76	22.805	22.72	22.745	176600.0
2022-10-31	AHHX	ETF	8.4326	8.4326	8.4149	8.4149	1367.0
2022-10-31	AHYB	ETF	42.86	42.892	42.775	42.775	400.0
2022-10-31	AIA	ETF	45.61	45.97	45.56	45.82	37496.0
2022-10-31	AIEQ	ETF	31.57	31.89	31.57	31.744	3900.0
2022-10-31	AIQ	ETF	19.72	19.7425	19.53	19.67	10998.0

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

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