PREVIEW / etf_daily / 2022-08-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-08-02.parquet
  size:    102 KB
  rows:    2,758

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-08-02	SPY	ETF	409.12	413.0	406.82	408.06	63435400.0
2022-08-02	QQQ	ETF	312.92	318.545	311.8401	314.33	48676501.0
2022-08-02	IWM	ETF	186.47	189.02	185.48	187.0	17492600.0
2022-08-02	DIA	ETF	326.97	327.78	323.9	324.04	5394600.0
2022-08-02	GLD	ETF	165.66	166.46	164.02	164.05	5725400.0
2022-08-02	TLT	ETF	120.15	120.69	117.29	117.5	17896300.0
2022-08-02	AAA	ETF	24.26	24.29	24.26	24.26	121.0
2022-08-02	AAAU	ETF	17.66	17.73	17.46	17.53	12098300.0
2022-08-02	AADR	ETF	50.91	50.91	50.59	50.59	600.0
2022-08-02	AAXJ	ETF	66.7	67.81	66.59	67.05	942900.0
2022-08-02	ABEQ	ETF	27.05	27.15	26.886	26.886	10700.0
2022-08-02	ACES	ETF	58.22	61.18	58.22	60.58	102600.0
2022-08-02	ACIO	ETF	30.455	30.62	30.36	30.4	17700.0
2022-08-02	ACSI	ETF	45.9616	45.9616	45.9616	45.9616	89.0
2022-08-02	ACT	ETF	24.23	24.47	23.625	24.27	281265.0
2022-08-02	ACTV	ETF	31.43	31.76	31.39	31.393	7849.0
2022-08-02	ACTX	ETF	0.7	0.7	0.55	0.55	222.0
2022-08-02	ACVF	ETF	30.79	31.05	30.755	30.767	2500.0
2022-08-02	ACWF	ETF	32.9101	32.94	32.7969	32.7969	1440.0
2022-08-02	ACWI	ETF	89.08	89.85	88.63	88.83	3810700.0
2022-08-02	ACWV	ETF	97.25	97.78	96.93	97.01	189000.0
2022-08-02	ACWX	ETF	46.0	46.28	45.79	45.79	1447302.0
2022-08-02	ADFI	ETF	8.7	8.71	8.667	8.667	1200.0
2022-08-02	ADIV	ETF	13.58	13.61	13.58	13.585	300.0
2022-08-02	ADME	ETF	36.445	36.68	36.34	36.409	8600.0
2022-08-02	ADRE	ETF	38.3	39.0824	38.2488	38.67	7187.0
2022-08-02	AEMB	ETF	38.76	38.76	38.57	38.57	400.0
2022-08-02	AESR	ETF	11.97	11.99	11.9	11.91	9700.0
2022-08-02	AFIF	ETF	8.901	8.901	8.88	8.89	2403.0
2022-08-02	AFK	ETF	17.18	17.18	17.0239	17.09	8810.0
2022-08-02	AFSM	ETF	23.863	23.863	23.863	23.863	100.0
2022-08-02	AFTY	ETF	17.11	17.2	17.11	17.163	500.0
2022-08-02	AGG	ETF	104.27	104.35	103.14	103.16	6869400.0
2022-08-02	AGGH	ETF	24.01	24.01	23.8432	23.8432	1379.0
2022-08-02	AGGY	ETF	46.16	46.204	45.54	45.73	98800.0
2022-08-02	AGNG	ETF	26.25	26.31	26.0	26.0	1200.0
2022-08-02	AGOV	ETF	82.7	83.525	82.64	82.64	945.0
2022-08-02	AGOX	ETF	21.52	21.73	21.488	21.51	30400.0
2022-08-02	AGQ	ETF	24.39	24.6	23.52	23.54	952800.0
2022-08-02	AGZ	ETF	111.16	111.225	110.5176	110.59	18019.0
2022-08-02	AGZD	ETF	22.935	22.995	22.865	22.97	167600.0
2022-08-02	AHHX	ETF	8.77	8.78	8.71	8.74	1554.0
2022-08-02	AHYB	ETF	44.9	44.9	44.807	44.807	400.0
2022-08-02	AIA	ETF	58.76	59.9435	58.56	59.37	42125.0
2022-08-02	AIEQ	ETF	33.76	34.351	33.76	34.036	4300.0
2022-08-02	AIQ	ETF	22.3	22.729	22.3	22.56	11540.0
2022-08-02	AIRR	ETF	42.75	43.12	42.52	42.52	61400.0
2022-08-02	AIVI	ETF	36.28	36.29	35.95	35.95	1600.0
2022-08-02	AIVL	ETF	94.66	94.78	93.79	93.79	1500.0
2022-08-02	ALTL	ETF	42.27	43.08	42.07	42.59	108530.0

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

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