debridge_v1_bsc

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	73	15370915	115792089237316195423570985008687907853269984665640564039457584007913129639935	0xc88f0aa5a8806945398ad10a5e8dd2805a720e1c8519e0a8b50af7a1b87d1f79	2022-02-18T18:33:11.000Z	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	0x0000000000004946c0e9f43f4dee607b0ef1fa1c	56	0xf0b99a0d7e431cadd4dc017ab48fe1bada8499ca694234ccb1ccfc191a7b31d3	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	87	15366256	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x3262c437e811f5fd71b84129c7527632f0b95d82657d0da4038a83d3a0e1b730	2022-02-18T14:40:02.000Z	0x5a41f637c3f7553dba6ddc2d3ca92641096577ea	0x5a41f637c3f7553dba6ddc2d3ca92641096577ea	56	0xfc3b45b5c1149f0e68f49cbe85b4af1a1bf680a94bab1a6338f9ff722abb24fb	10000
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	181	15366364	115792089237316195423570985008687907853269984665640564039457584007913129639935	0x353cb1900ca590fb15b7cf85b56a1f063328acb1fa5d3fb0d1594cd0431b5c3e	2022-02-18T14:45:26.000Z	0x5ac52ee5b2a633895292ff6d8a89bb9190451587	0x5ac52ee5b2a633895292ff6d8a89bb9190451587	56	0x2015e68bf8cd72f5a31ab5cba755b9119840d8fd50d1d906ce45ad93cc42b09b	10000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_bsc.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	28927	0	220	0xef4fb24ad0916217251f553c0596f8edc630eb66	31841493	1	{“fixFee”:“5000000000000000”,“transferFee”:“0”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“5000000000000000”}	0x000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001246abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b0000000000000000000000000000000000000000000000000000000000000006cb353b8bb1c5b1d895af138e00f24f1b68e7f4ebc5dc14b7537572d81c2fedbedad4ed20dabb1227fe11f21460affa596e42274c4e03c648ccab2381995e9c0899b241b9698a93771b7d6f788651205717cc599959ef320cb0a16a272a109eaa683ff772d721b9309fb44f1873e8e0f0930a8acd632a2b8b3e927a9d6126492889f8bbda921a6028db63f174f668b077bb0744a1322098b48924cab034eb8486a2a23aea7c2d2b63b3b4763fc60fbbc2104836c06d604a02c7fe238ca3b8535b00000000000000000000000000000000000000000000000000000000	0xf93982a76d8e8739fd39d418ca95d6d90f344b45e05ad231c2069a6a0eef7ea1	2023-09-18T05:34:19.000Z	0xe7351fd770a37282b91d153ee690b63579d6dd7f	0x8032d62af4f18e7c3804eb608a44e2b4b2b6fa81c067d70c276ed997d8cdd98b	0x626eabe0b83eaacb14fef0809b18c887c534031f8c3c11abf8ca7bd5dc57c77a
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	28928	0	182	0xef4fb24ad0916217251f553c0596f8edc630eb66	31842878	137	{“fixFee”:“5000000000000000”,“transferFee”:“193551013342”,“useAssetFee”:true,“isNativeToken”:true,“receivedAmount”:“5193551013342854”}	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000afd9ce113c000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014555ce236c0220695b68341bc48c68d52210cc35b00000000000000000000000000000000000000000000000000000000000000000000000000000000000001846abd4ea70000000000000000000000000000000000000000000000000000000000000040000000000000000000000000555ce236c0220695b68341bc48c68d52210cc35b000000000000000000000000000000000000000000000000000000000000000948ea725a2c02aea3c36daf5f168ae09796c47fdf94c37a6a7034090a8f4660624094fbbeb048b287a8595865273833c7ff73fae927c6cb5ba10cb29cfec33f445c121106f321625aa2fd361dd8def286c2e424f243d9fb0b0da03cf18b291515291f4de69a2093392cd477ba1895a3975a364adb6bf9bc3be01dd9d968a25e822abab515189015eba953f958c309e337045aa113d0a9123271513bb329309639edaef46ea126f999572e9ad8623d4943b267c8b6d34e43511f312a780ca8b8feb4350900d22f8fa1aaa6e42b62ad5eb51d9c07a67ff58c503262f7c3aae580b880ac1ab63818f62f7ba8ad0b07abc86d83905ad057f9e773c95af1548971d4ca41d127cc80ae4f4bd50e162ad8834a887041e4cb41bb84aca6d8f5fdb15bbf9600000000000000000000000000000000000000000000000000000000	0xf93982a76d8e8739fd39d418ca95d6d90f344b45e05ad231c2069a6a0eef7ea1	2023-09-18T06:44:00.000Z	0xe7351fd770a37282b91d153ee690b63579d6dd7f	0x1326f0927f85b8d030f49e787d816a3bc63dfea0c910c403c9544d8535d70a1a	0xeaf2b5717c868ee67385e0d8ef4d050650272ab4abf7ca8f62295717920145d7
0x43de2d77bf8027e25dbd179b491e8d64f38398aa	false	28929	21273078	237	0x413dddce3d0ead2489648e482d192a7758c2b1b4	31845495	137	{“fixFee”:“5000000000000000”,“transferFee”:“21703”,“useAssetFee”:false,“isNativeToken”:false,“receivedAmount”:“21703468”}	0x00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000063c6f0000000000000000000000000000000000000000000000000000000000000030000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000014a34eaaf454843fa2225c5978a675aae9b89a2e860000000000000000000000000000000000000000000000000000000000000000000000000000000000000e68003626b88d80ff0a00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000e1200413dddce3d0ead2489648e482d192a7758c2b1b4000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000004a4b64120b70000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000a34eaaf454843fa2225c5978a675aae9b89a2e8600000000000000000000000000000000000000000000000000000000000003c87c025200000000000000000000000000ce9cc1fa6df298854f77e92042fd2a3e7fb27eff000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001800000000000000000000000001ddcaa4ed761428ae348befc6718bcb12e63bfaa000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f000000000000000000000000ce9cc1fa6df298854f77e92042fd2a3e7fb27eff000000000000000000000000a5a1edd75e8b98be70c8c2f131427d0490b27f6900000000000000000000000000000000000000000000000000000000014488d70000000000000000000000000000000000000000000000000000000001356f6300000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002090000000000000000000000000000000000000000000000000001cb00001a0020d6bdbf781ddcaa4ed761428ae348befc6718bcb12e63bfaa00a007e5c0d200000000000000000000000000000000000000000000018d00012a00011051205ab5c56b9db92ba45a0b46a207286cd83c15c9391ddcaa4ed761428ae348befc6718bcb12e63bfaa0064e0286ab2000000000000000000000000da43bfd7ecc6835aa6f1761ced30b986a574c0d20000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000ce9cc1fa6df298854f77e92042fd2a3e7fb27eff00000000000000000000000000000000000000000000000000000000000000010020d6bdbf788f3cf7ad23cd3cadbd9735aff958023239c6a06302a00000000000000000000000000000000000000000000000000000000000000001ee63c1e581254aa3a898071d6a2da0db11da73b02b4646078f8f3cf7ad23cd3cadbd9735aff958023239c6a0631111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000014488d70000000000000000000000000000000000000000000000a36e5de700000000000000000000000000000000000000000000000000a5a1edd75e8b98be70c8c2f131427d0490b27f69000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008c47040de940000000000000000000000000000000000000000000000000000000000000023000000000000000000000000a34eaaf454843fa2225c5978a675aae9b89a2e86000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f0000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf12700000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa84174000000000000000000000000000000000000000000000000000000000000010000000000000000000000000000000000000000000000000000000000000004e0000000000000000000000000000000000000000000000000000000006508176438ed17390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000cd353f79d9fade311fc3119b841e1f456b54e858000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000002c0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000013c003e000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000213dab40a6607ad3e000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000bbc607d84ee5836c802b8b98392c8ead8b9cda5d00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000065081764000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000020000000000000000000000000c2132d05d31c914a87c6611c10748aeb04b58e8f00000000000000000000000000000000000000000000000000000000000000200000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf127038ed17390000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c0000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000008000000000000000000000000cd353f79d9fade311fc3119b841e1f456b54e858000000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000018000000000000000000000000000000000000000000000000000000000000001c000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000240000000000000000000000000000000000000000000000000000000000000028000000000000000000000000000000000000000000000000000000000000002c00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000001122416d39b577a3000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000989a45000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000000a00000000000000000000000000000000000000000000000000000000000000020000000000000000000000000bbc607d84ee5836c802b8b98392c8ead8b9cda5d000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000650817640000000000000000000000000000000000000000000000000000000000000020000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000000000000000000000000000000000000000200000000000000000000000000d500b1d8e8ef31e21c99d1db9a6444d3adf127000000000000000000000000000000000000000000000000000000000000000200000000000000000000000002791bca1f2de4661ed88a30c99a7a9449aa841740000000000000000000000000000000000000000000000000000000000000000000000000000	0x473d5176dee4131db96e7b596120a4a3710d38e620ca2d6d3e3f12a059a83416	2023-09-18T08:55:08.000Z	0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251	0x6af50abf11d3b9817ad821c37c4d4608f74410623bc6a951d7b9cfa941d40624	0x45570b1091a8126ed767e0465d4028543ada394fb474f9493d3c9fb03b075631

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_bsc.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	226	0x884ed9f9bc82c12bdbdc878bc9f20c09c500e09bd875950239648352f0e27c60	27940110	42339428230383848	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-05-05T08:58:14.000Z	0x90739d142fe07597076b89d10f0195641eb94e5edc74b5c522ca591c23a4195c	0x2170ed0880ac9a755fd29b2688956bd959f933f8
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	232	0x25fedc0412594d5e79ca8cc285b8512b3f805189eee877ba6a828266212002ca	27940110	3972174300239885328	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-05-05T08:58:14.000Z	0x90739d142fe07597076b89d10f0195641eb94e5edc74b5c522ca591c23a4195c	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	228	0x2c971cb000adb3a5b374c6bef4b478f9dda56614b5add456013c4acad6e0bbe0	27940110	172886008923600000000	0x555ce236c0220695b68341bc48c68d52210cc35b	2023-05-05T08:58:14.000Z	0x90739d142fe07597076b89d10f0195641eb94e5edc74b5c522ca591c23a4195c	0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_bsc.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”:“0x3e9e39194a60eb7bf9aea5a672c67c516f6fd47a”,“giveAmount”:“153340245192726086”,“takeAmount”:“152298686732561970”,“giveChainId”:“56”,“receiverDst”:“0x3e9e39194a60eb7bf9aea5a672c67c516f6fd47a”,“takeChainId”:“42161”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1701416935083”,“giveTokenAddress”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x3e9e39194a60eb7bf9aea5a672c67c516f6fd47a”,“orderAuthorityAddressDst”:“0x3e9e39194a60eb7bf9aea5a672c67c516f6fd47a”,“allowedCancelBeneficiarySrc”:“0x”}	210	0x5d5239a055f4f0d1b4468e6323656cd27036c208fe538b07d1b32e80af45fc7b	0x01010000008898c2c16de01f0000000000000000000000000032ee7342d9121d020000000000000000000000000000000000000000000000000000000000000000	33967924	61360642334024	2023-12-01T07:50:00.000Z	0x	5000000000000000	0	0x9111910052c477259aad83ad58e4cfe7afcc6d3f6ea761f5cd7cf2de661c02ae
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0xebd5f0763d46a9e9f9c82404b6ad3ee0788fd662”,“giveAmount”:“1041002148513600000000”,“takeAmount”:“1041002149”,“giveChainId”:“56”,“receiverDst”:“0xebd5f0763d46a9e9f9c82404b6ad3ee0788fd662”,“takeChainId”:“10”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1701397718675”,“giveTokenAddress”:“0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d”,“takeTokenAddress”:“0x7f5c764cbc14f9669b88837ca1490cca17c31607”,“givePatchAuthoritySrc”:“0xebd5f0763d46a9e9f9c82404b6ad3ee0788fd662”,“orderAuthorityAddressDst”:“0xebd5f0763d46a9e9f9c82404b6ad3ee0788fd662”,“allowedCancelBeneficiarySrc”:“0x”}	40	0xfc6421593668462ac8cf0bf18e6b4edddcc556e2e26bcac62981722c0d865c18	0x010100000000b07fd24d5ac206000000000000000000000000a56e0c3e000000000000000000000000000000000000000000000000000000000000000000000000	33961527	416567486400000000	2023-12-01T02:28:57.000Z	0x	5000000000000000	3842	0x3e15b38581aef9545bf29a04bdf10e77b5190c1df2cb3e2a142f31e8fff91fd7
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x6891e5ad2acdaf9c5a1aa362e6cf4c32f13389ca”,“giveAmount”:“10881160516292138”,“takeAmount”:“9683723833734504”,“giveChainId”:“56”,“receiverDst”:“0x6891e5ad2acdaf9c5a1aa362e6cf4c32f13389ca”,“takeChainId”:“59144”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1701426004980”,“giveTokenAddress”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x6891e5ad2acdaf9c5a1aa362e6cf4c32f13389ca”,“orderAuthorityAddressDst”:“0x6891e5ad2acdaf9c5a1aa362e6cf4c32f13389ca”,“allowedCancelBeneficiarySrc”:“0x”}	176	0x14f9cc2a32b990461324bd75544b5bd761b7c2b2e677948a4ad588aa7e2fded4	0x0101000000ea8f48b773c32600000000000000000000000000687536a74b6722000000000000000000000000000000000000000000000000000000000000000000	33970924	4354205888872	2023-12-01T10:20:14.000Z	0x	5000000000000000	4350	0xee894216b0b835bcf45c84a8696e990c0bee13a62569e96fc60d51f2569137e3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.debridge_v1_bsc.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”:“47021930903182642”,“takeAmount”:“37059349693162237”,“giveChainId”:“56”,“receiverDst”:“0x702e8e75651b3776c90391d5571331b0889e5463”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1409”,“giveTokenAddress”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x702e8e75651b3776c90391d5571331b0889e5463”,“orderAuthorityAddressDst”:“0x702e8e75651b3776c90391d5571331b0889e5463”,“allowedCancelBeneficiarySrc”:“0x”}	124	0x34bffb083ff37225a12daabbc6199e917012818d3da1d58547bcb273b1335d8b	29098421	18816298880825	2023-06-14T16:01:01.000Z	0x	5000000000000000	0	0x447bf5413edea230a440d43d313bbdeac6fd7b71b1225e60f9738bae2977d0fc
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251”,“giveAmount”:“16882666023093152”,“takeAmount”:“11463165486723276”,“giveChainId”:“56”,“receiverDst”:“0x73183ec7847c17bbac2fdc093a68692fde702049”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1403”,“giveTokenAddress”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x73183ec7847c17bbac2fdc093a68692fde702049”,“orderAuthorityAddressDst”:“0x73183ec7847c17bbac2fdc093a68692fde702049”,“allowedCancelBeneficiarySrc”:“0x”}	41	0xdfb977a1aeaeaa043d15b9f53b07488fa62a425ae31896cff097049f98697679	29086823	6755768716723	2023-06-14T06:19:58.000Z	0x	5000000000000000	0	0x39330f2c4b56ee8d28752cbe91dd839b35312a4ff17a30670d0d68a5e583e6e0
0xef4fb24ad0916217251f553c0596f8edc630eb66	false	{“makerSrc”:“0x663dc15d3c1ac63ff12e45ab68fea3f0a883c251”,“giveAmount”:“244426433219848947”,“takeAmount”:“236576054604855133”,“giveChainId”:“56”,“receiverDst”:“0x204bf175e4e7065bb272aee97704fc34390fbaa6”,“takeChainId”:“1”,“externalCall”:“0x”,“allowedTakerDst”:“0x”,“makerOrderNonce”:“1408”,“giveTokenAddress”:“0x2170ed0880ac9a755fd29b2688956bd959f933f8”,“takeTokenAddress”:“0x0000000000000000000000000000000000000000”,“givePatchAuthoritySrc”:“0x204bf175e4e7065bb272aee97704fc34390fbaa6”,“orderAuthorityAddressDst”:“0x204bf175e4e7065bb272aee97704fc34390fbaa6”,“allowedCancelBeneficiarySrc”:“0x”}	328	0x438876fce8686fc5d3d6ab6621d28edaf885266e6473ca64b2764ba2d61575bd	29096816	98005787177164	2023-06-14T14:40:32.000Z	0xdf9c09f9332669f6a5b06df53a342a66d7ce76670000000000000000000000000000000000000000000000000001bdadc0a733ff	5000000000000000	4844	0xd89ced6c68ea3ee92912eb8979d00c9932391a360dac04cea8582a2559ba32f4

Example Query

Query with partition filter

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