Skip to main content

​
Tables

​
Light_Swap_event

Swap events from AirSwap v2 Light protocol on Ethereum capturing peer-to-peer token trades between signers and senders. Records include traded token addresses, amounts, fees, and wallet addresses for analyzing decentralized OTC (over-the-counter) trading activity.
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 signer (market maker) for executing this swap, denominated in basis points. Always “7” in sample data, representing 0.07% of the trade value.
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
0xc549a5c701cb6e6cbc091007a80c089c49595468false163329292129152313359312716334399460x6b175474e89094c44da98b954eedeac495271d0f0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc22021-10-05T13:19:06.000Z11918098312149119592950x74de5d4fcbf63e00296fd95d33236b97940166313522990233441835520x00000000000080c886232e9b7ebbfb942b5987aa0x3bee4c35ae7cbfd030e223c91bd3804b68db99babef29b082732a3aefaa01ab0
0xc549a5c701cb6e6cbc091007a80c089c49595468false163329292164833213359454716334421700x7d1afa7b718fb893db30a3abc0cfc608aacfebb00x1f9840a85d5af5bf1d1762f925bdaddc4201f9842021-10-05T13:56:10.000Z262205578336254741450x74de5d4fcbf63e00296fd95d33236b979401663111657157770555046030x00000000000080c886232e9b7ebbfb942b5987aa0xe3e787624eeeb6db9a79285db0bac0cc4ef8af8a2978a837c454fdf5092d0091
0xc549a5c701cb6e6cbc091007a80c089c49595468false163329292105922713359172716334380010x8798249c2e607446efb7ad49ec89dd1865ff42720xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc22021-10-05T12:46:41.000Z160780155283456381160x74de5d4fcbf63e00296fd95d33236b9794016631586687957490895820x00000000000080c886232e9b7ebbfb942b5987aa0xd2f9d431fb08c51cd142c6094c76574eaf37b6fe0afff63fdc920f536283d5ee
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v2_ethereum.Light_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
Light_v0_Swap_event

Swap execution events from AirSwap v2 Light protocol on Ethereum, recording peer-to-peer token trades between signers and senders with amounts, wallet addresses, and nonce-based order tracking. Used for analyzing decentralized OTC trading patterns and liquidity provider activity.
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_senderWalletSTRINGWallet address of the sender 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_senderTokenSTRINGContract address of the token being provided by the sender 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_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_senderTokenin_signerTokenblock_timestampin_senderAmountin_senderWalletin_signerAmountin_signerWallettransaction_hash
0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3false1613665516941188189316136655330x6b175474e89094c44da98b954eedeac495271d0f0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e2021-02-18T16:25:33.000Z39880000000000000000000x74de5d4fcbf63e00296fd95d33236b9794016631903249447411728500xa5d07e978398eb1715056d3ca5cb31035c02fdad0xbd09ccd9ef3cb9cfc9178f5b003247576fe0ea053171e33def3ce0694b6871d1
0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3false16136259542421187892216136259820x6b175474e89094c44da98b954eedeac495271d0f0x1f9840a85d5af5bf1d1762f925bdaddc4201f9842021-02-18T05:26:22.000Z9970000000000000000000x74de5d4fcbf63e00296fd95d33236b9794016631452379632386217100000xa5d07e978398eb1715056d3ca5cb31035c02fdad0x21ce810159bdfd46ea7566c5d67f384c40b7bf6325fa42d529aa416a7e8aeade
0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3false16136295312251187919016136296070x6b175474e89094c44da98b954eedeac495271d0f0x1f9840a85d5af5bf1d1762f925bdaddc4201f9842021-02-18T06:26:47.000Z219340000000000000000x74de5d4fcbf63e00296fd95d33236b979401663110032988624174082000xa5d07e978398eb1715056d3ca5cb31035c02fdad0x5250bd9c19edc6ea8fb9d5a53b618d1d940951a0d7eae91b9e866ed6e70601e3
Query with partition filter
SELECT *
FROM `tt-contracts.airswap_v2_ethereum.Light_v0_Swap_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100