Indexer Staked Tokens Tracker

This is a substreams which can be used to track the staked tokens of an indexer.

This is a first draft and the which recalculates the staked tokens of an indexer every time an allocation is closed.

Future work could include:

• Tracking when a stake is directly added to an indexer's account

Usage

By default, this substreams tracks all indexers, but you can filter the indexers you want to track by setting the params on the map_allocation_closed module.

The default parameter is '*' to track all indexers. To track specific indexers, set this value to a json list of indexer addresses. For example: '["35917c0eb91d2e21bef40940d028940484230c06"]'

Deployment

This substreams has a db_out module which can be used with the substreams-sink-sql to store the data in a SQL database.

For more information on how to deploy this way, refer to https://github.com/streamingfast/substreams-sink-sql

You can use devel/up.sh (rm -rf devel/data if you want) and you will get an instance with this DSN:

DSN=psql://dev-node:insecure-change-me-in-prod@localhost:5432/dev-node?sslmode=disable

In short: If you have a postgres database running and the dsn is $DSN, you can deploy this substream with the following command:

substreams-sink-sql setup $DSN https://spkg.io/streamingfast/indexer-stake-tracker-v0.0.1.spkg

This will set up the tables on the database.

Then you can deploy the substream with the following command:

substreams-sink-sql run $DSN https://spkg.io/streamingfast/indexer-stake-tracker-v0.0.1.spkg

Then you can extract the data like this:

today=$(date +%Y-%m-%d)
psql2csv --host 127.0.0.1 -W  -U dev-node dev-node "select * from staked_tokens_changes" > indexer-rewards-stakes-${today}.csv