Assets
Balances
Sample query:
Table Columns
Column Name | Description | Example |
---|---|---|
address | Address of the account. | bc1qvs5783dumxhulduns7r48tk744dulw2x2nt2kk |
raw_balance | Balance of tokens (unnormalized) | 15,834,706 |
raw_balance_str | String of balance of tokens | 15834706 |
balance | Balance of the token, normalized by the decimal points defined by BTC protocol in sats. One sat = 1e-8 btc | 0.15834706 |
balance_str | Balance of this token, normalized by the decimal points defined in the token contract. | 0.15834706 |
usd_balance | The amount of tokens, in $USD at the current time. | 5,373.119530803 |
usd_exchange_rate | The exchange rate used to calculate the usd_value at current time. | 33,932.55 |
block_timestamp | The timestamp of the block that that resulted in change in balance. | 2023-10-24 09:34:58 |
block_number | The number of the block that resulted in change in balance. | 813,624 |
block_hash | The hash of block that resulted in change in balance. | 00000000000000000003306de67b0a54e98ef716b46b012d4d0937286e38d577 |
unique_id | Unique ID of the balances entry | block-813634_address-18BHxCWdeGXLFm9BwpmaPzEMLbcxHxiwRj_bitcoin |