Incorrect value for vault debt

[jvalteren]

Hi,

I'd like to use your subgraph to get specific Maker Vault collateral and debt values. I'm using cdpId 19417 for testing, of which I know the current debt (Tue 19 Jan 16:35 CET) is 9202.90 DAI (see https://defiexplore.com/cdp/19417).

However, querying the subgraph returns a debt of 8963.24.

Might this be related to pull request #6? Thanks!

Exact query:

{
  vaults(where:{ cdpId: 19417 }) {
    collateralType {
      id
    }
    collateral
    debt
  }
}

Response:

{
  "data": {
    "vaults": [
      {
        "collateral": "25",
        "collateralType": {
          "id": "ETH-A"
        },
        "debt": "8963.246306891334844794"
      }
    ]
  }
}

[jvalteren]

Hi @sistemico and @juanmardefago, can you tell me if this is a legitimate issue? Perhaps I'm doing something wrong. Hope to hear from you! Best, Jonathan

[juanmardefago]

Hey @jvalteren!
PR #6 is actually related to a fix to the system wide total debt, so it shouldn't be impacting specific vault debts.
I'll try to check it out asap, although I'm quite busy at the moment.

@sistemico, can you check it out soon?

[jvalteren]

Thanks! I've been doing a bit of research myself, with the following results:

Coincidentally, I just got access to the MCD Vault Tracker beta (https://api.mcdstate.info/). Their 'vault_state' response returns the same value, but under a property named 'art' (https://api.mcdstate.info/api-documentation/multi-collateral-dai-vault-tracker-api-documentation#vault_state-id).

I'm not a Maker/blockchain developer, so I had to look this up. I found that this is a 'normalized' debt value which 'multiplied by the correct rate gives the up-to-date, current stablecoin debt' (source: https://docs.makerdao.com/smart-contract-modules/core-module/vat-detailed-documentation#glossary-vat-vault-engine).

The schema browser on TheGraph playground (on the right side) for your subgraph shows this description for Vault field debt: 'Outstanding debt (art) [DAI]'. This made me assume the response value would be actual DAI units. Under CollateralType there is a field called debtNormalized, with comment: 'Debt backed by this collateral type [DAI] (Art)'.

When multiplying the Vault field debt with CollateralType field rate, I'm now getting the expected debt in DAI units.

Is it possible for you to introduce Vault field normalizedDebt (similar to CollateralType)? I can understand that changing the value returned by Vault field debt might break any apps that are using your subgraph. In that case, perhaps you could clarify this in the schema comments.

Thanks for your work!

[sistemico]

Awesome @jvalteren! And thank you so much for the research on this issue. For sure it's a bug and we should provide both normalized and raw values. We'll fix it as soon as posible. Thanks to you again for reporting and finding the problem.

[BearWithIvan]

Hi @sistemico and @juanmardefago,

I found another problem with debt and collateral value. I'm using cdpId 3851 for the test purpose, I found the current debt is 20.38 DAI and collateral is 200BAT (see https://defiexplore.com/cdp/3851).
Debt * rate doesn't help.

Response is:

{
  "data": {
    "vaults": [
      {
        "cdpId": "3851",
        "collateral": "383.15",
        "collateralType": {
          "id": "BAT-A"
        },
        "debt": "39.50140838541827308"
      }
    ]
  }
}

[sistemico]

Hey @BearWithIvan, thanks for report! Gonna tackle this issue in the same strike.

[BearWithIvan]

Hi @sistemico, @juanmardefago,
Do you have any news about this issue?

[cold-briu]

Hi @BearWithIvan I'll be giving support to this subgraph in the following weeks. Expect updates soon.

[pad01g]

@cold-briu
Hi, I've looked into source code of current dev branch and I can confirm at least following two functionality is missing and thus collateral and debt value is miscalculated.

1. VaultSplitChangeLog is currently recorded only when src or dst vault already exists. However, fork may run without src or dst. It should try to record VaultSplitChangeLog even when src or dst does not exist, and if vault was emptied or fulfilled by this operation, collateral and debt should be affected accordingly.
   • For example, https://ethtx.info/0x82e7c7dde47a82b8adfa1d47715a108f87eca1855e9ec637c09dc25110495d62/
2. Liquidation event is not considered. Collateral and debt should be affected accordingly.

Here's example:
https://tracker-vaults.makerdao.network/vault/8114
https://defiexplore.com/cdp/8114

In this vault 8114, the final collateral and debt should be zero. However, when you query the following, result is not zero because of above two points.

query

{
  vaults(
    where: { 
      collateralType: "ETH-A",
      cdpId: 8114
    },
    first: 1
  ){
    id,
    debt,
    collateral,
    cdpId,
    logs(orderBy: timestamp, orderDirection: desc){
      transaction,
      timestamp,
      __typename,
      ... on VaultCollateralChangeLog {
        collateralBefore,
        collateralAfter
      }
    },
  }
}

result

result from https://thegraph.com/explorer/subgraph?id=5TLohiwWUvfnXritG4NcL2MgTkeUqB6Ns6VouYxTw5xy&view=Playground

{
  "data": {
    "vaults": [
      {
        "id": "0xb671aa6ba13d8d27feb7e0c0f9f3347c994198f0-ETH-A",
        "debt": "24120.321801859282683123",
        "collateral": "21.128367318819360698",
        "cdpId": "8114",
        "logs": [
          {
            "transaction": "0x7f0861268028c01743096bbc55a5ea801b7cc927bf40b6520de2b1fc81d0849b",
            "timestamp": "1654784024",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "23.444300386974560091",
            "collateralAfter": "21.128367318819360698"
          },
          {
            "transaction": "0x69b8b24ca567cb52f16c477e862025d2c1205ebd7d4636b74c309c7194bf472e",
            "timestamp": "1652362687",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "21.128367318819360698",
            "collateralAfter": "23.444300386974560091"
          },
          {
            "transaction": "0x180d440d66228d79f828ca1138edc3a9b55307f3fdff0c07212af060f7fcfad0",
            "timestamp": "1651983165",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x180d440d66228d79f828ca1138edc3a9b55307f3fdff0c07212af060f7fcfad0",
            "timestamp": "1651983165",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "34.671533562794871035",
            "collateralAfter": "33.002068415891061235"
          },
          {
            "transaction": "0xd57ca7224a53fedefe66dda2c53e1eaa15b24277de5d4b58de1ae7e5151c83bc",
            "timestamp": "1650262351",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xd57ca7224a53fedefe66dda2c53e1eaa15b24277de5d4b58de1ae7e5151c83bc",
            "timestamp": "1650262351",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "36.561859212794871035",
            "collateralAfter": "34.671533562794871035"
          },
          {
            "transaction": "0x88ebfecff87472736d1e2a22eab014bbc8b4b9fd59ca45d41a8ee5b3f1569bf8",
            "timestamp": "1648422992",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "35.235138730295738479",
            "collateralAfter": "36.561859212794871035"
          },
          {
            "transaction": "0x88ebfecff87472736d1e2a22eab014bbc8b4b9fd59ca45d41a8ee5b3f1569bf8",
            "timestamp": "1648422992",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x44c0ad2ecf2aa619fa00422da7333f0e21dc6a947584eacd0b9e08dbb0af9098",
            "timestamp": "1647627875",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x44c0ad2ecf2aa619fa00422da7333f0e21dc6a947584eacd0b9e08dbb0af9098",
            "timestamp": "1647627875",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "34.130562862691304426",
            "collateralAfter": "35.235138730295738479"
          },
          {
            "transaction": "0x342f95215bcc7d3bc96bbf21a7dcaa72a444449dc9d87a5ec42d097321b205df",
            "timestamp": "1646428167",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x342f95215bcc7d3bc96bbf21a7dcaa72a444449dc9d87a5ec42d097321b205df",
            "timestamp": "1646428167",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "36.408596412691304426",
            "collateralAfter": "34.130562862691304426"
          },
          {
            "transaction": "0xa47f1667d16c966ec26c358f94dfa070e839c761127cff265e88b32f8b3a3628",
            "timestamp": "1646147515",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "35.100415716796436278",
            "collateralAfter": "36.408596412691304426"
          },
          {
            "transaction": "0xa47f1667d16c966ec26c358f94dfa070e839c761127cff265e88b32f8b3a3628",
            "timestamp": "1646147515",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x700ead12eb7b650b92b425ee8a1284a2bdab1ff86af03b6c1544415ccaa0e1d1",
            "timestamp": "1645742909",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "33.94251788496896257",
            "collateralAfter": "35.100415716796436278"
          },
          {
            "transaction": "0x700ead12eb7b650b92b425ee8a1284a2bdab1ff86af03b6c1544415ccaa0e1d1",
            "timestamp": "1645742909",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x92b5a6828497f31d3b629154149973fd2a3d684603c0b97a73d9cb61eef6f3cd",
            "timestamp": "1645689870",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x92b5a6828497f31d3b629154149973fd2a3d684603c0b97a73d9cb61eef6f3cd",
            "timestamp": "1645689870",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "35.47955463318481767",
            "collateralAfter": "33.94251788496896257"
          },
          {
            "transaction": "0xc03e1d5c7ac01f7dfd172712c0ab75cd3a1ea8b3e5486a6aa479c4c20f59e882",
            "timestamp": "1645344531",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xc03e1d5c7ac01f7dfd172712c0ab75cd3a1ea8b3e5486a6aa479c4c20f59e882",
            "timestamp": "1645344531",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "37.70110421318481767",
            "collateralAfter": "35.47955463318481767"
          },
          {
            "transaction": "0xb0d36ab4ca8aca09d25287d02d5401874daf0483dd01011c9aa1a899d5022e51",
            "timestamp": "1644028112",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "36.090983523456205494",
            "collateralAfter": "37.70110421318481767"
          },
          {
            "transaction": "0xb0d36ab4ca8aca09d25287d02d5401874daf0483dd01011c9aa1a899d5022e51",
            "timestamp": "1644028112",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x39aa10cb8bc3f2bb2c17b425d401120c6f9d21f8d7514a4ab93c01d86c376a2e",
            "timestamp": "1643498455",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "34.655498915083645835",
            "collateralAfter": "36.090983523456205494"
          },
          {
            "transaction": "0x39aa10cb8bc3f2bb2c17b425d401120c6f9d21f8d7514a4ab93c01d86c376a2e",
            "timestamp": "1643498455",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xf431f2ebf6bdbaf7a041128c33740eddf563e5eb5abbb56462af73e40d81c688",
            "timestamp": "1643028261",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xf431f2ebf6bdbaf7a041128c33740eddf563e5eb5abbb56462af73e40d81c688",
            "timestamp": "1643028261",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "36.660745849694259835",
            "collateralAfter": "34.655498915083645835"
          },
          {
            "transaction": "0x350db06a85672f516ed04bf538bb0667463a9a7ef079fc9899ef49787ffcb6a2",
            "timestamp": "1642835846",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x350db06a85672f516ed04bf538bb0667463a9a7ef079fc9899ef49787ffcb6a2",
            "timestamp": "1642835846",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "39.063142509694259835",
            "collateralAfter": "36.660745849694259835"
          },
          {
            "transaction": "0x03c4c1d3b2dbddc4d40ec2a99cfdfc12f7e1a04ba96572024ff2102bffa0c7d0",
            "timestamp": "1642755929",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x03c4c1d3b2dbddc4d40ec2a99cfdfc12f7e1a04ba96572024ff2102bffa0c7d0",
            "timestamp": "1642755929",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "41.528526889694259835",
            "collateralAfter": "39.063142509694259835"
          },
          {
            "transaction": "0xb99b5365255bbabc77c00607568f8b5dc778f543f7ffb558041f27ccbb1a083e",
            "timestamp": "1641536739",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xb99b5365255bbabc77c00607568f8b5dc778f543f7ffb558041f27ccbb1a083e",
            "timestamp": "1641536739",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "44.565162279694259835",
            "collateralAfter": "41.528526889694259835"
          },
          {
            "transaction": "0xd15c2754fe13d7914950858b3878e3e99fa57d07e24e8a4437f136ca0221ac8a",
            "timestamp": "1641424135",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "48.750191329694259835",
            "collateralAfter": "44.565162279694259835"
          },
          {
            "transaction": "0xd15c2754fe13d7914950858b3878e3e99fa57d07e24e8a4437f136ca0221ac8a",
            "timestamp": "1641424135",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x9ecace3af02d296ab3d2710899664bde1a941a32454cbd5c38bf4c416419fe18",
            "timestamp": "1638600340",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x9ecace3af02d296ab3d2710899664bde1a941a32454cbd5c38bf4c416419fe18",
            "timestamp": "1638600340",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "54.193150099694259835",
            "collateralAfter": "48.750191329694259835"
          },
          {
            "transaction": "0x6a76749bbe17124da4b91e57893d0023faf52322b49ee974ede48d9766bf9aae",
            "timestamp": "1638277753",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x6a76749bbe17124da4b91e57893d0023faf52322b49ee974ede48d9766bf9aae",
            "timestamp": "1638277753",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "51.382472584092833048",
            "collateralAfter": "54.193150099694259835"
          },
          {
            "transaction": "0x0c05e8a2aab1aa847bfa8012ce24776b738275c65d9d96948e2361da50b33575",
            "timestamp": "1637122137",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x0c05e8a2aab1aa847bfa8012ce24776b738275c65d9d96948e2361da50b33575",
            "timestamp": "1637122137",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "55.809870494092833048",
            "collateralAfter": "51.382472584092833048"
          },
          {
            "transaction": "0x91156e375104acdefb955c0df8d06fccdc42389fc6be3d5e90c67358e283396a",
            "timestamp": "1635903158",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "52.615539908267979372",
            "collateralAfter": "55.809870494092833048"
          },
          {
            "transaction": "0x91156e375104acdefb955c0df8d06fccdc42389fc6be3d5e90c67358e283396a",
            "timestamp": "1635903158",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xe1feabcde531a5dc50347f533c561c2dec7bbd6492fa9968feab63fac6c5b962",
            "timestamp": "1634915975",
            "__typename": "VaultTransferChangeLog"
          },
          {
            "transaction": "0xdaa0a0caa6244b5995603fff1ebacab3b074a159829d0eab757e6a3303509f82",
            "timestamp": "1634903837",
            "__typename": "VaultTransferChangeLog"
          },
          {
            "transaction": "0x88cf606f108dd2010865356ec18222f10c6ce952886f049a6c19793cc25b234b",
            "timestamp": "1634753567",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "50.13155260872479024",
            "collateralAfter": "52.615539908267979372"
          },
          {
            "transaction": "0x88cf606f108dd2010865356ec18222f10c6ce952886f049a6c19793cc25b234b",
            "timestamp": "1634753567",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xb5ab935ee8bd43a29a645a7595740bc61ff8a1b22e2a5598b428665a05ce2ef3",
            "timestamp": "1634218834",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "47.961716770477517169",
            "collateralAfter": "50.13155260872479024"
          },
          {
            "transaction": "0xb5ab935ee8bd43a29a645a7595740bc61ff8a1b22e2a5598b428665a05ce2ef3",
            "timestamp": "1634218834",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xf963c40017d3cc95176a3e91834b541dc5ad073b2b6c4265955b4e4a767ef479",
            "timestamp": "1633191138",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xf963c40017d3cc95176a3e91834b541dc5ad073b2b6c4265955b4e4a767ef479",
            "timestamp": "1633191138",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "45.73486135635206559",
            "collateralAfter": "47.961716770477517169"
          },
          {
            "transaction": "0xa7038eb90a334560e5432102fed25dc105bc888106b34b8f6d4b2ffe0a1ff8bc",
            "timestamp": "1632144052",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xa7038eb90a334560e5432102fed25dc105bc888106b34b8f6d4b2ffe0a1ff8bc",
            "timestamp": "1632144052",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "49.21426103635206559",
            "collateralAfter": "45.73486135635206559"
          },
          {
            "transaction": "0x92697dfd0d7ce1cac1b40453337b1e05364bb9cd1e13115250a6ad0909a4ba3d",
            "timestamp": "1631052537",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x92697dfd0d7ce1cac1b40453337b1e05364bb9cd1e13115250a6ad0909a4ba3d",
            "timestamp": "1631052537",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "53.30177965635206559",
            "collateralAfter": "49.21426103635206559"
          },
          {
            "transaction": "0xc6f418853056597df782a163f10ef0d7de563ce3271b21386ac35e296c9feef0",
            "timestamp": "1630521876",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "50.036754237745048977",
            "collateralAfter": "53.30177965635206559"
          },
          {
            "transaction": "0xc6f418853056597df782a163f10ef0d7de563ce3271b21386ac35e296c9feef0",
            "timestamp": "1630521876",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xeee4292eb4ec1d248b330b8c98cbea0c6e53b19786220bf06dc7022f1dd6e8f9",
            "timestamp": "1629475538",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "47.635678383729310323",
            "collateralAfter": "50.036754237745048977"
          },
          {
            "transaction": "0xeee4292eb4ec1d248b330b8c98cbea0c6e53b19786220bf06dc7022f1dd6e8f9",
            "timestamp": "1629475538",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xb3bec9ad935dc16808eb953feddd2a36fbebb2adea1fc0b4f33d727e08be7cfc",
            "timestamp": "1629353385",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xb3bec9ad935dc16808eb953feddd2a36fbebb2adea1fc0b4f33d727e08be7cfc",
            "timestamp": "1629353385",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "51.204354923729310323",
            "collateralAfter": "47.635678383729310323"
          },
          {
            "transaction": "0x2443b9056147dfc065e1feb2514953cfdcef234e9a73cd898ac83727daec6790",
            "timestamp": "1628903360",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "48.57552005297993792",
            "collateralAfter": "51.204354923729310323"
          },
          {
            "transaction": "0x2443b9056147dfc065e1feb2514953cfdcef234e9a73cd898ac83727daec6790",
            "timestamp": "1628903360",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xa6ce4367943bf9774c03eef9a3bd2a8bb918554f481514047d894e2dc609d838",
            "timestamp": "1628316572",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "46.183996825319658035",
            "collateralAfter": "48.57552005297993792"
          },
          {
            "transaction": "0xa6ce4367943bf9774c03eef9a3bd2a8bb918554f481514047d894e2dc609d838",
            "timestamp": "1628316572",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x8561dbdbac3978be57fabd0cd21cf302c6e6a0cb527db31109d7728ef2488b94",
            "timestamp": "1627855774",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "44.009686128362837181",
            "collateralAfter": "46.183996825319658035"
          },
          {
            "transaction": "0x8561dbdbac3978be57fabd0cd21cf302c6e6a0cb527db31109d7728ef2488b94",
            "timestamp": "1627855774",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x946c6e441d5f93edde5cbb7444555678ac57ae13577728d3b8f4150f775605cf",
            "timestamp": "1627614570",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "42.182204865830659047",
            "collateralAfter": "44.009686128362837181"
          },
          {
            "transaction": "0x946c6e441d5f93edde5cbb7444555678ac57ae13577728d3b8f4150f775605cf",
            "timestamp": "1627614570",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xb370585ebeb134346c50cfca881b7dea9b8c7adeac7b8d2f0aff83a5fd589320",
            "timestamp": "1627153509",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "40.390156890647028245",
            "collateralAfter": "42.182204865830659047"
          },
          {
            "transaction": "0xb370585ebeb134346c50cfca881b7dea9b8c7adeac7b8d2f0aff83a5fd589320",
            "timestamp": "1627153509",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x46e4a50873e3f4802f3f5ad8a06bf212983f4a3c3575da0843548becb965353d",
            "timestamp": "1626891435",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "38.731112578991211696",
            "collateralAfter": "40.390156890647028245"
          },
          {
            "transaction": "0x46e4a50873e3f4802f3f5ad8a06bf212983f4a3c3575da0843548becb965353d",
            "timestamp": "1626891435",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x361a44f94783d05ca698b75a0766276fab5e38f1ccbfebd94c1d4fd2beb9832e",
            "timestamp": "1626750688",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x361a44f94783d05ca698b75a0766276fab5e38f1ccbfebd94c1d4fd2beb9832e",
            "timestamp": "1626750688",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "41.342530298991211696",
            "collateralAfter": "38.731112578991211696"
          },
          {
            "transaction": "0x98d2e81ba2314a861a23ed9f4d5928b48bfdb022ff0c354fe8e8c61cd8bbb865",
            "timestamp": "1626160238",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x98d2e81ba2314a861a23ed9f4d5928b48bfdb022ff0c354fe8e8c61cd8bbb865",
            "timestamp": "1626160238",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "44.139408498991211696",
            "collateralAfter": "41.342530298991211696"
          },
          {
            "transaction": "0xba750a73153ca6b486c30ce3b2ff7b1fa246faf1ad16da1b875c63cb6badbfa8",
            "timestamp": "1625328379",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "42.205473174287913684",
            "collateralAfter": "44.139408498991211696"
          },
          {
            "transaction": "0xba750a73153ca6b486c30ce3b2ff7b1fa246faf1ad16da1b875c63cb6badbfa8",
            "timestamp": "1625328379",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xa996c0d047294a7b4fc47a5ce94422c8caa937014c97cc75ff941b64e42a6d1a",
            "timestamp": "1625213198",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xa996c0d047294a7b4fc47a5ce94422c8caa937014c97cc75ff941b64e42a6d1a",
            "timestamp": "1625213198",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "44.959338904287913684",
            "collateralAfter": "42.205473174287913684"
          },
          {
            "transaction": "0x95818c248e7b5f047024425df7feb202a231ee288f2cc29390ec879d810205c1",
            "timestamp": "1625101589",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "42.943022876161896932",
            "collateralAfter": "44.959338904287913684"
          },
          {
            "transaction": "0x95818c248e7b5f047024425df7feb202a231ee288f2cc29390ec879d810205c1",
            "timestamp": "1625101589",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x742b30d6db20ff39baea08c6a8506a89d5682a952825e2500f870e303fc7d2c1",
            "timestamp": "1624875261",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "41.040627996787967909",
            "collateralAfter": "42.943022876161896932"
          },
          {
            "transaction": "0x742b30d6db20ff39baea08c6a8506a89d5682a952825e2500f870e303fc7d2c1",
            "timestamp": "1624875261",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xe234ceac089176e3958588d4f606f1604ba47931b5bb1eecbde53a8b3bd31acf",
            "timestamp": "1624640832",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xe234ceac089176e3958588d4f606f1604ba47931b5bb1eecbde53a8b3bd31acf",
            "timestamp": "1624640832",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "43.321689966787967909",
            "collateralAfter": "41.040627996787967909"
          },
          {
            "transaction": "0xdd8077df26764d6648761545e1063a47b7d9daddfc97024911c5d16f5fdbfc03",
            "timestamp": "1624550784",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xdd8077df26764d6648761545e1063a47b7d9daddfc97024911c5d16f5fdbfc03",
            "timestamp": "1624550784",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "36.564878456366998506",
            "collateralAfter": "43.321689966787967909"
          },
          {
            "transaction": "0xdd8077df26764d6648761545e1063a47b7d9daddfc97024911c5d16f5fdbfc03",
            "timestamp": "1624550784",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xa216f465b78715aac8c196b292550b84562bc1b3b216e8dd42e60536db5612a3",
            "timestamp": "1624548213",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "31.018731835406349913",
            "collateralAfter": "36.564878456366998506"
          },
          {
            "transaction": "0x04cf3e114fd788e2aec5d91e2ed30d6e13a46ef475ec4def3428d53f0e0ccdb3",
            "timestamp": "1624375563",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "32.301505321926950931",
            "collateralAfter": "31.018731835406349913"
          },
          {
            "transaction": "0x04cf3e114fd788e2aec5d91e2ed30d6e13a46ef475ec4def3428d53f0e0ccdb3",
            "timestamp": "1624375563",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x04cf3e114fd788e2aec5d91e2ed30d6e13a46ef475ec4def3428d53f0e0ccdb3",
            "timestamp": "1624375563",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "33.487896383431995373",
            "collateralAfter": "32.301505321926950931"
          },
          {
            "transaction": "0xc68e8ee692a1561576bd7213377fd303ad72f4b52cdd065ff1fa7b932dabd039",
            "timestamp": "1624192260",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xc68e8ee692a1561576bd7213377fd303ad72f4b52cdd065ff1fa7b932dabd039",
            "timestamp": "1624192260",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "35.430081063431995373",
            "collateralAfter": "33.487896383431995373"
          },
          {
            "transaction": "0x776784959381574262810c8e38c4a7ea06c21f2adc74dae6a97a037e55a383df",
            "timestamp": "1623957248",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "37.382907873431995373",
            "collateralAfter": "35.430081063431995373"
          },
          {
            "transaction": "0x776784959381574262810c8e38c4a7ea06c21f2adc74dae6a97a037e55a383df",
            "timestamp": "1623957248",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0xec14d4ac57cbe1df9169def2401dc827f7d741f9254364cc269d6214874d0ef8",
            "timestamp": "1623723244",
            "__typename": "VaultCollateralChangeLog",
            "collateralBefore": "36.049922722243995461",
            "collateralAfter": "37.382907873431995373"
          },
          {
            "transaction": "0xec14d4ac57cbe1df9169def2401dc827f7d741f9254364cc269d6214874d0ef8",
            "timestamp": "1623723244",
            "__typename": "VaultDebtChangeLog"
          },
          {
            "transaction": "0x190e601e040e797b776c1ea41c0325a4a7000347683043dc885f5140d890b5ee",
            "timestamp": "1623169810",
            "__typename": "VaultDebtChangeLog"
          }
        ]
      }
    ]
  }
}

See https://github.com/stablecoinhq/maker-protocol-subgraph/tree/dev for more updates.