Post
Share your knowledge.
Aaveator138
Feb 07, 2023
Expert Q&A
How to calculate the Aave TVL using Dune analytics?
I'm trying to calculate the Aave TVL using Dune analytics. I'm not actually sure which events I need to look at to get an accurate aggregation... namely because there's interest.
My logic was net all the the transfer events to and from Aave v2, but that metric doesn't account for interest.
- Aave Protocol
- Aave v2
0
1
Share
Comments
Answers
1Aaveator138
Feb 14 2023, 12:15That's a hard duty given how dune analytics work by events, but in case it helps:
- Events that bring up HF => Supply/Deposit, repayments & liquidations;
- Events that bring down HF => Withdraw/Borrow;
- Also transfers might affect HF, if atokens are transferred;
- And supply only matters for those assets that are enabled (or can be used) as collateral;
Another way, in case its more simple, would be taking into account balance of atokens acting as collateral, versus debt tokens and do the maths from there.
0
Comments
Do you know the answer?
Please log in and share it.
Aave is a decentralized non-custodial liquidity protocol where users can participate as depositors or borrowers.
213Posts230Answers
Trending posts
- Error "No matching key" when trying to unstake USDC on BNB chain32
- How to tell the code to, rather than "deposit 1 eth worth of WBTC" deposit "500$ worth of WBTC"?22
- How to interpret configuration field in a response from the getReserveData view function in Aave v2?21
- Getting a return value of '25 - INVALID BURN AMOUNT'21
- Is there any way to stake in the security module on Görli?23