luisqaEvmos Daily Validator Rewards
Updated 2023-05-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
evmos.core.fact_validators.LABEL AS Name,
evmos.core.fact_validators.RATE AS Rate,
evmos.core.fact_validators.delegator_shares / 1000000000000000000 AS VP,
evmos.core.fact_validators.delegator_shares / (
SELECT
SUM(evmos.core.fact_validators.delegator_shares)
FROM
evmos.core.fact_validators
) AS VP_Perc,
VP_Perc * Rate * 300000000 * 0.533333334 / 365 AS Daily_Rewards
FROM
evmos.core.fact_validators
WHERE
VP > 140000
ORDER BY
evmos.core.fact_validators.delegator_shares DESC
Run a query to Download Data