Top 10 restaekers

datavortexTop 10 restaekers

Updated 2025-04-25

WITH restake_data AS (

SELECT

decoded_log:to AS restaker_address,

SUM(decoded_log:value) / 1e18 AS amount_staked

FROM

ethereum.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')

AND event_name = 'Transfer'

AND decoded_log:from = '0x0000000000000000000000000000000000000000'

AND decoded_log:to != '0x0000000000000000000000000000000000000000'

GROUP BY

decoded_log:to

top_restaker AS (

SELECT

restaker_address,

amount_staked,

ROW_NUMBER() OVER (ORDER BY amount_staked DESC) AS rank

FROM

restake_data

)

SELECT

restaker_address AS "Top Restaker",

amount_staked AS "Amount Staked (RSWETH)"

FROM

top_restaker

WHERE

rank <= 10;

Last run: 27 days ago

619B

81s

flipside