Aave (fun fact: the name is taken from the Finnish word for "ghost") is a decentralized, open-source, and non-custodial protocol for liquidity market creation on Ethereum where depositors can earn interest on deposits and borrow assets. Less than one year since launching, the Aave Protocol’s market size surpassed $1 billion. The Aave Protocol is unique in that it tokenizes deposits as aTokens, which accrue interest in real time. It also features access to Flash Loans and Credit Delegation as uncollateralised loan options. Head over to https://aave.com/ to learn more!

Liquidity farming, was the solution adopted by early protocols of that defined DeFi as we know it today. In order to incentivise providing liquidity to the protocol, protocols minted and distributed their governance tokens in order to bootstrap their liquidity pools. In lending protocols like AAVE and Compound, users were incentivised to borrow against their deposits by providing governance tokens to borrowers and yield farming was born and truly away.

The key to maximize your gains in borrowing was to keep your LTV close to the threshhold so you can farm maximum amount from your deposited collateral. And these dangerous folks who loved living by the edge called themselves degens. What now is a common term, wasn't so common before. Now while APRs have reduced by a great deal, farmers still farm, cause gains are gains.

In this dashboard we will look at some of the top degens by their loan to collateral ratio. To qualify into this, we have also set a minimum collateral limit at $1 Million. So fortunately my address wont be showing up anywhere.

How was this data prepared ?

(Thanks to kakamora#2549 for giving the boiler plate to find the collateral ratio, check his submission here Aave Preferred Collateralization Ratio )

AAVE represents its lending and borrowing via a-Tokens. These tokens accrue interest by the block and can be used to denominate the amount borrowed. There are separate tokens for debt accrual and lending interest accrual.

These debt a-tokens can be tracked via the ethereum.daily_balances and thus we can get the total loan taken by a said user. Then by tracking the deposit a-tokens, we can get the total collateral provided by the user. Now we can cross reference with the aave.liquidations table and get all those addresses that have not experienced the liquidation sword.