logo
0
avatar
Aaveator 5C2C49BE-0B07-4C3F-8D36-B1FB2C7ACC0C Created with sketchtool. 138 Stranger 3 Feb 7 2023 11:07

How to calculate the Aave TVL using Dune analytics?

Expert

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.

Answers 1

0
avatar
undefined 5C2C49BE-0B07-4C3F-8D36-B1FB2C7ACC0C Created with sketchtool. 0 Stranger 0 Feb 14 2023 12:15

That'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.