I operate a multi-owner pool with separate rewards account.
I’m not able to find per-owner rewards in cardano-db-sync.
I am able to query total rewards that go to the rewards account, but not per-owner rewards as seen on pooltool.io if you visit the address page.
Any help or snippet will be highly appreciated!
I really hope that such data exists in db-sync and is not something custom or not publicly available
Right now rewards distribution is cumbersome, I have to manually go to pooltool.io to determine each owner’s exact reward and do transactions.
Since recently that became even harder when pooltool.io has prevented seeing rewards for not your, not-claimed address.