Tools for Curation

Motivation

At P2P.org we are happy to provide The Graph community with a new tool to make the curation process more easier and more accessible through a data driven approach.

We have decided to contribute to the promotion of The Graph Curator role for a wider community since this does not require a lot of technical skills while at the same time gives everyone an opportunity to be fully engaged into the Web3 economy. As we move towards mass adoption it is important to give everyone a chance to participate in this technological breakthrough and because of that, we have created this new tool. Hence, the more satisfied users are, not only from a data consumer perspective, but also from an ecosystem participant point of view - the brighter the future for The Graph we all want to build.

The new tool helps users focus on extracting the maximum benefit from query fees and at the same time gives some overview statistics of the current situation on the curation market.

https://reports.p2p.org/superset/dashboard/graph_curation

Subgraphs leaderboard

The subgraphs tab provide the user with statistics on the subgraphs leaderboard.

We do want the signals market to follow the query fees and that is why we calculate query fees APR and query fees probability to provide curators with a convenient way of making data-driven decisions.

Query fees (QF) probability is calculated based on the past 30 days. If there were no queries in the last month, the probability of new queries is close to 0. The percentage takes into account all closed allocations, their size and duration and estimates the probability of the next query. Whether an indexer would get the query or not also depends on other parameters, but they are a lot harder to include into a generalised model and that is why we limited the probability calculations to only 2 parameters.

QF APR is estimated based on the annualised Price per Share changes in the last 30 days based on indexers’ allocation collect events. We’ve decided to calculate QF APR this way as the fees affect the share price, thus changing the bonding curve shape. Curators’ actions are removed from this APR calculations.

QF APR If You Signal N GRT is calculated considering current signals & query fees collected in the last 30 days. In cases where signals were burnt, the new calculated APR would be bigger than the current APR. When someone decides to join a subgraph’s bonding curve then there are less query fees for each curator, thus the APR decreases.

Curators Leaderboard

In case you want to investigate the most successful curators strategies you can switch to The Curators Leaderboard tab. Here you can see the curators’ statistics for the selected timeframe.

NB! The data is joined date by date, not block by block, so some changes (P\L, QF APR, etc.) may have happened before or after some exact action. For this reason, these numbers are approximations.

The signalled & unsignaled columns catch the filtered dates (the default filter is “last month”). So, if the curator has signalled 40 days ago and the filter is set to the default then this field would be 0.

Query fees APR is estimated based on annualised Price per Share changes in the selected date frame due to indexers’ allocation collect events. The APR spikes may happen in cases when the signal event has happened at the same date as the query fees were assigned.

The difference from the subgraphs tab is that this APR is not influenced by dates, so it represents the current APR. It also does not take into account the number of days for curators that allocate on this subgraph. On the subgraphs tab the APR is smoothed out as it is counted on a 1 month scale, even though subgraphs may exist only for several days.

On the contrary, the curators tab’s QF APR takes into account the exact number of days a curator signalled a particular subgraph and it is influenced by the selected timeframe. So, it may have some outliers in cases when query fees were assigned right after the signal minting.

To sum up, use the subgraph tab for long-term investments and curators tab for short-term reaction on other curators moves.

The shares value is calculated based on the assumption if a curator decides to sell all of his / her shares starting from the current price per share and ending up at a new price per share according to the bonding curve.

The “Num actions” parameter includes signal mint & burn events.

P\L Realised is calculated after the unsignal event.

P\L Unrealised is calculated according to remaining shares value.

To investigate the positions of some particular curator more precisely you can use Selected Curatos’ Subgraphs table and chart

On Selected Curators Subgraphs you can see the subgraph that a user had been curating in the selected timeframe and how the shares value had been changing in time. In the table there is a detailed explanation on how the numbers from the leaderboard were formed.

The “Days” parameter represents the number of days since the last signal change.

Signals % shows the portion of the subgraphs’ shares owned by the curator.

Let’s make The Graph better together!

We hope that you will find this new tool useful! You may share it with your friends outside of The Graph community and maybe they’ll join our network.

You may write any suggestions on ways to improve this dashboard or any bugs that you find in the Graph discord to @Anton Gaev

2 Likes