Query editor
-- Crisis-week outflow headline metrics for the Yuzu stack.WITH params AS (SELECT0xebfc8c2fe73c431ef2a371aea9132110aab50dca AS yzpp_addr,0x6695c0f8706c5ace3bdf8995073179cca47926dc AS yzusd_addr,0xc8a8df9b210243c55d31c73090f06787ad0a1bf6 AS syzusd_addr),raw_logs AS (SELECTCAST(l.block_time AS TIMESTAMP) AS block_time,l.block_number,l.topic1, l.topic2, l.data,CASE l.contract_addressWHEN (SELECT yzpp_addr FROM params) THEN 'yzPP'WHEN (SELECT yzusd_addr FROM params) THEN 'yzUSD'WHEN (SELECT syzusd_addr FROM params) THEN 'syzUSD'END AS tokenFROM plasma.logs lWHERE l.contract_address IN ((SELECT yzpp_addr FROM params),(SELECT yzusd_addr FROM params),(SELECT syzusd_addr FROM params))AND l.block_time >= DATE '2025-09-01'AND l.topic0 = keccak(to_utf8('Transfer(address,address,uint256)'))),deltas AS (SELECTtoken, block_time, block_number,CASEWHEN topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000THEN CAST(bytearray_to_uint256(bytearray_substring(data,1,32)) AS INT256)WHEN topic2 = 0x0000000000000000000000000000000000000000000000000000000000000000THEN -CAST(bytearray_to_uint256(bytearray_substring(data,1,32)) AS INT256)ELSE CAST(0 AS INT256)END AS delta_supplyFROM raw_logs),supply_at AS (SELECTtoken, block_time, block_number,SUM(delta_supply) OVER (PARTITION BY token ORDER BY block_number, block_timeROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cum_supply_rawFROM deltas),sn AS (SELECT 'syzUSD' AS tok, 'pre_crisis' AS lbl,(SELECT cum_supply_raw FROM supply_at WHERE token='syzUSD' AND block_time <= TIMESTAMP '2026-04-15 00:00:00' ORDER BY block_time DESC, block_number DESC LIMIT 1) AS sUNION ALL SELECT 'syzUSD', 'pre_slash',(SELECT cum_supply_raw FROM supply_at WHERE token='syzUSD' AND block_time <= TIMESTAMP '2026-04-24 03:14:00' ORDER BY block_time DESC, block_number DESC LIMIT 1)UNION ALL SELECT 'syzUSD', 'post_slash',(SELECT cum_supply_raw FROM supply_at WHERE token='syzUSD' AND block_time <= TIMESTAMP '2026-04-24 12:00:00' ORDER BY block_time DESC, block_number DESC LIMIT 1)UNION ALL SELECT 'yzUSD', 'pre_slash',(SELECT cum_supply_raw FROM supply_at WHERE token='yzUSD' AND block_time <= TIMESTAMP '2026-04-24 03:14:00' ORDER BY block_time DESC, block_number DESC LIMIT 1)UNION ALL SELECT 'yzUSD', 'post_slash',(SELECT cum_supply_raw FROM supply_at WHERE token='yzUSD' AND block_time <= TIMESTAMP '2026-04-24 12:00:00' ORDER BY block_time DESC, block_number DESC LIMIT 1)UNION ALL SELECT 'yzPP', 'pre_slash',(SELECT cum_supply_raw FROM supply_at WHERE token='yzPP' AND block_time <= TIMESTAMP '2026-04-24 03:14:00' ORDER BY block_time DESC, block_number DESC LIMIT 1)UNION ALL SELECT 'yzPP', 'post_slash',