| chain | VARCHAR(8) | The kadena chain name |
| chain_id | VARCHAR(16777216) | The unique identifier for the kadena chain |
| 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. |
| from_account | VARCHAR(16777216) | The account that initiated the swap |
| to_account | VARCHAR(16777216) | The recipient account of the swap |
| token_sold_address | VARCHAR(16777216) | 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 | VARCHAR(16777216) | Amount of tokens sold in string. |
| usd_sold_amount | FLOAT | Amount of token sold in USD value. |
| token_bought_address | VARCHAR(16777216) | 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 | VARCHAR(16777216) | Amount of tokens bought in string. |
| 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. |
| status | VARCHAR(16777216) | The status of the transaction |
| transaction_request_key | VARCHAR(16777216) | Unique identifier for the transaction request |
| transaction_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| event_index | NUMBER(38,0) | The index of the event within the transaction |
| block_creation_time | TIMESTAMP_NTZ(9) | Timestamp of the block creation |
| block_height | NUMBER(38,0) | Block height of the swap event. |
| block_hash | VARCHAR(16777216) | Block hash of the swap event. |
| unique_id | VARCHAR(16777216) | Unique ID of each trade. |
| _created_at | TIMESTAMP_NTZ(9) | The timestamp when the record was created |
| _updated_at | TIMESTAMP_NTZ(9) | The timestamp when the record was last updated |
| _changed_since_full_refresh | BOOLEAN | Indicates if the record has changed since full refresh |
