| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| transaction_index | NUMBER(38,0) | Zero-based position of the transaction within its block. The first transaction in a block has index 0. |
| swapper_address | VARCHAR(42) | Address of the account that initiated the swap (end user). |
| from_address | VARCHAR(42) | Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender). |
| to_address | VARCHAR(42) | Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract). |
| is_aggregator | BOOLEAN | Boolean indicating if the trade was executed through a DEX aggregator. |
| usd_volume | FLOAT | USD value of the individual trade. |
| total_usd_volume | FLOAT | Total USD value of all trades in the transaction. |
| senders | VARIANT | Array of addresses that sent tokens in the trade. |
| recipients | VARIANT | Array of addresses that received tokens in the trade. |
| user_token_input | VARCHAR(42) | Address of the token the user sent in the trade. |
| user_token_input_symbol | VARCHAR(16777216) | Symbol of the token the user sent. |
| user_token_output | VARCHAR(42) | Address of the token the user received in the trade. |
| user_token_output_symbol | VARCHAR(16777216) | Symbol of the token the user received. |
| tokens_sold | VARIANT | Array of token addresses that were sold in the trade. |
| tokens_bought | VARIANT | Array of token addresses that were bought in the trade. |
| integrators | VARIANT | Array of integrator addresses used in the trade. |
| integrator_tags | VARIANT | Array of tags associated with the integrators. |
| aggregator_source | VARIANT | Source of the aggregation if the trade was executed through an aggregator. |
| aggregator_usd_volume | FLOAT | USD volume of the trade portion executed through aggregators. |
| aggregators | VARIANT | Array of aggregator addresses used in the trade. |
| aggregators_count | NUMBER(38,0) | Number of different aggregators used in the trade. |
| aggregator_details | VARIANT | Detailed information about the aggregator portion of the trade. |
| liquidity_source | VARIANT | Array of DEX protocols that provided liquidity for the trade. |
| liquidity_usd_volume | FLOAT | USD volume of the trade portion executed through DEX liquidity pools. |
| liquidity_pools | VARIANT | Array of liquidity pool addresses used in the trade. |
| liquidity_pools_count | NUMBER(38,0) | Number of different liquidity pools used in the trade. |
| liquidity_details | VARIANT | Detailed information about the liquidity sources used, including protocol, pair, and amounts. |
| total_trades | NUMBER(38,0) | Total number of individual trades executed in this transaction. |
| unique_id | VARCHAR(16777216) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). 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. |
