Show total number of participants

[bajtos]

https://space-meridian.slack.com/archives/C07E0B56RKN/p1724177583985949

It would also be cool on the station website and dash to have the total number of FIL addresses to have ever submitted a measurement i.e. total user count

This should be very easy to implement:

• We already have daily_participants table, the data is exposed via “daily active participants” and “monthly active participants” endpoints.
• We can add another endpoint to expose the number of distinct participants over the entire history.

SELECT COUNT(DISTINCT participant_id) FROM daily_participants;

Count: 43,533
Query duration: 415ms