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.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_protocolFee | STRING | Fee collected by the protocol from the transaction or operation. Numeric string representation without decimals. |
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_timestamp | in_protocolFee | in_senderToken | in_signerToken | block_timestamp | in_senderAmount | in_senderWallet | in_signerAmount | in_signerWallet | transaction_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0x6713c23261c8a9b7d84dd6114e78d9a7b9863c1a | false | 1671309444 | 182 | 36952391 | 1671309453 | 7 | 0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270 | 0xc2132d05d31c914a87c6611c10748aeb04b58e8f | 2022-12-17T20:37:33.000Z | 2977710000000000000 | 0xc590175e458b83680867afd273527ff58f74c02b | 2380923 | 0x945bcf562085de2d5875b9e2012ed5fd5cfab927 | 0xd7a86947ce798f811b76d8dd315480953563f3469810d966ec379e6aa5072c89 |
| 0x6713c23261c8a9b7d84dd6114e78d9a7b9863c1a | false | 1671313306 | 227 | 36954141 | 1671313318 | 7 | 0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270 | 0xc2132d05d31c914a87c6611c10748aeb04b58e8f | 2022-12-17T21:41:58.000Z | 9925700000000000 | 0xc590175e458b83680867afd273527ff58f74c02b | 7964 | 0x945bcf562085de2d5875b9e2012ed5fd5cfab927 | 0xd58247abc16cf1abf48a03a5efa3cb4262675b6d41dc2b6c6a358ff62412e1ab |
| 0x6713c23261c8a9b7d84dd6114e78d9a7b9863c1a | false | 1671256844 | 296 | 36927970 | 1671256861 | 7 | 0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270 | 0xc2132d05d31c914a87c6611c10748aeb04b58e8f | 2022-12-17T06:01:01.000Z | 9925700000000000000 | 0xc590175e458b83680867afd273527ff58f74c02b | 7995063 | 0x945bcf562085de2d5875b9e2012ed5fd5cfab927 | 0x5f1ba6bc0a657cde39de43eba3a2969dafcd92bd66caff99f78e7ad9f90489fa |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v3_polygon.Swap_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100