| product_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt). Groups the canonical and bridged variants of the same stablecoin on the chain. |
| is_native | BOOLEAN | True if this is the issuer’s canonical deployment on this chain (not a bridged representation). |
| stablecoin_type | VARCHAR(16777216) | Classification of the stablecoin deployment: native, bridged, yield_bearing, lending_receipt, vault_share or unclassified. |
| currency | VARCHAR(16777216) | Fiat currency the stablecoin is pegged to, as a lowercase ISO 4217 code (e.g. usd, eur). |
| from_address | VARCHAR(16777216) | Sender of the stablecoin transfer. The placeholder 0x for mints. |
| to_address | VARCHAR(16777216) | Recipient of the stablecoin transfer. The placeholder 0x for burns. |
| token_address | VARCHAR(16777216) | Bank denom of the stablecoin (on Injective, e.g. peggy0x..., ibc/..., factory/..., or erc20:0x... for MultiVM EVM tokens such as USDC). |
| token_name | VARCHAR(16777216) | Name of the stablecoin, from the chain’s fungible token metadata. |
| token_symbol | VARCHAR(16777216) | Symbol of the stablecoin, from the chain’s fungible token metadata. |
| decimals | NUMBER(38,0) | Decimal precision of the stablecoin from Allium’s stablecoin registry, used to normalize amount. |
| event_type | VARCHAR(16777216) | Cosmos SDK event type that produced the transfer (e.g. transfer, ibc_transfer, coinbase for mints, burn for burns). |
| raw_amount_str | VARCHAR(16777216) | Transfer amount in the token’s smallest unit, as a string to retain full precision. |
| raw_amount | FLOAT | Transfer amount in the token’s smallest unit (not decimal-adjusted). |
| amount_str | VARCHAR(16777216) | Transfer amount normalized by the stablecoin’s registry decimals, as a string to retain precision. |
| amount | FLOAT | Transfer amount normalized by the stablecoin’s registry decimals. |
| usd_amount | FLOAT | Transfer amount valued in USD: amount multiplied by usd_exchange_rate. |
| usd_exchange_rate | FLOAT | USD price of the stablecoin: the daily stablecoin price for the transfer date, falling back to the hourly token price when no daily price exists. |
| tx_sender | VARCHAR(16777216) | The address that initiated the transaction. |
| transaction_hash | VARCHAR(16777216) | The hash of the transaction containing this transfer. |
| transaction_index | NUMBER(38,0) | The index of the transaction within the block. |
| event_index | NUMBER(38,0) | The index of the event within the transaction. |
| code | NUMBER(38,0) | The transaction result code (0 indicates success). |
| tx_success | BOOLEAN | Whether the transaction was successful. |
| memo | VARCHAR(16777216) | Memo of the IBC transfer, if applicable. Null for mints, burns and non-IBC transfers. |
| src_channel | VARCHAR(16777216) | Source IBC channel for cross-chain transfers. Null for mints, burns and non-IBC transfers. |
| dst_channel | VARCHAR(16777216) | Destination IBC channel for cross-chain transfers. Null for mints, burns and non-IBC transfers. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block containing this transfer. |
| block_height | NUMBER(38,0) | The height of the block containing this transfer. |
| block_hash | VARCHAR(16777216) | The hash of the block containing this transfer. |
| unique_id | VARCHAR(16777216) | Unique identifier for the transfer, inherited from the underlying fungible token transfer. |
| _transfer_created_at | TIMESTAMP_NTZ(9) | Timestamp when the underlying transfer record was first ingested. |
| _transfer_updated_at | TIMESTAMP_NTZ(9) | Timestamp when the underlying transfer record was last updated. |
| _metadata_updated_at | TIMESTAMP_NTZ(9) | Timestamp when the stablecoin registry record for this token was last updated. |
| _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. |
