> ## 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 | `tempo.lending.markets_daily` |
| Table Status | Production-Ready |
| Unique Key | `date`, `project`, `id` |

### 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 |
| 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 |
| 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 |
| supplied\_amount | FLOAT | Total supplied amount in token units |
| supplied\_amount\_usd | FLOAT | Total supplied amount in USD |
| 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 |
| is\_listed | BOOLEAN | Whether the market was listed and active on this date |
| \_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](/historical-data/supported-blockchains/evm/core-schemas/lending/markets-daily)