Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.allium.so/llms.txt

Use this file to discover all available pages before exploring further.

Table Details

PropertyValue
Table Namecasper.assets.fungible_balances
Table StatusProduction-Ready

Table Columns

Column NameData TypeDescription
addressVARCHAR(16777216)Holder address whose token balance is recorded.
token_typeVARCHAR(16777216)Type of token (native CSPR or CEP-18).
token_addressVARCHAR(16777216)Address (contract package hash) of the token.
token_nameVARCHAR(16777216)Human-readable name of the token.
token_symbolVARCHAR(16777216)Ticker symbol of the token.
token_decimalsNUMBER(38,0)Number of decimals used to convert raw amounts to human-readable amounts.
raw_balance_strVARCHAR(16777216)Raw balance in the token’s smallest unit as a string (preserves full precision).
raw_balanceFLOATRaw amount in the token’s smallest unit (no decimal adjustment).
balance_strVARCHAR(16777216)Human-readable balance adjusted for token decimals as a string.
balanceFLOATHuman-readable amount adjusted for token decimals.
usd_exchange_rateFLOATUSD price per unit of the token at the time of the event.
usd_balanceFLOATUSD value at the time of the event, using the closest available price.
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block this event was included in.
block_numberNUMBER(38,0)Height of the block this event was included in.
block_hashVARCHAR(16777216)Hash of the block this event was included in.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.