datavortexTop Stakers
    Updated 2024-11-20
    WITH staking AS (
    SELECT
    tx_hash,
    staker_address
    FROM
    crosschain.olas.ez_olas_staking
    )
    SELECT
    staker_address,
    COUNT(DISTINCT tx_hash) AS "number of stakes"
    FROM
    staking
    GROUP BY
    staker_address
    ORDER BY
    "number of stakes" DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived