Query editor
-- =====================================================================-- 1. UPSHIFT CURRENT VALUES (-> 3 counters: TVL, Holders, Partners)-- Latest Monday stock. Do not sum across Mondays.-- =====================================================================WITH m AS (SELECT *FROM dune.yieldxyz.dataset_upshift_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)SELECTl.day AS as_of,ROUND(SUM(CAST(m.usd_amount AS DOUBLE)), 2) AS total_tvl_usd,COUNT(*) AS positions,COUNT(DISTINCT m.address) AS holders,COUNT(DISTINCT m.integration_id) AS integrations,COUNT(DISTINCT m.partner) AS partners,COUNT(DISTINCT m.network) AS networksFROM mCROSS JOIN latest lWHERE CAST(m.event_date AS DATE) = l.dayGROUP BY l.day;