Stellar Stack Exchange is a question and answer site for developers and users of Stellar and the Stellar Distributed Exchange. It only takes a minute to sign up.
Sign up to join this community
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.
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.
