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.
Table Details
| Property | Value |
|---|---|
| Table Name | casper.dex.trades |
| Table Status | Production-Ready |
| Unique Key | transaction_hash, unique_id |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| project | VARCHAR(16777216) | Name of the DEX protocol’s project (e.g., Casperswap). |
| protocol | VARCHAR(16777216) | Specific protocol variant or version identifier. |
| liquidity_pool_address | VARCHAR(16777216) | Address of the liquidity pool contract where the trade occurred. |
| sender_address | VARCHAR(16777216) | Address that initiated the trade. |
| to_address | VARCHAR(16777216) | Address that received the bought tokens. |
| token_sold_address | VARCHAR(16777216) | Address of the token sold (input) in the trade. |
| token_sold_name | VARCHAR(16777216) | Human-readable name of the sold token. |
| token_sold_symbol | VARCHAR(16777216) | Ticker symbol of the sold token. |
| token_sold_decimals | NUMBER(38,0) | Decimals of the sold token. |
| token_sold_amount_raw_str | VARCHAR(16777216) | Raw amount of the sold token in its smallest unit as a string. |
| token_sold_amount_raw | FLOAT | Raw amount in the token’s smallest unit (no decimal adjustment). |
| token_sold_amount_str | VARCHAR(16777216) | Human-readable amount of the sold token adjusted for decimals as a string. |
| token_sold_amount | FLOAT | Human-readable amount adjusted for token decimals. |
| usd_sold_amount | FLOAT | USD value of the sold token amount at the time of the trade. |
| token_bought_address | VARCHAR(16777216) | Address of the token bought (output) in the trade. |
| token_bought_name | VARCHAR(16777216) | Human-readable name of the bought token. |
| token_bought_symbol | VARCHAR(16777216) | Ticker symbol of the bought token. |
| token_bought_decimals | NUMBER(38,0) | Decimals of the bought token. |
| token_bought_amount_raw_str | VARCHAR(16777216) | Raw amount of the bought token in its smallest unit as a string. |
| token_bought_amount_raw | FLOAT | Raw amount in the token’s smallest unit (no decimal adjustment). |
| token_bought_amount_str | VARCHAR(16777216) | Human-readable amount of the bought token adjusted for decimals as a string. |
| token_bought_amount | FLOAT | Human-readable amount adjusted for token decimals. |
| usd_bought_amount | FLOAT | USD value of the bought token amount at the time of the trade. |
| usd_amount | FLOAT | USD value of the trade, using the closest available price. |
| extra_fields | VARIANT | Protocol-specific additional fields not captured by standard columns. |
| swap_count | NUMBER(38,0) | Number of underlying swaps composing the trade (>1 for multi-hop routes). |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction this event belongs to. |
| log_index | NUMBER(38,0) | Index of the event within the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp of the block this event was included in. |
| block_number | NUMBER(38,0) | Height of the block this event was included in. |
| block_hash | VARCHAR(16777216) | Hash of the block this event was included in. |
| unique_id | VARCHAR(16777216) | Unique identifier for the row, used for deduplication. |