Query editor
-- =====================================================================-- KAMINO VAULT SUMMARY: one row per client vault-- =====================================================================-- Same measures and conventions as the client summary; no total row.-- Fees attribute to a vault via the share mint moving in the fee's own-- transaction. A client with ONE Kamino yield takes all its fees; for-- multi-vault clients an unmatched fee transfer stays unattributed, so-- these rows can sum to LESS than the client-level fee total.-- =====================================================================WITHclients (client, fee_recipient) AS (VALUES ('Deblock', 'E2bP5z64DKuLzJAJPbCVhEMHasKfDAt4iMksmvDvWVMr'),('Fordefi', 'CYh1x1yG9F6v5UPYJnJPEGFWLM7inpW8BdrnT5R11tZG')),registry (client, yield_id, vault_name, share_mint) AS (VALUES('Deblock','solana-kamino-sol-lending','Kamino SOL Lending', CAST(NULL AS VARCHAR)),('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 (SELECT partner, integration_id,MAX_BY(tvl_usd, day) AS tvl_usd,MAX(day) AS tvl_as_ofFROM tvl_daily GROUP BY 1, 2),acts AS (SELECT partner, integration_id,SUM(CASE WHEN action_type IN ('STAKE','DEPOSIT')THEN CAST(usd_amount AS DOUBLE) ELSE 0 END) AS inflow_usd,SUM(CASE WHEN action_type NOT IN ('STAKE','DEPOSIT')THEN CAST(usd_amount AS DOUBLE) ELSE 0 END) AS outflow_usd,COUNT_IF(action_type IN ('STAKE','DEPOSIT')) AS deposits,COUNT_IF(action_type NOT IN ('STAKE','DEPOSIT')) AS withdrawalsFROM dune.yieldxyz.dataset_kamino_actionsWHERE partner IN (SELECT client FROM clients) AND is_partner_facingGROUP BY 1, 2),uniq_vault AS (SELECT partner, integration_id, COUNT(DISTINCT address) AS unique_addressesFROM dune.yieldxyz.dataset_kamino_actionsWHERE partner IN (SELECT client FROM clients)AND is_partner_facingAND action_type IN ('STAKE','DEPOSIT')GROUP BY 1, 2),fee_txs AS (SELECT c.client, t.tx_id, t.block_date, t.amount_usd