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

> Tables in tt-contracts.zerion_v1_polygon

## 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   | 0x07a3df90b031e88808e69f9943d787262f931d39 | 83         | 30146433      | 0x7ceb23fd6bc0add59e62ac25578270cff1b9f619 | 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063 | 2022-06-29T18:46:47.000Z | 0x26dd7beafcc6d1b626e5cedc57083e302bcfe9ea972fb9d80519e8951da813c4 | 236222036018177087909 | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x07a3df90b031e88808e69f9943d787262f931d39","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x0000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a06300000000000000000000000000000000000000000000000000000000000003487c025200000000000000000000000000521709b3cd7f07e29722be0ba28a8ce0e806dbc3000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a0630000000000000000000000004a35582a710e1f4b2030a3f826da20bfb6703c09000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000000000000000000000000000002faa16773bcd56500000000000000000000000000000000000000000000000cad74f74c6d252d6f00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001a0000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000020800000000000000000000000521709b3cd7f07e29722be0ba28a8ce0e806dbc30000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed60000000000000000000000004a35582a710e1f4b2030a3f826da20bfb6703c090000000000000000000000007ceb23fd6bc0add59e62ac25578270cff1b9f6190000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a0630000000000000000002dc6c01111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 0                     | 214661397948978533     | 214661397948978533      | 233859815657995312824    | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x23e57777c60155baade25879bcaa03123745e350 | 192        | 30150536      | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0xc2132d05d31c914a87c6611c10748aeb04b58e8f | 2022-06-29T21:23:05.000Z | 0xef87424fad9c5f8fc0cd05de4898f57804687a03fc659c87caf7ec4474d6f42e | 7473318               | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x23e57777c60155baade25879bcaa03123745e350","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000e592427a0aece92de3edee1f18e0157c05861564000000000000000000000000e592427a0aece92de3edee1f18e0157c0586156400000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000000000000000000000000000000000000000014ac04b8d59000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000000000000062bcc9b1000000000000000000000000000000000000000000000000cd64299613c80000000000000000000000000000000000000000000000000000000000000070dcd600000000000000000000000000000000000000000000000000000000000000420d500b1d8e8ef31e21c99d1db9a6444d3adf12700001f42791bca1f2de4661ed88a30c99a7a9449aa84174000064c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000000000000000000000000000000000000000007a6572696f6e00000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 0                     | 14800000000000000000   | 14800000000000000000    | 7396566                  | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x24deda85a37aea206edaa523b6dc8d3925c818a9 | 43         | 30130508      | 0x8f3cf7ad23cd3cadbd9735aff958023239c6a063 | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 2022-06-29T08:52:46.000Z | 0xdd0f1b6c44cbde6396a5f06b6aae543fcf2706ef642544f4f8a12f6747ae81df | 2121454868949130901   | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x24deda85a37aea206edaa523b6dc8d3925c818a9","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x0000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a0630000000000000000000000001b02da8cb0d097eb8d57a175b88c7d8b479975060000000000000000000000001b02da8cb0d097eb8d57a175b88c7d8b4799750600000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000000000000000000000000000000000000000010418cbafe50000000000000000000000000000000000000000000000000f856423d39ae8720000000000000000000000000000000000000000000000001d258d71980748f500000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000000000000062bc19d800000000000000000000000000000000000000000000000000000000000000020000000000000000000000008f3cf7ad23cd3cadbd9735aff958023239c6a0630000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf127000000000000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 0                     | 1118410187508213874    | 1118410187508213874     | 2100240320259639541      | 0                        |
</Accordion>

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

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

***