Query editor
-- Ethena Combined: sUSDe APY (Ethena method) + Revenue + ENA Price-- APY = trailing 7d avg daily rate, annualised with weekly compoundingWITH rewards AS (SELECTdate_trunc('day', evt_block_time) AS day,SUM(CAST(value AS double) / 1e18) AS daily_rewardsFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x4c9EDD5852cd905f086C759E8383e09bff1e68b3AND "to" = 0x9D39A5DE30e57443BfF2A8307A4256c8797A3497AND "from" = 0xf2fa332bd83149c66b09b45670bce64746c6b439GROUP BY 1),vault_flows AS (SELECTdate_trunc('day', evt_block_time) AS day,SUM(CASEWHEN "to" = 0x9D39A5DE30e57443BfF2A8307A4256c8797A3497THEN CAST(value AS double) / 1e18WHEN "from" = 0x9D39A5DE30e57443BfF2A8307A4256c8797A3497THEN -CAST(value AS double) / 1e18ELSE 0END) AS net_flowFROM erc20_ethereum.evt_TransferWHERE contract_address = 0x4c9EDD5852cd905f086C759E8383e09bff1e68b3AND ("to" = 0x9D39A5DE30e57443BfF2A8307A4256c8797A3497OR "from" = 0x9D39A5DE30e57443BfF2A8307A4256c8797A3497)GROUP BY 1),vault_tvl AS (SELECTday,SUM(net_flow) OVER (ORDER BY day) AS staked_usdeFROM vault_flows),daily_rate AS (SELECTr.day,r.daily_rewards,v.staked_usde,r.daily_rewards / NULLIF(v.staked_usde, 0) AS rateFROM rewards rJOIN vault_tvl v ON r.day = v.dayWHERE v.staked_usde > 0),smoothed AS (SELECTday,daily_rewards,staked_usde,rate,AVG(rate) OVER (ORDER BY day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS avg_daily_rate_7d