How does one view addresses that were staking with a specific pool at a specific epoch boundary?

If there is any way to view a list of addresses that received staking rewards for a particular block, that could also do the trick.

2 Answers 2


If you need any kind of specific on chain information that isn't found on third party explorers like Cardanoscan, you'd have to use db-sync yourself. (It's what all the explorers use)

To quote directly from the db-sync github:

" The purpose of Cardano DB Sync is to follow the Cardano chain and take information from the chain and an internally maintained copy of ledger state. Data is then extracted from the chain and inserted into a PostgreSQL database. SQL queries can then be written directly against the database schema or as queries embedded in any language with libraries for interacting with an SQL database.

Examples of what someone would be able to do via an SQL query against a Cardano DB Sync instance fully synced to a specific network is:

  • Look up any block, transaction, address, stake pool etc on that network, usually by the hash that identifies that item or the index into another table.
  • Look up the balance of any stake address for any Shelley or later epoch.
  • Look up the amount of ADA delegated to each pool for any Shelley or later epoch. "

There are LOTS of examples in the interesting sql queries

  • Thanks a ton, especially for the examples link. This seems to be exactly what I've been looking for. Dec 10, 2021 at 21:34

If you do not want to setup cardano-db-sync, try blockfrost.io with the /epochs/{number}/blocks/{pool_id} endpoint.

  • That's a great point about blockfrost. Checking it out has been on my TODO for several months. Dec 10, 2021 at 21:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.