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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v0_ethereum.AirSwapExchange_Filled_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100