| chain | VARCHAR(10) | Slug identifying the blockchain this record belongs to (e.g. ethereum, base, avalanche, solana). In per-chain tables this is always the same value; in cross-chain tables it identifies which chain the row came from. |
| token_type | VARCHAR(6) | Type or standard of the token, as the chain names it. For example erc20, erc721, erc1155 or native on EVM chains, TRC20 or TRX on Tron, spl-token, system or sol on Solana, and coin or fungible_asset on Aptos and Sui. The values depend on the table. |
| address | VARCHAR(16777216) | Wallet or contract address of the account. On EVM chains, a 42-character hex string (0x-prefixed). On other chains, the native address format applies. |
| token_address | VARCHAR(16777216) | Contract address of the token. For EVM chains, native currency (e.g. ETH, MATIC) is represented as the zero address (0x0000000000000000000000000000000000000000). For Solana, this is the mint address. |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”, “Wrapped Ether”). |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”, “WETH”). |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances. |
| raw_balance | FLOAT | Token balance in the token’s smallest unit (not decimal-adjusted). Use balance for the human-readable normalized value. |
| balance_str | VARCHAR(16777216) | Normalized token balance stored as a string for full precision. Equivalent to balance but avoids floating-point truncation. |
| balance | FLOAT | Token balance normalized by the token’s decimal precision (raw_balance / 10^decimals). Human-readable value (e.g. 1.5 USDC rather than 1500000). |
| usd_balance_current | FLOAT | USD value of the token balance using the most recent available price, updated independently of balance changes. |
| usd_balance_at_block_timestamp | FLOAT | USD value of the token balance using the price at the timestamp of the last balance-changing event. |
| usd_exchange_rate_current | FLOAT | Most recent USD price per unit of the token, used to compute usd_balance_current. |
| usd_exchange_rate_at_block_timestamp | FLOAT | USD price per unit of the token at the timestamp of the last balance-changing event. |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block that last changed this balance. |
| last_activity_block_number | NUMBER(38,0) | Block number of the block that last changed this balance. |
| last_activity_block_hash | VARCHAR(16777216) | Hash of the block that last changed this balance. |
| unique_id | VARCHAR(107) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _updated_at__usd_exchange_rate_current | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the current USD exchange rate for this token. Updated independently when prices are refreshed, separate from balance data. |
| _updated_at__historical | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to the historical (at-block-timestamp) data for this row. |
| _created_at__onchain_lake | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this row was first written to the onchain lake (the raw data layer before mart transformation). |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
| _changed_since_full_refresh | BOOLEAN | Flag indicating whether this row was created or modified after the last full refresh of the model. Useful for identifying recently added or updated records in incremental processing. Same concept as _change_since_full_refresh — the column name varies by model generation. |