> ## 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

### Table Details

| Property | Value |
| - | - |
| Table Name | `aptos.lending.markets_daily` |
| Table Status | Production-Ready |
| Unique Key | `date`, `project`, `id` |
| Clustering Key(s) | `date, project` |

### 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). |
| 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). |
| 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. |

### Related Docs

* [MOVE Lending Markets Daily](/historical-data/supported-blockchains/move-ecosystem/core-schemas/lending/markets-daily)