Query editor
-- =====================================================================-- KAMINO TVL BY PARTNER: latest Monday breakdown-- =====================================================================WITH m AS (SELECT *FROM dune.yieldxyz.dataset_kamino_tvlWHERE CAST(is_partner_facing AS VARCHAR) IN ('true', 't', '1', 'TRUE')),latest AS (SELECT MAX(CAST(event_date AS DATE)) AS day FROM m)SELECTm.partner,m.integration_type,ROUND(SUM(CAST(m.usd_amount AS DOUBLE)), 2) AS tvl_usd,COUNT(DISTINCT m.address) AS holders,COUNT(*) AS positions,COUNT(DISTINCT m.integration_id) AS integrationsFROM mCROSS JOIN latest lWHERE CAST(m.event_date AS DATE) = l.dayGROUP BY m.partner, m.integration_typeORDER BY tvl_usd DESC