Compound Subgraph

Compound is an open-source protocol for algorithmic, efficient Money Markets on the Ethereum blockchain.

Events and Contracts

The Compound smart contracts are set up so that all the events are emitted from a single address. The solidity file that has all the events is MoneyMarket.sol.

Most events are included and tracked in the subgraph. The following events were not tracked:

• NewPendingAdmin - Not core to the protocol
• NewAdmin - Not core to the protocol
• NewOracle - Not core to the protocol
• EquityWithdrawn - Not core to the protocol
• SetPaused - Not core to the protocol

This subgraph can be used for Compound on the mainnet, and all testnets. In order to run it for a testnet, the subgraph.yaml file will need to have the contract addresses changed to point to the correct address for each respective network.

The subgraph takes about 2.5 hours to sync.

Brief Description of The Graph Node Setup

A Graph Node can run multiple subgraphs. The subgraph ingests event data and contract storage by calling to Infura through http. It can connect to any geth or parity node that accepts RPC calls. Fast synced geth nodes work. To use parity, the --no-warp flag must be used. Setting up a local Ethereum node results in faster queries, but Infura allows for quickly starting, and meets most needs.

This subgraph has three types of files which tell the Graph Node to ingest events from specific contracts. They are:

• The subgraph manifest (subgraph.yaml)
• A GraphQL schema (schema.graphql)
• Typescript Mapping scripts (moneyMarket.ts)

This repository has these files created and ready to compile, so a user can start this subgraph on their own. The only thing that needs to be edited is the contract addresses in the subgraph.yaml file to change between mainnet and testnets.

This doc provides a quick guide on how to start up the Compound subgraph graph node. If these steps aren't descriptive enough, the getting started guide has in depth details on running a subgraph.

Steps to Deploying The Compound Subgraph Locally

1. Install IPFS and run ipfs init followed by ipfs daemon
2. Install PostgreSQL and run initdb -D .postgres followed by pg_ctl -D .postgres start and createdb compound-mainnet (note this db name is used in the commands below for the mainnet examples)
3. If using Ubuntu, you may need to install additional packages: sudo apt-get install -y clang libpq-dev libssl-dev pkg-config
4. Clone this repository, and run the following:
   • yarn
   • yarn codegen
5. Clone https://github.com/graphprotocol/graph-node from master and cargo build (this might take a while)
6. a) Now that all the dependencies are running, you can run the following command to connect to Infura mainnet (it may take a few minutes for Rust to compile). PASSWORD might be optional, it depends on your postgres setup:

  cargo run -p graph-node --release -- \
  --postgres-url postgresql://USERNAME:[PASSWORD]@localhost:5432/compound-mainnet \
  --ipfs 127.0.0.1:5001 \
  --ethereum-rpc mainnet-infura:https://mainnet.infura.io --debug

6. b) Or Mainnet with a Local Ethereum node. This is very common if you are working with brand new contracts, and you have deployed them to a testnet environment like ganache (note that ganache commonly uses port 9545 rather than 8545):

  cargo run -p graph-node --release -- \
  --postgres-url postgresql://USERNAME:[PASSWORD]@localhost:5432/compound-mainnet \
  --ipfs 127.0.0.1:5001 \
  --ethereum-rpc mainnet-local:http://127.0.0.1:8545 

6. c) Or Infura Rinkeby (NOTE: Infura testnets are not reliable right now, we get inconsistent results returned. If Rinkeby data is needed, it is suggested to run your own Rinkeby node)

    cargo run -p graph-node --release --  \
    --postgres-url postgresql://USERNAME:[PASSWORD]@localhost:5432/compound-testnet \
    --ipfs 127.0.0.1:5001 \
    --ethereum-rpc rinkeby-infura:https://rinkeby.infura.io 

7. Now create the subgraph locally on The Graph Node with yarn create-local. (On The Graph Hosted service, creating the subgraph is done in the web broswer).

8. Now deploy the Compound subgraph to The Graph Node with yarn deploy. You should see a lot of blocks being skipped in the graph-node terminal, and then it will start ingesting events from the moment the contracts were uploaded to the network.

Now that the subgraph is running you may open a Graphiql browser at 127.0.0.1:8000 and get started with querying.

Viewing the Subgraph on the Graph Hosted Service

This subgraph has already been deploy to the hosted service, and you can see it under on The Graph Explorer. To understand how deploying to the hosted service works, check out the Deploying Instructions in the official documentation. The most important part of deploying to the hosted service is ensuring that the npm script for deploy is updated to the correct name that you want to deploy with.

Querying the subgraph

The query below shows some useful queries, with a few filters. There are many other filtering options that can be used, just check out the querying api.

Markets

To get a list of all the Markets within the Compound app, you can use the following query, ordered by asset name

{
  markets(orderBy: assetName) {
    id
    assetName
    isSupported
    isSuspended
    blockNumber
    interestRateModel
    totalSupply
    perBlockSupplyInterest
    priceInWei
    supplyIndex
    totalBorrows
    perBlockBorrowInterest
    borrowIndex
  }
}

You can also query users! This query will return the top 10 users that have the lowest account liquidity. This could be useful for monitoring accounts to liquidate and earn fees with the liquidation discount.

{
  users(first: 10, orderBy: accountLiquidity, orderDirection: asc) {
    id
    accountLiquidity
    totalSupplyInEth
    totalBorrowInEth
    assets {
      id
      user
      supplyPrincipal
      supplyInterestLastChange
      totalSupplyInterest
      supplyInterestIndex
      borrowPrincipal
      borrowInterestLastChange
      totalBorrowInterest
      borrowInterestIndex
      transactionHashes
      transactionTimes
    }
  }
}

The command above can be copy pasted into the Graphiql interface in your browser at 127.0.0.1:8000.