Query editor
-- Debt in US dollars and the debt-weighted 30-day borrow rate, percent a year before rewards, of USDC markets by collateral class and day.-- A market is left out on days it is pinned at full utilization and from the day Morpho's own exclusion list names it.WITH reg AS (SELECT * FROM dune.paigeisonfire.result_borrow_collateral_market_registry)SELECT s.day, r.collateral_class, SUM(s.borrowed_usd) AS borrowed_usd,SUM(s.borrow_rate_30d * s.borrowed_usd) / SUM(s.borrowed_usd) * 100 AS borrow_rate_30d_pct, COUNT(*) AS marketsFROM dune.paigeisonfire.result_borrow_collateral_market_state_daily s JOIN reg r ON r.chain = s.chain AND r.market_id = s.market_idWHERE ('{{Chain}}' = 'All' OR r.chain_name = '{{Chain}}') AND s.days_pinned = 0 AND s.borrowed_usd >= (CASE '{{Minimum debt}}' WHEN '$5M' THEN 5e6 WHEN '$25M' THEN 25e6 WHEN '$100M' THEN 100e6 ELSE 1e6 END) AND r.collateral_class <> 'Unclassified'AND s.day >= date_add('day', -(CASE '{{Window}}' WHEN '90 days' THEN 90 WHEN '180 days' THEN 180 WHEN '1 year' THEN 365 ELSE 100000 END), current_date)AND NOT EXISTS (SELECT 1 FROM dune.paigeisonfire.result_borrow_collateral_market_exclusions x WHERE x.chain = s.chain AND x.market_id = s.market_id AND x.excluded_from <= s.day)GROUP BY 1, 2ORDER BY 1, 2