USD prices for NFT token balances are not supported currently.

ERC1155 balances table contains the ERC1155 balances of all addresses, at every block height. Use this table to easily plot the change in the balance of ERC1155 tokens for an address or a group of addresses over time.

Sample Query

Getting the Balances of Cryptovoxel, an ERC1155 token from an address.

select * from ethereum.assets.erc1155_balances

where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

and token_address = '0xa58b5224e2fd94020cb2837231b2b0e4247301a6' -- Cryptovoxel Wearables 

order by block_number desc   

Note that ERC1155 permits the creation of both semi-fungible tokens and non-fungible tokens. In other words, there can be more than one quantity for a particular ERC1155 contract and token ID.

Table Columns

Column NameDescriptionExampleColumn Name
addressAddress of the account.0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459
token_addressToken address of the ERC1155 token.0xa58b5224e2FD94020cb2837231B2B0E4247301A6
token_nameName of the ERC1155 token.Cryptovoxel Wearables
token_symbolToken symbol of this token.WEAR
token_idUnique token ID of the ERC1155 token.3029
raw_balanceBalance of tokens (unnormalized). For ERC1155 tokens, there are no decimals division involved.2
balanceBalance of tokens. For ERC1155 tokens, unlike ERC721, the max balance can be more than 1. 2
usd_valueThe amount of tokens, in $USD.
usd_exchange_rateThe exchange rate used to calculate the usd_value.
block_timestampThe timestamp of the block that that resulted in the balance.2020-08-04T19:55:07
block_numberThe number of the block that resulted in the balance.10595307
block_hashThe hash of the block that resulted in the balance.0xf64dfbe61a1e33cf7390d41a0be963a4d8c759f455ea69b42360bd7c42e50das