Parcel #6weyqrdg5tjf4vm

WITH virtual_prices AS (
  SELECT
    median((e.deposit_amount / e.msol_minted)) as virtual_price,
    ep.epoch
  FROM
    solana.marinade.ez_liquid_staking_actions e
    INNER JOIN solana.gov.dim_epoch ep ON e.block_id BETWEEN ep.start_block
    AND ep.end_block
  WHERE
    ACTION_TYPE = 'deposit'
  GROUP BY
    epoch
  ORDER BY
    epoch DESC
  LIMIT {{total_epochs}}
), price_with_prev AS (
  SELECT
    vp.epoch,
    vp.virtual_price,
    LAG(vp.virtual_price) OVER (
      ORDER BY
        vp.epoch
    ) AS prev_virtual_price
  FROM
    virtual_prices vp
)
SELECT
  epoch,
  virtual_price,
  prev_virtual_price,
  CASE
    WHEN prev_virtual_price IS NOT NULL
    AND prev_virtual_price > 0 THEN (
      POWER(
        (virtual_price / prev_virtual_price),
        (365.0 / 2)
      ) - 1
    )
    ELSE NULL
  END AS apy
FROM
  price_with_prev
WHERE
  apy IS NOT NULL
ORDER BY
  epoch DESC