| address | VARCHAR(16777216) | Address of the account. |
| token_address | VARCHAR(16777216) | Token address of the asset; 0x0000000000000000000000000000000000000000 for the native token. |
| token_name | VARCHAR(16777216) | Name of the token. |
| token_symbol | VARCHAR(16777216) | Symbol of the token. |
| token_decimals | NUMBER(38,0) | Number of decimal places used to normalize the token’s raw balance. |
| raw_balance_str | VARCHAR(16777216) | String of the balance of tokens (unnormalized). |
| raw_balance | FLOAT | Balance of tokens (unnormalized). |
| balance_str | VARCHAR(16777216) | String of the balance, normalized by the decimal points defined by the BCH protocol in sats. One sat = 1e-8 BCH. |
| balance | FLOAT | Balance of the token, normalized by the decimal points defined by the BCH protocol in sats. One sat = 1e-8 BCH. |
| usd_balance_current | FLOAT | The amount of tokens, in $USD at the current time. |
| usd_balance_at_last_activity | FLOAT | The amount of tokens, in $USD at the price evaluated at the time of the last activity block. |
| usd_exchange_rate_current | FLOAT | The exchange rate used to calculate the usd_balance at the current time. |
| usd_exchange_rate_at_last_activity | FLOAT | The exchange rate used to calculate the usd_balance at the time of the last activity block. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | The latest timestamp of the block that resulted in a change in balance. |
| last_activity_block_number | NUMBER(38,0) | The number of the latest block that resulted in a change in balance. |
| last_activity_block_hash | VARCHAR(16777216) | The hash of the latest block that resulted in a change in balance. |
| last_activity_transaction_hash | VARCHAR(16777216) | The hash of the latest transaction that resulted in a change in balance. |
| last_activity_transaction_index | NUMBER(38,0) | The index within the block of the latest transaction that resulted in a change in balance. |
| unique_id | VARCHAR(16777216) | Unique ID of the balances entry. |
| _updated_at__usd_exchange_rate_current | TIMESTAMP_NTZ(9) | Time the USD exchange rate was calculated. |
| _updated_at__historical | TIMESTAMP_NTZ(9) | Time the historical (raw) balance was calculated. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
