Skip to main content

​
Tables

​
SwapERC20_SwapERC20_event

ERC20 token swap execution events containing sender and signer wallet addresses, token contract addresses, exchange amounts, nonces, and protocol fees. Used for tracking decentralized exchange activity and bilateral token trades.
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_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_protocolFeein_senderTokenin_signerTokenblock_timestampin_senderAmountin_senderWalletin_signerAmountin_signerWallettransaction_hash
0xd82fa167727a4dc6d6f55830a2c47abbb4b3a0f8false16892746742854503951270x0d500b1d8e8ef31e21c99d1db9a6444d3adf12700x2791bca1f2de4661ed88a30c99a7a9449aa841742023-07-13T18:58:00.000Z29989420000000000000xc590175e458b83680867afd273527ff58f74c02b25175180x2008b6c3d07b061a84f790c035c2f6dc11a0be700xb03709c6e5d538da46d7dd61d6f7a15b70ed31f4ef8b8d68c5b34a73e24650cb
0xd82fa167727a4dc6d6f55830a2c47abbb4b3a0f8false16892593553384503248670x0d500b1d8e8ef31e21c99d1db9a6444d3adf12700x2791bca1f2de4661ed88a30c99a7a9449aa841742023-07-13T14:43:00.000Z2008820000000000000xc590175e458b83680867afd273527ff58f74c02b1519200x2008b6c3d07b061a84f790c035c2f6dc11a0be700xe16950d892dc0f98f98a55130463bd617c3da85f522f9c42732ab02c82dcdad7
0xd82fa167727a4dc6d6f55830a2c47abbb4b3a0f8false16892590922484503236870x0d500b1d8e8ef31e21c99d1db9a6444d3adf12700x2791bca1f2de4661ed88a30c99a7a9449aa841742023-07-13T14:38:36.000Z1599210000000000000xc590175e458b83680867afd273527ff58f74c02b1208730x2008b6c3d07b061a84f790c035c2f6dc11a0be700xf636f0ca4e1a5619d8f554e2bb07ec3ab0d1d13b2aea4e16f98112bdf8fb0d59
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v4_polygon.SwapERC20_SwapERC20_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100