Announcement
Michael Calvey
September 26, 2023

New Datasets: Historical Asset Balances

Historical balances let you see the balance of any wallet for any token or NFT at any point in time.

Transposers,

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!

How the table works

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. 

How to use it

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:

What you can use it for

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:

  1. Calculate historical tax liabilities for realized gains on assets held in the past. 
  2. Easily track & chart the value of a wallet, broken down by individual token over time. 
  3. Track token decentralization over time
  4. Simple compliance & trade reporting on your compliance cycle

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. 

Get in touch

Have questions or feedback? Get in touch at [email protected] or in our discord

Return