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_signerTokenSTRINGContract address of the token being provided by the order signer in the swap. 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_protocolFeeSTRINGFee collected by the protocol from the transaction or operation. Numeric string representation without decimals.
in_senderWalletSTRINGWallet address of the sender in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string.
in_senderTokenSTRINGContract address of the token being provided by the sender in the swap. 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.
addressremovedin_noncelog_indexblock_numberin_timestampin_protocolFeein_senderTokenin_signerTokenblock_timestampin_senderAmountin_senderWalletin_signerAmountin_signerWallettransaction_hash
0x522d6f36c95a1b6509a14272c17747bbb582f2a6false167640086969019716638698167651915970x5283d291dbcf85356a21ba090e6db59121208b440x15d4c048f83bd7e37d49ea4c83a07267ec4203da2023-02-16T03:45:59.000Z4052446524541408000000x74de5d4fcbf63e00296fd95d33236b97940166319162352976170xaf0b0000f0210d0f421f0009c72406703b50506b0xdba333a3c7ba43d0605368285d61423974c149ec55581bffc061445a980ea6a5
0x522d6f36c95a1b6509a14272c17747bbb582f2a6false16764009434499816642530167656547970x7d1afa7b718fb893db30a3abc0cfc608aacfebb00x15d4c048f83bd7e37d49ea4c83a07267ec4203da2023-02-16T16:37:59.000Z8962907100000000000000x74de5d4fcbf63e00296fd95d33236b979401663125300477307310xaf0b0000f0210d0f421f0009c72406703b50506b0x287c09ec341dd998bdc5c4f4620c1c6c2a3978f6a0e1e73c2a38f58dfbc7759b
0x522d6f36c95a1b6509a14272c17747bbb582f2a6false16764009438869516642555167656577970xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb480x15d4c048f83bd7e37d49ea4c83a07267ec4203da2023-02-16T16:42:59.000Z148885500000x74de5d4fcbf63e00296fd95d33236b9794016631296720116474280xaf0b0000f0210d0f421f0009c72406703b50506b0x27c0a3ec787daa00f82d7fad7661939a422a8611b77e464a53d7766c2627a7cd
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v3_ethereum.Swap_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100