Query editor
-- Morpho USDC markets on Base: what borrowing did after a large net deposit day, beside markets with no inflow that week. May 20 to November 16, 2026.-- Reads a saved daily table of supply and debt per market built from the Morpho contract events. Markets that have held 1 million US dollars or more of debt, with 5 million or more supplied the day before.-- Markets with all supply lent out for a run of days and markets on Morpho's public exclusion list are left out.-- Large net deposit day: supply rose by 5 million US dollars or more and by 5 percent or more in one day; one event per market per 7 days. Events need 30 further days of data, so they end October 17.-- No inflow that week: a market day where supply moved by less than 1 percent over the next 7 days, sampled once a week per market.-- borrow_multiple = change in debt from the day before to 7 or 30 days after, divided by the day's net deposit. borrow_growth = the same change over debt the day before.WITH s AS (SELECT x.chain, x.market_id, x.day, x.supplied_usd, x.borrowed_usd,LAG(x.supplied_usd) OVER w AS sup_prev, LAG(x.borrowed_usd) OVER w AS bor_prev,LEAD(x.supplied_usd, 6) OVER w AS sup_7, LEAD(x.borrowed_usd, 6) OVER w AS bor_7, LEAD(x.borrowed_usd, 29) OVER w AS bor_30, LEAD(x.supplied_usd, 29) OVER w AS sup_30,MAX(x.days_pinned) OVER (PARTITION BY x.market_id) AS ever_pinnedFROM dune.paigeisonfire.result_borrow_collateral_market_state_daily xLEFT JOIN dune.paigeisonfire.result_borrow_collateral_market_exclusions e ON e.chain = x.chain AND e.market_id = x.market_idWHERE x.chain = 'base' AND x.day >= DATE '2026-05-01' AND e.market_id IS NULLWINDOW w AS (PARTITION BY x.market_id ORDER BY x.day)),c AS (SELECT s.*, r.market AS market_name,CASE WHEN supplied_usd - sup_prev >= 5e6 AND supplied_usd - sup_prev >= 0.05 * sup_prev THEN 'Large net deposit day'WHEN abs(sup_7 - sup_prev) < 0.01 * sup_prev AND day_of_week(day) = 1 THEN 'No inflow that week' END AS kindFROM s JOIN dune.paigeisonfire.result_borrow_collateral_market_registry r ON r.chain = s.chain AND r.market_id = s.market_idWHERE s.day BETWEEN DATE '2026-05-20' AND DATE '2026-10-17' AND s.sup_prev >= 5e6 AND s.bor_prev > 0 AND s.ever_pinned = 0 AND s.bor_30 IS NOT NULL),d AS (SELECT *, CASE WHEN kind = 'Large net deposit day' THEN date_diff('day', LAG(day) OVER (PARTITION BY market_id, kind ORDER BY day), day) END AS gap FROM c WHERE kind IS NOT NULL),k AS (SELECT kind, market_id, market_name, day, supplied_usd - sup_prev AS net_deposit_usd, sup_prev, bor_prev,(bor_7 - bor_prev) / NULLIF(supplied_usd - sup_prev, 0) AS mult_7, (bor_30 - bor_prev) / NULLIF(supplied_usd - sup_prev, 0) AS mult_30,(bor_7 - bor_prev) / bor_prev AS growth_7, (bor_30 - bor_prev) / bor_prev AS growth_30, (sup_30 - sup_prev) / sup_prev AS supply_growth_30FROM d WHERE kind = 'No inflow that week' OR gap IS NULL OR gap >= 7)SELECT kind, COUNT(*) AS market_days, COUNT(DISTINCT market_id) AS markets, SUM(CASE WHEN kind = 'Large net deposit day' THEN net_deposit_usd END) AS net_deposits_usd,approx_percentile(CASE WHEN kind = 'Large net deposit day' THEN mult_7 END, 0.5) AS median_borrow_multiple_7d,approx_percentile(CASE WHEN kind = 'Large net deposit day' THEN mult_7 END, 0.25) AS p25_borrow_multiple_7d, approx_percentile(CASE WHEN kind = 'Large net deposit day' THEN mult_7 END, 0.75) AS p75_borrow_multiple_7d,approx_percentile(CASE WHEN kind = 'Large net deposit day' THEN mult_30 END, 0.5) AS median_borrow_multiple_30d,approx_percentile(CASE WHEN kind = 'Large net deposit day' THEN mult_30 END, 0.25) AS p25_borrow_multiple_30d, approx_percentile(CASE WHEN kind = 'Large net deposit day' THEN mult_30 END, 0.75) AS p75_borrow_multiple_30d,approx_percentile(growth_7, 0.5) AS median_borrow_growth_7d, approx_percentile(growth_7, 0.25) AS p25_borrow_growth_7d, approx_percentile(growth_7, 0.75) AS p75_borrow_growth_7d,approx_percentile(growth_30, 0.5) AS median_borrow_growth_30d, approx_percentile(growth_30, 0.25) AS p25_borrow_growth_30d, approx_percentile(growth_30, 0.75) AS p75_borrow_growth_30d,approx_percentile(supply_growth_30, 0.5) AS median_supply_growth_30d,AVG(CASE WHEN growth_30 > 0 THEN 1e0 ELSE 0 END) AS share_with_more_debt_30d,DATE '2026-11-16' AS data_cutoffFROM k GROUP BY 1 ORDER BY 1