> ## 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 | `mantle.lending.markets_daily` |
| Table Status | Production-Ready |
| Unique Key | `date`, `project`, `id` |
| Clustering Key(s) | `date, project` |
| Search Optimization | `id`, `contract_address`, `token_address` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| date | TIMESTAMP\_NTZ(9) | Date of the market snapshot |
| project | VARCHAR(16777216) | Name of the lending project (e.g., aave, compound, morpho\_blue) |
| protocol | VARCHAR(16777216) | Underlying protocol version (e.g., aave\_v2, compound\_v2, euler\_v2) |
| id | VARCHAR(16777216) | Unique identifier for the market |
| id\_type | VARCHAR(16777216) | Type of the market identifier in `id` (e.g. market, reserve, pool). |
| id\_params | VARIANT | Parameters that compose the market `id`, as a JSON object. |
| contract\_address | VARCHAR(16777216) | Address of the lending market contract |
| token\_address | VARCHAR(16777216) | Address of the token in the market |
| token\_name | VARCHAR(16777216) | Name of the token |
| token\_symbol | VARCHAR(16777216) | Symbol of the token |
| token\_decimals | NUMBER(38,0) | Number of decimals for the token |
| usd\_exchange\_rate | FLOAT | USD exchange rate of the token at the time of the snapshot |
| supplied\_amount | FLOAT | Total supplied amount in token units |
| supplied\_amount\_usd | FLOAT | Total supplied amount in USD |
| outstanding\_loans | FLOAT | Total outstanding loans in token units |
| outstanding\_loans\_usd | FLOAT | Total outstanding loans in USD |
| available\_liquidity | FLOAT | Available liquidity in token units |
| available\_liquidity\_usd | FLOAT | Available liquidity in USD |
| extra\_fields | VARIANT | JSON object of additional protocol-specific fields for the market that are not part of the standard schema. |
| transaction\_hash | VARCHAR(16777216) | Hash of the last transaction affecting this market |
| transaction\_index | NUMBER(38,0) | Index of the last transaction in the block |
| last\_activity\_block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp of the last activity block |
| last\_activity\_block\_number | NUMBER(38,0) | Block number of the last activity |
| last\_activity\_block\_hash | VARCHAR(16777216) | Hash of the last activity block |
| unique\_id | VARCHAR(16777216) | Allium's deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| is\_listed | BOOLEAN | Whether the market was listed and active on this date |
| is\_excluded | BOOLEAN | True for bad-debt or wash markets. Their supplied, borrowed and liquidity values are zeroed, but the row is retained so market coverage stays intact. |
| exclusion\_category | VARCHAR(16777216) | Why the market is excluded (e.g. bad\_debt, wash). Null when not excluded. |
| exclusion\_reason | VARCHAR(16777216) | Free-text reason for the exclusion. Null when not excluded. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the record was created |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of when the record was last updated |

### Related Docs

* [EVM Lending Markets Daily](https://docs.allium.so/historical-data/supported-blockchains/evm/core-schemas/lending/markets-daily.md)
