| 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 |
| id_type | VARCHAR(16777216) | Type of the market identifier in id (e.g. market, reserve, pool). |
| id_params | VARIANT | Parameters that compose the market id, as a JSON object. |
| 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 |
| 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 | JSON object of additional protocol-specific fields for the market that are not part of the standard schema. |
| 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 |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| is_listed | BOOLEAN | Whether the market was listed and active on this date |
| is_excluded | BOOLEAN | True for bad-debt or wash markets. Their supplied, borrowed and liquidity values are zeroed, but the row is retained so market coverage stays intact. |
| exclusion_category | VARCHAR(16777216) | Why the market is excluded (e.g. bad_debt, wash). Null when not excluded. |
| exclusion_reason | VARCHAR(16777216) | Free-text reason for the exclusion. Null when not excluded. |
| _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 |