Query editor
-- =====================================================================-- KAMINO CLIENT SUMMARY: one row per client-- =====================================================================-- Solana/Kamino counterpart to 03_client_summary.sql.-- * TVL / flows / counts -> dune.yieldxyz.dataset_kamino_tvl / _actions-- * fees -> on-chain transfers INTO the client's Yield.xyz fee recipient-- (Solana has no Harvested event; fees are plain token transfers)-- Conventions copied from 03: vaults come from the registry (not the event-- stream), active = tvl_usd > 1, unique addresses are deposit owners and are-- deduped per client - never summed across vaults.-- =====================================================================WITHclients (client, fee_recipient) AS (VALUES ('Deblock', 'E2bP5z64DKuLzJAJPbCVhEMHasKfDAt4iMksmvDvWVMr'),('Fordefi', 'CYh1x1yG9F6v5UPYJnJPEGFWLM7inpW8BdrnT5R11tZG')),-- ================= KAMINO YIELD REGISTRY =================registry (client, yield_id, vault_name, share_mint) AS (VALUES-- Deblock('Deblock','solana-kamino-sol-lending','Kamino SOL Lending', CAST(NULL AS VARCHAR)),-- Fordefi('Fordefi','solana-kamino-usdc-dwsxb18x-vault','RockawayX RWA USDC','DgHN3q3dSYAchNX7V3D4aYiTWMx8RHTgHbfPiwiqBkE9'),('Fordefi','solana-kamino-usdc-9e69u4gz-vault','Gauntlet USDC Prime','9YHNzyKwsdZ54GirTp6wSMweL9twT6sxF9RJPeE6aXem'),('Fordefi','solana-kamino-usdc-gfiw6eds-vault','Gauntlet Frontier','7oPz5dFNUgVtWNChqJW4ud8fhECVq5m75BN1t4WMLpxA')),tvl_daily AS (SELECT partner, integration_id,CAST(event_date AS DATE) AS day,SUM(CAST(usd_amount AS DOUBLE)) AS tvl_usdFROM dune.yieldxyz.dataset_kamino_tvlWHERE partner IN (SELECT client FROM clients) AND is_partner_facingGROUP BY 1, 2, 3),tvl_latest AS ( -- stock snapshot: latest per vault, never summed over daysSELECT partner, integration_id, MAX_BY(tvl_usd, day) AS tvl_usdFROM tvl_daily GROUP BY 1, 2),acts AS (SELECT partner, integration_id,SUM(CAST(usd_amount AS DOUBLE)) AS volume_usdFROM dune.yieldxyz.dataset_kamino_actionsWHERE partner IN (SELECT client FROM clients) AND is_partner_facingGROUP BY 1, 2),-- Driven from the REGISTRY, so a yield with no uploaded rows still counts-- as a vault and reports 0.per_yield AS (SELECT r.client,COALESCE(t.tvl_usd, 0) AS tvl_usd,COALESCE(a.volume_usd, 0) AS volume_usdFROM registry rLEFT JOIN tvl_latest t ON t.partner = r.client AND t.integration_id = r.yield_idLEFT JOIN acts a ON a.partner = r.client AND a.integration_id = r.yield_id),