| activity_date | TIMESTAMP_NTZ(9) | Calendar date (UTC) this daily record aggregates. |
| project | VARCHAR(16777216) | Project or application associated with this record. |
| project_name | VARCHAR(16777216) | Human-readable name of the project. |
| protocol | VARCHAR(16777216) | Protocol (and version, if applicable) associated with this record. |
| vertical | VARCHAR(16777216) | Vertical classification of the protocol (e.g. lending). |
| token_price_usd | FLOAT | USD price of the protocol’s token on this date, when applicable. |
| market_cap_usd | FLOAT | USD market capitalization of the protocol’s token on this date, when applicable. |
| total_volume_usd | FLOAT | Total USD volume across all lending actions for the day. |
| avg_usd_amount | FLOAT | Average USD value per lending transaction for the day. |
| active_users | NUMBER(38,0) | Distinct addresses that performed any lending action on this date. |
| total_transactions | NUMBER(38,0) | Total number of lending transactions on this date. |
| tvl_usd | FLOAT | Total value locked in the protocol in USD on this date. |
| deposit_volume_usd | FLOAT | USD volume of deposits on this date. |
| deposit_avg_usd | FLOAT | Average USD value per deposit on this date. |
| depositor_count | NUMBER(38,0) | Distinct addresses that made a deposit on this date. |
| deposit_tx_count | NUMBER(38,0) | Number of deposit transactions on this date. |
| withdrawal_volume_usd | FLOAT | USD volume of withdrawals on this date. |
| withdrawal_avg_usd | FLOAT | Average USD value per withdrawal on this date. |
| withdrawer_count | NUMBER(38,0) | Distinct addresses that made a withdrawal on this date. |
| withdrawal_tx_count | NUMBER(38,0) | Number of withdrawal transactions on this date. |
| loan_volume_usd | FLOAT | USD volume of new loans (borrows) on this date. |
| loan_avg_usd | FLOAT | Average USD value per loan on this date. |
| borrower_count | NUMBER(38,0) | Distinct addresses that took out a loan on this date. |
| loan_tx_count | NUMBER(38,0) | Number of borrow transactions on this date. |
| repayment_volume_usd | FLOAT | USD volume of loan repayments on this date. |
| repayment_avg_usd | FLOAT | Average USD value per repayment on this date. |
| borrower_repaying_count | NUMBER(38,0) | Distinct borrower addresses that made a repayment on this date. |
| repayment_tx_count | NUMBER(38,0) | Number of repayment transactions on this date. |
| liquidation_volume_usd | FLOAT | USD volume of liquidations on this date. |
| liquidation_avg_usd | FLOAT | Average USD value per liquidation on this date. |
| borrower_liquidated_count | NUMBER(38,0) | Distinct borrower addresses that were liquidated on this date. |
| liquidation_tx_count | NUMBER(38,0) | Number of liquidation transactions on this date. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
