Milestone 2

[sh-rn]

Goal: now fetches, filters events correctly (similar to uniswap & co)

To do:

• rework database
• • introduce complete ORM (Object-relational mapping)
• • based on https://github.com/Uniswap/v2-subgraph/blob/master/schema.graphql - assume data will be served with Hasura
• rework event filter
• • stateful (saved in database)
• • add proper pair, token contract tracking

[sh-rn]

Adding an example query for info, from the first testing session:

  burn(limit: 20, order_by: {transaction: {timestamp: asc}}, where: {pair: {token: {symbol: {_eq: "USDC"}}}}) {
    id
    sender
    amount0
    amount1
    transaction {
      hash
      timestamp
    }
    pair {
      token0_address
      token1_address
      token {
        symbol
        name
      }
    }
  }
}

result:

  "data": {
    "burn": [
      {
        "id": 8,
        "sender": "0xc191a29203a83eec8e846c26340f828C68835715",
        "amount0": 10.157518,
        "amount1": 12.938674430229568,
        "transaction": {
          "hash": "0x7c008a023efd6018ad48d0fdfc5db8952b79dd3d6076d48b8b7eea9699212257",
          "timestamp": 1645035936
        },
        "pair": {
          "token0_address": "0x2bF9b864cdc97b08B6D79ad4663e71B8aB65c45c",
          "token1_address": "0xd3e822f3ef011Ca5f17D82C956D952D8d7C3A1BB",
          "token": {
            "symbol": "USDC",
            "name": "USD Coin"
          }
        }
      },
      {
        "id": 10,
        "sender": "0x6A9ae0b8A3717D8CaaDCe065D273b9a0882bE8A3",
        "amount0": 44.464797,
        "amount1": 57.51031778464559,
        "transaction": {
          "hash": "0x125bc283a5b90e4c91aeecb19615f7eb2ec92d5692c42e56983f66d4807aad3b",
          "timestamp": 1645036861
        },
        "pair": {
          "token0_address": "0x2bF9b864cdc97b08B6D79ad4663e71B8aB65c45c",
          "token1_address": "0xd3e822f3ef011Ca5f17D82C956D952D8d7C3A1BB",
          "token": {
            "symbol": "USDC",
            "name": "USD Coin"
          }
        }
      },... 

[sh-rn]

QA testing continued, now with recent blocks available.

Example data returned for blocknumber:180616:

Pegasys subgraph:

  "data": {
    "transactions": [
      {
        "swaps": [
          {
            "id": "0x8bba1b1ca502628de18c8631ab7c2ea5904d944c229c05c373780ecd4379371f-0",
            "pair": {
              "token0": {
                "name": "Wrapped SYS",
                "symbol": "WSYS"
              },
              "token1": {
                "name": "Pegasys",
                "symbol": "PSYS"
              }
            }
          }
        ],
        "blockNumber": "180616"
      },
      {
        "swaps": [
          {
            "id": "0x34d51aec1022067a3715f289aadc09cc7533f05ca8d11ae338eea4c2e3e4d46e-0",
            "pair": {
              "token0": {
                "name": "USD Coin",
                "symbol": "USDC"
              },
              "token1": {
                "name": "Tether USD",
                "symbol": "USDT"
              }
            }
          },
          {
            "id": "0x34d51aec1022067a3715f289aadc09cc7533f05ca8d11ae338eea4c2e3e4d46e-1",
            "pair": {
              "token0": {
                "name": "Tether USD",
                "symbol": "USDT"
              },
              "token1": {
                "name": "Wrapped SYS",
                "symbol": "WSYS"
              }
            }
          }
        ],
        "blockNumber": "180616"
      },

and with a similar query via XQuery:

  "data": {
    "transaction": [
      {
        "swaps": [
          {
            "transaction": {
              "hash": "0x8bba1b1ca502628de18c8631ab7c2ea5904d944c229c05c373780ecd4379371f"
            },
            "pair": {
              "token": {
                "name": "Wrapped SYS",
                "symbol": "WSYS"
              },
              "token1": {
                "name": "Pegasys",
                "symbol": "PSYS"
              }
            }
          }
        ],
        "block": {
          "number": 180616
        }
      },
      {
        "swaps": [
          {
            "transaction": {
              "hash": "0x34d51aec1022067a3715f289aadc09cc7533f05ca8d11ae338eea4c2e3e4d46e"
            },
            "pair": {
              "token": {
                "name": "USD Coin",
                "symbol": "USDC"
              },
              "token1": {
                "name": "Tether USD",
                "symbol": "USDT"
              }
            }
          },
          {
            "transaction": {
              "hash": "0x34d51aec1022067a3715f289aadc09cc7533f05ca8d11ae338eea4c2e3e4d46e"
            },
            "pair": {
              "token": {
                "name": "Tether USD",
                "symbol": "USDT"
              },
              "token1": {
                "name": "Wrapped SYS",
                "symbol": "WSYS"
              }
            }
          }
        ],
        "block": {
          "number": 180616
        }
      },