Dune Analytics for Compound Users

[RobinNagpal]

Background

• All the transactions that occur are stored on blockchain and by studying these transactions, we can study the project, the users, and the viability of the project.
• In a lending an borrowing protocol/project, part of people
  • deposit the base asset (USDC/ETH). They are called lenders
  • borrow the the base asset(USDC/ETH). They are called borrowers
• We want to study the persona of these lenders and borrowers
• Persona includes
  • How much funds do that have
  • What % of funds do they lend and borrow
  • How frequently are they borrowing lending
  • Is their lending and borrowing increasing with time?
  • What other platforms are they lending and borrowing
  • What are the top 10 assets in their holdings
• These will help us to understand blockchain in a deeper level and help us know which projects are good.
• Right now we will just limit it to compound, but we want to study atleast top 20 projects

Compound V3

• Here are compound docs https://docs.compound.finance/
• We want to see, the people who deposited money in compound
  • How much amount did they deposit?
  • What are their top 10 tokens which they hold

[ALIRAZA17]

Some Important links to read Techniques for fetching the data: https://docs.dune.com/data-catalog/evm/ethereum/decoded/overview How decoding works: https://docs.dune.com/data-catalog/evm/ethereum/decoded/call-tables Storage Structure of Dune: https://docs.dune.com/query-engine/writing-efficient-queries

[ALIRAZA17]

• List of addresses that supplied USDC on USDC V3 market on Mainnet (Ethereum) in the last 24 hours(DuneSql query)

SELECT
  "from" AS wallet_address,
  SUM(amount) AS total_supplied
FROM
  compound_v3_ethereum.Comet_evt_Supply
WHERE
  evt_block_time >= (CURRENT_TIMESTAMP - INTERVAL '1' day)
GROUP BY
  "from"
ORDER BY
  total_supplied DESC;

[ALIRAZA17]

• List of addresses that withdrew USDC on USDC V3 market on Mainnet (Ethereum) in the last 24 hours

SELECT
  "src" AS wallet_address,
  SUM(amount) AS total_withdrawn
FROM
  compound_v3_ethereum.Comet_evt_Withdraw
WHERE
  evt_block_time >= (CURRENT_TIMESTAMP - INTERVAL '1' day)
GROUP BY
  "src"
ORDER BY
  total_withdrawn DESC;