Substream to accumulate SOL balance for every account

[this-username-is-taken]

you can use https://github.com/messari/substreams/tree/master/eth-balance as a reference

[melotik]

@this-username-is-taken do we also want to be able to retrieve the balance of any address at any block?

It doesn't seem like the eth-balance supports that, but maybe I am misunderstanding or reading this wrong

[this-username-is-taken]

yes, though we don't need to put data at every block in the store to retrieve that. SF provides a very nice way called "initial snapshots" that you can leverage. You can check it out here: https://github.com/this-username-is-taken/lido-balances, specifically https://github.com/this-username-is-taken/lido-balances/blob/37d00ff702e24588c0ae9e784fe93d5aa887ee57/main.py#L54.

You can also use this mode in substreams run by adding and -i option:

$ substreams run --help
Stream modules from a given package on a remote endpoint

Usage:
  substreams run <manifest> <module_name> [flags]

Flags:
  -h, --help                                 help for run
  -i, --initial-snapshots                    Load an initial snapshot at start block, before continuing processing.
  -k, --insecure                             Skip certificate validation on GRPC connection
  -o, --output string                        Output mode. Defaults to 'ui' when in a TTY is present, and 'json' otherwise
  -p, --plaintext                            Establish GRPC connection in plaintext
  -s, --start-block int                      Start block to stream from. Defaults to -1, which means the initialBlock of the first module you are streaming (default -1)
  -t, --stop-block string                    Stop block to end stream at, inclusively. (default "0")
      --substreams-api-token-envvar string   name of variable containing Substreams Authentication token (default "SUBSTREAMS_API_TOKEN")
  -e, --substreams-endpoint string           Substreams gRPC endpoint (default "api.streamingfast.io:443")

[melotik]

Can use this dashboard to QA: https://messari.app.zettablock.com/my-workspace/queries/qu15-d679c88c-1a9b-4649-90a5-8f4614c16a8d