Query editor
WITH supply AS(SELECT date_trunc('day', evt_block_time) AS day, COUNT(DISTINCT "minter") AS lenderFROM compound_v2."cErc20_evt_Mint"WHERE evt_block_time > now() - interval '90 days' AND evt_block_time < now() - interval '1 days'GROUP BY 1ORDER BY 1 DESC),demand AS(SELECT date_trunc('day', evt_block_time) AS day, COUNT(DISTINCT "borrower") AS borrowerFROM compound_v2."cErc20_evt_Borrow"WHERE evt_block_time > now() - interval '90 days' AND evt_block_time < now() - interval '1 days'GROUP BY 1ORDER BY 1 DESC)SELECT s.day, lender, borrowerFROM supply sLEFT JOIN demand d ON s.day = d.dayWHERE lender NOT IN (SELECT borrower FROM demand)ORDER BY 1 DESC