Query editor
-- Bank-run on yzUSD (the senior, supposedly-protected tranche)-- in the 3 hours following the April 24 slashing.WITH points AS (SELECT * FROM (VALUES-- (label, supply_yzUSD)('apr15_initial', 63155871.78),('apr18_pre_event', 61484414.65),('apr24_pre_slash', 61484414.65),('apr24_post_slash', 41991693.29)) AS t(label, supply))SELECT1 AS row_num,'yzUSD redeemed at strike (USD)' AS metric,- ((SELECT supply FROM points WHERE label='apr24_post_slash')- (SELECT supply FROM points WHERE label='apr24_pre_slash')) AS valueUNION ALLSELECT2,'yzUSD redeemed at strike (% of pre-slash supply)',- ((SELECT supply FROM points WHERE label='apr24_post_slash')- (SELECT supply FROM points WHERE label='apr24_pre_slash'))/ (SELECT supply FROM points WHERE label='apr24_pre_slash') * 100UNION ALLSELECT3,'yzUSD redeemed during crisis week (USD)',- ((SELECT supply FROM points WHERE label='apr24_post_slash')- (SELECT supply FROM points WHERE label='apr15_initial'))UNION ALLSELECT4,'yzUSD redeemed crisis-week (% of initial)',- ((SELECT supply FROM points WHERE label='apr24_post_slash')- (SELECT supply FROM points WHERE label='apr15_initial'))/ (SELECT supply FROM points WHERE label='apr15_initial') * 100ORDER BY row_num;