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

> Tables in tt-contracts.zerion_v1_optimism

## 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   | 0x83e91a9c91d14f6b6e670cf7b33cb540cc90e518 | 3          | 103668208     | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 2023-06-01T21:30:28.000Z | 0xca2d2c162fb15f6aa34438b4acc7557aa642bc65e698d957175f90ac53e9f91f | 18717769           | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x83e91a9c91d14f6b6e670cf7b33cb540cc90e518","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000000000000000244f021092900000000000000000000000000000000000000000000000000000000000000200000000000000000000000003b87eed5a8f40b81ebd8a01ac1891f04cb59fd660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000083e91a9c91d14f6b6e670cf7b33cb540cc90e51800000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c31607000000000000000000000000000000000000000000000000002386f26fc10000000000000000000000000000000000000000000000000000002386f26fc1000000000000000000000000000000000000000000000000000000000000011d9c490000000000000000000000000000000000000000000000000000000064790e1b0000000000000000000000000000000000000000000000000000018878de80540167616e64616c6674686562726f776e67786d786e6900191a779854242b000000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000041bdb1a1d95855151e6c7fd119b3a27bb73b15be8d1c03db370522162a5f6bb31b66a85263f81def8c419a37f38d1b67b4b9ee2ce986f079d8ce7720a3fd6c21101c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 10000000000000000      | 10000000000000000       | 18717769                 | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd6 | 3          | 103566095     | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 2023-06-01T12:44:20.000Z | 0x816d8f3fd82d7e7a4ab9fe7c3bd8446c4af0654de1f00b5fcaedc3f521ce784b | 37208674           | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd6","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000000000000000244f021092900000000000000000000000000000000000000000000000000000000000000200000000000000000000000003b87eed5a8f40b81ebd8a01ac1891f04cb59fd660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000069155e7ca2e688ccdc247f6c4ddf374b3ae77bd600000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c3160700000000000000000000000000000000000000000000000000470de4df82000000000000000000000000000000000000000000000000000000470de4df820000000000000000000000000000000000000000000000000000000000000237c26200000000000000000000000000000000000000000000000000000000647892b70000000000000000000000000000000000000000000000000000018876fc7f3e0167616e64616c6674686562726f776e67786d786e6900191895973e2d5b000000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000000418f9cd76b5833e6e79de644d944f4df5555900394bfcb264a21b2fdddd50fefc01005424d589c5d580b76d89083170d0cd2fed0167eb24ab957f865b0e35ad6df1b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 20000000000000000      | 20000000000000000       | 37208674                 | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x21d90e6f18f3848d9e45f34bdb4dfdde3fa09d1a | 3          | 103544591     | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x7f5c764cbc14f9669b88837ca1490cca17c31607 | 2023-06-01T11:06:33.000Z | 0xe7ca3e9d4a3b64e53a738a98462e43f9cd3e636e0738b3ddd4fdee1ef822315f | 46490855           | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x21d90e6f18f3848d9e45f34bdb4dfdde3fa09d1a","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000000000000000244f021092900000000000000000000000000000000000000000000000000000000000000200000000000000000000000003b87eed5a8f40b81ebd8a01ac1891f04cb59fd660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000021d90e6f18f3848d9e45f34bdb4dfdde3fa09d1a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000000000002c564e70000000000000000000000000000000000000000000000000000000064787be20000000000000000000000000000000000000000000000000000018876a350040167616e64616c6674686562726f776e67786d786e690019183c68042d5b000000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000000410fbbca3db75cbcde4fd59a1d7ca3e3b7b3a457fbb2e3d224620c35c8607d5319102420f6cdfa93f67465b6ee5f569d2e874414f93784bbc5079f0b5b800953031b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 25000000000000000      | 25000000000000000       | 46490855                 | 0                        |
</Accordion>

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

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

***