Query editor
-- Purps (builder code 5000): daily volume and fees, UTC days.-- Read by purps-analytics.vercel.app via the Dune API. Keep column names stable.WITH f AS (SELECT evt_block_time AS t,abs(quoteDelta) / 1e18 AS vol,builderFee / 1e18 AS bfee,fee / 1e18 AS xfeeFROM nado_ink.offchainexchange_evt_builderfeepaymentWHERE builder = 5000)SELECT date_format(t, '%Y-%m-%d') AS day,sum(vol) AS volume_usd,sum(bfee) AS builder_fee_usd,sum(xfee) AS fee_usd,count(*) AS fillsFROM fGROUP BY 1UNION ALLSELECT 'last24h', sum(vol), sum(bfee), sum(xfee), count(*)FROM fWHERE t > now() - interval '24' hourORDER BY 1