PREVIEW / etf_daily / 2022-10-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-10-28.parquet
  size:    105 KB
  rows:    2,833

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-28	SPY	ETF	379.87	389.52	379.68	389.02	100302000.0
2022-10-28	QQQ	ETF	272.23	281.698	272.06	281.22	62651312.0
2022-10-28	IWM	ETF	179.83	183.41	178.74	183.16	33221600.0
2022-10-28	DIA	ETF	321.77	328.89	321.46	328.58	5251400.0
2022-10-28	GLD	ETF	152.96	153.54	152.5	153.16	4645400.0
2022-10-28	TLT	ETF	96.86	97.63	96.41	96.8	22244100.0
2022-10-28	AAA	ETF	24.18	24.18	24.18	24.18	4.0
2022-10-28	AAAU	ETF	16.31	16.35	16.26	16.33	492500.0
2022-10-28	AADR	ETF	47.31	47.31	47.31	47.31	200.0
2022-10-28	AAPB	ETF	21.46	22.11	21.46	21.81	4750.0
2022-10-28	AAPD	ETF	27.27	27.28	25.48	25.83	838690.0
2022-10-28	AAPU	ETF	20.8	22.75	20.8	22.39	214805.0
2022-10-28	AAXJ	ETF	55.37	55.9	55.26	55.89	535100.0
2022-10-28	ABEQ	ETF	26.9	27.05	26.9	27.035	65800.0
2022-10-28	ACES	ETF	53.51	53.92	52.646	53.86	67000.0
2022-10-28	ACIO	ETF	29.28	29.645	29.28	29.62	12500.0
2022-10-28	ACSI	ETF	44.1172	44.1172	44.1172	44.1172	18.0
2022-10-28	ACT	ETF	25.36	26.03	25.36	25.75	332412.0
2022-10-28	ACTV	ETF	28.8	29.15	28.79	29.15	2549.0
2022-10-28	ACTX	ETF	0.51	0.51	0.4382	0.4382	405.0
2022-10-28	ACVF	ETF	29.06	29.646	29.06	29.646	6700.0
2022-10-28	ACWF	ETF	31.18	31.6622	31.18	31.6599	2835.0
2022-10-28	ACWI	ETF	81.85	83.42	81.77	83.32	5587800.0
2022-10-28	ACWV	ETF	91.8	93.23	91.8	93.23	141600.0
2022-10-28	ACWX	ETF	41.29	41.77	41.21	41.76	4419076.0
2022-10-28	ADFI	ETF	8.25	8.25	8.21	8.235	14800.0
2022-10-28	ADIV	ETF	11.34	11.375	11.34	11.375	300.0
2022-10-28	ADME	ETF	35.02	35.06	34.54	35.01	13000.0
2022-10-28	ADRE	ETF	32.31	32.54	32.05	32.54	5028.0
2022-10-28	AEMB	ETF	35.429	35.429	35.429	35.429	100.0
2022-10-28	AESR	ETF	11.52	11.68	11.52	11.576	55400.0
2022-10-28	AFIF	ETF	8.66	8.68	8.65	8.6551	15730.0
2022-10-28	AFK	ETF	15.43	15.59	15.165	15.45	12264.0
2022-10-28	AFSM	ETF	23.285	23.323	23.285	23.323	200.0
2022-10-28	AFTY	ETF	13.49	13.513	13.49	13.513	400.0
2022-10-28	AGG	ETF	95.01	95.46	94.98	95.22	6229200.0
2022-10-28	AGGH	ETF	22.14	22.14	22.095	22.095	127.0
2022-10-28	AGGY	ETF	41.61	41.775	41.61	41.7	167000.0
2022-10-28	AGNG	ETF	24.58	24.943	24.58	24.93	1300.0
2022-10-28	AGOV	ETF	81.46	81.46	79.003	80.49	1344.0
2022-10-28	AGOX	ETF	20.42	20.69	20.33	20.655	16800.0
2022-10-28	AGQ	ETF	20.91	21.22	20.36	20.95	888800.0
2022-10-28	AGZ	ETF	105.94	106.15	105.775	106.15	35015.0
2022-10-28	AGZD	ETF	22.715	22.78	22.695	22.75	140400.0
2022-10-28	AHHX	ETF	8.424	8.5299	8.42	8.4848	4978.0
2022-10-28	AHYB	ETF	43.286	43.36	43.286	43.36	300.0
2022-10-28	AIA	ETF	45.44	45.9	45.36	45.9	43406.0
2022-10-28	AIEQ	ETF	31.17	31.71	31.0	31.61	3800.0
2022-10-28	AIQ	ETF	19.43	19.79	19.43	19.74	14609.0
2022-10-28	AIRR	ETF	43.91	44.955	43.835	44.87	203300.0

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

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