| from_address | VARCHAR(34) | Address that sent the stablecoin. The account whose balance decreased. |
| to_address | VARCHAR(34) | Address that received the stablecoin. The account whose balance increased. |
| token_address | VARCHAR(34) | Contract address of the stablecoin token. |
| token_name | VARCHAR(16777216) | Full name of the token (e.g. “USD Coin”). |
| token_symbol | VARCHAR(16777216) | Ticker symbol of the token (e.g. “USDC”). |
| raw_amount_str | VARCHAR(16777216) | Token amount in the smallest 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) | Normalized token amount stored as a string to preserve full precision. |
| amount | FLOAT | Token amount normalized by the token’s decimal precision. |
| usd_amount | FLOAT | USD value of the token amount at the time of the event. |
| usd_exchange_rate | FLOAT | Exchange rate used for USD conversion. |
| transaction_from_address | VARCHAR(34) | Address of the account that signed and submitted the transaction. May differ from from_address when a contract routes tokens on a user’s behalf. |
| transaction_to_address | VARCHAR(34) | Address the transaction was sent to (the top-level to field). May be a router or contract rather than the token recipient. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. |
| 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. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. |
| 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. |
| currency | VARCHAR(16777216) | Fiat currency this stablecoin is pegged to, as an ISO 4217 code in lowercase (e.g. usd, eur). |
| base_asset | VARCHAR(16777216) | Canonical name of the stablecoin (e.g. USDC, USDT, DAI). |
| is_bridge | BOOLEAN | True if this token is a bridged representation. False if it is the canonical deployment by the issuer. |
| _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. |
| _metadata_updated_at | TIMESTAMP_NTZ(9) | Timestamp when token metadata (name, symbol, etc.) was last updated. |
