Table Details
| Property | Value |
|---|---|
| Table Name | celo.lending.markets_daily |
| Table Status | Production-Ready |
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 |
| _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 |