Query editor
-- =====================================================================-- 2. UPSHIFT TVL OVER TIME (-> 2 line charts: TVL, Holders)-- Weekly Monday stock, split by network instead of Kamino's lending/vault.-- =====================================================================WITH m AS (SELECT *FROM dune.yieldxyz.dataset_upshift_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 network = 'monad'THEN CAST(usd_amount AS DOUBLE) ELSE 0 END), 2) AS monad_tvl_usd,ROUND(SUM(CASE WHEN network = 'ethereum'THEN CAST(usd_amount AS DOUBLE) ELSE 0 END), 2) AS ethereum_tvl_usdFROM mGROUP BY 1ORDER BY 1;