Historical balances let you see the balance of any wallet for any token or NFT at any point in time.
We’re excited to roll out one of our most powerful datasets on Ethereum yet today - historical balances.
The new historical balance table tracks the value of all wallets’ token balances over time, for all tokens. This lets you rapidly track the value of portfolios over time, compare token holding decentralization and even calculate tax obligations in the most effective way possible.
This post will run through how the table works, how to use it, and what it can be useful for. We’re excited to see all the cool applications of this data people will come up with!
Our regular, current balance tables (see this token owners table for example) matches contract addresses with wallets and their respective current balance. Useful for doing things like quickly pulling all current holdings of a wallet, or seeing which wallets own the most of a particular token.
This table matches contract addresses, wallets, timestamps and balances. The addition of timestamps makes it easy to search for balances at any point in history.
Working with this table is straightforward, but a couple tricks make things much easier.
First, we suggest using our prebuilt REST endpoints if you have any qualms about working with your own SQL. These handle pagination for you, are maximally optimized and will make your life easy.
If you want to customize things, you’ll need to write SQL and deploy a Custom Endpoint.
Here are a couple sample queries built by our team:
Context around which wallets owned how much of various tokens in the past is very useful for a range of use cases. Here are a few ideas on how this table can be used:
We’re sure you’ll figure out many other interesting ways to take advantage of this data - especially when paired with our high level protocol abstraction tables like DEX swaps, liquidity deposits/withdrawals, and bridge events.