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

> Tables in tt-contracts.zerion_v1_gnosis

## 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   | 0x10a1db5d3a971cf1e565b28a86d5ce9e576a7b81 | 7          | 26806523      | 0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2023-03-06T12:01:35.000Z | 0x16778a36fa6adb6e4fbeae3d9d90836b0eec13bf98dbcbe88670b04478805c1d | 311778708008567400  | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x10a1db5d3a971cf1e565b28a86d5ce9e576a7b81","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x0000000000000000000000006a023ccd1ff6f2045c3309768ead9e68f978f6e10000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000000000000000000002a87c02520000000000000000000000000029bc86ad68bb3bd3d54841a8522e0020c1882c22000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000006a023ccd1ff6f2045c3309768ead9e68f978f6e1000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000002eb71cd867e7e1d3a17ecd981d592e079b6cb985000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000000000b5e620f48000000000000000000000000000000000000000000000000000044e1f4713af1a1300000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e30000000000000000000000000000000000000000000000a500008f00005300206ae4071198002dc6c02eb71cd867e7e1d3a17ecd981d592e079b6cb98500000000000000000000000000000000000000000000000004489578e3fcb1be6a023ccd1ff6f2045c3309768ead9e68f978f6e14101e91d153e0b41518a2ce8dd3d7944fa863463a97d00042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0611111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000000000000b5e620f48000000000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                 | 0                     | 200000000000000        | 200000000000000         | 310219814468524605       | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0xecbf0aa9ead17d2bf7bd8aa83a0cdc8510a75a7b | 8          | 26809614      | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x9c58bacc331c9aa871afd802db6379a98e80cedb | 2023-03-06T16:32:00.000Z | 0xca39717822e71d116bc5fe42d06500885bfc4c80e3379e13f600e656bda42006 | 76343424656557220   | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0xecbf0aa9ead17d2bf7bd8aa83a0cdc8510a75a7b","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000009c58bacc331c9aa871afd802db6379a98e80cedb00000000000000000000000000000000000000000000000000000000000002a87c02520000000000000000000000000029bc86ad68bb3bd3d54841a8522e0020c1882c2200000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000009c58bacc331c9aa871afd802db6379a98e80cedb00000000000000000000000029bc86ad68bb3bd3d54841a8522e0020c1882c22000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000006f05b59d3b200000000000000000000000000000000000000000000000000000010ddec5420d8d4100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000e70000000000000000000000000000000000000000000000000000a900001a4041e91d153e0b41518a2ce8dd3d7944fa863463a97dd0e30db00c20e91d153e0b41518a2ce8dd3d7944fa863463a97d0f9d54d9ee044220a3925f9b97509811924fd2696ae4071138002dc6c00f9d54d9ee044220a3925f9b97509811924fd2691111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000010c8399d083d5dfe91d153e0b41518a2ce8dd3d7944fa863463a97d0000000000000000000000000000000000000000000000006f05b59d3b2000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                 | 0                     | 8000000000000000000    | 8000000000000000000     | 75961707533274429        | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x10a91cf39ee317d5844b6470346204604b07e85c | 10         | 26803388      | 0x6a023ccd1ff6f2045c3309768ead9e68f978f6e1 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2023-03-06T07:31:10.000Z | 0xfcac0c477066c455cae9fd263255b0bf7454a2c617de36d9a76df3977b35431e | 1562285719549940172 | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x10a91cf39ee317d5844b6470346204604b07e85c","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x0000000000000000000000006a023ccd1ff6f2045c3309768ead9e68f978f6e10000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000000000000000000000000000000000000000003287c02520000000000000000000000000029bc86ad68bb3bd3d54841a8522e0020c1882c22000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000006a023ccd1ff6f2045c3309768ead9e68f978f6e1000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3011007ebbb56c791eaebf87fe035190b8dbe62000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000000000000000000000000000000038d7ea4c6800000000000000000000000000000000000000000000000000015929a21b4aeba07000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000016e00000000000000000000000000000000000000000000000000013000011a00a007e5c0d20000000000000000000000000000000000000000000000f60000ba00006700206ae40711b8002dc6c0b3011007ebbb56c791eaebf87fe035190b8dbe628db8870ca4b8ac188c4d1a014f34a381ae27e1c20000000000000000000000000000000000000000000000000000000000001b066a023ccd1ff6f2045c3309768ead9e68f978f6e100206ae4071198002dc6c08db8870ca4b8ac188c4d1a014f34a381ae27e1c20000000000000000000000000000000000000000000000001576d9adc1ece2428e5bbbb09ed1ebde8674cda39a0c169401db42524101e91d153e0b41518a2ce8dd3d7944fa863463a97d00042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0611111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000038d7ea4c6800000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 1000000000000000       | 1000000000000000        | 1554474290952190361      | 0                        |
</Accordion>

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

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

***