Query editor
-- Confirm the V2 syzUSD address is the active one and discover its events.WITH known AS (SELECT * FROM (VALUES(keccak(to_utf8('Transfer(address,address,uint256)')), 'Transfer'),(keccak(to_utf8('Approval(address,address,uint256)')), 'Approval'),(keccak(to_utf8('Deposit(address,address,uint256,uint256)')), 'Deposit (4626)'),(keccak(to_utf8('Withdraw(address,address,address,uint256,uint256)')), 'Withdraw (4626)'),(keccak(to_utf8('Paused(address)')), 'Paused'),(keccak(to_utf8('Unpaused(address)')), 'Unpaused'),(keccak(to_utf8('RoleGranted(bytes32,address,address)')), 'RoleGranted'),(keccak(to_utf8('RoleRevoked(bytes32,address,address)')), 'RoleRevoked'),(keccak(to_utf8('RoleAdminChanged(bytes32,bytes32,bytes32)')), 'RoleAdminChanged'),(keccak(to_utf8('Initialized(uint64)')), 'Initialized'),(keccak(to_utf8('Upgraded(address)')), 'Upgraded'),(keccak(to_utf8('AdminChanged(address,address)')), 'AdminChanged'),(keccak(to_utf8('BeaconUpgraded(address)')), 'BeaconUpgraded')) AS t(topic0, name))SELECTl.topic0,COALESCE(k.name, '??? (Yuzu-specific)') AS guess,COUNT(*) AS event_count,MIN(l.block_time) AS first_seen,MAX(l.block_time) AS last_seenFROM plasma.logs lLEFT JOIN known k ON l.topic0 = k.topic0WHERE l.contract_address = 0xc8a8df9b210243c55d31c73090f06787ad0a1bf6AND l.block_time >= DATE '2025-09-01'GROUP BY 1, 2ORDER BY event_count DESC;