| product_id | VARCHAR(16777216) | Allium stablecoin product identifier (e.g. usdc, usdt). |
| is_native | BOOLEAN | True if this is the issuer’s canonical deployment on this chain (not a bridge-wrapped version). |
| stablecoin_type | VARCHAR(16777216) | Classification of the stablecoin mechanism (e.g. fiat_backed, crypto_backed, algorithmic). |
| currency | VARCHAR(16777216) | Fiat currency this stablecoin is pegged to, as an ISO 4217 code in lowercase (e.g. usd, eur). |
| from_address | VARCHAR(16777216) | Address that sent the transfer. For token transfers, the account whose balance decreased. |
| to_address | VARCHAR(16777216) | Address that received the transfer. For token transfers, the account whose balance increased. |
| token_address | VARCHAR(16777216) | Contract address of the stablecoin token. |
| token_type | VARCHAR(16777216) | Token standard for the asset (e.g. erc20) or the native currency symbol. |
| token_name | VARCHAR(16777216) | Name of the stablecoin. |
| token_symbol | VARCHAR(16777216) | Symbol of the stablecoin. |
| token_decimals | NUMBER(38,0) | Decimal precision of the stablecoin. Used to convert raw amounts: normalized_amount = raw_amount / 10^decimals. |
| raw_amount_str | VARCHAR(16777216) | Transfer amount in the smallest unit as a string, to preserve full precision. |
| raw_amount | FLOAT | Transfer amount in the token’s smallest indivisible unit (not decimal-adjusted). |
| amount_str | VARCHAR(16777216) | Normalized transfer amount stored as a string to preserve full precision. |
| amount | FLOAT | Transfer amount normalized by the token’s decimal precision (raw_amount / 10^decimals). |
| usd_amount | FLOAT | USD value of the transfer at the time of the event, computed using the hourly USD exchange rate. |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the time of the event, used to compute usd_amount. Sourced from Allium’s hourly price feed. |
| payer_account_id | VARCHAR(16777216) | Hedera account ID of the account that paid the transaction fee. |
| transaction_type | VARCHAR(16777216) | Ethereum transaction envelope type. 0 = Legacy, 1 = Access List (EIP-2930), 2 = EIP-1559 dynamic fee. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction_id | VARCHAR(16777216) | Hedera transaction ID in the format {payer_account_id}@{seconds}.{nanoseconds}. |
| transfers_index | NUMBER(38,0) | Zero-based index of this transfer within a Hedera transaction that contains multiple transfers. |
| block_hash | VARCHAR(16777216) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| consensus_timestamp | TIMESTAMP_NTZ(9) | The consensus timestamp on Hedera, expressed as nanoseconds since Unix epoch. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row, stable across full refreshes. |
| _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 metadata 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. |
