flipside

    worthy-gold
    datavortexworthy-gold
    Updated 2024-09-20
    /*
    WITH action_summary AS (
    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
    )
    SELECT
    a.validator_address,
    CASE
    WHEN a.validator_address = 'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' THEN 'Flipside'
    WHEN a.validator_address = 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6' THEN 'Hype Infra'
    WHEN a.validator_address = 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t' THEN 'Everstake'
    WHEN a.validator_address = 'seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74' THEN 'Rhino'
    WHEN a.validator_address = 'seivaloper1xm0pjt3qsdlc6u4n7fjpycqd5h7zwla7tz8m37' THEN 'Anchorage Digital'
    ELSE 'Unknown Validator'
    END AS validator_name,
    a.action,
    SUM(a.total_amount) AS total_amount
    FROM
    action_summary a
    GROUP BY
    a.validator_address,
    validator_name,
    a.action
    ORDER BY
    QueryRunArchived: QueryRun has been archived