Query editor
-- =====================================================================-- KAMINO TVL OVER TIME: weekly Monday stock (partner-facing)-- =====================================================================WITH m AS (SELECT *FROM dune.yieldxyz.dataset_kamino_tvlWHERE CAST(is_partner_facing AS VARCHAR) IN ('true', 't', '1', 'TRUE'))SELECTCAST(event_date AS DATE) AS day,ROUND(SUM(CAST(usd_amount AS DOUBLE)), 2) AS tvl_usd,COUNT(DISTINCT address) AS holders,COUNT(*) AS positions,ROUND(SUM(CASE WHEN integration_type = 'lending'THEN CAST(usd_amount AS DOUBLE) ELSE 0 END), 2) AS lending_tvl_usd,ROUND(SUM(CASE WHEN integration_type = 'vault'THEN CAST(usd_amount AS DOUBLE) ELSE 0 END), 2) AS vault_tvl_usdFROM mGROUP BY 1ORDER BY 1