/Aave_analysis

A simple exploratory analysis of Aave protocol

Aave Liquidity protocol (overview)

Aave is a decentralized finance (DeFi) protocol that lets people lend and borrow cryptocurrencies and real-world assets (RWAs) without having to go through a centralized intermediary. When they lend, they earn interest; when they borrow, they pay interest.

image

Methodology

We hope to solve these four main questions

  1. Total borrowed on Aave v2
  2. Total liquidity supplied on aave v2 3.Total borrowing per asset
  3. Total deposit per asset
Screenshot 2023-06-01 at 20 01 22

Total Borrowed for Aave v2 :

Query code:

SELECT SUM(BORROWED_USD/1E9) AS TOTAL_BORROWED -- THE TOTAL_BORROWED IS IN BILLIONS 
FROM ethereum.aave.ez_borrows
WHERE AAVE_VERSION = 'Aave V2'