PREVIEW / etf_daily / 2022-05-24

all etf daily files

  file:    by_date/etf_daily/2022/2022-05-24.parquet
  size:    101 KB
  rows:    2,731

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-05-24	SPY	ETF	392.56	395.15	386.96	393.89	91448800.0
2022-05-24	QQQ	ETF	288.125	288.86	282.25	287.24	73491124.0
2022-05-24	IWM	ETF	176.57	176.93	172.33	175.57	26861800.0
2022-05-24	DIA	ETF	316.57	320.15	313.62	319.39	5260500.0
2022-05-24	GLD	ETF	173.47	174.41	173.35	174.13	6794000.0
2022-05-24	TLT	ETF	117.9	119.64	117.86	118.86	23388200.0
2022-05-24	AAA	ETF	24.455	24.455	24.455	24.455	12.0
2022-05-24	AAAU	ETF	18.47	18.57	18.47	18.54	512100.0
2022-05-24	AADR	ETF	55.27	55.51	55.19	55.51	1000.0
2022-05-24	AAXJ	ETF	68.48	68.57	67.76	68.27	2921300.0
2022-05-24	ABEQ	ETF	28.4	28.74	28.39	28.69	10900.0
2022-05-24	ACES	ETF	49.31	49.63	47.98	48.53	98600.0
2022-05-24	ACIO	ETF	28.96	29.1	28.69	29.04	179800.0
2022-05-24	ACSI	ETF	42.35	42.678	42.35	42.678	1292.0
2022-05-24	ACT	ETF	23.91	24.14	23.41	23.84	367568.0
2022-05-24	ACTV	ETF	31.14	31.28	30.9802	31.2179	9074.0
2022-05-24	ACTX	ETF	0.8	0.8	0.7356	0.7356	1032.0
2022-05-24	ACVF	ETF	29.83	29.83	29.557	29.82	3100.0
2022-05-24	ACWF	ETF	33.35	33.35	33.0	33.34	5789.0
2022-05-24	ACWI	ETF	88.42	88.86	87.42	88.63	1764600.0
2022-05-24	ACWV	ETF	97.26	98.12	96.76	97.94	229800.0
2022-05-24	ACWX	ETF	48.31	48.43	47.937	48.35	2852707.0
2022-05-24	ADFI	ETF	8.68	8.7	8.67	8.695	4200.0
2022-05-24	ADIV	ETF	14.44	14.44	13.91	14.383	3900.0
2022-05-24	ADME	ETF	35.865	36.13	35.588	36.04	108600.0
2022-05-24	ADRE	ETF	38.96	38.96	38.4	38.74	5525.0
2022-05-24	AESR	ETF	11.55	11.6	11.32	11.557	66400.0
2022-05-24	AFIF	ETF	8.9825	9.0	8.97	8.995	30970.0
2022-05-24	AFK	ETF	18.9	18.95	18.74	18.8	3644.0
2022-05-24	AFLG	ETF	23.63	23.81	23.615	23.73	600.0
2022-05-24	AFSM	ETF	22.61	22.92	22.6	22.878	5200.0
2022-05-24	AFTY	ETF	16.741	16.741	16.741	16.741	100.0
2022-05-24	AGG	ETF	103.14	103.74	103.13	103.61	10332300.0
2022-05-24	AGGH	ETF	23.9331	23.9532	23.9331	23.9532	150.0
2022-05-24	AGGY	ETF	45.56	45.8	45.56	45.7	196400.0
2022-05-24	AGNG	ETF	25.52	25.752	25.52	25.752	7700.0
2022-05-24	AGOV	ETF	80.43	80.43	80.4	80.4	129.0
2022-05-24	AGOX	ETF	21.27	21.391	21.057	21.34	109900.0
2022-05-24	AGQ	ETF	29.39	29.97	29.23	29.73	615500.0
2022-05-24	AGZ	ETF	110.82	111.28	110.82	110.91	140652.0
2022-05-24	AGZD	ETF	22.925	22.955	22.895	22.92	97600.0
2022-05-24	AHHX	ETF	9.0322	9.0937	9.0003	9.0937	13452.0
2022-05-24	AHYB	ETF	44.51	44.69	44.51	44.69	900.0
2022-05-24	AIA	ETF	61.92	61.92	61.0	61.31	38907.0
2022-05-24	AIEQ	ETF	32.78	32.78	31.888	32.432	5900.0
2022-05-24	AIQ	ETF	21.34	21.34	20.86	21.04	22547.0
2022-05-24	AIRR	ETF	38.07	38.49	37.58	38.445	13900.0
2022-05-24	AIVI	ETF	39.25	39.44	39.17	39.43	9200.0
2022-05-24	AIVL	ETF	93.9	94.57	92.87	94.34	5000.0
2022-05-24	ALTL	ETF	41.84	42.5	41.65	42.44	135010.0

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

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