Flash challenge_borrowing on Aave

    Create a dashboard that covers and answers the questions below: How many unique borrowers of SNX, UNI, & MKR are there on Aave V2? What is total cumulative borrow for each asset on Aave V2? Can you visualize borrowing of each asset over time?


    Aave:

    Aave is a decentralized cryptocurrency platform that allows users to borrow and lend crypto. Aave uses smart contracts to automate the process, with preset rules on how funds are distributed, how collateral is handled, and how fees are assessed. 

    Aave specializes in overcollateralized loans, meaning that users will need to deposit crypto worth more than the amount that they wish to borrow. This protects lenders from losing money due to loan defaults and allows the Aave protocol to liquidate the collateral if it drops too much in value.

    Aave also offers a native crypto token (AAVE) that can be traded on most exchanges or staked in the Aave platform to earn interest. Staking is how crypto miners earn rewards for validating transactions on a proof-of-stake blockchain like the one that underlies Aave.1

    KEY TAKEAWAYS

    • Aave is a decentralized crypto lending platform.
    • Aave requires collateral, as users will need to deposit crypto to borrow.
    • Aave offers a native token (AAVE) that can earn interest through staking.
    • Aave borrowers risk liquidation of collateral if the value of that collateral drops too far.

    Intro: in this analysis we will take a look into the Aave three assets: MKR,SNX and UNI borrowing metrics to see how they behave on borrowing.

    we will also go in details with withdraw and depsoits as well to see how users behave.

    using Aave tables

    resource:

    db_img

    MKR:

    Maker (MKR) is the governance token of Maker Protocol, which token holders get to decide on the policies regarding Dai, the stablecoin issued by Maker decentralized autonomous organization (DAO).

    Today, there are more than 400 applications that have integrated Dai into payments, NFTs, DeFi gaming, and many more. Holders of MKR will get to participate in the process of governing Dai. This includes matters regarding upgrades to the platform, adjusting risk parameters, adding new collateral asset types, etc.

    SNX:

    Synthetix Network Token (SNX)

    Synthetix Network Token (SNX) is an Ethereum token that powers Synthetix, a decentralised synthetic asset issuance protocol. Synthetic assets are minted when token holders stake their SNX as collateral using Mintr, a decentralised application for interacting with the Synthetix contracts. The protocol currently supports synthetic fiat currencies, cryptocurrencies, and commodities.

    One of the most common requests we hear from customers is to be able to buy and sell more cryptocurrencies on Coinbase. We announced a process for listing assets, designed in part to accelerate the addition of more cryptocurrencies. We are also investing in new tools to help people understand and explore cryptocurrencies. We launched informational asset pages (see AAVEBNT, and SNX), as well as a new section of the Coinbase website to answer common questions about crypto.

    Customers can sign up for a Coinbase account here to buy, sell, convert, send, receive, or store AAVE, BNT, and SNX today.

    UNI:

    The UNI cryptocurrency is based on the AMM (Automatic Market Maker) protocol, created on the basis of Ethereum, because of it, users can exchange ERC20 standard tokens among themselves (in our case, this is the internal UNI token). The peculiarity of the Uniswap exchange is that, unlike many traditional exchanges, it does not require registration or identity verification.

    UNI is a governance token for the decentralized exchange Uniswap, hence its value is largely determined by how many people value the power to govern (through votes and proposal orientation) the Uniswap software.

    db_img
    db_img
    db_img
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    > in the above bar chart you can see the first bar chart that contains total borrowers for each asset.whic for MKR is 477 and SNX is 467 and UNI is 551 which you can see the donut for percetnage too and also under the bar chart you can see the stats for usd borrowed over time which the higehst rate is for jan18,2022 with 82M and for tokens on the right side it is jun20 with 2.7M in tokens borrowed which is a high number and for borrowers over time you can see 27 borrowers on jun22 is the top point overtime and the rest you can see and compare them together also you can see the numbers for total token and usd borrowed overtime clearly

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    next we look at the repayments first total stats then daily stats for MKR we see 457 payers for SNX there are 429 payers and for UNI there are 498 payers totaly you can see the onut percentage chart too then there is the repayed usd and token charts which MKR is above all with 238M SNX 227m and UNI with 177M.

    and for tokens MKR with 197K tokens last place second for UNI with 11k and first place for SNX with 40M tokens.

    > and for the transactions daily stats you can see clearly that aug19, 2020 is the highest places for transactions with 31 TXs and for payers aug13,2020 with 24 payers total for that day > > and for repayed USD 49M repayed on jun19,2022 stands at first place and 2M tokens for jul10th of 2022 stands at first place and for unique borrowers we see many ups and downs but on aug13,2020 we see the highest number with 24 unique borrowers.

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Deposits:

    > we start from the supplied in USD for deposit part of the analysis. 725M USD supply for MKR is the biggest amount among three, SNX 184MUSD and 593M USD for UNI the numbers are really huge the interesting part is for the depositors which for MKR which had the biggest number there are less depositors 2020 depositors and for SNX 4477 and UNI with 4226 and for transactions on deposits you can see them all in donut and bar chart. MKR with 5000 transactions SNX with 7373TXs and 7542 for UNI are the transactions .

    > for teh daily deposits transactions you can see the first landscaped bar chart which for jun27,2021 has the highest rate for 226 transactions and the rest is lower than 150 transactions daily which is comparable with unarmed eyes LOL. and for depositors daily you can see the bar and line charts which is visible which the first rank is for jun27,2021 with 193 depositors las bu not least 53M in USD is the highest rate for supplies on jun10,2021. > >
    > as you see the charts are easily readble thats why im not diging in to each chart in details .

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    > > above numbers are the total stats of the withdrawn table on Aave. which you can see and compare easily to see how things are and what are the differences between the three assets which are given to us to consider. > >

    > on the bar charts also you can compare the metrics and the stats for each assets for instance for MKR 636M in USD withdrawn totaly whic this number for tokens is 394k tokens . > > SNX 155M in USD and 30M for tokens and 573M USD for UNI and 37M tokens withdrawn totaly from Aave. > > and for depositors you can read the stats as for transactions which for MKR 3842 transactions made and 4759 TXs for SNX and also 5162 transactions for UNI

    > you can see the daily stats for withdraw table which for transactions the highest rate is for may23,2021 with 130 transactions and 25M in USD for OCT12,2021 the highest place as for tokens withdrawn is 1.7M tokens on jun28,0222 at the top place the rest you can see the usd and token withdrawn daily stats by symboland also the depositors too

    > > conclusion: > > as you saw the metrics the borrowing market on Aave is very popular as well as other chains too and also people like to borrow from crypto markets and it helps the market grow as well as people grow financialyy which they can work with the asset they borrowed also they repay it as well > > > > \