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

> Tables in tt-contracts.airswap_v2_bsc

## Tables

### Light\_Swap\_event

Peer-to-peer token swap events from AirSwap v2 Light protocol on Binance Smart Chain, recording sender/signer wallet addresses, token amounts, and fees for each bilateral trade. Used to analyze decentralized over-the-counter trading activity and liquidity provision patterns.

<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 market maker (signer) for executing this swap. Denominated in the smallest unit of the signer's token, typically basis points when divided by token amount. |
  | `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                                                  |
  | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------- | ------------- | ------------------------------------------ | ------------------------------------------ | ------------------------ | ------------------ | ------------------------------------------ | ---------------------- | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0xc98314a5077dba8f12991b29bce39f834e82e197 | false   | 1646653545 | 713        | 15850447      | 7             | 1646653573    | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x55d398326f99059ff775485246999027b3197955 | 2022-03-07T11:46:13.000Z | 5309623200000000   | 0xc590175e458b83680867afd273527ff58f74c02b | 13442459268612065000   | 0x945bcf562085de2d5875b9e2012ed5fd5cfab927 | 0xbb571c5556e7c32fd24367682098c7e917b79e6827a0cd52ced7f93e8a77b80f |
  | 0xc98314a5077dba8f12991b29bce39f834e82e197 | false   | 1646617778 | 529        | 15838558      | 7             | 1646617786    | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x55d398326f99059ff775485246999027b3197955 | 2022-03-07T01:49:46.000Z | 540539291087378546 | 0xc590175e458b83680867afd273527ff58f74c02b | 1375720613375138300000 | 0x111bb8c3542f2b92fb41b8d913c01d3788431111 | 0x87d0af112da080948da261c53277b3f43d78f261de1b6f9a9b12cf6a56908d81 |
  | 0xc98314a5077dba8f12991b29bce39f834e82e197 | false   | 1646644113 | 529        | 15847302      | 7             | 1646644125    | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x55d398326f99059ff775485246999027b3197955 | 2022-03-07T09:08:45.000Z | 49850000000000000  | 0xc590175e458b83680867afd273527ff58f74c02b | 126561156664334940000  | 0x111bb8c3542f2b92fb41b8d913c01d3788431111 | 0x50e7cfdf630c6f9ad7028664e10efda8092c53c4b5e0e1235308d25dde903ad2 |
</Accordion>

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

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

***