Query editor
-- =====================================================================-- UPSHIFT PARTNER OVERVIEW (query 8756106 "Upshift TVL by Partner")-- One row per partner: TVL on the latest Monday + all-time actions and volume.-- Every partner that ever had an Upshift position or action is listed, even at $0 TVL today.-- Partner-facing = every client (incl. their dev/test projects); internal Yield.xyz teams excluded.-- =====================================================================WITH t AS (SELECT *FROM dune.yieldxyz.dataset_upshift_tvlWHERE CAST(is_partner_facing AS VARCHAR) IN ('true', 't', '1', 'TRUE')),latest AS (SELECT MAX(CAST(event_date AS DATE)) AS day FROM t),tvl AS (SELECT t.partner,SUM(CAST(t.usd_amount AS DOUBLE)) AS tvl_usd,COUNT(DISTINCT t.address) AS holdersFROM tCROSS JOIN latest lWHERE CAST(t.event_date AS DATE) = l.dayGROUP BY 1),acts AS (SELECT partner,COUNT(*) AS actions,SUM(CAST(usd_amount AS DOUBLE)) AS volume_usd,SUM(CASE WHEN action_type = 'STAKE' THEN CAST(usd_amount AS DOUBLE) END) AS deposits_usd,SUM(CASE WHEN action_type = 'UNSTAKE' THEN CAST(usd_amount AS DOUBLE) END) AS withdrawals_usd,MAX(CAST(action_date AS DATE)) AS last_actionFROM dune.yieldxyz.dataset_upshift_actionsWHERE CAST(is_partner_facing AS VARCHAR) IN ('true', 't', '1', 'TRUE')GROUP BY 1),partners AS (SELECT partner FROM tvlUNIONSELECT partner FROM acts)SELECTp.partner,ROUND(COALESCE(v.tvl_usd, 0), 2) AS tvl_usd,COALESCE(v.holders, 0) AS holders,COALESCE(a.actions, 0) AS actions,ROUND(COALESCE(a.volume_usd, 0), 2) AS volume_usd,ROUND(COALESCE(a.deposits_usd, 0), 2) AS deposits_usd,ROUND(COALESCE(a.withdrawals_usd, 0), 2) AS withdrawals_usd,CAST(a.last_action AS VARCHAR) AS last_action -- "2026-07-31", no time partFROM partners pLEFT JOIN tvl v ON v.partner = p.partnerLEFT JOIN acts a ON a.partner = p.partnerORDER BY tvl_usd DESC, volume_usd DESC