Skip to main content

​
Tables

​
Swap_Swap_event

Executed swap events recording bilateral token exchanges between sender and signer wallets. Contains token addresses, exchange amounts, nonces for replay protection, and optional protocol fees or affiliate compensation depending on contract version.
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_nonceSTRINGUnique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
in_timestampSTRINGUnix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch.
in_signerWalletSTRINGWallet address of the order signer in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_signerAmountSTRINGAmount 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_signerIdSTRINGUser-defined identifier for the signer party in the swap, typically set to zero in standard transactions. This field allows for optional categorization or grouping of signer addresses within the AirSwap protocol.
in_signerTokenSTRINGContract address of the token being provided by the order signer in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_senderWalletSTRINGWallet address of the sender in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_senderAmountSTRINGAmount of tokens provided by the sender in the swap transaction. Numeric string representation without decimals, denominated in the smallest unit of the sender token.
in_senderIdSTRINGIdentifier for the sender party in the AirSwap peer-to-peer swap transaction. Typically set to ‘0’ in standard swaps, as seen across all sample transactions.
in_senderTokenSTRINGContract address of the token being provided by the sender in the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_affiliateWalletSTRINGWallet address of the affiliate who facilitated or referred this swap transaction. Appears as zero address when no affiliate was involved in the trade.
in_affiliateAmountSTRINGToken amount paid to the affiliate as a fee for facilitating the swap, denominated in the smallest unit of the affiliate token. Zero when no affiliate fee is charged for the transaction.
in_affiliateIdSTRINGUnique identifier for the affiliate party in the AirSwap trade, typically ‘0’ when no affiliate referral is involved. This field allows tracking of trades attributed to specific affiliate partners in the AirSwap protocol.
in_affiliateTokenSTRINGContract address of the affiliate’s fee token in the swap transaction. Zero address (0x0…0) indicates no affiliate fee was charged for this swap.
addressremovedin_noncelog_indexin_senderIdin_signerIdblock_numberin_timestampin_affiliateIdin_senderTokenin_signerTokenblock_timestampin_senderAmountin_senderWalletin_signerAmountin_signerWallettransaction_hashin_affiliateTokenin_affiliateAmountin_affiliateWallet
0x4572f2554421bd64bef1c22c8a81840e8d496beafalse16723283136693390016291423167232908300xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20xf8640b0b79c236b0c14f67344b4d203ffcedc7122022-12-29T15:51:23.000Z3530000000000000000x992878fb6d0c74e200aea8620f6506e9841f2a4769451345759000000000000xdd12c40d8eb5837a959890ea72c993e5c6fed7d30x8e810fca6a072c96a5dc4de06aabde36af597def977b1c9b0ba1ba6cd4e7d4000x000000000000000000000000000000000000000000xff98f0052bda391f8fad266685609ffb192bef25
0x4572f2554421bd64bef1c22c8a81840e8d496beafalse1672340185748430016292538167234253500xfcfc434ee5bff924222e084a8876eee74ea7cfba0x6b175474e89094c44da98b954eedeac495271d0f2022-12-29T19:35:35.000Z700000000000000000000x5107ba745f16125d5558b4b14176595b6593715852500000000000000000000x5b335a6b238e13bbd00a7bc04dfe810534da02f70x1ee7b40050631cbd521e9c02975ebae38b5bf52653e03df1eae3c5dbd7a1e9b30x000000000000000000000000000000000000000000xff98f0052bda391f8fad266685609ffb192bef25
0x4572f2554421bd64bef1c22c8a81840e8d496beafalse158842965252736832009987294158842967500xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc20x27054b13b1b798b345b591a4d22e6562d47ea75a2020-05-02T14:27:55.000Z7640000000000000000x21639a426a07498c4e7157ba909f92da2d57ce871000000000x3310b055015a94a2f2e37014b944d8ca6bd2b8450x2e131060ec158e52e204bf9effce806e6d59152b5033aeeb70f65096527c26030x000000000000000000000000000000000000000000x0000000000000000000000000000000000000000
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v1_ethereum.Swap_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100