Fungible Balances
The fungible balances table contains historical native token (e.g. ETH, MATIC, AVAX) and ERC20 tokens the balance of all addresses, at block height that has a balance change for the particularly address.
Sample Query
Query wallet Balance of a wallet by token address.
Table Columns
| Column Name | Type | Description | Example |
|---|---|---|---|
| address | varchar | Address of the account. | 0xd97d0911007bef00748579c5b8879a135ca31950 |
| token_address | varchar | Token address. Native ETH is represented as
| 0x0000000000000000000000000000000000000000 |
| raw_balance | numeric(512) | Unormalized token balance. For ETH, balance of eth in wei. | 8276168041811796 |
| block_timestamp | timestamp | The timestamp of the block that that resulted in the
| 2023-10-14T18:22:25 |
| block_number | bigint | The number of the block that resulted in the | 5259199 |
| block_hash | varchar | The hash of the block that resulted in the | 0x255d26efe0fe8c636f26f922ffb6de2093a070dd779a835e06f554b4d7a1181c |