Querying SILO

You can build your own queries using a GraphQL Explorer and enter your endpoint to limit the data to exactly what you need.

Each entity has a plural version and a singular version. When querying for a single record response (e.g. account), you will need to supply the id for the entity. When querying for a list of responses (e.g. accounts), you may add filters using the 'where' clause.

Below are some sample queries you can use to gather information from the SILO contracts.

Main Market

Request

fragment rates on Market {
  rates {
    side
    rate
    token {
      id
    }
  }
}

query Markets {
  lendingProtocols(block: { number: 18642057 }) {
    totalValueLockedUSD
  }
  markets(
    first: 5
    orderBy: totalValueLockedUSD
    orderDirection: desc
    where: { inputToken_: { activeOracle_not: "null" } }
    block: { number: 18642057 }
  ) {
    id
    name
    isActive
    archived
    marketAssets {
      asset {
        id
        symbol
        name
        decimals
        lastPriceUSD
      }
      balance
    }
    inputToken {
      id
    }
    outputToken {
      id
    }
    ...rates
  }
}

Response

Basic Market

Request

query BasicMarkets {
  silos(first: 5) {
    id
    archived
    baseAsset {
      id
    }
    bridgeAsset {
      id
    }
    market {
      inputToken {
        id
        name
        symbol
        decimals
      }
      sToken {
        id
      }
      spToken {
        id
      }
      dToken {
        id
      }
    }
  }
}

Response

Most at risk of liquidation - V3 ONLY

Request

fragment positionFields on Position {
  marketAsset: market {
    inputToken {
      id
    }
  }
  snapshots(first: 1, orderBy: blockNumber, orderDirection: desc) {
    blockNumber
    hash
  }
}

query QueryPositions {
  siloPositions(
    first: 5
    skip: 0
    where: { dTokenBalance_gt: 0, silo_: { id_not_in: [""] } }
    orderBy: riskFactor
    orderDirection: desc
    block: { number_gte: 19112526 }
  ) {
    id
    account {
      id
    }
    silo {
      id
      baseAsset {
        id
      }
      bridgeAsset {
        id
      }
      marketAssets: market {
        inputToken {
          id
          symbol
          decimals
          lastPriceUSD
        }
        liquidationThreshold
      }
    }
    totalCollateralValue
    totalBorrowValue
    riskFactor
    riskScore
    collateralPositions: positions(where: { sTokenBalance_gt: 0 }) {
      sTokenBalance
      sToken {
        derivativeConversion
      }
      ...positionFields
    }
    collateralOnlyPositions: positions(where: { spTokenBalance_gt: 0 }) {
      spTokenBalance
      ...positionFields
    }
    debtPositions: positions(where: { dTokenBalance_gt: 0 }) {
      dTokenBalance
      dToken {
        derivativeConversion
      }
      ...positionFields
    }
  }
}

Response

Interest rate example, can also be applied to InterestRateHourly

Request

{
  market(id: "0xa8897b4552c075e884bdb8e7b704eb10db29bf0d") {
    id
    name
    rates {
      side
      token {
        id
        symbol
      }
      interestRateDaily(first: 10, orderBy: day, orderDirection: desc) {
        day
        timestamp
        rateHigh
        rateLow
        rateAvg
        rateLast
      }
    }
  }
}

Response

Activity feed for a market

Request

query ActivityFeedBySilo(
  $Market: String = "0xac3333401e69574d433307b31f43a7826eb6f8fd"
) {
  events(
    first: 10
    orderBy: blockNumber
    orderDirection: desc
    where: { silo: $Market }
  ) {
    timestamp
    hash
    logIndex
    blockNumber
    id
    silo {
      id
    }
    asset {
      id
      symbol
    }
    amount
    amountUSD
    account {
      id
    }
    ... on Borrow {
      __typename
    }
    ... on Deposit {
      __typename
    }
    ... on Liquidate {
      __typename
    }
    ... on Repay {
      __typename
    }
    ... on Withdraw {
      __typename
    }
  }
}

Response

Week of metrics for a market

Request

query GetSiloMetricsWeek($silo: String = "CRV") {
  markets(where: { name: $silo }) {
    name
    dailySnapshots(orderBy: blockNumber, orderDirection: desc, first: 7) {
      dailyBorrowUSD
      dailyDepositUSD
      dailyLiquidateUSD
      dailyRepayUSD
      dailyWithdrawUSD
      timestamp
      totalBorrowBalanceUSD
      totalDepositBalanceUSD
      totalValueLockedUSD
    }
  }
}

Response

Account based position info

Request

query QueryAccountPositions(
  $account: String = "0xc255e0a1be0a4b7b8bf5ebe8d0aba162cf75bae2"
) {
  positions(orderDirection: desc, where: { account: $account }) {
    account {
      id
    }
    depositCount
    balance
    blockNumberClosed
    blockNumberOpened
    borrowCount
    isCollateral
    liquidationCount
    repayCount
    side
    timestampClosed
    timestampOpened
    withdrawCount
  }
}

Response