how would I go about obtaining a list of historical data (tokens held, their quantities and a timestamp) for an address? The stellar expert explorer has a way of generating this kind of data, an example can be seen here. Could this be obtained from the public horizon endpoint or a stellar core instance or is it a bit more involved (if yes where should I start looking?).

Thank you.

2 Answers 2


You can run aggregation query over the history_effects "replaying" all effects for the account (don't forget to join history_transactions to sum up tx fees). But you won't get the precise balances as Horizon currently ignores failed transactions, therefore there is no way to determine how much XLM were spent on the failed transactions fees based on the information available in Horizon db.

The only way to calculate balances precisely is to parse Stellar archives (or XDR records stored in Core database) directly.


You cannot get the historical balance directly, but it is possible.

The endpoints "transaction effects" and "transaction for accounts" could help you to deduce the actions and changes on certain accounts.

Your Answer

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

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