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 |