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

# Trades Enriched

### Table Details

| Property | Value |
| - | - |
| Table Name | `ethereum.dex.trades_enriched` |
| Table Status | Production-Ready |
| Unique Key | `transaction_hash`, `unique_id` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| project | VARCHAR(16777216) | The project (decentralized exchange) of the liquidity pool that the swap occurred from. |
| protocol | VARCHAR(16777216) | DEX protocol (& version, if applicable) of the contract address facilitating the swap. |
| liquidity\_pool\_address | VARCHAR(42) | Contract address of the liquidity pool holding the asset. For protocol without the concept of LP such as airswap, this will be null. |
| sender\_address | VARCHAR(42) | The address of the sender emitted on the swap event logs. This can be a router or pool address. |
| to\_address | VARCHAR(42) | Address of the recipient emitted on the swap event logs. For example, recipient\_address from the uniswap v3 swap event log. |
| token\_sold\_address | VARCHAR(42) | Token address of the token sold. |
| token\_sold\_name | VARCHAR(16777216) | Name of the token sold. |
| token\_sold\_symbol | VARCHAR(16777216) | Symbol of the token sold. |
| token\_sold\_decimals | NUMBER(38,0) | Token decimals of the token sold. |
| token\_sold\_amount\_raw\_str | VARCHAR(16777216) | Raw amount of tokens sold (unnormalized) in string. |
| token\_sold\_amount\_raw | FLOAT | Raw amount of tokens sold (unnormalized). |
| token\_sold\_amount\_str | VARCHAR(16777216) | Amount of tokens sold in string. |
| token\_sold\_amount | FLOAT | Amount of tokens sold. |
| usd\_sold\_amount | FLOAT | Amount of token sold in USD value. |
| token\_bought\_address | VARCHAR(42) | Token address of the token bought, i.e. the asset acquired from the trade. |
| token\_bought\_name | VARCHAR(16777216) | Name of the token bought. |
| token\_bought\_symbol | VARCHAR(16777216) | Symbol of the token bought. |
| token\_bought\_decimals | NUMBER(38,0) | Token decimals of the token bought. |
| token\_bought\_amount\_raw\_str | VARCHAR(16777216) | Raw amount of tokens bought (unnormalized) in string. |
| token\_bought\_amount\_raw | FLOAT | Raw amount of tokens bought (unnormalized). |
| token\_bought\_amount\_str | VARCHAR(16777216) | Amount of tokens bought in string. |
| token\_bought\_amount | FLOAT | Amount of tokens bought. |
| usd\_bought\_amount | FLOAT | Amount of token bought in USD value. |
| usd\_amount | FLOAT | USD value of the swap. This field preferentially selects the USD value of ETH and Stablecoin (USDT/USDC) tokens, as spam token prices may conflate the true swap value. |
| usd\_amount\_adjusted | FLOAT | `usd_amount`, or null when `is_flagged` is true, so `sum(usd_amount_adjusted)` gives adjusted volume. `usd_amount` is left as is; `sum(usd_amount) - sum(usd_amount_adjusted)` is the flagged amount. |
| is\_flagged | BOOLEAN | True if the trade is in `dex.trades_flagged` (see `flagged_details`). Filter `where not is_flagged` to exclude flagged trades such as round-trip wash. |
| flagged\_details | VARIANT | Why the trade is flagged, as one object. `reason`: the highest-priority match. `source`: what matched it, a registry key (`transaction_hash`, `transaction_from_address`, `transaction_to_address`) or `heuristic`. `flagged_at`: the registry entry's date, or the date a heuristic first flagged the trade; it is not the date the change reached production. `reasons`: every match, in priority order. Each reason key holds a list of its matches, each with its own `flagged_at`. `supply_shock_v1` / `self_issued_v1` = the trade touches a flagged token: `token_address`, `token_flagged_at`, `flagged_value` (units over pre-shock supply, or the creator's share of legs). `same_pool_roundtrip_v1` = the transaction trades one pool both ways and its flow cancels out: `pool_key`, `score` (1 = perfect round trip), `has_liquidity_event`. `roundtrip_wash` (registry): `source`, `value`. Examples: `flagged_details:reason::varchar`; one rule: `array_contains('same_pool_roundtrip_v1'::variant, flagged_details:reasons)`. |
| extra\_fields | VARIANT | This field contains all the extra columns emitted from the event/function call that were not part of the convetional DEX trades columns. |
| swap\_count | NUMBER(38,0) | Swap count within the transaction. |
| transaction\_fees | VARCHAR(16777216) | Fees paid at the transaction level. Varchar to retain precision. |
| transaction\_fees\_usd | FLOAT | Fees paid in USD. |
| fee\_details | VARIANT | Additional fee details of the transaction, including max priority fee, gas price and gas used for the transaction. |
| transaction\_from\_address | VARCHAR(42) | Transaction sender address. I.e. the address of the transaction initiator. (from\_address in the raw\.transactions field for the transaction\_hash of this swap). |
| transaction\_to\_address | VARCHAR(42) | Transaction receiver. (to\_address in the raw\.transactions field for the transaction\_hash of this swap). |
| transaction\_hash | VARCHAR(66) | Transaction hash that this swap belongs to. |
| transaction\_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| selector | VARCHAR(16777216) | 4byte selector of the transaction. |
| log\_index | NUMBER(38,0) | The position of the swap event log in the transaction. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | Block timestamp of the swap event. |
| block\_number | NUMBER(38,0) | Block number of the swap event. |
| block\_hash | VARCHAR(66) | Block hash of the swap event. |
| unique\_id | VARCHAR(16777216) | Unique ID of each trade. |
| \_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. |
| \_changed\_since\_full\_refresh | BOOLEAN | Indicates if the record has changed since the last full data refresh. |

### Related Docs

* [EVM DEX Trades Enriched](/historical-data/supported-blockchains/evm/core-schemas/dex/trades-enriched.md)