Query editor
-- Two heuristics to locate the real syzUSD proxy address:-- 1) Top non-EOA recipients of yzUSD (the staking vault accumulates yzUSD)-- 2) All contracts on Plasma that emit many ERC-4626 Deposit events-- Route 1: top non-burn, non-self recipients of yzUSDWITH yzusd_transfers AS (SELECTbytearray_ltrim(topic2) AS to_addr_trimmed,bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS valueFROM plasma.logsWHERE contract_address = 0x6695c0f8706c5ace3bdf8995073179cca47926dcAND topic0 = keccak(to_utf8('Transfer(address,address,uint256)'))AND block_time >= DATE '2025-09-01'),route1 AS (SELECT'route1_top_yzusd_recipients' AS route,CAST(to_addr_trimmed AS VARCHAR) AS candidate_addr,COUNT(*) AS n_transfers,SUM(CAST(value AS DOUBLE)) / 1e6 AS total_yzusd_receivedFROM yzusd_transfersWHERE to_addr_trimmed <> 0x -- exclude burnsGROUP BY to_addr_trimmedORDER BY total_yzusd_received DESCLIMIT 10),-- Route 2: contracts emitting ERC-4626 Deposit(address,address,uint256,uint256)-- Exclude the two we already know (yzPP, yzUSD)deposit_emitters AS (SELECTcontract_address,COUNT(*) AS n_deposits,MIN(block_time) AS first_seen,MAX(block_time) AS last_seenFROM plasma.logsWHERE topic0 = keccak(to_utf8('Deposit(address,address,uint256,uint256)'))AND contract_address NOT IN (0xebfc8c2fe73c431ef2a371aea9132110aab50dca, -- yzPP0x6695c0f8706c5ace3bdf8995073179cca47926dc -- yzUSD)AND block_time >= DATE '2025-09-01'GROUP BY contract_addressORDER BY n_deposits DESCLIMIT 10),route2 AS (SELECT'route2_other_4626_deposit_emitters' AS route,CAST(contract_address AS VARCHAR) AS candidate_addr,n_deposits AS n_transfers,CAST(NULL AS DOUBLE) AS total_yzusd_receivedFROM deposit_emitters)SELECT * FROM route1UNION ALLSELECT * FROM route2ORDER BY route, n_transfers DESC;