Balances
Fetch block-level changes in the balances of assets across wallets.
Blockchain Coverage
We support balances data for the following blockchains:
Blockchain | Balances Model |
---|---|
Bitcoin | The bitcoin.assets.balances contains Bitcoin balance-block changes in balances. Refer to here for more details. |
Solana | The solana.assets.balances contains Solana SOL and SPL token balances models. Refer to here for more details. |
Sui | The sui.raw.balance_changes Balance changes track the alterations in the amount of assets held by accounts, caused by transactions on Sui. Refer to here for more details. |
EVM-Compatible Blockchains | The crosschain.assets.fungible_balances_evm model offers a historical record of fungible asset balances, including native gas tokens and ERC-20 compatible tokens. |
EVM-Compatible Blockchains
The crosschain.assets.fungible_balances_evm
model offers a historical record of fungible asset balances, including native gas tokens and ERC-20 compatible tokens.
Each entry in the model corresponds to a specific event/transaction that causes a balance change in a particular asset at the block level. This means a new data entry is only created when a transaction alters an asset’s balance at the block level.
- For example, if a wallet receives 1 ETH in 2015 and experiences no further changes until yesterday, the model will have two entries: one for the initial receipt in 2015 and another for the recent change
Blockchain Coverage
We support fungible balance data (erc20 & native token) for the following EVM-compatible blockchains:
Sample Query
Generate Daily Balances from block-level balances data
Generate Daily Balances from block-level balances data
This query generates daily balances from block-level balances data.
- Replace the address with the desired wallet address, in lowercasing.
- Replace the chain with the desired blockchain.
Note: the final output will contain all tokens held by the wallet, including undesirable spam tokens. One approach to counter this would be to filter the output of the query with the desired tokens or balances above a certain USD value.
Table Column
Unique Key: unique_id
Column Name | Description |
---|---|
chain | The EVM-compatible blockchain of where the assets are held. |
address | The wallet address holding the token. |
token_address | The contract address of the token. Native tokens are represented with zero address. |
token_name | The name of the token. |
token_symbol | The symbol of the token. |
raw_balance_str | The raw balance as a string to retain precision. |
raw_balance | The raw balance as a numeric value. |
balance_str | The formatted balance as a string to retain precision. |
balance | The formatted balance as a numeric value. |
usd_balance | The balance converted to USD. |
usd_exchange_rate | The exchange rate used for USD conversion. |
block_timestamp | The timestamp of the block containing the balance. |
block_number | The block number containing the balance. |
block_hash | The hash of the block containing the balance. |
unique_id | A unique identifier for the balance record. |
_updated_at | The timestamp of the last update to the balance record. |