$ARENA Stakers Leaderboard

Ali3N$ARENA Stakers Leaderboard

Updated 6 hours ago

with claimrewardst as (

select distinct tx_hash

from avalanche.core.ez_decoded_event_logs

where origin_to_address = '0xeffb809d99142ce3b51c1796c096f5b01b4aaec4'

and event_name = 'Transfer'

and origin_function_signature = '0x2e1a7d4d'

and contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'

--and topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

--and origin_from_address = decoded_log:to

and decoded_log:value/1e18 = '0'

group by 1),

staket as (

select origin_from_address,

sum (decoded_log:value/1e18) as Staked_Volume

from avalanche.core.ez_decoded_event_logs

where origin_to_address = '0xeffb809d99142ce3b51c1796c096f5b01b4aaec4'

and event_name = 'Transfer'

and origin_function_signature = '0xb6b55f25'

and contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'

--and origin_from_address = decoded_log:from

group by 1),

unstaket as (

select origin_from_address,

sum (decoded_log:value/1e18) as Unstaked_Volume

from avalanche.core.ez_decoded_event_logs

where origin_to_address = '0xeffb809d99142ce3b51c1796c096f5b01b4aaec4'

and event_name = 'Transfer'

and origin_function_signature = '0x2e1a7d4d'

and contract_address = '0xb8d7710f7d8349a506b75dd184f05777c82dad0c'

and tx_hash not in (select distinct tx_hash from claimrewardst group by 1)

--and origin_from_address = decoded_log:to

group by 1)

select coalesce (t1.origin_from_address,t2.origin_from_address) as Wallet_Address,

Last run: about 6 hours agoAuto-refreshes every 12 hours

...

8802

513KB

52s

flipside