| token_type | VARCHAR(16777216) | Type of the token (e.g., ERC20, native). |
| address | VARCHAR(16777216) | The wallet or contract address holding the token. |
| token_address | VARCHAR(16777216) | The contract address of the token. |
| token_name | VARCHAR(16777216) | Name of the token. |
| token_symbol | VARCHAR(16777216) | Symbol of the token. |
| prev_balance | FLOAT | The token balance before this transaction, normalized by token decimals. |
| balance | FLOAT | The token balance after this transaction, normalized by token decimals. |
| balance_change | FLOAT | The change in token balance from this transaction. |
| usd_exchange_rate | FLOAT | The USD exchange rate of the token at the time of the transaction. |
| usd_balance | FLOAT | The USD value of the token balance at the time of the transaction. |
| usd_balance_change | FLOAT | The change in USD value of the token balance from this transaction. |
| usd_exchange_rate_latest | FLOAT | The latest available USD exchange rate of the token. |
| usd_balance_latest | FLOAT | The USD value of the token balance using the latest exchange rate. |
| transaction_type | VARCHAR(16777216) | The type of transaction (e.g., buy, sell, transfer). |
| tokens_purchased | FLOAT | The amount of tokens purchased in this transaction. |
| tokens_sold | FLOAT | The amount of tokens sold in this transaction. |
| average_cost | FLOAT | The volume-weighted average cost basis per token. |
| cumulative_costs | FLOAT | The cumulative USD cost of all token acquisitions and disposals. |
| cumulative_quantities | FLOAT | The cumulative quantity of tokens acquired and disposed. |
| cumulative_cost_from_purchases | FLOAT | The cumulative USD cost from purchase transactions only. |
| cumulative_quantity_from_purchases | FLOAT | The cumulative quantity of tokens from purchase transactions only. |
| realized_pnl | FLOAT | The cumulative realized profit and loss in USD. |
| realized_pnl_this_block | FLOAT | The realized profit and loss in USD from this block only. |
| unrealized_pnl | FLOAT | The unrealized profit and loss in USD based on the exchange rate at transaction time. |
| unrealized_pnl_latest | FLOAT | The unrealized profit and loss in USD based on the latest exchange rate. |
| group_vwap | FLOAT | The 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) | The timestamp of the block containing this transaction. |
| block_number | NUMBER(38,0) | The block number containing this transaction. |
| unique_id | VARCHAR(16777216) | Unique identifier for each PnL record. |
| _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. |
