| date | TIMESTAMP_NTZ(9) | Date of the metrics snapshot |
| project | VARCHAR(16777216) | Name of the lending project (e.g., aave, compound, morpho_blue) |
| protocol | VARCHAR(16777216) | Underlying protocol version (e.g., aave_v1, compound_v2) |
| outstanding_loans_usd | FLOAT | Total value of outstanding loans in USD |
| available_liquidity_usd | FLOAT | Total available liquidity in USD |
| supplied_amount_usd | FLOAT | Total supplied amount in USD (outstanding loans + available liquidity) |
| usd_balance | FLOAT | USD balance of the protocol |
| has_market_state | BOOLEAN | True when outstanding loans and supplied amounts are read from protocol market state. When false, those balance-sheet columns are null and only event-derived flow metrics are available. |
| net_deposit_flow_usd | FLOAT | Net USD value of liquidity supplied over the day: gross deposits minus gross withdrawals. Null when neither deposits nor withdrawals are covered. |
| net_borrow_flow_usd | FLOAT | Net USD value of debt originated over the day: gross borrows minus gross repayments. Null when neither borrows nor repayments are covered. |
| total_volume_usd | FLOAT | Total USD volume of lending events (deposits, withdrawals, borrows, repayments, and liquidations) on this day. |
| avg_volume_usd | FLOAT | Average USD size of lending events on this day. |
| total_transactions | NUMBER(38,0) | Total number of lending transactions on this day. |
| active_users | NUMBER(38,0) | Number of unique addresses that deposited, withdrew, borrowed, repaid, or were liquidated on this day. |
| deposit_volume_usd | FLOAT | Total deposit volume in USD for the activity date |
| deposit_avg_usd | FLOAT | Average deposit size in USD |
| depositor_count | NUMBER(38,0) | Count of unique depositors |
| deposit_tx_count | NUMBER(38,0) | Total number of deposit transactions |
| withdrawal_volume_usd | FLOAT | Total withdrawal volume in USD for the activity date |
| withdrawal_avg_usd | FLOAT | Average withdrawal size in USD |
| withdrawer_count | NUMBER(38,0) | Count of unique withdrawers |
| withdrawal_tx_count | NUMBER(38,0) | Total number of withdrawal transactions |
| loan_volume_usd | FLOAT | Total loan volume in USD for the activity date |
| loan_avg_usd | FLOAT | Average loan size in USD |
| borrower_count | NUMBER(38,0) | Count of unique borrowers |
| loan_tx_count | NUMBER(38,0) | Total number of loan transactions |
| repayment_volume_usd | FLOAT | Total repayment volume in USD for the activity date |
| repayment_avg_usd | FLOAT | Average repayment size in USD |
| borrower_repaying_count | NUMBER(38,0) | Count of unique borrowers making repayments |
| repayment_tx_count | NUMBER(38,0) | Total number of repayment transactions |
| liquidation_volume_usd | FLOAT | Total liquidation volume in USD for the activity date |
| liquidation_avg_usd | FLOAT | Average liquidation size in USD |
| borrower_liquidated_count | NUMBER(38,0) | Count of unique borrowers who were liquidated |
| liquidation_tx_count | NUMBER(38,0) | Total number of liquidation transactions |
| unique_id | VARCHAR(16777216) | Unique identifier for the record (date + project + protocol) |
| _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 |
