PREVIEW / etf_daily / 2022-07-28

all etf daily files

  file:    by_date/etf_daily/2022/2022-07-28.parquet
  size:    102 KB
  rows:    2,751

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-07-28	SPY	ETF	401.89	406.8	398.15	406.07	73966600.0
2022-07-28	QQQ	ETF	306.59	310.3965	302.745	309.81	55139941.0
2022-07-28	IWM	ETF	184.32	186.14	181.76	185.93	22838500.0
2022-07-28	DIA	ETF	322.45	326.12	319.81	325.23	2688400.0
2022-07-28	GLD	ETF	163.31	163.76	162.88	163.64	5606400.0
2022-07-28	TLT	ETF	118.05	118.92	117.32	117.75	16637900.0
2022-07-28	AAA	ETF	24.32	24.32	24.29	24.29	150.0
2022-07-28	AAAU	ETF	17.4	17.44	17.35	17.43	1172600.0
2022-07-28	AADR	ETF	50.14	50.59	50.14	50.59	500.0
2022-07-28	AAXJ	ETF	68.49	68.65	67.73	68.55	758900.0
2022-07-28	ABEQ	ETF	26.941	27.15	26.941	27.133	14300.0
2022-07-28	ACES	ETF	56.19	58.238	56.19	57.97	125200.0
2022-07-28	ACIO	ETF	29.97	30.31	29.97	30.22	26200.0
2022-07-28	ACSI	ETF	46.98	46.98	45.3775	45.3775	469.0
2022-07-28	ACT	ETF	22.83	22.99	22.7	22.91	133037.0
2022-07-28	ACTV	ETF	30.68	31.43	30.68	31.427	4499.0
2022-07-28	ACTX	ETF	0.699	0.699	0.699	0.699	1017.0
2022-07-28	ACVF	ETF	30.199	30.75	30.199	30.75	1000.0
2022-07-28	ACWF	ETF	32.47	32.917	32.47	32.917	11283.0
2022-07-28	ACWI	ETF	87.93	88.81	87.19	88.69	2597300.0
2022-07-28	ACWV	ETF	96.38	97.44	96.12	97.32	107200.0
2022-07-28	ACWX	ETF	45.82	46.18	45.51	46.1	1414455.0
2022-07-28	ADFI	ETF	8.7	8.72	8.635	8.72	117300.0
2022-07-28	ADIV	ETF	13.88	13.88	13.88	13.88	100.0
2022-07-28	ADME	ETF	35.88	36.21	35.54	36.17	42900.0
2022-07-28	ADRE	ETF	39.0994	39.62	38.81	39.6	2413.0
2022-07-28	AEMB	ETF	38.42	38.642	38.42	38.642	200.0
2022-07-28	AESR	ETF	11.7	11.86	11.64	11.85	15300.0
2022-07-28	AFIF	ETF	8.91	8.93	8.9	8.925	30828.0
2022-07-28	AFK	ETF	17.13	17.16	17.05	17.16	6678.0
2022-07-28	AFLG	ETF	23.985	23.985	23.985	23.985	100.0
2022-07-28	AFMC	ETF	22.731	22.731	22.731	22.731	100.0
2022-07-28	AFTY	ETF	17.66	17.734	17.66	17.734	500.0
2022-07-28	AGG	ETF	104.09	104.21	103.84	104.06	6473800.0
2022-07-28	AGGH	ETF	24.05	24.05	24.0445	24.0445	1166.0
2022-07-28	AGGY	ETF	45.94	46.02	45.865	45.95	104800.0
2022-07-28	AGIH	ETF	26.0699	26.0699	26.0191	26.04	400.0
2022-07-28	AGNG	ETF	26.15	26.505	26.15	26.42	1200.0
2022-07-28	AGOV	ETF	80.38	81.76	80.38	81.5	1100.0
2022-07-28	AGOX	ETF	23.38	23.38	21.063	21.44	52600.0
2022-07-28	AGQ	ETF	22.95	23.63	22.69	23.59	1456500.0
2022-07-28	AGZ	ETF	111.2	111.24	110.92	111.05	30513.0
2022-07-28	AGZD	ETF	22.885	22.975	22.84	22.87	268600.0
2022-07-28	AHHX	ETF	8.65	8.8099	8.65	8.7797	13364.0
2022-07-28	AIA	ETF	61.56	61.69	60.81	61.64	77751.0
2022-07-28	AIEQ	ETF	33.51	33.82	33.299	33.78	5900.0
2022-07-28	AIQ	ETF	22.14	22.38	21.99	22.32	5520.0
2022-07-28	AIRR	ETF	41.67	42.6	41.67	42.59	35000.0
2022-07-28	AIVI	ETF	35.84	36.09	35.69	36.06	12200.0
2022-07-28	AIVL	ETF	93.05	94.25	92.73	94.24	12800.0

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

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