PREVIEW / etf_daily / 2022-08-09

all etf daily files

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

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-09	SPY	ETF	412.22	412.75	410.22	411.35	44931800.0
2022-08-09	QQQ	ETF	318.77	319.03	315.42	317.08	39764220.0
2022-08-09	IWM	ETF	192.04	192.17	189.16	190.19	18247300.0
2022-08-09	DIA	ETF	328.28	328.94	327.19	327.91	1655100.0
2022-08-09	GLD	ETF	167.48	167.8	166.82	167.2	3205500.0
2022-08-09	TLT	ETF	117.73	118.36	117.46	117.89	8223200.0
2022-08-09	AAA	ETF	24.33	24.33	24.33	24.33	0.0
2022-08-09	AAAU	ETF	17.85	17.87	17.77	17.81	637900.0
2022-08-09	AADR	ETF	51.49	51.49	51.17	51.31	500.0
2022-08-09	AAPU	ETF	24.83	25.11	24.83	24.9701	3433.0
2022-08-09	AAXJ	ETF	67.98	68.06	67.56	67.66	544300.0
2022-08-09	ABEQ	ETF	27.19	27.2	27.12	27.129	16400.0
2022-08-09	ACES	ETF	62.71	63.29	62.129	62.69	42100.0
2022-08-09	ACIO	ETF	30.471	30.55	30.42	30.53	82600.0
2022-08-09	ACSI	ETF	46.5334	46.5334	46.5334	46.5334	30.0
2022-08-09	ACT	ETF	26.08	26.28	25.8	26.04	248443.0
2022-08-09	ACTV	ETF	31.57	31.57	31.32	31.3824	2971.0
2022-08-09	ACTX	ETF	0.561	0.561	0.56	0.56	4020.0
2022-08-09	ACVF	ETF	30.92	30.93	30.895	30.9	5000.0
2022-08-09	ACWF	ETF	33.0237	33.0237	32.86	32.87	11754.0
2022-08-09	ACWI	ETF	89.8	89.89	89.25	89.44	3657200.0
2022-08-09	ACWV	ETF	97.61	98.14	97.61	97.86	73100.0
2022-08-09	ACWX	ETF	46.23	46.29	45.895	45.99	1911502.0
2022-08-09	ADFI	ETF	8.72	8.72	8.66	8.683	1500.0
2022-08-09	ADIV	ETF	13.72	13.72	13.72	13.72	100.0
2022-08-09	ADME	ETF	36.535	36.56	36.445	36.51	13900.0
2022-08-09	ADRE	ETF	39.42	39.42	39.2601	39.3	2782.0
2022-08-09	AEMB	ETF	39.35	39.36	39.085	39.085	2000.0
2022-08-09	AESR	ETF	11.9	11.95	11.9	11.91	6400.0
2022-08-09	AFIF	ETF	8.95	8.95	8.93	8.93	3859.0
2022-08-09	AFK	ETF	17.53	17.7088	17.4801	17.54	5925.0
2022-08-09	AFMC	ETF	22.621	22.621	22.621	22.621	100.0
2022-08-09	AFTY	ETF	17.22	17.25	17.22	17.25	100.0
2022-08-09	AGG	ETF	102.92	103.05	102.84	102.95	3854000.0
2022-08-09	AGGH	ETF	23.76	23.76	23.76	23.76	675.0
2022-08-09	AGGY	ETF	45.57	45.67	45.523	45.615	103000.0
2022-08-09	AGNG	ETF	26.34	26.35	26.26	26.33	1100.0
2022-08-09	AGOV	ETF	82.88	82.92	81.22	82.92	6996.0
2022-08-09	AGOX	ETF	21.83	21.83	21.708	21.78	10700.0
2022-08-09	AGQ	ETF	25.12	25.27	24.59	24.86	507800.0
2022-08-09	AGZ	ETF	110.18	110.29	110.13	110.29	12568.0
2022-08-09	AGZD	ETF	22.99	23.015	22.935	23.01	50200.0
2022-08-09	AHHX	ETF	8.79	8.81	8.7449	8.7449	1542.0
2022-08-09	AHYB	ETF	44.829	44.829	44.829	44.829	100.0
2022-08-09	AIA	ETF	59.79	59.94	59.2005	59.29	814817.0
2022-08-09	AIEQ	ETF	34.64	34.64	34.0	34.08	4300.0
2022-08-09	AIQ	ETF	22.79	22.79	22.53	22.62	6954.0
2022-08-09	AIRR	ETF	42.65	42.74	42.41	42.63	36000.0
2022-08-09	AIVI	ETF	36.25	36.37	36.16	36.2	6400.0
2022-08-09	AIVL	ETF	94.28	94.31	93.87	94.04	4300.0

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

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