Try Quests to earn cryptoAnchor Collateral/Borrow Stats - Last 90 Days
For each question, we are interested in the underlying query(ies) and corresponding table(s) of the address-level data for each stat, rather than in a comprehensive analysis. Thank you for your help! 1. What are the average, median, and 10/90 percentile LTV ratios for each active address on Anchor in the last 90 days? 2. For each active Anchor borrower address, how many times and for how much of their collateral (absolute, and percentage) were they liquidated in the last 90 days?