-- forked from everest3 @ https://flipsidecrypto.xyz/edit/queries/0f24e879-ff12-4496-be73-b51701ca4979

with tb1 as (select

BLOCK_TIMESTAMP,

tx_hash,

DECODED_LOG:multisig as multisig,

DECODED_LOG:owner as owner,

DECODED_LOG:serviceId as serviceId,

DECODED_LOG:reward / 1e18 as reward

from gnosis.core.ez_decoded_event_logs

where CONTRACT_ADDRESS = '0x5add592ce0a1b5dcecebb5dcac086cd9f9e3ea5c'

and EVENT_NAME = 'ServiceUnstaked'

select

serviceId,

round(sum(reward),3) as "Total reward"

from tb1

group by 1 having "Total reward" > 0