flipside

    Top 10 validator by volume of redelegate
    Abolfazl_771025Top 10 validator by volume of redelegate
    Updated 2023-02-10
    SELECT
    b.label AS validator,
    sum(AMOUNT*power(10,-DECIMAL)) AS volume
    from osmosis.core.fact_staking A
    LEFT OUTER JOIN osmosis.core.dim_labels B ON A.VALIDATOR_ADDRESS = B.ADDRESS
    WHERE ACTION = 'redelegate'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10
    Run a query to Download Data