PolygonRaw Data Block rewards

kirastudioPolygonRaw Data Block rewards

Updated 2023-08-31

-- select

-- count( distinct tx_hash ),

-- event_name

-- from

-- ethereum.core.ez_decoded_event_logs

-- where

-- origin_from_address = '0xb38b208c79855404c56025aca4a4ffa8da6f4810'

-- and origin_to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

-- group by 2

-- Total Rewards Earned

-- select

-- decoded_log:validatorId :: NUMBER as validator_id,

-- sum(decoded_log:amount :: NUMBER) / 1e18 as amount_rewards

-- from

-- ethereum.core.ez_decoded_event_logs

-- where

-- event_name = 'ClaimRewards'

-- and origin_to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

-- group by 1

-- order by 1 desc

-- TopUpFee

-- 0x63656798

-- select

-- decoded_log:user as validator_id,

-- sum(decoded_log:fee :: NUMBER) / 1e18 as heimdallFee

-- from

-- ethereum.core.ez_decoded_event_logs

-- where

-- event_name = 'TopUpFee'

-- and origin_to_address = '0x5e3ef299fddf15eaa0432e6e66473ace8c13d908'

-- group by 1

-- order by 1 desc

-- 7,657,030.66 MATIC

-- 7,629,266.650619 MATIC ( Staking Rewards )

-- 80787293.138603 ( Total Rewards distributed)

-- select

Run a query to Download Data

flipside