Query editor
-- Which assets did stopped keepers maintain, and what happened to them after the Core Upgrade?-- feedId on Solana = array of 32 bytes -> converted to a 64-char hex string.-- Hex id -> symbol mapping built from (a) Douro Labs Aptos log (price_feed_id + identifier) and-- (b) decoded EVM PriceFeedUpdate events (id) joined to Douro Labs EVM log (identifier) by tx hash + log index.WITH u AS (SELECTcall_tx_signer AS keeper,array_join(transform(feedId, x -> format('%02x', ((x % 256) + 256) % 256)), '') AS feed_hex,CASEWHEN call_block_date >= DATE '2026-07-27' AND call_block_date < DATE '2026-08-24' THEN 'pre'WHEN call_block_date >= DATE '2026-08-31' AND call_block_date < DATE '2026-09-28' THEN 'post'END AS periodFROM pyth_solana.pyth_push_oracle_call_updatepricefeedWHERE call_block_date >= DATE '2026-07-27'AND call_block_date < DATE '2026-09-28'),u2 AS (SELECT * FROM u WHERE period IS NOT NULL),keeper_status AS (SELECT keeper,SUM(CASE WHEN period = 'pre' THEN 1 ELSE 0 END) AS pre_n,SUM(CASE WHEN period = 'post' THEN 1 ELSE 0 END) AS post_nFROM u2 GROUP BY 1),flagged AS (SELECT u2.*,(k.pre_n > 0 AND k.post_n = 0) AS by_stopped,u2.keeper IN ('FcEAifArzj9GaGorDyT4JjTfYbBWUHYjfqN6zrH6UVGR','4p16wya1Vw2u9w22oah4yXQgySb6eWKRRLMsEXCreish') AS by_mainFROM u2 JOIN keeper_status k ON k.keeper = u2.keeper),assets_of_stopped AS (SELECT DISTINCT feed_hex FROM flagged WHERE period = 'pre' AND by_stopped),per_asset AS (SELECTf.feed_hex,SUM(CASE WHEN period = 'pre' THEN 1 ELSE 0 END) AS pre_all,SUM(CASE WHEN period = 'pre' AND by_stopped THEN 1 ELSE 0 END) AS pre_by_stopped,SUM(CASE WHEN period = 'post' THEN 1 ELSE 0 END) AS post_all,SUM(CASE WHEN period = 'post' AND by_main THEN 1 ELSE 0 END) AS post_by_mainFROM flagged fJOIN assets_of_stopped s ON s.feed_hex = f.feed_hexGROUP BY 1),symbols AS (SELECT feed_hex, MAX(symbol) AS symbol, MAX(category) AS categoryFROM (SELECT lower(regexp_replace(price_feed_id, '^0x', '')) AS feed_hex,identifier AS symbol, categoryFROM dune.dourolabs.result_pyth_price_feed_update_log_aptosWHERE block_date >= DATE '2026-03-01'UNION ALLSELECT lower(to_hex(e.id)) AS feed_hex, d.identifier AS symbol, d.categoryFROM pyth_multichain.pythupgradable_evt_pricefeedupdate e