SELECT

delegator_address,

validator_address,

action,

SUM(amount) / POWER(10, 6) AS total_amount

FROM

sei.gov.fact_staking_rewards

WHERE

tx_succeeded = TRUE

GROUP BY

delegator_address,

validator_address,

action

),

delegation_summary AS (

SELECT

delegator_address,

(SUM(amount) / POWER(10, 6)) AS volume_in_sei

FROM

sei.gov.fact_staking

WHERE

action = 'delegate'

AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'

GROUP BY

delegator_address

ORDER BY

volume_in_sei DESC

LIMIT 5

SELECT

v.validator_address,

CASE

WHEN v.validator_address = 'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' THEN 'Flipside'

WHEN v.validator_address = 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6' THEN 'Hype Infra'

WHEN v.validator_address = 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t' THEN 'Everstake'