Generate CSV Exports of your Solana Staking Rewards.

solana-staking-csvs is a CLI program that queries the Solana blockchain for an account's staking accounts and exports all their staking rewards to a CSV file.

The Solana Beach API is used to fetch data from the blockchain and you will need a free API key to use this program.

You can install solana-staking-csvs with Stack: stack install --resolver nightly solana-staking-csvs. Then run the following to print out an account's rewards in CSV format:

solana-staking-csvs <API_KEY> <ACCOUNT_PUBKEY>

See solana-staking-csvs --help for additional options.

Solana Staking CSVs

Generate CSVs of your Solana staking rewards.

Requires stack & a SolanaBeach API key, which you can request here.

stack run -- <YOUR_API_KEY> <ACCOUNT_PUBKEY>
stack run -- --help

TODO:

• Allow sourcing pubkey & apikey from env variables?
• Move SolanaBeach API to separate, published package.

Install

You can install the CLI exe by running stack install. This lets you call the executable directly instead of through stack:

$ stack install
$ export PATH="${HOME}/.local/bin/:${PATH}"
$ solana-staking-csvs <YOUR_API_KEY> 6MTkiDNY5N5PoJHN862D91jM5ztF3KQWDyBeobo2rSgK
time,amount,stakeAccount,epoch
2021-07-03 19:49:49UTC,27.115357569,8yfoauy7WhfBGA441GsHnjQedeAga8MsZXu8Pn16xMmY,197
2021-07-06 21:44:25UTC,27.197834728,8yfoauy7WhfBGA441GsHnjQedeAga8MsZXu8Pn16xMmY,198
2021-07-10 00:02:06UTC,27.231624940,8yfoauy7WhfBGA441GsHnjQedeAga8MsZXu8Pn16xMmY,199
2021-07-10 00:02:06UTC,27.233380734,7XitpDt2tUwwmmmxfbPC4jJ6cCseuBBQHw5p6kWqmqvn,199

Build

You can build the project with stack:

stack build

For development, you can enable fast builds with file-watching, documentation-building, & test-running:

stack test --haddock --fast --file-watch --pedantic

To build & open the documentation, run

stack haddock --open solana-staking-csv

LICENSE

BSD-3