Query editor
-- =====================================================================-- KAMINO TVL BY MARKET / VAULT: latest Monday, for the pie chart + table-- =====================================================================-- Latest Monday Kamino TVL through Yield.xyz, split by market/vault.-- Reads the same upload as the other Kamino tiles (dune.yieldxyz.dataset_kamino_tvl),-- partner-facing only. Stock snapshot: one Monday, never summed across dates.-- Every market and vault is listed, however small.-- Names are the Yield.xyz API names (GET /v1/yields/{id} -> metadata.name, pulled 2026-10-13).-- "Kamino SOL Lending" = SOL supplied in Kamino's primary lending market (SOL/BTC Market).-- A new integration not listed below falls back to a readable version of its id.-- =====================================================================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),by_market AS (SELECTCASE m.integration_idWHEN 'solana-kamino-sol-a1so1bpd-vault' THEN 'Allez SOL'WHEN 'solana-kamino-usdc-a1usdzqd-vault' THEN 'Allez USDC'WHEN 'solana-kamino-usdt-a1usdt5b-vault' THEN 'Allez USDT'WHEN 'solana-kamino-usdc-a3htcwdn-vault' THEN 'Elemental USDC Turbo'WHEN 'solana-kamino-usdc-gfiw6eds-vault' THEN 'Gauntlet Frontier'WHEN 'solana-kamino-usdc-9e69u4gz-vault' THEN 'Gauntlet USDC Prime'WHEN 'solana-kamino-jlp-pyusd-2b1kv6dk-lending' THEN 'Kamino PYUSD Lending (JLP Market)'WHEN 'solana-kamino-usdc-91b1opzh-vault' THEN 'Kamino Private Credit USDC'WHEN 'solana-kamino-sol-lending' THEN 'Kamino SOL Lending'WHEN 'solana-kamino-bonk-sol-so111111-lending' THEN 'Kamino SOL Lending (Bonk Market)'WHEN 'solana-kamino-gm-sanctum-sol-so111111-lending' THEN 'Kamino SOL Lending (GM-Sanctum)'WHEN 'solana-kamino-gm-solblaze-sol-so111111-lending' THEN 'Kamino SOL Lending (GM-Solblaze)'WHEN 'solana-kamino-jito-sol-so111111-lending' THEN 'Kamino SOL Lending (Jito Market)'WHEN 'solana-kamino-marinade-sol-so111111-lending' THEN 'Kamino SOL Lending (Marinade Market)'WHEN 'solana-kamino-rstsol-bbsol-leverage-sol-so111111-lending' THEN 'Kamino SOL Lending (rstSOL/bbSOL Leverage Market)'WHEN 'solana-kamino-usdc-lending' THEN 'Kamino USDC Lending'WHEN 'solana-kamino-altcoins-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Altcoins Market)'WHEN 'solana-kamino-bitcoin-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Bitcoin Market)'WHEN 'solana-kamino-bonk-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Bonk Market)'WHEN 'solana-kamino-figure-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Figure Market)'WHEN 'solana-kamino-jto-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (JTO Market)'WHEN 'solana-kamino-jupiter-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Jupiter Market)'WHEN 'solana-kamino-maple-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Maple Market)'WHEN 'solana-kamino-onre-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (OnRe Market)'WHEN 'solana-kamino-pump-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (PUMP Market)'WHEN 'solana-kamino-zeus-bitcoin-usdc-epjfwdd5-lending' THEN 'Kamino USDC Lending (Zeus Bitcoin Market)'WHEN 'solana-kamino-bitcoin-usdg-2u1tszse-lending' THEN 'Kamino USDG Lending (Bitcoin Market)'WHEN 'solana-kamino-bonk-usdg-2u1tszse-lending' THEN 'Kamino USDG Lending (Bonk Market)'WHEN 'solana-kamino-jto-usdg-2u1tszse-lending' THEN 'Kamino USDG Lending (JTO Market)'WHEN 'solana-kamino-jupiter-usdg-2u1tszse-lending' THEN 'Kamino USDG Lending (Jupiter Market)'WHEN 'solana-kamino-usdt-lending' THEN 'Kamino USDT Lending'WHEN 'solana-kamino-fartcoin-usdt-es9vmfrz-lending' THEN 'Kamino USDT Lending (Fartcoin Market)'WHEN 'solana-kamino-jto-usdt-es9vmfrz-lending' THEN 'Kamino USDT Lending (JTO Market)'WHEN 'solana-kamino-cash-nssesc5s-vault' THEN 'Kamino Vault CASH'WHEN 'solana-kamino-sol-qaytekci-vault' THEN 'MEV Capital SOL'WHEN 'solana-kamino-usdc-epc2n3aa-vault' THEN 'MEV Capital USDC'WHEN 'solana-kamino-usdc-67dqmr76-vault' THEN 'Neutral Trade USDC Max Yield'WHEN 'solana-kamino-usdc-dwsxb18x-vault' THEN 'RockawayX RWA USDC'