> ## 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.

# Fungible Pnl

### Table Details

| Property | Value |
| - | - |
| Table Name | `hyperevm.assets.fungible_pnl` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `unique_id` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| token\_type | VARCHAR(16777216) | Token standard or category (e.g. erc20, native). |
| address | VARCHAR(16777216) | Wallet or contract address holding the token. |
| token\_address | VARCHAR(16777216) | Contract address of the token. On EVM chains native currency is represented as the zero address. |
| token\_name | VARCHAR(16777216) | Human-readable name of the token. |
| token\_symbol | VARCHAR(16777216) | Ticker symbol of the token. |
| prev\_balance | FLOAT | Token balance held by the address immediately before this transaction, normalized by token decimals. |
| balance | FLOAT | Token balance held by the address after this transaction, normalized by token decimals. |
| balance\_change | FLOAT | Change in token balance produced by this transaction. |
| usd\_exchange\_rate | FLOAT | USD price of one unit of the token at the record's timestamp. |
| usd\_balance | FLOAT | USD value of the balance at the record's timestamp. |
| usd\_balance\_change | FLOAT | Change in USD value of the address's balance produced by this transaction. |
| usd\_exchange\_rate\_latest | FLOAT | Latest available USD price of one unit of the token. |
| usd\_balance\_latest | FLOAT | USD value of the address's balance valued at the latest available price. |
| transaction\_type | VARCHAR(16777216) | Type or category of the transaction that produced this record (e.g. buy, sell, transfer). |
| tokens\_purchased | FLOAT | Quantity of tokens purchased in this transaction. |
| tokens\_sold | FLOAT | Quantity of tokens sold in this transaction. |
| average\_cost | FLOAT | Average USD cost basis per token unit held by the address, updated as positions change. |
| cumulative\_costs | FLOAT | Running total USD cost of tokens acquired by the address. |
| cumulative\_quantities | FLOAT | Running total quantity of tokens acquired by the address. |
| cumulative\_cost\_from\_purchases | FLOAT | Running total USD cost from purchase transactions only. |
| cumulative\_quantity\_from\_purchases | FLOAT | Running total quantity of tokens from purchase transactions only. |
| realized\_pnl | FLOAT | Cumulative realized profit and loss (USD) from tokens the address has sold. |
| realized\_pnl\_this\_block | FLOAT | Realized profit and loss (USD) attributable to this block. |
| unrealized\_pnl | FLOAT | Unrealized profit and loss (USD) on the address's remaining holdings at this record's time. |
| unrealized\_pnl\_latest | FLOAT | Unrealized profit and loss (USD) on the address's holdings valued at the latest available price. |
| group\_vwap | FLOAT | Volume-weighted average price for the current position group. |
| group\_id | NUMBER(38,0) | Identifier for the position group, incremented when a position is fully closed and reopened. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block\_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis) and increments by 1 per block. |
| unique\_id | VARCHAR(16777216) | Allium's deterministic unique identifier for this row, generated from the fields that uniquely identify the record. Stable across full refreshes. |
| \_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. |

### Related Docs

* [EVM Assets Fungible Pnl](/historical-data/supported-blockchains/evm/core-schemas/assets/fungible-pnl)