Query editor
-- Junior share price per product (Apr 18+) using Strata team's-- official methodology:-- pps_scaled = SUM(output_0) * 1e18 / SUM(shares)-- across all convertToAssets calls in the latest block of each hour.---- Per-product source tables:-- jrUSDe -> strata_ethereum.jrusde_call_converttoassets (own schema)-- jrNUSD -> strata_ethereum.tranche_call_converttoassets filtered by addr-- jrmHYPER -> strata_ethereum.tranche_call_converttoassets filtered by addr---- jrNUSD addr : 0xfc807058a352b61aeef6a38e2d0fc3990225e772-- jrmHYPER addr: 0xeb205d26e9e605ec82d1c0d652e00037c278714bWITH all_calls AS (SELECT'jrUSDe' AS product,call_block_time,call_block_number,output_0,sharesFROM strata_ethereum.jrusde_call_converttoassetsWHERE call_block_time >= TIMESTAMP '2026-04-18'UNION ALLSELECTCASE contract_addressWHEN 0xfc807058a352b61aeef6a38e2d0fc3990225e772 THEN 'jrNUSD'WHEN 0xeb205d26e9e605ec82d1c0d652e00037c278714b THEN 'jrmHYPER'END AS product,call_block_time,call_block_number,output_0,sharesFROM strata_ethereum.tranche_call_converttoassetsWHERE call_block_time >= TIMESTAMP '2026-04-18'AND contract_address IN (0xfc807058a352b61aeef6a38e2d0fc3990225e772,0xeb205d26e9e605ec82d1c0d652e00037c278714b)),hourly_blocks AS (SELECTproduct,date_trunc('hour', call_block_time) AS hour,max(call_block_number) AS max_blockFROM all_callsWHERE product IS NOT NULLGROUP BY 1, 2),hourly_pps AS (SELECThb.product,hb.hour,(sum(c.output_0) * 1e18) / NULLIF(sum(c.shares), 0) / 1e18 AS ppsFROM hourly_blocks hbJOIN all_calls cON c.call_block_number = hb.max_blockAND c.product = hb.productGROUP BY 1, 2)SELECT