Query editor
WITHrebase_logs AS (selectdate_trunc('day', evt_block_time) as day,MIN(rebasingCreditsPerToken) as rebasingCreditsPerTokenfromorigin_protocol_ethereum.OETH_evt_TotalSupplyUpdatedHighreswhereevt_block_number > 17197263 -- day we went liveGROUP BY1 -- dayORDER BYday),rebase_date_logs AS (selectdate_diff('day',lag(day) over (order byday),day) as day_diff,lag(rebasingCreditsPerToken) over (order byday) / cast(rebasingCreditsPerToken as double) as rebasingCreditsPerTokenRatio, -- cast because integer division performs truncation*fromrebase_logs),apr as (select-- check this from previous query-- (rebasingCreditsPerTokenRatio - 1) * 100 * 6400 * 365.25 / day_diff as apr,(rebasingCreditsPerTokenRatio - 1) * 100 * 365.25 / day_diff as apr, -- check this*fromrebase_date_logs),apy as (select-- check this from previous query-- ((1 + apr / 100 / 365.25) ^ (365.25 - 1)) * 100 - 100 as apy(power((1 + apr / 100 / (365.25 / day_diff)),(365.25 / day_diff)) -1) * 100 as apy,*fromapr)-- select-- *-- from-- apyselect