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.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_number | INT64 | Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain. |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
log_index | INT64 | Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission. |
address | STRING | Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string. |
removed | BOOL | Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization. |
in_nonce | STRING | Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros. |
in_timestamp | STRING | Unix timestamp when the event or operation occurred. Numeric string representation of seconds since epoch. |
in_signerWallet | STRING | Wallet address of the order signer in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_signerToken | STRING | Contract address of the token being provided by the order signer in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_signerAmount | STRING | Amount 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_signerFee | STRING | Fee 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_senderWallet | STRING | Wallet address of the sender in the swap transaction. Hex-encoded, 0x-prefixed, 42-character string. |
in_senderToken | STRING | Contract address of the token being provided by the sender in the swap. Hex-encoded, 0x-prefixed, 42-character string. |
in_senderAmount | STRING | Amount of tokens provided by the sender in the swap transaction. Numeric string representation without decimals, denominated in the smallest unit of the sender token. |
Sample Data
Sample Data
| address | removed | in_nonce | log_index | block_number | in_signerFee | in_timestamp | in_senderToken | in_signerToken | block_timestamp | in_senderAmount | in_senderWallet | in_signerAmount | in_signerWallet | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0xc98314a5077dba8f12991b29bce39f834e82e197 | false | 1646653545 | 713 | 15850447 | 7 | 1646653573 | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x55d398326f99059ff775485246999027b3197955 | 2022-03-07T11:46:13.000Z | 5309623200000000 | 0xc590175e458b83680867afd273527ff58f74c02b | 13442459268612065000 | 0x945bcf562085de2d5875b9e2012ed5fd5cfab927 | 0xbb571c5556e7c32fd24367682098c7e917b79e6827a0cd52ced7f93e8a77b80f |
| 0xc98314a5077dba8f12991b29bce39f834e82e197 | false | 1646617778 | 529 | 15838558 | 7 | 1646617786 | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x55d398326f99059ff775485246999027b3197955 | 2022-03-07T01:49:46.000Z | 540539291087378546 | 0xc590175e458b83680867afd273527ff58f74c02b | 1375720613375138300000 | 0x111bb8c3542f2b92fb41b8d913c01d3788431111 | 0x87d0af112da080948da261c53277b3f43d78f261de1b6f9a9b12cf6a56908d81 |
| 0xc98314a5077dba8f12991b29bce39f834e82e197 | false | 1646644113 | 529 | 15847302 | 7 | 1646644125 | 0x2170ed0880ac9a755fd29b2688956bd959f933f8 | 0x55d398326f99059ff775485246999027b3197955 | 2022-03-07T09:08:45.000Z | 49850000000000000 | 0xc590175e458b83680867afd273527ff58f74c02b | 126561156664334940000 | 0x111bb8c3542f2b92fb41b8d913c01d3788431111 | 0x50e7cfdf630c6f9ad7028664e10efda8092c53c4b5e0e1235308d25dde903ad2 |
Example Query
Example Query
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