parental-bronze

feyikemiparental-bronze

Updated 2025-03-23

SELECT

DISTINCT event_name,

-- tx_hash,

-- block_timestamp,

-- origin_from_address,

-- decoded_log,

-- COALESCE(decoded_log:amount / POW(10, 18), 0) AS amount, -- Converting to actual RON

-- COALESCE(decoded_log:user, decoded_log:delegator) AS user_address,

-- decoded_log:poolId AS pool_Id

FROM

ronin.core.ez_decoded_event_logs

WHERE

CONTRACT_ADDRESS = '0xe514d9deb7966c8be0ca922de8a064264ea6bcd4'

-- origin_to_address = '0x545edb750eb8769c868429be9586f5857a768758'

-- AND event_name IN ('Staked', 'Unstaked', 'RewardClaimed', 'Delegated', 'Undelegated'

Last run: 2 months ago

96B

flipside