How to query all accounts holding the specific asset?

kiewza

Hi,

Could anyone please advice how to query which accounts (public key) are holding the specific asset?
It would be great if we can know the balance as well

Thanks in advanced,

jeffditullio

kiewza I don't think it's doable with just horizon api, so you have a couple options:
1) use a website like stellar.expert https://stellar.expert/explorer/public/asset/HKDT-GABSZVZBYEO5F4V5LZKV7GR4SAJ5IKJGGOF43BIN42FNDUG7QPH6IMRQ?filter=asset-holders
2) if you're running stellar core you could query the core db trustlines table directly

kiewza

Thanks so much jeff : )