Table Columns
| Column | Data Type | Description |
|---|---|---|
| date | DATE | Date of the market snapshot |
| project | VARCHAR | Name of the lending project |
| protocol | VARCHAR | Underlying protocol version |
| id | VARCHAR | Unique identifier for the market |
| market_address | VARCHAR | Address of the lending market |
| contract_address | VARCHAR | Address of the lending market contract |
| token_address | VARCHAR | Address of the token in the market |
| token_symbol | VARCHAR | Symbol of the token |
| token_decimals | INTEGER | 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 |
| extra_fields | VARIANT | Protocol-specific fields not promoted to first-class columns |
| transaction_hash | VARCHAR | Hash of the last transaction affecting this market |
| ledger_sequence | INTEGER | 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 | Hash of the Stellar ledger of the last activity |
| unique_id | VARCHAR | Unique identifier for the row |