debridge_v1_arbitrum

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	23	293330375	115792089237316195423570985008687907853269984665640564039457584007913129639935	0xd2fb987c34d51e507889ea018d9db648641fd26355089aa4e9377d1ff149c50e	2025-01-08T16:35:48.000Z	0xdc8af5b11c8cb0aed2f5b9f724b638a655432b60	0x532801ed6f82fffd2dab70a19fc2d7b2772c4f4b	100000002	0x4dfdbf0bd0a27b6c69a665f7b16f63c026ae2cfe6f3ab1c93fa04739d00f87eb	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	1	3245543	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x78c8d09f83f806c7b5a679f99831e432763a4ffbc6a8fa68734ca7d3ef5108b0	2021-11-22T16:47:18.000Z	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	42161	0x6d3d3801460b9bee85a86aca6b95b5a40d3ef31f22ea41675cc12b845b39d204	0
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	14	211133316	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x716704bd99b26a63aa7149b037706243d475bf6855b26983b21b36bb13d76512	2024-05-14T09:31:29.000Z	0x38cbb84ccb80eab6840ad0e13599b16d8edd7e08	0x7fec03a5df1c4f55387f93412b191e966dff4d3129badeab7deeffaaf610d6c6	7565164	0x79318ef7f410692509d71db30394ff051711c3dee067460746c75435abbeede4	10000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_arbitrum.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_submissionId	transaction_hash
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	15546	5113575	25	0x413dddce3d0ead2489648e482d192a7758c2b1b4	53815122	56	{“fixFee”:“1000000000000000”,“transferFee”:“7883”,“useAssetFee”:false,“isNativeToken”:false,“receivedAmount”:“7883783”}	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000002a26550000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000000000143d175889fe6b34dbe67400bd9b3efffbea3287290000000000000000000000000000000000000000000000000000000000000000000000000000000000000488000ccfe9b64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003d175889fe6b34dbe67400bd9b3efffbea32872900000000000000000000000000000000000000000000000000000000000003a87c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f0000000000000000000000003d175889fe6b34dbe67400bd9b3efffbea32872900000000000000000000000000000000000000000000000000000000004e4e3e000000000000000000000000000000000000000000000000003a190629cf477300000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001fb0000000000000000000000000000000000000000000001bd0001a700001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa00a007e5c0d200000000000000000000000000000000000000016900012d0000ca0000b051205a7d2f9595ea00938f3b5ba1f97a85274f20b96c1ddcaa4ed761428ae348befc6718bcb12e63bfaa0044a6417ed600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010020d6bdbf7855d398326f99059ff775485246999027b31979550ca055d398326f99059ff775485246999027b3197955ec303ce1edbebf7e71fc7b350341bb6a6a7a6381c028b46d02ec303ce1edbebf7e71fc7b350341bb6a6a7a638100000000000000000000000000000000000000000000000000000000000000014101bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c00042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0611111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000004e4e3e0000000000a36e5de7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2023-01-18T04:17:05.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	0xdc1383af550d194310f9d54f6df072bedf7632f9f5252049214aab1a894559b2	0x294a4ea0194c305288bd4a78fdf800d95a7163639da5ed261c83e7a95893f931
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	15550	76490101	33	0x413dddce3d0ead2489648e482d192a7758c2b1b4	53841647	56	{“fixFee”:“1000000000000000”,“transferFee”:“79080”,“useAssetFee”:false,“isNativeToken”:false,“receivedAmount”:“79080709”}	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000002652a80000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000001420f5a75c7e7e628e03fcbe8c58cc293f7de8129300000000000000000000000000000000000000000000000000000000000000000000000000000000000003e8000bac75b64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000020f5a75c7e7e628e03fcbe8c58cc293f7de8129300000000000000000000000000000000000000000000000000000000000003087c02520000000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d00000000000000000000000018101ac1d35230f1a3c005e2abaaeb25cae79e7f00000000000000000000000020f5a75c7e7e628e03fcbe8c58cc293f7de8129300000000000000000000000000000000000000000000000000000000048f230d000000000000000000000000000000000000000000000004067818a9bf75935600000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001500000000000000000000000000000000000000001120000e40000ca00001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa51205a7d2f9595ea00938f3b5ba1f97a85274f20b96c1ddcaa4ed761428ae348befc6718bcb12e63bfaa0044a6417ed600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010020d6bdbf788ac76a51cc950d9822d68b83fe1ad97b32cd580d80a06c4eca278ac76a51cc950d9822d68b83fe1ad97b32cd580d1111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000048f230d00000000000000000000000000000000a36e5de7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2023-01-18T08:03:48.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	0xa2ffc873e5ec491c46f17bacd1b7aafe2e35aae76387d0211e90be8198113692	0x8f3a5c3a79639cb1444d79a737590cffa9491ed835b73c52a567ba2ed7d53b76
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	15554	157660186	24	0x413dddce3d0ead2489648e482d192a7758c2b1b4	53886604	137	{“fixFee”:“1000000000000000”,“transferFee”:“157991”,“useAssetFee”:false,“isNativeToken”:false,“receivedAmount”:“157991238”}	0x0000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000002a4050000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000001496dd7d7111d4140769794f5c758b338fc471c1b500000000000000000000000000000000000000000000000000000000000000000000000000000000000004e80015c460b64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000096dd7d7111d4140769794f5c758b338fc471c1b500000000000000000000000000000000000000000000000000000000000004087c0252000000000000000000000000000d15038f8a0362b4ce71d6c879d56bf9fc2884cf000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000000d15038f8a0362b4ce71d6c879d56bf9fc2884cf00000000000000000000000096dd7d7111d4140769794f5c758b338fc471c1b5000000000000000000000000000000000000000000000000000000000965af13000000000000000000000000000000000000000000000008857977e5fd76565800000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002470000000000000000000000000000000000000000000002090001f300001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa00a007e5c0d20000000000000000000000000000000000000001b500017900012a00011051205ab5c56b9db92ba45a0b46a207286cd83c15c9391ddcaa4ed761428ae348befc6718bcb12e63bfaa0064e0286ab2000000000000000000000000da43bfd7ecc6835aa6f1761ced30b986a574c0d200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000010000000000000000000000000d15038f8a0362b4ce71d6c879d56bf9fc2884cf00000000000000000000000000000000000000000000000000000000000000010020d6bdbf782791bca1f2de4661ed88a30c99a7a9449aa8417402a00000000000000000000000000000000000000000000000000000000000000001ee63c1e50088f3c15523544835ff6c738ddb30995339ad57d62791bca1f2de4661ed88a30c99a7a9449aa8417441010d500b1d8e8ef31e21c99d1db9a6444d3adf127000042e1a7d4d0000000000000000000000000000000000000000000000000000000000000000c0611111111254fb6c44bac0bed2854e76f90643097d000000000000000000000000000000000000000000000000000000000965af1300000000000000000000000000000000000000000000000000a36e5de7000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2023-01-18T12:53:36.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	0xcc1476ab5c291ad348bdca9a1d38aaaad28291222be3c8fb56ca3d7caba2f493	0x0c71c9a52faf9fbc672241be1bcc1ea651efb1ea818fa07b8e6b1e699032376d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_arbitrum.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	23	0x0ea568827c249a4f3a84c10b35d45787a6a095633f9350f44e7d73c6d6fa3d24	77926694	10711941	0xd96123fe9881344be9ab63ec054444902dc4d6a4	2023-04-07T09:03:14.000Z	0x07f46ce2b2d4b20e98e1212e858d2ff4f8294c07c0947036457f6bd35ce969fb	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	33	0x2c8d451a7c85d23734c85708eee5fc58fad19dcc38b9be3dd8503c18d284f1d5	77926694	11456209	0xd96123fe9881344be9ab63ec054444902dc4d6a4	2023-04-07T09:03:14.000Z	0x07f46ce2b2d4b20e98e1212e858d2ff4f8294c07c0947036457f6bd35ce969fb	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	29	0x0ff1abaa6ad28cdd9025afd87f91fc63e40510ca5049fc2318f8c717b7d6b6b7	77926694	10704783	0xd96123fe9881344be9ab63ec054444902dc4d6a4	2023-04-07T09:03:14.000Z	0x07f46ce2b2d4b20e98e1212e858d2ff4f8294c07c0947036457f6bd35ce969fb	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_arbitrum.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”:“0x0000017774c6f0af82a621834c846bbbeb982b4f”,“giveAmount”:“677907740841804171”,“takeAmount”:“676573106664808361”,“giveChainId”:“42161”,“receiverDst”:“0x0000017774c6f0af82a621834c846bbbeb982b4f”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1720713699523”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x0000017774c6f0af82a621834c846bbbeb982b4f”,“orderAuthorityAddressDst”:“0x0000017774c6f0af82a621834c846bbbeb982b4f”,“allowedCancelBeneficiarySrc”:“0x”}	19	0xb56df164ed549f51418ccbe74ae07e2d87bc000c8d177e67b812d7f69ba94f1d	0x0101010000753a046410850800000000000000000000000000a99f56e7a7ab6309000000000000000000000000000000000000000000000000000000000000000001	231132794	271271604978713	2024-07-11T16:01:52.000Z	0x	1000000000000000	4850	0x10d21361f9c8f981db5d52f4942ad4e9fbb441a6fbe9c389488883ea35036df7
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x00a6f9c9dc014a6290d877ade8ff3b7e48319a8b”,“giveAmount”:“50043638897882308”,“takeAmount”:“49970016727779576”,“giveChainId”:“42161”,“receiverDst”:“0x00a6f9c9dc014a6290d877ade8ff3b7e48319a8b”,“takeChainId”:“8453”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1720708968069”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x00a6f9c9dc014a6290d877ade8ff3b7e48319a8b”,“orderAuthorityAddressDst”:“0x00a6f9c9dc014a6290d877ade8ff3b7e48319a8b”,“allowedCancelBeneficiarySrc”:“0x”}	3	0x31f92d970e416c49e134dbb1c55359b6102384e3274c25c9940e1d894ad0e8f1	0x0101020000a8e54351b6730000000000000000000000000000f8c87a287787b100000000000000000000000000000000000000000000000000000000000000000001	231113914	20025465745451	2024-07-11T14:43:03.000Z	0x	1000000000000000	4851	0x83b729b9fa8b8d425c1bb398f02fb312b146196dc2319eba5ed3708e602d8b05
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x00c14100a7bac24d5887ced22d297c3753103ec5”,“giveAmount”:“226871547553457”,“takeAmount”:“99920016000000”,“giveChainId”:“42161”,“receiverDst”:“0x00c14100a7bac24d5887ced22d297c3753103ec5”,“takeChainId”:“8453”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1720668394654”,“giveTokenAddress”:“0x0000000000000000000000000000000000000000”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x00c14100a7bac24d5887ced22d297c3753103ec5”,“orderAuthorityAddressDst”:“0x00c14100a7bac24d5887ced22d297c3753103ec5”,“allowedCancelBeneficiarySrc”:“0x”}	7	0x8c020b6b08f4f2b7302da36d06abb8852a686e057dc2442f4df1ee27f547fdc4	0x0101010000a419e7136173000000000000000000000000000000440f71e05a0000000000000000000000000000000000000000000000000000000000000000000000	230952092	90784932994	2024-07-11T03:26:49.000Z	0x	1000000000000000	4850	0x0c65490bbb633bdb3f71e71e9bfbd1edebe87ba444405f94539db3fc128573d9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_arbitrum.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”:“0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251”,“giveAmount”:“3233568”,“takeAmount”:“7918585769903910”,“giveChainId”:“42161”,“receiverDst”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“takeChainId”:“56”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“960”,“giveTokenAddress”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“orderAuthorityAddressDst”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“allowedCancelBeneficiarySrc”:“0x”}	14	0x54d1076bbd11da85bee863af1ed7e797aea2608c48307058643f700242db7449	110228997	1293	2023-07-11T20:47:06.000Z	0x	1000000000000000	4850	0xbc830cef9b879ce6891ae91097757c3da7004bf6e885ac6ccf1c0485671ba8d1
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251”,“giveAmount”:“3524668”,“takeAmount”:“4025898338928208759”,“giveChainId”:“42161”,“receiverDst”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“takeChainId”:“137”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“961”,“giveTokenAddress”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“orderAuthorityAddressDst”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“allowedCancelBeneficiarySrc”:“0x”}	14	0xeb362e2d81c6b8e4a5e6da7a341e16c416416e6366d6460521a25e2bfe4cca90	110229308	1410	2023-07-11T20:48:26.000Z	0x	1000000000000000	4850	0x89e7ba72d6d13bca96803f7604512ea040eb4e0a67ebab504539db5551b5b031
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251”,“giveAmount”:“3620594”,“takeAmount”:“224958230190283674”,“giveChainId”:“42161”,“receiverDst”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“takeChainId”:“43114”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“959”,“giveTokenAddress”:“0xff970a61a04b1ca14834a43f5de4533ebddb5cc8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“orderAuthorityAddressDst”:“0x661afd8c9c33faeadd0fc166a3a8bbef8a3d0035”,“allowedCancelBeneficiarySrc”:“0x”}	16	0x16608323d378a8bb96be73231009cd01dcdc6a96bcc2cb023a58264166dfd9ec	110228340	1448	2023-07-11T20:44:18.000Z	0x	1000000000000000	4850	0x08bc36cbe9e17b4960dc6b9d7f59911861c6489f3e28b1d3fe99c85538e3b636

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_arbitrum.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