Query editor
-- =====================================================================-- KAMINO CURRENT VALUES: latest Monday TVL + holders (partner-facing)-- =====================================================================-- Source: reporting DB upload dune.yieldxyz.dataset_kamino_tvl-- Stock snapshot — do not sum across Mondays.-- =====================================================================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)SELECTl.day AS as_of,ROUND(SUM(CAST(m.usd_amount AS DOUBLE)), 2) AS total_tvl_usd,COUNT(*) AS positions,COUNT(DISTINCT m.address) AS holders,COUNT(DISTINCT m.integration_id) AS integrations,COUNT(DISTINCT m.partner) AS partnersFROM mCROSS JOIN latest lWHERE CAST(m.event_date AS DATE) = l.dayGROUP BY l.day