debridge_v1_ethereum

Tables

DeBridgeGate_PairAdded_event

Event logs recording cross-chain token pair registrations in the deBridge protocol. Contains token addresses, chain identifiers, bridge IDs, maximum transfer amounts, and minimum reserve basis points for each paired asset configuration.

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_debridgeId`	`STRING`	Unique identifier for the deBridge cross-chain bridge pairing or transaction. 66-character hex string including 0x prefix.
`in_tokenAddress`	`STRING`	Token contract address for the asset involved in the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_nativeAddress`	`STRING`	Token address on the original source blockchain for cross-chain bridge operations. Hex-encoded string format varies by blockchain implementation.
`in_nativeChainId`	`STRING`	Blockchain identifier for the token’s native chain in deBridge cross-chain operations. Decimal string representation of the chain ID where the asset originates.
`in_maxAmount`	`STRING`	Maximum allowable amount for the bridge operation. Decimal string representation of a uint256 value.
`in_minReservesBps`	`STRING`	Minimum reserve requirement expressed in basis points (BPS). Decimal string representation of an integer value where 10000 equals 100%.

Sample Data

address	removed	log_index	block_number	in_maxAmount	in_debridgeId	block_timestamp	in_tokenAddress	in_nativeAddress	in_nativeChainId	transaction_hash	in_minReservesBps
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	357	17773235	115792089237316195423570985008687907853269984665640564039457584007913129639935	0xe78e9bdc059565b1adaf86a620b813f93a586858098816a26e047c6d0c2ddc08	2023-07-25T22:59:11.000Z	0xcfaf3dba84233bdd2121e8f807b0f034770279bf	0xe5d7c2a44ffddf6b295a15c148167daaaf5cf34f	59144	0x32bcde184d6f511fdd23c6ff55e379aa1fb354a7dcf52e57a627f7a149dc3a47	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	67	16935577	115792089237316195423570985008687907853269984665640564039457584007913129639935	0xe3d57952b827609bce0c0f1dc3a6a056d4e1ba68c9bb241e2aba793c7e927be3	2023-03-29T21:22:11.000Z	0x429881672b9ae42b8eba0e26cd9c73711b891ca5	0x429881672b9ae42b8eba0e26cd9c73711b891ca5	1	0x0dda4974b7ff48a42eb94a09c72857767887af7deadf677b3eb1ff13f2ac229a	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	157	14455976	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x61104bbb33397d345e92c2352b587d9d1661e63a008409fd4304a0e8889c86c2	2022-03-25T14:27:10.000Z	0xac51066d7bec65dc4589368da368b212745d63e8	0xac51066d7bec65dc4589368da368b212745d63e8	1	0xc25a4377ec769676362376b8f96bbea8e2938423306db59217ba7ef5791f73da	10000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_ethereum.DeBridgeGate_PairAdded_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DeBridgeGate_Sent_event

Cross-chain bridge transfer initiation events emitted by the deBridge protocol. Records outbound asset transfers with source sender, destination chain identifier, receiver address, transfer amounts, fee parameters, and unique submission identifier for tracking cross-chain transactions.

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_submissionId`	`STRING`	Unique identifier for the cross-chain bridge submission. 66-character hex string including 0x prefix.
`in_debridgeId`	`STRING`	Unique identifier for the deBridge cross-chain bridge pairing or transaction. 66-character hex string including 0x prefix.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_nonce`	`STRING`	Unique numeric identifier for an order, transaction, or operation used to prevent replay attacks. Numeric string representation without leading zeros.
`in_chainIdTo`	`STRING`	Destination blockchain identifier for the cross-chain bridge transaction. Numeric string representation of the chain ID.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
`in_feeParams`	`STRUCT<receivedAmount STRING, fixFee STRING, transferFee STRING, useAssetFee BOOL, isNativeToken BOOL>`	Fee structure and payment details for the cross-chain bridge transaction. Contains receivedAmount (total tokens after fees), fixFee (base fee in wei), transferFee (variable fee in smallest denomination), useAssetFee (whether fees are paid in bridged asset), and isNativeToken (whether bridged asset is the chain’s native token).
`in_autoParams`	`STRING`	Automation parameters for cross-chain bridge execution. Hex-encoded byte string containing encoded configuration data for automated processing on the destination chain.
`in_nativeSender`	`STRING`	Address that initiated the cross-chain bridge transaction on the source blockchain. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_nonce	in_amount	log_index	in_receiver	block_number	in_chainIdTo	in_feeParams	in_autoParams	in_debridgeId	block_timestamp	in_nativeSender	in_referralCode	in_submissionId	transaction_hash
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	10248	4513013538	267	0x413dddce3d0ead2489648e482d192a7758c2b1b4	16289722	56	{“fixFee”:“1000000000000000”,“transferFee”:“4519934”,“useAssetFee”:false,“isNativeToken”:true,“receivedAmount”:“4519934877”}	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000024a47d0000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014218f304f1b43d40f01f60f0294727a59afdc37df0000000000000000000000000000000000000000000000000000000000000000000000000000000000000588000dc8afb64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000055d398326f99059ff775485246999027b3197955000000000000000000000000218f304f1b43d40f01f60f0294727a59afdc37df00000000000000000000000000000000000000000000000000000000000004a87c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa00000000000000000000000055d398326f99059ff775485246999027b319795500000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000218f304f1b43d40f01f60f0294727a59afdc37df000000000000000000000000000000000000000000000000000000010cff1f210000000000000000000000000000000000000000000000eb646f8e1b122800fa00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002ee0000000000000000000000000000000000000002b000028200023800001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa00a007e5c0d20000000000000000000000000000000000000000000001fa0000ca0000b051205a7d2f9595ea00938f3b5ba1f97a85274f20b96c1ddcaa4ed761428ae348befc6718bcb12e63bfaa0044a6417ed600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010020d6bdbf78e9e7cea3dedca5984780bafc599bd69add087d5651264ec3432d9443f05022e2ff4e54fc7514be2359e0e9e7cea3dedca5984780bafc599bd69add087d56000438ed17390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000a000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f0000000000000000000000000000000000000000000000000000000063b3fea80000000000000000000000000000000000000000000000000000000000000002000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d5600000000000000000000000055d398326f99059ff775485246999027b319795500a0f2fa6b6655d398326f99059ff775485246999027b31979550000000000000000000000000000000000000000000000f53349895c32e9abb000000000000000008aa00e0193a05e0180a06c4eca2755d398326f99059ff775485246999027b31979551111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000000010cff1f21000000000000000000000000000000000000a36e5de7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2022-12-29T10:08:59.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	4350	0x975049a20ee8ae2d52cc85f98f9f453f029bab20033a29025b4df1f036d0052e	0x41670d1669f4050a704988698eb4f007b8245df841e33a9613b4929180be93f7
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	10255	34700225470	175	0x413dddce3d0ead2489648e482d192a7758c2b1b4	16291616	56	{“fixFee”:“1000000000000000”,“transferFee”:“34736947”,“useAssetFee”:false,“isNativeToken”:true,“receivedAmount”:“34736947004”}	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000001e484b0000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014cc2d804590b2f7abb8c3b4cce016158814ef2b8900000000000000000000000000000000000000000000000000000000000000000000000000000000000003e8000b540db64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d56000000000000000000000000cc2d804590b2f7abb8c3b4cce016158814ef2b8900000000000000000000000000000000000000000000000000000000000003087c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d5600000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000cc2d804590b2f7abb8c3b4cce016158814ef2b8900000000000000000000000000000000000000000000000000000008144b6bbd000000000000000000000000000000000000000000000710a8ee70b5d020a24c00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001500000000000000000000000000000000000000001120000e40000ca00001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa51205a7d2f9595ea00938f3b5ba1f97a85274f20b96c1ddcaa4ed761428ae348befc6718bcb12e63bfaa0044a6417ed600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010020d6bdbf78e9e7cea3dedca5984780bafc599bd69add087d5680a06c4eca27e9e7cea3dedca5984780bafc599bd69add087d561111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000008144b6bbd00000000000000000000000000000000a36e5de7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2022-12-29T16:29:59.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	4350	0x094f7fa98668250a1a6d9fbec636aa71b431853eb4c0f9f2a67881c47f1618ec	0xa9f3a82beee7275b5a862bf21c1fc9b657f778c7e788e448b84a43ec91b8530e
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	10250	1035144694	120	0x413dddce3d0ead2489648e482d192a7758c2b1b4	16290357	56	{“fixFee”:“1000000000000000”,“transferFee”:“1038418”,“useAssetFee”:false,“isNativeToken”:true,“receivedAmount”:“1038418026”}	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000221a220000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000001464fef03995be3438316711b87e76d41de4787dc600000000000000000000000000000000000000000000000000000000000000000000000000000000000004c8000cc54ab64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000064fef03995be3438316711b87e76d41de4787dc600000000000000000000000000000000000000000000000000000000000003e87c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f00000000000000000000000064fef03995be3438316711b87e76d41de4787dc6000000000000000000000000000000000000000000000000000000003db576ce00000000000000000000000000000000000000000000000038b84edc86e30e7300000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002300000000000000000000000000000000000000001f20001dc00019200001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa00a007e5c0d20000000000000000000000000000000000000001540001180000ca0000b051205a7d2f9595ea00938f3b5ba1f97a85274f20b96c1ddcaa4ed761428ae348befc6718bcb12e63bfaa0044a6417ed600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010020d6bdbf78e9e7cea3dedca5984780bafc599bd69add087d5648200fe261aee0d1c4dfddee4102e82dd425999065f4e9e7cea3dedca5984780bafc599bd69add087d56dd93f59a00000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f4101bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00042e1a7d4d000000000000000000000000000000000000000000000000000000000000000000a0f2fa6b66eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000000000000000000000000003a7963c650ff313500000000000000000090ac072fbcec74c0611111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000000003db576ce00000000000000000000000000000000a36e5de7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2022-12-29T12:16:47.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	0	0x49ba1a0a1f0ae49404ee3264259420c7cb9429bd039471b6ebb36d4dc00750ce	0x60612dc296df2b06dcf5bc6833d563207baa4973af90e9d5045406717b35c651

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_ethereum.DeBridgeGate_Sent_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DlnSource_ClaimedUnlock_event

DeBridge DlnSource (Decentralized Liquidity Network Source) ClaimedUnlock event emitted when an order creator claims their original tokens after a cross-chain order cancellation or unlock. Records the order identifier, token amount returned, token contract address, and beneficiary receiving the unlocked funds.

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_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_beneficiary`	`STRING`	Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_giveAmount`	`STRING`	Amount of tokens being transferred or unlocked in the operation. String-encoded integer value representing the token quantity in its smallest unit.
`in_giveTokenAddress`	`STRING`	Contract address of the token being given or unlocked in the cross-chain bridge operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	in_orderId	block_number	in_giveAmount	in_beneficiary	block_timestamp	transaction_hash	in_giveTokenAddress
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	377	0x2d9dc5988f40ae3758aee070da6a0eee0bd2a430e6ac1d1d20dd3e1329f1e47a	18582906	509747778	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-11-16T07:18:47.000Z	0x1750081d2530265aa682357faf3581956a59ea39ae6a6560a2bb2d83189daf40	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	379	0x4a2c1912d3f567fb26c9087e42e47f5998b9bdebc63592e7270c159ee35adf3b	18582906	249900000	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-11-16T07:18:47.000Z	0x1750081d2530265aa682357faf3581956a59ea39ae6a6560a2bb2d83189daf40	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	381	0x81a1975ed47c343836c7fa93d32a0532974e9facb3d0a1fa11557b15ee7af939	18582906	4107281948	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-11-16T07:18:47.000Z	0x1750081d2530265aa682357faf3581956a59ea39ae6a6560a2bb2d83189daf40	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_ethereum.DlnSource_ClaimedUnlock_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DlnSource_CreatedOrder_event

Cross-chain order creation events from deBridge DLN (Deswap Liquidity Network) source contracts containing Request-for-Quote (RFQ) order parameters, fee structures, and routing metadata. Used for tracking intent-based cross-chain swap requests and order lifecycle analytics.

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_order`	`STRUCT<makerOrderNonce STRING, makerSrc STRING, giveChainId STRING, giveTokenAddress STRING, giveAmount STRING, takeChainId STRING, takeTokenAddress STRING, takeAmount STRING, receiverDst STRING, givePatchAuthoritySrc STRING, orderAuthorityAddressDst STRING, allowedTakerDst STRING, allowedCancelBeneficiarySrc STRING, externalCall STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_nativeFixFee`	`STRING`	Fixed fee amount denominated in the chain’s native token. String-encoded integer representing the fee charged in wei (for EVM chains) or smallest token unit.
`in_percentFee`	`STRING`	Percentage-based fee amount charged on the order. String-encoded integer representing the fee in basis points or smallest fee unit.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.
`in_metadata`	`STRING`	Metadata payload associated with the operation. Hex-encoded bytes containing protocol-specific auxiliary data such as action identifiers, addresses, amounts, and configuration parameters.

Sample Data

address	removed	in_order	log_index	in_orderId	in_metadata	block_number	in_percentFee	block_timestamp	in_affiliateFee	in_nativeFixFee	in_referralCode	transaction_hash
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x676628a8b5e33d59e79d32870e73851b1c58c0d8”,“giveAmount”:“249900000000000000”,“takeAmount”:“247610894076285407”,“giveChainId”:“1”,“receiverDst”:“0x676628a8b5e33d59e79d32870e73851b1c58c0d8”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x676628a8b5e33d59e79d32870e73851b1c58c0d8”,“orderAuthorityAddressDst”:“0x676628a8b5e33d59e79d32870e73851b1c58c0d8”,“allowedCancelBeneficiarySrc”:“0x”}	117	0xc20d0bef4be36c22e7a274afd54344030887c7b244ce14514e11509475583200	0x	18229002	100000000000000	2023-09-27T18:52:35.000Z	0x	1000000000000000	0	0x3a8c87ebf00dda07e644e23d99cedd13df6ce20b12aff21e14cd3f2db245e35b
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0xfe0ccdbc3ba03a54e7e942a2a932dda7ca7d98e7”,“giveAmount”:“79888000000000000”,“takeAmount”:“245634174323225869667”,“giveChainId”:“1”,“receiverDst”:“0xfe0ccdbc3ba03a54e7e942a2a932dda7ca7d98e7”,“takeChainId”:“137”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xfe0ccdbc3ba03a54e7e942a2a932dda7ca7d98e7”,“orderAuthorityAddressDst”:“0xfe0ccdbc3ba03a54e7e942a2a932dda7ca7d98e7”,“allowedCancelBeneficiarySrc”:“0x”}	208	0xdeebea1e5be6ef7eaa5a3c7e3e84755f0fd6c7eeebb2cb85ce9fbd08f3c7bf96	0x	18225954	32000000000000	2023-09-27T08:37:47.000Z	0x68cc4ff62a37eee0be1fa3ce49c9cf53244f70a9000000000000000000000000000000000000000000000000000048c273950000	1000000000000000	4753	0x35fe292ef310d1ed5761f2d5fe2f8f6131e8f24ae89be6975e799c6dd9bbb5f3
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x18aa33e23ea5aef2efbda65939449c1dd2d229ca”,“giveAmount”:“102425254664002232”,“takeAmount”:“161689414747135350392”,“giveChainId”:“1”,“receiverDst”:“0x18aa33e23ea5aef2efbda65939449c1dd2d229ca”,“takeChainId”:“56”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x55d398326f99059ff775485246999027b3197955”,“givePatchAuthoritySrc”:“0x18aa33e23ea5aef2efbda65939449c1dd2d229ca”,“orderAuthorityAddressDst”:“0x18aa33e23ea5aef2efbda65939449c1dd2d229ca”,“allowedCancelBeneficiarySrc”:“0x”}	251	0x063afe868888918d2533ec4cb88ae88c765344a57b730214458aaf445222796a	0x	18227145	41068666665598	2023-09-27T12:38:35.000Z	0xdf9c09f9332669f6a5b06df53a342a66d7ce76670000000000000000000000000000000000000000000000000000bac23870a478	1000000000000000	4844	0xbe5b06855497754513e7725160dbfad3cadeefaab79dfa4eddce43b0c48210e8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_ethereum.DlnSource_CreatedOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

DlnSourceV1_CreatedOrder_event

Cross-chain order creation events from DeBridge’s DLN (Debridge Liquidity Network) RFQ (Request-for-Quote) protocol. Contains order parameters including source/destination chains, token addresses, amounts, fees, maker addresses, and order identifiers for tracking cross-chain token swaps.

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_order`	`STRUCT<makerOrderNonce STRING, makerSrc STRING, giveChainId STRING, giveTokenAddress STRING, giveAmount STRING, takeChainId STRING, takeTokenAddress STRING, takeAmount STRING, receiverDst STRING, givePatchAuthoritySrc STRING, orderAuthorityAddressDst STRING, allowedTakerDst STRING, allowedCancelBeneficiarySrc STRING, externalCall STRING>`	Request-for-Quote (RFQ) order details structure containing maker and taker information. Structure includes token addresses for assets being exchanged, maker address, allowed sender address, and token amounts for both maker and taker sides of the trade.
`in_orderId`	`STRING`	Unique identifier for the order within the protocol. String-encoded value used to track and reference specific orders across operations.
`in_affiliateFee`	`STRING`	Fee paid to an affiliate for referring the transaction. Hex-encoded bytes value representing the affiliate address and fee amount.
`in_nativeFixFee`	`STRING`	Fixed fee amount denominated in the chain’s native token. String-encoded integer representing the fee charged in wei (for EVM chains) or smallest token unit.
`in_percentFee`	`STRING`	Percentage-based fee amount charged on the order. String-encoded integer representing the fee in basis points or smallest fee unit.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_order	log_index	in_orderId	block_number	in_percentFee	block_timestamp	in_affiliateFee	in_nativeFixFee	in_referralCode	transaction_hash
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x92a79e4e848f95a37f1d6af0a898f82246a38f00”,“giveAmount”:“27229558285870473”,“takeAmount”:“24978211994898589”,“giveChainId”:“1”,“receiverDst”:“0x92a79e4e848f95a37f1d6af0a898f82246a38f00”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x92a79e4e848f95a37f1d6af0a898f82246a38f00”,“orderAuthorityAddressDst”:“0x92a79e4e848f95a37f1d6af0a898f82246a38f00”,“allowedCancelBeneficiarySrc”:“0x”}	131	0x1be9e978b15f69940bbb659332639b6c6082693a02cf7bd5aa84a6b9d797e4bb	17997539	10896181787063	2023-08-26T08:05:47.000Z	0x	1000000000000000	0	0x0f3d5a4815589b3a4115a8d367554c567a9acf5f551cce2d69eafcd901d088f8
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x19e2dc0bf4069a0574072d0eb3564cbd774eef3d”,“giveAmount”:“735279136042000000”,“takeAmount”:“733035034672470254”,“giveChainId”:“1”,“receiverDst”:“0x19e2dc0bf4069a0574072d0eb3564cbd774eef3d”,“takeChainId”:“56”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“givePatchAuthoritySrc”:“0x19e2dc0bf4069a0574072d0eb3564cbd774eef3d”,“orderAuthorityAddressDst”:“0x19e2dc0bf4069a0574072d0eb3564cbd774eef3d”,“allowedCancelBeneficiarySrc”:“0x”}	140	0x22f25d8907cde40b3b23a19f3d377b4d513ab3239afe47ea7af79611213662cb	18000479	294523988000000	2023-08-26T17:57:35.000Z	0x68cc4ff62a37eee0be1fa3ce49c9cf53244f70a900000000000000000000000000000000000000000000000000029dab8634d880	1000000000000000	4753	0x4f45bbce2eb1b2da4c8cdbb9393eb252e407fa669c29b3b50f8853dbeb0d7440
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0xa303b4fc63f2afe3877964c31d3f4d89597d9575”,“giveAmount”:“20605242218000000”,“takeAmount”:“137646162130241204”,“giveChainId”:“1”,“receiverDst”:“0xa303b4fc63f2afe3877964c31d3f4d89597d9575”,“takeChainId”:“56”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“0”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0xa303b4fc63f2afe3877964c31d3f4d89597d9575”,“orderAuthorityAddressDst”:“0xa303b4fc63f2afe3877964c31d3f4d89597d9575”,“allowedCancelBeneficiarySrc”:“0x”}	80	0xd5d354e8dc76e5b4d8f8affe98c03f698aa8dccdbf8cf26cb4967106f1d6001c	17998618	8253652000000	2023-08-26T11:43:47.000Z	0x68cc4ff62a37eee0be1fa3ce49c9cf53244f70a9000000000000000000000000000000000000000000000000000012c441fd2880	1000000000000000	4753	0xe0c36864e9f341d4cffe7bd702807bc20c1fbc9d3405dcb2c0c7a430d75fcc67

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_ethereum.DlnSourceV1_CreatedOrder_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

DeBridgeGate_PairAdded_event

DeBridgeGate_Sent_event

DlnSource_ClaimedUnlock_event

DlnSource_CreatedOrder_event

DlnSourceV1_CreatedOrder_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​DeBridgeGate_PairAdded_event

​DeBridgeGate_Sent_event

​DlnSource_ClaimedUnlock_event

​DlnSource_CreatedOrder_event

​DlnSourceV1_CreatedOrder_event

Tables

DeBridgeGate_PairAdded_event

DeBridgeGate_Sent_event

DlnSource_ClaimedUnlock_event

DlnSource_CreatedOrder_event

DlnSourceV1_CreatedOrder_event