Query editor
with ankr_delegated as(select epoch, sum(net_trend) over (order by epoch) as total_delegatedfrom (select epoch, sum(ankr_amount) as net_trendfrom(select epoch, (cast(amount as double)/1e18) as ankr_amountfrom ankr_ethereum.AnkrTokenStaking_evt_Delegatedwhere evt_block_time >= date('2022-08-04') -- contract deployed) xgroup by 1order by 1 desc) t),ankr_undelegated as (select epoch, sum(net_trend) over (order by epoch) as total_undelegatedfrom (select epoch, sum(ankr_amount) as net_trendfrom(select epoch, (cast(amount as double)/1e18) as ankr_amountfrom ankr_ethereum.AnkrTokenStaking_evt_Undelegatedwhere evt_block_time >= date('2022-08-04') -- contract deployed) xgroup by 1order by 1 desc) t),ankr_redelegated as (select epoch, sum(net_trend) over (order by epoch) as total_redelegatedfrom (select epoch, sum(ankr_amount) as net_trendfrom(select epoch, (cast(amount as double)/1e18) as ankr_amountfrom ankr_ethereum.AnkrTokenStaking_evt_Redelegatedwhere evt_block_time >= date('2022-08-04') -- contract deployed) xgroup by 1order by 1 desc) t),total_staked_by_epoch as (select epoch, total_delegated - total_undelegated as current_staked_epochfrom ankr_delegated aleft join ankr_undelegated using (epoch)left join ankr_redelegated using (epoch)),validator_deposited as(select epoch, ankr_amount as rewards_amountfrom (select epoch, (cast(amount as double)/1e18) as ankr_amountfrom ankr_ethereum.AnkrTokenStaking_evt_ValidatorDeposited ) x),delegate_staking_apy as (select epoch, current_staked_epoch as current_staked_by_epoch,round((rewards_amount/current_staked_epoch)*5212, 2) as apyfrom total_staked_by_epochleft join validator_deposited using(epoch))select *from delegate_staking_apyorder by epoch desc