airswap_v2_ethereum

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.

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 signer (market maker) for executing this swap, denominated in basis points. Always “7” in sample data, representing 0.07% of the trade value.
`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

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
0xc549a5c701cb6e6cbc091007a80c089c49595468	false	1633292921291	523	13359312	7	1633439946	0x6b175474e89094c44da98b954eedeac495271d0f	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2021-10-05T13:19:06.000Z	1191809831214911959295	0x74de5d4fcbf63e00296fd95d33236b9794016631	352299023344183552	0x00000000000080c886232e9b7ebbfb942b5987aa	0x3bee4c35ae7cbfd030e223c91bd3804b68db99babef29b082732a3aefaa01ab0
0xc549a5c701cb6e6cbc091007a80c089c49595468	false	1633292921648	332	13359454	7	1633442170	0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	2021-10-05T13:56:10.000Z	26220557833625474145	0x74de5d4fcbf63e00296fd95d33236b9794016631	1165715777055504603	0x00000000000080c886232e9b7ebbfb942b5987aa	0xe3e787624eeeb6db9a79285db0bac0cc4ef8af8a2978a837c454fdf5092d0091
0xc549a5c701cb6e6cbc091007a80c089c49595468	false	1633292921059	227	13359172	7	1633438001	0x8798249c2e607446efb7ad49ec89dd1865ff4272	0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2	2021-10-05T12:46:41.000Z	16078015528345638116	0x74de5d4fcbf63e00296fd95d33236b9794016631	58668795749089582	0x00000000000080c886232e9b7ebbfb942b5987aa	0xd2f9d431fb08c51cd142c6094c76574eaf37b6fe0afff63fdc920f536283d5ee

Example Query

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.

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_senderWallet`	`STRING`	Wallet address of the sender 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_senderToken`	`STRING`	Contract address of the token being provided by the sender 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_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

address	removed	in_nonce	log_index	block_number	in_timestamp	in_senderToken	in_signerToken	block_timestamp	in_senderAmount	in_senderWallet	in_signerAmount	in_signerWallet	transaction_hash
0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3	false	1613665516	94	11881893	1613665533	0x6b175474e89094c44da98b954eedeac495271d0f	0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e	2021-02-18T16:25:33.000Z	3988000000000000000000	0x74de5d4fcbf63e00296fd95d33236b9794016631	90324944741172850	0xa5d07e978398eb1715056d3ca5cb31035c02fdad	0xbd09ccd9ef3cb9cfc9178f5b003247576fe0ea053171e33def3ce0694b6871d1
0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3	false	1613625954	242	11878922	1613625982	0x6b175474e89094c44da98b954eedeac495271d0f	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	2021-02-18T05:26:22.000Z	997000000000000000000	0x74de5d4fcbf63e00296fd95d33236b9794016631	45237963238621710000	0xa5d07e978398eb1715056d3ca5cb31035c02fdad	0x21ce810159bdfd46ea7566c5d67f384c40b7bf6325fa42d529aa416a7e8aeade
0xc50cb225e0f45e814fd41bcb3a120463ab1f04c3	false	1613629531	225	11879190	1613629607	0x6b175474e89094c44da98b954eedeac495271d0f	0x1f9840a85d5af5bf1d1762f925bdaddc4201f984	2021-02-18T06:26:47.000Z	21934000000000000000	0x74de5d4fcbf63e00296fd95d33236b9794016631	1003298862417408200	0xa5d07e978398eb1715056d3ca5cb31035c02fdad	0x5250bd9c19edc6ea8fb9d5a53b618d1d940951a0d7eae91b9e866ed6e70601e3

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

Light_Swap_event

Light_v0_Swap_event

​Tables

​Light_Swap_event

​Light_v0_Swap_event

Tables

Light_Swap_event

Light_v0_Swap_event