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

> Tables in tt-contracts.airswap_v0_ethereum

## Tables

### AirSwapExchange\_Filled\_event

Completed order fills from the AirSwap peer-to-peer token exchange on Ethereum, recording maker and taker addresses, token pairs, amounts, and expiration timestamps. Used for analyzing decentralized exchange (DEX) trading patterns and liquidity provision 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_makerAddress`  | `STRING`    | Ethereum address of the market maker who created the order being filled. Hex-encoded, 0x-prefixed 40-character string representing the party providing liquidity to the AirSwap trade.       |
  | `in_makerAmount`   | `STRING`    | Token amount provided by the maker in the swap, denominated in the maker token's smallest unit. Values are string-encoded integers representing raw token amounts before decimal adjustment. |
  | `in_makerToken`    | `STRING`    | Token address provided by the maker as part of the swap order. Represents the ERC-20 token contract (or zero address for ETH) that the maker is offering to exchange.                        |
  | `in_takerAddress`  | `STRING`    | Ethereum address of the party taking the maker's offer in the swap. Hex-encoded, 0x-prefixed address that receives the maker's tokens in exchange for providing taker tokens.                |
  | `in_takerAmount`   | `STRING`    | Token amount committed by the taker in the swap order, denominated in the taker token's smallest unit. String-formatted to handle large integers that exceed standard numeric limits.        |
  | `in_takerToken`    | `STRING`    | Contract address of the token being provided by the taker in the swap. Address 0x0000000000000000000000000000000000000000 represents native ETH on Ethereum.                                 |
  | `in_expiration`    | `STRING`    | Order expiration timestamp. Unix timestamp in seconds, or 0 for orders without expiration.                                                                                                   |
  | `in_nonce`         | `STRING`    | Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.                                       |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_nonce                                                                 | log\_index | block\_number | in\_expiration | in\_makerToken                             | in\_takerToken                             | in\_makerAmount        | in\_takerAmount    | block\_timestamp         | in\_makerAddress                           | in\_takerAddress                           | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------------------------------------- | ---------- | ------------- | -------------- | ------------------------------------------ | ------------------------------------------ | ---------------------- | ------------------ | ------------------------ | ------------------------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x8fd3121013a07c57f0d69646e86e7a4880b467b7 | false   | 4760465140811371206                                                       | 88         | 9089032       | 1576072474     | 0x27054b13b1b798b345b591a4d22e6562d47ea75a | 0x0000000000000000000000000000000000000000 | 10000                  | 147359279340000    | 2019-12-11T13:53:09.000Z | 0x3310b055015a94a2f2e37014b944d8ca6bd2b845 | 0xe4f09e773d5102e6473f12b1a89b21cc08fd2efb | 0x14d022e79e522242d96f559c7be729b294bfd9671154c07a2eccd8b6fc47c7f5 |
  | 0x8fd3121013a07c57f0d69646e86e7a4880b467b7 | false   | 38466                                                                     | 153        | 9091230       | 1576105909     | 0x4e15361fd6b4bb609fa63c81a2be19d873717870 | 0x0000000000000000000000000000000000000000 | 1222975303236763300000 | 100000000000000000 | 2019-12-11T23:07:56.000Z | 0x195ac57ae67f36d1aaaa2409d972f7e7b2582028 | 0xaae90a192247377c121b6469baffeb99b3ffd28a | 0x53050d655d008e0f1b4645f28b09c1ad8d83d7bf38e3c4b4b264414b0168f1f2 |
  | 0x8fd3121013a07c57f0d69646e86e7a4880b467b7 | false   | 1442135333492832859122335571791985200326835431741085547289000001576087669 | 32         | 9090034       | 1576087819     | 0x89d24a6b4ccb1b6faa2625fe562bdd9a23260359 | 0x0000000000000000000000000000000000000000 | 1000000000000000000    | 7029423613169915   | 2019-12-11T18:08:14.000Z | 0xc6093fd9cc143f9f058938868b2df2daf9a91d28 | 0xd0c81e82abddf29c6505d660f5bebe60cdff03c5 | 0x6f2de0aa0a13b0927f45e89ed00578fd619fab319b74c5cf7c41e06bee19e563 |
</Accordion>

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

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

***