| date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this record represents. Used in daily aggregate tables. |
| project | VARCHAR(16777216) | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| address | VARCHAR(16777216) | Lending pool contract address holding this balance. |
| market_address | VARCHAR(16777216) | Address of the lending market contract. For Aave this is the Pool/LendingPool address; for Compound this is the cToken contract; for Morpho this is the specific market address. |
| token_address | VARCHAR(16777216) | Identifier of the asset held. native for the chain’s native asset (XLM on Stellar); otherwise the asset’s contract or issuer-qualified identifier. |
| 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. For example, USDC has 6 decimals, so 2500000 raw units = 2.5 USDC. |
| 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. |
| raw_balance_str | VARCHAR(16777216) | Token balance in the smallest unit, stored as a string for full precision. Avoids floating-point truncation for tokens with very large integer balances. |
| raw_balance | FLOAT | Raw balance, string cast to float (precision-lossy for very large i128 values — use raw_balance_str for exact amounts). |
| balance_str | VARCHAR(16777216) | Decimal-normalized balance, string-typed for precision. |
| balance | FLOAT | Decimal-normalized balance. |
| usd_balance | FLOAT | USD value of this balance, null if it would exceed the $10B outlier guard. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Timestamp (UTC) when the XRP or Stellar ledger closed and was validated by the network. Equivalent to block_timestamp on EVM chains. |
| ledger_sequence | NUMBER(38,0) | Stellar ledger sequence number. |
| ledger_hash | VARCHAR(16777216) | Hash of the XRP or Stellar ledger. Equivalent to block_hash on EVM chains. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
