> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Markets Daily

Daily market state by token for lending protocols on Move chains. Each row holds the supplied amount (deposits), outstanding loans, and available liquidity of one market on one day, with USD values. End-of-day snapshots are forward-filled, so every market has a row for every day after its first snapshot. Protocol coverage varies by chain.

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| 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. |