Query editor
-- Yuzu PPS tracker — HOURLY granularity, pivoted (one column per token).-- End-of-hour binning: each row reflects state at HH:59:59 UTC.WITH params AS (SELECT0xebfc8c2fe73c431ef2a371aea9132110aab50dca AS yzpp_addr,0x6695c0f8706c5ace3bdf8995073179cca47926dc AS yzusd_addr,0xc8a8df9b210243c55d31c73090f06787ad0a1bf6 AS syzusd_addr,0x7785ecc75caab791a0d532b31f9bea69c91774264c030c48f0841cb3a91be2b2 AS poolupdated_topic0,1000000 AS ppm_scale,86400 AS seconds_per_day,CAST('{{focus_start}}' AS TIMESTAMP) AS focus_start,CAST('{{focus_end}}' AS TIMESTAMP) AS focus_end),raw_logs AS (SELECTCAST(l.block_time AS TIMESTAMP) AS block_time,l.block_number, l.tx_hash, l.index,l.contract_address, l.topic0, l.topic1, l.topic2, l.topic3, 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'),token_scaling AS (SELECT * FROM (VALUES('yzPP', 1e12),('yzUSD', 1e12),('syzUSD', 1.0)) AS t(token, pps_scale)),transfers AS (SELECT token, block_time, block_number,topic1 AS from_topic, topic2 AS to_topic,bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS valueFROM raw_logsWHERE topic0 = keccak(to_utf8('Transfer(address,address,uint256)'))),supply_deltas AS (SELECT token, block_time, block_number,CASEWHEN from_topic = 0x0000000000000000000000000000000000000000000000000000000000000000THEN CAST(value AS INT256)WHEN to_topic = 0x0000000000000000000000000000000000000000000000000000000000000000THEN -CAST(value AS INT256)ELSE CAST(0 AS INT256)END AS delta_supplyFROM transfers),supply_timeline AS (SELECT token, block_time, block_number,