| date | Calendar date (UTC) this record represents. Used in daily aggregate tables. |
| project | Business name of the protocol being used (e.g. uniswap, aave, lido, paraswap). Consistent across verticals — every table with a project column uses this field to identify the top-level protocol brand. |
| protocol | Specific version or variant of the protocol (e.g. uniswap_v3, aave_v2, stargate_v2). Qualifies the project field with version information. |
| outstanding_loans_usd | Total USD value of loans currently outstanding (borrowed but not yet repaid) in this lending market. |
| available_liquidity_usd | Total USD value of assets available to borrow from this lending market (supplied amount minus outstanding loans). |
| supplied_amount_usd | Total USD value of assets currently supplied to this lending market as collateral or liquidity. |
| usd_balance | USD value of the token balance, computed using the exchange rate at the time of the balance snapshot. |
| has_market_state | True when this project/protocol/day has markets_daily coverage. |
| net_deposit_flow_usd | deposit_volume_usd minus withdrawal_volume_usd for the day. |
| net_borrow_flow_usd | loan_volume_usd minus repayment_volume_usd for the day. |
| total_volume_usd | Distinct-counted gross volume across deposits/withdrawals/loans/repayments/liquidations. |
| avg_volume_usd | Average USD volume per transaction across all lending event types for the day. |
| total_transactions | Distinct transaction_hash count across all lending event types. |
| active_users | Distinct actor address count across all lending event types. |
| deposit_volume_usd | Total USD value deposited into this lending market over the day. |
| deposit_avg_usd | Average USD value per deposit over the day. |
| depositor_count | Distinct addresses that made a deposit over the day. |
| deposit_tx_count | Distinct transactions containing a deposit over the day. |
| withdrawal_volume_usd | Total USD value withdrawn from this lending market over the day. |
| withdrawal_avg_usd | Average USD value per withdrawal over the day. |
| withdrawer_count | Distinct addresses that made a withdrawal over the day. |
| withdrawal_tx_count | Distinct transactions containing a withdrawal over the day. |
| loan_volume_usd | Total USD value borrowed from this lending market over the day. |
| loan_avg_usd | Average USD value per loan over the day. |
| borrower_count | Distinct addresses that took out a loan over the day. |
| loan_tx_count | Distinct transactions containing a loan over the day. |
| repayment_volume_usd | Total USD value of debt repaid to this lending market over the day. |
| repayment_avg_usd | Average USD value per repayment over the day. |
| borrower_repaying_count | Distinct addresses that repaid debt over the day. |
| repayment_tx_count | Distinct transactions containing a repayment over the day. |
| liquidation_volume_usd | Sum of repay_usd_amount (debt-repaid leg) across liquidations for the day. |
| liquidation_avg_usd | Average USD value of debt repaid per liquidation over the day. |
| borrower_liquidated_count | Distinct borrower addresses that were liquidated over the day. |
| liquidation_tx_count | Distinct transactions containing a liquidation over the day. |
| unique_id | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| _created_at | Timestamp (UTC) when this row was first written to the Allium platform. Set once on insert and never changed. |
| _updated_at | Timestamp (UTC) of the most recent update to this row in the Allium platform. Advances when the row is reprocessed or enriched (e.g. USD price hydration). |
