SUM(olas_amount_usd) AS "total bonded volume",

COUNT(DISTINCT tx_hash) AS "total bonds",

SUM(CASE WHEN is_redeemed = True THEN olas_amount_usd ELSE 0 END) AS "total redeemed volume",

COUNT(DISTINCT CASE WHEN is_redeemed = True THEN tx_hash END) AS "total redeemed bonds",

(COUNT(DISTINCT CASE WHEN is_redeemed = True THEN tx_hash END) * 100.0) / COUNT(DISTINCT tx_hash) AS "percentage of bonds redeemed",

(SUM(CASE WHEN is_redeemed = True THEN olas_amount_usd ELSE 0 END) * 100.0) / SUM(olas_amount_usd) AS "percentage of volume redeemed"

crosschain.olas.ez_olas_bonding;