| project | VARCHAR(16777216) | Name of the lending project |
| protocol | VARCHAR(16777216) | Underlying protocol that the lending protocol is utilising |
| lending_event | VARCHAR(16777216) | Type of lending event (always ‘liquidations’ for this table) |
| event_name | VARCHAR(16777216) | Name of the event |
| market_address | VARCHAR(16777216) | Address of the lending market where the liquidation occurred |
| borrower_address | VARCHAR(16777216) | Address of the borrower being liquidated |
| liquidator_address | VARCHAR(16777216) | Address of the liquidator performing the liquidation |
| token_address | VARCHAR(16777216) | Address of the collateral token being liquidated |
| token_name | VARCHAR(16777216) | Name of the collateral token being liquidated |
| token_symbol | VARCHAR(16777216) | Symbol of the collateral token being liquidated |
| token_decimals | NUMBER(38,0) | Number of decimals of the collateral token |
| raw_amount_str | VARCHAR(16777216) | Raw amount of collateral liquidated, in string to retain precision |
| amount_str | VARCHAR(16777216) | Normalised amount of collateral liquidated, in string to retain precision |
| amount | FLOAT | Normalised amount of collateral liquidated |
| usd_amount | FLOAT | USD value of the collateral liquidated at the time of the transaction |
| usd_exchange_rate | FLOAT | Hourly USD exchange rate of the collateral token |
| repay_token_address | VARCHAR(16777216) | Address of the token used to repay the debt. This is null for Compound V3 events |
| repay_token_name | VARCHAR(16777216) | Name of the token used to repay the debt. This is null for Compound V3 events |
| repay_token_symbol | VARCHAR(16777216) | Symbol of the token used to repay the debt. This is null for Compound V3 events |
| repay_token_decimals | NUMBER(38,0) | Number of decimals of the repayment token. This is null for Compound V3 events |
| repay_raw_amount_str | VARCHAR(16777216) | Raw amount of debt repaid, in string to retain precision. This is null for Compound V3 events |
| repay_amount_str | VARCHAR(16777216) | Normalised amount of debt repaid, in string to retain precision. This is null for Compound V3 events |
| repay_amount | FLOAT | Normalised amount of debt repaid. This is null for Compound V3 events |
| repay_usd_amount | FLOAT | USD value of the debt repaid at the time of the transaction. This is null for Compound V3 events |
| extra_fields | VARIANT | Additional protocol-specific fields from the event |
| transaction_hash | VARCHAR(16777216) | Transaction hash of the liquidation event |
| transaction_index | NUMBER(38,0) | Index of the transaction in the block |
| transaction_from_address | VARCHAR(16777216) | Address of the sender of the liquidation transaction |
| transaction_to_address | VARCHAR(16777216) | Address of the recipient of the liquidation transaction |
| log_index | NUMBER(38,0) | Index of the log in the transaction |
| topic0 | VARCHAR(16777216) | Topic 0 of the event |
| block_number | NUMBER(38,0) | Block number of the liquidation event |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block |
| block_hash | VARCHAR(16777216) | Hash of the block |
| unique_id | VARCHAR(16777216) | Unique ID of the liquidation event |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the event was created |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the event was last updated |
