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

# Metrics Daily

### Table Details

| Property          | Value                            |
| ----------------- | -------------------------------- |
| Table Name        | `hyperevm.lending.metrics_daily` |
| Table Status      | Production-Ready                 |
| Unique Key        | `date`, `project`, `protocol`    |
| Clustering Key(s) | `date::date`                     |

### Table Columns

| Column Name               | Data Type         | Description                                                            |
| ------------------------- | ----------------- | ---------------------------------------------------------------------- |
| date                      | TIMESTAMP\_NTZ(9) | Date of the metrics snapshot                                           |
| project                   | VARCHAR(16777216) | Name of the lending project (e.g., aave, compound, morpho\_blue)       |
| protocol                  | VARCHAR(16777216) | Underlying protocol version (e.g., aave\_v1, compound\_v2)             |
| outstanding\_loans\_usd   | FLOAT             | Total value of outstanding loans in USD                                |
| available\_liquidity\_usd | FLOAT             | Total available liquidity in USD                                       |
| supplied\_amount\_usd     | FLOAT             | Total supplied amount in USD (outstanding loans + available liquidity) |
| usd\_balance              | FLOAT             | USD balance of the protocol                                            |
| unique\_id                | VARCHAR(16777216) | Unique identifier for the record (date + project + protocol)           |
| \_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 Metrics Daily](/historical-data/supported-blockchains/evm/core-schemas/lending/metrics-daily)