Table Details
| Property | Value |
|---|---|
| Table Name | stellar.lending.markets_daily |
| Table Status | Production-Ready |
| Unique Key | date, id |
| Clustering Key(s) | date, project |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| date | TIMESTAMP_NTZ(9) | Date of the market snapshot |
| project | VARCHAR(16777216) | Name of the lending project |
| protocol | VARCHAR(16777216) | Underlying protocol version |
| id | VARCHAR(16777216) | Unique identifier for the market |
| market_address | VARCHAR(16777216) | Address of the lending market |
| contract_address | VARCHAR(16777216) | Address of the lending market contract |
| token_address | VARCHAR(16777216) | Address of the token in the market |
| 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 | Protocol-specific fields not promoted to first-class columns |
| transaction_hash | VARCHAR(16777216) | Hash of the last transaction affecting this market |
| ledger_sequence | NUMBER(38,0) | Stellar ledger sequence of the last activity |
| ledger_close_time | TIMESTAMP_NTZ(9) | Close time of the Stellar ledger of the last activity |
| ledger_hash | VARCHAR(16777216) | Hash of the Stellar ledger of the last activity |
| unique_id | VARCHAR(16777216) | Unique identifier for the row |
| _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. |