I’m attempting to get the active stake value from cardano-db-sync for a pool at a specific epoch so I know how much stake it had for the next snapshot.

I’m currently using the following query

SELECT SUM(amount) FROM epoch_stake 

WHERE epoch_stake.epoch_no = $1 AND pool_id = $2

This query seems to work, but my result is quite a bit off when compared to what cardanoscan.io shows as the active stake for the same pool.

  • 1
    Active stake is an instantaneous stake distribution at the current block (and can change with each new block) whereas the epoch_stake table gives the stake distribution for a single epoch. Sep 23, 2022 at 10:24


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.