Query editor
-- jrUSDe share price (Apr 18+) using Strata team's official methodology:-- pps derived from convertToAssets call traces, SUM(output_0)/SUM(shares)-- in the latest block of each hour bucket.WITH hourly_blocks AS (SELECTdate_trunc('hour', call_block_time) AS hour,max(call_block_number) AS max_blockFROM strata_ethereum.jrusde_call_converttoassetsWHERE call_block_time >= TIMESTAMP '2026-04-18'GROUP BY 1),hourly_pps AS (SELECThb.hour,(sum(c.output_0) * 1e18) / NULLIF(sum(c.shares), 0) AS pps_scaledFROM hourly_blocks hbJOIN strata_ethereum.jrusde_call_converttoassets cON c.call_block_number = hb.max_blockWHERE c.call_block_time >= TIMESTAMP '2026-04-18'GROUP BY 1)SELECThour AS block_time,pps_scaled / 1e18 AS price_per_shareFROM hourly_ppsORDER BY hour ASC