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

> Tables in tt-contracts.zerion_v1_fantom

## 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   | 0x8330a84d3c16a55302f921c36979b1067418053a | 39         | 37343019      | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2022-05-01T17:56:26.000Z | 0x7c6a49889e86d45361eef250265ceb37f01296e7adf76e9a5518d04a4b21110e | 75878032229935581823 | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x8330a84d3c16a55302f921c36979b1067418053a","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000def189deaef76e379df891899eb5a00a94cbc250000000000000000000000000def189deaef76e379df891899eb5a00a94cbc25000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000628415565b000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000000000000356fbb7000000000000000000000000000000000000000000000004127d319c73bde0c800000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000060000000000000000000000000000000000000000000000000000000000000036000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000002a00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b7500000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c830000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000026000000000000000000000000000000000000000000000000000000000000002600000000000000000000000000000000000000000000000000000000000000240000000000000000000000000000000000000000000000000000000000356fbb70000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000001142656574686f76656e78000000000000000000000000000000000000000000000000000000000000000000000356fbb7000000000000000000000000000000000000000000000004127d319c73bde0c80000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004000000000000000000000000020dd72ed959b6147912c2e529f0a0c651c33c9ce5e65474c8400d0bb76edbbe066b2d2e7b0b6e7fb00010000000000000000007c0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000004000000000000000000000000021be370d5312f44cb42ce377bc9b8a0cef1a4c83ffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff0000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000100000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000000000869584cd0000000000000000000000007cba0eb7a94068324583be7771c5ecda25e4c4d10000000000000000000000000000000000000000000000414812eaa2626ec9b4000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 56032183               | 56032183                | 75119251907636226949     | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x78965cecb4696165b374fea43bac3029006dec2c | 36         | 37317419      | 0xfb98b335551a418cd0737375a2ea0ded62ea213b | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 2022-05-01T07:50:19.000Z | 0xb118f6f548d1fa8705e184d9ddef4bc632252da20ca9340da794b1d00c5a255b | 1495294983           | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x78965cecb4696165b374fea43bac3029006dec2c","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x000000000000000000000000fb98b335551a418cd0737375a2ea0ded62ea213b000000000000000000000000def189deaef76e379df891899eb5a00a94cbc250000000000000000000000000def189deaef76e379df891899eb5a00a94cbc25000000000000000000000000000000000000000000000000000000000000000a000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000000588415565b0000000000000000000000000fb98b335551a418cd0737375a2ea0ded62ea213b00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000000000000000000000000051a95ed9792fc0000000000000000000000000000000000000000000000000000000000000583c3a1000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000003400000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000002a000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000fb98b335551a418cd0737375a2ea0ded62ea213b00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b750000000000000000000000000000000000000000000000000000000000000120000000000000000000000000000000000000000000000000000000000000026000000000000000000000000000000000000000000000000000000000000002600000000000000000000000000000000000000000000000000000000000000240000000000000000000000000000000000000000000000051a95ed9792fc000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000001142656574686f76656e78000000000000000000000000000000000000000000000000000000000051a95ed9792fc0000000000000000000000000000000000000000000000000000000000000583c3a100000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004000000000000000000000000020dd72ed959b6147912c2e529f0a0c651c33c9ce985976228a4685ac4ecb0cfdbeed72154659b6d900020000000000000000008d000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000fb98b335551a418cd0737375a2ea0ded62ea213b000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd0000000000000000000000007cba0eb7a94068324583be7771c5ecda25e4c4d10000000000000000000000000000000000000000000000eaf8fc5362626e3bb6000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                 | 0                     | 1506390701125209686016 | 1506390701125209686016  | 1480342033               | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x1ecf831d6d5db415c1f231f28a2efcabdadfc873 | 22         | 37348395      | 0x04068da6c83afcfa0e13ba15a6696662335d5b75 | 0x841fad6eae12c286d1fd18d1d525dffa75c7effe | 2022-05-01T20:32:54.000Z | 0xab922d15fd82f1fe37aa2d400a9c28e1292acb292e20a6e302b5a06345242c64 | 10092219576291518707 | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x1ecf831d6d5db415c1f231f28a2efcabdadfc873","swapType":1,"protocolFee":\{"share":"5000000000000000","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x00000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000def189deaef76e379df891899eb5a00a94cbc250000000000000000000000000def189deaef76e379df891899eb5a00a94cbc25000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000841fad6eae12c286d1fd18d1d525dffa75c7effe0000000000000000000000000000000000000000000000000000000000000588415565b000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000841fad6eae12c286d1fd18d1d525dffa75c7effe0000000000000000000000000000000000000000000000000000000003d090000000000000000000000000000000000000000000000000008b59b3310bc1bac900000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000003400000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000002a00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000841fad6eae12c286d1fd18d1d525dffa75c7effe00000000000000000000000000000000000000000000000000000000000001200000000000000000000000000000000000000000000000000000000000000260000000000000000000000000000000000000000000000000000000000000026000000000000000000000000000000000000000000000000000000000000002400000000000000000000000000000000000000000000000000000000003d090000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000001142656574686f76656e780000000000000000000000000000000000000000000000000000000000000000000003d090000000000000000000000000000000000000000000000000008b59b3310bc1bac90000000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000004000000000000000000000000020dd72ed959b6147912c2e529f0a0c651c33c9ce0459a6e0478644a87ee1371ecf944f403ac65522000200000000000000000222000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000004068da6c83afcfa0e13ba15a6696662335d5b75000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000000000000000000000869584cd0000000000000000000000007cba0eb7a94068324583be7771c5ecda25e4c4d10000000000000000000000000000000000000000000000fe1e16e398626eee5e000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                  | 50461097881457593     | 64000000               | 64000000                | 9991297380528603791      | 0                        |
</Accordion>

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

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

***