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

# airswap_v2_ethereum

> Tables in tt-contracts.airswap_v2_ethereum

## Tables

### Light\_Swap\_event

Swap events from AirSwap v2 Light protocol on Ethereum capturing peer-to-peer token trades between signers and senders. Records include traded token addresses, amounts, fees, and wallet addresses for analyzing decentralized OTC (over-the-counter) trading activity.

<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_nonce`         | `STRING`    | Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.                  |
  | `in_timestamp`     | `STRING`    | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.                                                              |
  | `in_signerWallet`  | `STRING`    | Wallet address of the order signer in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                              |
  | `in_signerToken`   | `STRING`    | Contract address of the token being provided by the order signer in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                            |
  | `in_signerAmount`  | `STRING`    | Amount of tokens provided by the order signer in the swap. Numeric string representation without decimals, denominated in the smallest unit of the signer token.        |
  | `in_signerFee`     | `STRING`    | Fee amount charged by the signer (market maker) for executing this swap, denominated in basis points. Always "7" in sample data, representing 0.07% of the trade value. |
  | `in_senderWallet`  | `STRING`    | Wallet address of the sender in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                                    |
  | `in_senderToken`   | `STRING`    | Contract address of the token being provided by the sender in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                                  |
  | `in_senderAmount`  | `STRING`    | Amount of tokens provided by the sender in the swap transaction. Numeric string representation without decimals, denominated in the smallest unit of the sender token.  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_nonce     | log\_index | block\_number | in\_signerFee | in\_timestamp | in\_senderToken                            | in\_signerToken                            | block\_timestamp         | in\_senderAmount       | in\_senderWallet                           | in\_signerAmount    | in\_signerWallet                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------- | ---------- | ------------- | ------------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ---------------------- | ------------------------------------------ | ------------------- | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xc549a5c701cb6e6cbc091007a80c089c49595468 | false   | 1633292921291 | 523        | 13359312      | 7             | 1633439946    | 0x6b175474e89094c44da98b954eedeac495271d0f | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 2021-10-05T13:19:06.000Z | 1191809831214911959295 | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | 352299023344183552  | 0x00000000000080c886232e9b7ebbfb942b5987aa | 0x3bee4c35ae7cbfd030e223c91bd3804b68db99babef29b082732a3aefaa01ab0 |
  | 0xc549a5c701cb6e6cbc091007a80c089c49595468 | false   | 1633292921648 | 332        | 13359454      | 7             | 1633442170    | 0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0 | 0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 | 2021-10-05T13:56:10.000Z | 26220557833625474145   | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | 1165715777055504603 | 0x00000000000080c886232e9b7ebbfb942b5987aa | 0xe3e787624eeeb6db9a79285db0bac0cc4ef8af8a2978a837c454fdf5092d0091 |
  | 0xc549a5c701cb6e6cbc091007a80c089c49595468 | false   | 1633292921059 | 227        | 13359172      | 7             | 1633438001    | 0x8798249c2e607446efb7ad49ec89dd1865ff4272 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 2021-10-05T12:46:41.000Z | 16078015528345638116   | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | 58668795749089582   | 0x00000000000080c886232e9b7ebbfb942b5987aa | 0xd2f9d431fb08c51cd142c6094c76574eaf37b6fe0afff63fdc920f536283d5ee |
</Accordion>

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

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

***

### Light\_v0\_Swap\_event

Swap execution events from AirSwap v2 Light protocol on Ethereum, recording peer-to-peer token trades between signers and senders with amounts, wallet addresses, and nonce-based order tracking. Used for analyzing decentralized OTC trading patterns and liquidity provider activity.

<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_nonce`         | `STRING`    | Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.                 |
  | `in_timestamp`     | `STRING`    | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.                                                             |
  | `in_signerWallet`  | `STRING`    | Wallet address of the order signer in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                             |
  | `in_senderWallet`  | `STRING`    | Wallet address of the sender in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                                   |
  | `in_signerToken`   | `STRING`    | Contract address of the token being provided by the order signer in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_senderToken`   | `STRING`    | Contract address of the token being provided by the sender in the swap. Hex-encoded, 0x-prefixed, 42-character string.                                                 |
  | `in_signerAmount`  | `STRING`    | Amount of tokens provided by the order signer in the swap. Numeric string representation without decimals, denominated in the smallest unit of the signer token.       |
  | `in_senderAmount`  | `STRING`    | Amount of tokens provided by the sender in the swap transaction. Numeric string representation without decimals, denominated in the smallest unit of the sender token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_nonce  | log\_index | block\_number | in\_timestamp | in\_senderToken                            | in\_signerToken                            | block\_timestamp         | in\_senderAmount       | in\_senderWallet                           | in\_signerAmount     | in\_signerWallet                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ---------------------- | ------------------------------------------ | -------------------- | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3 | false   | 1613665516 | 94         | 11881893      | 1613665533    | 0x6b175474e89094c44da98b954eedeac495271d0f | 0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e | 2021-02-18T16:25:33.000Z | 3988000000000000000000 | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | 90324944741172850    | 0xa5d07e978398eb1715056d3ca5cb31035c02fdad | 0xbd09ccd9ef3cb9cfc9178f5b003247576fe0ea053171e33def3ce0694b6871d1 |
  | 0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3 | false   | 1613625954 | 242        | 11878922      | 1613625982    | 0x6b175474e89094c44da98b954eedeac495271d0f | 0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 | 2021-02-18T05:26:22.000Z | 997000000000000000000  | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | 45237963238621710000 | 0xa5d07e978398eb1715056d3ca5cb31035c02fdad | 0x21ce810159bdfd46ea7566c5d67f384c40b7bf6325fa42d529aa416a7e8aeade |
  | 0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3 | false   | 1613629531 | 225        | 11879190      | 1613629607    | 0x6b175474e89094c44da98b954eedeac495271d0f | 0x1f9840a85d5af5bf1d1762f925bdaddc4201f984 | 2021-02-18T06:26:47.000Z | 21934000000000000000   | 0x74de5d4fcbf63e00296fd95d33236b9794016631 | 1003298862417408200  | 0xa5d07e978398eb1715056d3ca5cb31035c02fdad | 0x5250bd9c19edc6ea8fb9d5a53b618d1d940951a0d7eae91b9e866ed6e70601e3 |
</Accordion>

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

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

***