articoloquintoAPE staking APR
    Updated 2022-12-07
    select 10500000*4*100/sum(amount) as "APE APR%" from(
    select sum(amount) as amount from ethereum.core.ez_token_transfers
    where contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'
    and to_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
    and origin_function_signature in ('0xbd5023a9', '0x9dcaafb4')
    union
    select -sum(amount) as amount from ethereum.core.ez_token_transfers
    where contract_address = '0x4d224452801aced8b2f0aebe155379bb5d594381'
    and from_address = '0x5954ab967bc958940b7eb73ee84797dc8a2afbb9'
    and origin_function_signature in ('0xe4e81847', '0x7f60d338'))
    Run a query to Download Data