Query editor
-- Crisis-week supply movements for all three Yuzu products.-- Uses the corrected syzUSD V2 address (0xc8a8df9b...).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.topic0, 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 '2026-04-01'AND l.block_time < DATE '2026-05-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),-- Snapshot supply at three key moments per tokensnapshots AS (SELECTtoken,'apr18_pre_exploit' AS phase,-- Latest cum_supply <= Apr 18 17:37 UTC(SELECT cum_supply_raw FROM supply_at saWHERE sa.token = s.token AND sa.block_time <= TIMESTAMP '2026-04-18 17:37:00'ORDER BY sa.block_time DESC, sa.block_number DESC LIMIT 1) AS supply_rawFROM (SELECT DISTINCT token FROM supply_at) s