PREVIEW / etf_daily / 2022-09-26

all etf daily files

  file:    by_date/etf_daily/2022/2022-09-26.parquet
  size:    105 KB
  rows:    2,821

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-09-26	SPY	ETF	366.41	370.21	363.03	364.31	92581200.0
2022-09-26	QQQ	ETF	275.03	279.49	273.56	274.37	71176694.0
2022-09-26	IWM	ETF	165.47	168.97	163.58	164.17	30597800.0
2022-09-26	DIA	ETF	294.6	296.24	291.5	292.72	4143400.0
2022-09-26	GLD	ETF	153.22	153.51	151.03	151.23	8240500.0
2022-09-26	TLT	ETF	105.36	105.41	103.22	103.68	25104600.0
2022-09-26	AAA	ETF	24.25	24.25	24.25	24.25	0.0
2022-09-26	AAAU	ETF	16.32	16.35	16.1	16.12	1848100.0
2022-09-26	AADR	ETF	44.87	44.87	43.66	43.8	1800.0
2022-09-26	AAPB	ETF	20.7	21.42	20.7	20.9994	1424.0
2022-09-26	AAPD	ETF	27.25	27.25	26.53	27.07	331673.0
2022-09-26	AAPU	ETF	21.41	22.2001	21.41	21.62	83290.0
2022-09-26	AAXJ	ETF	60.57	60.86	60.16	60.28	837100.0
2022-09-26	ABEQ	ETF	25.28	25.28	24.9	24.95	11900.0
2022-09-26	ACES	ETF	57.12	58.75	56.335	56.43	46100.0
2022-09-26	ACIO	ETF	28.51	28.54	28.39	28.39	78900.0
2022-09-26	ACSI	ETF	42.1113	42.1113	42.1113	42.1113	56.0
2022-09-26	ACT	ETF	22.39	22.74	22.09	22.22	173372.0
2022-09-26	ACTV	ETF	27.43	27.43	27.02	27.05	29721.0
2022-09-26	ACVF	ETF	27.36	27.62	27.27	27.315	5800.0
2022-09-26	ACWF	ETF	29.46	29.56	29.2017	29.3089	3011.0
2022-09-26	ACWI	ETF	79.32	80.07	78.56	78.86	7065600.0
2022-09-26	ACWV	ETF	90.04	90.51	89.4	89.73	168200.0
2022-09-26	ACWX	ETF	40.39	40.67	39.95	40.11	3283663.0
2022-09-26	ADFI	ETF	8.206	8.21	8.166	8.166	5300.0
2022-09-26	ADIV	ETF	12.29	12.29	12.29	12.29	300.0
2022-09-26	ADME	ETF	33.37	33.38	33.27	33.27	31900.0
2022-09-26	ADRE	ETF	35.415	35.5344	35.09	35.09	1567.0
2022-09-26	AEMB	ETF	36.29	36.29	35.9	35.9	4000.0
2022-09-26	AESR	ETF	10.78	10.79	10.73	10.756	20600.0
2022-09-26	AFIF	ETF	8.73	8.73	8.6801	8.7	91535.0
2022-09-26	AFK	ETF	15.22	15.6	14.91	15.1102	9900.0
2022-09-26	AFLG	ETF	21.68	21.706	21.68	21.706	200.0
2022-09-26	AFSM	ETF	20.67	20.67	20.543	20.543	800.0
2022-09-26	AFTY	ETF	15.523	15.523	15.523	15.523	100.0
2022-09-26	AGG	ETF	96.87	96.91	95.87	95.95	9009900.0
2022-09-26	AGGH	ETF	22.81	22.83	22.8068	22.8068	606.0
2022-09-26	AGGY	ETF	42.51	42.511	41.97	42.08	496000.0
2022-09-26	AGIH	ETF	23.9493	23.9493	23.89	23.89	300.0
2022-09-26	AGNG	ETF	23.21	23.21	22.96	23.015	2500.0
2022-09-26	AGOV	ETF	79.26	79.26	77.43	78.9068	2942.0
2022-09-26	AGOX	ETF	19.62	19.66	19.26	19.385	176900.0
2022-09-26	AGQ	ETF	20.47	20.9	19.36	19.42	1287300.0
2022-09-26	AGZ	ETF	106.69	106.73	105.62	106.28	83786.0
2022-09-26	AGZD	ETF	22.855	22.89	22.805	22.815	57200.0
2022-09-26	AHHX	ETF	8.16	8.16	8.07	8.11	3780.0
2022-09-26	AHYB	ETF	41.81	41.81	41.56	41.6	2100.0
2022-09-26	AIA	ETF	52.26	52.56	51.95	52.05	77552.0
2022-09-26	AIEQ	ETF	29.08	29.39	28.55	28.579	6600.0
2022-09-26	AIQ	ETF	19.45	19.735	19.315	19.4	29442.0

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

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