| account | VARCHAR(16777216) | Hedera account ID in the format {shard}.{realm}.{num}. Identifies the account whose supply changed. |
| token_id | VARCHAR(16777216) | Hedera token ID in the format {shard}.{realm}.{num} identifying the stablecoin token. |
| token_type | VARCHAR(16777216) | Token standard for the asset (e.g. erc20) or the native currency symbol. |
| 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”). |
| token_decimals | NUMBER(38,0) | Number of decimal places used to represent the token’s smallest unit. Used to convert raw amounts: normalized_amount = raw_amount / 10^decimals. |
| raw_amount_str | VARCHAR(16777216) | Supply-change amount in the smallest unit as a string, to preserve full precision. |
| raw_amount | FLOAT | Supply-change amount in the token’s smallest indivisible unit (not decimal-adjusted). |
| amount_str | VARCHAR(16777216) | Normalized supply-change amount stored as a string to preserve full precision. |
| amount | FLOAT | Supply-change amount normalized by the token’s decimal precision (raw_amount / 10^decimals). Positive for mints, negative for burns. |
| usd_amount | FLOAT | USD value of the supply change 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. |
| is_approval | BOOLEAN | True if this token transfer was an approved transfer executed by a delegated spender account. |
| payer_account_id | VARCHAR(16777216) | Hedera account ID of the account that paid the transaction fee. |
| entity_id | VARCHAR(16777216) | Hedera entity ID in the format {shard}.{realm}.{num}. Identifies accounts, contracts, tokens, and other Hedera entities. |
| nonce | NUMBER(38,0) | Number of transactions sent from the sender’s address prior to this one. Used to prevent replay attacks and ensure transaction ordering. |
| result | VARCHAR(16777216) | Result code of the Hedera transaction (e.g. SUCCESS, INSUFFICIENT_ACCOUNT_BALANCE). |
| 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. Starts at 0 (genesis block) and increments by 1 for each new block. |
| 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. |
| 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. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row, stable across full refreshes. |
| event_name | VARCHAR(16777216) | Name of the event that triggered this supply change (e.g. mint or burn). |
| is_mint | BOOLEAN | True if this supply change is a token minting event. |
| is_burn | BOOLEAN | True if this supply change is a token burning event. |
| _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. |
