| chain | VARCHAR(16777216) | Name of the blockchain network this record belongs to. |
| from_address | VARCHAR(16777216) | Address that sent in this event. For token transfers, the account whose balance decreased. |
| to_address | VARCHAR(16777216) | Address that received in this event. For token transfers, the account whose balance increased. |
| transfer_type | VARCHAR(9) | Category of transfer (e.g. mint, burn, standard transfer). |
| token_type | VARCHAR(16777216) | Token standard or category (e.g. erc20, erc721, native). |
| token_address | VARCHAR(16777216) | Contract address of the token. On EVM chains native currency is represented as the zero address. |
| token_name | VARCHAR(16777216) | Human-readable name of the token. |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token. |
| token_decimals | NUMBER(38,0) | Number of decimal places used to convert the token’s raw integer amount to a human-readable amount. |
| raw_amount_str | VARCHAR(16777216) | Token amount in the smallest indivisible unit as a string, to preserve full precision. |
| raw_amount | FLOAT | Token amount in the smallest indivisible unit (not decimal-adjusted). |
| amount_str | VARCHAR(16777216) | Decimal-adjusted token amount represented as a string to preserve full precision. |
| amount | FLOAT | Decimal-adjusted amount of tokens involved in this record. |
| usd_amount | FLOAT | USD value of the amount, computed using the token’s USD exchange rate at the record’s timestamp. |
| usd_exchange_rate | FLOAT | USD price of one unit of the token at the record’s timestamp. |
| transaction_from_address | VARCHAR(16777216) | Sender (msg.sender) of the transaction that produced this record. |
| transaction_to_address | VARCHAR(16777216) | Destination address of the transaction that produced this record (may be a smart contract). |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0. |
| block_date | DATE | Calendar date (UTC) of the block that contains this record. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis) and increments by 1 per block. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| _rwa_token_created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the RWA token record was first created in the Allium platform. |
| _transfers_created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the underlying transfer record was first created in the Allium platform. |
| _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. |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |
| is_mint | BOOLEAN | Whether this transfer is a mint (tokens created, originating from the zero address). |
| is_burn | BOOLEAN | Whether this transfer is a burn (tokens destroyed, sent to the zero address). |
