| date | TIMESTAMP_NTZ(9) | Calendar date (UTC) of the daily market snapshot. Values are forward-filled from the most recent end-of-day snapshot of the market. |
| project | VARCHAR(16777216) | Business name of the lending protocol (e.g. suilend, navi_lend, scallop, aries_markets, echelon). |
| protocol | VARCHAR(16777216) | Specific version or variant of the lending protocol (e.g. scallop_lend, aptin_finance_v2). Qualifies the project field. |
| id | VARCHAR(16777216) | Unique identifier of the market within its protocol, built from the protocol or market object address and the market’s token. |
| contract_address | VARCHAR(16777216) | Address of the lending market: the protocol package address or the market object id (the Move analogue of a contract address). |
| token_address | VARCHAR(16777216) | Move coin type or fungible asset address of the market’s token (e.g. 0x2::sui::SUI). |
| 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”). |
| token_decimals | NUMBER(38,0) | Number of decimal places used to represent the token’s smallest unit. |
| usd_exchange_rate | FLOAT | USD price per unit of the token at the start of the snapshot date, from Allium’s hourly price feed. Used to compute the _usd columns. |
| outstanding_loans | FLOAT | Total amount of tokens borrowed from the market, normalized by token decimals. |
| outstanding_loans_usd | FLOAT | USD value of the loans outstanding (borrowed and not yet repaid) in the market. |
| available_liquidity | FLOAT | Amount of tokens available for borrowing, normalized by token decimals. |
| available_liquidity_usd | FLOAT | USD value of the tokens available to borrow from the market. |
| supplied_amount | FLOAT | Total amount of tokens supplied to the market, normalized by token decimals. |
| supplied_amount_usd | FLOAT | USD value of the tokens supplied to the market. |
| transaction_hash | VARCHAR(16777216) | Hash of the last transaction that changed the market state as of this date (Aptos). |
| transaction_block_digest | VARCHAR(16777216) | Digest of the last transaction block that changed the market state as of this date (Sui). |
| last_activity_block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the last activity that changed the market state as of this date. |
| last_activity_transaction_version | NUMBER(38,0) | Transaction version of the last activity that changed the market state as of this date (Aptos). |
| last_activity_block_height | NUMBER(38,0) | Block height of the last activity that changed the market state as of this date (Aptos). |
| last_activity_checkpoint_sequence | NUMBER(38,0) | Checkpoint sequence number of the last activity that changed the market state as of this date (Sui). |
| last_activity_checkpoint_digest | VARCHAR(16777216) | Checkpoint digest of the last activity that changed the market state as of this date (Sui). |
| extra_fields | VARIANT | Protocol-specific fields from the snapshot, such as raw integer amounts, borrow_apy, supply_apy, and market metadata. |
| _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. |
