2scents, actually numbers you are quoting show some HCQ benefit across multiple studies. Even if each of them is below stat significance, they jointly will not be.
24% v 30% in placebo had symptoms
4 hospitalized v 8 or 10
1 died in both
0.27 events per year v 0.38
11.8 % v 14.3%
Cochrane review is a gold standard for meta-studies, trying to evaluate significance from multiple independent trials. Feb 2021 B Singh et al Chloroquine or hydroxychloroquine for prevention and treatment of COVID‐19 shows no benefit for HCQ in both treatment and prophylactics.