Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_makerAddressSTRINGEthereum 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_makerAmountSTRINGToken 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_makerTokenSTRINGToken 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_takerAddressSTRINGEthereum 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_takerAmountSTRINGToken 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_takerTokenSTRINGContract address of the token being provided by the taker in the swap. Address 0x0000000000000000000000000000000000000000 represents native ETH on Ethereum.
in_expirationSTRINGOrder expiration timestamp. Unix timestamp in seconds, or 0 for orders without expiration.
in_nonceSTRINGUnique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
addressremovedin_noncelog_indexblock_numberin_expirationin_makerTokenin_takerTokenin_makerAmountin_takerAmountblock_timestampin_makerAddressin_takerAddresstransaction_hash
0x8fd3121013a07c57f0d69646e86e7a4880b467b7false476046514081137120688908903215760724740x27054b13b1b798b345b591a4d22e6562d47ea75a0x0000000000000000000000000000000000000000100001473592793400002019-12-11T13:53:09.000Z0x3310b055015a94a2f2e37014b944d8ca6bd2b8450xe4f09e773d5102e6473f12b1a89b21cc08fd2efb0x14d022e79e522242d96f559c7be729b294bfd9671154c07a2eccd8b6fc47c7f5
0x8fd3121013a07c57f0d69646e86e7a4880b467b7false38466153909123015761059090x4e15361fd6b4bb609fa63c81a2be19d8737178700x000000000000000000000000000000000000000012229753032367633000001000000000000000002019-12-11T23:07:56.000Z0x195ac57ae67f36d1aaaa2409d972f7e7b25820280xaae90a192247377c121b6469baffeb99b3ffd28a0x53050d655d008e0f1b4645f28b09c1ad8d83d7bf38e3c4b4b264414b0168f1f2
0x8fd3121013a07c57f0d69646e86e7a4880b467b7false144213533349283285912233557179198520032683543174108554728900000157608766932909003415760878190x89d24a6b4ccb1b6faa2625fe562bdd9a232603590x0000000000000000000000000000000000000000100000000000000000070294236131699152019-12-11T18:08:14.000Z0xc6093fd9cc143f9f058938868b2df2daf9a91d280xd0c81e82abddf29c6505d660f5bebe60cdff03c50x6f2de0aa0a13b0927f45e89ed00578fd619fab319b74c5cf7c41e06bee19e563
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