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

> Tables in tt-contracts.zerion_v1_bsc

## 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   | 0x49ec04f2cfd2ac7a18a39f871e1bdd474a4d1487 | 324        | 19366449      | 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee | 0x111111111117dc0aa78b770fa6a738034120c302 | 2022-07-08T08:55:06.000Z | 0x078245a7df10454219f98ac45a8393f6355d6d8e023c8d2c27437e24a0887fed | 34466944802661317419  | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x49ec04f2cfd2ac7a18a39f871e1bdd474a4d1487","swapType":1,"protocolFee":\{"share":"5000000000000000","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000111111111117dc0aa78b770fa6a738034120c30200000000000000000000000000000000000000000000000000000000000005287c02520000000000000000000000000005ad60d9a2f1aa30ba0cdbaf1e0a0a145fbea16f00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000111111111117dc0aa78b770fa6a738034120c30200000000000000000000000005ad60d9a2f1aa30ba0cdbaf1e0a0a145fbea16f000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f000000000000000000000000000000000000000000000000016345785d8a0000000000000000000000000000000000000000000000000001de501fff29966a45000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000038000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000000000000000000000000000016345785d8a000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000004d0e30db0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000095783044c406715164d452d87fb5c54557bbef2000000000000000000000000000000000000000000000000016345785d8a00000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000095783044c406715164d452d87fb5c54557bbef2000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000111111111117dc0aa78b770fa6a738034120c3020000000000000000001e84801111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}} | 172334724013306587    | 100000000000000000     | 100000000000000000      | 34294610078648012636     | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x2a812626c2838dccb53fde027fd4d6fc3f6d7ce7 | 20         | 19382658      | 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d | 0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3 | 2022-07-08T22:26:27.000Z | 0x3b05a291e3e782a17b20d3f1aa01164e0ac40ab77b1c597d543019522fc32ede | 139839075871805366867 | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x2a812626c2838dccb53fde027fd4d6fc3f6d7ce7","swapType":1,"protocolFee":\{"share":"0","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc30000000000000000000000000000000000000000000000000000000000000148c43c9ef6000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000796e3ea3f8ab00000000000000000000000000000000000000000000000000007832d8b57f77b1618000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000030000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc3869584cd0000000000000000000000007cba0eb7a94068324583be7771c5ecda25e4c4d10000000000000000000000000000000000000000000000efc1b6b18262c8af04000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 0                     | 140000000000000000000  | 140000000000000000000   | 138440685113087319080    | 0                        |
  | 0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696f | false   | 0x022fe87e83f3d6662862ed51ef74de33ed16ff25 | 77         | 19382740      | 0xe9e7cea3dedca5984780bafc599bd69add087d56 | 0x1af3f329e8be154074d8769d1ffa4ee058b1dbc3 | 2022-07-08T22:30:33.000Z | 0xe954506430d203701276c29c26a53e78d64b31263c49d022abaa5cf78aa86e83 | 4973633219481922471   | \{"caller":"0xc629bf86f02ef13e8f1f5f75ade8a8165587998f","account":"0x022fe87e83f3d6662862ed51ef74de33ed16ff25","swapType":1,"protocolFee":\{"share":"5000000000000000","beneficiary":"0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54"},"callerCallData":"0x000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc300000000000000000000000000000000000000000000000000000000000003487c02520000000000000000000000000005ad60d9a2f1aa30ba0cdbaf1e0a0a145fbea16f00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc300000000000000000000000066fdb2eccfb58cf098eaa419e5efde841368e489000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000004563918244f4000000000000000000000000000000000000000000000000000044aca96bf5c9514a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000066fdb2eccfb58cf098eaa419e5efde841368e489000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc30000000000000000002625a01111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000","marketplaceFee":\{"share":"0","beneficiary":"0x0000000000000000000000000000000000000000"}}                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | 24868166097409612     | 5000000000000000000    | 5000000000000000000     | 4923896887287103488      | 0                        |
</Accordion>

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

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

***