The subgraph from dfx-finance

Staking Contracts In Subgraph

Information about number of stakers in DFX is requested.

totalStaked > totalLPToken

    {
        "id": "0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d",
        "token0": {
          "symbol": "USDC"
        },
        "token1": {
          "symbol": "CADC"
        },
        "reserve0": "4215966.465379",
        "reserve1": "2914614.315616389225907533",
        "reserveUSD": "6478000.0571894750648742",
        "totalLPToken": "6500759.932869160548592052",
        "totalStaked": "6528988.163800552393262537"
      },

6.50M total LPT, 6.52M staked

Negative LP appearing in participants

Useful query

{
  poolParticipants(
    orderBy: liquidityProvided
    orderDirection: asc
  ){
    id
    liquidityProvided
  }
}

follow up query only returns 2 things

{
  transfers(
    where: {
    	from: "0x39b5cfe0d2dfed221c1a0a68bff67af39f2bb300"
    	pair: "0xa6c0cbcaebd93ad3c6c94412ec06aaa37870216d"
    }
  ){
    id
    type
  }
}

{
  "data": {
    "transfers": [
      {
        "id": "0x30eba9d855d7548046df28ca5d6cd138492ffd2017ee94fd3f2a6698849099df-108",
        "type": "withdraw"
      },
      {
        "id": "0xf2ddbbae5d184f3eb8dc849cce4d0450ea4942a3979c836af47811ec96ea7101-325",
        "type": "stake"
      }
    ]
  }
}

if dug into further
https://etherscan.io/tx/0xa495db7297597445a3104cddf38e90ca63800569f259bb600a44a84b27030631

this contract interaction does not return a transfer for some reason

Participant Count on pairDayDatas only increments

The Participant Pools chart on Analytics shows the pool participants only increasing. Tested with the removal of personal LP from TRYB/USDC but saw no change in the data.

Subgraph test query for XSGD/USDC pair:

{
    pairDayDatas(
      first: 1000
      orderBy: date
      orderDirection: desc
      where: { pair:"0x2bab29a12a9527a179da88f422cdaaa223a90bd5"}
    ) {
      id
      date
      pair {
        id
        token0 {
          symbol
          name
        }
        token1 {
          symbol
          name
        }
      }
      participantCount
    }
}

Deposits & Withdrawals using Zap return as $0

Noticed on the frontend, the Zap deposits/withdrawals return the proper native amounts but show their value as $0 USD.

Cleanup Unused Subgraphs

dfxv2 and aave-amm

Update Readme

AMM no AMMV2 is no longer configured to work with the new Curve.json ABIs

Migration

Graph <> DFX Meeting notes

Migration is deploying the subgraph on ethereum -> api link associated with an EOA -> paid queries with GRT
Grant is about 30,000 GRT (3000 dollars)
8k-10k Set aside for curation signal
Doing about 100,000 queries per day
200 - 300 dollars a week (double check this calculation)
KYC for DFX entity
Marketing efforts
polygon will come later

Immediate

Marketing questions
KYC for dfx entity register.thegraph.com

Later

Clean up existing issues as redeploying costs money
Deploy on Ethereum
Update parties on new link? (CMC, Coingeko)
Update frontend (Better switch back to using alchemy?)

veDFX

New base subgraph for veDFX

DFX V2

Migrate Protocol V1 subgraph with V2
New fields i.e.

fee split
flashloans

https://docs.google.com/document/d/1w1ug1l441kWjprPB3OsEGC8Ta4lmdFmTJJnH6Rveg3I/edit#

Update Staking Contracts

New mutlistaking contracts are included in the subgraph

Template variables between networks

While the subgraph.yaml file is templated by moustache, there are some addresses within the src files that still use their own constants file which must be manually edited.

Find a way to template this alongside the yarn prepare commands.

See #60, #61