Skip to main content

​
Tables

​
Light_Swap_event

Peer-to-peer token swap events from AirSwap v2 Light protocol on Binance Smart Chain, recording sender/signer wallet addresses, token amounts, and fees for each bilateral trade. Used to analyze decentralized over-the-counter trading activity and liquidity provision patterns.
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_signerFeeSTRINGFee amount charged by the market maker (signer) for executing this swap. Denominated in the smallest unit of the signer’s token, typically basis points when divided by token amount.
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_signerFeein_timestampin_senderTokenin_signerTokenblock_timestampin_senderAmountin_senderWalletin_signerAmountin_signerWallettransaction_hash
0xc98314a5077dba8f12991b29bce39f834e82e197false164665354571315850447716466535730x2170ed0880ac9a755fd29b2688956bd959f933f80x55d398326f99059ff775485246999027b31979552022-03-07T11:46:13.000Z53096232000000000xc590175e458b83680867afd273527ff58f74c02b134424592686120650000x945bcf562085de2d5875b9e2012ed5fd5cfab9270xbb571c5556e7c32fd24367682098c7e917b79e6827a0cd52ced7f93e8a77b80f
0xc98314a5077dba8f12991b29bce39f834e82e197false164661777852915838558716466177860x2170ed0880ac9a755fd29b2688956bd959f933f80x55d398326f99059ff775485246999027b31979552022-03-07T01:49:46.000Z5405392910873785460xc590175e458b83680867afd273527ff58f74c02b13757206133751383000000x111bb8c3542f2b92fb41b8d913c01d37884311110x87d0af112da080948da261c53277b3f43d78f261de1b6f9a9b12cf6a56908d81
0xc98314a5077dba8f12991b29bce39f834e82e197false164664411352915847302716466441250x2170ed0880ac9a755fd29b2688956bd959f933f80x55d398326f99059ff775485246999027b31979552022-03-07T09:08:45.000Z498500000000000000xc590175e458b83680867afd273527ff58f74c02b1265611566643349400000x111bb8c3542f2b92fb41b8d913c01d37884311110x50e7cfdf630c6f9ad7028664e10efda8092c53c4b5e0e1235308d25dde903ad2
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v2_bsc.Light_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100