> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Position Holdings Daily

> Daily per-user holdings in Solana lending vault products.

The `solana.lending.position_holdings_daily` table contains daily per-user (per-address) holdings in Solana lending vault products, currently covering Kamino's kvault (managed vault) product.

Each row represents one user's proportional share of a vault's underlying reserve balances on a given day, along with metadata about the receipt tokens backing that position.

### Table Details

| Property            | Value                                    |
| ------------------- | ---------------------------------------- |
| Table Name          | `solana.lending.position_holdings_daily` |
| Table Status        | Production-Ready                         |
| Unique Key          | `date`, `lending_id`, `address`, `mint`  |
| Clustering Key(s)   | `date, project`                          |
| Search Optimization | `lending_id`, `address`, `mint`          |

### Table Columns

| Column Name                           | Data Type         | Description                                                                                                                                                                                    |
| ------------------------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| date                                  | TIMESTAMP\_NTZ(9) | Calendar date (UTC) this record represents.                                                                                                                                                    |
| project                               | VARCHAR(16777216) | Business name of the protocol being used (e.g. `kamino`).                                                                                                                                      |
| protocol                              | VARCHAR(16777216) | Specific version or variant of the protocol (e.g. `kvault`).                                                                                                                                   |
| lending\_id                           | VARCHAR(16777216) | Internal Allium identifier for the vault this position belongs to.                                                                                                                             |
| address                               | VARCHAR(16777216) | Wallet address of the vault depositor holding this position.                                                                                                                                   |
| mint                                  | VARCHAR(16777216) | Base58-encoded mint address of the underlying token this position is denominated in.                                                                                                           |
| raw\_balance\_str                     | VARCHAR(16777216) | Position balance in the smallest unit, as a string, to retain precision.                                                                                                                       |
| raw\_balance                          | FLOAT             | Position balance in the token's smallest unit (not decimal-adjusted).                                                                                                                          |
| balance                               | FLOAT             | Position balance normalized by the token's decimal precision.                                                                                                                                  |
| balance\_str                          | VARCHAR(16777216) | Normalized position balance, as a string, to retain precision.                                                                                                                                 |
| usd\_balance                          | FLOAT             | USD value of the position balance at the time of the snapshot.                                                                                                                                 |
| usd\_exchange\_rate                   | FLOAT             | USD price per unit of the underlying token at the time of the snapshot.                                                                                                                        |
| token\_name                           | VARCHAR(16777216) | Full name of the underlying token.                                                                                                                                                             |
| symbol                                | VARCHAR(16777216) | Ticker symbol of the underlying token.                                                                                                                                                         |
| decimals                              | NUMBER(38,0)      | Number of decimal places used to represent the underlying token's smallest unit.                                                                                                               |
| \_extras                              | VARIANT           | JSON object containing additional protocol-specific metadata, including the receipt (c-token) accounts backing this position (mint, symbol, decimals, and raw/normalized amounts per reserve). |
| last\_activity\_block\_timestamp      | TIMESTAMP\_NTZ(9) | Timestamp of the block that last changed this balance.                                                                                                                                         |
| last\_activity\_block\_slot           | NUMBER(38,0)      | Solana slot number of the block containing the most recent activity for this position.                                                                                                         |
| last\_activity\_block\_hash           | VARCHAR(16777216) | Hash of the block that last changed this balance.                                                                                                                                              |
| last\_activity\_txn\_index            | NUMBER(38,0)      | Index of the transaction within its block for the most recent balance-changing activity.                                                                                                       |
| last\_activity\_txn\_id               | VARCHAR(16777216) | Transaction ID (signature) of the most recent activity that changed this balance.                                                                                                              |
| last\_activity\_pseudo\_global\_order | NUMBER(38,0)      | Pseudo-global ordering key of the most recent activity, used to sort events across all transactions.                                                                                           |
| unique\_id                            | VARCHAR(16777216) | Allium's deterministic unique identifier for this row.                                                                                                                                         |
| \_created\_at                         | TIMESTAMP\_NTZ(9) | Timestamp (UTC) when this row was first written to the Allium platform.                                                                                                                        |
| \_updated\_at                         | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the most recent update to this row.                                                                                                                                         |

***

### Sample Query

<Tabs>
  <Tab title="A User's Positions">
    Get the latest holdings for a specific depositor across all Kamino vaults:

    ```sql theme={null}
    select date, lending_id, symbol, balance, usd_balance
    from solana.lending.position_holdings_daily
    where address = 'AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA' -- depositor wallet
    order by date desc
    ```
  </Tab>

  <Tab title="Top Holders of a Vault">
    Find the largest positions in a specific vault on a given date:

    ```sql theme={null}
    select date, address, symbol, balance, usd_balance
    from solana.lending.position_holdings_daily
    where lending_id = 'BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB' -- vault lending_id
      and date = '2026-08-01'
    order by usd_balance desc
    limit 20
    ```
  </Tab>
</Tabs>