> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# zerion_v1_avalanche

> Tables in tt-contracts.zerion_v1_avalanche

## Tables

### Router\_Executed\_event

Token swap execution event emitted by the Zerion Router contract. Records swap parameters including input/output tokens, amounts exchanged, protocol and marketplace fees charged, and swap routing details via callerCallData.

<Accordion title="Columns">
  | Column                    | Type                                                                                                                                                                                          | Description                                                                                                                                                                                                                                                                        |
  | ------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | `block_timestamp`         | `TIMESTAMP`                                                                                                                                                                                   | Timestamp when the block was produced. UTC timezone, millisecond precision.                                                                                                                                                                                                        |
  | `block_number`            | `INT64`                                                                                                                                                                                       | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block's position in the blockchain.                                                                                                                               |
  | `transaction_hash`        | `STRING`                                                                                                                                                                                      | Unique identifier for the transaction. 66-character hex string including 0x prefix.                                                                                                                                                                                                |
  | `log_index`               | `INT64`                                                                                                                                                                                       | Position of the event within the block's transaction logs. Zero-indexed integer representing the sequential order of log emission.                                                                                                                                                 |
  | `address`                 | `STRING`                                                                                                                                                                                      | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                                            |
  | `removed`                 | `BOOL`                                                                                                                                                                                        | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.                                                                                                                                                                       |
  | `in_inputToken`           | `STRING`                                                                                                                                                                                      | Contract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                       |
  | `in_absoluteInputAmount`  | `STRING`                                                                                                                                                                                      | Amount of input tokens specified for the swap operation. String-encoded integer representing the quantity in the smallest denomination of the input token.                                                                                                                         |
  | `in_inputBalanceChange`   | `STRING`                                                                                                                                                                                      | Actual change in the sender's input token balance for the swap operation. String-encoded integer representing the quantity in the smallest denomination of the input token.                                                                                                        |
  | `in_outputToken`          | `STRING`                                                                                                                                                                                      | Contract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                              |
  | `in_absoluteOutputAmount` | `STRING`                                                                                                                                                                                      | Amount of output tokens expected from the swap operation before fees are deducted. String-encoded integer representing the quantity in the smallest denomination of the output token.                                                                                              |
  | `in_returnedAmount`       | `STRING`                                                                                                                                                                                      | Amount of tokens returned to the user after completing the swap or settlement operation. String-encoded integer representing the quantity in the smallest denomination of the output token.                                                                                        |
  | `in_protocolFeeAmount`    | `STRING`                                                                                                                                                                                      | Amount of fees collected by the protocol from the transaction. String-encoded integer representing the fee in the smallest denomination of the token.                                                                                                                              |
  | `in_marketplaceFeeAmount` | `STRING`                                                                                                                                                                                      | Amount of fees collected by a marketplace partner or third-party integrator from the swap transaction. String-encoded integer representing the fee in the smallest denomination of the token.                                                                                      |
  | `in_swapDescription`      | `STRUCT<swapType INT64, protocolFee STRUCT<share STRING, beneficiary STRING>, marketplaceFee STRUCT<share STRING, beneficiary STRING>, account STRING, caller STRING, callerCallData STRING>` | Structured data describing the swap operation parameters and fee configuration. Contains swap type identifier, protocol and marketplace fee structures with beneficiary addresses, user account address, caller contract address, and hex-encoded calldata for the swap execution. |
  | `in_sender`               | `STRING`                                                                                                                                                                                      | Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                                                                                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_inputToken                             | in\_outputToken                            | block\_timestamp         | transaction\_hash                                                  | in\_returnedAmount | in\_swapDescription                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | in\_protocolFeeAmount | in\_inputBalanceChange | in\_absoluteInputAmount | in\_absoluteOutputAmount | in\_marketplaceFeeAmount |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | ---------------------- | ----------------------- | ------------------------ | ------------------------ |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x6bec9d1d1a3762769575f96d52c1484da04f30c4 | 76         | 29504596      | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x078f358208685046a11c85e8ad32895ded33a249 | 2023-05-02T15:41:28.000Z | 0xd22f9207d4b52815c5170710e10b56837744fae33e83da1cbf2ce0b5f7b1080f | 601545             | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x6bec9d1d1a3762769575f96d52c1484da04f30c4","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000078f358208685046a11c85e8ad32895ded33a24900000000000000000000000000000000000000000000000000000000000004087c025200000000000000000000000000f01ef4051130cc8871fa0c17024a6d62e379e85600000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000078f358208685046a11c85e8ad32895ded33a249000000000000000000000000f01ef4051130cc8871fa0c17024a6d62e379e856000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000008d8dadf544fc00000000000000000000000000000000000000000000000000000000000000092355000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000025b00000000000000000000000000000000000000000000021d0001ef00018f00a007e5c0d200000000000000000000000000000000000000016b0000bb00006800001a4041b31f66aa3c1e785363f0875a1b74e27b85fd66c7d0e30db048202939df25c6818c5b5bbd35a3f29daccc52e81b34b31f66aa3c1e785363f0875a1b74e27b85fd66c7bd6015b40000000000000000000000009d86243ae7008ec1f9cce83c49d76f7a557b80cf00206ae4071118002dc6c09d86243ae7008ec1f9cce83c49d76f7a557b80cf0000000000000000000000000000000000000000000000000000000000091794b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e5120794a61358d6845594f94dc1db02a252b5b4814ad50b7545627a5162f82a992c33b87adc75187b2180024617ba03700000000000000000000000050b7545627a5162f82a992c33b87adc75187b2180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f01ef4051130cc8871fa0c17024a6d62e379e856000000000000000000000000000000000000000000000000000000000000044d00a0cd211e1e078f358208685046a11c85e8ad32895ded33a2490000000000000000000000000000000000000000000000000000000000092f17000000000000000000000000000000027fffd26d332c71daa06bb24dded5c3c167961e9eb99480a06c4eca27078f358208685046a11c85e8ad32895ded33a2491111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000000008d8dadf544fc0000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 10200000000000000000   | 10200000000000000000    | 598869                   | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0xdaf45073a54cf4afc3122bf39d26e9620192f1b4 | 9          | 29491841      | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e | 2023-05-02T08:31:11.000Z | 0xb6f1384e3bde497392b5ba4c8dfad3ef1d12426c266f0a7082784a4598bc2e40 | 437190596          | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0xdaf45073a54cf4afc3122bf39d26e9620192f1b4","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0000000000000000000000000000000000000000000000000000000000000244f0210929000000000000000000000000000000000000000000000000000000000000002000000000000000000000000039ded1e84463bc9791f5042ee93bc1eaa9cc42cc0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f000000000000000000000000daf45073a54cf4afc3122bf39d26e9620192f1b40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0000000000000000000000000000000000000000000000016b99192fbb3c00000000000000000000000000000000000000000000000000016b99192fbb3c0000000000000000000000000000000000000000000000000000000000001a0effc4000000000000000000000000000000000000000000000000000000006450ca6f00000000000000000000000000000000000000000000000000000187db9627790167616e64616c6674686562726f776e67786d786e6900187d2f3f783c15000000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000041f9d56ddee3c30a91fad74b8834f5cfeb539c81b76a3e72ac996498df63304507644a99e59953965ca7d154200cdc9468ade24f46bb56b7b0f937900f63eff2d11b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 0                     | 26200000000000000000   | 26200000000000000000    | 437190596                | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x022832b3dcc169d66a6409354bfca7cd7796c68f | 24         | 29479927      | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0xc7198437980c041c805a1edcba50c1ce5db95118 | 2023-05-02T01:46:09.000Z | 0x162653a3e8586d8facbf11b8dee9f1df206828413eae9fea2df785112e65f50c | 82963373           | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x022832b3dcc169d66a6409354bfca7cd7796c68f","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000c7198437980c041c805a1edcba50c1ce5db951180000000000000000000000000000000000000000000000000000000000000244f02109290000000000000000000000000000000000000000000000000000000000000020000000000000000000000000cf19a556abfc75c1e4bc9d84fa3374046d3ea4f00000000000000000000000002008b6c3d07b061a84f790c035c2f6dc11a0be70000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f000000000000000000000000022832b3dcc169d66a6409354bfca7cd7796c68f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c7198437980c041c805a1edcba50c1ce5db951180000000000000000000000000000000000000000000000004563918244f400000000000000000000000000000000000000000000000000004563918244f400000000000000000000000000000000000000000000000000000000000004f1ebad0000000000000000000000000000000000000000000000000000000064506b6500000000000000000000000000000000000000000000000000000187da2337630167616e64616c6674686562726f776e67786d786e6900187bbc4f637dc8000000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000041d0037108eb9d3f6339a1145309bfd37e78cd6cf4618347086a943e8335ca314d4b84e8bfb95a7fb4ee53eb9a0d14d63b935fd6a94670ee1af02f77c0e3457da81b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 0                     | 5000000000000000000    | 5000000000000000000     | 82963373                 | 0                        |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.zerion_v1_avalanche.Router_Executed_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***